Robinson Helicopter R22 ALPHA
STCs that may be installed · 64
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 ('7640104')
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 ('7640104')
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 SH4969NMInstallation and fabrication of the Apollo Model DTM-3 spray tank system.STC SA00061LAInstallation of JPI digital tachometer.STC SA00238SEInstallation of Aviation Development Corporation's sump mounted chip detectorSTC SR00166SEFabrication and installation of Busse Model CBD-1 Utility Tray Assembly.STC SR0003BOInstallation of Helipod cargo containers.STC SR15BOInstallation of the Altair CCP-A-017-1 Collective Grip Assembly.STC SR9BOInstallation of the Altair SCY4-A-016-HH, -SH, -NH, or -NS Cyclic Grip Assemblies.STC SA1626NM PAGE 2Installation of Electronics Int'l Digital EGT/CHT Instruments and accessories. (201 Series)STC SH5237NMInstallation of Pneumatic door actuators on left and right cabin doors.STC SA2350NM PAGE 2Installation of Electronics International Inc digital carburetor/outside air temperature gaugesSTC SA4302NMInstallation of Electronics Int'l digital automatic engine analyzer.STC SA3862NM PAGE 2Installation of Electronics International Primary TIT/EGT/CHT instruments, remote switches and associated accessories.STC SA2190NM PAGE 2Installation of electronics International Digital Volt/Amp Gauges and Accessories.STC SA2350NMInstallation of Electronics International Inc digital carburetor/outside air temperature gauges listed on the attached continuation sheet and the associated accessories.
Back to Robinson Helicopter R22 ALPHA