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.

N986AKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 49412 N986ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7046 N986FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28482 N986JBJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7907 N986NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31236 N987AK987 Investments LLC · Spring, TXS/N 49404 N987AMAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7079 N987ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31069 N987FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28483 N987GCGenesis Custom Jetliners LLC · New York, NYBuilt 1991 · S/N 53040 N987JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7855 N987NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33247 N988ALAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7154 N988FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26705 N988JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7956 N988NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31237 N989ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33205 N989AUAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7307 N989FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28480 N989JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7924 N989NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33338 N98LT98lt LLC · Austin, TXBuilt 1995 · S/N 1278 N990ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29563 N990AUAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7336 N990DLCorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53342 N990FDFederal Express Corp · Memphis, TNBuilt 1986 · S/N 22909 N990JLJetblue Airways Corporation · Long Island City, NYBuilt 2017 · S/N 7993 N990NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31241 N991ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 30920 N991AUAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7131 N991FDFederal Express Corp · Memphis, TNBuilt 1986 · S/N 22911 N991JTJetblue Airways Corp · Long Island City, NYBuilt 2017 · S/N 7994 N991NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31242 N992ANWilmington Trust Co - Trustee (2008 Msn 31071) · Wilmington, DEBuilt 2009 · S/N 31071 N992AUUmb Bank N A Trustee · Salt Lake City, UTBuilt 2016 · S/N 7157 N992AVAircol 7 Trust · Wilmington, DEBuilt 2009 · S/N 3992 N992FDFederal Express Corp · Memphis, TNBuilt 1986 · S/N 22912 N992JBJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8178 N992NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31244 N993ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7188 N993ARBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 0993 N993JEJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8143 N993NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33340 N994ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7407 N994DLArctic One LLC · Fairbanks, AKS/N 53346 N994JLJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8185 N994NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33248 N995ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7301 N995GGAerovision Aircraft Holdings Inc · Dover, DEBuilt 1988 · S/N 1074 N995JLJetblue Airways Corp · Long Island City, NYBuilt 2018 · S/N 8293

Back to AD 2009-21-10 R1