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.

N710KTBradshaw Jeffrey T · Clearwater, FLBuilt 2005 · S/N 1347N710MHK Bay Air LLC · Homer, AKBuilt 1974 · S/N U20602383N710PCCirrusly Aviation LLC · Natchez, MSBuilt 2003 · S/N 0754N710TDDuke Ray J · Oak Point, TXBuilt 1976 · S/N 21061424N7114NPrairie Air Inc · Elbow Lake, MNBuilt 1967 · S/N D-8668N7116NMook Joshua Tyler · Cincinnati, OHBuilt 1967 · S/N D-8670N7116WEzra Aviation LLC · Katy, TXBuilt 1974 · S/N 421B0827N711AMNixon Bruce C · Portales, NMBuilt 1979 · S/N E-1487N711BGSaybrook Offshore LLC · Guilford, CTBuilt 1982 · S/N P21000806N711CBRoundhive Corp · New York, NYBuilt 1979 · S/N 340A0913N711CGOptimal Aircraft Management Nc LLC · Sanford, MIBuilt 2004 · S/N 1135N711FBLing Scott P · Old Saybrook, CTBuilt 1971 · S/N U20601651N711HEDesert West Enterpises LLC · Roswell, NMBuilt 1979 · S/N P21000242N711HRMarshall Phillip W III · Enid, OKBuilt 1974 · S/N E-519N711JFTwin D LLC · Lake City, FLBuilt 1978 · S/N 21062817N711KMRegistration Pending · Cologne, MNRegistration pendingBuilt 1970 · S/N D-9106N711LACrosby David J · Potomac, MDBuilt 1971 · S/N 30411N711MLShuff James S II · Victor, WVS/N 340-0090N711NCHussey Aviation LLC · Clear Lake, IAS/N D-9776N711PJRender Chad · Pine Bluff, ARS/N 21061128N711PRDaniel Dewey · Okeechobee, FLBuilt 1974 · S/N E-608N711RBMorris John C III · Rochester, MNBuilt 1969 · S/N D-9015N711SDMundy William L · Proctorville, OHS/N 340A0958N711SLAbc Leasing Inc · Oakdale, LABuilt 1978 · S/N CE-773N711THTri-County Sprayers Inc · Hamlin, TXS/N E-246N711TMPeters James L Trustee · Brighton, MIBuilt 1976 · S/N 21061301N711TRAtomic Cat LLC · Hamilton, MTS/N TE-350N711TVRepko Ventures LLC · Logan, UTBuilt 1965 · S/N D-7931N711TWMartens Ruth C · Wheaton, ILBuilt 1978 · S/N 21062654N711VSMilne Jeff J · Lake Geneva, WIBuilt 1975 · S/N E-756N711WJBeaubien Philippe R · Houston, TXBuilt 2005 · S/N 29-0390N711XVeetail LLC · Land O Lakes, FLBuilt 1964 · S/N D-7732N711YLBurkett Gary L Trustee · Murfreesboro, TNBuilt 1979 · S/N 340A0955N7121NLockbaum Jim · Oconomowoc, WIBuilt 1967 · S/N D-8674N7124NClifton Fred R Jr · Fredericksburg, TXBuilt 1967 · S/N D-8677N7127NGraber Loren · Lake Tapps, WABuilt 1968 · S/N TE-516N7128NMartin Automatic Inc · Rockford, ILBuilt 1967 · S/N D-8675N712CDLamadera Enterprises LLC · Lufkin, TXBuilt 2001 · S/N 0027N712CPMid Mo Aviation LLC · Huntsville, MOBuilt 1977 · S/N 310R0883N712GDOsborne David · Texarkana, ARBuilt 1980 · S/N TH-1107N712GLThere And Back LLC · Tulsa, OKBuilt 1975 · S/N 340A0029N712JWFalcon & Phoenix Aviation LLC · Las Vegas, NVBuilt 1969 · S/N 421A0128N712JZHeffley Brothers Flying Circus LLC · Benbrook, TXBuilt 1975 · S/N TH-671N712LSDwyer Stephen C · The Woodlands, TXBuilt 1979 · S/N TJ-192N712NDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 29-0413N712SBSinger Nathan · Pismo Beach, CABuilt 1975 · S/N 310R0122N712SREsplin Clyde D · Ontario, ORS/N 30106N712VTMiddle Fork Aviation Inc · Challis, IDBuilt 1967 · S/N U206-0932N7131Van Dyke Bryan C · Wichita, KSBuilt 1997 · S/N E-3093N7131GKao Allen K L · Burnsville, MNS/N CF20890885
Back to AD 86-13-04 R3