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 PCAA9700550Control Box · failedEMERGENCY LIGHTS WILL NOT TURN OFF FOLLOWING ENGINE SHUT DOWN UNLESS BATTERIES ARE FIRST SELECTED OFF. REMOVED AND REPLACED EMERGENCY LIGHT ADVISORY CONTROL BOX WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9700549Light · failedCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700551Bulb · failedONE BULB INOPERATIVE IN EMERGENCY FLOOR PROXIMITY LIGHTING. REMOVED AND REPLACED LAMP. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR QXEA9700581Bulb · failedPDX- FLIGHT ATTENDANT EMERGENCY LIGHT SWITCH INOP. RELAMPED, OPERATION CHECK GOOD.SDR QXEA9700580Test Switch · malfunctionPDX - FIRE EXTINGUISHER A-LIGHT ON, B-TESTS NORMAL. REPLACED TEST SWITCH, SYSTEM OPERATIONAL CHECKS GOOD.SDR QXEA9700574Mechanism · out of adjustPDX - LEFT HAND GEAR DOOR LIGHT STAYED ON AFTER GEAR WAS RAISED. ADJUSTED MAIN LANDING GEAR DOOR (REAR AND CENTER) ACTUATORS. ADJUSTED MAIN LANDING GEAR FORWARD DOOR CONNECTING LINK. RETRACTION AND EXTENSION TEST GOOD.SDR PCAA9700553Bulb · failedEMERGENCY FLOOR PROXIMITY LIGHTING HAS ONE BULB INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700548Hose · failedFLT 3633 - LGA-BTV - NR 2 HYDRAULIC SYSTEM PRESSURE FELL TO ZERO FOLLOWING GEAR RETRACTION ON DEPARTURE FROM LGA. CREW DECLARED AN EMERGENCY AND RETURNED TO LGA WITHOTU FURTHER INCIDENT. VERIFIED LEAK AND REPLACD NOSE GEAR DRAG STRUT ACTUATOR FLEXIBLE HYDRAUSDR MALA975668Bulb · failedDURING INSPECTION, CENTER AISLE OVERHEAD EMERGENCY LIGHT INOP. MAINTENANCE RELAMPED. (M)SDR MALA975654Lamp Socket · failedFLT 3093 - DURING PUSH-BACK, AN ELECTRICAL ODOR AT SEAT 2E. PASSENGERS AND CREW DEPLANED. MAINTENANCE PULLED CABIN LIGHTS CONTROL CIRCUIT BREAKER, REPLACED LAMP SOCKET AND RESET CIRCUIT. ALL CHECKS GOOD. (X)SDR QXEA9700572Connector · malfunctionAUTOFEATHER ARM WILL NOT TEST. REPLACED CANNON PLUGS 9811-P13 AND P14, OPERATIONAL CHECKS GOOD FOR NR 1 AND NR 2 ENGINE AUTOFEATHER SYSTEM.SDR QXEA9700569Harness · malfunctionPDX - UNABLE TO TEST AUTO FEATHER, NO ARM LIGHT DURING TEST. REPLACED NR 1 AND NR 2 TRUSS HARNESS FROM FIREWALL TO ECU. GROUND RAN, OPERATIONAL CHECK GOOD.SDR PCAA9700547Light · inoperativeFLOOR EMERGENCY PATH LIGHT AT ROW 7DF INOPERATIVE. FOUND WIRE PULLED OUT FROM LIGHT SOCKET. REMOVED AND REPLACED LIGHT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700546Bulb · failedONE OF FOUR RED CABIN FLOOR EMERGENCY PATH LIGHT AT CENTER CABIN IN INOP. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9700545Sign · inoperativeLEFT EMERGENCY EXIT SIGN AT ROW 4AC INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT SIGN AT ROW 4AC. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975650Bracket · brokenFLT 3266 - ON TAXI OUT OF GATE, THE FIRE EXTINGUISHER MOUNTING BRACKET IN FLIGHT COMPARTMENT BROKE. MAINTENANCE REPLACED COCKPIT FIRE EXTINGUISHER MOUNTING BRACKET. OPS CHECK GOOD. (M)SDR QXEA9700565Detector · malfunctionSEA - LAV SMOKE DETECTOR DOES NOT TEST. REPLACED SMOKE DETECTOR, OPERATIONAL CHECK GOOD.SDR PCAA9700544Wire · looseON SHUTDOWN WITH EMERGENCY LIGHT SWITCH OFF EMERGENCY LIGHTS CAME ON, FLICKERED AND WENT OFF. FOUND WIRE NR 20113A22 ON RELAY K20 RECEPTICAL POS B1 TO HAVE BAD SOLDER JOINT IN DC CONTACTOR BOX. RESOLDER WIRE. SYSTEM OPERATIONAL CHECKED NORMAL. AIRCRAFT RETSDR PCAA9700542Light · inoperativeCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT INOPERATIVE. REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975649Light · brokenDURING INSPECTION, FOUND EMERGENCY LIGHT ASSEMBLY AT SEAT 4AB BROKEN. MAINTENANCE REPLACED LIGHT ASSEMBLY WITH SERVICEABLE UNIT. ALL CHECKS GOOD. (M)SDR QXEA9700563Lamp · failedSEA- BAGGAGE SMOKE DETECTOR WILL NOT TEST IN POSITION NR 1. RELAMPED INTERNAL SMOKE DETECTOR LIGHT, OPERATIONAL CHECKS GOOD.SDR PCAA9700543Light · inoperativeONE LIGHT BULB ON RIGHT FLOOR EMERGENCY EXIT LIGHTS AT SEAT 3 D/F INOP. REMOVED AND REPLACED LIGHT STRIP WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR CA970922019Tube · chafed(CAN) PILOT NOTICED NR2 HYDRAULIC LEVEL STARTING TO DROP. NR2 LANDING GEAR DOORS FOUND ALL WET. LINE BETWEEN DUMP SOLENOID VALVES HAD A SMALL CHAFE ON THE EXTERIOR WHICH CAUSED THE LEAK.SDR CA970922003Relay Socket · loose(CAN) AFTER TAKEOFF WHEN GEAR SELECTED UP, GEAR INOPERATIVE LIGHT ON. AIRCRAFT RETURNED. NO GEAR FAULTS FOUND. RELAYS SWAPPED. LATER SAME DAY CLIMBING THROUGH 12,000 FEET GEAR INOPERATIVE LIGHT ON AGAIN. GEAR LOWERED MANUALLY. SOCKET FOR RELAY 3261-K11 FOUND LSDR PCAA9700541Lamp · failedLEFT FORWARD EMERGENCY EGRESS LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR SABA9700029Seal · damagedCLT - FLT 5035 - LOST CABIN PRESSURIZATION 72 MILES OUT OF CLT, RETURNED TO CLT. NO EMERGENCY DECLARED. REMOVED AND REPLACED DOOR SEAL. INSPECTED PRESSURE SYSTEM. REMOVED AND REPLACED CABIN PRESSURE CONTROLLER. (M)SDR PCAA9700540Light · inoperativeOVERHEAD COCKPIT PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700539Battery Pack · dischargedRIGHT CABIN AFT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RIGHT FORWARD BATTERY PACK. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR CA970918007Rod Assembly · sheared(CAN) AFTER LANDING FOUND THE LEFT AFT OUTBOARD AND CENTRE MAIN LANDING GEAR DOORS OPEN. FOUND THE ROD ASSEMBLY AND SPRING ASSEMBLY BROKEN IN HALF. SUSPECT THAT THE SPRING WAS BROKEN UNDER TENSION CAUSING BELLCRANK ASSEMBLY TO SPLIT ROD ASSEMBLY IN HALF.SDR CA970916014Spring Assembly · split(CAN) AFTER LANDING, FOUND THE LEFT AFT OUTBOARD AND CENTRE MAIN LANDING GEAR DOORS OPEN. FOUND ROD ASSEMBLY AND SPRING ASSEMBLY BROKEN IN HALF. SUSPECT SPRING HAD BROKEN UNDER TENSION CAUSING BELLCRANK ASSEMBLY TO SPLIT ROD ASSEMBLY IN HALF.SDR MALA975636Light · failedDURING INSPECTION, EMERGENCY EXIT LIGHT AT 1 D/E NOT SECURE. MAINTENANCE REMOVED AND REPLACED LAMP ASSEMBLY. ALL CHECKS GOOD. (M)SDR DHC8102Lamp · failedDURING INSPECTION, TWO RED FLOOR TRACK LIGHTS INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR CA970916013Safety Pin · missing(CAN) WHILE DOING AN ALTERNATE RELEASE CABLE CHECK, THE RIGHT MAIN LANDING GEAR ALTERNATE RELEASE CABLE CAME DISCONNECTED AT FORWARD END OF TURNBUCKLE. ONE OF THE TURNBUCKLE ASSEMBLY 'SAFETY PINS' WAS MISSING AND THE SECOND ONE WAS NOT STOPPING THE TURNBUCKLE SDR PCAA9700538Lamp · failedONE FORWARD EMERGENCY FLOOR PATH LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975634Lamp · failedDURING INSPECTION, TWO FLOOR TRACK LIGHTS OUT. MAINTENANCE RELAMPED BOTH FLOOR TRACK LIGHTS. OPS CHECK GOOD. (M)SDR MALA975633Lamp · failedDURING INSPECTION, FLOOR TRACK AT 1D OUT. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR MALA975632Light · failedDURING INSPECTION, EXIT SIGN FELL OFF. MAINTENANCE REPLACED EXIT SIGN. ALL CHECKS GOOD. (M)SDR QXEA9700549Tq Signal Cond · malfunctionBOI - AUTO FEATHER WOULD NOT ARM. REPLACED NR 1 AND NR 2 TSCU'S AND RELAY 6121K5, OPERATIONAL CHECK GOOD.SDR PCAA9700537Connector · looseSEVERAL EMERGENCY FLOOR PATH LIGHTS INOPERATIVE. RESECURED CONNECTOR AT FORWARD END OF EMERGENCY FLOOR LIGHTING STRIP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700531Socket · failedAFTER DEPARTURE FROM LGA, THE FLT ATTENDANT REPORTED A SMELL OF SMOKE IN THE CABIN. THE AIRCRAFT RETURNED TO FIELD AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND SOURCE OF SMOKE COMING FROM THE LIGHT SOCKETS AT ROW 1DF. MAINTENANCE ISOLATED SOSDR MALA975635Lamp · failedDURING INSPECTION, ONE OVERHEAD EMERGENCY LIGHT OUT IN AFT OF CABIN. MAINTENANCE REPLACED LAMP. OPS CHECK GOOD. (M)SDR 97ZZZM1098Socket · failedAFTER DEPARTURE FROM LGA, THE FLT ATTENDANT REPORTED A SMELL OF SMOKE IN THE CABIN. THE AIRCRAFT RETURNED TO FIELD AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND SOURCE OF SMOKE COMING FROM THE LIGHT SOCKETS AT ROW 1DF. MAINTENANCE ISOLATED SOSDR PCAA9700534Lamp · failedEMERGENCY FLOOR PATH LIGHTING AT ROW 1 HAS ONE LAMP INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975631Light · inoperativeDURING INSPECTION, 1C AND 5C FLOOR TRACK EMERGENCY LIGHTS INOP. MAINTENANCE REPLACED LIGHT ASSEMBLY. OPS CHECK GOOD. (M)SDR CA971020015Selector Valve · failed(CAN) WITH NORMAL APPROACH FOR LANDING AND GEAR SELECTION, GEAR FAILED TO COME DOWN. ALTERNATE SELECTION MADE, OK. LANDED OK. SELECTOR VALVE REPLACED.SDR PCAA9700536Bulb · failedSEVERAL EMERGENCY EXIT SIGN BULBS ARE INOPERATIVE. REMOVED AND REPLACED LAMPS. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. ACTC: 20,443. (X)SDR PCAA9700535Bulb · failedLEFT AFT EXTERIOR EMERGENCY LIGHT DIM. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700533Battery Pack · dischargedLEFT EXTERIOR AFT CEILING AND FWD CENTER CEILING EMERGENCY EXIT SIGNS ARE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK 3351PS3 AND REPLACED LAMP AT AFT POSITION. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975629Wire Harness · failedFLT 3405 - ON CLIMB-OUT, THE LEFT TORQUE, FUEL FLOW, AND EGT FLUCTUATION OCCURRED. RETURNED TO MSP. MAINTENANCE REPLACED WIRE HARNESS. GROUND RUNS AND OPS GOOD. (X)SDR QXEA9700546Hmu · malfunctionedSEA - NR 2 ENGINE FLAMED OUT AT 300 FEET ALG ON APPROACH. REPLACED HMU FUEL PUMP AND LP FUEL FILTER, NO DEFECTS NOTED. LEAK CHECKED, OPERATIONAL CHECK GOOD.
Back to Boeing DHC-8-102