STCs that may be installed · 172

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 = '1153605') 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 = '1153605')
    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 = '1153605')
  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 B-60

STC SA1494SWInstallation of Mitchell flight director remote annunciator Model AK375.Century Flight Systems Inc STC SA3151SW-DInstallation of Mitchell Automatic Flight System Model AK429 consisting of Century IV Autopilot or AK429/FD consisting of Century IV Flight Director Autopilot with Optional Remote AnnunciatorCentury Flight Systems Inc STC SA3293SW-DInstallation of Yaw damper system model YK380.Century Flight Systems Inc STC SA2190NM PAGE 1Installation of electronics International Digital Volt/Amp Gauges and Accessories.Electronics International STC SA3367SW-DMitchell automatic flight system AK870 consisting of Century 41autopilot or AK870FD consisting of Century 41FD autopilot.Century Flight Systems Inc STC SA3368SW-DMitchell automatic flight system YK871 consisting of yaw damper system.Century Flight Systems Inc STC SA545GLInstallation of a Shadin Co. 910502, 910504, or 910514 fuel flow indicating system.Shadin Avionics STC SA2956SWAddition of Hydro Seal Fluid Additive to the landing gear shock struts.Granville Lasseter/dba Granville's Aircraft Strut Sealant STC SA3162WEInstallation of recognition light assembly on the horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation STC SA2386SWInstallation of S.A.F.E., EGT, CHT Systems.Avicon Development Corporation STC SA154GLInstallation of Norton radome kit,No. 4132X.Norton Company, Performance Plactics STC SA539SOInstallation of Bendix FCS-810 automatic flight control system including manual electric trim and optional flight director indicator and/or YD-4 yaw damper.Bendix Corporation Avionics Div STC SA1024CEInstallation of AP-107 autopilot and associated flight director.Collins Radio Company STC SA570SOInstallation of Bendix M-4D automatic flight control system, in cluding optional manual electric trim and optional flight director indicator.Bendix Corporation Avionics Div 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 SA01435DEInstallation of engines, modified with a Firewall Forward Technologies.Centri-Lube Technologies LLC 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

Back to N420AS