STCs that may be installed · 17

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

STC SE00003ENInstructions for Continued Airworthiness for the PT6A-6/C20, -20, -20A and, -20B engine models that define specific maintenance tasks and their associated maintenance schedules, and that are used as a supplement to the applicable Pratt & Whitney Canada manuals.MORE Company Inc · Lists PT6A-6/C20 STC SE01624WIConversion of Pratt & Whitney Canada, Model PT6A-60A to a North Star Aviation PT6A-60AG turboprop engine. Data required: 1. A copy of this certificate 2. North Star Aviation document, NSA No. 1200, Turboprop Engine Conversion of PT6A-60A Model to PT6A-60AG Configuration per FAA Approved STC , dated March 15, 2011, or later FAA approved revision 3. The ICA supplement for North Star Aviation PT6A-60AG models, Instructions for Continued Airworthiness, NSA No. 1200-ICA, Rev NC, dated March 9, 2011 or later applicable revision.North Star Aviation Inc. · Lists PT6A-60A 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 SE8652SWInstallation of a flexible hose from the Propeller Primary Governor to the Fuel Control Unit.Air Tractor Inc · Lists PT6A-60AG STC SE2960SOInstallation of an oil filler cap safety adapter.Jet Avion Corporation STC SE615GLIncorporation of a fuel flow transducer.Shadin Avionics STC SE01805NYInstallation of Fuel Nozzle Adapters using studs and nuts.Atlantic Turbines International Inc. · Lists PT6A-60A STC SE00022ENInstallation of Oil Tank Filler Neck Check Valve.Helicopter Support Inc Services Div · Lists PT6A-66 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 SE8827SWModification to exhaust duct P/N 3109946-01.Air Tractor, Inc · Lists PT6A-67 STC SE1269EAStripping and recoating of compressor turbine blades, P/N 3023401, with Walbar Metals, Inc.Airwork Corporation STC SE5601SWReplacement splined end and oil mist lubrication on accessory drive gearshaft.Aviall of Texas, Inc 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

Back to N289PC