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-191L-2 automatic pilot.STC SA4-19813-gallon auxiliary fuel system.STC SA4-19913-gallon auxiliary fuel system.STC SA4-201350-gallon outer wing tank and new fuel system.STC SA4-202Oil filter 30816A with CP-1438-0 element.STC SA4-203Oil filter 1258-B86-C and element1258-OC on aircraft without UD3785 oil temperature regulator.STC SA4-204Oil filter 1258-B-86-D and element1258-OC on aircraft with UD3785 oil temperature regulator.STC SA4-207Spar reworked to facilitate rigging of metalized wings.STC SA4-213Radio rack in crew compartment.STC SA4-214Two Stewart-Warner 940-B heaters.STC SA4-215Oil filter 1258-B-86-A and element 1258-OC.STC SA4-218Windows in fuselage.STC SA4-219Vibration suppressor plates.STC SA4-221Autopilot L-2.STC SA4-222Fiberglass covering.STC SA4-224Application of fiberglass covering.STC SA4-225Removable metal fuselage panels.STC SA4-226Metal skin on wings.STC SA4-23Conversion to tricycle gear.STC SA4-231Installation of auxiliary power unit (Andover type D-2, Model V-32) and associated equipment in baggage compartment.STC SA4-238Thompson TF 2800 engine- driven fuel pump installation on Continental O-470-G engine.STC SA4-239Thompson TF2800 engine-driven fuel pump.STC SA4-242Full flow oil filter 30618A with element CP-1558-OC.STC SA4-247AiResearch C-7500-1 divan.STC SA4-248Cabin tables.STC SA4-249Hardman 3048 and 3041 chairs.STC SA4-250Galley and buffet.STC SA4-255Aft cabin lounge.STC SA4-258C-46A wings on C-46F aircraft.STC SA4-27Stratus supercharger and air cycler.STC SA4-271Installation of Sperry A-12 auto-pilot.STC SA4-276BN-1 propeller spinner.STC SA4-278Propeller spinners.STC SA4-282Tactair T-3 automatic pilot.STC SA4-284BN-1 propeller spinner.STC SA4-285BN-1 propeller spinner.STC SA4-288BN-1 propeller spinner.STC SA4-289BN-1 propeller spinnerSTC SA4-294Nose gear steering system.STC SA4-298Fuselage structural alterations and additions to provide for the installation of Fairchild Aviation aerial camera A5A or similar.STC SA4-299Windows at station 144.STC SA4-306Roto-Nav bracket and Grimes D 7080 anti-collision light on vertical fin.STC SA4-31Wright R1820-52 engines and Hamilton Standard 33D50/6511-9 propellers.STC SA4-310Emergency radio transmitter.STC SA4-311Interior seating change to provide 98 cabin places.STC SA4-312Ten man life raft stowage provisions.STC SA4-314Cabin interior.STC SA4-316Emergency equipment.STC SA4-317Auxiliary oil tank.STC SA4-322Full-flow oil filter 1050-B-83 with element 1A0094.