Fairchild F-27J
STCs that may be installed · 65
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 ('3373016')
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 ('3373016')
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 SA323SOSolid state voltage regulator.STC SA330SONew cockpit door with electric lock device.STC SA342SOCockpit voice recorder.STC SA4-1027Aircraft interior furnishings.STC SA4-1543Interior modification.STC SA4-947Floor structure for installation of seats and divans.STC SA441EAAutomatic flight control and flight director system.STC SA446WEGPT30-54 turbine APU.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-27J