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.

N2657FPoolshark Equipment LLC · Memphis, TNBuilt 1965 · S/N 18256757N2657S57 Sierra LLC · Houston, TXBuilt 1968 · S/N 337-0957N2657USzymanski Janet M · Alanson, MIBuilt 1963 · S/N 17250257N2657YNagy Leslie S · Walnut Creek, CABuilt 1962 · S/N 18051157N2658CMay Jeffrey P · Seligman, AZBuilt 1978 · S/N R18200198N2658FClayton Alfred T · Anchorage, AKBuilt 1965 · S/N 18256758N2658GSauer Roger A · Glenburn, NDBuilt 1959 · S/N 51958N2658JLife Finds A Way LLC · Sarasota, FLBuilt 1966 · S/N 15065658N2658RNorthern Science Services LLC · Anchorage, AKBuilt 1967 · S/N 18258358N2658VGriffin Robert L · Warren, OHBuilt 1948 · S/N 18168N26595Levy Alfred E · Richardson, TXBuilt 1971 · S/N 18260616N2659GMarmon David J · Great Falls, MTBuilt 1959 · S/N 51959N2659KWickline Wayne · Flower Mound, TXBuilt 1985 · S/N 18268502N2659QMorrison Mark C · Marfa, TXBuilt 1966 · S/N 18257859N2659RBerrios Antonio · Genoa, ILBuilt 1967 · S/N 18258359N2659SRovey Gerald A · Troy, IDBuilt 1973 · S/N 18502261N2659ZWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284521N265DTLynn Daniel K · Beaverton, ORBuilt 1975 · S/N 18264034N265ERAerosolutions Group Inc · Wilmington, DEBuilt 1976 · S/N 17268081N265HPN265hp LLC · Parachute, COBuilt 1985 · S/N 18268519N2660Applegate Land Holdings LLC · Jacksonville, ORBuilt 1981 · S/N 18268100N26601Trowbridge Rodney L · Haysville, KSBuilt 1968 · S/N 18259083N2660FWheels Up Aviation Inc · Lewes, DES/N 18256760N2660GFruge Cory · Egan, LABuilt 1959 · S/N 51960N2660RPa Bo Ma Inc · Alexandria, LABuilt 1967 · S/N 18258360N2660YRam Aviation LLC · Palmer, AKBuilt 1962 · S/N 18051160N2661ABerry Scott F · Destin, FLBuilt 1968 · S/N 18259102N2661DWhite Theodore F · Willow, AKBuilt 1952 · S/N 20813N2661LHall David B Jr · Midland City, ALBuilt 1967 · S/N 17255861N2661QAlred Robert I · Barrow, AKBuilt 1966 · S/N 18257861N2661UMoret Ronald P · Los Osos, CABuilt 1963 · S/N 17250261N2661VParker Alan A · Visalia, CABuilt 1948 · S/N 18171N2661YAlaska Outdoor Consultants LLC · King Salmon, AKBuilt 1962 · S/N 18051161N2662DReakoff Jack L · Wiseman, AKBuilt 1952 · S/N 20814N2662GWhitman Monty · Pagosa Springs, COBuilt 1959 · S/N 51962N2662JHanel Bruce · Placerville, CABuilt 1966 · S/N 15065662N2662LWaller Leslie P · Cynthiana, KYBuilt 1967 · S/N 17255862N2662UDeal Sarah M · Saint Joseph, MIBuilt 1963 · S/N 17250262N2662VPeck Kim O · Bolton, MABuilt 1974 · S/N 177RG0647N2662XTail Aero Corp · Wilmington, DEBuilt 1965 · S/N P206-0162N2663DGuy Gary L · Fairbanks, AKBuilt 1952 · S/N 20815N2663QBerg Weston L · Stanton, NDBuilt 1966 · S/N 18257863N2663SMaclean Kenneth J · Northborough, MABuilt 1968 · S/N 337-0963N2663UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 17250263N2663VGuthrie Michael E · North Highlands, CABuilt 1948 · S/N 18173N2664DGee Ryan S · Luverne, MNS/N 20816N2664SMcclain Daniel S · Enon Valley, PABuilt 1968 · S/N 337-0964N2664VKeaveny Kelly J · Annandale, MNBuilt 1974 · S/N 177RG0648N2665CWindsock Skies LLC · Caldwell, TXBuilt 1978 · S/N R18200201N2665LKay Bennie L · Brigham City, UTBuilt 1967 · S/N 17255865
Back to AD 87-20-03 R2