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 QXEA0002546Skin · chafedYXX- LEFT HAND OUTBOARD FLAP ASSEMBLY CHAFED AT REAR SPAR, TOP SKIN. REPAIRED IAW DHC-8 SRM 51-20-11, AND RD8-57-1777, AND HORIZON AIR EA 9-57-517.SDR QXEA0002543Angle · chafedYXX- LEFT HAND HORSE COLLAR HAS CHAFE DAMAGE AT LOWER FORWARD ANGLE AT STATION XN60.00 AND YW 164.00. REPAIRED IAW DHC-8 SRM 51-20-11, AND EA 9-54-257, AND RD8-54-1346.SDR PCAA0009062Connector · looseON 14SEP00 FLIGHT 3661 LEAVING BWI HAD SMOKE DETECTOR ILLUMINATED IN FLT FOR 5 SECONDS. AIRCRAFT THEN RETURNED TO THE FIELD. MAINTENANCE SECURED A LOOSE CANNON PLUG ON THE BULKHEAD SMOKE DETECTOR, OPERATIONAL CHECK WAS GOOD. AIRCRAFT WAS THEN RETURNED TO SESDR PCAA0009061Structure · crackedMDT- DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED OVER A PREVIOUS REPAIR AT FRAME 4 IN APU AREA. CRACK WAS REPAIRED IN ACCORDANCE WITH REPAIR DRAWING RD8-55-199. AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR CA000925017Screw · broken(CAN) DURING SCHEDULED INSPECTION OF THE COCKPIT WINDOW SURROUND AND ATTACHMENT AS INDICATED IN TASK 5310/07B, ONE SCREW WAS FOUND TO HAVE THE HEAD MISSING. IT WAS LOCATED ON THE LOWER EDGE OF THE CAPTAINS SIDE WINDOW. THE SCREW WAS REPLACED AND THE AIRCRAFT WSDR QXEA0002529Skin · dentedYXX- FUSELAGE EXTERIOR SKIN IS DENTED AT STATION X332 AND STRINGER 14P. REPAIRED IAW DHC-8 SRM 53-00-16, DHC-8 RD 8-53-5298, HORIZON AIR EO 2882, EA 9-53-576 AND HORIZON AIR GMM 5-5-0.SDR QXEA0002526Skin · dentedYXX- EXTERIOR FUSELAGE SKIN IS DENTED AT STATION X290 AND STRINGER 19P AND 20P. REPAIRED IAW DHC-8 53-00-16, 51-00-06, 51-00-05, HORIZON AIR EO 2880 AND EA 9-53-577.SDR QXEA0002524Skin · dentedYXX- FUSELAGE EXTERIOR SKIN IS DENTED IN TWO PLACES AT STATION X330 AND STRINGER 13P. REPAIRED IAW DHC-8 SRM 53-00-16 PAGE 1-6, 53-10-11 PAGE 1-10, 51-00-06, 51-00-05, DHC-8 RD 8-53-5297 AND HORIZON AIR EO 2883 AND EA 9-53-5751.SDR QXEA0002517Skin · gougedYXX- LEFT HAND FUSELAGE HAS A GOUGE AND DENT 5.5 INCHES FORWARD OF FRAME X636.000 BETWEEN STRINGER 15 AND 16. REPAIRED IAW DHC-8 SRM 51-13-01 PAGE 1-15, 51-20-26 PAGE 6, 51-00-05, 51-20-11 PAGE 5 AND DHC-8 RD 8-53-5302.SDR QXEA0002545Angle · damagedYXX- REPLACED LEFT HAND FORWARD CLOSING ANGLE. REPAIRED IAW DHC-8 SRM 51-40-11, PAGE 1-4, SRM 51-40-00, PAGE 1-5.SDR HNAA0000067Module · failedLT FWD GEAR DOOR STAYED OPEN AFTER GEAR RETRACTION. REMOVED AND REPLACED TERMINAL BLOCK 9811TB7 MODULE, OPS CHECK GOOD.SDR QXEA0002522Skin · gougedYXX- GOUGE 8 INCHES FORWARD OF FUSELAGE STATION X564.500 BETWEEN STRINGER 3L AND 4L. REPAIRED IAW DHC-8 SRM 53-00-16 PAGE 3, 51-20-00 PAGE 5,51-00-06, 51-00-05, 20-34-11 PAGE 17, DHC-8 RD 8-53-5300, HORIZON AIR EO 2884 AND EA 9-53-574.SDR QXEA0002544Angle · damagedYXX- REPLACED LEFT HAND AFT CLOSING ANGLE. REPAIRED IAW DHC-8 SRM 51-20-00, PAGE 5.SDR QXEA0002510Stringer · corrodedYXX- STRINGER 29 CORRODED AT METAL STANDOFF OF STATION X175. REPAIRED IAW DHC-8 SRM 51-20-11.SDR QXEA0002552Angle · damagedYXX- REPLACED RIGHT HAND CLOSING ANGLE. REPAIRED IAW DHC-8 SRM 51-20-00, PAGE 5, AND SRM 51-40-00, PAGE 1-5.SDR QXEA0002542Frame · damagedYXX- FRAME X387 AT STRINGER 75 HAS ENLARGED RIVET HOLE. REPAIRED IAW DHC-8 SRM 51-10-36, AND SRM 51-20-16, PAGE 1-5, AND SRM 53-20-21.SDR QXEA0002540Angle · corrodedYXX- BAGGAGE DOOR CUTOUT X597 297 X30 LEFT HAND ANGLE FROM FRAME TO DOOR SILL IS CORRODED. REPAIRED IAW DHC-8 SRM 51-20-00, PAGE 5, AND SRM 53-00-16, PAGE 4.SDR QXEA0002535Pressure Panel · scratchedYXX- SCRATCH AT STATION Z104.0 AND Y40.95 ON INSIDE OF REAR PRESSURE DOME. REPAIRED IAW DHC-8 SRM 51-20-26, PAGE 6, SRM 51-13-01, PAGE 1-15, SRM 51-20-11, PAGE 1-10, SRM 51-20-16, PAGE 1-5 EA 9-53-573.SDR QXEA0002534Pressure Panel · scratchedYXX- SCRATCH AT STATION Z135.0 AND Y50.0 ON INSIDE FACE OF REAR PRESSURE DOME. REPAIRED IAW DHC-8 SRM 51-20-26, PAGE 6, SRM 51-13-01, PAGE 1-15, SRM 51-20-11, PAGE 1-10, SRM 51-20-16, PAGE 1-5 AND RD8-53-5301 AND EA 9-53-573.SDR CA000925020Wheel · cracked(CAN) DURING SCHEDULED NDT, AN OUTBOARD WHEEL HALF WS FOUND TO BE CRACKED BEYOND LIMITS IN THE BEAD SEAT AREA. THE WHEEL HALF WAS REPLACED.SDR CA001228017Doubler · cracked(CAN) DURING FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME NR 4, STRINGER NR 4 PORT SIDE, CRACK WAS REPAIRED USING DEHAVILLAND REPAIR DWG (RD8-55-199).SDR QXEA0002523Strap · lightning strikeYXX- LONGITUDINAL JOINT STRAP HAS A LIGHTNING STRIKE ON RIVET AT STATION X151 AND STRINGER 22P. REPAIRED IAW DHC-8 SRM 51-40-00 PAGE 1-6 AND 51-40-11 PAGE 1-4.SDR QXEA0002513Bulkhead · chafedYXX- FORWARD PRESSURE BULKHEAD, FORWARD FACE AT STATION Y9.0 AND Z95.0 HAVE CHAFE MARKS. REPAIRED IAW DHC-8 SRM 51-20-11, 53-00-16 AND 51-20-00 PAGE 5.SDR QXEA0002512Structure · crackedYXX- CRACKS FOUND ON LEFT HAND NOSE LANDING GEAR BOX STATION X97.0, Y12.5 AND Z110.0. REPAIRED IAW DHC-8 SRM 51-20-00 PAGE 5, 51-30-21, AND DHC-8 RD 8-53-1676.SDR QXEA0002554Skin · gougedYXX- UPPER EDGE OF BAGGAGE DOOR OUTER SKIN GOUGED AT X564.5. REPAIRED IAW RD8-52-025.SDR QXEA0002541Threshold · tool damageYXX- BAGGAGE DOOR CUTOUT UPPER SILL HAS TOOLING DAMAGE AROUND RIVET HEAD AT X567 Z160. REPAIRED IAW DHC-8 SRM 51-40-11, PAGE 1-4, AND SRM 53-00-16.SDR QXEA0002539Floor Support · corrodedYXX- FLOOR PANEL SUPPORT ANGLE ON LEFT HAND SIDE OF LOWER BAGGAGE PIT AT STATION X597.5 HAS SURFACE CORROSION. REPAIRED IAW DHC-8 SRM 53-00-16, SRM 51-20-00, PAGE 5.SDR QXEA0002533Frame · chafedYXX- FORWARD SPAR FRAME AT X387.35 CHAFED AT GROUND STRAP ATTACH POINT STRINGER 7L. REPAIRED IAW DHC-8 SRM 53-00-16, SRM 51-20-11, AND SRM 51-20-00, PAGE 5.SDR PCAA0009060Structure · crackedMDT- DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4 STRINGER 4 IN APU AREA. CRACK WAS REPAIRED IN ACCORDANCE WITH DEHAVILLAND REPAIR DRAWING RD8-55-199. AIRCRAFT WAS THEN RETURNED TO SERVICE.SDR HNAA0000066Strut · brokenPAX DOOR HEAVY, ALREADY INFO''D. FOUND FWD STRUT SHEARED AND FOUND GAS STRUT UPPER ATTACH BRACKETS BENT. REMOVED AND REPLACED FORWARD AND AFT AIRSTAIR DOOR STRUT AND REMOVED AND REPLACED SLIDE ASSY.SDR CA000925019Controller · failed(CAN) THE FLIGHT CREW REPORTED THAT THE R/H WINDSHIELD HOT CAUTION LIGHT AND ILLUMINATED. MAINTENANCE REPLACED THE WINDSHIELD HEAT CONTROLLER AND THE AIRCRAFT WAS RETURNED TO SERVICE. THE CONTROLLER HAD BEEN INSTALLED 2 DAYS, 12:28 HOURS AND 19 CYCLES PREVIIOUSDR CA000925018Heater · failed(CAN) - DURING ROUTINE MAINTENANCE, NR 3 BLADE ON NR 2 PROP WAS FOUND TO HAVE A BURNED BLADE HATER. NR 1 AND NR 3 BLADES WERE REPLACED AS A MATCHED SET AND THE AIRCRAFT WAS RETURNED TO SERVICE. THE BLADE HISTORY SHOWS NO EVIDENCE OF THE HEATER EVER BEING CHANSDR QXEA0002537Door Frame · corrodedYXX- LEFT HAND EMERGENCY EXIT LOWER SILL STRUCTURE AT STATION X366.0 HAS CORROSION ON INTERNAL FRAMES. REPAIRED IAW DHC-8 SRM 51-20-11, PAGE 1-10, AND SRM 51-20-00, PAGE 5.SDR QXEA0002536Door Frame · corrodedYXX- RIGHT HAND EMERGENCY EXIT LOWER SILL STRUCTURE AT STAION X370 HAS CORROSION ON INTERNAL FRAME. REPAIRED IAW DHC-8 SRM 51-20-11, PAGE 1-10, AND SRM 51-20-00, PAGE 5.SDR CA001006002Line · failed(CAN) DEPLETION OF NR 1 & 2 HYDRAULIC SYSTEM FLUID LEVELS DUE TO LEAK THROUGH THE SIDEWALL OF NR 1 BRAKE FLEXIBLE HYDRAULIC LINE. (THIS LINE WAS INSTALLED ON A/C AUG. 5/98) WE SUSPECT THE HYDRAULIC LINE FAILURE WAS DUE TO FATIGUE. THERE IS NO VISIBLE DAMAGE TOSDR QXEA0002489Sign · malfunctionedSEA- FLIGHT COMPARTMENT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FLIGHT COMPARTMENT EMERGENCY LIGHT AS REQUIRED. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR CA000926003Starter Gen · malfunctioned(CAN) SHORTLY AFTER TAKEOFF THE FLIGHT CREW REPORTED THAT THE NR 1 DC GENERATOR HOT CAUTION LIGHT ILLUMINATED. THE LIGHT WENT OUT AFTER GENERATOR WAS SELECTED OFF.AIRCRAFT RETURNED TO YYC AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED THE NR 1 STARTER GENERSDR CA001228015Doubler · cracked(CAN) DURING FLEET INSPECTION REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME NR 4, STRINGER NR 4, PORT SIDE, CRACK WAS REPAIRED USING DEHAVILLAND REPAIR DWG (RD8-55-199).SDR QXEA0002530Frame · gougedYXX- GOUGE ON FORWARD FRAME OF STATION X222 OF CUTOUT FOR AIRSTAIR DOOR ABOVE FORWARD LOWER DOOR STOP. REPAIRED IAW DHC-8 SRM 53-00-16 AND 51-20-00 PAGE 5.SDR PCAA0009059Structure · crackedMDT- DURING A FLEET INSPECTION, THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED, (VERIFIED WITH EDDY CURRENT CHECK) AT FRAME NR 4 STRINGER NR 4 LT SIDE 1ST RIVET HOLE. CRACK WAS REPAIRED PER RD 8-55-199. AIRCRAFT WAS RETURNED TO SERVICE.SDR AU000738Landing Gear · faulty(AUS) NOSE LANDING GEAR WOULD NOT EXTEND BY NORMAL MEANS (THREE ATTEMPTS). NLG FINALLY EXTENDED USING THE EMERGENCY SYSTEM.SDR AU000699Lever · cracked(AUS) OUTBOARD GROUND SPOILER LEVER CRACKED.SDR AU000684Heater · overheated(AUS) STRONG ELECTRICAL SMELL EMANATING FROM THE AREA OF THE RT EMERGENCY CUPBOARD. INVESTIGATION COULD FIND NO SIGNS OF SMOKE OR FIRE. NR 2 URN WAS FOUND TO BE EMPTY OF WATER.SDR AU000650Tire · deflated(AUS) NOSE WHEEL TYRES DEFLATED.SDR AU000640Seat Belt · failed(AUS) SEAT BELT LIFT UP RELEASE MECHANISM SPLIT DOWN THE CENTRE. THEASSEMBLY IS MANUFACTURED FROM A PLASTIC COMPOUND. A TOTAL OF FIFTEEN ASSEMBLIES HAVE BEEN FOUND DAMAGED.SDR AU000621Torque Link · misinstalled(AUS) RT MLG TORQUE LINKS REVERSED AT REINSTALLATION FOLLOWING BUSHING REPLACEMENT. PERSONNEL / MAINTENANCE ERROR.SDR CA000925026Oil Cooler · leaking(CAN) THE FLIGHT CREW REPORTED A LOW OIL PRESSURE INDICATION ON NR 1 ENGINE DURING CRUISE FLIGHT. A PRECAUTIONARY SHUTDOWN WAS PERFORMED AND THE AIRCRAFT PROCEEDED TO AN ALTERNATE AIRPORT WHERE THEY LANDED UNEVENTFULLY. MAINTENANCE INVESTIGATION REVEALED THAT SDR QXEA0002525Skin · scratchedYXX- EXTERIOR FUSELAGE SKIN IS SCRATCHED AT STATION X345 AND STRINGER 16P. REPAIRED IAW DHC-8 SRM 51-20-11 PAGE 1-10, 51-20-16 PAGE 1-6, 51-20-46 PAGE 1-4, 53-00-16, AND 20-34-11 PAGE 17.SDR QXEA0002531Frame · scratchedYXX- SCRATCH ON PILOTS WINDSCREEN FRAME LOWER MOUNTING SURFACE AT X118 AND 47.0. REPAIRED IAW DHC-8 SRM 51-20-11 PAGE 1-10, 53-00-16, 51-20-16 AND 51-20-36 PAGE 1-8.SDR QXEA0002528Skin · scratchedYXX- FUSELAGE EXTERIOR SKIN IS SCRATCHED AT STATION X356 AND STRINGERS 17P AND 18P. REPAIRED IAW DHC-8 SRM 51-20-11 PAGE 1-10, 51-20-16 PAGE 1-6, 51-20-46 PAGE 1-4, 53-00-16 PAGE 2 AND 20-34-11 PAGE 17.
Back to Boeing DHC-8-102