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 SA4-323Full Flow oil filter 30816A with element 1A0097.STC SA4-328Step kit added to fore and aft cargo door.STC SA4-329Step kit added to fore and aft cargo door.STC SA4-330Step kit added to fore and aft cargo door.STC SA4-338Addition of exhaust stacks with venturi, pump, control valve, and tank for insect control work.STC SA4-339Curtiss metal propeller 55518 and replacement of .080 windshield with bubble .125 (grade I) plexiglass.STC SA4-343B Arcon.STC SA4-344B arcon system.STC SA4-345B Arcon.STC SA4-346Installation of modified B-13 engine mount.STC SA4-347Installation of modified BT-13 engine mount.STC SA4-35Wing root-fuselage fiberglass contoured fairings at leading edge of wing, and aluminum fairings contoured to existing fillet at inboard end of wing flaps extending aft to station 226.STC SA4-351Modification of airplane including removal of coat closet.STC SA4-352101 cabin seats and four crewmember seats.STC SA4-355Interior modification coach to mixed class.STC SA4-357Two Aircraft Radio Corp. ADF loops and sense antenna masta and lead-in insulators.STC SA4-358Outer wing panels to incorporate a 275-gallon integral fuel tank.STC SA4-359Glass cloth with resin.STC SA4-36General Dynamics 340 outer wing integral fuel tanks.STC SA4-361Aluminum alloy sheet on wings.STC SA4-364Application of glass cloth with resin.STC SA4-365Emergency inpact light.STC SA4-367Super automatic rudder control.STC SA4-369Lift strut assemblies.STC SA4-37Picture window.STC SA4-371Repair for wrinkles at wing station 120.STC SA4-372CO and smoke detection system in belly baggage compartments.STC SA4-374Glass cloth applied to wings, fuselage, flaps, and tail surfaces.STC SA4-377112 and 116 cabin seats and four crewmember seats.STC SA4-381Deletion of bat wings, new radar nose, and other modifications.STC SA4-382Radio rack.STC SA4-384Deterjet DJ-1015E valve between governor and nose cap mounting pad.STC SA4-39L-2B automatic pilot.STC SA4-393Fiberglas reinforced plastic wing tips incorporating positions.STC SA4-395Fiberglas wing tips.STC SA4-399Metallizing of wings.STC SA4-40Automatic rudder control.STC SA4-401Tail wheel trunnion. (Restricted category only.)STC SA4-404Glass cloth application on control surfaces.STC SA4-405Interior modification to mixed class.STC SA4-407Andover Type D-2, Model V-32 APU for ground operation only.STC SA4-408Interior arrangement installation(right hand forward cargo door made permanently inoperative as an exit by seating arrangement).STC SA4-41Structure, power plant, systems and equipment modification.STC SA4-411Modification of fuel system to PA-18 to facilitate takeoff either tank.STC SA4-412Large PA-18 tail surfaces.STC SA4-414Emergency lighting.STC SA4-416Deterjet DJ-1015E valve between governor and nose case mounting pad.STC SA4-418Auxiliary A.D.I. tank in aft baggage compartment.STC SA4-419Application of glass cloth over unbleached muslin to all but control surfaces.STC SA4-42Engine mount for Jacobs R-755 engine.