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.

N68836United Airlines Inc · Chicago, ILBuilt 2014 · S/N 60088 N68842United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42183 N68843United Airlines Inc · Chicago, ILBuilt 2015 · S/N 60317 N68880United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42199 N68891United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42196 N688DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27587 N688FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0874 N688SLAero Micronesia Inc DBA · Barrigada, GUBuilt 1991 · S/N 25140 N688TAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5243 N689DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27172 N689FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0875 N689TAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5333 N68ALAircraft Engine Lease Finance Inc · Guaynabo, PRFirst renewal noticeBuilt 1992 · S/N 1198 N69020United Airlines Inc · Chicago, ILBuilt 2007 · S/N 31687 N69059United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29454 N69063United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29458 N690DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27585 N690FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0876 N690NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8434 N691AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3691 N691FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0877 N691NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8614 N692AAAersale Inc · Doral, FLBuilt 1993 · S/N 26972 N692DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29724 N692FEFederal Express Corp · Memphis, TNBuilt 2007 · S/N 0878 N692NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8611 N693DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29725 N693NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8659 N694ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26974 N694DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29726 N694NKSpirit Airlines LLC · Dania Beach, FLBuilt 2018 · S/N 8632 N695DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29727 N696ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26976 N696DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29728 N696NKSpirit Airlines LLC · Dania Beach, FLBuilt 2019 · S/N 8824 N697ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26977 N697BJTexas Air And Space Museum Inc · Amarillo, TXS/N 47799 N697DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30318 N69804United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42816 N69806United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42742 N69810United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42744 N69813United Airlines Inc · Chicago, ILBuilt 2014 · S/N 43531 N69816United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42176 N69818United Airlines Inc · Chicago, ILFirst renewal noticeBuilt 2014 · S/N 42177 N69819United Airlines Inc · Chicago, ILFirst renewal noticeBuilt 2014 · S/N 43533 N69824United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42179 N69826United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42180 N69829United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44561 N69830United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44560 N69833United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44565

Back to AD 2009-21-10 R1