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.

N884DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31995 N884NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33222 N884UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2579 N885DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31996 N885NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31139 N886DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31998 N886NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33223 N887DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 31997 N887GARising Sun Aviation LLC · Irving, TXBuilt 1990 · S/N 49932 N887MRFouga LLC · Dover, DEBuilt 1994 · S/N 1251 N887NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31141 N888CSZg Aviation LLC · New York, NYBuilt 2001 · S/N 1469 N888DUDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31999 N888ESSpinair LLC · Saratoga, CABuilt 1989 · S/N 1120 N888FDFederal Express Corp · Memphis, TNBuilt 2017 · S/N 42704 N888FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 1041 N888LTAero Micronesia Inc DBA · Barrigada, GUBuilt 1992 · S/N 25441 N888MFSn 1268 Inc · Wilmington, DEBuilt 1995 · S/N 1268 N888YGGy Gulfstream LLC · Las Vegas, NVBuilt 2003 · S/N 1519 N889BHPrima Air Group LLC · Pasadena, CABuilt 1989 · S/N 1121 N889CGPrima Air LLC · Pasadena, CABuilt 1999 · S/N 1386 N889DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 62774 N889NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33314 N889UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2667 N890DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62775 N890NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31143 N890UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2815 N891DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32001 N891FDFederal Express Corp · Memphis, TNBuilt 2018 · S/N 41440 N891NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33315 N891UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2901 N892DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32000 N892NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31145 N892UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2940 N893DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32002 N893FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 41736 N893NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33316 N893UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2948 N894DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62776 N894FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 41737 N894NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31147 N894UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2969 N895DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32003 N895NNWilmingtontrust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31149 N895UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3020 N896DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62777 N896FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 41750 N896NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33224 N896UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 3144 N897DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32004

Back to AD 2009-21-10 R1