N430CH, cancelled Mar 13, 2012
Service difficulty reports · 145
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 = 'N430CH' AND deregistration_id = 'N430CH-2012-03-13' 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 = 'N430CH' AND deregistration_id = 'N430CH-2012-03-13' 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 AC2A072803Yoke · crackedSPAN-WISE CRACK ON TOP APPROX 12 INCHES FROM CENTER. REPLACED.SDR AC2A072802Pump · malfunctionedPSI ABOVE 1600 AT 10 DEGS. OAT. REPLACED PUMPSDR AC2A072797Exhaust Stack · crackedEXHAUST CRACKED.SDR AC2A072796Battery Pack · weakBATTERY FAILED FUNCTIONAL TEST. REPLACED BATTERY.SDR AC2A072795Liner · wornROTOR BRAKE WEAK - REPLACED LININGS WITH NEW.SDR AC2A072794Duplex Bearing · making metalMETAL IN SWASHPLATE GREASE. REPLACED DUPLEX BEARINGSDR AC2A072793Bushing · wornBUSHINGS WORN BEYOND LIMITS. REPLACED BUSHINGSSDR AC2A0000089Turbine Wheel · contaminatedFIELD MAINT REPORTED NR 1 ENGINE HAD FOREIGN OBJECT DAMAGE TO NR 1 ENG COMPRESSOR. MECH EXAMINED TURBINE FOR DAMAGE PER MAINT INSTRUCTIONS. DAMAGE FOUND ON TURBINE NR 1 WHEEL AND ENG REMOVED AND RETURNED FOR REPAIR. UPON TEARDOWN, FOUND NR 1 TURB WHEEL HAD SDR AC2A0000078Hinge · brokenCOPILOT VENT WINDOW IN COPILOT DOOR WINDOW, HAD BROKEN HINGE. REPLACED VENT WINDOW. (X)SDR AC2A0000072Drive Shaft · defectivePART IS DEFECTIVE. SHAFT DIAMETER THAT ENGAGES THE ARMATURE IS TOO LARGE. SUBMITTER STATED THIS IS A MANUFACTURING DEFECT. REPLACED SHAFT. (X)SDR AC2A0000080Cam · corrodedCAM FOLLOWERS ON HINGES FOR CABIN DOORS WERE FOUND TO HAVE CORROSION IN BEARINGS CAUSING THE BEARINGS TO SEIZE AND COME APART. THE CAM FOLLOWER IS NOT PROTECTED FROM THE ENVIRONMENT AND MOISTURE CAN EINTER BEARING EASILY. REPLACED CAM FOLLOWERS. (X)SDR AC2A0000077Exhaust Pipe · crackedENGINE EXHAUST DUCT FOUND CRACKED IN THE REAR AREA NEAR CENTER BOTTOM. REPLACED ENGINE EXHAUST DUCT. (X)SDR AC2A0000079Strap · debondedRIGHT AFT LANDING GEAR STRAP ASSY HAD RUBBER PAD DEBONDED. REPLACED AFT STRAP ASSY. (X)SDR AC2A0000048Gyro · failedVERTICAL GYRO FAILED AT APPROX 1000 HOURS. PART CAUSED AIRCRAFT AUTOPILOT TO PITCH UP AND ROLL RIGHT WHEN AUTOPILOT ENGAGED. REPLACED VERTICAL GYRO WITH SERVICEABLE VERTICAL GYRO. (X)SDR AC2A0000053Blade · separatedSEPARATION IN THE ROOT CLOSURE. THIS WAS THE ORIGINAL TAIL ROTOR BLADE RECEIVED WITH THIS AIRCRAFT. IT WAS REMOVED THE FIRST TIME AT AIRCRAFT TT: 589.4 HOURS FOR BEARINGS CRACKED. REPLACED TAIL ROTOR BLADE ASSY WITH SERVICEABLE PART. (X)SDR AC2A0000039Arm · brokenWINDSHIELD WIPER GUIDE ARM BROKEN AT ATTACHMENT POINT. REPLACED GUIDE ARM. (X)SDR AC2A0000026Seat Belt · frayedSHOULDER STRAPS FRAYED AT KEEPER ON TOP OF SEAT. REPLACED RESTRAINT ASSY. SMOOTHED EDGES OF KEEPER. (X)SDR AC2A0000035Life Raft · will not testJETTISONABLE LIFE RAFT WOULD NOT PASS 25 POUND PULL TEST FOR DEPLOYMENT. FOUND TORSION SPRING BHL/COMP.1728-201 INSTALLED TOO TIGHT AND WASHERS ADDED TO RELEASE HANDLE AT PIVOT POINT WHICH ARE NOT CALLED OUT IN THE PARTS MANUAL OR MM. ADJUSTED SPRING AND REMSDR AC2A0000029Bearing · wornBEARING BEYOND LIMITS. REPLACED ROD END. (X)SDR AC2A0000025Bearing · crackedALL FEATHERING BEARINGS CRACKED. REPLACED TAIL ROTOR HUB AND BLADE ASSY WITH CHEVRON OWNED TAIL ROTOR AND HUB SPARE. (X)SDR AC2A0000018Sleeve · scoredSCORING AT THE SEALING SURFACE. REPLACED WITH NEW PART. (X)SDR AC2A0000023Plate · chafedSHEAR RESTRAINT CAME UNBONDED AND WORKED AGAINST CLAMP PLATE. REPLACED CLAMP PLATE ASSY. (X)SDR AC2A0000022Retainer · looseSHEAR RESTRAINT CAME LOOSE AT PIN. REPLACED RESTRAINT. (X)SDR AC2A0000024Display · failedDISPLAY SLOWLY BECAME DIM, THEN WOULD NOT DISPLAY. REPLACED EFIS DISPLAY. (X)SDR AC2A0000030Link · wornWORN LINKS. REPLACED LINKS. (X)SDR AC2A0000042Tube · chafedTUBE WAS CHAFED BY ENGINE COWLING. REPLACED TUBE. (X)SDR AC2A0000028Bearing · wornBEARING WORN BEYOND LIMITS. REPLACED ROD END. (X)SDR AC2A0000006Gear · shiftedSEARCH LIGHT FAILS TO EXTEND FULLY (GEAR ON MOTOR SHIFTED CAUSING BIND AGAINST CASE). (X)SDR AC2A0000008Bushing · frozenLOWER AFT MOUNT FOR TAIL ROTOR GUARD LOOSE (BUSHING FROZEN ON BOLT CAUSING WEAR AD PLAY). (X)SDR AC2A0000033Disc Pack · corrodedTHE THOMAS COUPLING WAS CORRODED AND PITTED BEYOND LIMITS. REPLACED. (X)SDR AC2A0000032Disc Pack · mismanufacturedNEW PART WHEN TORQUEING THE BOLTS ON THE THOMAS COUPLING, THE DISC WOULD SPREAD. REPLACED. (X)SDR 99ZZZX3216Shaft · corrodedMAIN DRIVE SHAFT DUE 12-MONTH INSPECTION AND REPACK. DISASSEMBLED, INSPECTED. FOUND CORRODED ON COUPLINGS AND GEARS.SDR 99ZZZX3215Shaft · corrodedMAIN DRIVE SHAFT 12-MONTH INSPECTION AND REPACK. DISASSEMBLED, FOUND RUSTED AND PITTED ON COUPLINGS AND GEARS.SDR 99ZZZX2810Adc · disonnectedAFTER 300-HOUR INSPECTION ON AIRCRAFT, TEMPERATURE SENSOR CONNECTION WAS LEFT DISCONNECTED. THIS CAUSES KDC481T TO GO TO A DEFAULT MODE AND LIMIT IAS FUNCTION TO 88 KNOTS. NO ERROR CODES WERE GIVEN EXCEPT VMO LIMIT. KDC481T WAS REPLACED TWICE BEFORE LOOSE CSDR 99ZZZX3248Bearing · failedBEARING CAUSING CHIP LIGHT.SDR 99ZZZX3373Crosstube · corrodedCORROSION NEAR RIGHT SADDLE INBOARD BOTTOM SIDE.SDR 99ZZZX3454Filter · cloggedFILTERS CHANGED FOR BYPASS BUTTON ACTIVATION IN 100 HOURS.SDR 99ZZZX3367Display · malfunctionedNO NR 2 HYDRAULIC SYSTEM PRESSURE SHOWING. NO CARROT INDICATION.SDR 99ZZZX3259Blade · crackedOUTBOARD TRIM TAB CRACKED.SDR 99ZZZX3258Blade · crackedOUTBOARD TRIM TAB CRACKED.SDR 99ZZZX3257Blade · crackedOUTBOARD TRIM TAB CRACKED.SDR 99ZZZX3256Blade · crackedOUTBOARD TRIM TAB CRACKED.SDR 99ZZZX3253Cover · crackedROTOR BRAKE COVER CRACKED. REPLACED COVER.SDR 99ZZZX3251Lock Ring · missingLOCK RING MISSING FROM BOLT. REPLACED BOLT.SDR 99ZZZX3252Battery · dischargedBATTERY FAILED FUNCTIONAL CHECK. REPLACED BATTERY.SDR 99ZZZX3247Coupling · corrodedCORROSION UNDER PRIMER ON TRANSMISSION END.SDR 99ZZZX3246Coupling · corrodedCORROSION UNDER PRIMER AND ON SPLINES.SDR 99ZZZX3245Coupling · corrodedCORROSION UNDER PRIMER. TRANSMISSION END OF SHAFT HAD CORROSION. ENGINE END WITH NO PRIMER DID NOT HAVE CORROSION.SDR 99ZZZX3222Bearing · roughTAIL ROTOR FEATHERING BEARINGS CRACKED ON BOTH TAIL ROTOR BLADES AND TAIL ROTOR TRUNNION BEARINGS ROUGH. RE: CHEVRON S/O NR 526657PNAV.SDR 99ZZZX3221Bearing · crackedTAIL ROTOR FEATHERING BEARINGS CRACKED ON BOTH TAIL ROTOR BLADES AND TAIL ROTOR TRUNNION BEARINGS ROUGH. RE: CHEVRON S/O NR 526657PNAV.
Back to N430CH, cancelled Mar 13, 2012