OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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-08-08-R3')
    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-08-08-R3')
  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.

N3058TN3058t LLC · Cheyenne, WYBuilt 1979 · S/N 28R-7918062N3059BBay De Noc Flying Club Inc · Escanaba, MIBuilt 1978 · S/N 28-7990138N3059FAtwell Charles A · Eldred, NYBuilt 1969 · S/N 28-25760N3059RTimes Arrow LLC · Highland, MDBuilt 1969 · S/N 28R-35620N3059SRatte Clifford H · Gulf Breeze, FLBuilt 1979 · S/N 28R-7918061N3059ZHo Chris · Weymouth, MABuilt 1979 · S/N 28R-7918123N305MCShen Air II Inc · Mount Crawford, VABuilt 1973 · S/N 32-7340118N305MDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020255N305NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881616N305UMParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020051N305VPGaskins Patrick A · Fort Lauderdale, FLS/N 32R-7780321N30602Reinert Joseph M · Ringgold, GAS/N 28-8011055N3060BPrestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1978 · S/N 28-7990139N3060FEl Paso Aero Inc · El Paso, TXBuilt 1978 · S/N 28-7990227N3060LLang Scott T · Waseca, MNBuilt 1979 · S/N 28-7916251N3060RArrow N3060r LLC · Sheridan, WYBuilt 1969 · S/N 28R-35621N3060TPalumbo Henry R · Novato, CABuilt 1979 · S/N 28R-7931087N3060YB&D Flight Club LLC · Portage, INBuilt 1979 · S/N 28-7916370N3061RCohns Willie · Elizabethtown, KYBuilt 1969 · S/N 28R-35622N3061TAdventure Lab Aviation LLC · Saint George, UTBuilt 1979 · S/N 28R-7931088N3061WCcn Air LLC · Bloomington, INBuilt 1979 · S/N 32-7940079N3061YHott Steven A · Kokomo, INBuilt 1979 · S/N 28-7990388N3062LMerino Rodrigo R · Chilton, WIBuilt 1979 · S/N 28-7916252N3062RBuddys Aviation LLC · East Bernstadt, KYBuilt 1979 · S/N 32R-7985084N3062WD M Aviation II Llp · Park River, NDBuilt 1979 · S/N 32-7940080N3062YSwaringen Jeanne A · Lakeside, CABuilt 1979 · S/N 28-7990389N3063NConstantinides Chris · Chula Vista, CABuilt 1979 · S/N 28R-7931058N3063RGrant Scott A · Santa Barbara, CABuilt 1969 · S/N 28R-35624N30640Christianson Cleet M · Enumclaw, WABuilt 1978 · S/N 28R-7803369N30647Registration Pending · Diamondhead, MSRegistration pendingBuilt 1978 · S/N 28-7816545N30650Elite Flight Training And Aircraft Management LLC · Kankakee, ILBuilt 1978 · S/N 28-7916089N3065BVanator John D · Eaton Rapids, MIBuilt 1978 · S/N 32R-7987043N3065CVenture West LLC · Mesa, AZBuilt 1978 · S/N 28-7990152N3065KBowles William Jr · New Richmond, OHBuilt 1978 · S/N 28R-7918003N3065RFlavin Patrick J · Woodbridge, VABuilt 1969 · S/N 28R-35626N3065ZDreiling Alexander R · Queen Creek, AZBuilt 1979 · S/N 28R-7918124N30662Jandair LLC · Ennis, TXBuilt 2004 · S/N 3255023N3066GAstro Aviation LLC · Cross Plains, TNBuilt 1978 · S/N 28-7990197N3066HLarsen Mark S · Spencer, IABuilt 1978 · S/N 28-7916219N3066KQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 28R-7918005N3066RParker Michael A · Milwaukee, WIBuilt 1969 · S/N 28R-35628N3066UAjh Aviation LLC · Monroe, LABuilt 2004 · S/N 3257341N3066YQuiett Aaron Trustee · Hillsboro, ORS/N 28-7990392N3066ZBate Edward F III · Rhome, TXBuilt 1979 · S/N 28R-7918125N3067DLawson Roger E · Elizabethtown, KYBuilt 1978 · S/N 28-7916159N3067KLynch Alan J · Auburn, WABuilt 1978 · S/N 28R-7918006N3067QKpw Enterprises Inc · Chula Vista, CABuilt 1977 · S/N 32R-7780279N3067RSmith Julia L · Big Bear City, CABuilt 1969 · S/N 28R-35627N30689Pung Larry J · Hermitage, TNBuilt 1978 · S/N 32R-7885282N3068QTurbo Arrow IV LLC · Nibley, UTBuilt 1979 · S/N 28R-7931074
Back to AD 87-08-08 R3