STCs that may be installed · 581

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 = '2072430' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41508') 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 = '2072430'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41508')
    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 = '2072430'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '41508')
  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 · Cessna 172K

STC SA7220SW-DInstallation of S-TEC Manual Electric trim system, model ST-328.S-TEC Corporation STC SA2350NM PAGE 1Installation of Electronics International Inc digital carburetor/outside air temperature gaugesElectronics International STC SA4721NMInstallation of SynCon alarm system.SynCon Inc STC SA807CEInstallation of Lycoming 180 hp engine and constant speed propeller. (172P LANDPLANES)Robert or Barbara Williams STC SA2601CEOperation of airplane on leaded and unleaded automotive gasoline, 91 minimum antiknock index(RON+MON)/2. (172P 160 HP)Petersen Aviation Inc STC SA650CEInstallation of Fleet Model 2500 floats.Kelsey Michael STC SA4802NMInstallation of relocated battery boxDel-Air STC SA5124SW-DInstallation of S-TEC System 60 single axis automaticflight guidance system Model ST-094.S-TEC Corporation STC SA4302NMInstallation of Electronics Int'l digital automatic engine analyzer.Electronics International STC SA2852SWInstallation of leading edge cuffs, stall fences, aileron seals, wing tips.Bob Williams STC SA560NEInstallation of Eventide Avionics Argus 5000 Moving Map Display(MMD) with Software ID 01-02 or installation of Eventide Avionics Argus5000 MMD with Software ID 02.00.Eventide Avionics · Lists 172 Series STC SA4704NMInstallation of an Anti-Skid pressure accumulator module for the hydraulic brake system.Long's Aircraft Service STC SA5201SW-DInstallation of S-TEC System 50 two axis automatic flight guidance system, Model ST-182-50.S-TEC Corporation STC SA5113SW-DInstallation of S-TEC System 60 pitch stabilization system ST-096, with optional automatic electric trim system.S-TEC Corporation STC SA242EA40-0040 and 40-0043 supplemental light system.Grimes Division /FL Aerospace Corp. · Lists 172 Series STC SA3862NM PAGE 1Installation of Electronics International Primary TIT/EGT/CHT instruments, remote switches and associated accessories.Electronics International STC SA4166NMInstallation of Fairchild voltage regulator No. UA78 GUIC to replace the original voltage regulator in Cessna turn coordinator P/N 0661003-0506.Malkasian Paul STC SA5111SW-DInstallation of S-TEC System 60 Two Axis Automatic Flight Guidance system, Model ST-095, with Optional Automatic Electric Trim SystemS-TEC Corporation STC SA695CEInstall Frantz oil filter.D'Shannon Company STC SA503NEInstallation of oil cooler door, P/N E921.Aerocet, Inc STC SA2960NMInstall 'stay put' (seat position locking device).B & D Safety Lok Company STC SA1455NMInstallation of a flame proof auxiliary heater-dryer, Model12-1600.Thermal, Inc STC SA3425SW-DInstallation of Century automatic flight system Model AK928 consisting of a Century 31 autopilot.Century Flight Systems Inc STC SA3426SW-DInstallation of Century automatic flight system Model AK929 consisting of a Century 21 autopilot.Century Flight Systems Inc STC SA1645SWInstallation of Mitchell automatic flight system Model AK403, consisting of Century IIB autopilot with optional radio coupler.Century Flight Systems Inc STC SA1221SWMitchell automatic flight system AK312 consisting of Century I with optional omni tracker.Century Flight Systems Inc STC SA603SWInstallation of Mitchell automatic flight system model AK191 consisting of Century II and radio coupler and model AK192 automatic aileron stabilizer.Century Flight Systems Inc STC SA3046SW-DInstallation of Mitchell automatic flight system model AK524 consisting of Century IIB autopilot with optional radio coupler.Century Flight Systems Inc STC SA995SWIncrease wing leading edge radius wing tip fairings, and landing light lens.Williams Bob or Barbara STC SA1947CEReplace existing engine driven vacuum pump with engine driven piston-type vacuum pump.Sigma-Tek, Inc STC SA1584SOInstallation of Appalachian Accessories' brake rotor P/N 75-27.Appalachian Accessories · Lists 172 Series STC SA2190NM PAGE 1Installation of electronics International Digital Volt/Amp Gauges and Accessories.Electronics International STC SA3105WEInstallation of flapgap fairing. (172N, 179P, 172Q NORMAL AND UTILITY CATEGORIES)Thermal Aircraft Company STC SA1513SOInstallation of front seat modification.Civil Air Patrol Corporation · Lists 172 Series STC SA2086NMInstallation of a Lycoming O-360-A2F and a Sessenich 76EM855-O-60Rocky C Younger STC SA1371SWWing leading cuff, wing tips and upper surface flow fences.Williams Robert or Barbara STC SA1826CEInstallation of photo bubble in baggage door opening.Hue Aire, Inc STC SA1406SOInstallation of Model CC-1 checkpoint computer.Perception Systems STC SA4717SWInstallation of Texas Instruments Model 9100 Loran C navigator.Texas Instruments, Inc STC SA296GLConvert to conventional landing gear.Robert or Barbara Williams STC SA315GLInstallation of Fluidyne skis.Robert L. or Barbara V. Williams STC SA319GLInstallation of Bolen wheel extenders on Cessna models modified per STCSA296GL.Williams Robert or Barbara STC SA590CEInstallation of horse transportation stalls. (727-22C)Interstate Airlines, Inc · Lists 172 Series STC SA2075WEInstallation of Madras Air Service Inc. 'Super Tips.' (172l NORMAL CATEGORY)Madras Air Service STC SA1294SOInstallation of an adjustable nine-inch trim tab on left aileron.Aero Trim, Inc STC SA115NWModification of R.H. Door and the addition of a jump seat.Bunch Charles P STC SA1150NWInstallation of a 1976 Cessna 172 wing, an updated right wing leading edge, late model 172 dorsal fin, and later model 172 cowlSkinner, Burdette STC SA4283WEInstallation of electric inflatable door seal.Bob Fields Aerocessories STC SA826NWInstallation of Cessna flap gap seal fairingsSeaplane Flying Inc STC SA3788WEInstallation of the 'liftrol' wing spoiler system.Cleaves Esther E

Back to N46708