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 CA990310020Retainer · worn(CAN) DURING INSPECTION, CHAFING WAS FOUND BETWEEN OVERHEAD WIRING HARNESS AND SHARP EDGES OF TROUGH RETAINER AT STA X234.50, ABOVE FORWARD EMERGENCY EXIT. INSULATION WAS WORN BUT NOT THROUGH TO BARE WIRE. ALL SUPPORT FOR BUNDLE APPEARED TO BE IN PLACE.SDR CA990310021Light · failed(CAN) ELECTRICAL SMELL REPORTED IN GALLEY. NO FAULT FOUND, SLIGHT ODOR NOTED AT LAMP ASSY, LAMP ASSY REPLACED.SDR CA990301010Tire · leaking(CAN) MAIN GEAR TIRE LEAKING THROUGH SIDEWALL.SDR CA990209016Switch · contaminated(CAN) WHEN GEAR RETRACTED, LEFT MAIN GEAR DOOR OPEN WARNING ON. GEAR RECYCLED AND FAULT THE SAME. WITH GEAR DOWN, DOOR POSITION INDICATION WAS NORMAL. INSPECTION LEAD TO CLEANING OF PROXIMITY SWITCHES. SUBMITTER SUSPECTS EITHER DEBRIS OR COLD WEATHER CAUSESDR QXEA9900283Wire · brokenSEA- SMOKE WARNING LIGHT CAME ON INTERMITTENTLY FOR ABOUT 5 SECONDS EACH TIME. MAINTENANCE INSPECTED AND FOUND NO EVIDENCE OF FIRE OR SMOKE. FOUND 2 BROKEN WIRES AT THE CANNON PLUG ON THE NR 2 CARGO SMOKE DETECTOR. STOWED WIRES AND PLACED ON MEL.SDR CA990310019Connector · loose(CAN) ELECTRICAL BURNING SMELL NOTED AFTER TAKEOFF. HOT POT CONNECTOR IN GALLEY FOUND LOOSE. CONNECTORS REPLACED.SDR HNAA9900022Structure · corrodedCORROSION RIGHT FUSELAGE ON STRINGER SPLICE AT STR 32S FRAME 488, SPLICE ON STR 29 AND AT FRAME 488, FRAME 433 LEG AT ST 31S, STR 29 .021 DEEP AT FRAME 529, SURFACE .006 DEEP ON SPLICE STR 28 AT FRAME 488, 7 AREAS RADIUS OF STR 31 MAX .013 DEEP BETWEEN FRAMES SDR HNAA9900021Handle · bindingUNABLE TO OPEN AIRSTAIR DOOR FROM OUTSIDE. HANDLE BINDING, REPLACED HANDLE STOP.SDR CA990311084Cable · broken(CAN) RIGHT HAND CONDTION CONTROL CABLE FOUND WITH BROKEN STRANDS. AREA OF DEFECT FORWARD OF PULLEY ON FORWARD SIDE OF ENGINE FIREWALL.SDR CA990310009Valve · failed(CAN) LANDING GEAR DID NOT EXTEND WHEN SELECTED, ALTERNATE SYSTEM USED. LANDING GEAR SOLENOID VALVE REPLACED.SDR CA990210004Garlock Seal · leaking(CAN) AT 16,000 FEET, OIL PRESSURE ON NR 1 ENGINE GRADUALLY DROPPED. PRECAUTIONARY SHUT DOWN WAS CARRIED OUT ON NR 1 ENGINE. POST-FLIGHT INSPECTION FOUND THE SOURCE OF THE OIL LEAK TO BE A LEAKING GARLOCK SEAL ON THE ENGINE DRIVEN HYDRAULIC PUMP. GARLOCK CASDR HNAA9900020Wire · brokenDURING GEAR EXTENSION LEFT MAIN GEAR UNSAFE LIGHT ILLUMINATED (RED LIGHT). CYCLED GEAR SEVERAL TIMES WITH SAME RESULTS. PERFORMED ALTERNATE EXTENSION AND ALTERNATE GEAR INDICATION 3 POINTS DOWN AND LOCKED. REPAIRED BROKEN WIRE AT STABILIZER STAY STRUT PROXISDR HNAA9900019Retract Mech · malfunctionedLANDING GEAR DOORS WOULD NOT CLOSE UNTIL NOSE GEAR TOUCHED DOWN ON LANDING. REPLACED 3261-K9 (P/N DSC182-2) RELAY.SDR CA990310007Windshield · cracked(CAN) DURING CLIMB THROUGH 13,000 FEET AT 2,000 FPM, COPILOT'S OUTER WINDSHIELD SHATTERED.SDR AU990104Actuator · malfunctioned(AUS) RT INBOARD ROLL SPOILER ACTUATOR FAULTY. SPOILER PANEL WOULD NOT FULLY RETRACT.SDR QXEA9900128Battery · dischargedSEA - EMERGENCY EXIT FLOOR LIGHT INOP. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY AND BATTERY. OPERATIONAL CHECK GOOD.SDR AU990074Harness · worn(AUS) WIRING HARNESS LOCATED IN THE LEFT CABIN UNDERFLOOR TROUGH CHAFED. HARNESS HAD SUFFERED PREVIOUS MECHANICAL DAMAGE. PART TC: 21,573.SDR HNAA9900017Tab · brokenLOWER AFT CORNER OF PASSENGER DOOR ENTRANCE COMBING HAS TAB BROKEN OFF. REPAIRED AS NECESSARY.SDR HNAA9900018Shroud · crackedNR 1 ENGINE EXHAUST SHROUD HAS 1 INCH CRACK STA 223.4 AT 4 O'CLOCK POSITION, REAR I/B MOUNT BOLT OF FORWARD RADIATION SHIELD IS PULLED THROUGH, REAR O/B ANGLE BRACKET 1.5 INCH CRACK STA XN276.50, OUTLET SHROUD RING 5 CRACKS AT RIVETS STA XN221.25 FROM 4 TO 6 OSDR HNAA9900016Smoke Detector · malfunctionedSMOKE WARNING LIGHT ILLUMINATES INTERMITTANTLY IN FLIGHT. COULD NOT DUPLICATE. REPLACED ANNUNCIATOR PANEL (P/N 75-0434-1) (S/N 0075), SMOKE DETECTOR (P/N 473054) (S/N 0052) AND SMOKE DETECTION CONTROL AMPLFIER (P/N 30-326E7) (S/N 0354) AS A PRECAUTION.SDR QXEA9900096Gas Spring · malfunctionMAIN CABIN DOOR HARD TO OPEN AND CLOSE. MAINTENANCE REPLACED THE MAIN CABIN DOOR GAS SPRINGS, OPERATIONAL CHECKS GOOD.SDR QXEA9900098Light · inopCREW EMERGENCY ESCAPE LIGHT INOP. MAINTENANCE REPLACED THE EMERGENCY ESCAPE LIGHT, OPERATIONAL CHECKS GOOD.SDR CA990310094Switch · intermittent(CAN) TAKEOFF REJECTED DUE TO LOW OIL PRESSURE WARNING LIGHT ON NR 2 ENGINE. AIRCRAFT RETURNED TO GATE AND OIL WAS ADDED TO NR 2 ENGINE. MAINTENANCE TROUBLESHOT ENGINE AND THE FOLLOWING WAS ACCOMPLISHED: P2.5/P3 SWITCHING VALVE CLEANED, CENTRIFUGAL BREATHERSDR QXEA9900099Light · inopCOCKPIT EMERGENCY LIGHT DOES NOT ILLUMINATE. MAINTENANCE REPLACED THE OVERHEAD LIGHT, OPERATIONAL CHECKS GOOD.SDR AU990083Acm · seized(AUS) AIR CYCLE MACHINE BINDING. TURBINE WHEEL EVENTUALLY SEIZED. PART TC: 17,225.SDR HNAA9900011Pbe · unserviceablePERSONAL BREATHING EQUIPMENT (PBE) IN FLIGHT ATTENDANT'S CLOSET RED INDICATOR PROTRUDING PAST FACE OF CONTAINER. REPLACED PBE.SDR CA990310008Relay · failed(CAN) RIGHT PROPELLER DE-ICE PHASE A SHOWS LOAD WITH DE-ICE SELECTED OFF. RELAY FAILED IN ON POSITION. RELAY REPLACED.SDR AU990043Bellcrank · failed(AUS) CARGO DOOR WOULD NOT LOCK AFTER LOADING AIRCRAFT. ROTATION OF THE BAGGAGE DOOR HANDLE HAD NO EFFECT ON DOOR LOCKING. INVESTIGATION FOUND THAT BELLCRANK FAILURE HAD OCCURRED BETWEEN THE HANDLE AND DOOR LOCKING MECHANISM AT THE BEARING RETAINER. PART TCSDR HNAA9900015Skin · chafedRIGHT HAND WING OUTBOARD FLAP INBOARD UPPER SKIN HAS CHAFE, DEPTH IS .009 LENGTH AND WIDTH .3 BY .3 LOCATED 2.5 INCHES FROM INBOARD EDGE. REPAIRED AS NECESSARY.SDR HNAA9900014Bracket · crackedRIGHT HAND AILERON TRIM TAB ATTACH BRACKET CRACKED APPROXIMATELY 1 INCH RADIUS ON AFT SIDE FORWARD. REPLACED BRACKET.SDR HNAA9900013Conduit · damagedRIGHT WING WIRE CONDUIT RIPPED OPEN AND BRACKET DAMAGED AT NR 4 FLAP JACKSCREW LOCATION. REPAIRED AS NECESSARY.SDR HNAA9900012Intercostal · damagedINTERCOSTAL AFT OF SILL MEMBER LOCATED AFT OF FRAME X270 IN FUSELAGE RIGHT SIDE HAS HOLE IN FORWARD RADIUS. REPAIRED AS NECESSARY. INTECOSTAL AT STRINGER 23S FRAME X264.1 AND X270.5 CRACKED AT RIVET HOLE JUST FORWARD OF AFT HI-LOK IN LEG ATTACHED TO SEAT RAILSDR HNAA9900007Bracket · crackedPRESSURE MANIFOLD BRACKET IN NR 2 NACELLE CRACKED IN LOWER FORWARD CORNER. REPAIRED IN ACCORDANCE WITH STRUCTURAL REPAIR MANUAL.SDR CA990310015Manifold · failed(CAN) AFTER TAKEOFF, NR 2 STANDBY HYDRAULIC PUMP SEL. OFF, NR 2 ENGINE PUMP, RUDDER PRESS, RUDDER FULL PRESS, NR 2 RUDDER HYD, ROLL SPOILER CAUTION LIGHTS ON. TURNING NR 2 STANDBY PUMP ON, NORMAL OPERATION. PRESSURE MANIFOLD REPLACED.SDR HNAA9900010Seat Track · corrodedCORROSION ON SEAT RAIL, P/N 85330507-106, ON UPPER LEVEL .012 DEEP AT FRAME STATION X488. REPLACED SEAT RAIL. CORROSION ON SEAT RAIL, P/N 85320490-133, BETWEEN STATIONS X242 AND X264 BETWEEN .010 AND .015. REPAIRED AS NECESSARY. CORROSION ON SEAT RAIL, P/NSDR HNAA9900006Connector · brokenFORWARD DOOR EMERGENCY EXIT SIGN, FORWARD AISLE DOWN LIGHT AND ROW 4 RED FLOOR EMERGENCY LIGHT INOPERATIVE. REPAIRED 3351-PS2 CONNECTOR, OPERATIONAL CHECK GOOD.SDR CA990119025Line · leaking(CAN) HYDRAULIC LINE FOUND LEAKING AT THE 'B' NUT FOR SPOILER. LINE IN THE RIGHT HAND NACELLE BETWEEN THE T-FITTING AND RESERVOIR.SDR HNAA9900009Angle · crackedFORWARD ANGLE BETWEEN INBOARD SEAT RAILS AT COCKPIT ENTRANCE AT APPROXIMATELY STATION X210 CRACKED. REPLACED BRACKET.SDR AU990009Warning System · activated(AUS) ON INITIAL CLIMB, BOTH MAIN AND AUXILIARY BATTERY WARNING LIGHTS ILLUMINATED ON THE CENTRAL WARNING PANEL.SDR HNAA9900005Boots · malfunctionedEN ROUTE MULTIPLE DEICE BOOTS DID NOT INFLATE IN FREEZING CONDITIONS. CHECKED ALL BOOTS WITH SHOP AIR IN MANUAL AND AUTO MODE. REMOVED AND REINSTALLED DRAIN PLUGS WITH NO WATER FOUND OR ANY OTHER DISCREPANCIES.SDR HNAA9900004Battery Pack · dischargedEMERGENCY EXIT LIGHT OVER AIRSTAIR DOOR INOPERATIVE. REPLACED EMERGENCY BATTERY POWER SUPPLY (P/N 61-0478-1X) (S/N PS034) AND EMERGENCY LIGHT BATTERY (P/N 60-1321-1X) (S/N SBY128).SDR CA990310092Hp Turbine · damaged(CAN) NR 2 ENGINE HAD A TORQUE SURGE OF 107 PERCENT ON APPROACH. THE TORQUE SURGE SUBSIDED AFTER A FEW SECONDS. THEN A LOUD BANG WAS HEARD AND THERE WAS SMOKE IN THE COCKPIT AND CABIN. THE AIRCRAFT DECLARED AN EMERGENCY AND LANDED WITHOUT INCIDENT. POST-FLISDR HNAA9900008Frame · corrodedCORROSION AFT SIDE OF FRAME X487 BETWEEN STRINGERS 29S AND 31S AND FRAME AT STATION X202 AND A CRACKED RIVET HOLE ON FRAME A STATION X222 AT STRINGER 31R. REPAIRED AS NECESSARY.SDR HNAA9900001Fire Loop · out of positionBAGGAGE COMPARTMET SMOKE WARNING LIGHT CAME ON IN FLIGHT INTERMITTENTLY. NO EVIDENCE OF SMOKE. INSPECTED DETECTOR WIRING AND FOUND RUB MARKS ON CONNECTOR I-J3. REPOSITIONED WIRING. REPLACED NR 2 SMOKE DETECTOR.SDR HNAA9900003Valve · malfunctionedUNABLE TO OPEN PASSENGER DOOR FROM INSIDE AIRCRAFT. CYCLED DOOR OPEN/CLOSED. OPERATIONAL CHECKED GOOD. SUSPECT ICE ACCUMULATION IN DOOR SEAL PRESSURE VALVE. FOLLOWUP REPLACEMENT PER SERVICE BULLETIN 8-52-46.SDR CA990310090Line · leaking(CAN) LOSS OF NR 2 HYDRAULIC SYSTEM AFTER TAKEOFF WITH GEAR UP SELECTION. NLG UP LINE WAS FOUND BLOWN APART. LINE REPLACED AND SYSTEM CHECKED SERVICEABLE.SDR CA990310014Seat Track · corroded(CAN) SEAT RAIL FOUND CORRODED UNDER LAV/GALLEY AREA. PART REPLACED.SDR QXEA9802115Light · inopHANDHELD EMERGENCY LIGHT IN THE COCKPIT OVERHEAD IS INOP. MAINTENANCE REPLACED THE OVERHEAD EMERGENCY LIGHT, OPERATIONAL CHECKS GOOD.SDR HNAA9883396Windshield · failedCAPTAIN'S WINDSHIELD HEAT WIRING SHORTED IN FLIGHT FOR APPROXIMATELY 4 SECONDS AT WINDSHIELD TERMINAL BLOCK, FOLLOWED BY WINDSHIELD INNER PLY CRACKING. REPAIRED WIRING AND REPLACED WINDSHIELD.SDR QXEA9802113Mechanism · lack of lubeSEA - PASSENGER DOOR DIFFICULT TO OPEN FROM THE INSIDE. MAINTENANCE ADJUSTED THE THRESHOLD STRIP ON THE BOTTOM OF THE DOOR AND LUBRICATED THE DOOR PINS. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.
Back to Boeing DHC-8-102