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 QXEA0100072Skin · chafedPDX- LEFT WING OUTBOARD FLAP CHAFED ON UPPER SURFACE. REPAIRED IAW DHC-8 SRM 51-20-50 AND SRM 51-20-11, PAGE 6.SDR QXEA0100067Plate · scratchedPDX- LADDER PLATE SCRATCHED, PANEL 524BT CENTER AFT LADDER PLATE. REPAIRED IAW DHC-8 SRM 51-20-16 AND RD8-57-633.SDR QXEA0100066Plate · corrodedPDX- LADDER PLATE HAS PITTING, PANEL 524BT, AFT INBOARD CORNER. REPAIRED IAW DHC-8 SRM 51-20-16 AND RD8-57-633, PAGE 3.SDR QXEA0100058Floor Panel · corrodedPDX- MAIN CABIN DOORWAY FLOOR PANEL APERTURE FOR PANEL 131DZ HAS CORROSION ON 5 NUT PLATES AND SUROUNDING AREAS OF EACH NUT PLATE. REPAIRED IAW DHC-8 SRM 51-20-16.SDR QXEA0100053Frame · corrodedPDX- LIGHT CORROSION ON FRAME X510.000 BETWEEN STRINGER 31 AND 30. LOCATED ON FRAME FLANGE AROUND FUSELAGE RIVETS. REPAIRED IAW DHC-8 SRM 51-20-16.SDR QXEA0100050Seat Track · corrodedPDX- CORROSION UNDER BOLTHEAD ON STRAP ON INBOARD SIDE OF SEAT TRACK AT STATION X597.5 AND STRINGER 31L. REPAIRED IAW DHC-8 20-14-01 AND SRM 51-20-16, AND SRM 51-20-26.SDR AU010131Pseu · faulty(AUS) LANDING GEAR PROXIMITY SWITCH ELECTRONIC UNIT (PSEU) FAULTY.SDR AU010016Pseu · faulty(AUS) PROXIMITY SENSE ELECTRICAL UNIT (PSEU) FAULTY.SDR QXEA0100034Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS PITTING ON TOP SIDE AT STATION X264.100. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100015Controller · will not testLWS - AUTOFEATHER WILL NOT TEST. CYCLED POWER LEVERS AND CONDITION LEVERS FULL TRAVEL NUMEROUS TIMES. TEST NORMAL. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR QXEA0100041Seat Track · scratchedPDX-RIGHT HAND OUTBOARD SEAT TRACK HAS A SCRATCH AT STATION X501.000. REPAIRED IAW DHC-8 SRM 51-20-41 AND RD8-53-1342.SDR QXEA0100040Seat Track · corrodedPDX- RIGHT HAND OUTBOARD SEAT TRACK HAS PITTING AT STATION X490.500. REPAIRED IAW DHC-8 SRM 51-20-41 AND RD8-53-1342.SDR QXEA0100037Seat Track · corrodedPDX- RIGHT HAND OUTBOARD SEAT TRACK HAS PITTING AT STATION X310.350. REPAIRED IAW DHC-8 SRM 51-20-41 AND RD8-53-1342.SDR QXEA0100014Light · inoperativePDX - FLIGHT COMPARTMENT OVERHEAD EMERGENCY LIGHT WILL NOT TEST. REMOVED AND REPLACED OVERHEAD EXIT LIGHT. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR PCAA0101002Bulb · failedBGM FLIGHT 3555. ROW 1 RIGHT SIDE EMERGENCY LIGHT INOP ONE BULB. MAINTENANCE REPAIRED WIRING ON FLOOR EMERGENCY LIGHTS. AIRCRAFT RETURNED TO SERVICE.SDR PCAA0108103Rivet · looseDURING FLEET INSPECTION FOR NACELLE RIVETS BEING LOOSE AND MISSING, 2 RIVETS ON RIGHT NACELLE OUTBOARD END FOUND LOOSE JUST BELOW FLAP TRACK. LOOSE RIVETS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR 20010214SG006Light · inoperativeDURING A-CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLAED L1 EMERGENCY LIGHT IAW MM 33-50-22. OPS CHECK GOOD. (M)SDR CA010125009Line · leaking(CAN) INVESTIGATION OF A HYDRAULIC LEAK IN THE NOSE OF THE AIRCRAFT REVEALED A LARGE PINHOLE IN THE LINE FROM THE TEE AT STN X37.00 TO THE STEERING CONTROL GEAR UP. THE LINE WAS REPLACED AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR CA010126005Relay · stuck(CAN) THE FLIGHT CREW REPORTED THAT THE RT PROPELLER HEAT B PHASE WAS STUCK IN THE ON POSITION. THIS WAS CONFIRMED WITH THE LOADMETER. THEY PULLED THE CB TO DEACTIVATE THE SYSTEM. MAINTENANCE INVESTIGATION RESULTED IN REPLACEMENT OF PROP HEAT RELAY 3061-K4 WHISDR CA010126004Pin · damaged(CAN) THE FLIGHT CREW REPORTED AND UNSAFE GEAR LIGHT WITH NO NOSE GEAR GREEN INDICATION AFTER LANDING GEAR DOWN SELECTION. AN ALTERNATE EXTENSION WAS PERFORMED AND THE AIRCRAFT LANDED UNEVENTFULLY. MAINTENANCE INVESTIGATION REVEALED THAT A CONNECTOR PLUG FROM SDR CA010108014Line · leaking(CAN) THE FLIGHT CREW REPORTED LOW FLUID LEVEL IN NR 2 HYDRAULIC SYSTEM DURING DESCENT. THEY LANDED UNEVENTFULLY. MAINTENANCE INVESTIGATION RESULTED IN REPLACEMENT OF THE NOSE LANDING GEAR DRAG STRUT ACTUATOR FLEX LINE WHICH WAS LEAKING AT THE BASE OF THE STRASDR QXEA0100008Inverter · malfunctionedPDX- STRONG FISH SMELL EMINATING FROM LEFT SIDE BY AVIONICS RACK. REMOVED AND REPLACED PRIMARY INVERTER. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR PCAA0201006Jumper · brokenDURING ROUTINE MAINTENANCE VISIT, EMERGENCY FLOOR LIGHTING FOUND TO HAVE AN INOPERATIVE SEGMENT. ONE BROKEN JUMPER REPLACED, ANOTHER JUMPER WAS RESECURED. ALSO, CLEAR LENS COVER REPLACED. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR PCAA0201005Windshield · crackedBUF-BDL FLIGHT#3585. CREW REPORTED CAPTAINS FRONT WINDSHIELD CRACKED ON TO LEFT CORNER ON CLIMBOUT. MAINTENANCE REPLACED CAPTAINS WINDSHIELD IN ACCORDANCE WITH DASH 8 MAINTENANCE MANUAL 56-10. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR AU010032Connector · damaged(AUS) LIQUID HEATER CONNECTORS DAMAGED DUE TO OVERHEATING.SDR AU010031Connector · damaged(AUS) LIQUID HEATER CONNECTORS DAMAGED DUE TO OVERHEATING.SDR CA010108013Light · overheated(CAN) DURING ROUTINE MAINTENANCE TO REPLACE AN INOPERATIVE SIDEWALL LIGHT, THE FORWARD RECEPTACLE SHOWED SIGNS OF OVERHEATING. THE COMPLETE LIGHT FIXTURE WAS REPLACED. FURTHER INSPECTION OF THE FIXTURE REVEALED THAT BRUCE INDUSTRIES SL-BC5-0618-901-33-01 HAD BSDR PCAA0201004Battery Pack · inoperativeDURING ROUTINE MAINTENANCE VISIT ALL EMERGENCY EXIT AND FLOOR LIGHTS FOUND TO BE INOPERATIVE. BLOWN FUSES FOUND IN AFT BATTERY PACK. AFTER FUSES WERE REPLACED IT WAS DISCOVERED BATTERY PACK WAS BAD. AFT BATTERY PACK REPLACED. OPERATIONAL CHECK GOOD. AIRCRAFT RSDR CA010129003Fitting · leaking(CAN) ON JAN 02/2001 CREW OF A/C C-GTAF, S/N 087 ABORTED ITS TAKEOFF OUT OF GRAND PRAIRE (YQU) DUE TO ILLUMINATED OF NR 2 OIL PRESSURE LIGHT DURING TAKEOFF ROLL. A/C RETURNED TO GATE WITH NO FURTHER INCID. TO RPT. CRA CONTRA CTED ENGINEER FROM SWAN AERO 2000 TSDR QXEA0100002Power Supply · inoperativePDX - FOUND LEFT HAND SIDE EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR CA010130012Windshield · failed(CAN) LEFT WINDSHIELD SHATTERED INFLIGHT. AIRCRAFT LANDED. WINDSHIELD REPLACED IN ACCORDANCE WITH DHC8 MM 56-10-11. RAN AIRCRAFT OPERATIONS CHECKED, OK. AIRCRAFT RETURNED TO SERVICE. NOTE PCA A0101001SDR PCAA0101001Windshield · failedLGA-ALB FLIGHT 3551. LEFT WINDSCREEN SHATTERED IN FLIGHT. AIRCRAFT LANDED IN ALB. MAINTENANCE REPLACED CAPTAINS WINDSHIELD AND 15 NUTPLATES ALONG BOTTOM OF WINDOW SILL IN ACCORDANCE WITH DEHAVILLAND DASH 8 MAINTENANCE MANUAL 56-10-11, RAN AIRCRAFT, OPERATIONALSDR AU001239Line · split(AUS) HYDRAULIC LINE SPLIT AND LEAKING.SDR HNAA0100002Panel · damagedFOUND LEFT WING PANEL 622AT LADDER PLATE CRACKED AT OUTBOARD AFT RADIUS. CRACK WAS 0.3 INCH LONG. REPAIRED I/A/W PIEDMONT EO8-57-00-1012.SDR HNAA0100001Panel · damagedFOUND LEFT WING PANEL 522 AT LADDER PLATE CRACKED AT OUTBOARD AFT CORNER. CRACK WAS 0.3 INCH LONG. REPAIRED I/A/W PIEDMONT EO8-57-00-1009.SDR AU001257Structure · damaged(AUS) AIRSTAIR COMPONENTS BROKEN AND BADLY WORN. MAIN CABIN DOOR COULD NOT BE OPENED.SDR CA010108003Rod End · deteriorated(CAN) DURING INSPECTION, THE NLG DRAG STRUT ACTUATOR ROD END BEARING WAS FOUND TO HAVE EXCESSIVE PLAY. THE SPHERICAL BEARING P/N 8418-1 ON ROD END P/N 8411-3 IS FITTED WITH A FIBER (NO LUBRICATION REQUIRED) TYPE OF BUSHING ON THE INNER BORE OF THE BEARING. THISDR AU001211Bearing · galled(AUS) PROPELLER HUB BLADE RETAINING BEARING OUTER RACE GALLED. FOUND DURING SCHEDULED BLADE CHANGE.SDR QXEA0003273Pseu · malfunctionedSEA- GEAR BROUGHT UP DURING DEPARTURE AND A LOUD RATTLE NOISE WAS HEARD IN THE COCKPIT. RED CAUTION LIGHT ON LEFT GEAR SELECTOR ILLUMINATED AND YELLOW CAUTION LIGHT ON NOSE DOOR AND RIGHT DOOR ILLUMINATED. FLIGHT ATTENDANT OBSERVED ALL THREE DOORS DOWN ON LEFTSDR HNAA0000083Control Unit · smokeWHEN GROUND POWER WAS APPLIED TO THE AIRCRAFT SMOKE AND SPARKS CAME FROM THE F/O'S SIDE OF THE CENTER CONSOLE. REPLACED THE NR 2 TRANSPONDER CONTROL HEAD.SDR HNAA0000082Control Unit · smokeWHEN GROUND POWER WAS APPLIED TO THE AIRCRAFT SMOKE AND SPARKS CAME FROM THE F/O'S SIDE OF THE CENTER CONSOLE. REPLACED THE NO. 2 COMM CONTROL HEAD.SDR 20010119SG005Indicator · inoperativeABORTED TAKEOFF ON TAKEOFF ROLL, AT 100 KIAS ON CAPTAINS INDICATOR, F/O''S AIRSPEED INDICATED ''O'' KIAS. REPLACED F/O''S MACH AIRSPEED INDICATOR AND TWO O-RINGS. NOW TESTS NORMAL WITH PITOT/STATIC TESTER IAW MM 34-12-21. (M)SDR 20010119SG004Static Line · looseAIR TURNBACK, FLIGHT OFFICERS AIRSPEED INDICATOR INOPERTIVE. STAYED WELL BELOW CAPTAINS AIRSPEED AFTER TAKEOFF. FOUND STATIC F/O''S LINE LOOSE AT T-CONNECTION. REATTACHED AS REQUIRED AND OPS CHECK OK IAW MM 34-10-00. (M)SDR PCAA0012084Signal Cond Unit · faultyFLIGHT 3795 PHL-ROC. AT FL180, NR 2 ENGINE TORQUE DROPPED TO 7.1 PERCENT. CAPTAIN PERFORMED PRECAUTIONARY ENGINE SHUTDOWN AND DIVERTED TO BGM WITHOUT FURTHUR INCIDENT. EMERGENCY DECLARED. MAINTENANCE REPLACED NR 2 ENGINE TORQUE GAUGE AND NR 2 TORQUE SIGNAL CSDR CA010108006Line · leaking(CAN) THE FLIGHT CREW OBSERVED A HYDRAULIC LEAK FROM THE NR 2 ENGINE DURING PREFLIGHT WALKAROUND. MAINTENANCE INVESTIGATION RESULTED IN THE REPLACEMENT OF A HYDRAULIC PRESSURE LINE IN THE ENGINE COMPARTMENT. THE LINE HAD A PINHOLE IN A FACTORY WELD.SDR PCAA0012083Windshield · crackedBOS-FLIGHT 3789.CREW DISCOVERED FIRST OFFICERS WINDSHIELD CRACKED. MAINTENANCE REMOVED AND REPLACED FIRST OFFICERS WINDSHIELD IN ACCORDANCE WITH DEHAVILLAND DASH 8 MAINTENANCE MANUAL AND ALLEGHENY JOBCARD.OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR HNAA0000081Inverter · overheatedCREW REPORTED AN ELECTRICAL BURNING SMELL IN THE COCKPIT. REPLACED THE SECONDARY INVERTER.SDR CA010108005Shutoff Valve · leaking(CAN) INVESTIGATION OF A FUEL LEAK IN THE AFT OF NR 2 NACELLE RESULTED IN THE REPLACEMENT OF THE MASTER REFUEL/DEFUEL SHUTOFF VALVE ASSEMBLY WHICH WAS FOUND TO BE LEAKING FROM THE THERMAL RELIEF VALVE.SDR CA010103006Bearing · disintegrated(CAN) PILOT REPORTED TO MAINTENANCE THAT ENGING NR1 START HOT. MAINTENANCE CREW INVESTIGATE AND DURING ENGINE RUN NR1 DC GENERATOR CAUTION LIGHT ILLUMINATE. THEY REPLACED THE NR1 DC STARTER/GEN AND AFTER VISUAL INSPECTION ON THE UNSERVICEABLE PARTS THEY FOUND SDR CA001221006Guard · crushed(CAN) AFTER TAKEOFF ON GEAR RETRACTION THREE CAUTION LIGHTS AND ARIGHT MAIN GROUND WARNING LIGHT ON. MOTORING SOUND HEARD AND GEAR WOULD NOT RETRACT. IN TRANSIT LIGHT ON IN GEAR RETRACT LEVER, MAINTENANCE INSPECTION FOUND RIGHT HAND NACELLE AFT ACCESS PANEL CR
Back to Boeing DHC-8-102