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.

N4160CNewman Holdings LLC · Dallas, TXBuilt 1978 · S/N R18200332N4161FGilbertson Daniel E · Duluth, MNBuilt 1958 · S/N 46061N4161LBruner Harvey L · Latexo, TXBuilt 1966 · S/N 17254230N4162FPowell Clinton J · Pleasanton, TXBuilt 1958 · S/N 46062N4162UGiammarino Brian L · Antrim, NHBuilt 1963 · S/N 15060162N4162VUntiet Steven R · Homer, AKBuilt 1950 · S/N 18494N4163LLeitzman Robert A · Tucson, AZBuilt 1966 · S/N 17254232N4163UWilson Jim A · Grand Rapids, MNBuilt 1963 · S/N 15060163N4163VRoot Shane G · Dighton, KSBuilt 1948 · S/N 18495N4164COld Blue Solutions LLC · Harvest, ALS/N R18200333N4164LDerwin Diversified Inc · Santa Paula, CABuilt 1966 · S/N 17254233N4164URogers Robert P · Dubuque, IABuilt 1963 · S/N 15060164N4164VRowe Dennis A · Vandergrift, PABuilt 1948 · S/N 18497N4165VHagen Curt L · Sullivan, WIBuilt 1948 · S/N 18498N4166CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N R18200334N4166LWarbelows Air Ventures · Fairbanks, AKBuilt 1966 · S/N 17254235N4166VFreitas Anthony F · Canby, ORBuilt 1948 · S/N 18499N4167FHamburg Jeffrey B · Warner Robins, GABuilt 1958 · S/N 46067N4167URegistered aircraftS/N 15060167N4168FOfarrell Leo S · Lakeport, CABuilt 1958 · S/N 46068N4168LRoberts James E · Golconda, ILBuilt 1966 · S/N 17254237N4168VLehr F Mark · Placitas, NMBuilt 1948 · S/N 18501N4169ULofstrom David J · Chugiak, AKS/N 15060169N4169YVanderhoof Chad T · Elk, WAS/N 185-0369N416DCWeaver Eric W · Anchorage, AKBuilt 1959 · S/N 55940N416WTHigh Desert Flight Instruction LLC · Albuquerque, NMBuilt 1975 · S/N 17702355N4170BOutman William D · Half Moon Bay, CABuilt 1953 · S/N 26137N4170USwan Guy · West Palm Beach, FLBuilt 1963 · S/N 15060170N4171LFleeman Danny W · Manila, ARBuilt 1966 · S/N 17254240N4172FEdwon Ronnie L · Mesa, AZBuilt 1958 · S/N 46072N4172VMd Aero LLC · Somerton, AZBuilt 1948 · S/N 18505N4173VLohmeier George A · Indianapolis, INBuilt 1948 · S/N 18506N4175CSalciccioli Christopher · Joshua Tree, CABuilt 1978 · S/N R18200336N4175FGay Clayton B · Villisca, IAFirst renewal noticeBuilt 1958 · S/N 46075N4175LColangelo Frank · New Preston, CTBuilt 1966 · S/N 17254244N4176FKruggel Kurt · Rancho Cucamonga, CABuilt 1958 · S/N 46076N4177FWinkler Steve · Clarksburg, CABuilt 1958 · S/N 46077N41782Kansas Soaring Assoc Inc · Wichita, KSBuilt 1955 · S/N 613N4178VVan Dyke Robert L · Foley, ALBuilt 1948 · S/N 18511N4179LMorristown Flying Service Inc · Talbott, TNBuilt 1966 · S/N 17254248N4179UParks Daniel J · Milton, FLBuilt 1963 · S/N 15060179N4179VSchmidt David · Brooksville, MSBuilt 1948 · S/N 18512N417CBWings Over L A Aviation LLC · West Hills, CAS/N 15281010N417DKVitrella Steven E · Melbourne, FLBuilt 1974 · S/N 177RG0563N417LFRussell Tommy Edward · Kingsport, TNBuilt 1976 · S/N 18264714N4180LMcginn Robert W · Marion, NCBuilt 1966 · S/N 17254249N4180UFirst Flight Aviators · Lincoln, ILBuilt 1963 · S/N 15060180N4182FHong Jason S · Yorba Linda, CABuilt 1958 · S/N 46082N4182TMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270319N4182VCoulter Robert Allen · Granger, INBuilt 1948 · S/N 18515
Back to AD 87-20-03 R2