OpenAirDocs.org
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.

N3904WEyler Neale · Goddard, KSBuilt 1966 · S/N 32-850N3904XMoore Jeremy E · Baton Rouge, LABuilt 1975 · S/N 28R-7535347N3904ZHorney Paul E · Fort Sumner, NMBuilt 1961 · S/N 18-7717N3905FAsadoorian Todd · Arlington, TNBuilt 1976 · S/N 28-7625269N3905MTaro Brian James Trustee · Ketchikan, AKS/N 12-2585N3905QH&H Cloudbase Aviation LLC · Carlsbad, CAS/N 17260005N3905TSmooth Air LLC · Tampa, FLBuilt 1967 · S/N 28R-30239N3905XClingan James W Jr · Finksburg, MDBuilt 1975 · S/N 28-7515429N3906PJb Efta Farms Inc · Argyle, MNS/N 22-3575N3906WRegistered aircraftBuilt 1966 · S/N 32-852N3907KMcmanamin Conor P · Anchorage, AKBuilt 1961 · S/N 18-7543N3907WParks Craig W · Stephenville, TXBuilt 1967 · S/N 32-915N3908FRegistration Pending · Anchorage, AKRegistration pendingBuilt 1976 · S/N 28-7615431N3908QShamrock Flying Service LLC · Denver, COBuilt 1971 · S/N 17260008N3908TAustin Christopher · Dayton, NVBuilt 1967 · S/N 28R-30243N3908ZWiederkehr Air Inc · Palmer, AKBuilt 1961 · S/N 18-7721N3909CJames Eric A · Claremore, OKBuilt 1968 · S/N 17257032N3909KRada Norman · Hagerstown, MDBuilt 1967 · S/N 28-23776N3909QAdventure Seaplanes LLC · Tower, MNBuilt 1971 · S/N 17260009N3909TAnnis Aviation LLC · Gray, GABuilt 1967 · S/N 28R-30244N3909WMargolien Brooks · Orange, MABuilt 1967 · S/N 32-855N390ACEtcheverry Raymond L · Sunriver, ORS/N 491-2006N390ASOcala Aviation Services Inc · Ocala, FLS/N 27-3117N390CCKenmore Air Harbor LLC · Kenmore, WABuilt 2002 · S/N 9944CCN390MEMccabe Eugene · Fremont, CABuilt 2000 · S/N 18280862N390MFDavies Thomas N · Anacortes, WABuilt 2003 · S/N 0039N390MSStack Brian James · Paso Robles, CABuilt 1981 · S/N 32-8106048N390TCD & J Aviation LLC · Apopka, FLBuilt 2007 · S/N 2842290N390TTOlsoe Jonathan · Eagle, IDFirst renewal noticeBuilt 2008 · S/N 5601N390UChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496025N390WWalter Paul F · Milwaukee, WIBuilt 1970 · S/N 39-39N390XNovak Matt E · Port Orchard, WABuilt 1976 · S/N 7028CN3910NStratus Aviation Group LLC · Washington, DCBuilt 1968 · S/N 680058N3910TSpeelman Jonathan D · Stockton, CABuilt 1967 · S/N 28R-30245N3910UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842220N3910ZHudson Ollie C · Talkeetna, AKBuilt 1961 · S/N 18-7726N3911QTraining Planes LLC · Tampa, FLBuilt 1971 · S/N 17260011N3911TMartin Aviation Services LLC · Bay City, MIS/N 28R-30246N3912MGateway Flight Training LLC · Saint Louis, MOBuilt 1978 · S/N 28-7816385N3912NChiwaya Brandon · Philadelphia, PABuilt 1968 · S/N 680059N3912WFrankie Dixon · Cookeville, TNBuilt 1967 · S/N 32-858N3912XN3912x Holdings LLC · Sarasota, FLBuilt 1975 · S/N 28-7525337N3913TPetit Randy F Jr · Ama, LABuilt 1967 · S/N 28R-30249N3913XDesert Flight Academy Inc · Henderson, NCBuilt 1975 · S/N 28R-7535350N3914KErmis Aviation LLC · Coleman, WIBuilt 1967 · S/N 28-23782N3914MNatwick Micah E · Anchorage, AKS/N 12-2812N3914NBradford Michael G · San Jose, CABuilt 1968 · S/N 680060N3914POrtiz Fernando Mark · Squaw Valley, CAS/N 22-3584N3914QAmerican Patrol Inc · Midland, TXBuilt 1971 · S/N 17260014N3914TBias Lee · Weston, FLS/N 28R-30961
Back to AD 87-10-06 R1