OpenAirDocs.org
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.

N8143TMatheny Larry E · Litchfield, MNBuilt 1960 · S/N 17556843N8143UJon Boyd Beard · Houston, TXBuilt 1964 · S/N 17252043N8143VCenterline Holdings Inc · Camden, DEBuilt 1974 · S/N A1500539N8143ZMoojens LLC · San Carlos, CABuilt 1962 · S/N 205-0143N8144BPepper Marcus · San Antonio, TXBuilt 1957 · S/N 29944N8144SRegistered aircraftBuilt 1965 · S/N 15061744N8144TShanklin Christopher G · Port Aransas, TXBuilt 1960 · S/N 17556844N8144UHansen Kermit E · Ryder, NDBuilt 1976 · S/N 15077901N8144VLundahl Frederick B · Langley, WABuilt 1974 · S/N A1500540N8144XBeadles Scott D · Valley Springs, CABuilt 1961 · S/N 17248644N8145AAllen John Jay · Bloomington, ILBuilt 1952 · S/N 20997N8145BRojas Luis Alberto · Riverside, CABuilt 1957 · S/N 29945N8145SBissat Rishid H · Visalia, CABuilt 1965 · S/N 15061745N8145TLobitz Walter A · Lake Almanor, CABuilt 1960 · S/N 17556845N8145XEast Carolina Aviation LLC · Camden, NCBuilt 1961 · S/N 17248645N8146QOak Gulch LLC · Killdeer, NDBuilt 1975 · S/N U20603097N8146UBearce Todd A · Phoenix, AZS/N 17252046N8146VAnthony Michael L · Sanger, TXBuilt 1974 · S/N A1500541N8147SHoehn Ronald T · Perryville, MOS/N 15061747N8147VSchmitt Rudy · Brookshire, TXBuilt 1968 · S/N 188-0397N8148BRoberts Michael · Port Orchard, WABuilt 1957 · S/N 29948N8149BBergstrom Matthew James · Renton, WABuilt 1957 · S/N 29949N8149MMcinnish John · Tallassee, ALBuilt 1976 · S/N 18264547N8149XBlacksword Armoury Inc · Hawthorne, FLBuilt 1961 · S/N 17248649N814BMMcdaniel Robert L · Columbia, ILBuilt 1966 · S/N 17255216N814DEDickinson Dennis D · St Pete Beach, FLBuilt 1966 · S/N 17254192N814JAdvantage Aviation Services LLC · South Saint Paul, MNS/N 337-0596N814JHOcean Ave LLC · Mound House, NVS/N 18264821N814RReed Mackenzie · Princeton, TXS/N 17260405N8150BFond Of Flying Co · Dover, DES/N 29950N8150LKal Aero Flight Instruction LLC · Mattawan, MIBuilt 1967 · S/N 17256350N8150TAhs Aero LLC · Phoenix, MIS/N 17556850N8150VSchindler Flying Inc · Neligh, NEBuilt 1968 · S/N 188-0400N8151AHayes James R · Sonora, CABuilt 1952 · S/N 25003N8151BBig Valley Flying Club · Lookout, CABuilt 1957 · S/N 29951N8151FMitchell John F · Shannon, ILBuilt 1966 · S/N 15064251N8151LBrown Gary D · Rainbow City, ALBuilt 1967 · S/N 17256351N8151TAffordable Flight Time LLC · Eagle River, AKBuilt 1960 · S/N 17556851N8151UYork George T · Harvard, ILBuilt 1964 · S/N 17252051N8151XEvarts Raymond A · Cedar City, UTS/N 17248651N8152AMattoon Michael · Santa Fe, NMBuilt 1952 · S/N 25004N8152LBowman Douglas M · Elyria, OHBuilt 1967 · S/N 17256352N8152UGentry James L · Englewood, TNBuilt 1964 · S/N 17252052N8152VBrowning Lonnie O IV · Allendale, SCBuilt 1974 · S/N A1500543N8153AKaulback Joseph F · Andover, CTS/N 25005N8153LTr Air LLC · Kenton, OHBuilt 1967 · S/N 17256353N8153SBelli Tony G · Huron, OHBuilt 1965 · S/N 15061753N8153UGorman Shawn Michael · Van Wert, OHBuilt 1964 · S/N 17252053N8153XArmbrister Justin R · Blue Ridge, TXBuilt 1961 · S/N 17248653N8154BWestnyack Aviaiton LLC · Sag Harbor, NYBuilt 1957 · S/N 29954
Back to AD 87-20-03 R2