Skip to content

Registered aircraft · 45

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-15-01') 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-15-01') 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-15-01')
    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-15-01')
  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-15-01')
  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-15-01')
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.

N597SBInternational Air Services Inc Trustee · Carson City, NVBuilt 1997 · S/N 415 N701FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 1680 N702FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 1681 N703FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 1686 N705FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 1736 N705SVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 1038 N706FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 1739 N707FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 1741 N708FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 1744 N708SVJah2022a Atr72 Msn 1092 LLC · Dallas, TXBuilt 2013 · S/N 1092 N709FEFederal Express Corporation · Memphis, TNBuilt 2023 · S/N 1750 N710FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 1753 N711FEFederal Express Corp · Memphis, TNS/N 1755 N712FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 1758 N713FEFederal Express Corp · Memphis, TNS/N 1766 N714FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 1767 N800FXFederal Express Corp · Memphis, TNS/N 336 N801FXFederal Express Corp · Memphis, TNS/N 338 N802FXFederal Express Corp · Memphis, TNS/N 344 N803FXFederal Express Corp · Memphis, TNS/N 362 N804FXFederal Express Corp · Memphis, TNS/N 370 N805FXFederal Express Corp · Memphis, TNS/N 372 N806FXFederal Express Corp · Memphis, TNS/N 375 N807FXFederal Express Corp · Memphis, TNS/N 383 N810FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 220 N811FXFederal Express Corp · Memphis, TNS/N 283 N812FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 404 N816FXFederal Express Corp · Memphis, TNS/N 347 N819FXFederal Express Corp · Memphis, TNBuilt 1993 · S/N 359 N820FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 248 N821FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 253 N830FETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 1239 N832FEFederal Express Corp · Memphis, TNS/N 1472 N909FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 275 N910FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 277 N912FXFederal Express Corp · Memphis, TNBuilt 1987 · S/N 047 N913FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 250 N914FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 293 N915FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 269 N916FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 314 N917FXFederal Express Corp · Memphis, TNBuilt 1993 · S/N 354 N918FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 262 N919FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 266 N920FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 325 N921FXFederal Express Corp · Memphis, TNBuilt 1992 · S/N 319

Back to AD 91-15-01