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.

N246ALAiror LLC · Lees Summit, MOBuilt 1978 · S/N E-1412N246DYWilson Ralph W Trustee · Mentor, OHBuilt 1996 · S/N E-3065N2472Vivid Aviation LLC · Las Vegas, NVBuilt 1976 · S/N E-906N2472YAndrews Kevin M · Riverside, CABuilt 1970 · S/N E-254N248G E Flight Services LLC · Clarksdale, MSBuilt 2001 · S/N EA-678N249BB42m Aviation LLC · Shady Shores, TXBuilt 1979 · S/N D-10318N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249N249MVAmble Tod M · Bozeman, MTBuilt 1979 · S/N CE-884N24AGAegis Air LLC · Columbia City, INBuilt 1979 · S/N D-10293N24ASRegistered aircraftBuilt 1985 · S/N E-2259N24BEMystic Knights Of The Air Lodge Inc · Canton, MSBuilt 1979 · S/N E-1540N24BFWright Aviation Inc · Pikeville, KYBuilt 1980 · S/N E1736N24BKN24bk LLC · Jupiter, FLBuilt 1977 · S/N E-1145N24HFHangarwise Management LLC · Albuquerque, NMBuilt 1982 · S/N CE-999N24HLLederer Henry A IV · Riderwood, MDBuilt 1976 · S/N CE-660N24JVVan Blarcom John C II · Highland, CABuilt 1972 · S/N D-9337N24KHMoffett Jules M DBA · Elmore, ALBuilt 1974 · S/N TE-996N24LKPrime Rib Aviation LLC · Nowata, OKBuilt 1980 · S/N E-1744N24NTrewhitt Douglas G · Camarillo, CAS/N EA-693N24RAGrass Peter T · Hampstead, NCBuilt 1989 · S/N CE-1379N24RCJeanes Guy R · Lampe, MOBuilt 1974 · S/N TE-994N250DCHightower George Jr · Thomaston, GABuilt 1979 · S/N TK-91N250MLAlpha Aero Repair LLC · Dousman, WIBuilt 1973 · S/N CE-475N250MMMone Forwarding Lc · Laredo, TXBuilt 1980 · S/N TJ-261N252DPDream Flite LLC · Sarasota, FLBuilt 1973 · S/N TE-932N252VKirschner Joel Trustee · Burbank, CABuilt 1971 · S/N CE-321N2531UClyde Shields Entomological Service · Brawley, CAS/N E-2301N253KTInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N E2200N253RLArs Automation Design Inc · Greensboro, NCBuilt 1980 · S/N EA-131N25466Bas Part Sales LLC · Greeley, COBuilt 1986 · S/N E-2303N2549625496 LLC · Muscatine, IABuilt 1986 · S/N E-2305N254DPPulsipher David · Saint George, UTBuilt 1990 · S/N E-2527N25612Mad Scientist Aviation LLC · Wilmington, DES/N TE-897N25615Roark Co Inc · Montgomery, ALBuilt 1973 · S/N E-460N25625Martinez Maurice Dominic · La Habra, CABuilt 1973 · S/N E-393N25627Sutter Jacob O · Roland, ARBuilt 1973 · S/N TH-295N25632Struck Larry G · Gardnerville, NVS/N D-9435N25633Paolercio Alan D · Grants Pass, ORBuilt 1973 · S/N D-9438N25642Pester Jerome B · Hingham, MTBuilt 1973 · S/N CE-457N25647Segura Richard J III · Henderson, TXBuilt 1973 · S/N TH-301N25662Atcnavion LLC · Hinckley, OHBuilt 1973 · S/N D-9522N25665Franks Bryan · Camarillo, CABuilt 1973 · S/N CE-459N25667Bushnell Alison M · Phelan, CABuilt 1973 · S/N E-468N25675Todd James Michael · Angleton, TXBuilt 1973 · S/N E-472N25681Heli-Ventures Inc · Wilmington, DEBuilt 1973 · S/N CE-460N25691Marty Daniel A · Birmingham, ALBuilt 1973 · S/N CE-462N256DBNortheastern Gastroenterology Associates Pa · Summit Hill, PABuilt 1998 · S/N E-3081N25704Arrison Frank J · Doylestown, PABuilt 1973 · S/N E-475N25717Vaadi LLC · Babson Park, FLBuilt 1973 · S/N D-9542N25719Brunner Robert L · Jefferson, ORBuilt 1973 · S/N D-9540
Back to AD 87-18-06 R1