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-691Oil filter 30409A with element 1A0235.STC SA4-692Interior equipment.STC SA4-699R003-232-72T propeller with Continental C-90-12 engine.STC SA4-70330409A lube oil filter with element 1A0235.STC SA4-704Carburetor air scoop and fairing assembly for aircraft with Pratt& Whitney R-1830-94 engines.STC SA4-707Aerofilter 30409A lube oil filter with element 1A0235.STC SA4-708Aerofilter 30409A lube oil filter with element 1A0235.STC SA4-709Passenger cabin interior and weight reduction modification.STC SA4-717Removal of No. 3 generator system and one refrigeration system.STC SA4-728Nose tank.STC SA4-729Mounting brackets, flush window, and wiring to operate automotive type sealed-beam headlamp as a dual purpose landing and taxi light.STC SA4-73Metal skins 0.020 24ST and/or 75ST aluminum alloy.STC SA4-730Impregnated glass cloth hopper-tank type PBC-F1, PBC-R1 or PBS-2.STC SA4-731Modified cowl flap actuating system on aircraft with Pratt& Whitney R-1830 series engines.STC SA4-733Fuel flow meter removed.STC SA4-736Modification of lower aft access door and installation of brakets and mounts for K-25 camera.STC SA4-74McCauley 1A200 fixed pitch metal propeller.STC SA4-744Camera.STC SA4-75Modified Convair B24 exhaust manifold (Pratt & Whitney R-1830).STC SA4-755Ceconite 101 covering of rudder, elevators and ailerons.STC SA4-758Aerofilter 30690B full flow lube oil filter with element 1A0286.STC SA4-76New engine ring cowls on aircraft with Pratt & Whitney R-1830 engines.STC SA4-760Ceconite 101 covering of wings, fuselage and ailerons.STC SA4-763Glass cloth applies to wings, fuselage, and ailerons.STC SA4-764Application of glass cloth to ailerons and elevators.STC SA4-768Fuel flow filter 30409A with element 1A0235 and adapter 2A0083.STC SA4-773Metal skin aft of rear spar and fuel tank access door.STC SA4-774Metal skin on flaps.STC SA4-775Mark AN-3 camera in left wing.STC SA4-776Replacement of fabric on trailing edge of wing with sheet metal.STC SA4-777Aerofilter 30409A-12 or full flow filter 30409A with element 1A0235.STC SA4-778Ceconite covering.STC SA4-785Hartzell HC-12X20-7D/8433-0propeller.STC SA4-788Ceconite 101 covering of ailerons, elevators, and rudder.STC SA4-789McCauley 1B90-CM/7045 propeller on Continental A-65-8 engine.STC SA4-79Recovering of wings with metal.020 aluminum 2024-T3 clad.STC SA4-790C-O-Two smoke detector system in main cargo compartment and forward baggage compartment.STC SA4-797Fabrication and installation of camera mount and K-25 camra.STC SA4-8Wright R1820-87 and -60 engines and Hamilton Standard 6353A-18 propellers and modification fuel system and exhaust system.STC SA4-80Cowl flap linkage system.STC SA4-801Ceconite 101 covering of wings.STC SA4-802Ceconite 101 covering of wings.STC SA4-803Ceconite 101 covering of wings.STC SA4-804Ceconite 101 covering of rudders, elevators and ailerons.STC SA4-807Automatic rudder control Model B.STC SA4-808L-2C autopilot.STC SA4-81Lycoming O-290-D2 engine and Sensenich M76AM-2/74-52 propeller.STC SA4-811Fiberglass nose.STC SA4-817Propeller spinners on aircraft with Pratt & Whitney R-1830-92 engines.STC SA4-818Ceconite 101 covering of rudders, elevators, ailerons and flaps.