Registered aircraft · 4,274

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:2009-21-10-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-21-10-R1') 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:2009-21-10-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-21-10-R1')
  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:2009-21-10-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-21-10-R1')
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.

N904AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7613 N904ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29506 N904ARUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 33097 N904CETatonduk Outfitters Limited · Fairbanks, AKBuilt 1967 · S/N 47040 N904DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32008 N904NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33317 N905ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29507 N905AUBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7700 N905DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32009 N905JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5854 N905LPChateau Aviation LLC · Wilmington, DEBuilt 1997 · S/N 1321 N905NANational Aeronautics And Space Administration · Houston, TXBuilt 1970 · S/N 20107 N905NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31156 N906AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7651 N906ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29508 N906DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64879 N906NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31155 N907AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7732 N907ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29509 N907DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32010 N907JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5865 N907NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31158 N908AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7775 N908ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29510 N908DNDelta Air Lines Inc · Atlanta, GAS/N 64881 N908JTValiair Lc Trustee · Casper, WYBuilt 1990 · S/N 1145 N908NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31157 N909AMWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7756 N909ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29511 N909DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64880 N909NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31159 N90RGRobtoria Aircraft Leasing LLC · Wilmington, DEBuilt 2000 · S/N 1410 N90VLBank Of Utah Trustee · Salt Lake City, UTS/N 39091 N910AFAfh Aviation LLC · Mineola, NYBuilt 1997 · S/N 1312 N910ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29512 N910AUWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7876 N910DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32011 N910FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25054 N910FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 1781 N910NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 31160 N910UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67980 N9113DHeikkila Glenn R · Rockland, MAS/N 47577 N911DQDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64882 N912ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29513 N912DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64883 N912NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33319 N912UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67981 N912UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6264 N913ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29514 N913DECorsair Two LLC · Hillsboro, ORBuilt 1993 · S/N 49956

Back to AD 2009-21-10 R1