OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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-20-03-R2')
    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-20-03-R2')
  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.

N3869QNew Garden Township · Landenberg, PABuilt 1971 · S/N 17259969N3869RErl Don L · Medford, WIBuilt 1966 · S/N 17255369N3870DKlad-Air LLC · Catlett, VABuilt 1957 · S/N 34570N3870JLucido Frank · Vacaville, CABuilt 1966 · S/N 15065170N3870LStraub Brian L · Queensbury, NYBuilt 1965 · S/N 17254039N3870QLake Waccamaw Aviation LLC · Lake Waccamaw, NCBuilt 1971 · S/N 17259970N3870SCherryhill Aviation Inc · Freetown, INBuilt 1963 · S/N 17251070N3870VMercury International LLC · Cheyenne, WYBuilt 1977 · S/N R1722266N3872LMaletich Steven J · Las Vegas, NVBuilt 1965 · S/N 17254041N3872QGibbs Elizabeth A · Bellingham, WABuilt 1971 · S/N 17259972N3872RS&Sa Aviation LLC · Colby, KSBuilt 1966 · S/N 17255372N3872SNeu Aviation LLC · Benton, LABuilt 1963 · S/N 17251072N3873GKronfuss Edward P · Bozeman, MTBuilt 1967 · S/N U206-0873N3873QSkywalker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17259973N3873RFoster William G Jr · Sunnyvale, CABuilt 1966 · S/N 17255373N3873VAthens Air LLC · Athens, TNBuilt 1949 · S/N 7335N3874GMcfarlane Bradley J · Port Alsworth, AKS/N U206-0874N3874RMartig Glenn A · Lino Lakes, MNBuilt 1966 · S/N 17255374N3875DJames D Wirt · Goldsby, OKBuilt 1957 · S/N 34575N3875GBurnett Ross L · Riggins, IDBuilt 1967 · S/N U206-0875N3875LBazemore Robert J · Butler, GAS/N 17254044N3875QAerial Scouting Solutions LLC · Sioux Center, IABuilt 1971 · S/N 17259975N3875SFlying M Enterprises · Loomis, NEBuilt 1963 · S/N 17251075N3875UCody Plane Corp · Wilmington, DEBuilt 1964 · S/N 336-0175N3875VBlaedow Kyle R · North Pole, AKBuilt 1975 · S/N 15076643N3876DBurns William Greg · Eloy, AZBuilt 1958 · S/N 34839N3876LWoerle Edward R · Rossville, TNS/N 17254045N3876QKracke Spraying Service Inc · Fargo, NDBuilt 1971 · S/N 17259976N3876RTriple Farms DBA · Sikeston, MOBuilt 1966 · S/N 17255376N3876SMustoe William J Jr · Summersville, WVBuilt 1963 · S/N 17251076N3876VKramer William L · Big Lake, AKBuilt 1981 · S/N 18504167N3877JWilson Steven J · Elkton, KYBuilt 1966 · S/N 15065177N3877VPetersonrandy · Sonoma, CABuilt 1949 · S/N 7339N3877YGonzo LLC · La Junta, COS/N 21058377N3878LLatshaw Sonja · Vero Beach, FLBuilt 1965 · S/N 17254047N3878RSs Farms Operating LLC · Hydro, OKBuilt 1966 · S/N 17255378N3878SSkyhawk172 LLC · Gainesville, TXBuilt 1963 · S/N 17251078N3878YRegistered aircraftBuilt 1964 · S/N 21058378N3879DHolberton George L · White City, ORBuilt 1957 · S/N 34579N3879JMuehl John M · Maryland, NYBuilt 1966 · S/N 15065179N3879LThielemann Kate Ann · Inverness, FLBuilt 1966 · S/N 17254048N387WYSvp LLC · Missoula, MTBuilt 1977 · S/N 18265614N3880CGreer Glenn M · Eugene, ORBuilt 1954 · S/N 31028N3880DWallace David L · Huntersville, NCBuilt 1957 · S/N 34580N3880QJ&J Hangars LLC · Newnan, GABuilt 1971 · S/N 17259980N3880RC172 Nancy LLC · Euclid, OHS/N 17255380N3880YLake Country Aviation LLC · Milledgeville, GABuilt 1964 · S/N 21058380N3881LDarnell David M · Bon Aqua, TNS/N 17254050N3881SWynja Loreen Dee · Riverside, CABuilt 1963 · S/N 17251081N3881YNorton Tim C · Danville, VABuilt 1964 · S/N 21058381
Back to AD 87-20-03 R2