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.

N297NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2778 N298AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-298 N298CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40565 N298NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2800 N299FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 64059 N299NVAllegiant Air LLC · Las Vegas, NVBuilt 2011 · S/N 4870 N300BFBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1943 · S/N 26744 N300MFMissionary Flights And Services Inc DBA · Fort Pierce, FLBuilt 1944 · S/N 32961 N301CRCobra Aviation Services LLC · Oklahoma City, OKS/N 30331 N301KHAeko Kula LLC DBA · Honolulu, HIBuilt 1995 · S/N 27904 N301NWAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33342 N301PAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31255 N302FLBank Of Utah Trustee · Salt Lake City, UTS/N 30072 N303KHNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1999 · S/N 25606 N303MPAir Cargo Services LLC · Miami, FLS/N 390 N303TWLogistic Air Inc · Reno, NVS/N 20116 N3047VTatonduk Outfitters Ltd · Fairbanks, AKS/N 44658 N304AEBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 340B-304 N304AGBank Of Utah Trustee · Salt Lake City, UTS/N 340B-418 N304WWWin Win Aviation Inc · Wake Forest, NCS/N SH3413 N30501Dutchess Community College · Poughkeepsie, NYS/N 383 N305LRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 305 N305NXAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31253 N306NYAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33343 N306PBAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31257 N307ACBank Of Utah Trustee · Salt Lake City, UTS/N 30700 N307AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-307 N307AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1997 · S/N 28725 N309DEDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 29634 N309HGConstruction Helicopters LLC · Howell, MIS/N 309 N309PCAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31258 N30HEClassic Aircraft Aviation Museum Inc · Hillsboro, ORBuilt 1967 · S/N 51 N30LXN492a LLC · Goodyear, AZBuilt 1984 · S/N 438 N30WRInfotech Management Inc · San Diego, CANon-citizen corporation, flight hours not reportedBuilt 1983 · S/N 380 N31019Save A Connie Inc DBA · Kansas City, MOBuilt 1974 · S/N 193B-1066 N3103SSale Reported · Salt Lake City, UTSale reported, pending cancellationS/N 1313 N310DEDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 29665 N311AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25316 N311GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1995 · S/N 26316 N312AACargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22315 N313AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-313 N313AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1990 · S/N 24930 N313MSEpic Rise LLC · Tulsa, OKS/N 372 N313XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25313 N314PDAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31259 N314XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25314 N3159GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 35119 N315PEWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31261 N3160GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 32277 N316PFAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31262

Back to AD 74-08-09 R2