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.

N938NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33490 N939ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 30083 N939AVAircol 24 · Wilmington, DEBuilt 2011 · S/N 4939 N939NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33491 N939PGUrnxtjet LLC · Deland, FLBuilt 1993 · S/N 1212 N9405TFrontera Flight Holdings Inc · Dover, DES/N 53141 N9409FFronteraflight Holdings Inc · Dover, DEBuilt 1992 · S/N 53121 N940ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 30598 N940FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24772 N940NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33323 N941ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29534 N941FDFederal Express Corp · Memphis, TNBuilt 1987 · S/N 22691 N941FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2483 N941NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33232 N942ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30084 N942FDFederal Express Corp · Memphis, TNBuilt 1986 · S/N 22612 N942JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6279 N942NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33492 N943ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30599 N943FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2518 N943JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6326 N943NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31177 N944ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29535 N944AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4730 N944JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6359 N944NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31185 N945ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30085 N945AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4733 N945JTJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6390 N945NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 33233 N945XCStratton Ventures LLC · Dover, DES/N 1019 N946ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30600 N946AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4924 N946FDFederal Express Corp · Memphis, TNS/N 24398 N946JLJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6425 N946NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33234 N947ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29536 N947FDFederal Express Corp · Memphis, TNS/N 24882 N947JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6448 N947NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31190 N948ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30086 N948AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4933 N948FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25059 N948JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6560 N948NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31189 N948TWKc Aviation Stem Inc · Kansas City, MOS/N 49575 N949ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29537 N949FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25060 N949FRUmb Bank N A Trustee · Salt Lake City, UTBuilt 2006 · S/N 2857 N949JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6575

Back to AD 2009-21-10 R1