STCs that may be installed · 525

Approved for this aircraft’s airframe or engine model. The registry doesn’t record which STCs an aircraft has; its records do. In force first, then newest.

Query with SQL

SELECT m.matched_by, s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model FROM ( SELECT stc_number, min(side) AS side, arg_min(matched_by, side) AS matched_by, arg_min(matched_model, side) AS matched_model FROM (SELECT stc_number, 1 AS side, 'airframe' AS matched_by, matched_model FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet' WHERE aircraft_model_code = '2073357' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '17040') GROUP BY stc_number ) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number) ORDER BY m.side, s.status = 'Current' DESC, s.status_date DESC, s.stc_number

duckdb -csv -c "SELECT m.matched_by, s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
  FROM (
    SELECT stc_number, min(side) AS side, arg_min(matched_by, side) AS matched_by, arg_min(matched_model, side) AS matched_model
    FROM (SELECT stc_number, 1 AS side, 'airframe' AS matched_by, matched_model FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet' WHERE aircraft_model_code = '2073357'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '17040')
    GROUP BY stc_number
  ) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
  ORDER BY m.side, s.status = 'Current' DESC, s.status_date DESC, s.stc_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.

SELECT m.matched_by, s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
  SELECT stc_number, min(side) AS side, arg_min(matched_by, side) AS matched_by, arg_min(matched_model, side) AS matched_model
  FROM (SELECT stc_number, 1 AS side, 'airframe' AS matched_by, matched_model FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet' WHERE aircraft_model_code = '2073357'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '17040')
  GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY m.side, s.status = 'Current' DESC, s.status_date DESC, s.stc_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

Airframe · Cessna TU206G

STC SA3862NM PAGE 1Installation of Electronics International Primary TIT/EGT/CHT instruments, remote switches and associated accessories.Electronics International STC SA1037CEInstallation of 26-gallon auxiliary fuel tank in baggage compartment.PHH Aviation · Lists TU206 Series STC SA4166NMInstallation of Fairchild voltage regulator No. UA78 GUIC to replace the original voltage regulator in Cessna turn coordinator P/N 0661003-0506.Malkasian Paul STC SA3347NMUse of the Union Aviation portable hand operated rudder and brake model C.C & C Aviation STC SA2172SOReplacement of Cleveland brake discs, P/N 164-15A or 164-115A, with Appalachian stainless steel brake discs, P/N 75-15A.Appalachian Accessories · Lists 206 Series STC SA186RMInstallation of wing strut mounted camera pod and/or viewfinder.Dalla Family Trust STC SA2767NMInstallation of replacement left exhaust heat exchanger unit.Heliarc Welding Service Inc.STC SA1807SOInstallation of Appalachian Acces. stainless steel brake discs, P/N 73-47.Appalachian Accessories · Lists 206 Series STC SA3611NMInstallation of Schneider Wheel Skies SWS-11000 tundra tires, wheels, and hubs.Bushmaster Management Co STC SA838GLInstallation of safety belt extenders.Stevenson John · Lists 206 Series STC SA3281NMInstallation of ARNAV Systems FC-10 or FT-10 digital fuel flow indicating system.Arnav Systems STC SA1580NMInstallation of replacement exhaust heat exchanger.Heliarc Welding Service Inc.STC SA2960NMInstall 'stay put' (seat position locking device).B & D Safety Lok Company STC SA2329NMInstallation of F. Atlee Dodge filler neck adapter. (TP206E UP TO S/N P20600649) (TU206G UP TO S/N U20604649)F Atlee Dodge Aircraft Service STC SA1455NMInstallation of a flame proof auxiliary heater-dryer, Model12-1600.Thermal, Inc STC SA2322NMInstallation of Lindco fuel cap assembly. (TU206G UP TO S/N U20604649)Lindco STC SA3193NMInstallation of fuselage reinforcement kit.Simula, Inc STC SA3432SW-DInstallation of Century automatic flight system Model AK936 consisting of a Century 21 autopilot.Century Flight Systems Inc STC SA2703NMInstallation of replacement exhaust system riser.Heliarc Welding Service Inc.STC SA2855SWInstallation of wing Leading edge cuffs, stall fences, aileron seals, and wing tips.Bob Williams STC SA2311NMInstallation of Schneider Wheel Skis, Inc 6 inch to 10 inch aluminum wheel adapters (P/N SWS-10000) and 29x11.0-10 8 ply minmum tires (with tubes) on the main landing gear.Schneider Richard J STC SA5369SW-DInstallation of S-TEC manual electric trim system, Model ST-275.S-TEC Corporation STC SA3097SWInstallation of Mitchell automatic flight control Model AK471 consisting of a Century III autopilot with optional command/ automatic electronic pitch trim, radio coupler and glide slope coupler.Century Flight Systems Inc STC SA807GLInstallation of Airborne 28 VDC auxiliary dry air pump Kit No. 372-2.Parker Hannifin Corp STC SA3177SW-DInstallation of Mitchell Automatic Flight System Model AK470 consisting of a Century IIB Autopilot with Optional Radio Coupler.Century Flight Systems Inc STC SA3178SW-DInstallation of Mitchell Automatic Flight System Model AK469 consisting of a Century I Autopilot with Optional Omni TrackerCentury Flight Systems Inc STC SA3263SW-DInstallation of Mitchell automatic flight system model AK714 consisting of Century IIB autopilot with optional radio couplerCentury Flight Systems Inc STC SA3262SW-DInstallation of Mitchell automatic flight system model AK715 consisting of Century III autopilot with optional radio coupler and glide slope couplerCentury Flight Systems Inc STC SA3264SW-DInstallation of Mitchell automatic flight system model AK713 consisting of Century I autopilot with optional omni tracker.Century Flight Systems Inc STC SA3265SW-DInstallation of Mitchell automatic flight system model AK717/FD consisting of Century IV/ flight director autopilot with optional remote annunciator.Century Flight Systems Inc STC SA4413SWInstallation of parabolic mirror.Amchris Aviation System STC SA2302NMInstallation of Schneider Model SWS-4000C-15, SWS-4000C-19, or Model SWS-4000C-23 main wheel skis.Schneider Richard J · Lists 206 Series STC SA1506SOInstallation of seats.Jungle Aviation & Radio Service, Inc. · Lists 206 Series STC SA3387SW-DMitchell automatic flight system AK888 consisting of Century 31 autopilot.Century Flight Systems Inc STC SA3408SW-DEdo Avionics automatic flight system AK911 consisting of Century 31 autopilot.Century Flight Systems Inc STC SA5156SW-DInstallation of S-TEC System 60 single axis automatic flight guidance system Model ST-036.S-TEC Corporation STC SA1381SOInstallation of engine fire detector system.Armtec Industries, Inc · Lists 206 Series STC SA1335SOInstallation of seat tracks.Jungle Aviation & Radio Service, Inc. · Lists 206 Series STC SA556GLInstall cargo door ladder to EDO float 582-3430.Ely Lake Aviation, Inc · Lists TU206 Series STC SA4343WEInstallation of modified brake system.Mission Avn Fellowship STC SA512CEInstallation of Pee Kay Model 3500 or A3500 or B3500 seaplane floats.PK Floats · Lists TU206 Series STC SA851EAInstallation of Pee Kay Model3500A, C3500A and/or D3500A amphibious floats (TSO C-27).PK Floats · Lists TU206 Series STC SA4286WEInstallation of inflatable door seal.Bob Fields Aerocessories STC SA4033SWCamera installationHoward, A. D. Jr.STC SA896NWInstallation of a Logue Avionics Ltd. IndicatorMcKenzie Flying Service Inc STC SA728NWInstallation of vented fuel cap.Venting Engineering STC SA831NWInstallation of an aerial flare dispenser system.Boise Inter-Agency Fire Center STC SA2905SWInstallation of AVICON TZ1 fuel flow totalizer systemAvicon Development Corporation STC SA2906SWInstallation of AVICON AF1 fuel flow processor.Avicon Development Corporation STC SA2386SWInstallation of S.A.F.E., EGT, CHT Systems.Avicon Development Corporation

Back to N721