STCs that may be installed · 162

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 = '3930312' UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52061') 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 = '3930312'
      UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52061')
    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 = '3930312'
    UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52061')
  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 Industrie A300 B4-622R

STC ST4CHInstallation of replacement oven door.Aircraft Food Service Equipment Repair · Lists A300 Series STC SA2878SOInstallation of 234 passenger interior (48 first class/186 tourist class seats).Eastern Airlines, Inc · Lists A300 B4 Series STC SA4926NMInstallation of horse containers. (A310 SERIES -200C) (A300 SERIES -600C)Instone Airline Ltd · Lists A300 Series STC SA2391SOModification of cabin interior.Cross Continent Aircraft Services, Inc · Lists A300 Series STC SA2215SOInstallation of floor proximity escape path marking system.Jetaire Services, Inc · Lists A300 Series STC SA1900SOInstallation of Airfone air/ground telephone system.Eastern Airlines, Inc · Lists A300 B4 Series STC SA1752SOInstallation of passenger seats.Eastern Airlines, Inc · Lists A300 Series STC SA1258EAInstallation of Cosco model78-( ) child restraint system. (172M S/N 17263459 - 17267584)Miller Stuart R · Lists A300 Series STC ST00747LA-DInstallation of control column and rudder pedal, position sensors for Flight Data REcorder Expanded Parameters.Hollingsead International STC SA4218NM-DReconfiguration of interior seating. (A300 B4 SERIES -622R)Hollingsead International

Engine · Pratt & Whitney PW4158

STC SE01543CHReplace Hamilton Sundstrand P/N 778839-13, 778839-14, 778839-19, 778839-20, 778839-37, 778839-38, 816682-1, 840618-2, 880724 carbon bushings with Cook Airtomic P/N AIR22947 Slotted Entry Busing in the High Pressure Shutoff Valve.Cook Airtomic STC SE00053AT-DModification of fan exit guide vane, to line replaceable unit configuration.Chromalloy Gas Turbine Corp.

Back to N741FD