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.

N4888UBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3258 N488UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1680 N489MCAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 26553 N489UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1702 N48GLGenesis Adventures LLC · Brea, CABuilt 1988 · S/N 1052 N4901UUnited Airlines Inc · Chicago, ILBuilt 2006 · S/N 2680 N490UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1728 N491ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44109 N491AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29429 N491UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1741 N492ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44110 N492UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1755 N493ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 41727 N493UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1821 N494ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 41729 N494UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1840 N495ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 41728 N495JSP&P Air LLC · Salem, NHBuilt 1998 · S/N 1336 N495MMAmazon.Com Services LLC · Seattle, WABuilt 2022 · S/N 67026 N495UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1842 N495WGAir Kuz LLC · Jamison, PABuilt 1993 · S/N 1214 N496UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1845 N497UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1847 N498UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1865 N499AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29432 N49RFUnited States Department Of Commerce · Lakeland, FLBuilt 1994 · S/N 1246 N4DPGreen Chair Productions Inc · Los Angeles, CABuilt 1989 · S/N 1097 N5007EAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5781 N501RBLone Star Land & Cattle Co · Houston, TXBuilt 1990 · S/N 1138 N502DADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 21304 N503AZAmazon.Com Services LLC · Seattle, WABuilt 1991 · S/N 25274 N503JBJetblue Airways Corp · Longisland City, NYBuilt 1999 · S/N 1123 N503KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 28553 N503UAUnited Airlines Inc · Chicago, ILBuilt 1989 · S/N 24624 N504JBJetblue Airways Corp · Long Island City, NYBuilt 1999 · S/N 1156 N505JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1173 N505VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4798 N506ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35690 N506JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1235 N506VLBank Of Utah Trustee · Salt Lake City, UTS/N 4828 N507AYAmerican Airlines Inc · Fort Worth, TXBuilt 2008 · S/N 3712 N507JTJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1240 N507VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4832 N507YVBank Of Utah Trustee · Salt Lake City, UTS/N 24607 N508ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35691 N508AYAmerican Airlines Inc · Fort Worth, TXBuilt 2008 · S/N 3740 N508BCAlta 777 LLC · Salt Lake City, UTS/N 30873 N508JLJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1257 N508UAUnited Airlines Inc · Chicago, ILBuilt 1990 · S/N 24744 N508VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4950

Back to AD 2009-21-10 R1