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.

N306NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2420 N306NYAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33343 N306PBAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31257 N306TTIgnite Enterprises LLC · Cerritos, CABuilt 1990 · S/N 1148 N307ACBank Of Utah Trustee · Salt Lake City, UTS/N 30700 N307AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1997 · S/N 28725 N307EWFast Bird LLC · Wilmington, DEBuilt 1988 · S/N 1051 N307FEFederal Express Corp · Memphis, TNBuilt 1986 · S/N 48291 N307NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2427 N308FEFederal Express Corp · Memphis, TNBuilt 1986 · S/N 48297 N308JWSupera Aviation I LLC · Sarasota, FLS/N 1390 N308NVSunrise Asset Management LLC · Las Vegas, NVS/N 2450 N309DEDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 29634 N309NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3084 N309PCAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31258 N30DJBizav Support LLC · Fort Lauderdale, FLBuilt 1995 · S/N 1269 N30GDCarol City Air LLC · Hialeah, FLBuilt 1993 · S/N 1228 N30JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 1517 N30LHHillier Giv LLC · Va Beach, VABuilt 1992 · S/N 1207 N310DEDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 29665 N311AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25316 N311GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1995 · S/N 26316 N311NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2006 · S/N 2702 N312AACargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22315 N312NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2289 N312WWWin Win Aviation Inc · Wake Forest, NCBuilt 1992 · S/N SH3212 N313ARDora 13 LLC · North Bergen, NJBuilt 1997 · S/N 1317 N313AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1990 · S/N 24930 N313FTUmb Bank Na Trustee · Salt Lake City, UTS/N 2313 N313NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2300 N313XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25313 N31412United Airlines Inc · Chicago, ILBuilt 2002 · S/N 30129 N314NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1191 N314PDAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31259 N314XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25314 N3159GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 35119 N315FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 48313 N315NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1230 N315NVSunrise Asset Management LLC · Las Vegas, NVS/N 2412 N315PEWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31261 N315WWWin Win Aviation Inc · Wake Forest, NCBuilt 1992 · S/N SH3215 N3160GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 32277 N316FEFederal Express Corp · Memphis, TNBuilt 1988 · S/N 48314 N316NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1249 N316NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2481 N316PFAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31262 N316VBLiving Word Christian Center · Forest Park, ILBuilt 1999 · S/N 1377 N316WWWin Win Aviation Inc · Wake Forest, NCBuilt 1992 · S/N SH3216 N317AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25445 N317CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24317

Back to AD 2009-21-10 R1