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 HNAA0000008Battery · dischargedBEFORE THE FIRST FLIGHT OF THE MORNING SEVERAL EMERGENCY LIGHTS WERE FOUND TO BE INOP. REPLACED ALL EMERGENCY LIGHT BATTERY PACKS.SDR HNAA0000007Cable · displacedBEFORE THE FIRST FLIGHT OF THE MORNING THE CREW COULD NOT OPEN THE PAX DOOR MORE THAN APPROX 1 FOOT. THE COUNTERBALANCE CABLE WAS FOUND TO BE OFF THE CABLE DRUM. THE CABLE AND COUNTERBALANCE GAS STRUTS WERE REPLACED.SDR AU000020Impeller · fod(AUS) NR 1 ENGINE FIRST STAGE (LP) IMPELLER DAMAGED BEYOND LIMITS DUE TO FOD.SDR AU000031Ecu · malfunctioned(AUS) LEFT ENGINE ELECTRONIC CONTROL UNIT FAULTY.SDR CA000310006Switch · failed(CAN) DURING CRUISE FLIGHT, AIRCRAFT HAD A FAILURE OF THE NR 2 HYD RES LEVEL SWITCH CAUSING AN ISOLATION OF THE NR 2 HYD SYSTEM. ALT LANDING GEAR EXTENSION WAS CARRIED OUT. A/C POST MOD 8/2781. PARTS TO BE EXAMINED BY VICKERS.SDR PCAA0001006Cable · twistedSWF - FLIGHT 1369 - UPON ARRIVAL AT AIRCRAFT PRIOR TO FIRST FLIGHT, THE CREW COULD NOT OPEN THE PASSENGER DOOR MORE THAN 12 INCHES. MAINTENANCE INSPECTED AND FOUND THE LOWER DOOR CABLE TANGLED. REMOVED AND REPLACED DOOR SUPPORT CABLE ASSEMBLY. OPERATIONAL CSDR PCAA0001005Radar · failedBDL TO BWI - FLIGHT 3892 EN ROUTE - THE CREW NOTICED SMOKE COMING FROM THE RADAR UNIT. THE FLIGHT WAS DIVERTED TO ACY. AN EMERGENCY WAS DECLARED AND EMERGENCY EQUIPMENT CALLED. ALL PAX DEPLANED THROUGH MAIN CABIN DOOR. THE SMOKE WAS VERIFIED AS COMING FROSDR HNAA0000005Switch · inoperativeNR 2 HYD ISO VALVE CAUTION LIGHT FLICKERED IN FLIGHT. THE LIGHT ILLUMINATED STEADILY AFTER ATTEMPTED GEAR EXTENSION. GEAR WOULD NOT EXTEND. CREW PERFORMED ALTERNATE GEAR EXTENSION. FOUND NR 2 HYDRAULIC RESRVOIR LOW LEVEL SWITCH INOP. REPLACED SWITCH.SDR CA000501001Light · failed(CAN) BASE ASSY 3351-PS2 REPLACED BECAUSE NUMERIOUS EMERGENCY LIGHTS WOULD NOT TURN ON.SDR AU000023Transmitter · cracked(AUS) HYDRAULIC PRESSURE TRANSMITTER CRACKED AND LEAKING.SDR QXEA000015Light · brokenSEA - EXIT SIGN BELOW LEFT WINDOW EMERGENCY EXIT BROKEN. REMOVED AND REPLACED EXIT SIGN AT 4AB. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR PCAA0001004Skin · crackedBGM - DURING A ROUTINE WALK AROUND, THE FORWARD RUDDER WAS FOUND CRACKED AT THE UPPER RIGHT SIDE. MAINTENANCE REPAIRED THE CRACK IAW REPAIR DRAWING 8-55-130. AIRCRAFT WAS RETURNED TO SERVICE.SDR CA000118014Generator · failed(CAN) WHILE IN CRUISE FLIGHT, THE LEFT ELEVATOR HORN HEAT FAILED FOLLOWED BY A FAILURE OF THE LEFT TRANSFORMER RECTIFIER UNIT. MAINTENANCE REPLACED THE LEFT AC GENERATOR AND A BLOWN ''A'' PHASE CURRENT LIMITER, P.N. MS28937-30.SDR CA000118010Line · blocked(CAN) THE FLIGHT CREW REPORTED THAT THE CABIN DOOR SEAL DEFLATED AFTER TAKEOFF. THE AIRCRAFT RETURNED FOR LANDING. WHILE THE MAINTENANCE PERSONNEL WERE REPLACING THE DOOR SEAL, THEY FOUND THE PRESSURE LINE TO THE DOOR SEAL PLUGGED WITH WATER AND ICE. THE LINE SDR PCAA0001003Trim · frozenBUF-BWI - FLIGHT 3610 RETURNED TO BUF - DURING CRUISE ATTEMPTED TO DESCEND USING THE AUTO PILOT. CREW RECEIVED A MISTRIM LIGHT AND TURNED OFF AUTO PILOT. EXPERIENCED AN OUT OF TRIM CONDITION. THE ELEVATOR TRIM WOULD NOT ADJUST MANUALLY, TEMPERATURE -19C. MSDR CA000120002Gasket · leaking(CAN) THE CREW REPORTED FUEL LEAKING FROM THE NR 1 ENGINE NACELLE. MAINTENANCE FOUND THE GASKET AND O-RING ON THE MAIN FUEL FEED LINE BULKHEAD FITTING, LOCATED BETWEEN THE FUEL TANK AND DRY BAY, TO BE LEAKING.SDR PCAA0001002Indicator · malfunctionedSYR-LGA - FLIGHT 3863, CREW SHUTDOWN NR 1 ENGINE AS A PRECAUTION DUE TO LOW OIL PRESSURE INDICATION, OIL PRESSURE LIGHT REMAINED OUT UNTIL ENGINE WAS SHUTDOWN. AIRCRAFT WAS DIVERTED INTO BGM, PASSENGERS DEPLANED NORMALLY. EMERGENCY WAS DECLARED. MAINTENANCESDR HNAA0000004Window · crackedTHE CAPTAINS SIDE WINDOW OUTER PLY CRACKED IN FLIGHT. PIECES OF THE OUTER PLY SEPARATED FROM THE AIRCRAFT AND DAMAGED THE NR 1 PROP NR 1 BLADE. REPLACED THE CAPTAINS SIDE WINDOW AND NR 1 BLADE ON NR 1 PROP.SDR QXEA000038Stop · dirtyPDX - MAIN CABIN DOOR DIFFICULT TO OPEN. CLEANED MAIN CABIN DOOR STOP PADS. OPENED AND CLOSED DOOR NUMEROUS TIMES. DOOR OPERATIONS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR HNAA0000003Eec · failedNR 2 ENG FAILED WHILE AIRBORNE. REMOVED AND REPLACED NR 2 ENG HMU AND FUEL PUNP NO FIX. REMOVED AND REPLACED NR 2 EEC GROUND RUN CHECK GOOD.SDR HNAA0000002Door · out of adjustNR 1 GEAR DOOR (AFT) OPENED IN FLT AND WILL NOT CLOSE. ADJUSTED GEAR DOOR AND AND NR 1 PROX SENSOR.SDR CA000118015Switch · contaminated(CAN) THE CREW REJECTED TAKEOFF DUE TO AN INBOARD ROLL SPOILER CAUTION LIGHT. MAINTENANCE FOUND THE POWER LEVER MICROSWITCHES WERE CONTAMINATED. THE SWITCHES AND ACTUATORS WERE CLEANED AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR CA000118009Line · leaking(CAN) DURING INSPECTION, A HYDRAULIC FLUID LEAK WAS FOUND IN THE HYD FLUID LINE TO THE LANDING GEAR DOOR SEQUENCING VALVE.SDR AU000022Brake · failed(AUS) RIG INBOARD BRAKE ASSEMBLY LOCKED ON CAUSING THE THERMAL PLUGS TO BLOW AND THE TIRE TO DEFLATE.SDR AU000051Brake · seized(AUS) RIGHT BRAKE UNIT LOCKED ON CAUSING THERMAL PLUGS TO BLOW.SDR HNAA0000001Line · chafedNR 1 HYDRAULIC SYSTEM LOST ALL QUANTITY. FOUND HYDRAULIC LINE CHAFFED NR 1 NACELLE. REPLACED LINE WITH TEMP FLEX LINE.SDR CA000118012Oil Cooler · leaking(CAN) OIL COOLER LEAK EXPERIENCED. KNOWN ISD.SDR CA000118017Valve · leaking(CAN) DURING SCHEDULED MAINTENANCE, IT WAS DISCOVERED THAT THE PARKING BRAKE WAS LOSING PRESSURE. MAINTENANCE DETERMINED THE PARK BRAKE VALVE WAS LEAKING INTERNALLY AND REPLACED IT. THE NR 2 SYSTEM PX CHECK VALVE ON THE PARK BRAKE MANIFOLD WAS ALSO REPLACED.SDR PCAA0001001Gas Strut · brokenFLIGHT 3692 IN PHL- PASSENGER DOOR WAS FOUND DIFFICULT TO OPEN AND CLOSE. PASSENGERS WERE DEPLANED NORMALLY. MAINTENANCE INSPECTED AND FOUND THE AFT DOOR STRUT BROKEN. REMOVED AND REPLACED FORWARD AND AFT STRUTS IAW DHC PROCEDURES. DOOR OPERATIONALLY CHECKSDR CA000110011Line · leaking(CAN) THE PARKING BRAKE WAS FOUND TO BE LOOSING PRESSURE WHILE UNDERGOING MAINTENANCE. INVESTIGATION REVEALED THE PARKING BRAKE PRESSURIZING LINE WAS CRACKED AND LEAKING FLUID.SDR CA000110010Gcu · failed(CAN) DURING THE TAKEOFF ROLL,THE NR 1 AC GENERATOR CAUTION LIGHT CAME ON. THE TAKEOFF WAS ABORTED AND THE AIRCRAFT RETURNED TO MAINTENANCE. MAINTENANCE REPLACED THE AC GCU AND RETURNED THE AIRCRAFT TO SERVICE.SDR QXEA9902677Cable · lack of lubePDX - MAIN CABIN DOOR HARD TO OPEN. MAINTENANCE LUBRICATED THE MAIN CABIN DOOR CABLE. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR QXEA9902676Light · inoperativePDX - FLIGHT DECK EMERGENCY OVERHEAD LIGHT DEAD. MAINTENANCE REPLACED EMERGENCY LIGHT. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR PCAA9900064Cable · kinkedFLIGHT 3715- UPON ARRIVAL INTO BOS THE CREW COULD NOT OPEN THE PASSENGER DOOR. PASSENGERS WERE DEPLANED THROUGH THE RIGHT FORWARD EMERGENCY EXIT. MAINTENANCE INSPECTED AND FOUND THE DOOR CABLE WAS KINKED AND BOUND AROUND THE LOWER PULLEY. MAINTENANCE REMOVESDR QXEA9902718Web · corrodedPDX - RIGHT NACELLE TOP DECK AFT PORTION HAS CORROSION WHERE EXHAUST FINGERNAIL MOUNTS BETWEEN STATION XN255 AND XN286.0. REPAIRED IAW DHC-8 SRM 51-40-4.SDR QXEA9902701Skin · crackedPDX - RIGHT NACELLE EXTERIOR OUTBOARD SKIN HAS .250 CRACK FROM RIVET HOLE TO SKIN PANEL EDGE AT STATION XN122.00 AND YW171.200, ALSO HAS LOOSE WORKING RIVET IN SAME AREA JUST AFT OF PANEL 426AR. REPAIRED IAW HORIZON AIR EA 9-54-239.SDR QXEA9902699Web · corrodedPDX - RIGHT NACELLE TOP DECK AFT PORTION HAS CORROSION WHERE EXHAUST FINGERNAIL MOUNTS BETWEEN STATION XN255 AND XN280.00. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11.SDR QXEA9902674Skin · dentedPDX - 4 DENT ON OUTER SKIN AT STATION 507, WL100, BL40RH. REPAIRED IAW HORIZON AIR EA 9-53-531.SDR PCAA9900063Gas Strut · failedPIT- FLIGHT 3774- PRIOR TO DEPARTURE THE CABIN DOOR WAS FOUND DIFFICULT TO CLOSE. MAINTENANCE INSPECTED, OPERATED DOOR, NO DEFECTS FOUND. SUBSEQUENT MAINTENANCE REPLACED THE FORWARD DOOR GAS STRUT IAW DHC MAINTENANCE MANUAL PROCEDURES, OPERATIONAL CHECK PROSDR CA000118034Line · leaking(CAN) DURING THE ENGINE START, HYDRAULIC FLUID QUANTITY DROPPED TO .5 QUARTS. MAINTENANCE FOUND THE PRESSURE LINE TO THE QUANTITY LIMITING VALVE TO BE CHAFED AND LEAKING.SDR QXEA9902696Guard · wornPDX - INBOARD MIDDLE GRAVEL GUARD ATTACH POINT WORN EXCESSIVELY THIN. REPAIRED IAW RD8-54-41.SDR QXEA9902673Skin · chafedPDX - CHAFE DAMAGE AT STATION 242.20 AND STRINGER 11S, ABOVE RIGHT FORWARD EXIT. IT IS APPROXIMATELY .035 DEEP. REPAIRED IAW HORIZON AIR EA 9-53-535.SDR QXEA9902669Bracket · corrodedPDX - CORROSION IN ANGLE BRACKET AT FRAME X600.0 AND STRINGER 21S. REPAIRED IAW HORIZON AIR EA 9-53-536.SDR QXEA9902663Stringer · gougedPDX - SMALL GOUGE IN LEFT-HAND STRINGER 31 AT APPROXIMATELY STATION 550. REPAIRED IAW HORIZON AIR EA 9-53-532.SDR CA000118036Housing · cracked(CAN) THE FLIGHT CREW REPORTED THAT THE LEFT OUTBOARD ROLL SPOILER DID NOT DEPLOY DURING LANDING. MAINTENANCE FOUND THAT THE SPOILER ACTUATOR WAS LEAKING FROM A CRACK IN THE HOUSING AT THE PRESSURE INLET FITTING.SDR CA000118035Line · cracked(CAN) HYDRAULIC LINE TO THE LEFT INBOARD SPOILER ACTUATOR WAS FOUND CRACKED AND LEAKING.SDR QXEA9902652Frame · corrodedPDX - CORROSION ON UNDER SIDE OF HORIZONTAL STIFFENING RIB ON AFT FLANGE OF FRAME 253.400, BETWEEN STRINGERS 24 LT AND 25 LT. REPAIRED IAW HORIZON AIR EA 9-53-534.SDR QXEA9902695Web · chafedPDX - TOP EXHAUST DECK HAS CHAFE HOLE CENTER OF DECK AT RIVET LINE. REPAIRED IAW RD8-54-866.SDR QXEA9902700Skin · crackedPDX - RIGHT NACELLE EXTERIOR INBOARD SKIN HAS 1.5 CRACK AT STATION XN127.5 AND YW139.200, JUST AFT OF PANEL 425AL TOP EDGE. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA9902698Web · puncturedPDX - AFT NACELLE TOP DECK HAS A PUNCTURE HOLE AT APPROXIMATELY STATION X236.00 AND YW139.900. REPAIRED IAW HORIZON AIR EA 9-54-237.
Back to Boeing DHC-8-102