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.

N293UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48473 N29401Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 29401 N294AKAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 64303 N294ARJet Midwest Inc · Kansas City, MOS/N 29404 N294EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53210 N294FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63131 N294NVBank Of Utah Trustee · Salt Lake City, UTS/N 4941 N294UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48472 N295EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53211 N295FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63130 N295NVBank Of Utah Trustee · Salt Lake City, UTS/N 4942 N296AKAlaska Airlines Inc · Seattle, WABuilt 2018 · S/N 64304 N296EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53212 N296FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64056 N296NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2674 N29717United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28936 N297AKAlaska Airlines Inc · Seattle, WABuilt 2019 · S/N 60578 N297EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53213 N297NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2778 N298AKAlaska Airlines Inc · Seattle, WABuilt 2019 · S/N 60583 N298CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40565 N298NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2800 N298RBSmb G-IV IV LLC · Longwood, FLBuilt 1998 · S/N 1341 N299FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 64059 N299MBOne World Aviation 299 LLC · Atlanta, GAS/N 1231 N299NVAllegiant Air LLC · Las Vegas, NVBuilt 2011 · S/N 4870 N2RDAmerican Gift LLC · Atlanta, GABuilt 2003 · S/N 1510 N300SFModern Industrial Services Inc · Beaumont, TXBuilt 1994 · S/N 1250 N3014RAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5842 N301CRCobra Aviation Services LLC · Oklahoma City, OKS/N 30331 N301KHAeko Kula LLC DBA · Honolulu, HIBuilt 1995 · S/N 27904 N301NBDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1058 N301NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2319 N301NWAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33342 N301PAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31255 N302FLBank Of Utah Trustee · Salt Lake City, UTS/N 30072 N302NBDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1062 N302NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2387 N303FEFederal Express Corporation · Memphis, TNBuilt 1973 · S/N 46802 N303KHNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1999 · S/N 25606 N303TWLogistic Air Inc · Reno, NVS/N 20116 N30401United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30118 N304FEFederal Express Corporation · Memphis, TNBuilt 1978 · S/N 46992 N305DGAerobeauty LLC · Santa Fe Springs, CABuilt 1990 · S/N 1139 N305GHN305dg LLC · Miami, FLBuilt 1994 · S/N 1257 N305LMHga LLC · Dallas, TXBuilt 2001 · S/N 1443 N305NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2005 · S/N 2398 N305NXAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31253 N305TCAlliance Aviation Group LLC · Wilmington, DEBuilt 1989 · S/N 1116 N306FEFederal Express Corp · Memphis, TNBuilt 1985 · S/N 48287

Back to AD 2009-21-10 R1