AD 87-10-06 R1

Registered aircraft · 72,010

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-10-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-10-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.

N842PWalker Vince · Boulder, COBuilt 1998 · S/N 061N842PTTemple Peter L · Harrisville, NHBuilt 2022 · S/N 67PN842RBLowcountry Flight LLC · Johns Island, SCBuilt 1969 · S/N 17258377N842SHSilver Star Helicopters LLC · El Campo, TXBuilt 2005 · S/N 3819N842SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 172S8747N842SVPylon Aviation Services LLC · Chandler, AZBuilt 1983 · S/N 0366N842TAkin Air LLC · Monticello, ARBuilt 1960 · S/N TD-355N842TCWitte Transport LLC · West Plains, MOBuilt 2000 · S/N 18280841N84309Mcgee David · West Monroe, LABuilt 1969 · S/N 17258417N8430BTrident Aviation LLC · Bedford, NHBuilt 1981 · S/N 32R-8129097N8430DBottorff Marshall B · Kimberling City, MOBuilt 1957 · S/N 22-5685N8430RRegistration Pending · Calera, OKRegistration pendingBuilt 1966 · S/N 28-22309N8430WZuber Thomas P · Opelika, ALBuilt 1965 · S/N 28-2660N8430YDavid Litteken · Aviston, ILBuilt 1967 · S/N 30-1588N84316Smith Jimmy C · Plano, TXBuilt 1969 · S/N 17258419N84317Waco West Inc · Dover, DEBuilt 1969 · S/N 17258420N8431LDsr Cherokee 180 LLC · Dallas, TXS/N 17256631N8431WAhearn Bernard Francis · Farmington, NHS/N 28-2661N8431YN8431y LLC · Coatesville, INBuilt 1967 · S/N 30-1589N8432Himsl Vincent S · Mattawa, WABuilt 2008 · S/N 80296N84326Yang Edward E · Killeen, TXBuilt 1981 · S/N 28-8116313N8432BClaxton David R · Cookeville, TNBuilt 1981 · S/N 32R-8113112N8432CEmpire Aviation · Oxford, NCBuilt 1976 · S/N 28-7625117N8432LAster Labs Inc · Shoreview, MNBuilt 1968 · S/N 17256632N8432WBinek Darwin P · Midlothian, TXBuilt 1965 · S/N 28-2662N8432YTaylor Kyle F · Enterprise, ALBuilt 1967 · S/N 30-1591N84330Blanche-Caron Elie P · Palmer, AKBuilt 1969 · S/N 17258421N84332Engler Jerry J · Kerrville, TXBuilt 1969 · S/N 17258422N84333Backup Enterprises LLC · Conway Springs, KSBuilt 1969 · S/N 17258423N84337Kent East Inc · Wilmington, DES/N 32R-8129104N84338Jrh Wings LLC · Alva, OKS/N 17258426N84339Burnt Pond Aero LLC · Ostrander, OHBuilt 1969 · S/N 17258427N8433AWoods Todd Ryan · Perry, OKBuilt 1981 · S/N 32-8124032N8433LHeacock Jeffrey A · Hollis, MEBuilt 1968 · S/N 17256633N8433RRichards Riley · Seattle, WABuilt 1966 · S/N 28-22313N8433WKilduff James L · Wellsboro, PABuilt 1965 · S/N 28-2663N8433YLomeli Rigoberto Orozco Jr · Longs, SCBuilt 1981 · S/N 32R-8129101N84342Choate Aviation LLC · Summerville, SCBuilt 1969 · S/N 17258429N84346Registration Pending · New Derry, PARegistration pendingS/N 17258433N84347Giovannini Marco · Malibu, CABuilt 1969 · S/N 17258434N8434DAllen Clifford R · Indianapolis, INBuilt 1957 · S/N 22-5689N8434EWiborg Eric J · Fort Lauderdale, FLBuilt 1989 · S/N 99N8434LMemmi Charles D · Three Springs, PABuilt 1968 · S/N 17256634N8434RPeoples John R Jr · Hixson, TNS/N 28-22314N8434WAlpha-One Air Service LLC · Concord, NCBuilt 1965 · S/N 28-2664N84350Piecko Michael T · Genoa, ILBuilt 1981 · S/N 28-8290006N84351Stanton James W · Maple, NCBuilt 1969 · S/N 17258436N84352Boundless Aviation LLC · Kailua Kona, HIBuilt 1969 · S/N 17258437N84358Child Michael A · Fort Worth, TXBuilt 1969 · S/N 17258440N8435DOrbis Advisory Services LLC · Hebron, KYBuilt 1981 · S/N 28-8290001
Back to AD 87-10-06 R1