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 QXEA9901073Mechanism · lack of lubeGEG - THE MAIN CABIN DOOR OPERATION HANDLE IS HARD TO MOVE, HANGS UP DURING OPERATION. MAINTENANCE CLEANED AND LUBRICATED THE DOOR STOPS AND PIVOT POINTS. OPERATIONAL CHECKS GOOD. NO PARTS REPLACED.SDR AU990526Hose · failed(AUS) LT MAIN LANDING GEAR DOWN HOSE RUPTURED. LOSS OF FLUID FROM NR 2 HYDRAULIC SYSTEM.SDR AU990477Connector · contaminated(AUS) RIGHT ENGINE TORQUE SIGNAL CONDITIONER CONNECTOR CONTAMINATED WITH OIL.SDR HNAA9900059Battery Pack · dischargedDURING OVERNIGHT, MAINTENANCE IT WAS FOUND THAT THE LT OUTSIDE EMERGENCY LIGHT DID NOT ILLUMINATE. THE PS3 BATTERY PACK WAS REPLACED.SDR PCAA9900013Uplock · dirtyFLT 3968- BWI-UPON GEAR SELECTION DOWN, THE LEFT MAIN GEAR DID NOT EXTEND. ALTERNATE GEAR EXTENSION WAS PERFORMED SATISFACTORY. AIRCRAFT LANDED SAFELY. MAINTENANCE INSPECTED EXTENSION SYSTEM, CLEANED UPLOCK ROLLERS, OPERATED GEAR SEVERAL TIMES. GEAR OPERATSDR PCAA9900012Indication · malfunctionedFLT 3904 - UPON DESCENT INTO ABE WHEN LANDING GEAR WAS SELECTED DOWN, THE NLG FAILED TO ILLUMINATE. NOSE GEAR LIGHT ILLUMINATED ON AND OFF WHEN GEAR WAS EXTENDED. MAINTENANCE INSPECTED NLG INDICATION SYSTEM, CLEANED LIGHT MODULE AND SYSTEM CHECKED OUT NORMALSDR QXEA9901065Axle · damagedPDX- NOSE GEAR TRAILING ARM HAS SEVERAL GOUGES. MAINTENANCE REPLACED TRAILING ARM ASSEMBLY. GEAR SWINGS AND OPERATIONAL CHECKS GOOD.SDR HNAA9900058Power Supply · inoperativeLEFT HAND FUSELAGE EMERGENCY LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT POWER SUPPLY 3351-PS1.SDR QXEA9901014Inverter · malfunctionSEA - STRANGE ODOR NOTED IN COCKPIT. MAINTENANCE FOUND SMELL TO BE COMING FROM PRIMARY INVERTER. REPLACED INVERTER. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR PCAA9900011Bumper · out of positionMHT FLT 3758 - PASSENGER DOOR HANDLE RECESSED. UNABLE TO OPEN DOOR FROM THE OUTSIDE. MAINTENANCE INSPECTED, FOUND RUBBER BUMPER FOR HANDLE AT FAULT. SHIMMED BUMPER, OPERATED DOOR SEVERAL TIMES, OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR HNAA9900056Hose · leakingLOSS OF NR 2 HYDRAULIC QUANTITY AND PRESSURE AFTER TAKEOFF (LEAK FROM NOSE GEAR AREA). REPLACED NOSE GEAR DRAG STRUT ACTUATOR HOSE ASSEMBLY. INSPECTED ENGINE DRIVEN PUMP PER MM PROCEDURE 05-50-33. NO CONTAMINATION FOUND IN CASE DRAIN FILTER. GROUND RAN AIRSDR PCAA9900010Mechanism · out of adjustPHL FLT 3810 - AIRSTAIR DOOR WAS DIFFICULT TO OPEN WHEN DEPLANING PASSENGERS. MAINTENANCE INSPECTED AND FOUND THE DOOR LIFT MECHANISM AT FAULT. ADJUSTED IAW BOMBARDIER PROCEDURES CHAPTER 52. AIRCRAFT RETURNED TO SERVICE.SDR HNAA9900054Mechanism · out of adjustRIGHT HAND MAIN LANDING GEAR DOORS WOULD NOT OPEN. ADJUSTED CABLE AT NR 2 NACELLE FOR AFT DOORS. CYCLED DOOR SERVERAL TIMES OPENING DOORS WITH RELEASE HANDLE. OPERATIONAL CHECK GOOD.SDR QXEA9900851Light · inoperativeSEA- COCKPIT OVERHEAD EMERGENCY LIGHT INOP. MAINTENANCE REPLACED THE COCKPIT OVERHEAD LIGHT. OPERATIONAL CHECKS GOOD.SDR HNAA9900053Skin · dentedDENT ON RIGHT FUSELAGE FROM LAVATORY CAP HANDLE, LOCATED .5 INCHES BELOW STRINGER 265 RIVET ROW 2 INCHES FORWARD OF FRAME X202. DENT IS .020 INCHES DEEP, 1.2 INCHES LONG AND .4 INCHES WIDE. INSPECTED DENT AND DEFERRED.SDR HNAA9900052Bracket · crackedLEFT WING FLAP WELL PANEL MOUNT BRACKET (SECONDARY STRUCTURE) UNDER OUTBOARD ROLL SPOILER ACTUATING HINGE CRACKED ON FORWARD OUTBOARD EDGE OF OUTBOARD LIGHTENING HOLE. REPAIRED CRACK.SDR HNAA9900051Power Supply · inoperativeFORWARD LEFT HAND INTERIOR FUSELAGE EMERGENCY LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT POWER SUPPLY.SDR HNAA9900049Smoke Detector · malfunctionedINTERMITTENT BAGGAGE BAY SMOKE WARNING LIGHT IN FLIGHT (CONFIRMED NO SMOKE). INSPECTED WIRING/CONNECTORS AT BOTH SMOKE DETECTORS. SYSTEM TESTS NORMAL.SDR HNAA9900048Smoke Detector · won't testBAGGAGE COMPARTMENT NR 2 SMOKE DETECTOR WILL NOT TEST. REPLACED SMOKE DETECTOR.SDR HNAA9900046Intercostal · crackedNR 1 NACELLE DOOR OUTBOARD INTERCOSTAL CRACKED AT FORWARD HINGE BRACKET. REPAIRED INTERCOSTAL.SDR PCAA9900009Valve · failedCLE-FLT 3775 - ON APPROACH INTO CLE, LANDING GEAR FAILED TO EXTEND WHEN SELECTED. GEAR INDICATED INTRANSIT. CREW PERFORMED SUCCESSFUL ALTERNATE GEAR EXTENSION AND LANDED IN CLE WITHOUT INCIDENT. AIRCRAFT WAS FERRIED TO BGM WHERE MAINTENANCE REPLACED LANDINGSDR HNAA9900045Rail · corrodedCORROSION ON RT CENTER FLOORBOARD RAIL AT FRAME 215.00 ON TOP FLANGE .025 DEEP, ON OUTER FLANGE .035 DEEP AND ON INBOARD SIDE OF OUTER FLANGE .016 DEEP. BLENDED CORROSION FROM RAILS.SDR HNAA9900044Wire · looseSECOND FROM LAST FLOOR EMERGENCY LIGHT INOPERATIVE. REATTACHED WIRE.SDR HNAA9900043Spring · brokenLAVATORY TRASH BIN DOOR WILL NOT STAY CLOSED. REPLACED BROKEN SPRING ON TRASH BIN DOOR.SDR HNAA9900047Rivets · looseTWELVE WORKING RIVETS ON INBOARD WALL OF NR 2 NACELLE (ALL RIVETS ON STRAP) AT GROUND POWER CONNECTOR. REPLACED RIVETS.SDR AU990328Spring · broken(AUS) RIGHT MAIN LANDING GEAR DOOR SPRING BROKEN AND FOULING ON DOOR ACTUATING ROD PN 83231014-003.SDR PCAA9900008Wire · brokenBDL-FLT3871, DURING CRUISE FLIGHT THE NR 1 ENGINE OIL TEMPERATURE WAS ERRATIC, TEMPERATURE PEGGED AT 150 DEGREES CELSIUS FOR 60 SECONDS. CREW SECURED NR 1 ENGINE AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND REPAIRED A BROKEN WIRE AT THE TEMP BULB ESDR CA990416024Engine · failed(CAN) ON DEPARTURE, NR 1 ENGINE OIL PRESSURE GAUGE FLUCTUATED, CONFIRMED BY OIL PRESSURE AND MASTER CAUTION WARNING LIGHTS. PRECAUTIONARY SHUTDOWN OF ENG CARRIED OUT AND AIRCRAFT RETURNED TO ITS DEPARTURE POINT. INVESTIGATION FOUND THIS ENG WAS REMOVED FROMSDR HNAA9900042Battery · dischargedLEFT AFT EMERGENCY EGRESS LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHTS BATTERY 3351-P5.SDR AU990322Linkage · disconnected(AUS) RIGHT INBOARD GROUND SPOILER LINKAGE DISCONNECTED FROM ACTUATOR. LINKAGE HAD BEEN DISCONNECTED DURING MAINTENANCE AND NOT CORRECTLY RECONNECTED.SDR QXEA9900558Housing · chafedYXX - NR 1 HORSE COLLAR INBOARD FORWARD LATCH HOUSING CHAFED BADLY AND CRACKED. REPAIRED IAW DASH 8 RD 8-71-154, CONAIR EA 2240 AND HORIZON AIR EA 9-71-103.SDR QXEA9900555Skin · damagedYXX - NR 2 NACELLE HAS RIVETS PULLED THROUGH SKIN AT NACELLE STATION 134.68 AT LOWER LONGERON OUTBOARD SIDE. REPAIRED IAW SRM 51-20-16.SDR QXEA9900554Cowl · crackedYXX - NR 2 ENGINE PANEL 432AL CRACKING AROUND RIVET ON GUSSET AND CHANNEL AT COOLING DUCT ATTACH FLANGE. REPAIRED IAW CONAIR EO 2251 AND HORIZON AIR EA 9-71-105.SDR QXEA9900551Skin · chafedYXX - CHAFE MARK ON UPPER SKIN OF LEFT-HAND INBOARD FLAP STATION YW 74.35, 1 AFT OF FLAP FRONT SPAR. REPAIRED IAW DASH 8 RD 8-57-1361.SDR QXEA9900556Firewall · crackedYXX - CRACK IN NR 1 FIREWALL, INBOARD SIDE JUST ABOVE CUT OUT FOR ATTACHMENT HARDWARE OF MAIN LANDING GEAR RETRACT ACTUATOR ATTACH FITTING. REPAIRED IAW DASH 8 RD 8-54-10147, CONAIR EO 2254 AND HORIZON AIR EA 9-54-193.SDR QXEA9900548Trailing Arm · gougedSEA- NOSE WHEEL SWIVEL GOUGED APPROX .035 DEEP. AIRCRAFT FERRIED FROM SEA TO PDX FOR REPAIRS. IN PDX, MAINTENANCE REMOVED THE DAMAGED TRAILING ARM, AND THE UNDAMAGED AXLE AS A UNIT. REPLACED WORN CONNECTION LINK PIN. INSTALLED OVERHAULED TRAILING ARM, AND SDR QXEA9900560Skin · dentedYXX - FORWARD LEFT-HAND SIDE AT STATION X148.000 DENT FOUND OUT OF SRM LIMITS, CHAPTER 53-00-16, PAGE 4. REPAIRED IAW DASH 8 RD 8-53-4107.SDR QXEA9900557Shroud · dentedYXX - VERTICAL STABILIZER RIGHT-HAND TRAILING EDGE SHROUD BETWEEN RIB 8 AND RIB 9 DENTED. REPAIRED IAW DASH 8 RD 8-555-718.SDR QXEA9900553Skin · dentedYXX - LEFT-HAND WING HAS DENT ON LOWER SKIN SURFACE STATION YW 279.00. REPAIRED IAW DASH 8 RD 8-57-1359.SDR PCAA9900006Smoke Detector · malfunctionedBDL -FLT 3781 BAGGAGE SMOKE WARNING LIGHT CAME ON WITH NO EVIDENCE OF SMOKE OR FIRE DURING CRUISE FLIGHT INTO BDL. MAINTENANCE INSPECTED, FOUND NO EVIDENCE OF SMOKE OR FIRE, FOUND THE NR 2 BAGGAGE SMOKE DETECTOR AT FAULT. DISBLED IT AND RELEASED AIRCRAFT UNDERSDR QXEA9900552Plate · corrodedYXX - LEFT-HAND WING LADDER PLATE HAS CORROSION ON UPPER SURFACE LADDER PLATE STATION YW 171.2 TO YW 261.0. REPAIRED IAW DASH-8 RD 51-20-16.SDR PCAA9900005Smoke Detector · failedACY - FLT3698: AIRCRAFT WAS EN ROUTE TO PHL WHEN A BAG BAY SMOKE WARNING LIGHT ILLUMINATED. THE CREW DIVERTED INTO ACY AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND NO EVIDENCE OF SMOKE OR FIRE. THEY FOUND THE NR 2 SMOKE DETECTOR AT FAULT. TSDR PCAA9900004Wire · brokenBWI-FLT 3616: UPON DESCENT, THE NLG FAILED TO INDICATE DOWN AND LOCKED. DOWN AND LOCKED VERIFIED VIA THE ALTERNATE INDICATION. MAINTENANCE INSPECTED AND FOUND A BROKEN WIRE FOR THE NLG STAY STRUT SENSOR. WIRE WAS REPAIRED AND AN OPERATIONAL CHECK WAS SATISFSDR CA990401014Cable · damaged(CAN) LEFT CONDITION LEVER CONTROL CABLE FOUND DAMAGED.SDR QXEA9900510Engine · flamed outSEA- ON DESCENT INTO SEA, THE AIRCRAFT EXPERIENCED MODERATE TO SEVERE TURBULENCE WHILE IN INSTRUMENT METROLOGICAL CONDITIONS (IMC). DURING THIS PERIOD, BOTH ENGINES APPARENTLY FLAMED-OUT, AND THEN BOTH IMMEDIATELY RELIT. THERE WAS A LOUD SURGE WITH THE POWERSDR PCAA9900003Skin · damagedMDT- DURING A LIGHTNING STRIKE INSPECTION THE FORE RUDDER WAS FOUND TO HAVE NUMEROUS RIVETS PULLED THROUGH AND LOOSE. THE RUDDER WAS REPAIRED IAW BOMBARDIER RD8-55-335.SDR CA990401021Tire · leaking(CAN) TIRE LEAKING.SDR CA990401019Tire · leaking(CAN) TIRE LEAKING.SDR AU990301Line · chafed(AUS) HYDRAULIC PRESSURE PIPE FROM ANTI-SKID VALVE TO THE BRAKE QUANTITY LIMITING VALVE CHAFED. LOSS OF NR 1 SYSTEM HYDRAULIC FLUID. PIPE IS LOCATED IN THE RT NACELLE.SDR HNAA9900039Smoke Detector · failedDURING CLIMB-OUT, SMOKE WARNING LIGHT ILLUMINATED SEVERAL TIMES. NO EVIDENCE OF FIRE OR SMOKE. ELECTRICAL SMELL FOUND IN BAG BAY WHEN DOOR WAS OPENED. REPLACED BOTH SMOKE DETECTORS P/N 30-231-3 NR 1, S/N 31832, NR 2 S/N 0015W.
Back to Boeing DHC-8-102