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.

N9958TKonefal Arthur J · Fairbanks, AKBuilt 1960 · S/N 18253058N99598Registration Pending · Argyle, TXRegistration pendingBuilt 1985 · S/N 17276474N9959ANelson Jayson A Trustee · Caldwell, IDBuilt 1950 · S/N 19319N9959BHackamore Equipment LLC · Prairie City, SDBuilt 1957 · S/N 34359N9959ETyler Matthew S · Lakeside, CABuilt 1975 · S/N 18264019N9959HThibault William N · Newport Beach, CABuilt 1981 · S/N 18268144N9959RRusyniak Anthony J · Syracuse, NYBuilt 1986 · S/N U20607000N9959XMiller Keith D · Pittsburgh, PAS/N 1850159N9959YGrand Aviation LLC · Winter Park, COFirst renewal noticeBuilt 1982 · S/N 21064648N995JAN995ja LLC · Ft Lauderdale, FLBuilt 1974 · S/N 17263989N995NABucher Devin V · Kalispell, MTBuilt 1966 · S/N 17255575N995SBRossi Randall A · Georgetown, TXBuilt 1974 · S/N 18262473N995VZMeyerowitz Noah A · Great Barrington, MABuilt 1974 · S/N 177RG0478N99606Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276478N9960BSouthern Aircraft Leasing LLC · Montgomery, ALBuilt 1957 · S/N 34360N9960EArklamiss Aviation LLC · Ruston, LAS/N 17272299N9960NBoemer Steven E · El Cajon, CABuilt 1982 · S/N 18504377N9960RInternational Air Services Inc Trustee · Carson City, NVS/N U20607001N9961ERuryk Jonathan D · Pineville, LABuilt 1979 · S/N 17272300N9961VCk Leasing Services LLC · Wilmington, DEBuilt 1974 · S/N 17264579N9962ESynergy Financial Services Inc · Vancouver, WABuilt 1975 · S/N 18264022N9962MFox Aircraft LLC · Bethel, AKS/N 20700765N9962TWh72 LLC · Lincoln, NEBuilt 1960 · S/N 18253062N9963EDenski David T · Plymouth, MIBuilt 1979 · S/N 17272301N9963NWoodward Aviation LLC · Alpine, TXBuilt 1975 · S/N 18052618N9963YN9963y LLC · Provo, UTBuilt 1982 · S/N 21064649N9964CTakle Management LLC · Bethany, OKBuilt 1964 · S/N 18255519N9964EJansen Christopher · Stilwell, KSBuilt 1975 · S/N 18264024N9964HBuchanan Gary · Jay, FLFirst renewal noticeBuilt 1981 · S/N 18268148N9964LHess Garrett J · Fullerton, CABuilt 1986 · S/N 17276652N9964YGreenspun Mark H · Washington, DCBuilt 1982 · S/N 21064650N9965ARobertson Francis E · Hibbing, MNBuilt 1950 · S/N 19325N9965BTuma Tom · Cut Bank, MTS/N 34365N9965XNistler Matt J · Three Forks, MTBuilt 1961 · S/N 185-0165N9966BKimbrell Heath · Quinlan, TXS/N 34366N9966NBeeson John Charles · Palmer, AKBuilt 1975 · S/N 18052621N9966TItalio River Adventures LLC · Yakutat, AKBuilt 1960 · S/N 18253066N9966VLeisner David L · Palmer, AKBuilt 1974 · S/N 17264584N9966XFickus Timothy R · North Pole, AKBuilt 1961 · S/N 185-0166N9967CJoemac Business Services LLC · Casper, WYBuilt 1978 · S/N R18200492N9967NSawtooth Aviation LLC · Hovland, MNBuilt 1975 · S/N 18052622N9967RBravan Aviation · Fort Lauderdale, FLBuilt 1986 · S/N U20607005N9968APickett Steven M · Odenville, ALBuilt 1950 · S/N 19328N9968CPaulin Gregory H · Flagstaff, AZBuilt 1978 · S/N R18200493N9968EReeder Joseph · Northfield, MNBuilt 1975 · S/N 18264028N9968GPetecraft Aviation Services Inc · Plains, GABuilt 1971 · S/N 18800768N9968JBoening Bros Dusting & Spraying Scv · Floresville, TXBuilt 1981 · S/N T18803897TN9968LMw Flying LLC · Sanford, NCBuilt 1986 · S/N 17276654N9968NBuhannic Patrick A · Shepherdstown, WVS/N 21063259N9968TMontague Robert · Kilmichael, MSBuilt 1960 · S/N 18253068
Back to AD 87-20-03 R2