Skip to content

Registered aircraft · 465

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:91-13-10-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-13-10-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:91-13-10-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-13-10-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:91-13-10-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-13-10-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N257AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1999 · S/N 29605 N257FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67536 N258FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67535 N259FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67534 N260FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67533 N261FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67532 N262FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67531 N263FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67530 N263SGAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 29263 N264FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66869 N265FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66868 N266FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66867 N267FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66866 N267JRKnight Sky II LLC · Miami, FLBuilt 1986 · S/N 23402 N268FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66865 N269CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 25586 N269FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66864 N270FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66249 N271FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66250 N272FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66242 N273FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66243 N274FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66244 N275FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66245 N276FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66251 N277FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66246 N278FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66247 N279FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66252 N280FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66253 N281FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66254 N282FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63143 N283CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40566 N283FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63142 N284FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63141 N285FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63140 N286FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63139 N287FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63138 N288FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63137 N289FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63136 N290CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40564 N290FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63135 N291FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63134 N292FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63133 N293FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63132 N294FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63131 N295FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63130 N296FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64056 N298CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40565 N299FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 64059 N301CRCobra Aviation Services LLC · Oklahoma City, OKS/N 30331 N303TWLogistic Air Inc · Reno, NVS/N 20116

Back to AD 91-13-10 R1