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.

N3900TNopat LLC · North Charleston, SCBuilt 1967 · S/N 28R-30232N3900WStuart Deed Pendell · Elkhart, INBuilt 1966 · S/N 32-846N3904WEyler Neale · Goddard, KSBuilt 1966 · S/N 32-850N3904XMoore Jeremy E · Baton Rouge, LABuilt 1975 · S/N 28R-7535347N3905FAsadoorian Todd · Arlington, TNBuilt 1976 · S/N 28-7625269N3905TSmooth Air LLC · Tampa, FLBuilt 1967 · S/N 28R-30239N3905XClingan James W Jr · Finksburg, MDBuilt 1975 · S/N 28-7515429N3906WRegistered aircraftBuilt 1966 · S/N 32-852N3907WParks Craig W · Stephenville, TXBuilt 1967 · S/N 32-915N3908FRegistration Pending · Anchorage, AKRegistration pendingBuilt 1976 · S/N 28-7615431N3908TAustin Christopher · Dayton, NVBuilt 1967 · S/N 28R-30243N3909KRada Norman · Hagerstown, MDBuilt 1967 · S/N 28-23776N3909TAnnis Aviation LLC · Gray, GABuilt 1967 · S/N 28R-30244N3909WMargolien Brooks · Orange, MABuilt 1967 · S/N 32-855N390MSStack Brian James · Paso Robles, CABuilt 1981 · S/N 32-8106048N390TCD & J Aviation LLC · Apopka, FLBuilt 2007 · S/N 2842290N3910TSpeelman Jonathan D · Stockton, CABuilt 1967 · S/N 28R-30245N3910UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842220N3911TMartin Aviation Services LLC · Bay City, MIS/N 28R-30246N3912MGateway Flight Training LLC · Saint Louis, MOBuilt 1978 · S/N 28-7816385N3912WFrankie Dixon · Cookeville, TNBuilt 1967 · S/N 32-858N3912XN3912x Holdings LLC · Sarasota, FLBuilt 1975 · S/N 28-7525337N3913TPetit Randy F Jr · Ama, LABuilt 1967 · S/N 28R-30249N3913XDesert Flight Academy Inc · Henderson, NCBuilt 1975 · S/N 28R-7535350N3914KErmis Aviation LLC · Coleman, WIBuilt 1967 · S/N 28-23782N3914TBias Lee · Weston, FLS/N 28R-30961N3914WGiermek Peter T · Olean, NYS/N 32-860N3914XLechene Aviation LLC · Indiana, PABuilt 1975 · S/N 28R-7535351N3915KPayne Garin Jay · Huntington Beach, CABuilt 1967 · S/N 28-23783N3915RMaloney Kylee · Kingman, KSBuilt 1970 · S/N 28-5859N3915XKb Aviation LLC · Lewes, DEBuilt 1975 · S/N 32-7540182N3916KBell Clarence R · Pasadena, TXBuilt 1967 · S/N 28-23784N3916TChnupa David Scott · Fishers, INBuilt 1967 · S/N 28R-30252N3916WSpiritaire Inc · Saint Louis, MOBuilt 1967 · S/N 32-919N3917KBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 28-23786N3917MWells Brandon A · Mechanicsville, VABuilt 1978 · S/N 28-7890339N3917THarrington-Zink Kristopher Michael · Port Richey, FLBuilt 1967 · S/N 28R-30253N3917WAir Tipton Inc · Tipton, IAS/N 32-1058N3917XVan Anda Aviation LLC · Apopka, FLBuilt 1975 · S/N 28-7515431N3918MAstro Aviation LLC · Cross Plains, TNBuilt 1978 · S/N 28-7890341N3918XHorton Gregory L · Moorpark, CAS/N 28R-7703001N3919KTerrell Thomas III · Edwards, ILBuilt 1967 · S/N 28-23788N3919WAir First LLC · Kalispell, MTS/N 32-865N391DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843849N391KCAig Aeronautics LLC · Guaynabo, PRBuilt 2005 · S/N 3257391N391LTPowell Patrick C · Kenai, AKBuilt 1967 · S/N 28-24018N391WHSheppard Harold Jr DBA · Riverton, WYBuilt 1968 · S/N 28R-30934N3920KPeriklos Andreas · Aliso Viejo, CAS/N 28-23789N3920XBennett Barry B · El Cajon, CABuilt 1975 · S/N 28R-7535352N3921KLewis Mark A · Ozark, ALBuilt 1967 · S/N 28-23791
Back to AD 87-08-08 R3