Supplemental type certificates

49,114 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.

STC SR02104NY-DInstallation of a Universal Cockpit Display (UCD) SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02105NY-DInstallation of Gooseneck Lighting System.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02106NY-DInstallation of a Heads-Up Technologies CMS-400A checklist management system.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02107NY-DInstallation of a Honeywell JetMap II System.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02108NY-DInstallation of an executive VIP interiorSikorsky Aircraft Corporation · Dec 17, 2014STC SR02110NY-DInstallation of a Honeywell Chadwick Model 15175 VXP system.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02112NY-DInstallation of a Main Gear Box Oil Drip Pan modificationSikorsky Aircraft Corporation · Dec 17, 2014STC SR02113NY-DInstallation of Cockpit Provisional Storage ContainersSikorsky Aircraft Corporation · Dec 17, 2014STC SR02115NY-DInstallation of External Camera SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02117NY-DInstallation of a Honeywell Primus 660 Weather RadarSikorsky Aircraft Corporation · Dec 17, 2014STC SR02118NY-DInstallation of a Replacement Retractable Boarding StepSikorsky Aircraft Corporation · Dec 17, 2014STC SR02119NY-DInstallation of an Utility LavatorySikorsky Aircraft Corporation · Dec 17, 2014STC SR02121NY-DInstallation of a shelves (Station 643 and/or Station 520)Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02122NY-DInstallation of High Intensity Strobe Lights.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02123NY-DInstallation of provisions for a Euroavionics Euronav IV systemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02124NY-DInstallation of Jettisonable windows (Cabin &/or Emergency Exit)Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02125NY-DInstallation of Cockpit Pressure Refueling Control SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02126NY-DInstallation of a SkyTrac Systems ISAT-100 system.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02127NY-DInstallation of a HF-9000 High Frequency Communications SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02128NY-DInstallation of FLIR Systems, Inc. Star Safire III FLIRSikorsky Aircraft Corporation · Dec 17, 2014STC SR02129NY-DInstallation of Keystone Helicopter Corp. Silencer Wall Panel SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02130NY-DInstallation of Garmin GMX 200 Multi-Function DisplaySikorsky Aircraft Corporation · Dec 17, 2014STC SR02131NY-DInstallation of Keystone Helicoper Corp. Deluxe VIP Interior.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02132NY-DInstallation of Ramp Gap BridgeSikorsky Aircraft Corporation · Dec 17, 2014STC SR02133NY-DInstallation of Side Facing Utility SeatSikorsky Aircraft Corporation · Dec 17, 2014STC SR02208NY-DInstallation of a LavatorySikorsky Aircraft Corporation · Dec 17, 2014STC SR02400NY-DInstallation of Helicopter Emergency Egress Lighting System (HEELS).Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02401NY-DInstallation of SAR Operator s SeatSikorsky Aircraft Corporation · Dec 17, 2014STC SR02402NY-DInstallation of Alternate Utility Interior.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02403NY-DInstallation of Chelton TETRA TransceiverSikorsky Aircraft Corporation · Dec 17, 2014STC SR02404NY-DInstallation of Scene Lights.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02405NY-DInstallation of Logo LightsSikorsky Aircraft Corporation · Dec 17, 2014STC SR02406NY-DInstallation of a Honeywell Primus 701A Weather RadarSikorsky Aircraft Corporation · Dec 17, 2014STC SR02407NY-DInstallation of an Auxiliary DC Power System.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02408NY-DInstallation of a Spectrolab Nightsun II XP SearchlightSikorsky Aircraft Corporation · Dec 17, 2014STC SR02409NY-DInstallation of a Polycon Wireless Intercom SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02410NY-DInstallation of a Mission Audio SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02411NY-DInstallation of a Wescam MX-15iSikorsky Aircraft Corporation · Dec 17, 2014STC SR02412NY-DInstallation of a Saab Airborne Transponder SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02413NY-DInstallation of the Wulfsberg Flexcomm II Communication SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02414NY-DInstallation of a GKN Sliding Cabin Entry DoorSikorsky Aircraft Corporation · Dec 17, 2014STC SR02415NY-DInstallation of a Chelton 935-2 V/UHF Direction FinderSikorsky Aircraft Corporation · Dec 17, 2014STC SR02416NY-DInstallation of Honeywell KHF 1050 HF Communication SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02417NY-DInstallation of Honeywell KHF 1050 HF Communication SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02418NY-DInstallation of a Universal Cockpit Display (UCD) SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02419NY-DInstallation of Corporate Interior.Sikorsky Aircraft Corporation · Dec 17, 2014STC SR02420NY-DInstallation of an AvVisor Plus Cabin Information Display SystemSikorsky Aircraft Corporation · Dec 17, 2014STC SR02421NY-DInstallation of Center Console Four Inch ExtensionSikorsky Aircraft Corporation · Dec 17, 2014STC SR02422NY-DInstallation of Aft RackSikorsky Aircraft Corporation · Dec 17, 2014STC SR02423NY-DInstallation of Dimmer/Balance Box Modification.Sikorsky Aircraft Corporation · Dec 17, 2014