STCs that may be installed · 158

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

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 = '3940031' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52119') 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

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 = '3940031'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52119')
    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 = '3940031'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52119')
  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 · Airbus A330-223

STC ST01924NYInstallation of replacement handset cradles for Matsushita Avionics Systems Corporation (MASC) System 2000E or System 3000 passenger entertainment system.Delta Engineering STC ST00626CHInstallation of replacement immersion heater.Aircraft Food Service Equipment Repair STC ST01318ATManufacture and installation of cargo pallet (p/n DM-12936) with either a jacket type restraint (p/n WCSI-1111) or a net type restraint (p/n AC20-0253300), in accordance with AVITAS Engineering report 96PLRP.001R-1, Appendix A Master Drawing List, issue E, dated December 5, 2002, or later FAA approved revisions.Saeplast STC ST01004NYInstallation of cargo restraint straps.Airline Container Manufacturing Co Inc · Lists A330 Series STC SA9039NM-DInstallation of vacuum flush toilets.Rogerson ATS STC ST02508ATManufacture of a service cart for galley stowage, P/N CAF014-101-( ).JK Aerospace, Inc.STC SA02100ATManufacture of a three tier folding cart BFE P/N 2934.BFE Services · Lists A330 Series STC ST01796WIInstallation of an AV201 series Portable Oxygen UnitB/E Aerospace Inc.

Back to N855NW