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 ST00293LA-DInstallation of Barry Controls Aerospace active tuned mass absorber system.STC ST00076BOInstallation of dual Universal Avionics Model UNS-1M Navigation Management Systems. (1-11 SERIES 401/AK)STC ST00724CHInstall Aft Baggage Insert.STC SA09265AC-DInstallation of S-TEC Manual Electric Trim System, Model ST-705.STC SA2359SWModification of Marston primary heat exchanger.STC SA2971SWModification of AiResearch P/N's189100 and 189440 air to air precoolers.STC SA3718SWRemanufacture of AiResearch air conditioning heat exchanger P/N 187900 by replacing core assembly.STC SA3804SWRemanufacture of AiResearch air conditioning heat exchanger, P/N 184360 by replacing core assembly.STC SA3839SWRemanufacture of AiResearch air conditioning heat exchanger P/N 182820.STC SA3870SWRemanufacture of Hamilton Standard air conditioning heat exchanger P/N 733949 by replacing core assyemblySTC SA3888SWRemanufacture of Airesearch oil cooler heat exchanger P/N 158440 by replacing core assembly.STC SA3898SWRemanufacture of Airesearch air conditioning heat exchanger P/N 176840 by replacing core assembly.STC SA3899SWRemanufacture of AiResearch air conditioning heat exchanger P/N 184380 by replacing core assembly.STC SA4071SWModification of Janitrol heat exchangers.STC SA5877SWRemanufacture of Hamilton-Standard air conditioning heat exchanger P/N 719235 by replacing core assembly.STC SA7416SWRecore of Airesearch heat exchangers P/N 179450 for DC-9 environmental control heat.STC SA7552SWRecore of AiResearch secondary air conditioning heat exchanger P/N 184060.STC SA7593SWRecore precooler heat exchanger Airesearch P/N 182400 assembly.STC SA7611SWRecore of APU oil cooler P/N 160186 or 160192.STC SA7728SWRecore of ECU Precooler, Airesearch P/N 194430.STC SA7857SWRecore of Englehard P/N D19333 ozone converters.STC SA7858SWRecore of Airesearch P/N 2202465 ozone converter .STC SA7859SWRecore of Englehard P/N D19563 ozone converters.STC SA7883SWRecore of Englehard PN D19772 ozone converters.STC SA7884SWRecore of Englehard P/N D-19751-1 ozone converters.STC SA7885SWRecore of Englehard P/N D-19811 ozone converters.STC SA7950SWRecore precooler heat exchanger core, Hamilton Std P/N 773287, when existing core becomes unserviceable.STC SA8034SWRecore of PN 2049901 ozone converterSTC SA8072SWRecore of Boeing 737 precooler heat exchanger.STC SA8198SWRecore of Airesearch P/N 157790 heat exchanger.STC SA8317SWInstallation of a new heat exchanger core in Hamilton Std. P/N 775516 precooler heat exchanger.STC SA8425SWRecore of Airesearch P/N 160176 APU oil cooler installed.STC SA8426SWRecore of Airesearch P/N 160176 APU oil coolerSTC SA8463SWRecore of AiResearch P/N 194110 heat exchanger when repair limits are exceeded.STC SA8464SWRecore of 757 and 767 heat exchanger.STC SA8627SWRecore of Airesearch P/N 194270 primary heat exchanger.STC SA8682SWRecore of P/N 294776 heat exchanger.STC SA8841SWRecore of air to air heat exchanger manufactured by Garrett P/N 194276.STC SA8933SWRecore of Airesearch P/N 194274 heat exchanger used on Boeing 757 air conditioning system.STC SA8934SWRecore of Airesearch P/N 194274 heat exchanger used on Boeing 767.STC SA8979SWRecore of Hamilton Standard P/N 779215 heat exchanger with a new core.STC ST08996SCRecore of Hamilton Standard precooler heat exchanger.STC ST09072SCRecore of Hamilton Standard precooler heat exchanger P/N 792930.STC ST09129SCRecore of AiReseach P/N 160282 oil cooler.STC ST09130SCReplacement of core assembly in Airesearch heat exchanger P/N 118440.STC SA00680NYInstallation of Dorsal Fin.STC SA00681NYInstallation of tail cone.STC ST01453ATInstallation of a Meggitt Avionics Secondary Flight Display System.STC ST01454ATInstallation of a Meggitt Avionics Secondary Navigation Display System.STC ST09365SCInstallation of dual Collins Mode S Transponders.