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.

N874FDFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66263 N874NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31129 N874TWUnited States Government · Washington, DCBuilt 1989 · S/N 24524 N874UAUmb Bank Na Trustee · Salt Lake City, UTS/N 2008 N87507United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31637 N87512United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33458 N87513United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31621 N87527United Airlines Inc · Chicago, ILBuilt 2010 · S/N 38701 N87531United Airlines Inc · Chicago, ILBuilt 2011 · S/N 39999 N875AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36705 N875DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31986 N875FDFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66264 N875NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33220 N875UAUnited Airlines Inc · Chicago, ILBuilt 2004 · S/N 2200 N876DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeS/N 31987 N876FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 40682 N876GLGlj Aviation LLC · Pompano Beach, FLBuilt 2001 · S/N 1454 N876NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40767 N876UAUnited Airlines Inc · Chicago, ILBuilt 2004 · S/N 2203 N877AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2001 · S/N 1461 N877DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2017 · S/N 31988 N877FDFederal Express Corp · Memphis, TNBuilt 2018 · S/N 40683 N877LCLetica Leasing LLC · Rochester Hills, MIBuilt 1991 · S/N 1165 N877NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31131 N877UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 2232 N878DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31989 N878FDFederal Express Corp · Memphis, TNBuilt 2017 · S/N 40684 N878NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40768 N878SMWorld Heir Inc · College Park, GABuilt 1997 · S/N 1319 N878UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2371 N879DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31990 N879FDFederal Express Corp · Memphis, TNBuilt 2018 · S/N 40685 N879NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31133 N879UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2408 N880CFBoss 8 LLC · Fort Worth, TXBuilt 1988 · S/N 1082 N880DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31991 N880NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40769 N880UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2426 N881DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31992 N881NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31135 N881UAUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 2435 N882DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31994 N882NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33221 N882UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2505 N883DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31993 N883GAFalcon Commercial Aviation LLC · Miami, FLBuilt 1988 · S/N 49710 N883LDV-Jet Aircraft Holding Co Trustee · Dover, DEBuilt 2001 · S/N 1441 N883NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31137 N883UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2574 N884CFN360kv LLC · Modesto, CABuilt 2001 · S/N 1435

Back to AD 2009-21-10 R1