OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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:87-10-06-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:87-10-06-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.

N192DBTodd Tracy · Lancaster, SCBuilt 1976 · S/N 14021N192DKLong Drive Holdings LLC · Alpine, UTS/N 17265020N192FCFleming Michael D · Huntersville, NCBuilt 1968 · S/N 28-24374N192JHHogue James B · Spencer, TNBuilt 1992 · S/N 669-92N192MEKindrick Jan W · Mt Vernon, TXBuilt 2000 · S/N 172S8454N192MHHolland James Michael · Fort Collins, COBuilt 2005 · S/N 90556N192RDisarro Wayne · Ketchikan, AKBuilt 2003 · S/N RK 100 1N192RGCinda Corporation · Lehighton, PABuilt 1992 · S/N 14561N192RKWeber Martin Trustee · Marthasville, MOBuilt 1992 · S/N 1854N192TGSaz Dynamics LLC · Daly City, CABuilt 2005 · S/N 18281524N192VDefenbaugh Matthew J · Biggsville, ILBuilt 1999 · S/N 22107N1930LMaclean Milton A III · Rossmoor, CAS/N M-1828N1930TWing John · Fort Worth, TXS/N 28-7125442N1930UGazzano Leonard S Trustee · Yerington, NVBuilt 1999 · S/N 1930N1930VDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1974 · S/N 17263798N1931TFordham Scott · Sag Harbor, NYBuilt 1975 · S/N AA50744N1931VRegistered aircraftBuilt 1974 · S/N 17263799N1931WDelgado Alan J · Auburn, GABuilt 1973 · S/N MB-589N1932VFarmland Aviation LLC · Glenwood, IABuilt 2005 · S/N 84232N1932YDriver L Spence · Bay City, WIBuilt 1964 · S/N 239N1932ZSpencer David E · Woodville, ALBuilt 2015 · S/N 001N1933FVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 17273023N1933HBlock Andrea · Chandler, AZS/N 28-7725170N1933LN1933l Ltd · Streetsboro, OHBuilt 1976 · S/N MC-417N1933TLogan Flyers LLC · Logan, OHBuilt 1971 · S/N 28-7105151N1933WHanson Garrick D · Clayton, NCS/N MB-597N1934HMaloney Loran D · Barnhart, MOBuilt 1977 · S/N 28-7716065N1934JN1934j LLC · Highland Lakes, NJBuilt 1976 · S/N 14025N1934PProulx Michael G · Westhampton, MABuilt 1955 · S/N 22-2685N1934YMack Anita · Scott Afb, ILBuilt 1964 · S/N 241N1935LBlais Aviation Services LLC · Frisco, TXBuilt 1976 · S/N MB-797N1935TWebboe Investments LLC · Falls Church, VABuilt 1971 · S/N 287105153N1935YHodges William L Jr · Spotsylvania, VABuilt 1964 · S/N 289N1936AHead Joseph A · Fairbanks, AKBuilt 1952 · S/N 18-1770N1936FCheek David H · Garland, TXBuilt 1979 · S/N 17273026N1936GDowning John T · Tucker, GABuilt 1936 · S/N 6N1936HBarts Flying Service · Storm Lake, IABuilt 1977 · S/N 28-7716066N1936LAnderson Brian E · Edmond, OKBuilt 1976 · S/N M-1846N1936NBrown Stuart J · Anchorage, AKBuilt 1977 · S/N 18-7709070N1936PSand Dollar Seaplanes LLC · Valentines, VABuilt 1997 · S/N 25008CN1936SMoore Christopher D · Cheyenne, OKBuilt 1964 · S/N 28-3173N1936TN1936t LLC · Franklin Park, NJBuilt 1971 · S/N 28-7105154N1936WDelgatto Robert G · Bellingham, WAS/N MB-599N19370Clanton Ronald W · Aurora, COBuilt 1968 · S/N 17257181N1937FA2 Flight Leasing LLC · Castro Valley, CABuilt 1979 · S/N 17273027N1937GGriffin Gerald D · Hunt, TXBuilt 1959 · S/N 18-7124N1937HTerra Alfred Jr · Taunton, MABuilt 1977 · S/N 28-7790358N1937JBryant Joe Henry Jr · Meridian, MSBuilt 1976 · S/N 14037N1937KGriffin Contracting Co · Bloomfield, MOS/N 3213091N1937LLuks George J · Crescent City, CABuilt 1976 · S/N MC-419
Back to AD 87-10-06 R1