N137AS
STCs that may be installed · 215
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
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 = '1153005'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41514')
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 = '1153005'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41514')
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_numberRun 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 76
STC SA01280CHInstallation of Challenger Spin-On Oil Filters.(For Cessna 182 model, s/n 67042 and up) (For Cessna 421C model, s/n 1017 thru 1404)STC SA00804SEInstallation of an engine failure indicator system, also referred to as a 'low Thrust Detector system.'STC SA71GLInstallation of air filtersSTC SA1153EAInstallation of DeVore 'tel- tail' lights on lower surface of horizontal stabilizer.STC SA3488SW-DInstallation of Century automatic flight system model AK995 consisting of a Century 2110/2130/2131/2150/2151 AutopilotSTC SA00749ATModification of flush type fuel caps for installation of a locking cylinder and keeper. (1964 and subsequent)STC SA5925NMInstallation of oil pressure/temperature instrument.STC SA5924NMInstallation of RPM instrument.STC SA00227NYInstallation of Sky Harbour Aircraft Refinishing Ltd. Ice Damage Prevention Plates.STC SA157NEInstallation of Graphic Engine Monitor System Model GEM-602 S/N 403 and GEM-603 S/N001126and subsequent.STC SA00061LAInstallation of JPI digital tachometer.STC SA8922SWInstallation of replacement Ultimate Engine Oil Filter for Textron Lycoming and Teledyne Continental engines. (411 S/N 000 THRU 0126, S/N 0127 AND UP) (T188C S/N 03474 AND UP) (206 S/N 05030 AND UP) (207 S/N 05227 AND UP) (T207 S/N 05227 AND UP) (P21 0 SERIES S/N 278 AND UP) (180 S/N 53087 AND UP) (210 S/N 63373 - 63375 AND UP) (B19 SPORT)STC SA5656NMInstallation of burglar alarm system.STC SA00075SEModified instrument panel manufactured and installed.STC SA5926NMInstallation of manifold pressure instrument.STC SA1626NM PAGE 1Installation of Electronics Int'l Digital EGT/CHT Instruments and accessories. (201 Series)STC SA2350NM PAGE 1Installation of Electronics International Inc digital carburetor/outside air temperature gaugesSTC SA4302NMInstallation of Electronics Int'l digital automatic engine analyzer.STC SA3862NM PAGE 1Installation of Electronics International Primary TIT/EGT/CHT instruments, remote switches and associated accessories.STC SA7131SW-DInstallation of S-TEC yaw damper system, Model ST-076.STC SA7133SW-DInstallation of S-TEC System 65 two axis automatic flight guidance system.STC SA7130SW-DInstallation of S-TEC system 60 two axis automatic flight guidance system Model ST-074.STC SA6091SW-DInstallation of S-TEC yaw damper system Model ST-108.STC SA6077SW-DInstallation of S-TEC system 65 two axis automatic flight guidance system, Model ST-370.STC SA6076SW-DInstallation of S-TEC system 60 two axis automatic flight guidance system, Model ST-106 with optional automatic electric trim system.STC SA1418SOReplacement of rotor vanes in Airborne 211CC and 212CW vacuum pumps. (See limitations)STC SA3256SW-DInstallation of Mitchell automatic flight system model AK694 consisting of Century IV autopilot or AK694FD consisting of Century IV Flight Director autopilot with optional remote annunciator.STC SA3257SW-DInstallation of Mitchell automatic flight system model AK693 consisting of Century III autopilot with optioanl radio coupler and glide slope couplerSTC SA3258SW-DInstallation of Mitchell automatic flight system model AK692 consisting of Century III autopilot with optional radio couplers.STC SA3259SW-DInstallation of Mitchell Automatic Flight System Model AK691 consisting of Century I autopilot with optional omni tracker.STC SA3260SW-DInstallation of Mitchell command electric trim system model AK695.STC SA3261SW-DInstallation of Yaw damper system model YK696.STC SA2190NM PAGE 1Installation of electronics International Digital Volt/Amp Gauges and Accessories.STC SA5257SW-DInstallation of S-TEC manual electric trim system Model ST-253.STC SA5250SW-DInstallation of S-TEC System 40/50 single and two axis automatic flight guidance systems Model ST-218-40/50.STC SA5243SW-DInstallation of S-TEC System, 40/50 single and two axis automatic flight guidance systems Model ST-219-40/50.STC SA3317SW-DInstallation of Mitchell automatic flight system AK761 consisting of Century I autopilot with omni tracker.STC SA3318SW-DInstallation of Mitchell automatic flight system AK762 consisting of Century IIB autopilot with optional radio couplers.STC SA3319SW-DInstallation of Mitchell automatic flight system AK763 consisting of Century III autopilot with optional radio and glide slope couplers.STC SA3320SW-DInstallation of Mitchell automatic flight system AK764 consisting of Century IV autopilot or AK764FD consisting of Century IV autopilot flight director with optional remote annunciator.STC SA3321SW-DInstallation of Mitchell automatic flight system AK765 consisting of command electric trim system.STC SA3322SWInstallation of Mitchell yaw damper YK766.STC SA3345SWInstallation of Mitchell yaw damper YK838.STC SA3346SWMitchell automatic flight system AK827/FD consisting of Century 41/FD flight director autopilot.STC SA5206SW-DInstallation of S-TEC System 60 pitch stabilization system Model ST-075 with optional automatic electric trim system.STC SA3356SWInstallation of Mitchell automatic flight system AK826 consisting of Century21 autopilot.STC SA3396SW-DInstallation of Mitchell automatic flight system Model AK894consisting of Century 31 autopilot.STC SA4786SWInstallation of S-TEC System 60 two axis automatic flight guidance system model ST-106 with optional autotrim systemSTC SA4787SWInstallation of S-TEC yaw damper system model ST-108STC SA5104SW-DInstallation of S-TEC system 60 pitch stabilization system Model ST-107 with optional automatic electric trim system