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.

N949NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31192 N950AMUmb Bank Na Owner Trustee · Salt Lake City, UTS/N 35115 N950ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30087 N950AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3545 N950FDFederal Express Corp · Memphis, TNBuilt 1994 · S/N 25806 N950JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6609 N950NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31194 N950NSCorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53023 N951AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29538 N951AVWilmington Trust Company Trustee · Wilmington, DEBuilt 2008 · S/N 3574 N951FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28665 N951NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33327 N952AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30088 N952CAAc Spe 3 LLC · Orlando, FLBuilt 1991 · S/N 25238 N952FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28666 N952JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6663 N952NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31196 N953ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29539 N953FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28667 N953JMAlta Airlines Holdings LLC · Salt Lake City, UTS/N 25151 N953NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33328 N954ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30089 N954AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3699 N954FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 29113 N954JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6725 N954NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31197 N955ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29540 N955AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3835 N955FDFederal Express Corp · Memphis, TNBuilt 1998 · S/N 29114 N955JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6757 N955MBHms Air LLC · Van Nuys, CABuilt 1987 · S/N 1022 N955NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31199 N956ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30090 N956AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6050 N956FDFederal Express Corp · Memphis, TNBuilt 1998 · S/N 29115 N956JMJam Aviation LLC · Laredo, TXBuilt 1993 · S/N 1223 N956JTJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6791 N956NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31200 N957AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 39957 N957ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29541 N957AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6057 N957JBJet Blue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6809 N957NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31202 N958AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 39958 N958ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30091 N958AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6103 N958BXGulfstream 1227 LLC · Lewes, DEBuilt 1993 · S/N 1227 N958FDFederal Express Corp · Memphis, TNBuilt 1989 · S/N 24371 N958JBJetblue Airways Corp · Long Island City, NYBuilt 2015 · S/N 6859 N958NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31203

Back to AD 2009-21-10 R1