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.

N712VTMiddle Fork Aviation Inc · Challis, IDBuilt 1967 · S/N U206-0932N71300Finch Merry B · Marysville, CABuilt 1969 · S/N 18259568N71305Fisher Vincent E · Burrton, KSBuilt 1969 · S/N 18259570N7130AJohnston David E · Fort Myers, FLBuilt 1956 · S/N 29230N7130FRicker Gary L · Greeneville, TNS/N 15063730N7130SHansen Christopher H · Durhamville, NYBuilt 1967 · S/N 15067830N71317Abbatiello Vincent Jr · Cape Coral, FLBuilt 1969 · S/N 18259575N7131AOneill Mark B · Pinckney, MIBuilt 1956 · S/N 29231N7131ETravis Michael James · Burns, ORS/N 52131N7131FSchoch Brayden · Fort Pierce, FLBuilt 1966 · S/N 15063731N7131SMaya Aircraft Holdings LLC · Lee, NHBuilt 1981 · S/N R18201697N7131TReyes Jose Daniel Cruz · Wilmington, NCBuilt 1959 · S/N 46731N7131XEaa Charter 1093 · Midland, MIS/N 15059231N71320Wptd Inc · Munster, INBuilt 1969 · S/N 18259577N71321Boyle Christopher R · Truckee, CABuilt 1969 · S/N 18259578N71323Air Legacy LLC · Chanhassen, MNBuilt 1969 · S/N 18259579N71326Lrc Aero LLC · Jacksonville, TXS/N 18259580N7132QAero Quest LLC · Olive Branch, MSBuilt 1972 · S/N 17260432N71331Baird David W · Kanab, UTBuilt 1969 · S/N 18259582N71333Delaney Michael T · Edmonds, WABuilt 1969 · S/N 18259583N71336Aviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1969 · S/N 18259585N7133APeacock Richelle L · Arcadia, FLBuilt 1956 · S/N 29233N7133FCarrolls Auto And Aircraft Sales LLC · Muncie, INBuilt 1966 · S/N 15063733N7133QPage Aerial Service Inc · Rochelle, ILBuilt 1972 · S/N 17260433N7133TQuam Gary L · Rio, WIBuilt 1959 · S/N 46733N7134FMejean Kenneth R · Brandon, FLBuilt 1966 · S/N 15063734N7134MTravis Craig W · Fallon, NVBuilt 1958 · S/N 55434N71354Willis Enterprises · Enterprise, ORBuilt 1969 · S/N 18259589N71355Dal Tex Flyers Inc · Arlington, TXBuilt 1969 · S/N 18259590N71359Sparks Fly LLC · Mount Gilead, OHBuilt 1969 · S/N 18259593N7135AMoss Colin · Sparta, NCBuilt 1956 · S/N 29235N7135FMiller Joseph A · Amissville, VABuilt 1966 · S/N 15063735N7135QHoman Larry E · Sigourney, IABuilt 1972 · S/N 17260435N71369Gosney James R Trustee · Silver City, NMBuilt 1969 · S/N 18259595N7136ACross Frank · Huntsville, MOBuilt 1956 · S/N 29236N7136ECreel Jeffrey G · Gaylesville, ALBuilt 1959 · S/N 52136N7136GFairchild Natalie J · Drummond Island, MIS/N 15074614N7136QPa Lawrence LLC · Anchorage, AKBuilt 1972 · S/N 17260436N7136SGonzalez Alec · Homestead, FLBuilt 1967 · S/N 15067836N7136TSnouffer Robert E · Mountain Grove, MOBuilt 1959 · S/N 46736N7136XArchangel Michael Flyers Inc · Princeville, HIS/N 17702290N71374Farmers Supply Corp · Ontario, ORBuilt 1969 · S/N 18259596N71378Hanson Jared E · Missoula, MTBuilt 1969 · S/N 18259598N7137ACarrico Drew E · Redway, CABuilt 1956 · S/N 29237N7137ESss Inc · Anchorage, AKBuilt 1959 · S/N 52137N7137TLeavitt John E · Palmer, AKBuilt 1959 · S/N 46737N71384Neal Donald L · Fresno, CABuilt 1969 · S/N 18259600N71386Single Engine Flyers LLC · Fredericksburg, TXBuilt 1969 · S/N 18259601N7138GWerenko Zandra · Cape Canaveral, FLBuilt 1973 · S/N 15074616N7138QArctic Aviation Leasing LLC · Anchorage, AKBuilt 1975 · S/N U20603074
Back to AD 87-20-03 R2