N24089

STCs that may be installed · 671

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 = '1384478')
    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.

Airframe · Boeing 737-242C

STC SA2258WEThe installation of Firestone 40 X 14-21 tires at 40% tire deflection per sealed Piedmont Service Evaluation Report SER Number 70-18, and Supplement "A" to Airplane Flight Manual Dt-8737, 201Piedmont Aviation Inc · Lists 737-200 SeriesSTC SA9PCInstallation of Bendix Main Wheel AssemblyAloha Airlines · Lists 737-200 SeriesSTC ST430SOInstallation of unusual events recording system.Technology Inc · Lists 737-200 SeriesSTC ST01091SEFabrication of lightweight window plugsLiteAir Aviation Products Inc.STC ST01504AT-DInstallation of complete provisions for a Trimble 2101I/O GPS.AIRCRAFT RECONFIG TECHNOLOGIES, LLC · Lists 737-200 SeriesSTC ST01796WIInstallation of an AV201 series Portable Oxygen UnitB/E Aerospace Inc.STC SA2050SOInstallation of passenger interior.American Airlines Inc · Lists 737-200 SeriesSTC SA00968LAInstallation of Rockwell Collins Air Transport System TCAS II system.Hollingsead InternationalSTC ST00968LAInstallation of Rockwell Collins Air Transport Systems TCAS II System.Hollingsead InternationalSTC ST01462LA-DInstallation of Honeywell Enhanced Ground Proximity Warning System.Hollingsead InternationalSTC ST01796LAInstallation of Rockwell Collins FPI-930 5 ATI LCD EADI & EHSI, WXR-700X Basic Turbulence Weather Radar System, and Honeywell Compass SystemHollingsead International · Lists 737-200 SeriesSTC ST01797LAInstallation of Honeywell Mark VII Enhanced Ground Proximity Warning System (EGPWS)Hollingsead International · Lists 737-200 SeriesSTC ST00170LA-DInstallation of provisions for the seat back telephones in passenger seats.Hollingsead International · Lists 737-200 SeriesSTC ST00397LA-DONE-ONLY STC: Installation of first class passenger seats and tables, S/N 19440.Hollingsead International · Lists 737-200 SeriesSTC ST00761LA-DInstallation of Rockwell Collins CMU-900 ACARS and VHF-700 #3 VHF Radio Provisions.Hollingsead InternationalSTC ST00762LA-DInstallation of Flight Data Recorder expanded parameters.Hollingsead InternationalSTC SA4214NM-DInterior reconfiguration including installation of G-2 galley and class divider.Hollingsead International · Lists 737-200 SeriesSTC SA4184NM-DInstallation of class dividers.Hollingsead InternationalSTC ST01143SE-DInstallation of a new security flight deck door in accordance with Jamco America Inc. Master Drawing List (MDL) No. IA-085COAMDL, Revision AL, dated December 10, 2008, or later Federal Aviation Administration (FAA) approved revision.Jamco America Inc · Lists 737-200 SeriesSTC SA1082NWInstallation of auxiliary fuel tanks in the aft cargo compartment. (737 series -2K9A)Rogerson ATS · Lists 737 SeriesSTC ST02688ATInstallation of Rockwell/Collins CMU-900 ACARS System in accordance with Aircraft Engineering and Installation Services Master Drawing List 234-03-0003 Rev. A dated 16 July 2003 or later FAA approved revision.Aircraft Engineering & Installation Services Inc · Lists 737-200 Series
Back to N24089