Supplemental type certificates
49,120 STCs, most recently changed first. Search by what an STC changes, its holder or a model.
Query with SQL
duckdb -csv -c "SELECT stc_number, description, holder, status, status_date FROM 'https://openairdocs.org/data/latest/faa_stc.parquet' ORDER BY status_date DESC NULLS LAST, 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 stc_number, description, holder, status, status_date FROM 'https://openairdocs.org/data/latest/faa_stc.parquet' ORDER BY status_date DESC NULLS LAST, 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.
STC SG4-1411Ceconite 103 covering of glider.STC SG4-741Bubble canopies over each cockpit and change in configuration of vertical and horizontal tail.STC SG4WECeconite 101 covering of complete aircraft.STC SG5WECeconite 103 covering of complete wing assembly.STC SG7WECeconite 101 covering of complete airframe.STC SH1-175American type rate of climb, altimeter, air speed and outside air temperature indicators.STC SH1-253Goodyear floats and United States hardware.STC SH1-315Modification of rotor swash plate.STC SH1-437Stewart-Warner combustion heater F-24, relocation of aircraft junction box and special centrifugal blower SP-151.STC SH1-457Aircooler Motors 6VS-335B turbo-supercharged engine (derated).STC SH1-461Engine air inlet duct screens.STC SH1-475Purolator fuel filter element type EP-173 P/N 6656561 and gasket 6656574.STC SH1-504Cabin heating system utilizing Stewart-Warner 940F24 heater.STC SH1-509Lube oil filter PB55-1.STC SH1-512Aircooled Motors 6VS-335A turbo- supercharged engine (derated).STC SH1-527Transmission gears in transmission box assembly SE 3130 62-30-00; 81P740009 first stage sun gear, one; 81P740006 second stage sun gear, one; 81P740007 satellite gear, twelve.STC SH1-563Tail light modification.STC SH1-592American manufactured instrument panel and cabin dome lighting.STC SH1-614Anti-collision rotating beacon light.STC SH1-616Marginal weather instrument group consisting of directional gyro, gyro horizon and turn-slip indicators.STC SH1-617Grimes eyebrow instrument lights.STC SH1-618Shoulder harness for pilot and copilot.STC SH1-623American type folding 3-man troop seat.STC SH1-626Lube oil filter PB55-1.STC SH1-67Franklin 6V-335-A engine.STC SH1010SWSliding tinted glass window assembly for forward right and left cabin doors.STC SH1062SOInstallation of fuel tank filler extension (increased fuel capacity).STC SH10WEFour-place configuration and related changes.STC SH111WEInstallation of step on either side or both sides of aircraft, attached to skid and torsion bar between Stations 60 and 100.STC SH112WEInstallation of box ejector for Codling Moth Control.STC SH11WEOverlay instrument panel to accommodate Motorola ADF T-128, Sperry Horizon, Schwien turn and bank.STC SH136SWProvisions for use of stokes litter with left cabin door propped open 22.8 inches.STC SH14WEFull flow lube oil filter 30409A with element 1A0235.STC SH159EARaybestos-Manhatten Ray-Bond (R) R8001 adhesive as an alternate bond for bonding of Alouette.STC SH160ALAirborne control survey system.STC SH165EAHeater kit 50-1000 fabrication and installation.STC SH17ALTundra board.STC SH17WEAdapter bracket utilized as attachment for lifting a maximum external load of 928 lbs.STC SH184SWCargo sling, 800 lbs. capacity. (Restricted category only.)STC SH186SWLycoming VO-540-B1B3 engine, transmission, Bell 47-620-600-25(or -23 modified to -25 by Bell Helicopter Co.) oil cooler, Bell47-671-036-1, and associated changes. (Eligible on skiplane version of Bell 47G-2A only.)STC SH18WECargo racks left and right sides.STC SH1989SWReplace main rotor blade L.E. protection strip.STC SH19ALCargo racks.STC SH27WEJump-step.STC SH3-473Heater.STC SH3-517Engine exhuast cabin heating system.STC SH3-561Sunshade to reduce heat and glare in cockpit.STC SH32WEFabricate and install jump-step.STC SH33WERadio navigation equipment.STC SH341ALInstallation of Airglas skis.