OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N2870UKline Kevin J · Clyde, OHBuilt 1963 · S/N 17250470N2870YDabevv LLC · Salina, UTBuilt 1962 · S/N 18253870N2871KPace Robert A Jr · Pensacola, FLBuilt 1979 · S/N 18053107N2871RBlue Ridge Flyers Inc · Leesburg, VABuilt 1967 · S/N 18258471N2871USt Clair Dustin W · Cloverdale, CAS/N 17250471N2871YJohnson Cynthia Trustee · Sagle, IDS/N 18253871N2872AArdmore Aviation LLC · Russell Twp, OHBuilt 1953 · S/N 30072N2872KR N Geraci LLC · Lutz, FLBuilt 1979 · S/N 18053108N2872QTriad Aviation Academy LLC · Greensboro, NCBuilt 1971 · S/N 17259872N2872VRamirez Jose · Altadena, CABuilt 1974 · S/N 15076306N2873AAndelin Sheila P · Newport Beach, CABuilt 1953 · S/N 30073N2873CHart John E · West Yellowstone, MTBuilt 1954 · S/N 26416N2873QCloud Dancer Aviation Inc · Deland, FLBuilt 1971 · S/N 17259873N2873YMorris Ben M · Albany, GABuilt 1962 · S/N 18253873N2874CLarson Ivan · Parker, AZBuilt 1954 · S/N 26417N2874EMoutafian Adom · Los Gatos, CAS/N 21062773N2874KWashburn Kent F · Grants Pass, ORBuilt 1979 · S/N 18053110N2874LSchirack John · Decatur, INBuilt 1967 · S/N 17256074N2875LDavenport Ross K · Raleigh, NCBuilt 1967 · S/N 17256075N2875QLani Lea Sky Tours LLC · Honolulu, HIBuilt 1971 · S/N 17259875N2875SHolland Van D · Sandy Valley, NVBuilt 1967 · S/N 15066775N2875UWalter Karl F · Fayetteville, GABuilt 1963 · S/N 17250475N2876FJohnston Natalie R · Edgewood, TXBuilt 1966 · S/N 18256976N2876SRay Charlie B · Prosser, WAS/N 15066776N2876UPianalto David · Wichita, KSBuilt 1963 · S/N 17250476N2876YForbes Richard L · Plano, TXBuilt 1962 · S/N 18253876N2877ADutremble Donald L · Amherst, NHBuilt 1953 · S/N 30077N2877CCarlson John R · Plainfield, WIBuilt 1954 · S/N 26420N2877SWarner David F · Altoona, IABuilt 1967 · S/N 15066777N2877UMelin James · Livingston, MTBuilt 1963 · S/N 17250477N2877XJim Doherty Trucking Inc · Sacramento, CABuilt 1967 · S/N 17700277N2877YBrumback Recreation LLC · Bluffdale, UTBuilt 1962 · S/N 18253877N2878AAero Garage Inc · Fort Myers, FLS/N 30078N2878CGullion Joshua A · Weldona, COBuilt 1954 · S/N 26421N2878LHolbrook David A · Toccoa, GABuilt 1967 · S/N 17256078N2878QFields Williams H · Greensboro, NCBuilt 1971 · S/N 17259878N2879FMinich Sophie R · Anchorage, AKS/N 18256979N2879KTwo Niner Kilo LLC · Seattle, WABuilt 1979 · S/N 18053115N2879QBlue Side Aviation LLC · Tampa, FLBuilt 1971 · S/N 17259879N2879XGregoire Louis Bernard III · Blairsville, GABuilt 1967 · S/N 17700279N287BWDaniels Kelly M · Humble, TXBuilt 1979 · S/N R18201329N287TCAiv Con Inc · Charlevoix, MIBuilt 1969 · S/N 18260183N2880CBuchert Allen C · Grand Rapids, MNBuilt 1954 · S/N 26423N2880EDemulling Michael C · New Richmond, WIBuilt 1978 · S/N 17271358N2880RPhelps Thomas J · Orem, UTBuilt 1967 · S/N 18258480N2880SHigh Exposure Inc · Wilmington, DEBuilt 1967 · S/N 15066780N2880XGerstung Dennis R · Anchorage, AKBuilt 1967 · S/N 17700280N2880YRegistered aircraftBuilt 1962 · S/N 18253880N2881CCompton Steven · Anchorage, AKBuilt 1954 · S/N 26424N2881FAirplanes Over Niagara LLC · Lewiston, NYBuilt 1966 · S/N 18256981
Back to AD 87-20-03 R2