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.

N4073DKarsell Kris J · Duluth, MNBuilt 1958 · S/N 34773N4073FStebbins Craig S · Glendive, MTBuilt 1958 · S/N 36973N4073UNew Entity Corp · Hardy, ARS/N 15061473N4073VBryant Dorothy A · Arlington, SDBuilt 1948 · S/N 18405N4074DDimitriadis Joseph T · Las Vegas, NVBuilt 1958 · S/N 34774N4074YMcaleer John D · Aurora, ORBuilt 1961 · S/N 1850274N4075FPrice Timothy C · Rancho Cucamonga, CABuilt 1958 · S/N 36975N4075JB&R Aircraft LLC · Wadsworth, OHBuilt 1966 · S/N 15065375N4075UWright Joseph G · Medicine Lodge, KSBuilt 1965 · S/N 15061475N4076FStebbins Robert A · Cookson, OKS/N 36976N4076UKoehn David Scott · Orange Beach, ALS/N 15061476N4076VPennington Charles A · Fort Smith, ARBuilt 1975 · S/N 15076691N4076YPhillips Halvor A · Winnemucca, NVBuilt 1961 · S/N 185-0276N4077D234kq LLC · Eagle, IDBuilt 1957 · S/N 34777N4077ECalef Jere Trustee · Mojave, CABuilt 1965 · S/N 15061477N4077FSolomon Joseph E Jr · Modesto, CABuilt 1958 · S/N 36977N4077YWalker Air LLC · Charleston, WVBuilt 1977 · S/N 18265351N4078DFinney James R · Howe, TXBuilt 1957 · S/N 34778N4078FJanes Christopher D · Columbia, KYBuilt 1958 · S/N 36978N4078UHoover Michael B · Ridgeland, WIBuilt 1965 · S/N 15061478N4079DErnst Gregory R · Eagle Creek, ORBuilt 1957 · S/N 34779N4079FCovington Gary N · Midland, TXFirst renewal noticeBuilt 1958 · S/N 36979N4079UScribner Jeffrey D · Upton, MEBuilt 1965 · S/N 15061479N4079VGovednik Frank J · Nipomo, CABuilt 1948 · S/N 18411N4080DCrane Gary W · Gig Harbor, WABuilt 1957 · S/N 34780N4080FGoggans John L · Mansfield, MOBuilt 1958 · S/N 36980N4080YPanama City Cycles Inc · Panama City, FLBuilt 1961 · S/N 1850280N4081DEarl Tim G · Plymouth, CAS/N 34781N4081VLark Thomas S · Coppell, TXBuilt 1975 · S/N 15076694N4082DSharp Nicholas · Valdez, AKBuilt 1957 · S/N 34782N4083DAerohawk Aviation Inc · Idaho Falls, IDBuilt 1957 · S/N 34783N4083UKadlecovic Martin · Prescott, AZBuilt 1964 · S/N 15061483N4085UHilderbrand Timothy S · Chicora, PABuilt 1965 · S/N 15061485N4085VGeorge Daniel W · Reynoldsburg, OHBuilt 1948 · S/N 18417N4086DThompson George M · Fairbanks, AKBuilt 1957 · S/N 34786N4086FShelton Joseph G · Kingman, AZBuilt 1958 · S/N 36986N4086JBell Robert A Jr · Scotland Neck, NCBuilt 1966 · S/N 15065386N4086VBoyd Darrell M · Claremore, OKBuilt 1975 · S/N 15076695N4087VYakima 65 N Flying Club · Yakima, WABuilt 1948 · S/N 18419N4088DIron Horse Aviation LLC · Omak, WABuilt 1957 · S/N 34788N4088JLampasona Brendan T · Citrus Springs, FLBuilt 1966 · S/N 15065388N4088VSlezak Daniel S · Santa Margarita, CABuilt 1975 · S/N 15076696N4089DGaffney Justin L · Arcata, CABuilt 1958 · S/N 34789N4089VIhlenfeld Mark A · Owatonna, MNBuilt 1948 · S/N 18421N408GHMcdowell Kevin A · Tumwater, WABuilt 1959 · S/N 57075N408LJHuston Craig C · Keokuk, IABuilt 1975 · S/N 18264147N408RStone Aviation LLC · Cusick, WABuilt 1954 · S/N 31149N4090FFox Aero Club · Catawba, NCBuilt 1958 · S/N 36990N4090HSouthern Air Transport Services LLC · Dover, DEBuilt 1969 · S/N 18052083N4092VGroves Donald L · Butler, PABuilt 1975 · S/N 15076697
Back to AD 87-20-03 R2