OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N333THUchiyamada Brian N · San Gabriel, CABuilt 1977 · S/N CE-692N333TRBreaking Wind LLC · Alabaster, ALBuilt 1979 · S/N CE-860N333VPDennee Enterprises Group LLC · New Bern, NCBuilt 1984 · S/N E-2161N333WDanarich LLC · Rancho Mirage, CABuilt 1979 · S/N TE-1172N333ZXMallick Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N TH-1739N3344MSmith Andrew L · Hillsboro, TXBuilt 1993 · S/N CE-1731N3345BR Farms LLC · Wilmington, DEBuilt 1994 · S/N E-2865N3349ADoherty David R · Thief River Falls, MNBuilt 1970 · S/N CE-306N334CHLittle River Aviation LLC · Tifton, GABuilt 1977 · S/N D9962N334CPRws Aviation LLC · Indianapolis, INBuilt 1977 · S/N E-1003N334DBrady Michael H Trustee · Healdton, OKBuilt 1993 · S/N CE-1756N334HPN334hp LLC · Sheridan, WYBuilt 1974 · S/N CE-519N334JDGolden Bear Properties LLC · Lakeside, AZBuilt 1993 · S/N CE-1718N334KWRoberts Dorel Lynn · Sheridan, WYS/N CE-523N334MBSutherland Scott G · Longmont, COBuilt 1982 · S/N CE-1012N334PBConway Brian · Denver, COBuilt 1990 · S/N CE-1543N334PCMagic Valley Auction LLC · Jerome, IDBuilt 1990 · S/N CE-1534N334PWGary Bass Restorations LLC · Monett, MOBuilt 1974 · S/N CE-488N334RN566rw LLC · Hensley, ARBuilt 1991 · S/N CE-1561N334RDWrob Aero LLC · Del Rio, TXBuilt 1978 · S/N CE-837N334SESteeb Erik · San Luis Obispo, CABuilt 1987 · S/N CE-1111N334TRNachtigal Michael P · Ozark, MOBuilt 1990 · S/N CE-1499N334UWalter Matthew Timothy · Bella Vista, ARBuilt 1992 · S/N CE-1685N335HPOlympus Leasing LLC · Bremerton, WABuilt 1992 · S/N CE1663N335PElvin Robert Brian · Grove, OKBuilt 1996 · S/N E-3005N335RAirdocs LLC · Atlanta, GABuilt 2000 · S/N E-3335N335TBJkh Enterprises LLC · Westfield, INBuilt 1987 · S/N CE1166N335VHolden Donald T · Cherokee, IABuilt 1980 · S/N D-10338N3364BDilley Darrel L · La Salle, COBuilt 1977 · S/N CE-734N336CABergeron Machine Shop Inc · Abbeville, LABuilt 1998 · S/N EA613N336CBBeechair LLC · Helena, MTBuilt 2002 · S/N E-3431N336HPChs Acquisitions Inc · Dallas, TXBuilt 1989 · S/N CE1312N336LMKlm Unlimited Inc · Staples, MNS/N E-1587N336MLobo Air LLC · Carefree, AZS/N E-3528N336MTNorth Peak Aviation LLC · Waunakee, WIBuilt 1999 · S/N E-3265N336NANickravesh Niknam J · Saratoga, CABuilt 1980 · S/N E-480N336PWCajan LLC · Kings Mountain, NCBuilt 1982 · S/N EA-297N336RDByone Steve · Natchitoches, LABuilt 1996 · S/N E-3008N336TTophatter85 LLC · Kirksville, MOBuilt 1978 · S/N E-1219N3389MRoberts Roger W Trustee · Wichita, KSBuilt 1989 · S/N CE-1412N338D38 Delta Corp · Killington, VTBuilt 1987 · S/N E-2392N338HPN338hp LLC · Omaha, NEBuilt 1993 · S/N CE-1724N338MGEjdeha LLC · Boston, MABuilt 1989 · S/N CE-1325N338TKGranite Boarding LLC · Loomis, CAS/N TH-1991N33ANeo Terra Aviation LLC · Setauket, NYBuilt 1988 · S/N CE-1222N33CVMaintain Aviation LLC · Pomona, MOBuilt 1992 · S/N CE-1678N33EJReinke Bradley H · Pascagoula, MSBuilt 1993 · S/N CE-1721N33FSBvd Inc · Yates Center, KSBuilt 1974 · S/N D-9658N33FXDougfly Inc · Malibu, CAS/N D-10105N33GKDugger Glenn · Denton, TXBuilt 1990 · S/N CE-1468
Back to AD 87-18-06 R1