Skip to content

Registered aircraft · 2,913

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.

N444HECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1987 · S/N 23800 N444UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 824 N444YVWells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 444 N44503Frontera Flight Holdings Inc · Dover, DEBuilt 1989 · S/N 49797 N445UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 826 N446AVAircol 11 · Wilmington, DEBuilt 2009 · S/N 4046 N446UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 834 N447UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 836 N448UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 842 N449UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 851 N449YVBank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 449 N44HBBartowjets LLC · Wilmington, DEBuilt 1984 · S/N 437 N450AMid Atlantic Air Museum · Reading, PABuilt 1952 · S/N 14141 N451AVAircol 12 · Wilmington, DEBuilt 2009 · S/N 4051 N451UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 865 N452UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 0955 N453FEFederal Express Corp · Memphis, TNBuilt 1983 · S/N 267 N453UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1001 N454AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5454 N454FEFederal Express Corp · Memphis, TNBuilt 1983 · S/N 278 N454PCOmega Air Inc · San Antonio, TXS/N 18839 N454UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1104 N455CMCargo Aircraft Management Inc · Wilmington, OHS/N 26983 N455UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1105 N456BEBillionaire Inc · St Petersburg, FLBuilt 1981 · S/N 335 N456UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1128 N457AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 25448 N457JCExceptional Aircrafts LLC · Mcallen, TXS/N 457 N457UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1146 N45838United Airlines Inc · Chicago, ILS/N 397 N458CLBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 340B-458 N458UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1163 N459UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1192 N460UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1248 N461ARSolo Energy Drink Inc · Miramar, FLS/N 384 N461MSheppard Harold Jr DBA · Riverton, WYS/N 14227 N461UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1266 N462CMN462cm Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 26985 N462UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1272 N463UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1282 N464MCAtlas Air Inc · Purchase, NYBuilt 1992 · S/N 26341 N464UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1290 N465MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24784 N465TWSierra American Corp · Wilmington, DES/N 23465 N465UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1341 N466UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1343 N467AMBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 441 N467TWSierra American Corp · Wilmington, DES/N 23466 N467UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1359 N468UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1363

Back to AD 74-08-09 R2