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 QXEA0100245Yoke · chafedPDX- RIGHT HAND YOKE, RIGHT HAND AFT EDGE IS BEING CHAFED BY THE HYDRAULIC STANDBY PUMP BLUE FLEX LINE.SDR QXEA0100244Seat Track · wornPDX- LEFT HAND OUTBOARD SEAT TRACK STATION 429-504 WORN BEYOND LIMITS. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-40-11.SDR PCAA0102008Hub · galledBGM - DURING ROUTINE MAINTENANCE VISIT LEFT PROPELLER ASSEMBLY HAD EVIDENCE OF OIL LEAK. UPON FURTHER INVESTIGATION LEAK WAS FOUND TO BE COMING FROM NR4 BLADE. AFTER REMOVING THE LEFT NR4 BLADE THE OUTER BEARING RACE WITHIN THE PROPELLER HUB WAS FOUND TO BE CRSDR PCAA0102009Light · malfunctionedLGA-FLIGHT 3635. CREW REPORTED FLOOR LEVEL EMERGENCY LIGHTS AND GALLEY LIGHT SWITCH CAME ON AND FLICKERED FOR 30 MINUTES AFTER TAKEOFF. MAINTENANCE CLEANED CANNON PLUG ON FLIGHT ATTENDANTS PANEL. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR AU010148Pipe · leaking(AUS) HYDRAULIC LINE LOCATED IN RH WHEEL BAY CONTAINED A PINHOLE LEAK.SDR CA010301011Tube · leaking(CAN) THE FLIGHT CREW OBSERVED HYDRAULIC FLUID LEAKING FROM THE L/H NACELLE DURING WALKAROUND. MAINTENANCE INVESTIGATION RESULTED IN REPLACEMENT OF THE NR 2 FLIGHT SPOILER UNLOADING LINE.SDR QXEA0100243Seat Track · wornPDX- LEFT HAND OUTBOARD SEAT TRACK STATION 262-429 WORN BEYOND LIMITS. REPAIRED IAW DHC-8 51-40-00 AND SRM 51-40-11.SDR QXEA0100241Seat Track · wornPDX- RIGHT HAND FORWARD OUTBOARD SEAT TRACK STA 262-429 WORN BEYOND LIMITS. REPAIRED IAW DHC-8 SRM 51-40-11 AND SRM 51-40-00.SDR AU010144Wire · worn(AUS) HORIZONTAL STABILISER SURFACE POSITION INDICATOR WIRE CHAFED ANDSHORT CIRCUITING INSIDE CONDUIT LOCATED BETWEEN THE FORWARD SPAROF THE HORIZONTAL STABILISER AND THE RT ELEVATOR SYNCHRO.SDR CA010301028Tire · failed(CAN) SEPARATION OF TIRE SIDEWALL CORDS.SDR QXEA0100240Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK CORROSION AT X518.00. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100238Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK CORROSION AT X500.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100237Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK CORROSION AT X485.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100236Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK CORROSION AT X520.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100235Seat Track · corrodedPDX- RIGHT HAND OUTBOARD SEAT TRACK CORROSION AT X456.00. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100234Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK CORROSION AT X330.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100233Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK CORROSION AT X361.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100232Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK CORROSION AT X390.00. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100231Seat Track · corrodedPDX- LEFT HAND SEAT TRACK CORROSION AT X542.00. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100230Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK CORROSION AT X515.00. REPAIRED IAW DHC-8 RD8-83-1339.SDR QXEA0100229Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK CORROSION AT FRAME 545.000. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100118Odor · detectedPDX- STRONG FUEL ODOR AFTER ENGINE START. GROUND RAN ENGINES. NO FUEL SMELL NOTED IN BLEED SYSTEM. SUSPECT SLIGHT TAIL WIND CAUSED FUEL VAPOR TO ENTER BLEED SYSTEM OF NR 2 ENGINE DURING NR 1 ENGINE START. NO PARTS REPLACED. OPERATIONAL CHECKS GOOD. AIRCRSDR PCAA0102005Switch · defectiveMDT FLIGHT 3800. CREW REPORTED CABIN EMERGENCY LIGHTS FLICKERED ON INTERMITTANTLY DURING CLIMBOUT, AFTER POWER REDUCTION, AFTER CRUISE. MAINTENANCE REPLACED SWITCH AT FLIGHT ATTENDANTS LIGHTING PANEL. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR PCAA0102007Guard · jammedRDG FLIGHT 3555. CREW REPORTED AIRSTAIR DOOR WILL NOT OPEN. MAINTENANCE UNJAMMED DIRT GUARD FROM BOTTOM OF DOOR. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR HNAA0100012Battery Pack · dischargedFIRST TWO RED EMERGENCY FLOOR LIGHTS INOP. REPLACED EMERGENCY LIGHT BATTERY PACK 3352-P2.SDR 20010406SG006Battery Pack · dischargedFOUND LEFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW MM 33-50-21, OPS CHECK OK. (M)SDR 20010406SG004Power Supply · dischargedMID CABIN OVERHEAD EMERGENCY EXIT SIGN LIGHT INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY IAW MM 33-50-21, OPS CHECK OK. (M)SDR PCAA0102006Transformer · fluctuatesALB FLIGHT 3539. FLIGHT ATTENDANT REPORTED EMERGENCY LIGHTS WERE FLASHING ON AND OFF DURING CLIMBOUT. MEL 24-01 ISSUED FOR TRANSFORMER RECTIFIER UNIT (TRU) AND AIRCRAFT RETURNED TO SERVICE. DURING NEXT SCHEDULED MAINTENANCE VISIT RIGHT TRU REPLACED. SYSTEMSDR HNAA0100014Control Cable · out of toleranceUPON RELEASE OF AUTO PILOT, NOTED ROLL CONTROL VERY STIFF, SEEMS TO REDUCE WITH REDUCTION IN AIR SPEED. INSPECTED AILERONS AND ROLL SPOILERS, FOUND AILERON CONTROL CABLE TENSIONS OUT OF LIMITS. RE-TENSIONED CABLES. EVALUATION FLIGHT SATISFACTORY.SDR QXEA0100106Seat Track · corrodedPDX- FRETTING CORROSION ON INBOARD FLANGE OF LEFT INBOARD SEAT TRACK AT STATION X252.700 IN LINE WITH AFT EDGE OF MAIN CABIN DOOR. REPAIRED IAW PSM 1-GEN-5 CHAPTER 4 PAGE 4-16.SDR QXEA0100093Light · malfunctionedSEA- COCKPIT EMERGENCY LIGHT INOPERATIVE WHEN CONTROL SWITCH IS ON POSITION. INTERMITTENTLY ILLUMINATED ON WHEN SWITCH IN ARM OR OFF POSITION. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT ASSEMBLY. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE.SDR HNAA0100011Door · separatedNR 2 MLG FWD DOOR CAME OFF IN FLIGHT, DAMAGING SURROUNDING NACELLE STRUCTURE. REPLACED GEAR DOOR AND REPAIRED NACELLE STRUCTURE PER EO8-54-01-061.SDR PCAA0102004Light · inoperativeLGA FLIGHT 3909. CREW REPORTED ROW ONE FLOOR EMERGENCY LIGHT STRIP IS INOPERATIVE, FOUR RED LIGHTS OUT. MAINTENANCE INSPECTED AND REPAIRED FIVE BROKEN WIRES. EMERGENCY LIGHTS CHECKED GOOD AT THIS TIME. AIRCRAFT RETURNED TO SERVICE.SDR QXEA0100109Skin · dentedPDX- DENT IN AFT FUSELAGE SKIN 6 INCHES LONG, .020 INCH DEEP AFT OF FRAME X600.0 BETWEEN STRINGERS 22R AND 23R. REPAIRED IAW DHC-8 RD 8-53-436.SDR QXEA0100108Seat Track · corrodedPDX- FRETTING CORROSION ON INBOARD FLANGE OF LEFT HAND INBOARD SEAT TRACK AT STATION X252.700 IN LINE WITH AFT EDGE OF MAIN CABIN DOOR. REPAIRED IAW DHC-8 SRM 51-40-00 AND RD 8-53-1102.SDR QXEA0100100Seat Track · misdrilledPDX- LEFT HAND INBOARD NR 4 SEAT TRACK SUPPORT ANGLE AT STATION 355.950 AND 354.250 HAS A 10:32 FASTENER HOLE THAT HAS BEEN MISDRILLED. REPAIRED IAW HORIZON AIR EA 9-53-596.SDR QXEA0100113Elevator · incorrectPDX- RIGHT HAND ELEVATOR INBOARD TRAILING EDGE DOES NOT FARE WITH ELEVATOR SKIN. REPAIRED IAW DHC-8 SRM 51-40-00.SDR PCAA0102003Control Box · false activationLGA FLIGHT 3704. FLIGHT ATTENDANT REPORTED EMERGENCY LIGHTS FLASHING ON AND OFF. MAINTENANCE INSPECTED CONTROL SWITCH AND WIRING, NO DEFECTS NOTED. EMERGENCY LIGHTS CONTROL BOX REPLACED. OPERATED LIGHTS, COULD NOT DUPLICATE PROBLEM. AIRCRAFT RETURNED TO SESDR QXEA0100114Attach Fitting · corrodedPDX- LEFT HAND MAIN LANDING GEAR RETRACTION ACTUATOR ATTACH FITTING ATTACH POINT ON H-MEMBER HAS FRETTING CORROSION AT LEFT HAND SIDE OF UPPER MOUNT HOLES. REPAIRED IAW HORIZON AIR EA 9-54-267.SDR CA010223007Starter Gen · disintegrated(CAN) A VIBRATION WAS FELT DURING START-UP ON NR 2 ENGINE AND THEN DURING TAXI THE NR 2 D.C. GENERATOR LIGHT CAME ON. THE CREW WERE UNABLE TO SUCCESSFULLY RESET THE NR 2 GENERATOR AND RETURNED TO THE GATE. INVESTIGATION REVEALED THE NR 2 GENERATOR FAN END BEARSDR QXEA0100116Stiffener · crackedPDX- LOWER FINGERNAIL DECK OUTBOARD FORE/AFT STIFFENER IS CRACKED AT GEARWELL WALL VERTICAL STIFFENER OF LEFT HAND NACELLE. REPAIRED IAW DHC-8 SRM 51-40-11 AND 51-20-16.SDR QXEA0100115Stiffener · chafedPDX- FINGERNAIL DECK STIFFENER CHAFED THIN AT XN232.0 TOP SIDE. REPAIRED IAW DHC-8 SRM 51-40-11 AND 51-20-16.SDR QXEA0100110Splice · crackedPDX- FRAME JOINT SPLICE ANGLE AT STATION X136.80 AT STRINGER 15A RIGHT HAND IS CRACKED. REPAIRED IAW DHC-8 RD 8-53-576.SDR QXEA0100102Flap Track · damagedPDX- RIGHT HAND INBOARD FLAP, NR 2 OUTBOARD FLAP TRACK UPPER TRACK HAS A DIVET 10 INCHES AFT OF FORWARD END. REPAIRED IAW DHC-8 RD 8-57-986.SDR QXEA0100101Flap Track · damagedPDX- RIGHT HAND INBOARD FLAP, NR 1 INBOARD UPPER TRACK HAS DIVETS IN TOP AND BOTTOM 10 INCHES AFT OF FORWARD END. REPAIRED IAW DHC-8 RD 8-57-985.SDR QXEA0100086Battery · dischargedSEA- FORWARD 2 EMERGENCY ESCAPE PATH LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY AND POWER SUPPLY AT PS-2. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR QXEA0100112Skin · crackedPDX- TOP RIGHT HAND SIDE OF TRAILING RUDDER SKIN HAS A CRACK PROGRESSING OUT FROM RIVET HOLE AT PREVIOUS REPAIR SKIN PATCH. REPAIRED IAW DHC-8 SRM 55-40-28 AND 51-40-00.SDR QXEA0100111Splice · crackedPDX- CRACK FOUND IN LEFT HAND JOINT SPLICE FRAME AT STATION X136.80 AND STRINGER 15A. REPAIRED IAW DHC-8 RD 8-53-576.SDR HNAA0100010Control Unit · contaminatedDURING TAKEOFF ROLL, THE LEFT AC BUS CAUTION LIGHT ILLUMINATED. CREW ABORTED TAKEOFF. FOUND DEICE FLUID CONTAMINATION IN NR 1 AC GENERATOR CONNECTOR. CLEANED CONNECTOR. ALSO REPLACED NR 1 AC GEN CONTROL UNIT.SDR QXEA0100117Door Frame · corrodedPDX- MAIN CABIN DOOR SURROUND FORWARD FRAME CORRODED AROUND NUTPLATE THAT IS BETWEEN 2ND AND 3RD STOPS FROM BOTTOM. REPAIRED IAW DHC-8 SRM 51-20-11 AND 53-00-16.
Back to Boeing DHC-8-102