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 QXEA9802112Light · inopSEA - ESCAPE PATH LIGHTING AT ROW 3E INOP. MAINTENANCE PLACED ON MEL 33-13. AIRCRAFT RETURNED TO SERVICE.SDR CA990111033Strut · gouged(CAN) THE CARGO DOOR UPPER AFT STRUT FOUND GOUGED BELOW THE ADJUSTABLE ROD END. SUSPECT INCORRECT BOLT INSTALLATION CAUSING NUT SIDE OF BOLT TO GOUGE INTO THE STRUT ASSY. CLEARANCE ACHIEVED BY REVERSING THE INSTALLATION OF INBOARD BOLT WHEN CARGO DOOR IS CSDR HNAA9892794Skin · corrodedUNDER COCKPIT FLOOR MINOR SURFACE CORROSION TO THE SKIN ADJACENT TO STRINGER 31 RT, .020 DEPTH CORROSION TO THE SKIN APPROXIMATELY 3 INCHES LONG AT STRINGER 32 RT. STRINGER 31 RT BETWEEN STATION 167.00 AND STATION 182.00 CORRODED APPROXIMATELY 11 INCHES EXCEESDR CA990111032Line · cracked(CAN) LOST 2 LITRE HYDRAULIC FLUID IN-FLIIGHT FROM NR 2 SYSTEM. LINE FOUND LEAKING. REF IPC 29-10-00, FIGURE 30, ITEM 345.SDR CA990111031Handle · broken(CAN) FOUND CARGO DOOR HANDLE 'OPEN' STOP SHEARED IN HALF AT INNER MOUNT HOLE. STOP REPLACED AND ADJUSTED.SDR QXEA9802107Battery · dischargedEMERGENCY LIGHTS INOP. REPLACED BATTERY PACKS, OPERATIONAL CHECK GOOD.SDR QXEA9900008Hinge · damagedFORE RUDDER TRAILING TOP HINGE FITTING HAS MECHANICAL DAMAGE. REPAIRED IAW DHC-8 SRM 51-20-16 AND 51-20-36.SDR QXEA9900007Hinge · damagedFORE RUDDER TRAILING HINGE, BOTTOM FITTING HAS MECHANICAL DAMAGE. REPAIRED IAW DHC -8 SRM 51-20-16 AND 51-20-36.SDR AU981662Bracket · broken(AUS) WING GROUND SPOILER PANEL'S LT OUTBOARD ATTACHMENT BRACKET FOUND BROKEN AT ACTUATOR LINK ATTACHMENT. SUSPECT A POSSIBLE CAUSE OF THE FAILURE WAS DUE TO INCORRECT RIGGING ASSEMBLY AT LAST FITMENT AS THE ACTUATOR ROD END REQUIRED ADJUSTMENT TO RECONNECT TSDR QXEA9900013Skin · dentedDENT BEYOND LIMITS AT X498.737 AND .5 BELOW STATION 21. REPAIRED IAW RD 8-53-3961.SDR AU981665Impeller · damaged(AUS) NR 2 ENGINE LP IMPELLER DAMAGED BY FOD. ALL SIXTEEN VANES WERE DAMAGED WITH 1.58 MM (.0625 INCH) TO 6.35 MM (.25 INCH) CUTS AND DENTS ALONG THE LEADING EDGE. PART TC: 2,305.SDR QXEA9900012Support · corrodedFRETTING CORROSION FOUND ON LEFT SUPPORT FOR PANELS 143AZ AND 143BZ BETWEEN FUSELAGE STATION X424.124 AND X488.500. REPAIRED IAW DHC-8 RD 8-53-3960.SDR QXEA9900006Skin · dentedDENTS FOUND IN OUTER SKIN OF INBOARD NR 2 ENGINE PANEL 425AL. REPAIRED IAW DHC-8 RD 8-71-139.SDR QXEA9900003Door · crackedNR 1 ENGINE COWL DOOR 416AR HAD CRACK. REPAIRED IAW DHC-8 RD 71-142.SDR QXEA9900001Door · damagedMECHANICAL DAMAGE ON CARGO DOOR UNDER MOUNTING AREA FOR UPPER MOST OF REAR VERTICAL EDGE. REPAIRED IAW RD 8-52-368.SDR AU981642Indicator · failed(AUS) CREW REPORTED AN ELECTRICAL SMELL IN THE COCKPIT, CO-INCIDENT WITH CAPTAIN'S RADIO MAGNETIC INDICATOR U/S FLAG AND ADF NR 2 NEEDLE FREEZING AND TRIPPING OF 26VAC ADF NR 2 CIRCUIT BREAKER.SDR AU981641Sheath · cracked(AUS) PROPELLER BLADE (P/N $FA13MIROA+) METAL SHEATH CRACKED ALONG THE LEADING EDGE OF THE BLADE APPROXIMATELY 31.75 MM (1.25 INCHES) IN LENGTH. PART TC: 14,103.SDR QXEA9900011Fitting · wornLOWER LUG OF MIDDLE LOWER RUDDER FITTING ON VERTICAL STABILIZER IS WORN WHERE THE BEARING SITS. REPAIRED IAW RD 55-350.SDR QXEA9802101Wire · brokenSEA - FOUND BROKEN WIRE ON NR 2 SMOKE DETECTOR CANNON PLUG. MAINTENANCE SOLDERED WIRE TO CANNON PLUG. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR QXEA9900004Actuator · chafedLEFT MAIN LANDING GEAR STANDBY ACTUATOR FOUND TO BE CHAFING ON ATTACH POINT FITTING. REPAIRED IAW DHC-8 MM 32-30-16, PAGE 202, PARAGRAPH B.SDR QXEA9900002Actuator · chafedNR 2 MAIN GEAR STANDBY ACTUATOR CHAFING AT ATTACH POINT. REPAIRED IAW RD 8-54-1001 AND DHC -8 MM 32-30-16, PAGE 202, PARAGRAPH B.SDR HNAA9894290Power Supply · inoperativeSBY - FLT 3081 - AFT OVERHEAD EMERGENCY LIGHT INOP. REMOVED AND REPLACED THE POWER SUPPLY AND BASE. (M)SDR CA981230061Bearing · failed(CAN) STARTER/GENERATOR CAUTION LIGHT ON IN CLIMB. REPLACED STARTER/GENERATOR.SDR QXEA9900005Support · gougedNR 1 ENGINE OUTBOARD SUPPORT STRUT HAS GOUGES FROM FIRE DETECTION WIRES IN TWO PLACES. REPAIRED IAW DHC-8 SRM 51-20-16 AND 51-20-36.SDR QXEA9801787Light · inoperativePDX- STRONG ELECTRICAL SMELL NOTED IN THE CABIN. MAINTENANCE ISOLATED TO THE OVERHEAD LIGHT AT SEAT ROW 4DE. REMOVED THE LAMP AND PLACED ON MEL. MEL CLEARED ON 12/8/98 BY REPLACING THE LIGHT TUBE SOCKET WHICH WAS FOUND TO BE MELTED. OPERATIONAL CHECKS GOODSDR CA981214015Bus Bar · loose(CAN) THE LEFT MAIN DISTRIBUTION BUS BAR BECAME LOOSE FROM THE FOUR, 50-AMP CIRCUIT BREAKERS THAT ARE IN THE LEFT COCKPIT CIRCUIT BREAKER PANEL. THIS CONDITION CAUSED THE FOUR 50-AMP CIRCUIT BREAKERS TO OPEN AND THE AIRCRAFT LOST THE LEFT MAIN DC BUS WITH NO SDR QXEA9801786Pseu · malfunctionedRIGHT MAIN GEAR DOOR REMAINED OPEN AFTER GEAR RETRACTION. LIGHT REMAINED ON. AIRCRAFT WAS FERRIED FROM SEA TO PDX FOR REPAIRS. IN PDX MAINTENANCE REPLACED THE PSEU, OPERATIONAL CHECKS GOOD.SDR HNAA9892389Structure · corrodedCORROSION FOUND FUSELAGE FRAMES AT STA X222 BETWEEN STRINGERS 32S AND 32P (FRAME, STRINGER, SKIN AND SEAT RAIL SUPPORT), STA X215 BETWEEN STRINGERS 30S AND 31S (FRAME, SEAT RAIL SUPPORT AND TENSION FITTING), STA X467 BETWEEN STRINGERS 29S, 30S AND 31S RT SIDE,SDR HNAA982389Frame · corrodedSBY - FOUND CORROSION FUSELAGE FRAMES AT STATION X222 BETWEEN STRINGERS 32S AND 32P (FRAME, STRINGER, SKIN AND SEAT RAIL SUPPORT), STATION X215 BETWEEN STRINGERS 30S AND 31S (FRAME, SEAT RAIL SUPPORT AND TENSION FITTING), STATION X467 BETWEEN STRINGERS 29S, 30SDR HNAA9892488Windshield · arcedPHL - FLT 3038 - CAPTAINS WINDSHIELD ARCS AT WINDSHIELD HEAT CONNECTIONS. OPERATED PER MEL 30-10. (M)SDR CA981230059Line · leaking(CAN) LEFT HAND SPOILER LINE REPLACED BECAUSE OF A PIN HOLE. SEE IPC 29-00-00-35-190.SDR QXEA9900010Fitting · chafedMINOR CHAFE DAMAGE ON FORE RUDDER HYDRAULIC DAMPER FITTING. REPAIRED IAW RD 8-55-128.SDR QXEA9900009Fitting · chafedMINOR CHAFE DAMAGE ON UPPER AND LOWER FORE RUDDER ACTUATOR FITTINGS. REPAIRED IAW RD 8-55-128.SDR QXEA9802105Conditioner · malfunctionedMWH - DURING CLIMB-OUT OF MWH, NR 2 ENGINE EXPERIENCED A UNCOMMANDED AUTOFEATHER. FLIGHT CREW SECURED THE ENGINE. AIRCRAFT RETURNED TO MWH WITHOUT INCIDENT. MAINTENANCE REPLACED THE TORQUE SIGNAL CONDITIONER, NR 2 PROPELLER (FOR OVERTORQUE INSPECTION), AND SDR CA990310001Cable · broken(CAN) CREW UNABLE TO OPEN AIRSTAIR DOOR AFTER LANDING. CABLE WRAPPED AROUND THE DRUM PREVENTING DOOR FROM BEING OPENED. CABLE HAD TO BE DISCONNECTED FROM DOOR TO ALLOW IT TO BE OPENED.SDR CA981214016Filter Plug · leaking(CAN) NR 2 ENGINE LOW PRESSURE FUEL FILTER DRAIN PLUG FOUND LEAKING. PLUG WAS FOUND LOOSE EVEN THOUGH IT WAS LOCKED WIRED. PART TC: 3,840.SDR AU981615Impeller · damaged(AUS) DURING ENGINE COMPRESSOR INSPECTION, FOD DAMAGE WAS FOUND ON THE LP IMPELLER BLADES. A BORESCOPE INSPECTION ON THE HP IMPELLER REVEALED DAMAGE THAT WAS OUTSIDE ACCEPTABLE LIMITS. THE ORIGIN OF THE FOD WAS NOT IDENTIFIED.SDR HNAA9893685Skin · crackedORF - NR 1 NACELLE EXHAUST FINGERNAIL IS CRACKED AT THE OUTBOARD FORWARD SIDE SKIN AND HAS SEVERAL LOOSE RIVETS AND MISSING RIVETS AT THE TOP FORWARD SKIN. REPAIRED CRACKED SKIN AND REPLACED RIVETS. (M)SDR HNAA9893084Stop · out of adjustDCA - FLT 3159 - UNABLE TO OPEN PASSENGER DOOR FROM INSIDE. FOUND LOWER DOOR SKIN RUBBING. ADDED SHIMS AND ADJUSTED ALL DOOR STOPS. PRESSURIZED AIRCRAFT. OPERATIONAL AND LEAK CHECK GOOD. (M)SDR QXEA9801784Mechanism · lack of lubeMAIN CABIN DOOR DIFFICULT TO OPEN. MAINTENANCE CLEANED AND LUBRICATED MAIN CABIN DOOR STOPS AND LINKAGE, OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR QXEA9801754Battery · dischargedLEFT FORWARD FUSELAGE EMERGENCY LIGHT INOP. REPLACED BATTERY FOR EMERGENCY LIGHTING, OPERATION CHECK GOOD.SDR HNAA9893786Frame · crackedSBY - NR 2 NACELLE OUTBOARD MAIN OUTBOARD MAIN FRAME 'Z' MEMBER CRACKED AT UPPER END. STOP DRILLED CRACK AND INSTALLED RIVETS THROUGH 'Z' MEMBER, LANDING GEAR MAIN FRAME AND SKIN. (M)SDR HNAA9892793Stringer · corrodedJAX - FOUND CORROSION ON STRINGER 31 RT BETWEEN STATION 167 AND 182 WITH A LOSS OF 50 PERCENT OF MATERIAL. REPAIRED IAW RD8-53-1243. (M)SDR HNAA9892792Stringer · corrodedJAX - CORROSION WAS REPAIRED ON STRINGER 32 RT IAW EO8-53-98-385. (M)SDR QXEA9801755Connector · brokenFORWARD END OF NR 3 AND NR 4 EMERGENCY TRACK LIGHTING INOP. FOUND BROKEN PLUG CONNECTOR 3352-J3. APPLIED INTERIM REPAIR, OPERATIONAL CHECK GOOD.SDR AU981590Rod · out of adjust(AUS) NOSE LANDING GEAR DOOR ACTUATOR ROD OUT OF ADJUSTMENT.SDR CA990310006Switch · shorted(CAN) IN-FLIGHT, ROLL SPOILER INBOARD CAUTION LIGHT ILLUMINATED. LEFT UPPER ROLL SPOILER MICROSWITCH FOUND SHORTED INTERNALLY, SWITCH REPLACED.SDR AU981568Line · cracked(AUS) COMPRESSOR AIR DIFFUSER LINE CRACKED.SDR HNAA9892483Power Supply · inoperativeCHO - FLT 3251 - FLOOR EMERGENCY LIGHTS INOPERATIVE. REPLACED 3352-PS1 AND 3352-PS2 BATTERY POWER SUPPLIES AND BASE ASSEMBLIES. POWER SUPPLIES P/N OFF 61-0479-1X S/N SBY106 AND ORF61. POWER SUPPLY BASE P/N OFF NSN7 AND PS207. (M)SDR CA990310018Tscu · malfunctioned(CAN) NR 2 ENGINE TORQUE WENT TO 168 PERCENT ON TAKEOFF. TAKEOFF REJECTED. ALL OTHER ENGINE PARAMETERS WERE NORMAL. AFTER RETURN TO GATE, THE TORQUE STILL INDICTED 168 PERCENT. THE TORQUE SENSOR CONDITIONING UNIT WAS REPLACED.
Back to Boeing DHC-8-102