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.

N9153ZDanam Aviation LLC · Queen Creek, AZBuilt 1996 · S/N 27-0209N9154PSloan James M Trustee · Grandbury, TXBuilt 1966 · S/N 24-4640N9154YNolan Daniel R · Wilmington, NCBuilt 2001 · S/N 18280971N91553Simpson Josiah J L Trustee · Shelburne, MABuilt 1973 · S/N 17261500N9155CN9155c LLC · Palm Harbor, FLBuilt 1978 · S/N R18200427N9155DTaylor Glenn Maurice · Fayetteville, GABuilt 1958 · S/N 22-6207N9155FMahoney Michael K · Neillsville, WIBuilt 1994 · S/N 27-0185N9155PRegistered aircraftBuilt 1966 · S/N 24-4641N9155VHickox Joseph C · Rollins, MTBuilt 1969 · S/N 690032N9155WWiger Theodore L · Falcon Heights, MNBuilt 1966 · S/N 28-10787N9156DTalmadge Jeffery K · New Milford, CTBuilt 1958 · S/N 22-6208N9156HSolar Flying Club · Grimes, IABuilt 1975 · S/N 17265981N9156JChristian Family Fellowship · Mesa, AZS/N 28-3213N9156SStickley Harold R · Wauseon, OHBuilt 1976 · S/N MC-401N9156VLegnaioli Richard · Cambridge, MDS/N 690013N9156YRegistered aircraftBuilt 1992 · S/N 27-0141N9156ZEdney James A Md · Omaha, NEBuilt 1992 · S/N 27-0142N9157CAims Community College · Greeley, COBuilt 1978 · S/N R18200429N9157EWillard James L · Prosser, WABuilt 1977 · S/N 7114CN9157JAkn Inc · Crystal, MNFirst renewal noticeBuilt 1992 · S/N 27-0131N9157PN9157p LLC · Mason, MIBuilt 1966 · S/N 24-4643N9157SAdverse Yaw LLC · Albuquerque, NMBuilt 1994 · S/N 27-0181N9157WFear David L · Hartford City, INBuilt 1966 · S/N 28-10773N9158CSmith Robert A · Stillwater, OKBuilt 1978 · S/N R18200430N9158E7 J Aeroflight Publications Inc · Gruver, TXBuilt 1977 · S/N 7115CN9158HParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1975 · S/N 17265982N9158VMellinger David S · Lusby, MDBuilt 1969 · S/N 690040N9158WKirkhoff Robert A · Pottstown, PABuilt 1966 · S/N 28-10832N9158YLockwood Rick I · Garden Grove, CAS/N 18-8911N91596West Michigan Flying Club Inc · Norton Shores, MIBuilt 1973 · S/N 17261505N9159CConlon James E III · Longmont, COBuilt 1996 · S/N 27-0223N9159HHess Garrett · Fullerton, CAS/N 17265983N9159KRoss Andrew · Yamhill, ORBuilt 1976 · S/N 28R-7635223N9159NBoeing Co · Renton, WABuilt 1971 · S/N 3113N9159VSmith Darryl Edward · Houston, TXS/N 690033N9159WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 28-10778N915AJb Efta Farms Inc · Argyle, MNFirst renewal noticeBuilt 1951 · S/N 22-218N915AZN915az LLC · Miami, FLBuilt 1974 · S/N 34-7450199N915CMVaayu Aviation LLC · Newark, CABuilt 1972 · S/N 17261229N915CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8335N915GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881073N915GWWills Gary W · Channahon, ILBuilt 2012 · S/N 71267N915HPAnderson Austin C · Washington, DCBuilt 1966 · S/N 24-4371N915JBKruger Karl A · Monterey, TNBuilt 2018 · S/N 73660N915JCCannata Jack P · Roselle, ILBuilt 2000 · S/N 14674N915JDDowling Jeffrey T · Poplar Grove, ILBuilt 2003 · S/N 20098N915JTLd Aviation LLC · Durango, COBuilt 2005 · S/N T18208444N915KKKramer Kurt J · Volcano, CABuilt 2022 · S/N 25744N915LCardinal Flying Corp · San Jose, CABuilt 1976 · S/N 17267355N915LFLingo Joshua B · Oak Grove, LABuilt 1998 · S/N 390-98
Back to AD 87-10-06 R1