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.

N87CA200 Knots LLC · Dover, DEBuilt 1983 · S/N TH-1382N87JSLvyqt LLC · Menlo Park, CABuilt 1988 · S/N EA-476N87MJBerdan Curtis A · Sterling Heights, MIBuilt 1972 · S/N TH-259N87MTThompson John Stuart · Dallas, TXBuilt 1978 · S/N CE-771N87RGCannon William C Jr · Concord, NCBuilt 1998 · S/N TH-1886N87RRBahnair LLC · Oklahoma City, OKS/N TJ-34N87SM10269 Flight LLC · Bainbridge Island, WABuilt 1990 · S/N TH-1587N880CANspace LLC · Spicewood, TXBuilt 1973 · S/N TE-934N8816XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N CE-489N881HMiller Leonard L · Houston, TXBuilt 1972 · S/N TE-883N881SRegistration Pending · Sulphur Rock, ARRegistration pendingBuilt 1973 · S/N CE-454N882CCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1989 · S/N CE1345N882CTCharlie Tango Aviation LLC · Rocklin, CABuilt 1990 · S/N E-2566N882MTGta Air Inc · Addison, TXBuilt 1982 · S/N TH1343N8833AChrzanowski Sigmund J Trustee · Hampshire, ILBuilt 1982 · S/N CE-976N887ACBrg Enterprises LLC · Johns Island, SCS/N TH-603N887BMNewman Matthew · Warwick, NYBuilt 1997 · S/N E-3122N887CAHerron Joe D · Burnet, TXBuilt 1976 · S/N E-864N887JKHenry Joseph · Paris, TXS/N E-3586N888AOlivia Aviation LLC · Plymouth, MNBuilt 2000 · S/N E-3304N888AERegistered aircraftBuilt 1978 · S/N E-1323N888DBEastern Stearman Inc Trustee · Leesburg, VAS/N D10076N888HDPham Doug · Irvine, CABuilt 1977 · S/N CE-748N888HPGreen Mountain State Aviation LLC · Cornwall, VTBuilt 1988 · S/N CE-1302N888JRJones & Weaver Pc · Wheatland, WYBuilt 1978 · S/N E-1241N888MBsa Vending · Rohnert Park, CABuilt 1981 · S/N EA-262N888MZM-Z Aviation LLC · Birmingham, ALBuilt 1988 · S/N E-2417N888NEFarmex Land Mgmt Inc · Sanger, CABuilt 1981 · S/N D-10367N888SK5 Aviation LLC · Las Vegas, NVBuilt 1976 · S/N D-9937N889FTMolly Willis Ventures LLC · Albany, GABuilt 1997 · S/N TH-1828N889JSMoran Consulting Corp · Long Beach, CABuilt 1974 · S/N D-9579N889SEasy Air LLC · Wilmington, DEBuilt 1984 · S/N E-2138N889TSQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N TJ281N88ANJk Manufacturing Co · Wilmington, DES/N CE-1700N88BAir Taco LLC · Virginia Beach, VABuilt 1982 · S/N E-2036N88BPPlane LLC · Worcester, MABuilt 1993 · S/N E-2780N88BVCarr Phillip E · Cave Creek, AZBuilt 1977 · S/N D10060N88CJLyman Michael R · Lake Oswego, ORBuilt 1977 · S/N E-1042N88CLHarp Robert P · Houston, TXBuilt 1988 · S/N CE-1225N88ESChapman Kevin J · Williston, NDBuilt 1975 · S/N E-758N88EZMusack Randy A · Butternut, WIBuilt 2000 · S/N E-3364N88MBLebanon Aviation Inc · Mount Juliet, TNBuilt 1971 · S/N TE844N88PRValley River Leasing Inc · Murphy, NCBuilt 1995 · S/N E-2982N88RRegistration Pending · Wilmington, DERegistration pendingBuilt 1973 · S/N D-9475N88TJCooley Bridget A · Seattle, WABuilt 1988 · S/N CE-1256N88TSWrb Aircraft LLC · New York, NYBuilt 1988 · S/N E-2409N8911XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1998 · S/N E-3166N892JHMaitland Property Management LLC · Plano, TXBuilt 2000 · S/N E-3323N892WWWasserburger John C · Collierville, TNBuilt 1992 · S/N CE-1694N8933Walthers John P · Mequon, WIBuilt 1989 · S/N CE-1384
Back to AD 87-18-06 R1