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 QXEA9900559Strap · chafedYXX - CHAFE FOUND ON LEFT-HAND MID CABIN EXIT CAP STRAP AT FORWARD UPPER CORNER. REPAIRED IAW HORIZON AIR EA 9-53-77C.SDR HNAA9900038Mat · out of positionNOSE GEAR DID NOT RETRACT WHEN SELECTED UP. FOUND ALTERNATE EXTENSION DOOR AJAR. SEATED DOOR AND CYCLED GEAR. OPERATION NORMAL. ON FOLLOWUP, TRIMMED RUBBER FLOOR MAT AWAY FROM DOOR. DOOR SEATS NORMALLY.SDR PCAA9900002Pcu · malfunctionedAFTER TAKEOFF FROM MDT, THE CREW EXPERIENCED A NR 2 ENGINE TORQUE FLUCTUATION ASSOCIATED WITH A PROPELLER RPM FLUCTUATION, OIL PRESSURE REMAINED NORMAL. THE AIRCRAFT RETURNED TO THE FIELD AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND THE NR 2 SDR CA990412010Sensor · failed(CAN) RIGHT GEAR DOOR LIGHT CAME ON IN CRUISE. WENT OUT AFTER 20 MINUTES. DOOR PROXIMITY SWITCH REPLACED AND RIGGED.SDR PCAA9900001Spring · detachedPASSENGER DOOR WOULD NOT CLOSE. MAINTENANCE INSPECTED AND FOUND THE FLIP UP FLOOR BOARD SPRING DETACHED. REATTACHED SPRING, OPERATIONAL CHECK GOOD.SDR CA990330016Bearing · failed(CAN) ON PROPELLER INSPECTION, ONE BLADE WAS NOTICEABLY LOOSE. THE NR 2 BLADE WAS REMOVED AND THE PROP BEARING OUTER RACE WAS FOUND BROKEN IN TWO PIECES. THE EDGE OF THE SAME RACE WAS CHIPPED AT APPROXIMATELY 180 DEGREES OPPOSITE THE BROKEN AREA. FURTHER INSDR HNAA9900037Seat · out of positionUNABLE TO REMOVE RIGHT HAND AFT FIRE BOTTLE FROM BULKHEAD. REPOSITIONED ROW 9 SEAT.SDR HNAA9900036Strut · brokenPASSENGER DOOR WOULD NOT OPEN. FORWARD UPPER DOOR SUPPORT STRUT BROKEN. REPLACED FORWARD SUPPORT STRUT (TUBE ASSY).SDR CA990330039Plug · leaking(CAN) IN-FLIGHT, HYDRAULIC LEAK. RETURNED TO YOW. PLUG IN NR 2 MANIFOLD FOUND LOOSE AND NOT LOCKWIRED.SDR CA990330007Switch · intermittent(CAN) AUTOFEATHER LIGHT CAME ON DURING TAKEOFF WITH SWITCH IN THE OFF POSITION. TAKEOFF ABORTED. CONTAMINATED BY COFFEE/POP.SDR HNAA9900035Sensor · damagedAFTER DEPARTURE GEAR RETRACTED, RIGHT HAND MAIN GEAR RED LIGHT DID NOT ILLUMINATE AND THE GREEN LIGHT STAYED ON. CYCLED GEAR, NO CHANGE. REPLACED RIGHT HAND DOWNLOCK PROXIMITY SENSOR DUE TO DAMAGED WIRING AND CONDUIT.SDR CA990412009Line · chafed(CAN) HYDRAULIC LINE FROM NR 1 SPOILER DUMP VALVE LEAKING. LINE REPLACED.SDR CA990318056Hinge · broken(CAN) WEIGHT-ON-WHEEL (WOW) CAUTION LIGHT ILLUMINATED AFTER TAKEOFF. NLG WOW SENSOR COVER ROTATED AND DAMAGED BOTH SENSORS. HINGE FOUND BROKEN AT COVER.SDR QXEA9900451Skin · dentedPDX - THERE IS A DENT APPROXIMATELY 3 INCH DIAMETER IN THE FUSELAGE SKIN, UNDER THE RIGHT-HAND ICE SHIELD. REPAIRED IAW -8 MM 20-16-11.SDR QXEA9900450Skin · corrodedPDX - THERE IS LIGHT FRETTING CORROSION IN THE FUSELAGE SKIN AROUND SEVEN SCREW HOLES UNDER THE RIGHT-HAND ICE SHIELD. REPAIRED IAW -8 MM 20-13-11, PAGE 3.SDR QXEA9900443Skin · dentedPDX - DENT IN FUSELAGE SKIN JUST AFT OF LEFT-HAND ICE SHIELD AT STATION 312.350 AND STRINGER 12. REPAIRED IAW HORIZON AIR EA 9-53-442B.SDR CA990330082Tire · failed(CAN) 10 INCH SECTION OF THREAD AND SIDEWALL MISSING AFTER LANDING.SDR CA990330004Indicator · erratic(CAN) TAKEOFF ROLL ,CAPTAIN ASI ERRATIC. REPLACED.SDR CA990318055Line · chafed(CAN) NR 1 NACELLE-EDP CASE DRAIN LINE AND PRESSURE LINE CHAFING TOGETHER CAUSING A HOLE IN CASE DRAIN LINE. LINE REPLACED.SDR HNAA9900034Detector · intermittantSMOKE WARNING ILLUMINATED IN FLIGHT. NO APPARENT CAUSE. COULD NOT DUPLICATE. REPLACED NR 2 (FORWARD) SMOKE DETECTOR AS A PRECAUTION.SDR CA990318054Bushing · sheared(CAN) LEFT NACELLE INBOARD LOWER STRUT TO A FRAME PACKERS. FLANGED BUSHING FOUND SHEARED IN HALF. SB 8-54-19 CW.SDR QXEA9900427Track · corrodedPDX - NR 3 RIGHT-HAND FLAP TRACK HAS LIGHT TO MODERATE SURFACE PITTING ON LOWER TRACK TOP SURFACE IN ROLLER PATH AND UPPER TRACK BOTTOM SURFACE IN ROLLER PATH. REPAIRED IAW HORIZON AIR EA 9-57-406.SDR HNAA9900033Battery · looseFIRST AND THIRD OVERHEAD EMERGENCY LIGHTS INOPERATIVE. RESEATED BATTERY IN 3351-PS3. OPERATIONAL CHECK GOOD.SDR QXEA9900456Skin · corrodedPDX - CORROSION ON BELLY SKIN AROUND TCAS ANTENNA DOUBLER RIVETS. REPAIRED IAW SRM 51-40-11.SDR QXEA9900440Frame · damagedPDX - CHAFE DAMAGE ON RIGHT-HAND CARGO PIT FRAME AT STATION 618 BETWEEN STRINGER 20 TO 22. REPAIRED IAW HORIZON AIR EA 9-53-443.SDR QXEA9900433Link · wornPDX - EXCESSIVE AXIAL PLAY ON INBOARD SIDE OF LINK ASSEMBLY. REPAIRED IAW HORIZON AIR EA 9-54-192.SDR HNAA9900032Unknown · odorDURING TRAINING FLIGH, EXPERIENCED SMOKE-LIKE SMELL IN COCKPIT. UNABLE TO DUPLICATE. NO DISCREPANCY FOUND.SDR CA990330003Eec · malfunctioned(CAN) ON DESCENT, NR 1 ENGINE HAD AN UNCOMMANDED TORQUE ROLLBACK FROM 55 PERCENT TO 15 PERCENT. TEST OF HARNESS SHOWED SOME FAULTS, CONNECTORS CLEANED, NO HARNESS FAULTS FOUND. ENGINE ELECTRONIC CONTROL REPLACED.SDR CA990330002Sensor · contaminated(CAN) DURING TAKEOFF, NR 2 ENGINE TORQUE ROLLED BACK TO 70 PERCENT FROM 90 PERCENT. TAKEOFF SENSOR CLEANED.SDR QXEA9900523Hinge · corrodedYXX - TRAILING RUDDER BOTTOM HINGE HAS PITTING DAMAGE TO FITTING BEARING RETAINING SURFACES. REPAIRED IAW HORIZON AIR EA 9-27-100, DHC-8 SRM 51-20-36, 51-40-00, PAGE 1, PARAGRAPH 2 AND PAGE 2, TABLE 1.SDR QXEA9900438Frame · wornPDX - FRAME 646 AT STRINGER 18 HAS 2 WEAR MARKS FROM GILE LINER SUPPORT BRACKET. REPAIRED IAW SRM 53-20-21, FIGURE 6.SDR QXEA9900437Frame · damagedPDX - FRAME 618 AT STRINGER 18 HAS 2 WEAR MARKS FROM GILE LINER SUPPORT BRACKET. REPAIRED IAW SRM 51-20-11 AND 51-20-16.SDR QXEA9900421Strut · malfunctionYVR- MAIN CABIN DOOR WILL NOT OPEN. MAINTENANCE FERRIED FROM YVR TO PDX FOR REPAIRS. IN PDX, REPLACED FORWARD HANDRAIL STRUT. OPERATIONAL CHECKS GOOD.SDR QXEA9900534Skin · damagedYXX - NR 1 NACELLE OUTBOARD LOWER CORNER AT FORWARD GEAR DOOR CUTOUT OUTER SKIN DAMAGED. REPAIRED IAW DHC-8 RD 8-54-1043.SDR QXEA9900442Sill · damagedPDX - BAGGAGE DOOR CUTOUT UPPER SILL INNER STRAPS HAVE CHAFE DAMAGE. REPAIRED IAW HORIZON AIR EA 9-53-440.SDR QXEA9900430Plate · corrodedPDX - LADDER PLATE UNDER PANEL 521AT HAS FRETTING CORROSION. REPAIRED IAW RD 8-57-592.SDR HNAA9900030Wire · looseLANDING GEAR WOULD NOT EXTEND, GOT THREE RED LIGHTS. CYCLED HANDLE NUMEROUS TIMES. PERFORMED ALTERNATE GEAR EXTENSION, LANDED NORMAL. RESEATED CONNECTOR ON LANDING GEAR SELECTOR. TIGHTENED LOOSE WIRE ON LANDING GEAR INHIBIT SWITCH AND CONFIRMED POWER TO LASDR QXEA9900541Web · gougedYXX - GOUGES ON WEB BESIDE BAGGAGE DOOR FITTINGS. REPAIRED IAW DHC 8 SRM 51-20-16, 51-20-36, CONAIR EO 2214, HORIZON AIR EA 9-53-425 AND DHC 8 RD 8-53-4033.SDR QXEA9900521Skin · dentedYXX - DENT ON FUSELAGE SKIN AT X487.5 TO S521 AND STRINGERS 21S AND 22S. REPAIRED IAW HORIZON AIR EA 9-53-939 AND DHC-8 RD 8-53-4082.SDR QXEA9900512Skin · damagedYXX - DENT AND GOUGE ON FUSELAGE EXTERIOR AT STA 607 AND BELOW STRINGER 21. REPAIRED IAW RD 8-53-4026, DHC-8 SRM 51-20-16 AND 51-20-36.SDR QXEA9900445Angle · crackedPDX - RIGHT-HAND AFT WING SPAR TO FUSELAGE CLOSING ANGLE IS CRACKED. REPAIRED IAW SRM 51-40-11.SDR QXEA9900444Angle · crackedPDX - LEFT-HAND AFT REAR WING SPAR TO FUSELAGE CLOSING ANGLE IS CRACKED. REPAIRED IAW SRM 51-40-11.SDR QXEA9900441Frame · dentedPDX - RIGHT-HAND CARGO PIT FRAME IS DENTED AT STATION 580.5 AND STRINGER 22. REPAIRED IAW HORIZON AIR EA 9-53-437.SDR QXEA9900420Wire · brokenPDX- AFT SMOKE DETECTOR LIGHT STAYS ON. MAINTENANCE REPAIRED BROKEN WIRES 2612-4A22 AT CONNECTION 2612-P2. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR HNAA9900029Valve · inopGEAR WOULD NOT EXTEND ON FIRST TWO ATTEMPTS. REPLACED LANDING GEAR SELECTOR VALVE.SDR CA990412008Line · chafed(CAN) HYDRUALIC LEAK AT NR 1 DUMP VALVE PRESSURE LINE. NEW LINE INSTALLED.SDR QXEA9900439Sill · crackedPDX - PILOT SIDE WINDOW LOWER SILL JOINT TO SIDE POST HAS A 1 INCH CRACK. REPAIRED IAW RD 8-53-576.SDR QXEA9900517Skin · dentedYXX - DENT DAMAGE BETWEEN STRINGER 19S AND 20S AT FUSELAGE STATION 580.50 AND 600. REPAIRED IAW DHC-8 RD 8-53-4052.SDR QXEA9900516Skin · dentedYXX - DENT BETWEEN FRAMES 270.5 AND 291.4 AT LEFT-HAND SIDE OF STRINGERS 3 AND 4. REPAIRED IAW DHC-8 RD 8-53-4046.SDR QXEA9900513Skin · dentedYXX - TWO DENTS ABOVE STRINGER 29, RIGHT-HAND SIDE BELOW LAVATORY SERVICE PANEL AT STA 201 TO 222. REPAIRED IAW DHC-8 RD 8-53-4086, SRM 51-40-00 SRM 51-20-16 AND SRM 51-20-36.
Back to Boeing DHC-8-102