OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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.

N7721GWurtsboro Airpark LLC · Wurtsboro, NYS/N 17259421N7721TBourdon Alain · West Springfield, MABuilt 1960 · S/N 47321N77222Davis Sam Alan · Wendell, NCBuilt 1973 · S/N 17262487N7722FSmall Tony D · Welch, OKBuilt 1972 · S/N 18261560N7722GKnaack Roland · Cumming, GABuilt 1970 · S/N 17259422N7722TPfc Aviation Repair Inc · Wallingford, CTS/N 47322N7722UBeebout Shawn C · Milroy, MNBuilt 1964 · S/N 17251722N7722XLeasure Everett D · Joliet, ILBuilt 1960 · S/N 17248222N7723ADoremus Scott M · Wolfeboro, NHBuilt 1956 · S/N 32620N7723FSchlueter Rodney E · Kansas City, MOBuilt 1966 · S/N 15063823N7723MDdw Inc · Gardner, COBuilt 1968 · S/N T210-0357N7723UAdams David C · Westford, MABuilt 1964 · S/N 17251723N7724GWind Walker LLC · Tucson, AZBuilt 1970 · S/N 17259424N7724KGardner Thomas W · Lincoln, MEBuilt 1976 · S/N 18052711N7724XJohnson Randy G · Collinsville, OKBuilt 1960 · S/N 17248224N7725FToney Michael · Saint Peters, MOBuilt 1966 · S/N 15063825N7725UCvz-Vivace LLC · Fort Worth, TXBuilt 1964 · S/N 17251725N7726FWargacki Darrin W · Hamilton, OHBuilt 1966 · S/N 15063826N7726XTop Profile Management LLC · Somis, CABuilt 1960 · S/N 17248226N7727GSkyhawk Air LLC · Brunswick, GABuilt 1970 · S/N 17259427N7727UWingtip Aviation LLC · Amarillo, TXBuilt 1964 · S/N 17251727N7728GTakeflight LLC · Spanish Fork, UTBuilt 1970 · S/N 17259428N7728UKropp Richard G · North Creek, NYBuilt 1964 · S/N 17251728N7729FCardenas Enrique · Brownsville, TXBuilt 1966 · S/N 15063829N7729GValiair Lc Trustee · Casper, WYBuilt 1970 · S/N 17259429N7729UBlough Lynn M · Pittsburgh, PABuilt 1964 · S/N 17251729N772CGBarefoot Brendan · Four Oaks, NCBuilt 1973 · S/N 18261964N772KWTime Flies LLC · Loxahatchee, FLS/N R1722854N772MABaumbaugh Randal Kelly · Granger, INBuilt 1978 · S/N R1722959N772MVAir And Sea LLC · Oak Bluffs, MAS/N R1722823N772PLSfc-182 LLC · Kansas City, MOBuilt 1965 · S/N 18255970N772RAKehmeyer Aviation LLC · Bronson, MIBuilt 1977 · S/N 17270013N772RFSpencer John S · Indian, AKBuilt 1967 · S/N U206-0816N772TXDyson Thornton E · Houston, TXBuilt 1979 · S/N 18267491N772ZZCirri Joseph A · Deming, NMBuilt 1966 · S/N 15064240N7730FBmg Aviation Leasing LLC · Bloomington, INBuilt 1966 · S/N 15063830N7730GSellet Jack A · Winter Haven, FLBuilt 1973 · S/N 15074719N7731FN7731f LLC · Portage, MIBuilt 1966 · S/N 15063831N7731KMorrison Richard Trustee · Anchorage, AKBuilt 1976 · S/N 18052712N7731TNash Leslie W · Bentonia, MSBuilt 1960 · S/N 47331N7731UMd Aviation Inc · Sioux Falls, SDBuilt 1964 · S/N 17251731N7731VDedmon Stephen V · Fleming Island, FLBuilt 1976 · S/N 177RG0906N7732XLinstad Daniel E · Canby, ORBuilt 1960 · S/N 17248232N7733GWashingtons Mt St Helens Co Inc · Mill Creek, WAS/N 17259433N7733TSiu Ena · Reno, NVS/N 47333N7733UGutlon Richard S · Durham, NCBuilt 1964 · S/N 17251733N7733VLong Final LLC · Clay, NYBuilt 1976 · S/N 177RG0907N7734FJackson Kimberly F · Wichita Falls, TXBuilt 1966 · S/N 15063834N7734XNelson Daniel J · Ladd, ILBuilt 1961 · S/N 17248234N7735GShaver John M · Shelby, NCBuilt 1973 · S/N 15074722
Back to AD 87-20-03 R2