OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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-10-06-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:87-10-06-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.

N3451334513 LLC · Stanton, TNBuilt 1972 · S/N 17701851N34519Mccarthy James E · Yucca Valley, CABuilt 1972 · S/N 17701855N3451KMorehead Matt F · Chico, CABuilt 1967 · S/N 28-23559N3451QCcr Holdings LLC · Rushford, MNBuilt 1977 · S/N 28-7725228N3451TMichael W Maciol Md · Pelham, NYBuilt 1968 · S/N 17700751N3451ZHarris Michael E · Greenville, SCS/N 22-7370N34521Mitchell Robert A · Centennial, COBuilt 1972 · S/N 17701856N34524Registered aircraftBuilt 1972 · S/N 17701857N34528Mcmahon John · Sequim, WABuilt 1972 · S/N 17701859N3452KRegistered aircraftBuilt 1967 · S/N 28-23561N3452TKordus Robert A · Union Grove, WIS/N 17700752N3452ZChief LLC · Du Quoin, ILBuilt 1960 · S/N 22-7371N3453QEdwards Latas L Jr · St Petersburg, FLFirst renewal noticeS/N 28-7716156N3453TAircraft Evolution LLC · Miami, FLBuilt 1968 · S/N 17700753N3453WBrown Craig · Vernal, UTBuilt 1966 · S/N 32-321N34543Riggs Jeffrey W · Claremore, OKBuilt 1973 · S/N 17701865N3454CHenderson Eric R · Santa Rosa, CABuilt 1954 · S/N 26497N3454TTears Gary S · Edmond, OKBuilt 1968 · S/N 17700754N3454WRoos Paul A · Lake City, FLBuilt 1966 · S/N 32-322N3454XGarcia Eduardo G · Houston, TXBuilt 1966 · S/N 1138N34552Mlinarich Rob · Pottsboro, TXBuilt 1973 · S/N 17701868N34554Maryland Industrial Trucks Inc · Linthicum, MDS/N 17701870N34555Cardinal Aviation LLC · Everett, WABuilt 1973 · S/N 17701871N34556Thornsbury Nicholas J · Virginia Beach, VABuilt 1973 · S/N 17701872N34557Podgwaite Frank C III · North Haven, CTBuilt 1973 · S/N 17701873N34559Bagley John C · Schertz, TXBuilt 1973 · S/N 17701874N3455AKoelsch Benjamin · Nome, AKBuilt 1956 · S/N 22-3875N3455ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1978 · S/N 17271553N3455NRegistered aircraftBuilt 1967 · S/N 680057N3455RBulut LLC · Los Angeles, CABuilt 1969 · S/N 28-5685N3455TCornejo Jose Valente · Scottsdale, AZBuilt 1968 · S/N 17700755N3455WClark James A · Walnut Creek, CABuilt 1966 · S/N 32-324N34566Inspiring Flight · Scottsdale, AZBuilt 1973 · S/N 17701877N34568Diebel Darrel L · Okanogan, WABuilt 1973 · S/N 17701878N3456BSale Reported · Viroqua, WISale reportedS/N M-003/116N3456MBuxton Michael · Grand Junction, COBuilt 2006 · S/N 47004TN3456PBels Holdings LLC · Albert Lea, MNBuilt 1958 · S/N 23-1428N34577Registration Pending · Page, AZRegistration pendingBuilt 1973 · S/N 17701882N34579Oliver Terry L · Polk City, FLBuilt 1973 · S/N 17701884N3457ETri Star Aviation & Development Ltd · Bath, NCBuilt 1978 · S/N 17271554N3457PSewade Dawn M · New River, AZBuilt 1958 · S/N 23-1429N3457WBas Part Sales LLC · Greeley, COS/N 32-326N3457ZHanus Phillip J · Ashley, MIBuilt 1960 · S/N 22-7378N34580Contois Richard R · Renton, WABuilt 1973 · S/N 17701885N3458TBrown Lance D · Cottonwood, CABuilt 1968 · S/N 17700758N3458WBerquist Glenn A · Columbus, MSBuilt 1966 · S/N 32-327N3458XDalton Robert E · San Martin, CABuilt 1966 · S/N 1140N34592Van Cleve Cole · Cotulla, TXBuilt 1973 · S/N 17701889N34594Paschall David C · Hernando, MSBuilt 1973 · S/N 17701890N34597G2 Aviation LLC · Wheatland, WYBuilt 1973 · S/N 17701892
Back to AD 87-10-06 R1