STCs approved under this data sheet · 104

Current certificates first, most recently changed first.

Query with SQL

duckdb -csv -c "SELECT s.stc_number, s.description, s.holder, s.status, s.status_date
  FROM 'https://openairdocs.org/data/latest/faa_stc.parquet' s
  WHERE s.stc_number IN (SELECT stc_number FROM 'https://openairdocs.org/data/latest/faa_stc_model.parquet' WHERE tcds_number = 'A20EU')
  ORDER BY s.status = 'Current' DESC, s.status_date DESC, s.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 s.stc_number, s.description, s.holder, s.status, s.status_date
FROM 'https://openairdocs.org/data/latest/faa_stc.parquet' s
WHERE s.stc_number IN (SELECT stc_number FROM 'https://openairdocs.org/data/latest/faa_stc_model.parquet' WHERE tcds_number = 'A20EU')
ORDER BY s.status = 'Current' DESC, s.status_date DESC, s.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 SA380NEInstallation of dual Sperry flight director system.Georgetown Aircraft Serv STC SA381NEInstallation of dual Sperry air data sys. AZ-800.Georgetown Aircraft Serv STC SA382NEInstallation of a Sperry vertical navigation sys., VN801.Georgetown Aircraft Serv STC SA1258EAInstallation of Cosco model78-( ) child restraint system. (172M S/N 17263459 - 17267584)Miller Stuart R

Back to TCDS A20EU