Skip to content

AD 2009-21-10 R1

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.

N678MKKhairy Mohammed Al Trustee · San Diego, CAS/N 415 N678NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7857 N679AWBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 2613 N679FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 793 N679NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7825 N68061United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29456 N68084Federal Express Corp · Memphis, TNS/N 25036 N68085Federal Express Corp · Memphis, TNBuilt 1993 · S/N 26702 N68087Federal Express Corp · Memphis, TNBuilt 1990 · S/N 24891 N680AWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2005 · S/N 2630 N680FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 794 N680NKUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7870 N681AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25338 N681FEFederal Express Corporation · Memphis, TNBuilt 1999 · S/N 0799 N681NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7908 N682DADelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 1993 · S/N 26958 N682FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0800 N682NKSpirit Airlines LLC · Dania Beach, FLBuilt 2017 · S/N 7957 N683AZAmazon.Com Services LLC · Seattle, WABuilt 2022 · S/N 67027 N683DADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 27103 N683FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0801 N683NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8114 N68452United Airlines Inc · Chicago, ILBuilt 2012 · S/N 40005 N68453United Airlines Inc · Chicago, ILBuilt 2012 · S/N 41742 N684AJUnited Aircraft Industries · Newark, DES/N 0194 N684DADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 27104 N684FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0802 N684NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8047 N685DADelta Air Lines Inc · Atlanta, GABuilt 1995 · S/N 27588 N685FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0803 N685MFSmb G-IV Vi LLC · Longwood, FLBuilt 1988 · S/N 1056 N685NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8115 N686AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25343 N686DADelta Air Lines Inc · Atlanta, GABuilt 1995 · S/N 27589 N686FEFederal Express Corp · Memphis, TNBuilt 1999 · S/N 0804 N686NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8141 N686TAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5238 N687DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27586 N687FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0873 N687NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8160 N68801United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42740 N68802United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42739 N68805United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42818 N68807United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42819 N68811United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42175 N68817United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42747 N68821United Airlines Inc · Chicago, ILBuilt 2014 · S/N 43535 N68822United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42178 N68823United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42746 N68834United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44564

Back to AD 2009-21-10 R1