OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N5813SBailey Craig R · Poplar Grove, ILBuilt 1964 · S/N D-7721N5815FHubbard Scott N · New Brighton, MNBuilt 1966 · S/N 21058815N5816PWolf Michael A · Rutledge, TNBuilt 1996 · S/N 29-0087N5817KMunsch James R · Algonquin, ILBuilt 1965 · S/N CD-887N581AFAirtrust LLC 11 Series 11 Trustee · Sheridan, WYBuilt 2003 · S/N TH-2063N581BVStueber Daniel A · Royse City, TXBuilt 1987 · S/N CE-1177N581CBColorado Baron LLC · Ketchum, IDBuilt 1979 · S/N TJ-233N581CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N TH-1183N581CMUgashik Inc · King Salmon, AKS/N 18502805N581CPRdc Leasing Lc · Johnston, IABuilt 1980 · S/N 18504090N581CTFraley Stuart W · Indianapolis, INBuilt 1980 · S/N 18504181N581ECoobac Dean P · Alpine, WYBuilt 1973 · S/N TH-423N581GHarper Abe L Jr · Daphne, ALBuilt 1976 · S/N TH-716N581JTMckenna John Jr Trustee · Bozeman, MTBuilt 1978 · S/N 18503662N581KBFenn Farms Inc · Durham, CABuilt 1975 · S/N E-786N581PFFox Arrow 542 LLC · Jonesboro, ARBuilt 1993 · S/N TH-1707N581PSBonanza Aviation LLC · Wilmington, DEBuilt 1999 · S/N TH-1903N581SACalifornia Industrial Rubber Co Inc · Fresno, CABuilt 2000 · S/N TH-1942N581SHShowtime Aviation LLC · Frostproof, FLBuilt 2001 · S/N TH-2011N5820SHemmeger Scott E · Kokomo, INBuilt 1964 · S/N D-7724N5821FFlite Five Inc · Kiowa, KSBuilt 1966 · S/N 21058821N5822FGrein David A · Mokena, ILS/N 21058822N5822SPatton Aviation LLC · Billings, MTBuilt 1964 · S/N D-7726N5822WKanza Aviation LLC · Andover, KSBuilt 1971 · S/N TH167N58235Collins Wayne J · Lubbock, TXBuilt 1966 · S/N 188-0033N5825KBonanza Over Miami Inc · Coral Gables, FLBuilt 1965 · S/N D-7855N5825MLee Brian P · Kent, WABuilt 1969 · S/N 310P0125N5826CBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 402C0050N5826KObiewan Air Services LLC · Manvel, TXBuilt 1965 · S/N D-7842N5827FBok Hans · North Dartmouth, MABuilt 1966 · S/N 21058827N5827MHopland Steve · Johnson City, TNBuilt 1972 · S/N 340-0051N5828FKissell Ryan · Mount Vernon, OHBuilt 1966 · S/N 21058828N5828SCustom Ag LLC · El Centro, CABuilt 1964 · S/N D-7727N5829FMoa Klinton J · Bellingham, WABuilt 1966 · S/N 21058829N582SBHardy Gordon H · Belmont, CABuilt 1978 · S/N TJ-172N582TAWiday John P · El Cajon, CABuilt 1979 · S/N TJ-191N582TMArnst Jodi M · Clio, MIBuilt 1974 · S/N E-582N58302Gillett John W · Hillsboro, ORBuilt 1972 · S/N 18501966N5830FSuchy Karel · Kenosha, WIBuilt 1966 · S/N 21058830N5830JMontague Brett A · Van Buren, OHBuilt 1970 · S/N 18501799N5830KAmigliore Gary E · Anaheim, CABuilt 1965 · S/N D-7890N58316Labelle-Hamer Brendan T · Fairbanks, AKBuilt 1977 · S/N 18503284N5831KWright Scott M · Tulare, CABuilt 1965 · S/N D-7840N5831RBroome Adam H · Chapel Hill, NCBuilt 1983 · S/N E-2096N5831SDangberg Dennis C · Wayne, NES/N D-7731N5832KSutton Sean A · Fort Lauderdale, FLBuilt 1965 · S/N D-7843N5832SRoutt Thomas · Norfolk, VABuilt 1964 · S/N D-7729N5833FVermillion Fc-1 LLC · Crystal City, TXBuilt 1966 · S/N 21058833N5833KFostvedt Kim C · Elkhorn, NEBuilt 1965 · S/N D-7844N5833SDelp William H · Doral, FLBuilt 1964 · S/N D-7744
Back to AD 86-13-04 R3