Air Tractor AT-402B
STCs that may be installed · 54
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 ('0390208')
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 ('0390208')
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 SA01528CHInstallation of Walter M601E-11 model turbine engine and an AVIA Propeller Limited VJ8.510 or VJ8.510AG propeller system or Hartzell HC-B3TW-3/T10282NS+4 model propeller.STC SA00198SEFabrication and installation of vortex generators and 'delta wings' mounted on the wings and strakes mounted above the left- and right-hand wing/ fuselage junctions.STC SA09200AC-DInstallation of S-TEC System 40/50 Single and Two Axis Automatic Flight Guidance Systems, Model ST-656-40/50.STC SA7469SWInstall freon air conditioning system with inverter and 117 VAC compressor.
Back to Air Tractor AT-402B