Columbia Aircraft SB 107-26-S0004
Service difficulty reports that cite it · 15
Newest first, with the revision each cites, as OpenAirDocs read it from the records’ text. OpenAirDocs read these citations from the records’ text, so one can be misread: check it against the record. A newer revision may exist that no record cites.
Query with SQL
duckdb -csv -c "SELECT s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id
WHERE c.document_id = 'columbia/107-26-s0004' AND c.record_type = 'faa_service_difficulty_report'
GROUP BY ALL
ORDER BY max(c.record_date) DESC"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 s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions, bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id WHERE c.document_id = 'columbia/107-26-s0004' AND c.record_type = 'faa_service_difficulty_report' GROUP BY ALL ORDER BY max(c.record_date) DESC
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.
SDR CHIA201907234035Fire Detector · Boeing 1072DURING CRUISE FLIGHT PILOTS NOTICED #1 T-HANDLE FLICKERING, VERIFIED IT WAS A FALSE INDICATION AND DID NOT NEED TO UTILIZE ANY EMERGENCY PROCEDURES. FIRE LIGHT THEN EXTINGUISHED WITHIN 30 SECONDS. RARSDR CHIA201907214031Detector · Boeing 1072DURING CRUISE FLIGHT PILOTS NOTICED #1 T-HANDLE FLICKERING, VERIFIED IT WAS A FALSE INDICATION AND DID NOT NEED TO UTILIZE ANY EMERGENCY PROCEDURES. FIRE LIGHT THEN EXTINGUISHED WITHIN 30 SECONDS. AIRSDR CHIA2018101083560Fire Detector · Boeing 1072NR 1 FIRE LIGHT CAME ON DURING FLIGHT. AIRCRAFT CONTINUED TO REGULARLY SCHEDULED DESTINATION. REMOVED AND REPLACED NR 1 AFT UPPER FIRE DETECTOR. RETURNED AIRCRAFT TO SERVICE. INTERIM SUPPLEMENTAL INFOSDR CHIA2018101063561Fire Detector · Boeing 1072NR 1 FIRE LIGHT CAME ON DURING FLIGHT. AIRCRAFT CONTINUED TO REGULARLY SCHEDULED DESTINATION. REMOVED AND REPLACED NR 1 AFT UPPER FIRE DETECTOR. RETURNED AIRCRAFT TO SERVICE. INTERIM SUPPLEMENTAL INFOSDR CHIA2018032803196Fire Warning · Boeing 1072NR 2 ENGINE FIRE LIGHT ILLUMINATED FOR A BRIEF AMOUNT OF TIME. PILOTS CONFIRMED THAT THERE WAS NO FIRE AND DETERMINED THAT IT WAS A FALSE FIRE INDICATION. SUPPLEMENTAL INFORMATION; THE DETECTORS IN THSDR CHIR201709293001Wire · Boeing 1072#1 ENGINE F I RE WARNING LIGHT ILLUMINATED, BUT NO F I RE WAS PRESENT. AC RET U RNED T O BASE AT BAF. CHANGED #1 AFT L OWER F I RE EYE FOR C HAFED WI RE .SUPPLEMENTAL INFORMATION; THE DETECTORS IN THISDR CHIR201709072957Ground Wire · Boeing 1072WHILE IN ENROUTE THE NR 1 ENGINE FIRE LIGHT ILLUMINATED (6) SEPARATE TIMES FOR 3-5 SECONDS EACH TIME, WITH 1-2 MINUTES IN BETWEEN OCCURRENCES. PILOT LANDED AND TURNED ACFT OVER TO MAINT. BLUE GROUND WSDR CHIR2879Wire Harness · Boeing 1072DURING FLIGHT, THE NR 1 FIRE HANDLE WARNING LIGHT ILLUMINATED. FALSE FIRE WARNING, FLIGHT CONTINUED. DURING TROUBLESHOOTING, FOUND THE NR 1 FWD OUTBOARD FIRE DETECTOR TO HAVE VOLTAGE IN EXCESS OF 11 VSDR CHIR20161121001Fire Detector · Boeing 1072FIRE DETECTION WARNING LIGHT ILLUMINATED DURING FLIGHT (FLIGHT ILLUMINATION). THERE HAVE BEEN SEVERAL PREVIOUS OCCURRENCES (SEE SUBMITTED SDR'S). THE NR 2 AFT, INBOARD, FIRE DETECTOR WAS REPLACED AND SDR CHIR20161009001Wire · Boeing 1072FIRE DETECTION WARNING LIGHT ILLUMINATED DURING FLIGHT. FAULTY PORTION OF THE NR 1 FIRE DETECTION SYSTEM WAS REPLACED FOR MULTIPLE NICKS IN THE WIRE SHIELDING AND SUSPECTED FAULTY SPLICES. NO FURTHER SDR CHIR20161008001Wire · Boeing 1072NR 1 ENGINE FIRE LIGHT ILLUMINATED IN FLIGHT (FALSE ACTIVATION). INSPECTED SYSTEM. NO FAULTS FOUND. REPLACED FWD UPPER & LOWER DETECTORS FOR TROUBLESHOOTING. AIRCRAFT RETURNED TO SERVICE. FAULTY PORTISDR CHIR20161007001Wire · Boeing 1072NR 1 ENGING FIRE DETECTION LIGHT ILLUMINATED DURING FLIGHT. INSPECTED SYSTEM. NO FAULTS FOUND. REPLACED BOTH AFT UPPER & LOWER FIRE DETECTORS. SYSTEM TESTED. AIRCRAFT RETURNED TO SERVICE. FAULTY PORTISDR CHIR20161006001Wire · Boeing 1072DURING CRUISE FLIGHT, THE NR 1 ENGINE FIRE DETECTION LIGHT FALSE ACTIVATED. SYSTEM INSPECTED. NO FAULTS FOUND. CHANGED THE SYSTEM AMPLIFIER FOR TROUBLESHOOTING. ACFT RETURNED TO SERVICE. FAULTY PORTIOSDR CHIR20161003001Wire · Boeing 1072NR 1 ENGINE FIRE WARNING LIGHT ILLUMINATED DURING FLIGHT. FALSE FIRE WARNING. FAULTY PORTION OF THE NR 1 FIRE DETECTION SYSTEM WAS REPLACED FOR MULTIPLE NICKS IN THE WIRE SHIELDING AND SUSPECTED FAULTSDR CHIR20160608001Fire Detector · Boeing 1072DURING TAKEOFF, NR 1 ENGINE FIRE WARNING LIGHT ILLUMINATED WITH NO SECONDARY INDICATIONS. ACFT LANDED IMMEDIATELY BACK AT MAINTENANCE RAMP. THE NR 1 AFT, UPPER, FIRE DETECTOR WAS REPLACED AND DOCUMENT
Back to Columbia Aircraft SB 107-26-S0004