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.

N8265PNiemiec Andrew Josephtrustee · Anchorage, AKBuilt 1963 · S/N 24-3518N8265RMirrorstriker Aviation LLC · Tomball, TXBuilt 1972 · S/N 32-73N8265WRoy Kristi D · Burleson, TXS/N 28-2417N82665Schiestle Jason T · Greenville, PABuilt 1978 · S/N 18-7909026N82667Corfman Randle S · Lino Lakes, MNBuilt 1978 · S/N 18-7909028N82669Balcomb Mark S · Silt, COBuilt 1978 · S/N 18-7909029N8266EPropel Air LLC · Pottstown, PABuilt 1979 · S/N 17272156N8266JSumrall Olen · Tylertown, MSBuilt 1978 · S/N VAC-112-78N8266POtto David M · Gig Harbor, WABuilt 1963 · S/N 24-3519N8266WCraddock James E · Greensboro, NCBuilt 1965 · S/N 28-2419N8266YWerner Thomas E · Newark, DEBuilt 1966 · S/N 30-1394N82671Keleman Kenneth S · Bellingham, WABuilt 1976 · S/N 17266998N82676Accelerated Aviation Instruction LLC · Owatonna, MNBuilt 1980 · S/N 28-8116043N8267EFlippin Steven P · Oak Ridge, NCBuilt 1971 · S/N 171N8267NGallup Asa N · Morgan, TXBuilt 1969 · S/N 28-25480N8267YMh Aviation Inc · Lancaster, CABuilt 1966 · S/N 30-1395N82688Wells Flying Services LLC · Holdrege, NEBuilt 1977 · S/N 36-7960043N8268BMarinko Christopher M · Geneva, OHBuilt 1980 · S/N 28-8190040N8268CJk Aviation LLC · Austin, TXBuilt 1980 · S/N 28-8190041N8268ERegistration Pending · Richlands, NCRegistration pending, pending cancellationBuilt 1979 · S/N 17272158N8268HAirtime Aviation LLC · Chippewa Falls, WIS/N 28-8190043N8268NDawes Roger L · Bullhead City, AZS/N 28-25481N8268VMcs Inc · Loveland, COBuilt 1980 · S/N 32-8024050N8268WMontjar Andrew J · Shelby Township, MIBuilt 1965 · S/N 28-2421N8268YBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 30-1397N82692Piper Aircraft Inc · Vero Beach, FLBuilt 1977 · S/N 36-7960044N8269BJain Sharad S Trustee · Golden, COBuilt 1983 · S/N 28-8311002N8269EBucher Max · Fort Mohave, AZS/N 17272159N8269PEarley Douglas J · Covina, CABuilt 1963 · S/N 24-3522N8269ZMcelveen Thomas G Jr · Springfield, GABuilt 1980 · S/N 28-8116039N826ATAviation Training LLC · Wilmington, DEBuilt 2002 · S/N 4496148N826BSmith Darrin M · Torrance, CABuilt 1995 · S/N 22290N826CFHanekamp John W · Glen Carbon, ILBuilt 2001 · S/N T182-08091N826CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281264N826CVScott Roger A · Saint Croix Falls, WIBuilt 1979 · S/N R18201128N826DSouthall Charles A Trustee · Naples, FLBuilt 1977 · S/N 61P0399138N826DCSkyhawk Td LLC · Siloam Springs, ARS/N 20678N826DDRegistered aircraftBuilt 2004 · S/N T18208357N826DSSutton Douglas · Wichita, KSBuilt 2025 · S/N 02220236N826JWWills John L · Jasper, ALBuilt 2001 · S/N S1826N826KSPlanelease LLC · Venice, CABuilt 1999 · S/N 17280792N826MEEmrath Martin L · Brentwood, TNBuilt 2010 · S/N 25249N826MRWalthour William Charles · Seaside, ORBuilt 2005 · S/N 70381N826SASilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 3755N826SPGalaxy Aviation LLC · Nantucket, MAS/N 172S8739N826TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881705N826WDDavis Bruce D · Lufkin, TXBuilt 2019 · S/N 72455N826WRZachrich Julie A Trustee · Fremont, INS/N 67N8270JZephyr Enterprises Inc · Wilmington, DEBuilt 1978 · S/N VAC-116-78N8270NCloudsurfer LLC · Louisville, KYBuilt 1969 · S/N 28-25484
Back to AD 87-10-06 R1