Skip to content

Registered aircraft · 47

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:2014-09-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-09-06') 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:2014-09-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-09-06')
  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:2014-09-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-09-06')
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.

N707GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2022 · S/N 67992 N708GTUmb Bank & Trust Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67993 N709GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 67994 N710GTTitan Aviation Leasing Ltd - Americas Inc · Purchase, NYBuilt 2023 · S/N 67995 N712GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 69787 N722GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 69788 N760GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 68186 N761GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 69033 N773CKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 66083 N774CKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 66084 N775CKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 66087 N776CKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2021 · S/N 66815 N791CANational Air Cargo Group Inc DBA · Orlando, FLBuilt 2026 · S/N 70547 N792CANational Air Cargo Group Inc · Orlando, FLBuilt 2026 · S/N 70548 N795CANational Air Cargo Group Inc · Orlando, FLBuilt 2026 · S/N 70549 N798CANational Air Cargo Group Inc · Orlando, FLBuilt 2026 · S/N 70550 N835FDBoeing Co · Renton, WAS/N 70865 N836FDBoeing Co · Renton, WAS/N 70864 N837FDFederal Express Corp · Memphis, TNBuilt 2026 · S/N 70863 N841FDFederal Express Corp · Memphis, TNBuilt 2025 · S/N 66267 N845FDFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66255 N846FDFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66256 N847FDFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66257 N848FDFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66258 N849FDFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66259 N860FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 37731 N865FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 40671 N866FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 40672 N867FDFederal Express Corp · Memphis, TNBuilt 2021 · S/N 40673 N870FDFederal Express Corp · Memphis, TNBuilt 2021 · S/N 40676 N871FDFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66260 N872FDFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66262 N873FDFederal Express Corp · Memphis, TNBuilt 2021 · S/N 40679 N874FDFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66263 N875FDFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66264 N876FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 40682 N877FDFederal Express Corp · Memphis, TNBuilt 2018 · S/N 40683 N878FDFederal Express Corp · Memphis, TNBuilt 2017 · S/N 40684 N879FDFederal Express Corp · Memphis, TNBuilt 2018 · S/N 40685 N888FDFederal Express Corp · Memphis, TNBuilt 2017 · S/N 42704 N891FDFederal Express Corp · Memphis, TNBuilt 2018 · S/N 41440 N893FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 41736 N894FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 41737 N896FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 41750 N897FDFederal Express Corp · Memphis, TNBuilt 2017 · S/N 42705 N898FDFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66265 N899FDFederal Express Corporation · Memphis, TNBuilt 2025 · S/N 66266

Back to AD 2014-09-06