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.

N4405CDavis Richard L · Everett, WABuilt 1952 · S/N 7990N4405LKopcho Thomas L · York, NEBuilt 1966 · S/N 17254490N4405RBon Homme Flyers Inc · Tyndall, SDBuilt 1974 · S/N 17263155N4406BAndersen Gregory A · Kenai, AKBuilt 1955 · S/N 26750N4406RDe Nora Christian G · San Antonio, TXBuilt 1976 · S/N 18052670N4406VPacific Aviation Aircraft Management Inc · Fresno, CABuilt 1948 · S/N 18539N4407QSund Manufacturing Co · Newburg, NDS/N 17261698N4407RRhyneer Loren S · Anchorage, AKBuilt 1976 · S/N 18502946N4408BBrookover Thomas E · Anchorage, AKBuilt 1955 · S/N 26752N4408CBarron Aviation LLC · Perry, MOBuilt 1952 · S/N 7993N4408VScott Tony D · Mangum, OKBuilt 1948 · S/N 18541N4409BDavis John A · Waller, TXS/N 26753N4409RRegistration Pending · Albany, ORRegistration pendingBuilt 1974 · S/N 17263158N4410BRhymes Dustin A · Upland, CABuilt 1955 · S/N 26754N4410LLenhart James A · Manchester, MIBuilt 1966 · S/N 17254495N4410QAyer Benjamin D · Newport, MEBuilt 1973 · S/N 17261699N4410RSpane John T · Mount Airy, NCBuilt 1974 · S/N 17263159N4410TLavin Gregory S · Chugiak, AKBuilt 1982 · S/N 18504335N4410VMorris Roy S · Shorter, ALBuilt 1948 · S/N 18543N4411Mh Aviation LLC · Dublin, CABuilt 1965 · S/N 15062560N4411BFerguson James L · Junction City, KSBuilt 1955 · S/N 26755N4411CBartko Ramon · Pittsburg, TXS/N 7996N4412BGiraffe & Platypus Aviation Ltd · Fort Collins, COBuilt 1955 · S/N 26756N4412QWoods Flying Service LLC · Memphis, MOBuilt 1971 · S/N 18800812N4413BBynum Sonia · Portland, ORBuilt 1955 · S/N 26757N4413CSteele Aviation Inc · Walnut Cove, NCS/N 7998N4413SBirmingham Flight Center LLC · Birmingham, ALS/N 17257905N4413USpears David A · Naperville, ILBuilt 1964 · S/N 15060413N4414CJohnson Thomas W · Westminster, MDBuilt 1953 · S/N 7999N4414RKirk Ledoux · Stanwood, WABuilt 1979 · S/N U20605111N4414VVan Noy Greg A · Bozeman, MTBuilt 1948 · S/N 18547N4415CHunter Mason B · Helena, MTBuilt 1952 · S/N 16000N4415RNextgen Flight Academy Inc · Riverside, CABuilt 1974 · S/N 17263163N4416LBustamante Marcos H · Nogales, AZBuilt 1966 · S/N 17254503N4416VWiebe Aron Fehr · Seminole, TXBuilt 1948 · S/N 18549N4417UBlacqjacq Aviation Co · Wilmington, DEBuilt 1964 · S/N 15060417N4418BFulwiler Daniel R · Green Bay, WIBuilt 1955 · S/N 26762N4418LIroquois Soaring Assn · Rome, NYBuilt 1966 · S/N 17254505N4418RTeton Leasing LLC · Pocatello, IDBuilt 1974 · S/N 17263166N4419BStaubach Adam R · North Pole, AKBuilt 1955 · S/N 26763N4419LMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 17254506N441AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1983 · S/N 17276091N441DLPinion Aviation Inc · Glenbrook, NVBuilt 1976 · S/N 17267391N441DPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1975 · S/N 17265691N441NAHendry Rickey W · Apple Springs, TXBuilt 1955 · S/N 32198N441SPPendragon Aviation LLC · Sylvania, GABuilt 1982 · S/N 18268215N441SSSchwarz Mickey D · Thorndale, TXBuilt 1964 · S/N 15060512N441TJRylee LLC · Lawrence, KSBuilt 1979 · S/N 18267141N441TSRawareo LLC · Warsaw, MOBuilt 1966 · S/N 17254288N44200Cessna172 LLC · Holliday, TXBuilt 1956 · S/N 28127
Back to AD 87-20-03 R2