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.

N4386TTango 86 LLC · Stuart, FLBuilt 1971 · S/N 28-7105221N4387JSparetime Aviation LLC · Belle Plaine, MNBuilt 1967 · S/N 28-22775N4387LAlways Double Down LLC · Palm Beach Gardens, FLS/N 3213015N4387TSkystat LLC · Forney, TXBuilt 1972 · S/N 28-7205155N43885Paris Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8516032N4388CAlbert Lea Airport Inc · Albert Lea, MNBuilt 1984 · S/N 28-8516021N4388JJohnson Kurt A · South Weber, UTS/N 28-22778N4388TClear Skies Aviation Inc · Montgomery, TXBuilt 1971 · S/N 28-7205156N43899Smtm Holdings Inc · Wilmington, DEBuilt 1985 · S/N 28-8516033N4389FFarooqi Muhammad M · Plano, TXS/N 28-7725013N4389TBurchett James W · Seabeck, WABuilt 1972 · S/N 28-7205157N4389VLeonard Nicholas Robert Eugene · Monument, COBuilt 1985 · S/N 28-8590028N4389XRrg Software LLC · Alpine, CAFirst renewal noticeBuilt 1975 · S/N 28R-7635034N438FDFly Dynasty Corp · Ocala, FLBuilt 1967 · S/N 28-24061N438GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881178N438RMRocky Mountain College · Billings, MTBuilt 2019 · S/N 2881095N438SLGriffith Aviation Inc · Griffith, INBuilt 1979 · S/N 28-7916276N4390JIsch Carl J · Geneva, INBuilt 1967 · S/N 28-22780N4390SCandace A Larned Enterprises Inc · Long Beach, CABuilt 1985 · S/N 28-8516031N4390WWurster Gregory J · Creston, IABuilt 1986 · S/N 32R-8629005N4391FNorcal Flight Club · Vacaville, CABuilt 1976 · S/N 28-7715030N4391JAvian Leasing LLC · Bremerton, WABuilt 1967 · S/N 28-22781N4391XLyman Gregory B · Fiddletown, CABuilt 1975 · S/N 28-7615003N4392JOrtega Rene · Seaside, ORBuilt 1967 · S/N 28-22783N4392XMountain View Aviation Inc · Honesdale, PABuilt 1975 · S/N 28-7690004N4393FCloutier Donald P · Waldorf, MDBuilt 1976 · S/N 28-7715031N4393TJackson R Allen · Granbury, TXBuilt 1972 · S/N 28R-7235030N4393XGriffin David R · Amarillo, TXBuilt 1975 · S/N 28R-7635035N43948Jl3 Aviation LLC · Blue Springs, NEBuilt 1977 · S/N 28-7890030N4394FPacific Piper LLC · Washougal, WABuilt 1976 · S/N 28-7715032N4394TLinden'S Aviation LLC · Lagrange, OHBuilt 1972 · S/N 32-7200020N43954Georgetown Aircraft Rental Inc · Granger, TXBuilt 1977 · S/N 28-7890032N43956Freeflight Aviation LLC · Allentown, NJBuilt 1977 · S/N 28-7890033N43957Ocbc Ventures Aviation LLC · Los Angeles, CABuilt 1977 · S/N 28-7890034N43959Explore Gourmet LLC · Wyandanch, NYBuilt 1977 · S/N 28-7890035N4395JR W Dow Corp · Garrison, NYBuilt 1967 · S/N 28-22786N43966Sims Kenneth Leon · Desert Hot Springs, CAS/N 28R-7737139N43967Jo Air Inc · La Mesa, CABuilt 1977 · S/N 28R-7737140N4396JSunshine Flight Services LLC · Dayton, TNBuilt 1967 · S/N 28-22788N4396TBanman David P · Seminole, TXS/N 28-7225162N43970Arrow N43970 LLC · Derry, NHBuilt 1977 · S/N 28R-7703321N43977Air Kraft Spraying Inc · Timber Lake, SDBuilt 1977 · S/N 32R-7780534N4397JBeers Ward J · Shirleysburg, PABuilt 1967 · S/N 28-22789N4397XC & D Media LLC · Lees Summit, MOS/N 28-7615004N43983Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N 28-7890038N43984New England Flyers LLC · Franklin, MAS/N 28-7890039N4398JAberle Jerry L · Fallbrook, CAS/N 28-22790N43994Harrison Shawn · Salisbury, MDBuilt 1977 · S/N 28R-7703327N43998Tailwind Aviation LLC · Royersford, PABuilt 1977 · S/N 32-7740105N4399XDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 28-7615006
Back to AD 87-08-08 R3