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 CA110607005Actuator · failed(CAN) ON TAKEOFF (AT ABOUT 50 IN THE CLIMB) THE LT INBD ROLL SPOILER DEPLOYED UN-COMMANDED. PASSING THROUGH 1500 IT RETRACTED. THE ACFT RETURNED TO THE BASE WITH NO FURTHER ISSUES. THE LT INBD ROLL SPOILER ACTUATOR WAS FOUND AT FAULT AND WAS REPLACED. SPOISDR HNAA2011061300163Wire · brokenDURING RETURN TO FIELD, FLAPS WOULD NOT EXTEND, FOUND C/B L7 ON LT ESSENTIAL POPPED. FOUND WIRE BROKEN AT FLAP ARMING SWITCH, WILL SOLDER AND OPS CHECKED FLAP. NO FIX. REMOVED RELAY 2752 K1 CIRCUIT BREAKER STILL POPS, REINSTALLED RELAY.SDR HNAA2011060100162Unknown · odorMINOR COCKPIT SMOKE IN FLIGHT, THEN CB'S F8, F9 AND G9 POPPED AND SMOKE STOPPED (INVERTER BREAKER). COMPLIED WITH HIDDEN DAMAGE INSPECTION WITH NONE NOTED. RESET C/B'S F8, F9 AND G9. GROUND RAN ACFT WITH C/B F8 POPPING WITH IN 5 SECONDS, ALL OTHER INVERTERS OSDR HNAA2011060100160Wire Harness · miswiredPANEL 143BZ (CTR FLOOR) EMERGENCY LIGHTS DO NOT COME ON AND DIM ALL OTHER EMERGENCY LIGHTS WHEN PLUGGED IN. R & R POWER SUPPLY BASE AND BATTERY, NO FIX. FOUND LIGHT HARNESS AT THIS LOCATION WIRED INCORRECTLY. REWIRED HARNESS. FLOOR EMERGENCY ESCAPE LIGHTS OPSDR HNAA2011060100157Frame · corrodedRIB AT X222, STRINGER 30-31 HAS CORROSION. REMOVED VERTICAL FLOOR SUPPORT FRAME. REMOVED RIB SECTION AT X222 BETWEEN STRINGERS 32P AND 28S. COMPLIED WITH HFEC INSPECTION, NO DEFECTS NOTED. SPLICE FRAME AT X222 IAW EO8-53-11-0289.SDR HNAA2011060100156Frame · corrodedRIB AT X240.5, STA. 31S HAS CORROSION. REMOVED RIB SECTION AT X240.5 BETWEEN STRINGER 32P AND STRINGER 28S. COMPLIED WITH HFEC IAW EO8-53-11-0289. NO DEFECTS NOTED. SPLICE FRAME AT X240.5 IAW EO8-53-11-0289.SDR HNAA2011060100155Battery · failedTWO EMERGENCY FLOOR PATH LIGHTS ARE INOP AT THE FIRST ROW. REMOVED EMERGENCY LIGHT BATTERY COVER AT ROW 3 CEILING. R & R BATTERY PS4. INSTALLED COVER.SDR HNAA2011052300151Bulb · inoperativeROW 4DF SIDEWALL EMERGENCY LIGHT HAS 1 INOP BULB. REMOVED AND REPLACED BULB, OPS CHECKED GOOD.SDR HNAA2011060100152Wire · crossedABORTED TAKEOFF DUE TO PEGGED NR 2 ITT GAGE WITH AMBER LIGHT AND NO OTHER UNUSUAL INDICATIONS. INSPECTED NR 2 ENGINE HOT SECTION, FOUND 3 THERMOCOUPLE WIRES CROSSED, REPOSITIONED WIRES, GROUND RAN NR2 ENGINE, OPS CHECKED GOOD.SDR HNAA2011052300150Tru · failedRIGHT AC BUSS CAUTION LIGHT ILLUMINATED INFLIGHT ASSOCIATED WITH OTHER CAUTION LIGHTS. REMOVED AND REPLACED RT TRU IAW 24-31-00, OPS CHECKED GOOD.SDR HNAA2011052300149Radar · failedRADAR FAILED INFLIGHT. INSPECTED AND FOUND MOISTURE INSIDE RADOME. REMOVED MOISTURE AND OPS CHECKED GOOD.SDR HNAA2011051700141Switch · inoperativeABORTED TAKEOFF DURING TAKEOFF ROLL. AUTOFEATHER DID NOT ARM. R & R SWITCH 6121-S13. GROUND RUN OPS CHECKED GOOD IAW RUNUP MANUAL.SDR HNAA2011051700138Switch · inoperativeABORTED TAKEOFF AUTOFEATHER WILL NOT ARM. CYCLED POWER LEVERS, OPS CHECKED NORMAL. R & R SWITCH 6121-S13. GROUND RUN, OPS CHECKED GOOD IAW RUNUP MANUAL.SDR HNAA2011051700137Battery · failed2 RED FLOOR LIGHTS AT ROW 1 ARE INOP. R & R BOTH FLOOR MODUALS, NO FIX, LOWERED PSU AT 7AC, REPLACED EMERGENCY LIGHT BATTERY, RESECURED PSU, OPS CHECKED GOOD.SDR CA110527001Engine · power loss(CAN) LOSS OF TORQUE/IFSD DURING CLIMB AFTER T/O, THE NR 1 ENGINE FUEL FLOW NH SPEED DROPPED AND THE TORQUE WENT DOWNTO 40 PERCENT ACCOMPANIED BY SURGING. THE ENGINE UPTRIM CAME ON FOR THE NR 2 ENGINE, THEN THE NR 1 ENGINE STARTED TO SURGE AGAIN AND THE TORQSDR CA110511007Line · leaking(CAN) DURING THE GEAR EXTENSION THE LT MLG ACTUATOR DOWN PRESSURE FLEX LINE BROKEN. THE LINE WAS REPLACED AND GEAR SWINGS CARRIED OUT WITH NO DEFECTS NOTED.SDR HNAA2011051700143Light · malfunctionedLT AFT EMERGENCY EXIT BETA LIGHT IS DIMMER THAN THE CAMPARING LIGHT. R & R LIGHT USING ATTACHING HARDWARE.SDR HNAA2011051700142Light · malfunctionedRT AFT EMERGENCY EXIT BETA LIGHT IS DIMMER THAN COMPARING LIGHT. R & R USING ATTACHED HARDWARE.SDR HNAA2011051700136Light · malfunctionedRT FWD EMERGENCY EXIT BETA LIGHT IS DIMMER THAN THE COMPARING LIGHT. R & R LIGHT USING ORIGINAL ATTACHED HARDWARE.SDR HNAA2011062400197Window Frame · corrodedRT NR 8 CABIN WINDOW AT X456.500 HAS CORROSION ON LOWER PORTION AT STR 168. REMOVED ALL CORROSION AT RT NR 8 CABIN WINDOW FRAME IAW -8,-100, RD8-53-623. PERFORMED HFEC INSPECTION IAW -8 -100 SERIES NTM 51-00-06. NO DEFECTS NOTED.SDR HNAA2011062400196Cable · rustedGUST LOCK CABLES AFT, ON WING, TOP OF FUSELAGE ARE RUSTED. R & R GUST LOCK CABLE IAW MM 27-70-00. PERFORMED RIGGING OF GUST LOCK CABLE IAW DASH 8 -100 MM 27-70-00.SDR HNAA2011062300189Control Cable · corrodedMLG ALTERNATE EXTENSION SYS CONTROL CABLE SHOWING SIGNS OF CORROSOIN IN MAIN LANDING GEAR WELL TO REAR DOOR RELEASE. R & R LEFT MLG ALTERNATE EXTENSION SYS CONTROL CABLE IAW -8 -100, MM 32-35-00.SDR HNAA2011062300188Sill · corrodedCORROSION AFT PAX DOOR LOWER SILL AT DOOR SEAL INFLATION FITTING. REMOVED CORROSION IAW SRM 51-20-11. FOUND TO BE WITHIN LIMITS, TREATED WITH ALODINE, PRIMED IAW -8 -100 SRM51-20-26.SDR HNAA2011062400194Shaft · corrodedPAX DOOR HAND RAIL STRUT SHAFT BEARINGS WORN AND CORRODED. R & R PAX DOOR HAND RAIL STRUT SHAFT, FORK AND BUSHINGS IAW -8 -100 MM 20-12-04.SDR HNAA2011062300183Frame · corrodedFRAME AT X202.75, STR 31S IS CORRODED AND THE CORROSION GOES BETWEEN THE TENSION FITTING AND FLOORBEAM SUPPORT STRUT. CORROSION GOES FROM 30S TO 32S. REMOVED FRAME X202.75 BETWEEN STR 28S AND STR 28P. REPLACED WITH NEW FRAME, REMOVED RT FORWARD TENSION FITTSDR HNAA2011062400195Shaft · corrodedSHAFT FOR AFT PAX DOOR HANDRAIL PITTED AND CORRODED. R & R SHAFT FOR AFT PAX DOOR HANDRAIL IAW MM 52-10-00.SDR HNAA2011051700135Flap Track · corrodedRT NR 2 FLAP TRACK HAS PITTING AND CORROSION ON MATING SURFACE AND HEAVY WEAR AND PITTING ON ROLLER SURFACE. R & R FLAP TRACK WITH NEW HARDWARE IAW AMM57-50-26.SDR HNAA2011052300145Threshold · corrodedPAX DOOR THRESHOLD IS CORRODED. R & R THRESHOLD ASSY, INSTALLED THRESHOLD ASSY IAW ENG DRAWING 85321241.SDR HNAA2011051700130Fitting · corrodedRT NR1 FLAP TRACK THROUGH BOLT FITTING IS CORRODED. R & R NECESSARY HARDWARE WITH NEW HARDWARE.SDR HNAA2011051700134Skin · corrodedSEVERAL AREAS OF CORROSION AT UPPER END OF PAX DOOR SKIN. R & R PAX DOOR SKIN.SDR HNAA2011051700133Floor Support · corrodedLAV FLOOR ANGLE BRACKET IS CORRODED. REMOVED LOWER AND UPPER ANGLE. FABRICATED NEW ANGLES FROM 2024-T3 .040 ALUMINUM, ALODINED, PRIMED AND INSTALLED IAW DWG 82540006 WITH NEW HARDWARD AND BONDED.SDR HNAA2011051700132Structure · crackedINTERNAL STRUCTURE HAS SMALL CRACKS EMINATING FROM A RIVET AT LOWER AFT CORNER ON LT MID EMERGENCY EXIT. FURTHER INSP FOUND STRUCTURE AT HOLE BOWED OUT, CAUSING EDGE CRACKS. COLD WORKED METAL BACK INTO SHAPE, UPSIZED HOLE 1 STANDARD SIZE, WHICH CLEANED UP DASDR HNAA2011051700131Flap Track · corrodedRT NR 1 FLAP TRACK HAS CORROSION ON THE MATING SURFACE AND HEAVY WEAR AND PITTING ON THE ROLLER SURFACE. R & R FLAP TRACK WITH NEW HARDWARE IAW AMM 57-50-11.SDR HNAA2011050600110Switch · failedPAC HOT CAUTION LIGHT FLICKERED ON AND OFF. STOPPED CYCLING WITH BLEEDS SELECTED OFF, STRONG HOT ODOR WITH POWER SETTINGS REDUCED. R & R ACM OVERTEMP SWITCH IAW 21-50-31 AND OPS CHECKED GOOD.SDR HNAA2011062400193Support Channel · corrodedPAX DOOR THRESHOLD SUPPORT CHANNEL CORRODED. BLENDED OUT CORROSION AT PAX DOOR THRESHOLD SUPPORT CHANNEL AND WAS FOUND TO BE OUT OF LIMITS IAW -8 RD8-53-8921. REPLACED THRESHOLD SUPPORT IAW SRM 51-40-11, ALODINE, PRIMED IAW SRM 51-20-26.SDR CA110504004Mount · cracked(CAN) ON ACFT, THE RT WING, OTBD ROLL SPOILER ACTUATOR MOUNTING BRACKET, PN 85710559-001, WAS FOUND CRACKED AND FLEXING.SDR HNAA2011062400192Seat Track · corrodedRIGHT MID SEAT RAIL HAS NICKS AND CORROSION THE ENTIRE LENGTH ON INBD SEAT RAIL. REPAIRED SEAT RAIL IAW RD8-53-1339. FOUND TO BE WITHIN LIMITS OF RD. HFEC INSPECTION PERFORMED IAW NTM 51-00-06. NO DEFECTS NOTED.SDR HNAA2011062400191Seat Track · corrodedLEFT MID SET RAIL HAS NICKS AND CORROSION THE ENTIRE LENGTH ON THE INBD SEAT REAL. REPAIRED SEAT RAIL IAW RD8-53-1339. FOUND TO BE WITHIN LIMITS OF RD. HFEC INSPECTION PERFORMED IAW DHC 8-100 SERIES NTM 51-00-06. NO DEFECTS NOTED.SDR HNAA2011062400190Seat Track · corrodedRIGHT SEAT RAIL HAS NICKS AND CORROSION THE ENTIRE LENGTH BETWEEN X548.1 TO X593.062. REPAIRED SEAT RAIL IAW RD8-53-784. FOUND TO BE WITHIN LIMITS OF RD8-53-784. HFEC INSP PERFORMED IAW -8, -100 NTM 51-00-06. NO DEFECTS NOTED.SDR HNAA2011062300186Skin · corrodedSURFACE CORROSION ON ACFT SKIN AT STATION X510.000 AND Z81.000. REMOVED CORROSION ON ACFT SKIN AT STA X510.00 AND Z81.000. FOUND TO BE IN LIMITS IAW SRM CHAPTER 53-00-16. ALODINE, PRIMED AND PAINTED IAW CH 51-20-16.SDR HNAA11062300186ADoor · corrodedLAV SERVICE PANEL HAS CORROSION AROUND WASTE DRAIN. REMOVED DAMAGE IAW RD8-53-2103. HFEC INSP WAS PERFORMED IAW NTM 51-00-06. NO DEFECTS NOTED. NO LEAKS NOTED IAW MM 21-30-00.SDR HNAA2011050600108Generator · failedRT AC BUSS CAUTION LIGHT ILLUMINATED ALONG WITH ASSOCIATED CAUTION LIGHTS DURING FLIGHT AND RETURN TO DEPARTURE AFTER CONFERING WITH AFTER ENGINE SHUTDOWN, NR 1 AC GENERATOR CAUTION LIGHT DID NOT ILLUMINATE, BUT DOES TEST. REMOVED NR 2 AC GENERATOR. REF WORKSDR HNAA2011062300185Cover · corrodedRT AILERON HINGE COVER HARDWARE CORRODED ON PANELS 643FR, 643ER, 643DR, 643CR, 643BR AND 643GB. REPLACED RT AILERON HINGE COVERS HARDWARE IAW -8 MM 27-12-11.SDR HNAA2011062300182Floor Support · corrodedPAX ENTRANCE FLOORBOARD CHANNEL TRIM HARDWARE CORRODED. R & R PAX ENTRANCE FLOORBOARD CHANNEL TRIM HARDWARE IAW -8-100, MM 25-22-10.SDR HNAA2011062300181Hinge Bracket · corrodedLEFT AND RIGHT PAX DOOR FLOOR HINGE BRACKET HARDWARE CORRODED. R & R PAX DOOR FLOOR HINGE BRACKET HARDWARD IAW -8 MM 20-14-01.SDR HNAA2011050600102Connector · dirtyNR 1 ENG OIL TEMP FLUXS INTO THE RED. ACFT RETURNED TO GATE. CLEANED AND TIGHTENED OIL TEMP GROUND WIRE AND CLEANED AND RESEATED TEMP BULB CONNECTOR PLUG. GROUND RAN ACFT. RAN NORMAL AT THIS TIME.SDR HNAA2011050600101Battery Pack · inoperativeEMERGENCY LIGHT CAUTION LIGHTS DID NOT ILLUMINATE WHEN EMERGENCY LIGHTS WERE TURNED OFF. NOW LIGHTS WILL NOT TURN ON FROM COCKPIT OR F/A STATION. R & R ALL EMERGENCY LIGHT BATTERIES IAW 33-50-03Q, OPS CHECKED GOOD AT THIS TIME.SDR HNAA2011042400081Brush Block · failedWHEN PROP HEAT WAS SELECTED ON EMERGENCY LIGHTS ILLUMINATED AND RT AC BUSS FELL OFF LINE. R & R BRUSH BLOCK AT NR 2 POSITION. OPS CHECKED GOOD.SDR CA110502004Actuator · leaking(CAN) NR 2 HYDRAULIC SYSTEM LEVEL INDICATION SLOWLY DROPPED DURING THE FLIGHT, SHOWED FLUID COMING FROM THE NOSE WHEEL BAY AREA. ACFT RETURNED TO BASE. LEAK FOUND AT NOSE WHEEL STEERING ACTUATOR BLEED NIPPLES. O-RINGS REPLACED WITH SERVICEABLE ITEMS. SYSTESDR CA110427018Actuator · failed(CAN) NR1 ENGINES OIL PRESSURE WAS NOTICED TO BE FLUCTUATING FROM APPROXIMATELY 65 PSI TO 50 PSI. MALFUNCTION WAS CALLED, CREW CHECKED LT ENGINE COWL FOR LEAK AND NOTICED LEAKING OIL AROUND HORSE COLLAR AND UPPER LIP OF INTAKE. THE CREW THEN PROCEEDED TO RET
Back to Boeing DHC-8-102