N865F
STCs that may be installed · 189
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 = '302198H'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52039')
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 = '302198H'
UNION ALL SELECT stc_number, 2, 'engine', matched_model FROM 'https://openairdocs.org/data/latest/faa_engine_model_stc.parquet' WHERE engine_model_code = '52039')
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_numberRun 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 · Mcdonnell Douglas DC-8-63F
STC SA2318WEInstallation of emergency exit lights.STC SA1812WEInstallation of Heath Tecna88 x 125-inch cargo pallets P/N AC-10355-1 and AC-10366-1 and net P/N AC-10357-1.STC SA1928WEInstallation of Heath Tecna88 x 125-inch cargo pallet P/N AC-10065-1 with Heath Tecna net P/N AC-10292-1 or Brownline net P/N 22758-51.STC SA1978WEInstallation of underseat baggage restraint system with certain specified seat models.STC SA2152WEInstallation of Heath 88 x 108 inch cargo pallet AC-10527-1 and net AC-10196-1.STC SA2218WEInstallation of Satco cargo pallet P/N 31 80-501, NAS classification3610-2A3P and P/N 31076-501, NAS classification 3610-2A1P with cargo nets Brownline P/N 22758-51, -52, -54, 22672-52, 22273-51, 23226-51, 40517-101; Heath Tecna P/N AC10292-1; Marino P/N LM 1500-100; and ANCRA Corp. P/N 40178-10.STC SA652EAInstallation of dual Decca doppler systems, Type 72.STC SA589EAInstallation of dual omnitrac navigation system.STC SA45SOLife rafts M6861-100.STC SA3-666Reduction of the rated cargo capacity of the cargo bin from 2420 to 2050 pounds. (Installs a removable, track mounted movable cargo bin)STC SA3-603Installation of removable, track mounted cargo binSTC SA1347WEGalley 100 and 200 at fuselage stations 447.75 to 490, and1385.5 to 1416.STC SA176SOAuxiliary galley.STC SA1783WEInstallation of underseat baggage restraint system.STC SA1796WEInstallation of underseat baggage restraint system.STC SA194SOPassenger seating and cabin interior.STC SA2087WEInstallation of Cargo Systems, Inc. 88 x 125-inch cargo pallet assembly 1950-90-1 with Brownline net P/N 22758-51.STC SA286SOGables G-1340B instrument warning system.STC SA306SOForward lounge compartment configuration change.STC SA343SOCockpit voice recorder.STC SA350SOGalleys 1 and 4.STC SA359SOSeat belt attachment.STC SA370SOSingle radio altimeter.STC SA373SOInstallation of remote accelerometer and mount assembly for DC-8 flight recorder.STC SA380SOInstallation of stretcher assembly.STC SA4-1026Forward lounge.STC SA52SOLife rafts 6924-100.STC SA543EAcockpit voice recorder.STC SA544WEInterior arrangements.STC SA545WEInterior arrangements.STC SA55SOB-500-2 oil separator.STC SA582WEAileron power system modification to incorporate a flexible hose.STC SA602SODual Collins AL-101 radio altimeter system.STC SA69EABrown line 21105-51 stretcher kit in passenger compartment.STC SA70SODeactivation of center wing and forward auxiliary fuel tanks.STC SA77EASP-30 autopilot modification to allow manual pitch operation while maintaining automatic roll and yaw control.STC SA94SOWN233-102 and WN333-101 passenger seats.STC SA994WERain repellent system.STC ST00988LA-DInstallation of Rockwell Collins TCAS II.