Skip to content

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 ST00821LA-DInstallation of passenger cabin interior. Approved for GV, serial number 574 ONLY.Gulfstream Aerospace Corporation · Feb 2, 2000 STC SA813NEInstallation of aft cabin storage utility box. (U206F, TU206F S/N U20601701 TO U20603521) (U206, TU206G S/N U20603522 and up) (206H, T206H S/N T2068001 and up)Promavia · Feb 1, 2000 STC SA1008EAInstallation of single lamp logo light in horizontal tail.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA1036EAInstallation of vertical tail floodlights on upper surfaces of the horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA1123EAInstallation of Devore vertical tail floodlights on upper surface of horizontal stabilator.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA1126EAInstallation of DeVore vertical tail floodlights on upper surface of stabilatorDeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA1130EAInstallation of Devore vertical tail floodlights on upper surface of horizontal stabilizer. (235E 235GT, MS894E RALLYE 220 AND 220GT, MS892E-150 RALLYE 150GT, MS893E RALLYE 180GT)DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA1147EAInstallation of DeVore vertical tail floodlights on upper surface of horizontal stabilatorDeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA1153EAInstallation of DeVore 'tel- tail' lights on lower surface of horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA1158EAInstallation of DeVore 'Tel-Tail' lights on lower surface of horizontal stabilator.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA1159EAInstallation of DeVore 'Tel-Tail' lights on lower surface of horizontal stabilator.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2212WEInstallation of emblem lights mounted on trailing edge of wing tips.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2233WEInstallation of emblem lights mounted on trailing edge of wing tips.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2301WEInstallation of emblem light.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2302WEModification of pedestal flight idle stop and lift to reverse system.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2366WEInstallation of emblem lights at mid span of horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2539WEInstallation of emblem light.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2704WEInstallation of horizontal stabilizer mounted vertical tail floodlightDeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2774WEInstallation of wing tip mounted emblem lights.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2797WEInstallation of wing tip mounted emblem lights.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2876WEInstallation of vertical tail floodlights on the horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2906WEInstallation of vertical tail floodlights on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2943WEInstallation of recognition lights on horizontal stabilizer upper surface.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2944WEInstallation of DeVore emblem lights on horizontal stabilizer tips.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2974WEModification for installation of aft galley and forward galley rework.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2992WEInstallation of logo lights on horizontal stabilizer lower surface.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA2999WEInstallation of vertical tail floodlightsDeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3000WEInstallation of logo light assembly.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3003WEInstallation of recognition light assembly on horizontal stabilizerDeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3052WEInstallation of Vertical Tail Floodlights on horizontal stabilizerDeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3338WERecognition light installation on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3349WEInstallation of recognition lights on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3383WEInstallation of recognition lights on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3387WEInstallation of recognition lights on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3388WEInstallation of recognition lights on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3409WEInstallation of vertical tail flood lights on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3419WEInstallation of recognition lights on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3427WEInstallation of tail flood light on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3465WEInstallation of recognition light assembly on the horizontal stabilizerDeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3481WEInstallation of recognition light assembly on the horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3482WEInstallation of recognition light assembly on the horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3487WEInstallation of tail floodlight.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3498WEInstallation of tail flood light on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3499WEInstallation of tail flood lights on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3524WEInstallation of vertical tail flood lights on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3554WEInstallation of vertical tail floodlights on horizontal stabilizer.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3557WEInstallation of DeVore Aviation Corp. tail floodlights.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3595SWInstallation of tail floodlights.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3641WEInstallation of DeVore Aviation Corp. horizontal stabilizer mounted vertical tail flood lights.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000 STC SA3643WEInstallation of vertical tail floodlight.DeVore Aviation Corporation of America, a New Mexico Corporation · Jan 31, 2000