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.

N858WGreat Pond LLC · Bedford, MAS/N TH-2060N859CBoe Ndt LLC · Haysville, KSBuilt 2001 · S/N E-3395N85BBAvanti Aviation LLC · Bellevue, NEBuilt 1973 · S/N E-508N85ECHammett Wilbur Jeffrey · Saint Augustine, FLBuilt 1985 · S/N E-2278N85FS7353r Co Partnership · Pottstown, PABuilt 1974 · S/N TH-486N85JS85 Juliet Sierra LLC · Chico, CABuilt 1970 · S/N CE-303N85MEGlobal Petroleum Services LLC · Greenville, SCBuilt 1978 · S/N TJ-168N85WMDiaz Oscar Jr · Raleigh, NCBuilt 1981 · S/N CE-943N860AJohnson Plane Services LLC · Greenbrier, TNBuilt 1980 · S/N CE-934N861DAirtipp LLC · Tipp City, OHBuilt 1975 · S/N TE-1052N861DSWilliamson Mark · South Padre Island, TXS/N CE-512N861RXMullen Robert R III Trustee · Woodland Hills, CABuilt 1979 · S/N E-1449N861SCSpotted Hawk Aviation LLC · Rosenberg, TXBuilt 1997 · S/N E3128N862DRegistered aircraftBuilt 1978 · S/N E-1362N8636A36a Ltd · Cincinnati, OHBuilt 1982 · S/N E1977N8652RFour Alpha Juliet LLC · Minster, OHBuilt 2000 · S/N E-3354N865MCN865mc LLC · Knoxville, TNBuilt 1973 · S/N TE 905N866RAircraft Partner Holdings Inc Trustee · BerlinBuilt 1980 · S/N EA-105N867DBLimberopoulos Anthony John · Naperville, ILBuilt 1987 · S/N CE-1134N867LCCurd Layton · Cypress, TXBuilt 1991 · S/N E-2649N869KSUniversity Of Central Missouri · Warrensburg, MOBuilt 1993 · S/N TH-1692N86BVMila Air LLC · Cincinnati, OHBuilt 1991 · S/N CE-1582N86CDBri Mar Aviation Corp · New Britain, CTBuilt 1997 · S/N E-3145N86MESutherland Jason · Auburn, WABuilt 1999 · S/N E-3285N86TEBowers Stephen W · Richland, MIS/N D-10342N870UOhio University · Albany, OHBuilt 2002 · S/N TH-2036N871ANWnd Aircraft Management LLC · Miami, FLBuilt 1993 · S/N TH-1678N871CSTurquoise Blue Aviation LLC · Santa Rosa Beach, FLS/N E-2291N871JBAas Baron LLC · Houston, TXS/N TH-2038N8720YEmpire Rental & Leasing Inc · Eden, NCBuilt 1991 · S/N CE-1555N872WNsi Flight Services LLC · Idaho Falls, IDS/N EA-681N872WHTheologos Charles · Waveland, MSBuilt 1993 · S/N TH-1679N8733Nason David F · Kent, WABuilt 1987 · S/N CE1159N873BCMedia Stew LLC · Carson City, NVS/N CE-1227N873JDBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N TH-2044N873WHG & A Viation LLC · Miller, MOBuilt 1993 · S/N TH-1680N874JETc Air LLC · Williamson, WVS/N TH-2045N874WHRed Oak Aviation LLC · Sunset, LABuilt 1993 · S/N TH-1681N875DBDbco LLC · Greenwood Village, COBuilt 1980 · S/N TH-1135N875JGN875jg LLC · Lawton, OKS/N TH-2046N875PDGarmin International Inc · Olathe, KSS/N E-3534N876PMGeddie Steven Gwynn · College Station, TXBuilt 1976 · S/N E-961N877CAHausman Benjamin · Merritt Island, FLBuilt 1994 · S/N TH-1727N877HLLeavitt Randall Stephen Trustee · San Diego, CABuilt 1991 · S/N E-2643N877TSpecialty Paving Inc · Lincoln, CABuilt 2001 · S/N E-3381N878BBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N TH-1710N878CAKag Aviation LLC · Mc Carley, MSBuilt 1994 · S/N TH-1728N878WMortgage And General Investment Corp · Big Bear Lake, CABuilt 2002 · S/N E-3459N879JPRebel Aircraft LLC · Rapid City, SDBuilt 2002 · S/N TH-2030N879MCJ P IV LLC · Hickory, NCBuilt 1977 · S/N D-10008
Back to AD 87-18-06 R1