STCs that may be installed · 26

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 = '05637JH' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52247') 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 = '05637JH'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52247')
    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 = '05637JH'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52247')
  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.

Engine · Pratt & Whitney Canada PT6A-27 series

STC SE000ENEngines will be maintained IAW 'Maintenance or Reliable Engines(MORE) Program,' Rev 4, dated 8/16/95.MORE Company Inc STC SE10552SCConversion of Pratt & Whitney Canada Corp. Model PT6A-27 or -28 to a Model PT6A-34 turboprop engine.Prime Turbines LLC STC SE02170ATInstallation of Pc Safety Valve KitBell Helicopter Textron Inc.STC SE11095SCThe conversion of the Pratt & Whitney Canada, Model PT6A-27 to a PT6A-34 turboprop engineR.T. Turbines, Inc.STC SE00014ENInstallation of the Pratt & Whitney Engine Services, Inc. CrossCheck Engine Monitor Kit P/N HUMS-K-071-1, Rev. A on the specified PT6A engine models and kit P/N HUMS-K-071-2 on the specified A250 engine models.Pratt & Whitney Engine Services Inc.STC SE00020ENInstallation of the Pratt & Whitney Engine Services, Inc. TrendCheck/ TrendCheck Plus Engine Monitor Kit P/N TREND-K-010-1Pratt & Whitney Engine Services Inc.STC SE2960SOInstallation of an oil filler cap safety adapter.Jet Avion Corporation STC SE02273NYConversion of a Pratt & Whitney Canada PT6A-27 or PT6A-28 engine to operate as a PT6A-34 engine.Atlantic Turbines International Inc.STC SE615GLIncorporation of a fuel flow transducer.Shadin Avionics STC SE01805NYInstallation of Fuel Nozzle Adapters using studs and nuts.Atlantic Turbines International Inc.STC SE00691NYConversion of engine models PT6A-27 and -28 to Model PT6A-34 as described in Temporary Overhaul Data Revision.Standard Aero Limited STC SE09257SCConvert P&W Engine Models PT6A-15AG, -27, and -28, into PT6A-34 configuration.Covington Aircraft Engines, Inc.STC SE659NEInstallation of oil tank filler neck check valve, P/N TSA-76A.Aviation Components Support STC SE1122EARepair of combustion chamber small exit duct, P/N 3012060.Airwork Corporation STC SE7677SWModifiy the P&W Canada PT-6A-27, -28, -15AG to the PT6A-34 configuration.Airforce Turbine Service STC SE1251GLConversion of engine Model PT6A-27 to Model PT6A-34.Turbines, Inc STC SE1269EAStripping and recoating of compressor turbine blades, P/N 3023401, with Walbar Metals, Inc.Airwork Corporation STC SE386NEInstallation of Turbo Products PMA parts.Audco Corporation STC SE355NEConversion of engine model PT6A-27 to model PT6A-34.Van Dusen Turbine Products STC SE241NEConversion of engine Models PT6A-27 and -28 to 01/157/3.Airwork Corporation STC SE5601SWReplacement splined end and oil mist lubrication on accessory drive gearshaft.Aviall of Texas, Inc STC SE79NEConversion to an aircooled compressor turbine vane ring configuration.Airwork Corporation STC SE1165EAAssembly and installation of AW10262 wet spline starter gear seal.Airwork Corporation STC SE4607SWRevise the starter-generator drive spline to provide lubrication with engine oil.Aviall of Texas, Inc STC SE4570SWRevise accessory drive spline, P/N 3008181.Aviall of Texas, Inc STC SE12CEInstallation of Gits Brothers Manufacturing Company dipstick filler cap assembly P/N 02297-2000.Gits Brothers Mfg Co

Back to N696EX