N129TW
STCs that may be installed · 465
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 = '1384894')
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 = '1384894') 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 · Boeing 747-128
STC SA503EA-D1) Add additional first class passenger seats and class divider. 2) Add two additional coat closets in Zone CSTC SA2117WEModify 747-100 Series Aircraft by the installation of 747 Lower Deck Modular and Unitized Baggage/Cargo Containers.STC SA3547WEInstallation of cargo container P/N 025-45571STC SA490GLInstallation of a Telephonics P/N 547-000-1 central switching unit.STC SA702CEInstallation of Bendix standby horizon indicator and inverter.STC SA748NEInstallation of Iacobucci Corp. meal trolleys P/N IM16-00 and IM-16-01.STC ST00989LA-DInstallation of Rockwell Collins FPI-920 LCD EHSI/TAWS Display.STC ST00110LA-DInstallation of wing pylon electrical disconnect panels.STC ST00111LA-DInstallation of a cargo handling system.STC ST00752LA-DInstallation of Rockwell Collins alternate part number SVHS Video Tape players.STC SA4215NM-DReconfiguration of interior seating.STC SA4221NM-DInterior modification.STC SA3074WEInstallation of 96 x 125 inch animal containers.STC SA4149NMInterior reconfiguration including installation of seats, stowage units, and galleysSTC SA2715NMInstallation of a Zone A center- piece stowage unit assembly.