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.

N234TCAg N234tc LLC · South Salt Lake, UTBuilt 1974 · S/N 310R0050N234WIwaa Inc · Woodstock, GABuilt 1976 · S/N 21061618N234WBDrake Colin · Mendocino, CABuilt 1969 · S/N D-8952N234WSMancini Gary Ray · Livermore, CABuilt 2004 · S/N 29-0343N2351FStewart Anthony D · Blytheville, ARBuilt 1964 · S/N 21058551N23523Fox & Bear Air Charters LLC · South Padre Island, TXBuilt 1977 · S/N E-1175N2352YMilton Jerry D · Lillington, NCBuilt 1998 · S/N TH-1865N23534Schwabenton William J · Greensboro, NCBuilt 1977 · S/N CE-751N23540State Of Iowa · Iowa City, IABuilt 1977 · S/N E-1180N23541Registration Pending · Middleburg, FLRegistration pendingBuilt 1977 · S/N E-1182N23542Mrj Aviation LLC · Attica, NYBuilt 1977 · S/N D-10085N2354BHigh Sky LLC · Rogers, ARBuilt 1968 · S/N D-8831N2354FBarbee William Terry · Weslaco, TXBuilt 1998 · S/N E-3154N23551S&M Aviation (A Co Limited Liability Co) · Colorado Springs, COBuilt 1977 · S/N E-1183N2355TBe-3195 LLC · Conway, ARBuilt 1998 · S/N E-3195N23571Dlat Holdings LLC · Allen, TXBuilt 1977 · S/N TE-1120N23578Green Law Aviation Inc · Culpeper, VABuilt 1977 · S/N E-1185N2357FBachand Kevin L · Leesburg, VABuilt 1964 · S/N 21058557N2357NCreviston Steven Eric · Greensboro, NCBuilt 1998 · S/N E-3157N23589High Times Adventure Co LLC · Columbiana, ALBuilt 1977 · S/N TH-889N2358FEast County Communications Inc · Hurricane, UTBuilt 1965 · S/N 21058558N2358KSmith Aeromotive Charters Inc · Excelsior, MNBuilt 1997 · S/N TH-1827N2359FSheldon David E Trustee · Idaho Falls, IDBuilt 1964 · S/N 21058559N2359LJ & M Baling Inc · Farmington, NMBuilt 1998 · S/N E-3159N235DRegistration Pending · Mead, CORegistration pendingBuilt 1978 · S/N TJ-134N235EMcfarland Joel Cable · East Earl, PABuilt 1963 · S/N D-7162N235EGHch Aircraft LLC · El Paso, TXBuilt 1985 · S/N EA-443N235RRegistered aircraftBuilt 1966 · S/N D-8360N235RDGrady Fun Flying LLC · Grady, OKBuilt 1973 · S/N D-9446N235SLifetime Aviation LLC · Lewes, DEBuilt 1964 · S/N D-7326N235SEPlane Flt LLC · Broken Arrow, OKBuilt 1981 · S/N E-1953N235SMTriniair LLC · Warner Robins, GAS/N TH-926N235WJmzb Leasing LLC · Amarillo, TXBuilt 1979 · S/N 21063206N235WHTail Aero Corp · Wilmington, DEBuilt 1977 · S/N 21061797N23607Green P Stephen · Steamboat Springs, COBuilt 1977 · S/N D-10088N23612Lcms Limited · Durham, NCBuilt 1977 · S/N CE-756N23615Yoder Metal & Post Frame & Building Supplies · Haven, KSBuilt 1977 · S/N E-1191N23620Erickson Brian C · Pahrump, NVBuilt 1977 · S/N E-1165N23621Excellance Inc · Madison, ALBuilt 1977 · S/N E-1192N23639Teleprint Inc · Rydal, PABuilt 1978 · S/N E-1293N2363FColumbus State Community College · Columbus, OHBuilt 1964 · S/N 21058563N23642Samson Motors Inc · Redmond, ORBuilt 1977 · S/N CE-759N2364FCarlson David G Trustee · Cape Fair, MOBuilt 1964 · S/N 21058564N23674Siebenhaar Harold J · Los Altos, CAS/N D-10146N23682Next Century Aviation Oregon LLC · Sausalito, CABuilt 1978 · S/N E-1205N23685Clements Dennis · Chapel Hill, NCBuilt 1978 · S/N D-10099N236ATN236at LLC · Miami, FLBuilt 1975 · S/N 414-0805N236BEMcgill Benjamin D · Larchmont, NYBuilt 1981 · S/N E-1825N236CHGta Air Inc · Addison, TXBuilt 1973 · S/N E-502N236CTCostanzo Ralph R · Virginia Beach, VABuilt 1968 · S/N E-51
Back to AD 86-13-04 R3