FAA To ICAO Link Models
Data models used to represent FAA-to-ICAO aircraft type linkage results, including both the structured LLM worker output schema and the persisted registry linkage entity. These models define the canonical structure used by linking pipelines to map FAA manufacturer-model and serial identifiers to normalized ICAO aircraft type designators, enabling cross-dataset registry normalization, search indexing, and aircraft type resolution workflows across the platform.
FAAICAOLinkRequestModel
Schema defining the structured output returned by the LLM linking worker. The worker analyzes FAA manufacturer-model and serial metadata and returns the predicted ICAO aircraft type designator along with a confidence score. This model is intentionally minimal to enforce deterministic parsing of the worker response before persistence.
- type_designator — Predicted ICAO aircraft type designator (2–4 alphanumeric)
- confidence — Model confidence score between 0 and 1
FAAICAOLinkModel
Purpose
Represents a persisted FAA registry linkage record mapping
MFR_MDL_CODE + Serial to an ICAO aircraft type.
Fields
- mfr_mdl_code — FAA manufacturer-model code
- serial — Aircraft serial number
- type_designator — ICAO aircraft type code
- manufacturer — Optional resolved manufacturer name
- model — Optional resolved model name
- confidence — Match confidence score
Validation
ICAO codes are validated to ensure they are 2–4 uppercase alphanumeric characters. Invalid codes raise a validation error prior to persistence.
Primary Keys
PK = FAA#LINKSSK = MFR_MDL_CODE#{code}#SN#{serial}
Global Secondary Index
GSI1PK = ICAO#{type_designator}GSI1SK = MFR_MDL_CODE#{code}#SN#{serial}
This index enables reverse lookup by ICAO type, merging FAA registry data with ICAO aircraft metadata queries.