OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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.

N7734CAstillero Ricardo · Northfield, NJS/N 28-7690079N7734JB & B Aviation LLC · Wilmington, DES/N 32-1137N7734NStewart Duncan · Long Beach, CABuilt 1968 · S/N 28-5177N7734WBrown Tyler M · Cary, NCBuilt 1964 · S/N 28-1742N7735JPhilpot Jason A · Somerville, TNBuilt 1969 · S/N 32-1138N7735NMelanson Wayne L · Liberal, KSBuilt 1968 · S/N 28-5180N7736CSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1975 · S/N 28R-7635116N7737JVir Inc · West Bend, WIS/N 32-1140N7737NKoch Michael R · Nemo, SDBuilt 1968 · S/N 28-5181N7737WGt Air LLC · Burton, OHBuilt 1964 · S/N 28-1745N7738JAzuyak Tony Jr · Kodiak, AKS/N 32-1141N7738NBluegrass Aviation LLC · Springdale, ARBuilt 1968 · S/N 28-5182N7738WFlying Turtle Management LLC · Ellicott City, MDBuilt 1965 · S/N 28-2915N7739NSenia John A · Berlin, CTBuilt 1968 · S/N 28-5183N773FTRatte David R · W Melbourne, FLBuilt 2000 · S/N 2844030N773GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881221N773NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881038N7740JEbm Management LLC · Canadian, TXBuilt 1969 · S/N 32-1143N7740NLenderman Steven E · Sharpsburg, GABuilt 1968 · S/N 28-5184N7740UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020279N7740WReiger Roger L · Lafayette, INBuilt 1964 · S/N 28-1748N7741JPiper Mac 3 LLC · Dover, DES/N 32-1144N7741NBrindle Richard L · Pleasant Hall, PABuilt 1969 · S/N 28-5186N7742JAirmore Inc · Gainesville, FLBuilt 1969 · S/N 32-1146N7742NDistler Robert · Northborough, MAS/N 28-5188N7742WDupont Micheal Rene · East Taunton, MABuilt 1964 · S/N 28-1751N7743NRegistered aircraftBuilt 1968 · S/N 28-5144N7743WAtigun Aviation LLC · Sheridan, WYBuilt 1964 · S/N 28-1752N7744TDickert Investments Holdings LLC · Cave Creek, AZBuilt 1968 · S/N 28-24073N7744WShotwell Michael · Dallas, GABuilt 1964 · S/N 28-1754N7745NAppealing Adventures Inc · Canadensis, PABuilt 1968 · S/N 28-5189N7745WSchaff Investments LLC · Stone Mountain, GABuilt 1964 · S/N 28-1755N7746FWilliams Dwight J · Wichita, KSBuilt 1976 · S/N 28-7725105N7747NShumock Jerry Ray · Moss Point, MSBuilt 1968 · S/N 28-5191N7747WFlying Family LLC · Orlando, FLBuilt 1964 · S/N 28-1757N7748JBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 32-1152N7749FLohr Martin J · Petersburg, AKBuilt 1976 · S/N 28-7725106N7749JKokomo Aviation Inc · Boynton Beach, FLBuilt 1969 · S/N 32-1153N7749NTeijeiro Edgar E Trustee · El Paso, TXBuilt 1968 · S/N 28-5194N774CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881763N774FSHilty Kenneth C · Greensboro, NCBuilt 2000 · S/N 3257192N774LLLedet Corp · Houma, LABuilt 2003 · S/N 3246213N774LRCampbell Jeffrey R · Surprise, AZBuilt 1974 · S/N 28R-7435297N774LSDroge John W · Sisters, ORBuilt 1977 · S/N 32-7840004N774NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881042N774PCHarrell Brian · Auburn, ALBuilt 1973 · S/N 28-7405018N7751WSmith Derek D · Portland, ORS/N 28-1719N7752NCote Daniel A · Montpelier, VTS/N 28-5197N7752WCavender John S · Centerville, MDBuilt 1964 · S/N 28-1728N7753NSonner Michael J · Golden, COBuilt 1968 · S/N 28-5198
Back to AD 87-08-08 R3