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.

N8977WRice Elden · Black Hawk, SDBuilt 1965 · S/N 28-10555N8979NPeeling Clyde R · Allenwood, PABuilt 1969 · S/N 32-40862N897ALJansky Sand & Gravel Inc · Hallettsville, TXBuilt 1973 · S/N 28R-7335331N897ECMatacia Thomas Eugene · Evergreen, NCBuilt 1969 · S/N 28R-35376N897GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881072N897HParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020244N897JWAmh Properties LLC · Auburn, ALFirst renewal noticeBuilt 2011 · S/N 2843698N897MAPate Jimmy B · Fredericksburg, TXBuilt 1997 · S/N 3246083N897MBJts Aircraft LLC · Rock Hill, SCBuilt 1966 · S/N 28-21978N897SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881801N8980WAddis Timothy David · Mount Vernon, OHBuilt 1965 · S/N 28-10559N8981AAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1978 · S/N 32-7840190N8982WTorres Lewis A · Pasadena, CABuilt 1966 · S/N 28-10815N8983JStensrud Maynard R · Waseca, MNBuilt 1966 · S/N 28-3006N8984JKlassen Wayne V · New Ulm, MNBuilt 1965 · S/N 28-3007N8984NBlair Gary B · Salado, TXBuilt 1969 · S/N 32-40867N8985CCornelius James Sean · Hamilton, MOBuilt 1976 · S/N 32R-7680147N8985WKeskintepe Levent · Las Vegas, NVBuilt 1964 · S/N 28-10564N8986JKleinberg Kenneth A · Saugerties, NYBuilt 1965 · S/N 28-3009N8986NBay Air Inc · Dillingham, AKS/N 32-40869N8986WCandler Derrick · Tampa, FLBuilt 1964 · S/N 28-10565N8987CDouble M Charters LLC · Lakeland, FLBuilt 1976 · S/N 32R-7680148N8987WSonrise Aviation LLC · Lake Havasu City, AZBuilt 1964 · S/N 28-10566N8988JMerkle Hunter T · Mattawa, WABuilt 1966 · S/N 28-3011N8988NCicero Flying Club LLC · Indianapolis, INBuilt 1969 · S/N 32-40871N8988WGonzaga Michaelr · Chino Hills, CABuilt 1965 · S/N 28-10567N8989JJohnston Family Clinic Inc · Meridian, MSS/N 28-3012N898CPThomas Robert M Jr · Kissimmee, FLBuilt 1975 · S/N 32-7640031N898DANopat LLC · North Charleston, SCBuilt 2000 · S/N 2843377N898DSBeretta James P · Indian Springs, ALBuilt 1977 · S/N 32R-7780358N898GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881470N898PTitus Aviation LLC · Fresno, CAS/N 28-7515403N8990JStites Charles Harold · Chapel Hill, NCBuilt 1966 · S/N 28-3014N8991JCavoto Allyn E III · Adrian, PABuilt 1965 · S/N 28-3015N8992EDmd Air Ventures LLC · Waycross, GABuilt 1976 · S/N 32R-7680187N8992JMid-Atlantic Air Ventures Inc · Richmond, VABuilt 1965 · S/N 28-3016N8992NBenedict Kevin M · Lakeland, FLBuilt 1970 · S/N 32-40875N8992WKelk Investment Management LLC · Lake Tomahawk, WIBuilt 1965 · S/N 28-10572N8993JHealy Law Offices Pc · Tyler, TXBuilt 1965 · S/N 28-3017N8994JBatham Carin C · Yuba City, CABuilt 1965 · S/N 28-3018N8994WLong Evertt W · Wichita, KSFirst renewal noticeBuilt 1964 · S/N 28-10575N8995JBloomquist Eric R · Phoenix, AZBuilt 1965 · S/N 28-3019N8995WBlair Maksim J · Pensacola, FLBuilt 1964 · S/N 28-10576N8996EHooligan Air LLC · Ponce Inlet, FLBuilt 1976 · S/N 28-7690217N8996NBickford Shawn A · Auburn, CABuilt 1969 · S/N 32-40879N8996WVan Seghbroeck Jeffrey A · Zion Crossroads, VABuilt 1965 · S/N 28-10577N8997JKakuska Michael · Madison, WIBuilt 1965 · S/N 28-3021N8997WDockers Elite Aviation LLC · Towanda, KSBuilt 1964 · S/N 28-10579N8998EGeorgetson Michael J · Sayre, PABuilt 1976 · S/N 28-7690219N8998JObrien Robert · Warrens, WIBuilt 1966 · S/N 28-3022
Back to AD 87-08-08 R3