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.

N3475VSatterlee Michael E · Clever, MOBuilt 1974 · S/N 15076513N3475YAbidance Inc · Winthrop, WAS/N 18051975N34760Abrahamson Allen G · Frisco, TXBuilt 1973 · S/N 17701986N34761Griffin Jeremiah L · Titus, ALBuilt 1973 · S/N 17701987N34762Cadamore Brian S · Cabot, PABuilt 1973 · S/N 17701988N34764York Aviators LLC · York, PABuilt 1973 · S/N 17701990N34766Robbins Paul A · Nacogdoches, TXS/N 17701991N34767Tschida Thomas R · Mendota Heights, MNBuilt 1973 · S/N 17701992N3476CDitzler Kevin J · Kirkland, WABuilt 1954 · S/N 26519N3476FDickens Charles L · Panama City Beach, FLS/N 18257476N3476JJr Imaging Logistics Inc · Pasco, WAS/N 15066176N3476RTibbs Properties LLC · Franklin, LABuilt 1968 · S/N 18258776N3476UNelson Robert D · Anchorage, AKBuilt 1963 · S/N 18254876N34770Gustin Brian K · Camdenton, MOBuilt 1973 · S/N 17701994N34772Mlaskoch Air LLC · Willow River, MNBuilt 1973 · S/N 17701996N34774Dunn Gregory Scott · Wooster, OHBuilt 1973 · S/N 17701998N34777Trautmann Glenn K · Highlands Ranch, COBuilt 1973 · S/N 17702000N3477CAir Speed Development LLC · Helena, MTBuilt 1954 · S/N 26520N3477EMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 17271563N3477FFlying T LLC · Albuquerque, NMBuilt 1966 · S/N 18257477N3477SN3477s Inc · Dalton Gardens, IDS/N 18255877N34787Baker Herman L · Austin, TXBuilt 1973 · S/N 17702003N3478CSchumacher Brent A · Inchelium, WAS/N 26521N3478TGuzowski Richard G · Haydenville, MABuilt 1968 · S/N 17700778N3478VGazsy William · North Bellmore, NYS/N 15076514N34794Schmidt Gary L · Afton, MNBuilt 1973 · S/N 17702005N34795Fox Business Advisors LLC · Mesa, AZBuilt 1974 · S/N 17702006N34796Masters David R · Troy, KSBuilt 1973 · S/N 17702007N3479DGeier Harry J · Huntington Beach, CABuilt 1955 · S/N 27022N3479RM S Davidson Enterpries Pc · Laurel, DEBuilt 1968 · S/N 18258779N3479SCook Mark C · Hutto, TXBuilt 1964 · S/N 18255879N3479TRobbins Derick Mitchell Robbins · Freeport, FLBuilt 1968 · S/N 17700779N3479VInternational Air Services Inc Trustee · Carson City, NVS/N T30300273N347CHAce Flight Center · St Thomas, VIBuilt 1974 · S/N 17263661N347WGMt Aircraft LLC · Port Orange, FLBuilt 1968 · S/N 17256883N34807Wiese Marcus G · Shady Shores, TXBuilt 1976 · S/N 177RG1014N34808Barber Jeffrey A · Blaine, MNBuilt 1973 · S/N 17702016N34809Grassmyer Richard M · Salem, INBuilt 1973 · S/N 17702017N3480CEffenberger Anthony J · Mankato, MNBuilt 1954 · S/N 26523N3480FAltus Aircraft LLC · Taylor, TXFirst renewal noticeBuilt 1966 · S/N 18257480N3480TMoffatt Thomas O Jr · Diberville, MSBuilt 1968 · S/N 17700780N3480USoule Clauson D · Cooperstown, NYS/N 18254880N34813Max Gs LLC · Wilmington, DEBuilt 1973 · S/N 17702020N34816Clark Tal O · Hudson, COBuilt 1973 · S/N 17702022N34818Rosenberger Mark W · West Columbia, SCBuilt 1973 · S/N 17702023N3481DDavis Tyler M · Moreland, GABuilt 1955 · S/N 27024N3481FWells Garry L · Scotia, NEBuilt 1966 · S/N 18257481N3481SDorman Richard E · Mesa, WABuilt 1964 · S/N 18255881N3481TEstes Kenneth · Portland, ORS/N 17700781N3481USmith Lowell A · Gresham, ORBuilt 1963 · S/N 18254881
Back to AD 87-20-03 R2