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.

N8493FCharles City Aeronautics Inc · Charles City, IABuilt 1976 · S/N 28-7715275N8493RCapital City Flyers LLC · Thomasville, GABuilt 1966 · S/N 28-22405N8494FPlane Viewing LLC · Colbert, WABuilt 1976 · S/N 28-7790252N8494RCactus Air Gold LLC · Mesa, AZBuilt 1966 · S/N 28-22406N8495CMtl Inc · Sparta, TNBuilt 1976 · S/N 32R-7680119N8495FKing Robert M · Fall River Mills, CABuilt 1976 · S/N 28-7790253N8495WSensenig Landis · Owen, WIBuilt 1965 · S/N 28-2741N8496FSoriano Juan H · Travelers Rest, SCBuilt 1976 · S/N 28-7790254N8496WKnapp Richard M · Dallas, TXBuilt 1965 · S/N 28-2742N8497WAndrews James E Jr · Cantonment, FLBuilt 1965 · S/N 28-2744N8498FJones Teddy · Sevierville, TNS/N 32R-7780105N8498RLangeland Carrol · Menno, SDBuilt 1966 · S/N 28-22410N8498WPetry Scott A · Greenfield, INBuilt 1965 · S/N 28-2740N8499FArrow Inc · Rockford, MIBuilt 1976 · S/N 32R-7780106N8499RZoss Curtis · Pensacola, FLBuilt 1966 · S/N 28-22411N8499WNazif Ziad J · Denver, NCBuilt 1965 · S/N 28-2747N849AAAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881849N849BTPeacock Group LLC · Clermont, FLBuilt 1974 · S/N 28R-7535095N84ARArc Aviation LLC · Auburn, ALBuilt 1977 · S/N 28R-7737099N84AUCapital Holdings 242 LLC · Newark, DES/N 3257464N84EBHodge Joseph Randall · Brenham, TXBuilt 1978 · S/N 32-7840173N84KAEpix Air LLC · Worthington, MNBuilt 1981 · S/N 32R-8129052N84KLSpitfire-173 & Partners LLC · New Bern, NCBuilt 1999 · S/N 3246128N84LAMav Air LLC · Rigby, IDBuilt 1980 · S/N 32R-8029102N84SSHoffman Thomas A- Trustee · Emmett, KSBuilt 1980 · S/N 32R-8013101N84WPJayanthi Venkata R · Columbus, OHBuilt 1978 · S/N 28-7911035N84WTAndreotti Mark C · Colusa, CABuilt 2004 · S/N 3255021N8502NDickman Edward A · Melba, IDBuilt 1971 · S/N 32-7140052N8502WWinker Kurt F · Los Lunas, NMBuilt 1963 · S/N 28-10003N8503EB&B Aviation Holdings LLC · Pembroke Pines, FLBuilt 1976 · S/N 28-7690175N8503NKirkland Joseph Talmadge III · Memphis, TNBuilt 1969 · S/N 28-11223N8504NArchuleta Michael E · Jenks, OKBuilt 1969 · S/N 28-11246N8505NMahffey Gary L · Parachute, COBuilt 1969 · S/N 28-11247N8505WMcnamara Kevin Jr · East Aurora, NYBuilt 1963 · S/N 28-10006N8506NTiller Aviation LLC · Omaha, NES/N 28-11248N8506WWestenburg Garrett V · Porter, TXBuilt 1963 · S/N 28-10007N8508CHobart Aviation Inc · Akron, OHBuilt 1976 · S/N 28R-7635164N8509CMaxwell Samuel L · Wasilla, AKBuilt 1976 · S/N 32-7640066N8509WMoreno Rodrigo S · Phoenix, AZS/N 28-10010N850FSParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020072N850NCRegistered aircraftBuilt 2002 · S/N 2844074N850PUTrustees Of Purdue University · West Lafayette, INS/N 2881323N8510NEarhart Brad Thomas · Winnemucca, NVBuilt 1969 · S/N 28-11245N8510WMeyer Jeremy L · Conway Springs, KSBuilt 1963 · S/N 28-10011N8511FMrd Aero LLC · Manheim, PABuilt 1976 · S/N 28-7725119N8511NKindergan Brian · Hewitt, NJBuilt 1969 · S/N 28-11208N8511WLyons Matthew · Walkersville, MDBuilt 1963 · S/N 28-10012N8512WNorthcut David A · Midlothian, TXBuilt 1963 · S/N 28-10013N8513CBranscome Julius L · Woodbridge, VABuilt 1976 · S/N 32R-7680121N8513WTexas Old Mans Aviation Society Inc · Bertram, TXBuilt 1963 · S/N 28-10014
Back to AD 87-08-08 R3