Fairchild F-27B
STCs that may be installed · 57
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 ('3373006')
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 ('3373006')
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 SA468CEUnited Data Control V-557 cockpit voice recorder.STC SA619WE18-passenger interior and equipment, including an oxygen system, inverter, and antennas.STC SA790WEReplacement of carbon pile voltage regulator for 30-volt DC generator with Leland Airborne Products Type CSV-1105-1 solid state voltage regulator.STC SA968WETwo windows in aft fuselage.STC SA969WETwo radar altimeter antennas. (This is a structural installation only and does not include the operational evaluation of the antennas or system.)STC SA970WEDoppler antenna. (This is a structural installation only and does not include the operational evaluation of the antenna or system.)STC SA1-429Outer wing structure modification to provide additional fuel.
Back to Fairchild F-27B