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.

N913DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62781 N913JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5909 N913NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29571 N913UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67982 N913USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6255 N914ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29515 N914DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 62782 N914NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31161 N914UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67983 N914UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6337 N915ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29516 N915DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 62783 N915FDFederal Express Corp · Memphis, TNBuilt 1988 · S/N 24120 N915NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33227 N915UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67984 N915USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6387 N916ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29517 N916DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64884 N916NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31163 N916UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67985 N916USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6420 N917ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29518 N917DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 63530 N917KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 46917 N917MS917ms LLC · Longwood, FLBuilt 1994 · S/N 1241 N917NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29572 N917UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68363 N917UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6427 N917WMetro Helicopter LLC · Los Angeles, CABuilt 1991 · S/N 1158 N918ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29519 N918AVBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N 49104 N918DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64885 N918NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33228 N918SCCharlie November One LLC · Sheridan, WYBuilt 1988 · S/N 1075 N918UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68364 N918USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6443 N919ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29520 N919CAAc Spe 2 LLC · Orlando, FLBuilt 1991 · S/N 25302 N919DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 63531 N919NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 29573 N919RATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 30174 N919UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68365 N919USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6479 N91JSReserve Aircrafts LLC · New York, NYBuilt 2002 · S/N 1485 N920ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29521 N920DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63533 N920NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31165 N920UPBoeing Co · Renton, WABuilt 2026 · S/N 68366 N920USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6490 N9218Omega Air Inc · Selma, TXS/N 48218

Back to AD 2009-21-10 R1