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.

N99AWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N CE-420N99BDOcm Aviation LLC · Garner, NCBuilt 1977 · S/N E-1147N99BRAircorps Aviation LLC · Bemidji, MNBuilt 1980 · S/N E-1688N99DAAuburn Aero Holdings LLC · Auburn, INBuilt 1975 · S/N TH-619N99DGBrooks Conoly O III · San Angelo, TXBuilt 1978 · S/N CE-823N99JZUnadventurous LLC · Amarillo, TXBuilt 1984 · S/N TJ-474N99LFLake Air LLC · Jonesboro, ARBuilt 1981 · S/N TH-1261N99LGWashington Enterprises LLC · Little Rock, ARBuilt 1987 · S/N CE 1157N99MFly Buy LLC · Kalispell, MTBuilt 1972 · S/N CE-414N99MKHigh Mountain Healthcare LLC · Blairsville, GABuilt 1977 · S/N CE-742N99NPColonial Export Inc · Pompton Plains, NJBuilt 1976 · S/N E-809N99PAMckelvey Jeffrey R · Dadeville, ALBuilt 1978 · S/N TJ-179N99RFEcho Bravo Aviation LLC · Nashville, TNBuilt 1974 · S/N TH-463N99RKNorth Shore Flying Club · Libertyville, ILBuilt 1992 · S/N TH-1649N99RLThompson Nigel J · Ann Arbor, MIBuilt 1970 · S/N D-9108N99SBBonanza Service Ltd Co · Bethany, OKBuilt 1971 · S/N E-281N99TDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1991 · S/N TH1641N99VBC&S Aviation Partners LLC · Thibodaux, LABuilt 1980 · S/N EA-154N99VMDaniel M Skotte Do Pc · Sunriver, ORBuilt 1980 · S/N EA-140N99WPMarco Investments · Ripley, MSBuilt 1978 · S/N TH-958N99WTSudick Daniel · Dadeville, ALBuilt 2000 · S/N TH-1959N99ZXCecil Geoffrey · Punta Gorda, FLBuilt 1973 · S/N D-9530N9ABFirst Alarm Aviation LLC · Fosters, ALBuilt 1978 · S/N D-10175N9BNBrookfield Bonanza Corp · Menomonee Falls, WIBuilt 1982 · S/N E-2046N9DNMaxs Airplane LLC · Plano, TXBuilt 1973 · S/N D-9550N9DVNorwood Ronald Steven · Raleigh, NCBuilt 1981 · S/N EA-193N9DWJauch Robert J · Lyndonville, VTBuilt 1973 · S/N D-9436N9EPMcavian LLC · Perryton, TXBuilt 1981 · S/N TJ-378N9HGPoage Matthew L · Yukon, OKBuilt 1979 · S/N D-10244N9JFMontgomery David N · Knoxville, TNBuilt 1972 · S/N E-362N9LTRegistered aircraftBuilt 2001 · S/N TH-1989N9MPYen Albert S · Hermosa Beach, CABuilt 2002 · S/N E-3471N9NSTs&L Aircraft LLC · Alexandria, MNBuilt 1979 · S/N TJ-238N9RRN9rr Enterprises LLC · Lewes, DEBuilt 1994 · S/N CE-1785N9SHSenza Limiti LLC · Park City, UTBuilt 1980 · S/N EA-52N9TCSouthwestern Aviation LLC · Pueblo, COBuilt 1976 · S/N E-923N9YRMiller John F · Granby, COBuilt 1975 · S/N TE-1055N9YTYarberry Timothy C · Anderson, INBuilt 1997 · S/N E-3125
Back to AD 87-18-06 R1