Airbus Helicopters ASB EC135-63A-012
Service difficulty reports that cite it · 9
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 = 'airbus-helicopters/ec135-63a012' 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 = 'airbus-helicopters/ec135-63a012' 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 QMLA2017121917139Transmission · Urocop EC135T2TWO MAIN TRANSMISSION CHIP INDICATIONS 35 HOURS APART REQUIRING PINION AND BEVEL GEAR INSPECION PER AIRBUS ASB EC135-63A-012. FOUND PITTING ON #1 BEVEL GEAR THAT WAS BEYOND LIMITS. THIS AIRCRAFT REMAISDR QMLA2017090617088Gear · Urocop EC135P2AIRCRAFT EXPERIENCED A COCKPIT MGB CHIP LIGHT AFTER ENGINE START AND BEFORE TAKE-OFF. SERVICEABILITY CHECKS AND MGB OIL FLUSH WAS ACCOMPLISHED AND AIRCRAFT RETURNED TO AIRWORTHY CONDITION AND RELOCATESDR QMLA2016072416086Transmission · Urocop EC135P2DURING MAINTENANCE GROUND RUN FOR GENERATO ADJUSMENT, TRANSMISSION CHIP LIGHT CAME ON. THE TRANSMISSION OIL AND FILTER HAD JUST 55 MIN TT SINCE LAST CHANGE FOR ANOTHER CHIP INDICATION. THE MECHANIC RESDR QMLA2015101315096Pinion · Urocop EC135P2MAIN TRANSMISSION HAD STAGE 2 HIGH IRON INDICATION FROM OIL SAMPLE, REQUIRING INPUT DRIVE STAGE TOOTHING INSPECTION IAW ASB EC135-63A-012 WITHIN 25 FH. INSPECTION REVEALED PITTING IN BOTH INPUT PINIONSDR M3XA2014111108Chip Detector · Urocop EC135P2THE PILOT ENCOUNTERED A TRANSMISSION CHIP LIGHT WITH THE MEDICAL CREW & PATIENT ONBOARD. THE PILOT IMMEDIATELY PERFORMED A PRECAUTIONARY LANDING SAFELY. MAINTENANCE WAS NOTIFIED & EN ROUTE WITH SUPPLISDR QMLA2012122012198Pinion Gear · Urocop EC135T2PRIOR TO TAKEOFF, MGB CHIP LIGHT ILLUMINATED. INSPECTED CHIP DETECTOR AND FILTER ELEMENT, FINDINGS CLASSIFIED AS STAGE "B" DEPOSITS IAW SECTION 3, PART 3, FIG 5. REPLACED OIL FILTER AND CLEANED CHIP PSDR QMLA2012801712134Gearbox · Urocop EC135P2DURING FLIGHT, TRANSMISSION CHIP WARNING WAS NOTICED. PILOT MADE A UNSCHEDUELD LANDING AT NEAREST AIRPORT. MAINTENANCE INSPECTED TRANSMISSION AND A CHIP WAS FOUND. CHIP WAS FOUND TO BE A STAGE A AND WSDR QMLA2012081412133Transmission · Urocop EC135P1TRANSMISSION CHIP LIGHT ILLUMINATED ON WARNING PANEL ON LANDING. REMOVED CHIP DETECTOR AND OIL FILTER, FOUND FINE METAL DEPOSITS. COMPLIED WITH SB EC135-63A-012 PART 3, STAGE BAND PART 4 DRIVE STAGE TSDR QMLA2012061212096Bevel Gear · Urocop EC135P2PILOT REPORTED IN CRUISE FLIGHT, ACFT TRANSMISSION CHIP ILLUMINATED TWICE. CAUTION LIGHT WENT OUT OF IT'S OWN BOTH TIMES. DURATION WAS 5-7 SECONDS EACH TIME. CHIP CAUTION WAS NOT ILLUMINATED, BUT DIVE
Back to Airbus Helicopters ASB EC135-63A-012