STCs that may be installed · 224

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 = '1152703' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '17273') 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 = '1152703'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '17273')
    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 = '1152703'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '17273')
  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 · Beech 58PA

STC SA3040SW-DInstallation of Mitchell automatic flight system model AK453 consisting of Century III autopilot with optional command/automatic electronic pitch trim system, radio coupler and glide slope coupler.Century Flight Systems Inc STC SA2603NMInstallation of Wing Tip Recognition Light per Flightcraft, Inc.Flightcraft Inc STC SA3311SW-DInstallation of Mitchell automatic flight system model AK453 consisting of Century III autopilot with optional radio coupler and glide slope couplerCentury Flight Systems Inc STC SA2190NM PAGE 1Installation of electronics International Digital Volt/Amp Gauges and Accessories.Electronics International STC SA3338SW-DMitchell automatic flight system system AK813 consisting of Century 41 autopilot or AK813FD consisting 41 flight director autopilot with optional remote annunciator.Century Flight Systems Inc STC SA3344SWMitchell yaw damper system. YK781.Century Flight Systems Inc STC SA1800NMInstallation of wing spar reinforcement.Aviadesign, Inc STC SA2961SWAddition of Hydro Seal Fluid Additive to the landing gear shock struts.Granville Lasseter/dba Granville's Aircraft Strut Sealant STC SA978SOInstallation of NP-2041A area navigation computer programmer.Bendix Corporation Avionics Div STC SA979SOInstallation of Bendix FCS-870automatic flight control system including manual electric pitch trim and optional yaw damper and optional flight director.Bendix Corporation Avionics Div STC SA453SOInstallation of Bendix Model FCS 810 automatic flight control system including manual electric trim and optional flight director indicator.Bendix Corporation Avionics Div STC SA1123CEInstall AP-106 autopilot system and interface with either Collins FD-106 or FD-112 flight director.Collins Radio Group STC SA1124CEInstall AP-107 (2 axis) autopilot and interface with either Collins FD-106 or FD-112 flight director.Collins Radio Group STC SA1125CEInstall AP-107 (3 axis) autopilot system and interface with either Collins FD-106 or FD-112 flight director.Collins Radio Group STC SA00765DE PAGE 1Installation of Automatic Dependent Surveillance Broadcast (ADS-B) Out functionality using the BendixKing KT74 Transponder and qualified position sensorPeregrine STC SA02153LA-DInstallation of Garmin G600 Primary Flight Display (PFD) and Multifunction Display (MFD) SystemGarmin International Inc STC ST01085LAInstallation of the VNS 1000 Voice Navigation System.VNS Incorporated STC SA00281BO PAGE 2Installation of Avidyne Corporation MLX770 MultiLink Broadcast Transceiver P/N 700-00163-( ), Sensor Systems Inc. Antenna P/N S67-1575-109, or equivalent, and optional Avidyne Mounting Tray P/N 700-00165-000Avidyne Corporation STC SA02153LAInstallation of Garmin G600 Primary Flight Display (PFD) and Multifunction Display (MFD) System.Garmin AT Inc.STC SA01933LAInstallation of Garmin Model 400W / 500W Series GPS-WAAS Navigation SystemGarmin AT Inc.STC SA2350NMInstallation of Electronics International Inc digital carburetor/outside air temperature gauges listed on the attached continuation sheet and the associated accessories.Electronics International

Engine · Continental TSIO-520-WB

Back to N456KW