N929JG
STCs that may be installed · 110
Approved for this aircraft’s airframe or engine model. The registry doesn’t record which STCs an aircraft has; its records do. In force first, then newest.
Query with SQL
duckdb -csv -c "SELECT m.matched_by, s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
SELECT stc_number, min(side) AS side, arg_min(matched_by, side) AS matched_by, arg_min(matched_model, side) AS matched_model
FROM (SELECT stc_number, 1 AS side, 'airframe' AS matched_by, matched_model FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet' WHERE aircraft_model_code = '5170506')
GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY m.side, 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 m.matched_by, s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model FROM ( SELECT stc_number, min(side) AS side, arg_min(matched_by, side) AS matched_by, arg_min(matched_model, side) AS matched_model FROM (SELECT stc_number, 1 AS side, 'airframe' AS matched_by, matched_model FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet' WHERE aircraft_model_code = '5170506') GROUP BY stc_number ) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number) ORDER BY m.side, s.status = 'Current' DESC, s.status_date DESC, s.stc_number
Run 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.
Airframe · Learjet 25
STC SA2657SWModification of air conditioner motorSTC SA639ALInstallation of Model EP-110 starter/generator decoupler system on Models 23, 24, 25 airplanes using Bendix Model30B-37 starter generators.STC SA2861SWAddition of Hydro seal fluid additive to nose and main gear shock struts.STC SA175RMReplacement of throttle knob, Model EP-004, for 20 series Learjet equipped with Dee Howard thrust reversers.STC SA1RMInstallation of cargo restraint systemSTC ST147RMInstallation of Communications Components Corp. Ontrac III VLF/Omega navigation system.STC SA2788SWInstallation of tail-stringer antenna housing.STC SA1746SWInstallation of Ray Electronics Model 7107 battery fault warning system.STC SA36NWInstallation of Sundstrand Ground Proximity Warning SystemSTC ST02893ATInstallation of a Boom Beam Taxi/Landing Light System