Boeing DHC-8-102
Service difficulty reports · 9,272
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = 'DHC8102' 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 aircraft_model_key = 'DHC8102' 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 CA991208014Brake Assy · vibration(CAN) DURING TAXI ,THE AIRCRAFT EXPERIENCED SEVERE VIBRATION DURING BRAKING. MAINTENANCE REPLACED THE NR 4 BRAKE ASSY.SDR QXEA9902345Switch · malfunctionedPDX- FLIGHT ATTENDANTS LIGHTING PANEL EMERGENCY LIGHT SWITCH INTERMITTANT. REMOVED AND REPLACED LIGHT SWITCH, OPERATIONAL CHECK GOOD.SDR CA991208013Wire · chafed(CAN) DURING PRE-FLIGHT, IT WAS DISCOVERED THAT THE PORT NAV LIGHTS WERE NOT ILLUMINATING. THE PROBLEM WAS TRACED TO AN OPEN CIRCUIT IN THE NAV LIGHT WIRING IN THE PORT WING LEADING EDGE. THE WIRE APPEARED TO HAVE CHAFED THE EDGE OFTHE WIRE CONDUIT WHERE IT SDR CA991209015Wire · chafed(CAN) DURING CLIMB, THE CREW NOTICED THE FUEL PRESSURE WARNING LIGHT FLICKER. THE BOOST PUMP WAS TURNED ON AND HAD NO EFFECT ON THE WARNING LIGHT. THE FLIGHT RETURNED TO THE AIRPORT FOR LANDING. MAINTENANCE FOUND A CHAFING/SHORTING WIRE IN THE FUEL PRESSURESDR CA991208006Ac Generator · failed(CAN) THE FLIGHT CREW REPORTED THE NR 2 AC GENERATOR FAILED AND WOULD NOT RESET. MAINTENANCE REPLACED THE NR 2 AC GENERATOR.SDR CA991209056Bolt · failed(CAN) DURING TAXI, LOUD NOISE WAS HEARD, FOLLOWED BY A LOSS OF NR 2 SYSTEM HYDRAULIC PRESSURE. MAINTENANCE FOUND 2 FAILED BOLTS ON THE STEERING MANIFOLD COMPENSATOR CAP.SDR CA991208024Pipe · contaminated(CAN) THE FLIGHT CREW COMPLAINED OF FEELING LIGHT HEADED WITH ASSOCIATED HEADACHES. MAINTENANCE DETERMINED THE SMELL TO BE COMING FROM THE BLEED AIR SYSTEM. A NEW BLEED AIR PIPE WAS INSTALLED THE PREVIOUS NIGHT. SUBMITTER FELT THE PIPE MAY HAVE BEEN TREATEDSDR CA991208007Gearbox · contaminated(CAN) RGB CHIP FLAGGED. MATERIAL WAS BEARING DEBRIS. BEARING PART NUMBER NOT SPECIFIED.SDR CA991208032Wire · broken(CAN) DURING TAXI, THE NR 1 ROLL SPOILER PUSH-OFF LIGHT ILLUMINATED. MAINTENANCE FOUND AND REPAIRED A BROKEN WIRE AT THE RIGHT ROLL SPOILER CLUTCH MICROSWITCH. THE SUBMITTER STATES THAT DEHAVILLAND HAS ISSUED ASYD TO ADDRESS THIS ISSUE, WHICH THE SUBMITTER SSDR CA991208012Generator · overheat(CAN) DURING FLIGHT, THE CREW GOT A 'NR 2 GEN HOT' LIGHT AND SELECTED THE GENERATOR OFF. MAINTENANCE REPLACED THE STARTER/GENERATOR.SDR CA991209053Line · leaking(CAN) DURING TAXI, HYDRAULIC FLUID WAS SEEN LEAKING FROM THE RIGHT ENGINE NACELLE AREA. MAINTENANCE FOUND A LEAK IN THE HYDRAULIC LINE FOR THE NR 2 SPOILER UNLOADING VALVE.SDR CA991208023Cable · damaged(CAN) DURING SCHEDULED MAINTENANCE, THE CONDITION LEVER CABLE WAS FOUND WORN TO SERVICE LIMITS WHERE IT RIDES ON THE STEEL PULLEY FORWARD OF THE FIREWALL.SDR CA991208011Timer · failed(CAN) FLIGHT CREW REPORTED THAT THE DEICE BOOTS WOULD NOT DEFLATE AFTER THE INFLATION CYCLE. MAINTENANCE REPLACED THE DEICE TIMER.SDR CA991209055Hose · leaking(CAN) DURING PRE-FLIGHT INSPECTION, OIL WAS NOTICED DRIPPING FROM THE NR 2 ENGINE LOWER COWLING. MAINTENANCE FOUND THE OIL SUPPLY HOSE BETWEEN THE OIL FILTER HOUSING AND THE OIL COOLER WAS LEAKING.SDR CA991209052Actuator · leaking(CAN) AFTER TAKEOFF, SUBSTANTIAL RIGHT AILERON INPUT WAS REQUIRED TO KEEP THE AIRCRAFT LEVEL. MAINTENANCE FOUND THE RIGHT HAND SPOILER ACTUATOR TO HAVE AN INTERNAL LEAK. THE SPOILER ACTUATOR WAS REPLACED AND A TEST FLIGHT WAS CARRIED OUT.SDR CA991208005Fuel Valve · leaking(CAN) DURING SCHEDULED MAINTENANCE, FUEL WAS OBSERVED DRIPPING FROM THE FUEL-DEFUEL VALVE SCUPPER DRAIN LINE. THE VALVE WAS REPLACED.SDR CA991208009Seal · leaking(CAN) DURING SCHEDULED MAINTENANCE, THE NR 2 BRAKE WAS FOUND TO BE LEAKING. THE PROBLEM WAS TRACED TO A DAMAGED BACK-UP RING ON A BRAKE PISTON.SDR CA991208031Fcu · failed(CAN) TORQUE ROLLBACK WITH LARGE WF FLUCTUATIONS EXPERIENCED, MANUAL MODE SELECTED WHICH REDUCED FLUCTUATIONS. HMU AND EEC INSPECTED AND FOUND FAILED.SDR QXEA9902265Fairing · delaminatedPDX - THERE ARE NUMEROUS DELAMINATED AREAS ON COMPOSITE AERODYNAMIC FAIRING AROUND ACCESS PANEL 261AT. REPAIRED IAW HORIZON AIR EA 9-53-492, STEPS 13-20, AND SRM 51-40-11.SDR CA991208030Seal · leaking(CAN) THE CREW REPORTED A LOUD SQUEAL COMING FROM THE PASSENGER DOOR DURING DESCENT. MAINTENANCE FOUND THE INFLATABLE DOOR SEAL TO BE LEAKING.SDR CA991208008Receptacle · failed(CAN) WHILE REPLACING A CABIN OVERHEAD LIGHT, MAINTENANCE FOUND THE AFT TUBE RECEPTACLE TO BE BURNT. THE ENTIRE FIXTURE WAS REPLACED.SDR CA991230033Outflow Valve · failed(CAN) WHILE IN CRUISE FLIGHT, THE AIRCRAFT DEPRESSURIZED. MAINTENANCE REPLACED THE OUTFLOW VALVE.SDR QXEA9902271Support · corrodedPDX - INBOARD AND OUTBOARD FLOOR SUPPORTS FOR WARDROBE ARE CORRODED ALONG UPPER SURFACE. REPAIRED IAW HORIZON AIR EA 9-53-483.SDR CA991208010Generator · failed(CAN) THE NR 2 GENERATOR FAILED AND WOULD NOT RESET. MAINTENANCE REPLACED THE S/G.SDR CA991208004Ecu · failed(CAN) TORQUE AND POWER REDUCTION REPORTED. MANUAL MODE SELECTED AND ENGINE STABILIZED. EEC FAILURE ESTABLISHED.SDR 99ZZZX4531Engine · malfunctionedENGINE REMOVED FROM AIRCRAFT DUE TO VIBRATION AT 1,050 RPM.SDR 99ZZZX4530Engine · malfunctionedENGINE REMOVED FROM AIRCRAFT DUE TO MODERATE VIBRATION AT 1,050 RPM, SLIGHT AT 900 RPM.SDR 99ZZZX4529Engine · malfunctionedENGINE REMOVED FROM AIRCRAFT DUE TO MODERATE VIBRATION AT 900 RPM.SDR QXEA9902300Seat Track · corrodedPDX - LEFT INBOARD CABIN SEAT TRACK AT FUSELAGE STATION 597.500 HAS CORROSION ON TOP SURFACE. REPAIRED IAW DHC-8 SRM 51-40-00.SDR QXEA9902270Seat Track · corrodedPDX - NUMEROUS CORROSION DISCREPANCIES ON LEFT INBOARD CENTER SEAT TRACK. REPAIRED IAW DHC-8 SRM 51-40-00.SDR AU991061Hose · failed(AUS) FLEXIBLE HYDRAULIC HOSE FAILED. LOSS OF NR 2 HYDRAULIC SYSTEM FLUID.SDR QXEA9902249Frame · damagedPDX - FORWARD SIDE OF OUTBOARD MAIN LANDING GEAR FRAME, TWO DRILL MARKS, JUST AFT OF ENGINE BAY FIREWALL. REPAIRED IAW HORIZON AIR EA 9-54-221.SDR QXEA9902234Angle · damagedPDX - ANGLE ATTACHMENT FOR OUTBOARD NACELLE SKIN TO WIG BOX, TO FROM MAIN LANDING GEAR FRAME. REPAIRED IAW HORIZON AIR EA 9-53-485.SDR QXEA9902296Channel · corrodedPDX - RIGHT FORWARD DRAIN CHANNEL ATTACHED TO RIGHT INBOARD CABIN SEAT TRACK HAS FRETTING CORROSION AND IS CRACKED AROUND FORWARD ATTACH RIVET HOLES AT STATION 182.000. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902276Frame · corrodedPDX - FORWARD SIDE OF FRAME 510.00 HAS CORROSION AT OUTBOARD SIDE OF STRINGER 31S. REPAIRED IAW HORIZON AIR EA 9-53-490.SDR QXEA9902275Structure · corrodedPDX - THERE IS CORROSION ON SKIN AND FRAME FORWARD OF 531.500 AT STRINGER 31S. REPAIRED IAW HORIZON AIR EA 9-53-489 AND DHC-8 SRM 51-40-11.SDR QXEA9902250Firewall · crackedPDX - THERE IS A CRACK IN THE AFT FIREWALL OF THE NR 2 ENGINE, OUTBOARD SIDE, AT BEND IN MATERIAL JUST ABOVE FIRE DETECTION LOOP BRACKET. REPAIRED IAW HORIZON AIR EA 9-54-219 AND RD 8-54-430.SDR HNAA9900140Smoke Detector · malfunctionedBAGGAGE SMOKE WARNING LIGHT ILLUMINATED INFLIGHT AND EXTINGISHED ON LANDING. COULD NOT DUPLICATE PROBLEM ON GROUND. REMOVED AND REPLACED NUMBER 1 SMOKE DETECTOR, OPS CHECK GOOD.SDR QXEA9902280Frame · corrodedPDX - FORWARD SIDE OF FRAME 467 HAS CORROSION AT STRINGER 31S. REPAIRED IAW HORIZON AIR EA 9-53-488.SDR QXEA9902279Frame · corrodedPDX - FORWARD SIDE OF FRAME 488.5 IS CORRODED AT STRINGER 341S. REPAIRED IAW HORIZON AIR EA 9-53-487.SDR QXEA9902274Frame · corrodedPDX - FRAME 545.00 HAS CORROSION ON FORWARD SIDE JUST OUTBOARD OF STRINGER 31S. REPAIRED IAW HORIZON AIR EA 9-53-486 AND DHC-8 SRM 51-40-11.SDR QXEA9902273Frame · corrodedPDX - FRAME 531.5 HAS CORROSION ON AFT SIDE JUST OUTBOARD OF STRINGER 31S. REPAIRED IAW HORIZON AIR EA 9-53-489 AND DHC-8 SRM 51-40-11.SDR QXEA9902272Frame · corrodedPDX - CORROSION ON FORWARD SIDE OF FRAME 4885 FROM STRINGER 32P TO STRINGER 32S. REPAIRED IAW HORIZON AIR EA 9-53-487.SDR QXEA9902255Skin · dentedPDX - DENT ON INBOARD SIDE OF LEFT NACELLE AT APPROXIMATELY XN 155.30 AND ZN 24.25. REPAIRED IAW SRM 54.30.21, PAGE 2, FIGURE 2.SDR QXEA9902267Seat Rack · corodedPDX - NUMEROUS CORROSION DISCREPANCIES ON LEFT INBOARD FORWARD SEAT TRACK. REPAIRED IAW DHC-8 SRM 51-40-00.SDR CA991112033Actuator · leaking(CAN) PROPELLER ACTUATOR LEAK INVESTIGATED AND REVEALED CHROME PLATING ON THE INSIDE OF THE DOME HAD PEELED BACK APPROXIMATELY .75 INCH IN LENGTH AND .1685 INCH IN WIDTH. THIS DAMAGED O-RING, CAUSED DOME TO PRESSURIZE.SDR AU991051Antenna · failed(AUS) WEATHER RADAR ANTENNA FAILED.SDR HNAA9900139Bulb · failedFIRST 2 RED FLOOR PATH LIGHTS INOP. REMOVED AND REPLACED BULBS AND BATTERY, NO HELP. REMOVED AND REPLACED BASE ASSY.SDR CA991112011Line · leaking(CAN) HYDRAULIC FLUID FOUND LEAKING FROM A PIN HOLE IN THE LINE TO THE NOSE GEAR DOOR ACTUATOR.SDR QXEA9902282Support · failedPDX - THE VERTICAL FLOOR SUPPORT WEB AT Y9.250 RIGHT IS BUCKLED APPROXIMATELY .090 AT THE TOP JUST AFT OF X601 TO ABOUT X611. REPAIRED IAW HORIZON AIR EA 9-53-478.
Back to Boeing DHC-8-102