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 CA981207028Oil Cooler · leaking(CAN) NR 1 ENGINE OIL COOLER LEAKING. THE COOLER WAS REPLACED. PART TC: 3,264.SDR QXEA01780Skin · dentedFUSELAGE RIGHT-HAND SIDE STRINGER 6 STATION X540 DENTED. REPAIRED IAW DHC-8 RD 8-53-3908.SDR QXEA01778Skin · dentedDENT LEFT-HAND SIDE FUSELAGE SKIN STRINGER 28S, JUST FORWARD OF FORWARD PRESSURE BULKHEAD. REPAIRED IAW DHC-8 RD 8-53-3909.SDR QXEA01769Skin · damagedNR 2 NACELLE INBOARD SIDE LOOSE RIVETS AND RIVETS WORN THROUGH SKIN AT STATION XN 134.68. REPAIRED IAW DHC - RD 8-54-983.SDR QXEA01767Skin · damagedNR 2 NACELLE OUTBOARD SIDE LOOSE RIVETS AND RIVETS PULLED THROUGH SKIN AT STATION 134.68 AND 24.25. REPAIRED IAW DHC-8 RD 8-54-983.SDR HNAA9898080Power Supply · inoperativeHVN - FLT 3091 - NUMEROUS INTERIOR/EXTERIOR EMERGENCY LIGHTS OUT. REPLACED ALL EMERGENCY BATTERY POWER SUPPLIES. OPS CHECK GOOD. (M)SDR CA981130017Tube · cracked(CAN) HYDRAULIC LEAK UNDER THE LEFT WING LED TO FINDING A CRACKED TUBE ASSEMBLY.SDR QXEA9801723Light · brokenSEA- LEFT UNDERWING CABIN EMERGENCY LIGHT BROKEN. MAINTENANCE REPLACED LIGHT ASSEMBLY. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR HNAA9899478Connector · looseTPA - FLT 3453 - SMOKE WARNING LIGHT ILLUMINATED TWICE IN FLIGHT AND WENT OUT. FOUND CANNON PLUG ONE-HALF TURN LOOSE ON FORWARD NR 2 SMOKE DETECTOR. INSPECTED PINS AND WIRING. RESECURED AND SAFETIED CANNON PLUG. INSPECTED NR 1 DETECTOR, NO DEFECTS NOTED. SDR HNAA9893477Battery · dischargedFLO - FLT 3252 - EMERGENCY EXIT SIGN ABOVE PASSENGER DOOR WILL NOT ILLUMINATE. REPLACED EMERGENCY BATTERY BASE PS1 IN WARDROBE CLOSET. (M)SDR QXEA01777Fitting · damagedTRAILING RUDDER BOTTOM RADIUS ARM FITTING HAS EXCESSIVE DAMAGE. REPAIRED IAW DHC-8 SRM 51-30-26.SDR QXEA01775Lugs · damagedFORE RUDDER ACTUATOR ATTACHMENT LUGS HAVE MECHANICAL DAMAGE ON BOTTOM SURFACES. REPAIRED IAW DHC-8 SRM 51-30-26.SDR CA981123023Contactor · stuck(CAN) SMOKE SMELL IN FLIGHT DECK AFTER NR 1 ENGINE WAS STARTED. FOUND THE START CONTACTOR WELDED SHUT, WHICH CAUSED THE STARTER TO CONTINUE RUNNING AND OVERHEAT.SDR HNAA9898479Gas Strut · failedCLT - FLT 3212 - PASSENGER DOOR WILL NOT OPEN ALL THE WAY (HALF WAY). REPLACED AFT GAS STRUT ASSEMBLY. OPERATIONAL CHECK GOOD. (M)SDR QXEA01766Tracks · corrodedLEFT-HAND NR 1 AND RIGHT-HAND NR 2 FLAP TRACKS HAVE PITTING CORROSION ON BACK SIDE OF TRACK. REPAIRED IAW DHC-8 RD 8-57-1282.SDR AU981480Sign · misinstalled(AUS) EMERGENCY EXIT LOCATED AT ROW 4 LT WAS INCORRECTLY INSTALLED PREVENTING PRESSURIZATION.SDR AU981469Wire · failed(AUS) NOSE LANDING GEAR PROXIMITY SWITCH CANNON PLUG WIRING FAULTY.SDR CA981125010Pump · failed(CAN) ON TAKEOFF, THE NR 2 ENGINE DRIVEN HYDRAULIC PUMP FAILED.SDR QXEA9801681Air Dist · odorSMELL OF JET FUEL IN THE CABIN AND COCKPIT AFTER TURNING ON NR 2 BLEED. TURNING OFF NR 2 BLEED GETS RID OF THE SMELL. MAINTENANCE PERFORMED AN INSPECTION OF THE BLEED AIR SYSTEM WITH NO DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR CA981125008Relay · shorted(CAN) STRONG ELECTRICAL SMELL ON FLIGHT DECK DURING LANDING. LEFT FLARE LIGHT RELAY 33-40-K2 SHORTED AND ARCING INTERNALLY.SDR CA981116014Centering Mech · cracked(CAN) THE CENTERING MECHANISM FOR THE NOSE GEAR WAS FOUND CRACKED. CRACK ABOUT 3 INCHES LONG.SDR QXEA01776Fitting · damagedFORE RUDDER UPPER FORWARD FAIL-SAFE FITTING HAS FRETTING DAMAGE. REPAIRED IAW DHC-8 SRM 51-40-00, TABLE 1 AND TABLE 4.SDR HNAA9891772Power Supply · inoperativeSBY - FLT 3200 - PASSENGER EXIT SIGN AT BOARDING DOOR INOP. REMOVED AND REPLACED POWER SUPPLY 3351 PS1. OPS CHECK GOOD. (M)SDR QXEA01774Fitting · damagedFORE RUDDER LOWER FORWARD FAIL-SAFE FITTING HAS EXCESSIVE DAMAGE. REPAIRED IAW DHC-8 SRM 51-40-00, PARAGRAPH 2, PAGE 2 TABLE 1 AND PARAGRAPH 3A, PAGE 4, TABLE 4.SDR QXEA01773Fitting · damagedFORE RUDDER TRAILING TOP FAIL-SAFE FITTING HAS MECHANICAL DAMAGE. REPAIRED IAW DHC-8 RD 8-55-123.SDR QXEA01770Skin · crackedFORE RUDDER LEADING EDGE SKIN CRACKED AT BASE ON LEFT SIDE. REPAIRED IAW DHC-8 SRM 51-40-11.SDR CA981113007Connector · burnt(CAN) PITOT TUBE POSITIVE PIN FOUND BURNT INSIDE THE RECEPTACLE. RECEPTACLE BURNT INSIDE AND OUT.SDR CA981113005Pseu · failed(CAN) ON GEAR DOWN SELECTION, THERE WERE 3 GREEN AND 3 RED AND A GEAR HANDLE LIGHT. PSEU REPLACED.SDR AU981449Indicator · malfunctioned(AUS) ENGINE EXPERIENCED A TORQUE SWING OF PLUS OR MINUS 4 PERCENT. INVESTIGATION WAS UNABLE TO RE-PRODUCE THE FAULT. ECU, TSCU, AND TORQUE PROBE CONNECTORS CLEANED AS A PRECAUTION. NO FURTHER OCCURRENCES.SDR QXEA9801548Battery · dischargedCOCKPIT EMERGENCY FLASHLIGHT IS NOT BLINKING. REPLACED BATTERY IN FLASHLIGHT, OPERATIONAL CHECKS GOOD.SDR QXEA9801547Strut · crackedPDX- DURING THE ACCOMPLISHMENT OF A SCHEDULED A CHECK, THE NOSE LANDING GEAR OUTER CYLINDER WAS FOUND CRACKED. THE CRACK WAS ON THE AFT SIDE OF THE OUTER CYLINDER BEGINING AT THE TOP AND EXTENDING 5.5 INCHES VERTICALLY DOWN THE CYLINDER. REPLACED THE NOSE GEASDR HNAA9893670Light · inoperativeCLT - FLT 3138 - ROW 4F EMERGENCY EXIT SIGN IN BROKEN. LIGHTS WORKS OK. REPAIRED EXIT SIGN AS REQUIRED. (M)SDR HNAA9890671Terminal · failedPHL - FLT 3455 - ODOR EVIDENT AT AFT CABIN AND FLIGHT DECK. REPLACED BURNED EXTERNAL LIGHTING RING TERMINAL AND CHAFED WIRE TO TERMINAL X1 OF RELAY 3341-K1. (M)SDR CA981113008Window · cracked(CAN) OUTSIDE PANE OF CAPTAIN'S SIDE WINDOW FOUND CRACKED.SDR QXEA01771Skin · damagedRIGHT-HAND ELEVATOR TOP SKIN STATION YH139.00 TO YH150.00 HAS COUNTER SUNK RIVETS PULLING THROUGH THE SKIN. REPAIRED IAW DHC-8 SRM 51-40-00.SDR CA981113009Spring · broken(CAN) IN TAXI, FLIGHT CREW NOTICED THE GUSTLOCK HANDLE HAD LITTLE OR NO SPRING TENSION WHEN APPLIED. INSPECTION OF THE AILERON SPLITTER QUADRANT AT CENTER WING WAS CARRIED OUT. THE TOP ONE OF THE TWO SPRINGS FOR THE GUSTLOCK LEVER WAS BROKEN AT THE EYE END.SDR CA981113006Line · leaking(CAN) DURING MAINTENANCE, NR 1 SYSTEM'S HYDRAULIC WAS PRESSURIZED AND A CLOUD OF HYDRAULIC FLUID MIST WAS NOTED COMING FROM THE LEFT OUTBOARD WING REAR SPAR AREA. THE LEFT INBOARD ROLL SPOILER LIFT DUMP PRESSURE LINE WAS FOUND LEAKING.SDR QXEA01772Skin · wornLEFT-HAND UPPER ELEVATOR HORN, NUMEROUS LOOSE RIVETS WEARING INTO SKIN. REPAIRED IAW DHC-8 SRM 51-40-11.SDR CA981109031Line · chafed(CAN) LARGE HYDRAULIC LEAK FOUND IN TAIL AREA. WIRING HARNESS FOR RUDDER SYNCHRO TRANSIMTTER CHAFED THROUGH RETURN LINE FOR NR 2 RUDDER ACTUATOR. WIRING HARNESS WRAPPED WITH SPIRAL WRAP. LEAK FOUND IN UPPER PORTION OF LINE JUST BELOW RUDDER SYNCHRO TRANSMISDR CA981109030Line · leaking(CAN) HYDRAULIC LEAK FOUND IN NOSE GEAR WHEELWELL. NOSE GEAR DOOR ACTUATOR CLOSE LINE FOUND LEAKING. LINE HAD A PIN HOLE CAUSED BY CORROSION.SDR AU981490Start/Gen · failed(AUS) STARTER/GENERATOR WENT OFF-LINE AND COULD NOT BE RESET. SUSPECT BRUSH END BEARING FAILED ALLOWING THE ROTOR TO COME IN CONTACT WITH THE STATOR.SDR AU981435Aileron · damaged(AUS) LEFT AILERON TIP DAMAGED IN A GROUND ACCIDENT. PART TC: 24,413.SDR PCAA9800791Battery · overtempEN ROUTE FROM PIT TO IPT, THE MAIN BATTERY HOT CAUTION LIGHT ILLUMINATED AND TEMPERATURE MONITOR ROSE TO 60 DEGREES CELSIUS. THE CREW DIVERTED INTO SCE, AND LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT SYSTEM, FOUND BATTERY AT FAULT. REMOVED AND REPLACESDR QXEA9801680Wheel · crackedNR 4 MAIN WHEEL BROKEN. THE OUTER RIM FAILED AT THE BEAD SEAT. THE CRACK RUNS APPROXIMATELY HALF OF THE WAY AROUND THE BEAD SEAT AREA. REPLACED THE NR 4 WHEEL ASSEMBLY.SDR QXEA9801534Battery · dischargedEMERGENCY FLASHLIGHT NOT BLINKING. REPLACED BATTERY PACK, OPERATIONAL CHECKS GOOD.SDR QXEA9801532Battery · dischargedEMERGENCY FLASHLIGHT BELOW FLIGHT ATTENDANT SEAT NOT FLASHING. REPLACED BATTERY PACK FOR THE EMERGENCY FLASHLIGHT, OPERATIONAL CHECKS GOOD.SDR CA981113004Release Cable · frayed(CAN) AT 500 HOUR INSPECTION, THE RIGHT MAIN LANDING GEAR DOOR RELEASE CABLE WAS FOUND FRAYED.SDR CA981109028Cable · frayed(CAN) LEFT HAND LOWER CONDITION LEVER CABLE FOUND FRAYED WHERE IT PASSES OVER THE PULLEY FORWARD OF THE ENGINE FIREWALL.SDR CA981109027Cable · frayed(CAN) RIGHT HAND LOWER CONDITION LEVER CABLE FOUND FRAYED WHERE THE CABLE PASSES OVER THE PULLEY FORWARD OF THE ENGINE FIREWALL.SDR SABA980058Engine · failedCLT-CVG - FLT 5033 - THE LEFT ENGINE HAD A UNCOMMANDED SHUT DOWN AT 9000 FT AND ON APPROACH TO CINCINNATI. THERE WAS NO UNUSUAL TEMPS OR PRESSURE READINGS PRIOR TO FAILURE. LEF TPROP DID NOT FEATHER. ALTERNATE FEATHER WAS USED. INFLIGHT EMERGENCY WAS DECLA
Back to Boeing DHC-8-102