OpenAirDocs.org
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
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.

N435ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 43292N435GXBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1763N435HCAerobat Ventures LLC · Phoenix, AZBuilt 2001 · S/N 1450N435UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 613N436UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 638N437GAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 1437N437UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 655N438AAFrontera Flight Holding Inc · Dover, DEBuilt 1987 · S/N 49456N438BNAntares Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 21045N438GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30766N438UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 678N439GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30767N439UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 683N440ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41705N440KHAircraft 28889 LLC · Lake Mary, FLBuilt 1998 · S/N 28889N440UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 702N441UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 751N442ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 43293N442KHAircraft 28888 LLC · Lake Mary, FLBuilt 1998 · S/N 28888N442UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 780N442WWAb Jet Co Vii LLC · Metairie, LABuilt 2001 · S/N 1442N443AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25202N443UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 820N444HECsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1987 · S/N 23800N444QCGulfstream Giv-1411 LLC · Wilmington, DEBuilt 2000 · S/N 1411N444QGQuad/Air LLC · Sussex, WIBuilt 2001 · S/N 1453N444UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 824N44503Frontera Flight Holdings Inc · Dover, DEBuilt 1989 · S/N 49797N445MDMalcolm Aviation LLC · San Francisco, CABuilt 1999 · S/N 1366N445UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 826N446AVAircol 11 · Wilmington, DEBuilt 2009 · S/N 4046N446UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 834N447UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 836N448ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36356N448UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 842N449UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 851N44CEEvergreen Executive Holdings LLC · North Oaks, MNBuilt 1989 · S/N 1125N44GJN44gj LLC · Camden, DEBuilt 2003 · S/N 1508N44GVN44gv LLC · Pacific Palisades, CABuilt 1997 · S/N 1305N450EJPremier Air Charter Inc · Carlsbad, CABuilt 1995 · S/N 1273N450LRRicotta Lance · Yuma, AZBuilt 1988 · S/N 1013N450MBAircraft Fidelity Corporation Trustee · Dover, DEBuilt 1996 · S/N 1295N450PZN800pz LLC · Las Vegas, NVBuilt 1996 · S/N 1299N451AVAircol 12 · Wilmington, DEBuilt 2009 · S/N 4051N451GAStratton Ventures LLC · Wilmington, DEBuilt 1993 · S/N 1221N451KRAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2001 · S/N 1451N451PEPa Msn 1451 LLC · Dallas, TXBuilt 2001 · S/N 01451N451UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 865N452UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 0955N453ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 36354
Back to AD 2009-21-10 R1