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.

N472EVFletcher Aviation Services LLC · Bismarck, NDBuilt 1971 · S/N 20320 N472MMSmb G-IV II LLC · Longwood, FLS/N 1072 N472TNUmb Bank Na Trustee · Salt Lake City, UTS/N 29863 N472UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1435 N473CWAlfa Fox X LLC · Sebring, FLBuilt 1992 · S/N 1194 N473UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1469 N47414United Airlines Inc · Chicago, ILBuilt 2008 · S/N 32827 N474ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 40715 N474UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1475 N474XWashington Penn Plastic Co Inc · Washington, PABuilt 2001 · S/N 1445 N475LCIntrajet Corp · Kalispell, MTBuilt 2002 · S/N 1472 N475UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1495 N475USUS Department Of Homeland Security · Arlington, VABuilt 2004 · S/N 33789 N476UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1508 N477ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 40716 N477AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2013 · S/N 5477 N477GG477 Aviation LLC · Beverly Hills, CABuilt 1987 · S/N 1032 N477UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1514 N477USUS Department Of Homeland Security · Arlington, VABuilt 2003 · S/N 33785 N478ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44105 N478GSIntrajet Corp · Kalispell, MTBuilt 2002 · S/N 1478 N478UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1533 N479ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 60576 N479AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 25450 N479UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1538 N480MCAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 28812 N480UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1555 N480VRMmap LLC · Denver, COBuilt 1999 · S/N 1380 N48127United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28968 N481ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44106 N481AVAircol 21 · Wilmington, DEBuilt 2010 · S/N 4381 N481CMCargo Aircraft Management Inc · Wilmington, OHS/N 26992 N481MCAtlas Air Inc · Purchase, NYS/N 32339 N481SCRjs Aviation LLC · Fort Myers, FLBuilt 1997 · S/N 1313 N481UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1559 N482AAArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49675 N482MCAtlas Air Inc · Purchase, NYBuilt 2001 · S/N 32340 N482UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1584 N483AArctic One LLC · Fairbanks, AKBuilt 1988 · S/N 49676 N483ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 36350 N483UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1586 N484UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1609 N485GMGlobal Destinations LLC · Beaumont, TXBuilt 1997 · S/N 1311 N485UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1617 N4866UUnited Airlines Inc · Chicago, ILS/N 2404 N486ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44107 N486UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1620 N487ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44108 N487CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2004 · S/N 33768 N487UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1669

Back to AD 2009-21-10 R1