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.

N7698C98charlie LLC · Van Wert, OHBuilt 1975 · S/N 32R-7680059N7698FProfessional Pilot Training · Eagle Lake, TXBuilt 1976 · S/N 28-7790223N7698JMetz Mark A · Ida, MIBuilt 1969 · S/N 28R-31098N7698WFlyhnz LLC · Oxford, NCS/N 28-1690N7699JHamilton John B · Stafford, VABuilt 1969 · S/N 28R-31099N769AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843794N769GMN373hp LLC · Ladera Ranch, CABuilt 2021 · S/N 2881448N769GSSkylar Aviation LLC · Hagerhill, KYBuilt 1977 · S/N 32R-7780236N769JHorn Warren B · Athens, GAS/N 28R-7335147N769LZMontana 1204 LLC · Rock Valley, IABuilt 2003 · S/N 3255012N769NDN769nd LLC · Sidney, MTBuilt 2016 · S/N 2843861N769RAMcclure Dennis N · Mcalpin, FLS/N 28-23164N76ADWerner Richard · Syosset, NYBuilt 1975 · S/N 28-7690019N76AHOrthoplane LLC · Kalamazoo, MIBuilt 2004 · S/N 3232029N76DHKarapelou James M · Allentown, PABuilt 1995 · S/N 2843019N76DMHendrix Aviation Inc · Plantation, FLBuilt 1977 · S/N 28-7890110N76EHMitchell Matthew J · Penn Yan, NYBuilt 1975 · S/N 32R-7680034N76FR76 Freedom LLC · Greenville, INBuilt 1977 · S/N 32R-7780317N76PFRodriguez Amable Omar · Hialeah, FLBuilt 1982 · S/N 28-8216151N76SWHendricks Blair · Charleston, SCBuilt 1980 · S/N 28-8011123N76TDWillmott Wilson R · Huntington Station, NYBuilt 1979 · S/N 32R-8013027N76TXBrenner Kurt · Saint Ann, MOBuilt 1976 · S/N 28-7625102N7700JLuke Motley IV · Sherman, TXBuilt 1968 · S/N 32-1067N7700WGleasman Steven J · Rockton, ILBuilt 1964 · S/N 28-1692N7701NN5746u LLC · Dover, DEBuilt 1968 · S/N 28-5147N7702HPaphos Airways LLC · Farmingdale, NYBuilt 2003 · S/N 2843568N7702LPrp Enterprises LLC · Lake Forest, CABuilt 1980 · S/N 32R-8013104N7702NN7702n LLC · Glenford, OHBuilt 1968 · S/N 28-5149N7702WMud Duck LLC · Dover, DEBuilt 1964 · S/N 28-1695N7704JTatum John T · Danville, ARBuilt 1969 · S/N 32-1112N7704WKelly John T III · Denison, TXBuilt 1964 · S/N 28-1700N7705NNagy Peter · Sebring, FLBuilt 1968 · S/N 28-5152N7706NSealey John W · Athens, TXBuilt 1968 · S/N 28-5153N77077Hammarback Inc · East Grand Forks, MNBuilt 1977 · S/N 28-7710019N7707JBowersox James · Lititz, PABuilt 1968 · S/N 32-1074N7707NAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1968 · S/N 28-5154N7707WCockrell Amos L · Florence, ALBuilt 1964 · S/N 28-1705N7708WCarter Veronica D · Mesa, AZBuilt 1964 · S/N 28-1708N7709NGallette John B · Edgewood, NMBuilt 1968 · S/N 28-5157N7709WNewlin Thomas R · Montezuma, INFirst renewal noticeBuilt 1964 · S/N 28-1709N770GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881207N770NDN770nd LLC · Sidney, MTBuilt 2016 · S/N 2843862N770PRPuerto Rico International Airline Inc · Santurce, PRBuilt 1978 · S/N 28-7816510N7710NSimpson Chad M · Dover, OHBuilt 1968 · S/N 28-5158N7710WRegistered aircraftBuilt 1964 · S/N 28-1711N7712FRice Robert Dalton · Kerrville, TXBuilt 1976 · S/N 32R-7780082N7713NSingh Harsimran · Las Vegas, NVBuilt 1968 · S/N 28-5159N7713WBarber Mark E · Lighthouse Point, FLBuilt 1964 · S/N 28-1713N7714CLuebow Jens · Madison, WIBuilt 1975 · S/N 28-7690078N7714WCrosswinds Flight Center Inc · Drums, PABuilt 1964 · S/N 28-1718
Back to AD 87-08-08 R3