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.

N385UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67974 N386DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30373 N386DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8947 N386UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67975 N38727United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28797 N387DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30374 N387DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9025 N387UPC C & E I LLC · Louisville, KYBuilt 2024 · S/N 67976 N388CAPhoenix Aurora LLC · San Juan, PRBuilt 1987 · S/N 1034 N388DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30375 N388DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9043 N388UPC.C. & E.I LLC · Louisville, KYBuilt 2025 · S/N 67977 N389AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 26915 N389DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30376 N389DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 9057 N389UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67978 N390CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 32973 N390DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30536 N390DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9066 N390UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67979 N391CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 32975 N391DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30560 N391DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9027 N391UPCargo Aircraft Management Inc · Wilmington, OHS/N 28039 N39297United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34003 N392DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30561 N392DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9028 N392UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 28041 N393DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30377 N393DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9067 N393UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29228 N39415United Airlines Inc · Chicago, ILBuilt 2008 · S/N 32826 N39416United Airlines Inc · Chicago, ILBuilt 2008 · S/N 37093 N39418United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33456 N39423United Airlines Inc · Chicago, ILBuilt 2008 · S/N 32829 N39450United Airlines Inc · Chicago, ILBuilt 2012 · S/N 40004 N39461United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37201 N39463United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37208 N39475United Airlines Inc · Chicago, ILBuilt 2013 · S/N 37100 N394AJGlf4 1470 LLC · Wilmington, DEBuilt 2001 · S/N 1470 N394DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30562 N394DXDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9125 N394UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25136 N395CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25447 N395DNDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30773 N395DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9126 N395UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29229 N396CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25195 N396DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30378 N396DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9128

Back to AD 2009-21-10 R1