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.

N8897NAnderson Leroy H · San Angelo, TXBuilt 1969 · S/N 28-25761N8897PFey Ray D · Middleton, WIBuilt 1965 · S/N 24-4351N8897YAvion LLC · Lewes, DEBuilt 1970 · S/N 39-54N8898DWelty Donald Robert Jr · Glennallen, AKBuilt 1958 · S/N 18-6374N8898JColt 45 LLC · Tulsa, OKS/N 28-2874N8898NTaylor Danny H · Defuniak Springs, FLBuilt 1969 · S/N 28-25762N8898WWade Harry Jr · Helotes, TXBuilt 1964 · S/N 28-10462N8898YWickenheiser Kenneth W · Sun City, AZBuilt 1970 · S/N 39-33N8899ERgp Aviation LLC · Wilmington, DES/N 28-7690215N8899LSujet Dylan P · Hampton, NJBuilt 1974 · S/N AA5-0698N8899PLavoie Paul · Macon, GAS/N 24-4353N8899YSture Joel M · Anchorage, AKBuilt 1974 · S/N 18-7409031N889ACKdx Air Ventures LLC · Naples, FLS/N 60-8423024N889DQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N AA5B-0706N889DALeik Aviation LLC · Dousman, WIBuilt 2023 · S/N 80814N889EHMillhouse Eric L · Cheyenne, WYBuilt 2002 · S/N 1184N889FNe Ia Helicopter LLC · Tekamah, NEBuilt 2016 · S/N CC19-0010N889GSKlock Dexter F · Driggs, IDBuilt 2000 · S/N 853-99N889JDByxbee John · Greenville, SCBuilt 1981 · S/N 28-8111061N889MHExtreme Helicopter Service LLC · Alice, TXBuilt 2001 · S/N 3160N889SCCrawford Stevan L · Woodinville, WABuilt 2005 · S/N 2476N889TJvs LLC · Santa Rosa, CABuilt 1957 · S/N 18-5540N889TTFlying Farmer LLC · Wilmington, DEBuilt 2018 · S/N 087N889ZMaule N889z Inc Trustee · Wilmington, DEBuilt 2009 · S/N 30044CN88ABBrown James L · Athens, ALBuilt 1973 · S/N 17262739N88ACSegerstrom William C · Sunriver, ORBuilt 1965 · S/N TD-621N88AKState Of Alaska · Anchorage, AKBuilt 1965 · S/N 18-8311N88APLangdon Brian B · Newcastle, WABuilt 1964 · S/N 30-456N88AVN88av LLC · Fort Myers, FLS/N 525N88BELee George M · Queen City, TXBuilt 1988 · S/N 1317N88BSBachman Jared R S · Elbert, COBuilt 1981 · S/N 2N88BWRegistered aircraftBuilt 1976 · S/N 817N88CMTurner Ronald A · Tulsa, OKBuilt 1974 · S/N 61-0150-080N88CTCameron John W · Canby, ORS/N 882N88CVAllen David L · Sturgis, SDBuilt 1999 · S/N 80327N88CXChamplin Aviation LLC · Kerens, TXBuilt 1974 · S/N 61P-0160-002N88DAAnderson Darin D · Eatonville, WABuilt 2021 · S/N 41667N88DEMatta Figueroa Eduardo · Chapman, KSBuilt 1959 · S/N 23-1618N88DKPitts Cabot J · Palmer, AKBuilt 1977 · S/N 7088CN88DRAkerson Charles J · Clarksville, TNBuilt 1965 · S/N 3170N88EStarlite Aviation Technologies LLC · Las Vegas, NVBuilt 1973 · S/N 17261476N88EFPeyton Craig L · Rhinebeck, NYBuilt 1979 · S/N 24-0815N88ETGelfan Russell A · Bellingham, WABuilt 1980 · S/N 202N88EWAviat Aircraft Inc · Afton, WYBuilt 1985 · S/N 5073N88FVandivort Aaron · Jacksonville, FLBuilt 1959 · S/N 24-1245N88FBGeary Travis S · Viroqua, WIBuilt 1975 · S/N 28-7510108N88FCSandlapper Aviation Of De Inc · Bennington, VTBuilt 1998 · S/N 80061N88FNSaline County Flyers Association LLC · Little Rock, ARBuilt 1969 · S/N 28-26119N88GEGothreaux William A · Deridder, LAS/N 1934N88GGSchneck Doreen Trustee · Albany, GABuilt 1970 · S/N 3
Back to AD 87-10-06 R1