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.

N71BDBdj Aviation LLC · Ridgeland, MSBuilt 2000 · S/N 1415 N71NEIal Corp · Lewes, DEBuilt 1991 · S/N 1174 N71TV1430 Giv LLC · Fort Lauderdale, FLBuilt 2000 · S/N 1430 N720ADTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 1290 N720ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33522 N720CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1977 · S/N 21298 N720FRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 7852 N721ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31546 N721BSAria LLC · Salt Lake City, UTBuilt 2003 · S/N 1516 N721FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7884 N721MNBd Md-87 LLC · Longwood, FLBuilt 1989 · S/N 49767 N721TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29954 N721UWBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1095 N721VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 34295 N722ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31547 N722FRAlc A321 8579 LLC · Camden, DEBuilt 2018 · S/N 8579 N722GTWilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 69788 N722LALogistic Air Inc · Reno, NVS/N 22992 N722NKOsprey Wings LLC · Las Vegas, NVBuilt 1992 · S/N 1203 N722TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29385 N722USBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1097 N723ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 33125 N723AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6167 N723FRAlc A321 8640 LLC · Camden, DEBuilt 2018 · S/N 8640 N723TWDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29378 N723UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1109 N72405United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30122 N724ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31548 N724AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6153 N724CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1971 · S/N 20383 N724TWR&W Flying Inc · Greenbrier, ARS/N 28488 N724UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1122 N725ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 41666 N725UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1135 N725WWWin Win Aviation Inc · Wake Forest, NCFirst renewal noticeBuilt 1990 · S/N SH3205 N726ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31550 N726AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6174 N726RWAvire LLC · West Hollywood, CABuilt 1987 · S/N 1039 N726USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22469 N727ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 33541 N727HLAviation Sales And Charter LLC · Dover, DES/N 22642 N727NKAntares Aviation LLC · Boca Raton, FLBuilt 1979 · S/N 21945 N727TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30340 N727USUSA Jet Airlines Inc · Belleville, MIBuilt 1981 · S/N 22470 N727YKFayaka Airways LLC · San Francisco, CANon-citizen corporation, flight hours not reportedS/N 21442 N728ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 31553 N728AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6209 N729ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 33127 N729CAAc Spe 6 LLC · Orlando, FLBuilt 1991 · S/N 25068 N729CKConair USA Co · Dover, DEBuilt 1982 · S/N 22982

Back to AD 2009-21-10 R1