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.

N6486NTennessee Aviation Co LLC · Knoxville, TNBuilt 1982 · S/N CE-1007N648JRStreamline Aviation LLC · Henderson, NVBuilt 1977 · S/N E-1070N6496NFisher Ranch Corporation · Blythe, CABuilt 1982 · S/N EA-314N649ECDriggers David M · Tifton, GABuilt 1981 · S/N TH-1323N649LCSmith Aviation LLC · Sitka, AKBuilt 1980 · S/N TJ-304N64BTSunflower Enterprises Inc · Dubuque, IAS/N CE-1152N64BWSkyjams Holdings LLC · Las Vegas, NVBuilt 1975 · S/N E-656N64DWNavation LLC · Lauderhill, FLBuilt 1973 · S/N TH-306N64LAHanner Investments LLC · Appling, GAS/N TH-978N64LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N TH-1749N64PFW & L Consultants Inc · Dunn, NCS/N E-3452N64RPCoe Administrators LLC · Oshkosh, WIBuilt 1978 · S/N TJ-169N64VBTamworth Aviation LLC · Allen, TXBuilt 1973 · S/N TH-305N64WRAlesia Holdings LLC · Beaumont, TXBuilt 2001 · S/N TH-1981N64ZLewis Timothy W · Thousand Palms, CABuilt 1976 · S/N E-918N6507VBrown Steven K · Tucson, AZBuilt 1982 · S/N EA-309N6508VBest John K · Cave Creek, AZBuilt 1982 · S/N CE-1008N650YRWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N E-1932N65118Stormy Pilots LLC · Saint Thomas, VIBuilt 1982 · S/N TJ-437N6519NWinged Chariot LLC · Cincinnati, OHBuilt 1982 · S/N EA-319N6525Sacramento Computer Power Inc · Sacramento, CABuilt 1977 · S/N E-1173N65288Tammen Eric W · San Pedro, CABuilt 1983 · S/N E-2062N6529RN6529r LLC · Merritt Island, FLBuilt 1982 · S/N EA-322N652DBRocky Mountain Air LLC · Lafayette, COBuilt 1987 · S/N CE-1144N65318Prairie Sales Inc · Eden Prairie, MNBuilt 1983 · S/N E-2060N65320Lombardozzi James E · Billings, MTS/N EA-335N6536NPalmetto Wings LLC · Marietta, GAS/N E-2049N65376Sardella Craig J · Gold River, CABuilt 1983 · S/N EA-366N65420D5167 LLC · Kalispell, MTS/N E-2091N6544VHuber Robert T · West Chester, PABuilt 1983 · S/N E-2063N6548CRobinetti Newbeard LLC · Stratford, CABuilt 1982 · S/N E-2051N654JHEcho Bravo LLC · Helena, MTS/N E-3545N654SCLewis Aviation Inc · Wilmington, DEBuilt 1988 · S/N CE-1257N6551CChurch Thomas · Lenoir, NCS/N D-10402N6552XRockdoc Investments LLC · Mckinney, TXBuilt 1983 · S/N EA-325N6559Watson Charles R Jr · Austin, TXBuilt 1980 · S/N CE-877N655DDWarren Jason J · Silverdale, WABuilt 1988 · S/N CE-1263N655TWilliams Terry J · Owasso, OKBuilt 1972 · S/N E-328N6564DSan Antonio Prop Slingers LLC · La Vernia, TXBuilt 1982 · S/N E-2048N6573KGta Air Inc · Addison, TXBuilt 1983 · S/N TH-1369N6576SBeech Aviators LLC · Brookings, SDBuilt 1976 · S/N E-803N6580XSouthwest Aerial Survey LLC · Carlsbad, CABuilt 1983 · S/N EA-341N6582QHuss M Stephen M D · Decatur, ILBuilt 1983 · S/N E-2068N6585XNorthbay Consulting LLC · Bellevue, WABuilt 1983 · S/N EA-340N65873Carpenter Steve · Batesville, ARBuilt 1983 · S/N EA-342N658DGSchardt Aaron · Hastings, NEBuilt 1981 · S/N TH-1324N658JSTwo River Airspray LLC · Cavalier, NDBuilt 1977 · S/N TJ100N658MWitherington Properties Inc · Oak Ridge, TNBuilt 1982 · S/N TJ429N6593UWedt LLC · Wilmington, DEBuilt 1983 · S/N TH-1371N659TLucy Donald E III · Newbury Park, CABuilt 1972 · S/N D-9357
Back to AD 87-18-06 R1