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.

N2382XRolleston Moreton M III · Canton, GABuilt 1965 · S/N 18256282N2383XComo Aviation LLC · South Weymouth, MABuilt 1965 · S/N 18256283N2383YAult Stanley K · Cinebar, WABuilt 1965 · S/N 21058583N2384GAircraft Holdings LLC · Ellensburg, WABuilt 1958 · S/N 51684N2384SChervenak A Douglas · Smyrna, DEBuilt 1976 · S/N 21061263N2384XHill James P · Eagle Point, ORBuilt 1965 · S/N 18256284N2384YArea-I Flying Club LLC · Atlanta, GAS/N 17700184N2385CSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1978 · S/N R18200172N2385DHurst Gerald W · Bigfork, MTBuilt 1952 · S/N 20537N2385UThomas Robert G · Eatonville, WABuilt 1962 · S/N 17249985N2386CSuiter Thomas D · Earl Park, INBuilt 1978 · S/N R18200173N2386DTitan Aero LLC · Wilmington, DEBuilt 1952 · S/N 20538N2386ENiblack Ward Scott · Tecumseh, MIBuilt 1978 · S/N 17271261N2386UBratton Beryl M · Yoncalla, ORS/N 17249986N2387CEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 30687N2387FMitten Daniel L · Hatfield, PABuilt 1965 · S/N 21058587N2387GPitsch Air Service · Grand Rapids, MIBuilt 1959 · S/N 51687N2387RLeroux Fernand Dean · Lagrange, GABuilt 1964 · S/N 18255487N2388CRicottilli Stanley L · Mill Creek, WVBuilt 1953 · S/N 30688N2388GFlat Top Sheep Co · Carey, IDBuilt 1958 · S/N 51688N2388URay Charlie B · Prosser, WABuilt 1963 · S/N 17249988N2388XSeiler Richard · Bozeman, MTBuilt 1965 · S/N 18256288N2388YMay James E · Nashville, GABuilt 1967 · S/N 17700188N2389RB2fh Ltd · Allentown, NJBuilt 1964 · S/N 18255489N2389SPhillips Aviation Enterprises Inc · Petoskey, MIBuilt 1979 · S/N R18201335N2389UAllworth Ruger · Wapello, IABuilt 1962 · S/N 17249989N238ESSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 52854N238TWDunlap Allan D · Spokane, WABuilt 1981 · S/N 17275287N2390DNorman James C · Laguna Niguel, CABuilt 1952 · S/N 20542N2390SPowerhawk Flyers LLC · Farmington Hills, MIBuilt 1976 · S/N 21061266N2390UKuhn Jacob H · Bloomer, WIBuilt 1962 · S/N 17249990N2391FBlue Horizon Consulting LLC · Toccoa, GABuilt 1965 · S/N 21058591N2391YOleksyn Anthony · Fairport, NYBuilt 1967 · S/N 17700191N2392CRoot Eric J · Lakewood, COBuilt 1954 · S/N 30692N2392FDingo Aviation LLC · Kalispell, MTBuilt 1965 · S/N 21058592N2392RHarvey Aaron C · Bandon, ORS/N 18255492N2392XSmm Leasing LLC · Camp Verde, AZBuilt 1965 · S/N 18256292N2393CKocon Tyler · Puyallup, WABuilt 1954 · S/N 30693N2393DSoares Manuel J · Wasilla, AKBuilt 1952 · S/N 20545N2393FGreengo Aviation LLC · Temple, TXBuilt 1965 · S/N 21058593N2394DRegistration Pending · Fort Ripley, MNRegistration pendingBuilt 1952 · S/N 20546N2394FN2394 Fox LLC · Sapulpa, OKBuilt 1965 · S/N 21058594N2394SSale Reported · Wild Rose, WISale reportedBuilt 1979 · S/N R18201336N2394XPierson Daniel · Kalispell, MTS/N 18256294N2395RSweitzer Derrick L · Stewartstown, PAS/N 18255495N2395UBucher Sheldon L · Divide, COBuilt 1962 · S/N 17249995N2395XEdwards Keith D · Olathe, KSBuilt 1965 · S/N 18256295N2395YRice Dwight D · Loma Linda, CABuilt 1967 · S/N 17700195N2396DClark Patrick L · Kenai, AKS/N 20548N2396FFlippin Birds Aviation LLC · Mobile, ALBuilt 1965 · S/N 21058596
Back to AD 87-20-03 R2