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.

N695ATL And P Air 2 LLC · Lees Summit, MOBuilt 1974 · S/N 340-0344N695PGTurcaian Export Services Inc · ProvidencialsS/N 401A0114N695SUAlpha Whiskey 2 LLC · Brandon, MSBuilt 1974 · S/N 310R0098N695TClay Kennamer Livestock Farms LLC · Hollywood, ALBuilt 1976 · S/N TK-3N69610Airplane Planet 2 LLC · Dayton, OHBuilt 1974 · S/N 310R0102N69670Rose Aircraft Services Inc · Mena, ARBuilt 1975 · S/N 310R0110N6967BChalk 2 Inc · Apple Valley, CABuilt 1978 · S/N 21062857N6967NSand Creek Oil & Gas Inc · Edmond, OKBuilt 1979 · S/N 21063177N6969YTorres Charles O · Riverside, CABuilt 1966 · S/N T210-0150N696BTSanta Anita Inc · Dallas, TXBuilt 1974 · S/N CE-515N696DTRastavan David DBA · La Habra, CABuilt 1973 · S/N 414-0370N696MCHay Robert G · Point Arena, CABuilt 1990 · S/N CE-1476N696SCWeber Henry II · Victoria, TXS/N 310R0970N696WHGarnett Charles Wade · Hopkinsville, KYS/N E-3048N6970NSeitz Thomas J · Mission, KSFirst renewal noticeBuilt 1979 · S/N 21063179N6972NEnns Robert B · Cayucos, CABuilt 1979 · S/N 21063181N6976NCenturion Capital Partners LLC · Blue Ash, OHBuilt 1979 · S/N 21063185N6977BCollins Kevin T · Roseville, CABuilt 1978 · S/N 21062862N6979BCenturion Bravo LLC · Houston, TXBuilt 1978 · S/N 21062863N6979LIntravaia Anthony J · Saint Louis, MOS/N 310K0079N6979NArango Jorge · Mcallen, TXBuilt 1979 · S/N 21063188N697AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N TH-2423N697CMrc Aviation LLC · Columbia, TNS/N 0443N697KJVillage Center Vail LLC · Tetonia, IDBuilt 2017 · S/N E-4108N6980BBlack Bravo LLC · Newark, DEBuilt 2007 · S/N E-3780N6980MPetumenos Timothy James · Anchorage, AKBuilt 1977 · S/N 21062005N698CMuehlstein Charles W · Stamford, TXBuilt 1999 · S/N 29-0205N6990YV Speed Aviation LLC · Reno, NVBuilt 1964 · S/N 21058490N6993NSp Aircraft LLC · Moscow, IDBuilt 1979 · S/N 21063202N6994HMach 2 LLC · Fairbanks, AKS/N 18503349N6994MParish John L Sr · Tullahoma, TNBuilt 1978 · S/N U20604513N69983Ruble Air LLC · Mechanicsburg, PABuilt 1974 · S/N 310Q1055N6999N3v1 LLC · Pensacola, FLBuilt 1975 · S/N D-9815N699BBProfi-Vision Inc · Fogelsville, PABuilt 1981 · S/N TJ-334N699CDFaridev LLC · White Plains, NYBuilt 2005 · S/N 1505N699EEMathes Jay B · Ridgecrest, CABuilt 1976 · S/N 21061184N699JSJustin Seth Drach Pa · Jacksonville, FLBuilt 1975 · S/N 421B0941N699PSMcmillen Yachts Inc · Newport, RIBuilt 1998 · S/N TH1856N699TGTkg Aviation Inc · Port Orange, FLBuilt 1978 · S/N 414A0081N699WWWallis Warren · Barstow, CABuilt 1969 · S/N 21059161N69AKSimple Dimple LLC · Kalispell, MTBuilt 1968 · S/N E-91N69CJCook Benjamin · Meridian, IDBuilt 1968 · S/N E-15N69CLTspy Services Inc · Nicholasville, KYBuilt 2000 · S/N TH-1949N69CTEan Aviation Inc · Clarendon Hills, ILBuilt 1977 · S/N CE-718N69GDBonanza Five Flying Club Inc · Roswell, GABuilt 1989 · S/N E-2509N69GVSaltz Clyde · Soldotna, AKBuilt 1975 · S/N 18502725N69HZU206 Ice LLC · Pompano Beach, FLS/N U206-1253N69LEEle Motorsports LLC · Dover, DES/N 21062897N69MRSonic Air LLC · Waukesha, WIBuilt 1969 · S/N TE-708N69PBAerocraft Papa Bravo LLC · Hallandale, FLS/N 402B-1248
Back to AD 86-13-04 R3