Skip to content

Registered aircraft · 2,912

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

N273UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48574 N274FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66244 N274NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3079 N274UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48575 N275FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66245 N275NVSunrise Asset Management LLC · Las Vegas, NVS/N 2807 N275UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48774 N276FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66251 N276GXFalcon Msn 2695 Trust · Wilmington, DEBuilt 2006 · S/N 2695 N276NVAllegiant Air LLC · Las Vegas, NVBuilt 2019 · S/N 8671 N276UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48579 N27722United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28789 N27724United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28791 N27733United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28800 N27734United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28949 N277FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66246 N277NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3205 N278FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66247 N278GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1954 N278NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4253 N278UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48577 N279FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66252 N279NVSunrise Asset Management LLC · Las Vegas, NVS/N 5250 N27XJPhoenix Air Group Inc · Cartersville, GABuilt 1985 · S/N 340A-027 N2805JAmerican Flight Museum Inc · Topeka, KSBuilt 1944 · S/N 20835 N280FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66253 N280NVDustland LLC · Las Vegas, NVS/N 5320 N2819WDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21057 N281AVAircol 14 Trust · Wilmington, DEBuilt 2010 · S/N 4281 N281FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66254 N281FLInternational Trading Co Of Yukon · Oklahoma City, OKBuilt 1978 · S/N 21455 N281GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2830 N281NVDustland LLC · Las Vegas, NVS/N 5381 N281UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48538 N282FRockland Aerospace Inc · Crofton, MDBuilt 1959 · S/N 1084 N282FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63143 N282GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2851 N282NVSunrise Asset Management LLC · Las Vegas, NVS/N 2875 N28341Delta Air Lines Inc · Atlanta, GABuilt 1940 · S/N 3278 N283CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40566 N283FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63142 N283NVSunrise Asset Management LLC · Las Vegas, NVS/N 2920 N284AVAircol 16 · Wilmington, DEBuilt 2010 · S/N 4284 N284FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63141 N284NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2012 · S/N 5045 N284UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48541 N285FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63140 N285NVAllegiant Air LLC · Las Vegas, NVBuilt 2012 · S/N 5067 N286AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-286 N286FRockland Aerospace Inc · Crofton, MDBuilt 1960 · S/N 1146

Back to AD 74-08-09 R2