OpenAirDocs.org
AD 95-19-15 R1

Registered aircraft · 1,889

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:95-19-15-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-19-15-R1')
  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.

N1336RManus Phillip P · Tucson, AZS/N AA5-0736N1337RZimmerman Christopher Paul · Canandaigua, NYBuilt 1975 · S/N AA5-0737N1339RWilcox Marion L Trustee · La Mesa, CABuilt 1975 · S/N AA5-0739N133UOrion Future Data LLC · Sarasota, FLBuilt 1993 · S/N 10165N1341RTmp Aviation LLC · Altamonte Springs, FLBuilt 1975 · S/N AA5-0741N1342RGladden Thomas E · Otis Orchards, WABuilt 1975 · S/N AA5-0742N1345RGrumman N1345r LLC · Benton Harbor, MIBuilt 1975 · S/N AA5-0745N1346RPaul Joshua Daniel · Murrieta, CABuilt 1975 · S/N AA5-0746N1347RCharles Kaplove Md Inc · Novato, CABuilt 1975 · S/N AA5-0747N1348RMargolien Brooks · Orange, MABuilt 1975 · S/N AA5-0748N1353NSubsonic Aviation Leasing LLC · Grandville, MIBuilt 1979 · S/N AA5B1242N1355RFly Guys LLC · Arcata, CABuilt 1975 · S/N AA5-0755N1359REllingson Jason J · Edina, MNBuilt 1975 · S/N AA5-0759N1361RLeslie Michael H · Ashburn, VABuilt 1975 · S/N AA5-0761N1366RParodi Carlos Guillermo · Austin, TXBuilt 1975 · S/N AA5-0766N1369RRyals Jon Harris · Billings, MTBuilt 1975 · S/N AA5-0769N136SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 10164N1376RParker Brian L · Columbus, GABuilt 1975 · S/N AA5-0776N1377RHendrix David S · Benbrook, TXBuilt 1975 · S/N AA5-0777N1385RCulleton Frederic · Flowery Branch, GABuilt 1975 · S/N AA5-0785N1388RTrybe LLC · Frisco, TXBuilt 1975 · S/N AA5-0788N1390RYancy Timothy J · Chino Hills, CABuilt 1975 · S/N AA5-0790N1391RMccarthy Daniel J · San Diego, CAS/N AA5-0791N1395RKing Rodney R · Lucedale, MSBuilt 1975 · S/N AA5-0795N1396RHodges John J · Cleburne, TXBuilt 1975 · S/N AA5-0796N1398RHopland Steven R · Johnson City, TNBuilt 1975 · S/N AA5-0798N141ACGann Steve W · Southaven, MSS/N AA5-0743N1420N5504r LLC · Jefferson City, MOBuilt 1993 · S/N 10172N142BLipinski Glen E · Chandler, AZBuilt 1992 · S/N 10134N144CCNightingale William T III · Rancho Cucamonga, CABuilt 1975 · S/N AA5B-84N144RLHanshew James M · Phoenix, AZS/N AA5B1034N148RRDunbar Richard · El Dorado Hills, CABuilt 1978 · S/N AA5B-1008N14YUInternational Air Services Inc Trustee · Carson City, NVBuilt 1992 · S/N 10135N1502RSale Reported · San Diego, CASale reported, pending cancellationBuilt 1974 · S/N AA5B-0002N1503RBeck Wally J · Davenport, IABuilt 1974 · S/N AA5B-0003N1504RFlying Tiger LLC · Broomfield, COBuilt 1974 · S/N AA5B-0004N1508RAmspoker David A · Kingman, AZBuilt 1975 · S/N AA5B-0030N1515ROwen Ray M · Columbia Station, OHBuilt 1974 · S/N AA5B-0015N1516RMckenzie Pools Inc DBA · Springfield, ORBuilt 1974 · S/N AA5B-0016N1519RSims John · Ingleside, TXBuilt 1974 · S/N AA5B-0019N1520Littler David E · Largo, FLBuilt 1978 · S/N AA5B0957N1520RCastro Jose M · Conway, ARS/N AA5B-0020N1521RPerkins J R III · The Dalles, ORBuilt 1975 · S/N AA5B-0021N1523RDement Myers Michael W · Newberg, ORBuilt 1975 · S/N AA5B-0023N1527RFilkins Barbara L · Fillmore, CABuilt 1975 · S/N AA5B-0027N1529RBall Chad M · Delaware, OHBuilt 1975 · S/N AA5B-0029N1531RMorgan Virginia K · Artesian, SDBuilt 1975 · S/N AA5B-0031N1532RAdkins Todd D · Manassas, VABuilt 1975 · S/N AA5B-0032N1533RAnderson Michael · Byhalia, MSBuilt 1975 · S/N AA5B-0033N1536RCape Cod Aero Club LLC · Falmouth, MABuilt 1975 · S/N AA5B-0036
Back to AD 95-19-15 R1