N135EH, cancelled Apr 4, 2017
Service difficulty reports · 24
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N135EH' AND deregistration_id = 'N135EH-2017-04-04' ORDER BY difficulty_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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N135EH' AND deregistration_id = 'N135EH-2017-04-04' ORDER BY difficulty_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 ERAA097113Caliper · damagedDISC RUBBING CALIPER ASSY. CLEANED, INSPECTED, AND REPAIRED. TESTED.SDR ERAA096616Elt · crackedFOUND CRACKED ELT ASSY. SENT UNIT TO MANUFACTURER FOR REPAIR.SDR ERAA096631Float · leakingCYLINDER FOUND TO BE LEAKING NITROGEN FROM SQUIB VALVE. PERFORMED 6 MONTH FLOAT INSPECTION AND REPACK. REPAIRED LEAKING SQUIB VALVE BY REPLACING O-RING AND LEATHER BACK UP RING AT VALVE TO MANIFOLD JUNCTION. VERIFIED COMPLIANCE WITH SB NUMBERS 102-81-3, 12SDR ERAA097104Bolt · galledBLADE BOLT GALLED SLIGHT GALLING ON BOTH BOLTS ACTION TAKEN. SCRAPPED BOTH PRIMARY BLADE BOLTS DUE TO GALLING BEYOND LIMITS IAW BO-105 MM CH 13.SDR ERAA096632Oil Cooler · making metalOIL COOLER HAD METAL IN TRANSMISSION OIL FILTER CHANGE IAW BO105 MM. LEAKING IN CORE THE UNIT WAS CLEANED, FLUSHED, OVERHAULED, TESTED AND INSPECTED. UNIT PASSED X RAY INSPETION, NO METAL.SDR ERAA091802Bearing · failedMETAL ON BOTTOM PLUG. BROKEN NR 4 BEARING CAGE. INSTALLED SERVICEABLE GEARBOX. COMPLIED WITH E CHECKSDR ERAA093717Governor · inoperativeN2 DROPS OFF 10-12 PERCENT IN CRUISE FLIGHT AND VERY STIFF ARM. INTERNAL COMPONENTS VERY WORN FOR LOW TIME USED. POSSIBLE EXTERNAL VIBRATIONS. REPAIRED AND TESTED IAW MFG OHM FORM 15-1095A.SDR ERAA093705Fcu · out of adjustFUEL CONTROL IDLES BELOW 59 PERCENT AND WILL NOT ADJUST UP. MAKING VALVE FUEL FLOW ON HOT SIDE, IDLE FOUND ADJUSTABLE, CUTOFF SHAFT LEAKING. A REPAIRED AND TESTED IAW MFG OHM FORM 15-602E.SDR ERAA087107Transmitter · erraticFUEL PROBE HAS ERRATIC INDICATION. REPLACED CASE ASSEMBLY AND TESTED.SDR ERAA087104Engine · making metalENGINE MAKING METAL. FOUND TURBINE MOUNT STUD ON LT SIDE OF GEARBOX LOOSE, MOVING.SDR ERAA087097Governor · stiffGOVERNOR HITS MAX STOP WITH MAX BEEP AND UP COLLECTIVE AND ARM VERY STIFF. HEAVY WEAR ON INTERNAL COMPONENTS MAY BE DUE TO EXTERNAL VIBRATION SOURCES. WORK SCOPE CHANGED TO OVERHAUL DUE TO SEVERITY OF WORN COMPONENTS. OVERHAULED IAW HONEYWELL OHM FORM 15-109SDR ERAA093691Rotor Head · damagedINNER SLEEVE BUSHINGS DEBONDED. OB BUSHINGS 2 EA ON INNER SLEEVE CRACKED. BOTH RINGS IN BOTTOM OF GRIPS MECHANICALLY DAMAGED. IB INNER SLEEVE BUSHINGS WORN. TEETER BUILT BUSHINGS WORN AND MECHANICALLY DAMAGED . ALL FOUR TEFLON GRIP BUSHINGS WORN. ONE GRIPSDR ERAA086436Gearbox · making metalGEARBOX MAKING METAL. 2 1/2 BEARING FAILED. OVERHAULED GEARBOX. COMPLIED WITH CEB A-1211 MAG PLUG INSP, CEB-A-1340 REMOVE PINION GEAR, CEB-A-1351, REPLACE OIL TUBE, CEB-1363 NEW DAMPER RING, CEB-A-1372 INSPECT DAMPER RING, AD 2001-24-12 PER CEB-A-1386.SDR ERAA097080Elt · crackedSUB ASSEMBLY, TOP COVER CRACKED. REPLACE BATTERY, SUB ASSEMBLY, TOP COVER. TESTED IAW ARTEX PROCEDURES 4128,4129,4130.SDR ERAA081160Fuel Control · malfunctionedFUEL CONTROL CAUSES ROTOR DROOP, UNIT OVERHAULED IAW HONEYWELL OHM FOR 15 602E.SDR ERAA080479Turbine Wheel · damagedUNIT HAS LOW POWER. NR 4 NOZZLE AND NR 3 WHEEL CRACKED. INSTALLED NEW NR 3 & 4 WHEEL AND NEW NR 4 NOZZLE. C/W CEB-1360; RE-COAT INNER SHAFT.SDR ERAA079869Governor · wornCAUSES NR TO BLEED OFF AFTER BEEPED TO 100 PERCENT. COVERED BY SEVERE PREMATURE WEAR. EVIDENCE OF TORSIONAL RESONANCE CONDITION BETWEEN PTG DRIVE & GEAR BOX DRIVE. WATER / RUST ON SEVERAL PARTS. SPEEDER SPRING & 2D CAM LEVER. ACTION TAKEN: SET PTG TORSIONSDR ERAA076665Blade · debondedBLADE IS DEBONDING ON LEADING EDGE. POTTING NEEDS CHANGING. ALL ABRASI9ON STRIPS VOID SCARF JOINT, NR 1 ABRASION STRIP ERROSION NOSE AND NECK SHELL CRACKED AT FITTING, SKIN AT ROOT AREA CRACKED ROVING FILLER SEPERATED, UPPER SURFACE AT TRAILING EDGE, DAMPNESDR ERAA076664Blade · debondedBLADE IS DEBONDING ON LEADING EDGE. POTTING NEEDS CHANGING NOSE AND NECK SHELLS CRACKED @ NECK DOWN AREA, SKIN CRACK AND VOIDED @ NECK AREA, TEFLON MISSING FROM MAIN BUSHING, DRAG BUSHING HAS FRAYED AND MISSING TEFLON, DAMPNER WRAP VOID LOWER SURFACE, ALL ABRSDR ERAA076663Blade · debondedM/R BLADE IS DEBONDED. LEADING EDGE DEBONDING, POTTING NEEDS CHANGING. ACTION TAKEN: ALL ABRASION STRIPS VOID, HEAVY ERROSION ON ABRASION STRIP, P.U. FILM DETERIORATION, PAINT PEELING, HARDWARE CORRODED SWEEP OUT -13.21MM, NOSE AND NECK SHELLS CRACKED SKINSDR ERAA96292Nozzle · defective#2 NOZZLE WAS OVERHAULED. ERA REC'D BACK AT ERA 7-18-96. SEAL BORE TOO LARGE. PROTRUSIONS ON THE INNER BAND, NEEDS TO BE REMOVED.SDR ERAA96286Pt Support · defectivePT SUPPORT OVERHAULED 7-3-96. REAR SUMP COVER NOT SECURE TO SUPPORT. EVALUATE CRACKS ADJACENT TO 6 O'CLOCK STRUT.SDR ERAA96242Wheel · blade stretchWHEEL HAS 252.0 HRS ON IT AND HAS BLADE TIP STRETCH TO 6.197".SDR ERAA9576Adapter · plating flakingNEW ADAPTER THAT HAS DAMAGED INTERNAL SPLINES, FLAKING SILVER PLATING.
Back to N135EH, cancelled Apr 4, 2017