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.

N427LLForrest Jeffrey H · Bloomfield Hills, MIBuilt 1977 · S/N CE-679N427PWLangford Stephen C · York, SCBuilt 1976 · S/N D-9850N42800Asbury William J · Fresno, CABuilt 1976 · S/N D-9934N4280SYoung Daniel R · Germantown, TNBuilt 1976 · S/N D-9969N4281S4b Aviation LLC · Upper Arlington, OHBuilt 1977 · S/N E-949N4282PAero Tramp Holdings LLC · Dallas, TXBuilt 1999 · S/N E-3282N4282SGoerzen John P · Goessel, KSBuilt 1976 · S/N E-946N4289SGleason Aviation LLC · High Point, NCBuilt 1977 · S/N CE-682N428BDAirbrn LLC · Stuttgart, ARBuilt 1977 · S/N E-950N428KRLilly James D · Columbia, MDBuilt 1972 · S/N D-9306N4298YAir LLC · Fresno, CABuilt 2001 · S/N TH-1998N429JKRegistered aircraftBuilt 2005 · S/N E-3604N429PDupuy William C · Waco, TXBuilt 2000 · S/N E-3356N42AMGruhlkey William H · Wildorado, TXBuilt 1979 · S/N EA-29N42AUBite Wing Aviation LLC · Wichita, KSBuilt 1982 · S/N CE-1010N42BAGroom Randall T · Vero Beach, FLBuilt 1984 · S/N E-2139N42FQSp Aviation Group LLC · Weston, FLBuilt 1984 · S/N TH-1406N42JVCheshire Vincent Eugene Jr · Slidell, LABuilt 1980 · S/N CE-913N42KWMarine Aviation LLC · Lyme, NHBuilt 2001 · S/N TH-1985N42LBRigney Timothy D · Troy, VABuilt 1970 · S/N D-9140N42LHFly Hangar 13 LLC · Mico, TXBuilt 1981 · S/N EA-163N42MMPiper Capital LLC · Elkhorn, NEBuilt 1988 · S/N CE-1278N42SMBaron South LLC · Dexter, MOBuilt 1977 · S/N TJ-109N42TBFlores Nicholas L Jr · San Antonio, TXBuilt 1998 · S/N TH-1872N4300WPrivate Enterprises LLC · Peoria, AZBuilt 1973 · S/N E-487N4301SCoburn Thomas R Trustee · Upperco, MDBuilt 1975 · S/N CE-578N4301WNash Matthew · Edmonds, WABuilt 1974 · S/N D-9578N4302WDagenhart Ronald Jason · Westerville, OHBuilt 1974 · S/N D-9582N4305UMarshall Paul A Trustee · Gilroy, CABuilt 2000 · S/N E-3305N4305WBennett Hugh · Gillette, WYBuilt 1974 · S/N TE-967N4306AOdyssey Aviation LLC · Raleigh, NCBuilt 1970 · S/N TE-802N4306WBlaylock Christopher W · Lubbock, TXBuilt 2000 · S/N E-3352N4307SHuddleston Edward · Oaktown, INS/N E-675N4308SBurroughs Steven R · Murphysboro, ILBuilt 1975 · S/N E-678N4309SGsi · Temple, TXBuilt 1975 · S/N E-682N430FMCygnus Inc · Sioux Falls, SDBuilt 2000 · S/N E-3319N430RTTortorigi Aviation LLC · Birmingham, ALBuilt 1984 · S/N TH-1411N430RVVermejo Aviation LLC · Boulder, COBuilt 2004 · S/N TH-2097N4310SVelk Vincent F · Havre, MTBuilt 1975 · S/N D-9773N4312WBreitbarth Brian · Canby, ORBuilt 1974 · S/N D-9585N4314BJab Aviation LLC · Houston, TXBuilt 1982 · S/N CE-1002N4316WHolt Bartlett · Binghamton, NYBuilt 1974 · S/N CE-485N4317WMurray Patrick G · Moraga, CABuilt 1974 · S/N D-9587N4322WSnell Steve · Scotts Valley, CABuilt 1974 · S/N D-9589N4324VTriple Aaa LLC · Garden City, KSBuilt 2001 · S/N TH-2014N4324WWhite River Trucking Inc · Mason, WIBuilt 1974 · S/N TE-966N432ABWisco Flyers LLC · Middleton, WIBuilt 1987 · S/N CE-1181N432DLWhitecotton William W · Eldersburg, MDBuilt 1974 · S/N TH-561N4331ECmb Holdings LLC · Logansport, INBuilt 2000 · S/N E-3331N4331WRicca Gregory F Trustee · Bentonville, ARBuilt 1974 · S/N TH-436
Back to AD 87-18-06 R1