Supplemental type certificates
49,113 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 SH5707NMFabrication of Onboard Systems Model 200-088-03 or 200-088-04 (without Load Weight) or 200-089-03, -04, -05 or -06 (with Load Weight) cargo hook suspension systemsSTC SH5737NMReplacement of Bell magnesium cargo hook bumper and ring Part Nos. 204-072-901-1 or -3, and 204-072-905-3, respectively, with Onboard bumper ring kit No. 210-092-00. Fabrication of Onboard Systems Model 210-092-00 bumper ring kitSTC SH5758NMFabrication of the Onboard Model 200-095-00 Multi-Channel Electrical Slip-Ring KitSTC SH5780NMFabrication of Onboard Systems model E-46 cargo hook load weigh system.STC SR00277SEFabrication of Onboard Systems Model 528-002-00 or 528-002-01 cargo hookSTC SR00369SEFabrication, Installation, and Inpection of Onboard Systems Model 200-215-00 Cargo Hook Kit.STC SR00406SEFabrication of Onboard Systems Model 200-189-00 cargo hook kitSTC SR00407SEFabrication of Onboard Systems Model 200-187-00 cargo hook kitSTC SR00408SEFabrication of Onboard Systems Model E-62 Cargo Hook Load Weigh SystemSTC SR00418SEFabrication of Onboard Systems Model 200-195-00 (without load weigh) and 200-196-00 (with load weigh) Cargo Hook Suspension Systems.STC SR00439SEFabrication of Onboard Systems Model 200-190-00 Cargo Hook KitSTC SR00525SEFabrication of Onboard Systems Model 200-231-00 and 200-231-01 Cargo Hook Attach Point Kit and installation of these Cargo Hook Attach Point KitsSTC SR00538SEFabrication of Onboard Systems Model 200-232-00 cargo hook kitSTC SR00557SEFabrication of Onboard Systems Model 200-225-00 (without load weight) or 200-226-00 (with load weight) cargo hook suspension systemSTC SR00558SEFabrication of Onboard Systems Model 200-229-00 Cargo Hook KitSTC SR00578SEFabrication of Onboard Systems Cargo Hook Kits Model 200-227-00 (without load weigh), Model 200-228-00 (with load weigh), Model 200-313-00 (28V, without load weigh), Model 200-314-00 (28V, with load weigh).STC SR00649SEFabrication of Onboard Systems Model 200-233-00 or 200-235-00 (without load weigh) or 200-234-00 or 200-236-00 (with load weigh) cargo hook suspension systemSTC SR00681SEFabrication of Onboard Systems Model 200-243-00 or 200-243-01 Cargo Hook Load Weigh SystemSTC SR00699SEFabrication of Onboard Systems Model 200-246-00 cargo hook kitSTC SR00711SEFabrication of Onboard Systems Model 200-244-00 cargo hook kitSTC SR00724SEFabrication of Onboard Systems Model 200-249-00 (without load weigh) or 200-250-00 (with load weigh) cargo hook suspension systemSTC SR00765SEFabrication of Onboard Systems Model 200-239-00 (H-frame) or 200-240-00 (frame swing) cargo hook kitSTC SR00808SEFabrication of Onboard Systems Model 200-253-00 (without load weigh) and Model 200-254-00 (with load weigh) Big Mouth Hook Kit and Model 200-290-00 (without load weigh) and Model 200-291-00 (with load weigh) 3.5KK Cargo Hook KitSTC SR00850SEFabrication of Onboard Systems Model 200-260-00 Cargo Hook Kit and Model 200-260-01 Cargo Hook KitSTC SR00886SEInstallation of Onboard Systems International Cargo Hook KitsSTC SR00892SEFabrication of Onboard Systems International Model 200-264-00, 200-264-01, and 200-264-02 Cargo Hook Kits.STC SR00896SEInstallation of Onboard Systems International Cargo Hook Kit and Load WeightSTC SR00897SEFabrication of Onboard Systems Model 200-270-00, 200-270-01, 200-271-00, and 200-271-02 Cargo Hook KitsSTC SR00898SEFabrication of Onboard Model 200-258-00 (without load weigh), 200-259-00 (with load weigh) or 200-259-01 (with load weigh and 5V Lighting) cargo hook systemSTC SR00920SEFabrication of Onboard Systems Model 200-262-00 cargo hook suspension systemSTC SR01064SEFabrication of Onboard Systems Model 200-265-00 12 Volt Talon LC Keeperless cargo hook kit without load weigh, Model 200-266-00 12 Volt Talon LC Keeperless Cargo hook kit with load weigh, Model 200-288-00 28 Volt Talon LC Keeperless cargo hook kit without load weighSTC SR01164SEInstallation of Onboard Systems International Cargo Hook Swing Suspension SystemSTC SR01165SEFabrication of Onboard Systems Model 200-282-00 and 200-282-03, Cargo Hook Sling Suspension Kits.STC SR01166SEFabrication of Onboard Systems Model 200-281-00 Cargo Hook KitSTC SR01393SEFabrication of Onboard Systems Model 200-286-01 Cargo Hook KitsSTC SR01394SEFabrication of Onboard Systems Models 200-287-00 and 200-287-01 Cargo Hook KitsSTC SR01424SEFabrication of Onboard Systems Model 200-292-01 Cargo Hook Kit and Model 200-292-02 Cargo Hook KitSTC SR01588SEFabrication of Onboard Systems Model 200-299-00 Fuel Drain Guard Kit in accordance with Federal Aviation Administration (FAA) approved Onboard Systems Master Drawing List No. 155-111-00, Rev. 6, dated March 11, 2011, or later FAA-approved revision and Installation of the Fuel Drain Guard KitSTC SR01694SEFabrication of Onboard Systems Models 200-302-00 and 200-387-00 Talon LC Hydraulic Cargo Hook Kits without Load Weigh and Models 200-303-00 and 200-388-00 Talon LC Hydraulic Cargo Hook Kits with Load WeighSTC SR01731SEFabrication of Onboard Systems Model 200-317-00 Cargo Hook Suspension Kit.STC SR01795SEFabrication of Onboard Systems Model 200-308-00, Cargo Hook Suspension KitSTC SR01804SEInstallation of Onboard Systems International Load Weigh SystemSTC SR01808SEInstallation of Onboard Systems International Cargo Hook KitSTC SR01812SEInstallation of Onboard Systems International Talon LC Hydraulic Cargo Hook Kit, with or without Load WeighSTC SR01815SEFabrication of Onboard Systems Model 200-321-00 Cargo Hook Swing Suspension Kit and 200-322-00 Cargo Hook Sling Suspension KitSTC SR01862SEFabrication of Onboard Systems Model 200-282-01 or 200-282-02, Cargo Hook Sling Suspension SystemSTC SR01943SEInstallation of Onboard Systems International Cargo Hook Kits and Load Weigh KitsSTC SR02028SEFabrication of Onboard Systems International Model 200-351-00, Cargo Hook Kit,STC SR02035SEFabrication of Onboard Systems International Model 200-352-00, Cargo Hook KitSTC SR02447SEFabrication of Onboard Systems International R66 Cargo Hook Suspension System