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.

N3773DDelta Air Lines Inc · Atlanta, GABuilt 2010 · S/N 30825 N377CLPetrus Iagcas 777 LLC · Dallas, TXS/N 35164 N377DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29625 N377DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8856 N377NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2082 N377UPUnited Parcel Service Co · Louisville, KYBuilt 2021 · S/N 66812 N378CXCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27184 N378DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30265 N378DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8822 N378NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2092 N378UPCc&E I LLC · Louisville, KYBuilt 2023 · S/N 67920 N379AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25200 N379DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30349 N379DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8914 N379UPCc&E I LLC · Louisville, KYBuilt 2023 · S/N 67968 N37ECPark Ohio Industries Inc · Cleveland, OHBuilt 1993 · S/N 1226 N37WHNorthrop Grumman Systems Corp · El Segundo, CABuilt 1994 · S/N 1243 N380ACUmb Bank Na Trustee · Salt Lake City, UTS/N 3383 N380DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30266 N380DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8915 N380UPCc&E I LLC · Louisville, KYBuilt 2023 · S/N 67969 N381DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30350 N381DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8859 N381UPC C & E I LLC · Louisville, KYBuilt 2023 · S/N 67970 N38257United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30612 N38268United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31587 N382DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30345 N382DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8854 N382UPC C & E I LLC · Louisville, KYBuilt 2023 · S/N 67971 N383DJGiv Investors LLC · Olean, NYBuilt 2000 · S/N 1383 N383DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30346 N383DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8916 N383UPCc & Ei LLC · Louisville, KYBuilt 2023 · S/N 67972 N38403United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30120 N38417United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31665 N38424United Airlines Inc · Chicago, ILBuilt 2008 · S/N 37095 N38443United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31655 N38446United Airlines Inc · Chicago, ILBuilt 2012 · S/N 31661 N38451United Airlines Inc · Chicago, ILBuilt 2012 · S/N 31646 N38454United Airlines Inc · Chicago, ILBuilt 2012 · S/N 31640 N38458United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37199 N38459United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37206 N38467United Airlines Inc · Chicago, ILBuilt 2013 · S/N 33537 N38473United Airlines Inc · Chicago, ILBuilt 2013 · S/N 38702 N38479United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62817 N384DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30347 N384DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8974 N384UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67973 N385DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30348 N385DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8975

Back to AD 2009-21-10 R1