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.

N349CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26996 N349NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 417 N349PHBam Leasing LLC · California, MDBuilt 1997 · S/N 486 N349TABering Air Inc · Nome, AKBuilt 1986 · S/N 349 N34HGUnited States Government · Fort Belvoir, VAS/N 34 N350NADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 418 N3518JJetran LLC · Horseshoe Bay, TXS/N 35108 N351AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B445 N351CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25201 N351FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 1955 · S/N 279 N351NWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 766 N351PHBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 490 N351TATrans Executive Airlines Of Hawaii Inc · Honolulu, HIBuilt 1989 · S/N SH3759 N35204United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30576 N35236United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28801 N35260United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30855 N35271United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31589 N352CARyan Air Inc · Anchorage, AKBuilt 1981 · S/N 190 N352CJAviation Inventory Resources Inc · Alvarado, TXBuilt 1993 · S/N 340B-352 N352NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 778 N352PSWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33256 N353ASAersale Inc · Coral Gables, FLS/N 553 N353AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25198 N353MMMartin Aviation LLC · Warren, NJBuilt 1944 · S/N 13541 N353NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 786 N353PAAersale Inc · Coral Gables, FLS/N 20622 N353SABank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 340B-351 N354NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 801 N354PTAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31275 N355CLRegistration Pending · Statesville, NCRegistration pendingS/N 340B-355 N355NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 807 N355PUAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 33348 N356BRBdp Airways LLC · Dover, DEBuilt 1982 · S/N 356 N356KDAtares Funding LLC · Miami Beach, FLBuilt 1994 · S/N 26356 N356NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 818 N357DCAwas 3896 Trust · Wilmington, DES/N 3896 N357NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 830 N357PVWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31277 N358CYBondio LLC · Great Neck, NYS/N 358 N358NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 832 N358PWWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33349 N359AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24036 N359NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 846 N359PHBighorn Airways Inc · Sheridan, WYBuilt 1998 · S/N 514 N359PXAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31280 N360ABAcc Integrated Services Inc · Milwaukee, WIBuilt 1989 · S/N SH3756 N360NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 0903 N360PHUmb Bank Na Trustee · Salt Lake City, UTBuilt 1998 · S/N 515 N360WANorthern Air Cargo LLC · Anchorage, AKBuilt 1987 · S/N 23553 N361CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1994 · S/N 340B-361

Back to AD 74-08-09 R2