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.

N806DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31914 N806JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5302 N806NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29561 N806TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1992 · S/N 27081 N806UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0788 N806WA53251 LLC · Miami Springs, FLBuilt 1991 · S/N 53251 N806XAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2017 · S/N 61786 N807AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1064 N807DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31921 N807JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5312 N807KWAlta 777 LLC · Salt Lake City, UTS/N 27638 N807NNAmerican Airlines Inc · Fort Worth, TXS/N 31077 N807UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0798 N807WAFederal Dynamics Corp · Henderson, NVBuilt 1993 · S/N 53093 N807XAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 63406 N808AWU S Bank Na Trustee · Boston, MABuilt 1999 · S/N 1088 N808CFBoss 8 LLC · Fort Worth, TXBuilt 1991 · S/N 1176 N808DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31920 N808MFCd 321 LLC · Cypress, TXBuilt 2001 · S/N 1448 N808NNWilmington Trust Co Trustee · Wilmington, DES/N 33206 N808UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0804 N808WACaribbean Sun Airlines Inc · Miami, FLBuilt 1990 · S/N 53044 N809AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1111 N809DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31915 N809JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5349 N809NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33519 N809TARhoades Aviation Inc · Honolulu, HIBuilt 1987 · S/N 23796 N809UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0825 N80QJRegistered aircraftBuilt 1998 · S/N 1333 N810AWUS Bank Na Trustee · Boston, MABuilt 1999 · S/N 1116 N810DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31922 N810KWAlta 777 LLC · Salt Lake City, UTS/N 27639 N810NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 33207 N810TARhoades Aviation Inc · Honolulu, HIBuilt 1975 · S/N 21116 N810TMNomad Air LLC · Dover, DEBuilt 2002 · S/N 1483 N810UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0843 N8118KTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 33722 N811DZDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31916 N811KWAlta 777 LLC · Salt Lake City, UTS/N 27656 N811NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31079 N811TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1986 · S/N 23538 N811UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0847 N812AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1178 N812DNDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 31923 N812NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33520 N812UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 0850 N813AWWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 1223 N813DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31925 N813KWAlta 777 LLC · Salt Lake City, UTS/N 27641 N813NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 30918

Back to AD 2009-21-10 R1