Embraer S A ERJ 170-200 STD
STCs that may be installed · 55
In force first, then newest. The registry doesn’t record which STCs an aircraft has.
Query with SQL
duckdb -csv -c "SELECT s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
SELECT stc_number, min(matched_model) AS matched_model
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
WHERE aircraft_model_code IN ('3260417')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
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, m.matched_model
FROM (
SELECT stc_number, min(matched_model) AS matched_model
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
WHERE aircraft_model_code IN ('3260417')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY s.status = 'Current' DESC, s.status_date DESC, s.stc_numberRun 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 ST03269NYInstallation of Dunlop Aircraft Tyres Limited Radial Nose Landing Gear, P/N DZ32816TSTC ST03262NYInstallation of Quality Aircraft Interiors Oxygen Cylinder Restraint System (OCRS), P/N OCRS-1730-QAI, Models A & DSTC ST02146NYInstallation of EMS Technologies Ltd. Cabin Network Xcelerator (CNX).STC ST02638CHInstallation of Electronic Flight BagSTC ST02248NYInstallation of EMS HSD-64, HSD-128, HSD-HCM, and HSD-X
Back to Embraer S A ERJ 170-200 STD