OpenAirDocs.org
AD 2014-17-08 R1

Registered aircraft · 2,524

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:2014-17-08-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:2014-17-08-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.

N8502ATumbleweed Leasing LLC · Tacoma, WABuilt 2002 · S/N 502-0647N8502HPope James D · Lewiston, IDS/N 802-0140N8504RRussell Armstrong And Danny Hawk DBA · Yuba City, CABuilt 2001 · S/N 802A-0123N8504TWakefield Aircraft LLC · Cooperstown, NDBuilt 2005 · S/N 802A-0218N8506VKubecka Daniel P · Edna, TXBuilt 2003 · S/N 502B-0650N8507KA & M Flying Service Inc · Carlise, ARBuilt 2001 · S/N 802A-0122N8507NTumbleweed Leasing LLC · Tacoma, WABuilt 2003 · S/N 802A-0158N8507SVan Namen Jonathan · Benoit, MSBuilt 2003 · S/N 502B-0664N8509SAir Tractor Inc · Olney, TXBuilt 2003 · S/N 802A-0164N8509TCrop Jet Aviation LLC · Gooding, IDS/N 802A-0152N850HState Of Ohio Department Of Transportation · Columbus, OHBuilt 2004 · S/N 208B1061N850WRAg-Tech Aviation Inc · Leland, MSBuilt 2001 · S/N 502B-0643N8511QDaniels Aviation Inc · Inverness, MSS/N 602-0665N8516JG3 Flying LLC · Merigold, MSS/N 602-0671N8516KFlatland Aviation LLC · Indianola, MSBuilt 2003 · S/N 502B-0669N8519VAdams Aerial Solutions LLC · Decatur, ILBuilt 2004 · S/N 502B-0686N851EMLos Angeles Police Department · Los Angeles, CABuilt 1976 · S/N 73-22259N851FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0166N8521PThomas Air Service Inc · Hastings, NEBuilt 2004 · S/N 402B-1148N8521QCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2005 · S/N 502B-2572N8521VJones Flying Service · Biggs, CABuilt 2004 · S/N 602-0690N8521WA & M Flying Service Inc · Carlisle, ARBuilt 2004 · S/N 802A-0167N8521ZAir Care Leasing LLC · Lamar, COBuilt 2004 · S/N 502B-0693N8522SDodson International Parts Inc · Rantoul, KSBuilt 2003 · S/N 802A-0161N8522YAero Applications Inc · Burley, IDBuilt 2004 · S/N 802A-0188N85239Shelton Agri Services Inc · Hereford, TXBuilt 2005 · S/N 602-1130N8523LTwin Cities Aviation Inc · Yuba City, CABuilt 2005 · S/N 802A-0203N8524HMitchell Andrew D Trustee · Winnie, TXS/N 802A-0163N8524LTri Rotor Spray & Chemical · Ulysses, KSBuilt 2005 · S/N 802A-0202N8524QMid-Cal Ag Aviation Inc · Kerman, CABuilt 2005 · S/N 502B-2580N8525FJlr Ag Aircraft LLC · Fowler, COBuilt 2005 · S/N 402B-1169N8525QMagnum Aviation LLC · Goff, KSBuilt 2005 · S/N 802A-0222N8526LJack Olham Oil Inc · Dumas, TXBuilt 2005 · S/N 402B-1167N853ALMetro Aviation Inc · Shreveport, LABuilt 1996 · S/N 168N853FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0170N854CMHeritage Aviation Management Ltd · Conroe, TXBuilt 2001 · S/N 208B0908N85516United States Department Of State · Melbourne, FLBuilt 1993 · S/N UE-61N855FEAircraft Structures International Corp · Enid, OKBuilt 1990 · S/N 208B0203N856FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0176N857FEFederal Express Corp · Memphis, TNBuilt 1989 · S/N 208B0177N857MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2422N858FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0178N858MAMess Aero Inc · Grand Forks, NDBuilt 1997 · S/N 20800262N859FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0181N859MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2424N85CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0125N85HWHigh Notes LLC · Nashville, TNBuilt 1994 · S/N BB-1498N85LGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N LJ-1487N85TKStreamline Aviation LLC · Leawood, KSBuilt 2002 · S/N 4697128N85WLWillis Lease Finance Corp · Larkspur, CABuilt 1995 · S/N 20800245
Back to AD 2014-17-08 R1