FAA To ICAO Linking Models

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

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#LINKS
• SK = 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.