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.

N3900UHeston Jeffrey W · Warren, OHBuilt 1965 · S/N 15061300N3900VMays Kevin E · West Liberty, KYBuilt 1948 · S/N 18210N3901CAero II Inc · Spartanburg, SCBuilt 1968 · S/N 15069096N3901DDanford Scott M · Chickamauga, GAS/N 34601N3901FCda Maine LLC · Winthrop, MEBuilt 1958 · S/N 36801N3901JHolladay Leonard · Greeley, COBuilt 1966 · S/N 15065201N3901LSan Fernando Aviation LLC · Van Nuys, CAS/N 17254070N3901RMuth Joseph A · Richmond, KYS/N 17255401N3901SEggett Glade · Brigham City, UTBuilt 1963 · S/N 17251101N3901YCentruion Express LLC · North Port, FLS/N 21058401N3902CRegistration Pending · Post Falls, IDRegistration pendingBuilt 1968 · S/N 15069101N3902FMagaw David N · Sacramento, CABuilt 1958 · S/N 36802N3902JUltimate Aviation LLC · Lowell, ARBuilt 1966 · S/N 15065202N3902RBotero Jorge · Alexandria, VAS/N 17255402N3902SGooding Flying Club · Gooding, IDBuilt 1963 · S/N 17251102N3903FSlattery Gordon C · Chippewa Falls, WIBuilt 1958 · S/N 36803N3903QWashington Chinook LLC · Bellingham, WABuilt 1973 · S/N 18502209N3903RDanielson Bradley K · Willmar, MNBuilt 1966 · S/N 17255403N3903SAt Aero LLC · Wilmington, DEBuilt 1963 · S/N 17251103N3903VMiller Charles G · Anchorage, AKBuilt 1948 · S/N 18213N3904DOreilly Thomas P · Oscoda, MIS/N 34604N3904FPedersen Blake A · Clackamas, ORBuilt 1958 · S/N 36804N3904QKern Bruce A · Collinsville, OKBuilt 1971 · S/N 17260004N3904SLambert Aviation Service LLC · Washington, PABuilt 1963 · S/N 17251104N3904UKunkel Keith R · Bay City, MIS/N 15061304N3904VObloy James J · Brunswick, OHBuilt 1975 · S/N 15076649N3904YOtto William R · Ontario, CABuilt 1964 · S/N 21058404N3905CWind Walker LLC · Tucson, AZBuilt 1968 · S/N 15069294N3905DKoehn Jerry L · Cimarron, KSBuilt 1957 · S/N 34605N3905QH&H Cloudbase Aviation LLC · Carlsbad, CAS/N 17260005N3905RShea Michael P · Nashua, NHBuilt 1966 · S/N 17255405N3906RHorning Richard · Galion, OHS/N 17255406N3906UBrighton Flying Club LLC · Brighton, MIBuilt 1965 · S/N 15061306N3906YWildbur Mark B · Laramie, WYBuilt 1964 · S/N 21058406N3907FTaylor William Bc · Quincy, CABuilt 1958 · S/N 36807N3907GMid-America Sport Parachute Club · Taylorville, ILBuilt 1967 · S/N U206-0907N3907L33 Global LLC · Potomac Falls, VABuilt 1965 · S/N 17254076N3907RNexgen Aviation LLC · Ennis, TXBuilt 1966 · S/N 17255407N3907SWilliamson Henry H · Conway, SCBuilt 1964 · S/N 17251107N3907UDenton Brian H · Poughquag, NYBuilt 1965 · S/N 15061307N3907VSortland Mitchell Kent · Parkersburg, IABuilt 1948 · S/N 18217N3907YAckley John · Brownsville, TXBuilt 1964 · S/N 21058407N3908DMoors Greg K · Athol, IDBuilt 1957 · S/N 34608N3908JSpanaflight LLC · Puyallup, WAS/N 15065208N3908QShamrock Flying Service LLC · Denver, COBuilt 1971 · S/N 17260008N3908RDobson James Cody · Paradise, UTBuilt 1966 · S/N 17255408N3908VKaiser Jimmy · Lake Park, MNBuilt 1948 · S/N 18218N3909CJames Eric A · Claremore, OKBuilt 1968 · S/N 17257032N3909DDavidson Danny F · Anchorage, AKBuilt 1957 · S/N 34609N3909LBlakeley David · Lancaster, NYBuilt 1965 · S/N 17254078
Back to AD 87-20-03 R2