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 QXEA9902287Seat Track · corrodedPDX - RIGHT OUTBOARD CABIN SEAT TRACK AT STATION 265.000 HAS CORROSION ON TOP SURFACE AND AROUND SEAT PEG HOLE. REPLACED SEAT TRACK.SDR QXEA9902286Seat Track · gougedPDX - RIGHT OUTBOARD CABIN SEAT TRACK AT STATION 291.400 HAS TOOL GOUGE MARKS ON TOP SURFACE. REPLACED SEAT TRACK.SDR QXEA9902285Seat Track · corrodedPDX - RIGHT OUTBOARD CABIN SEAT TRACK BETWEEN STATION 333.300 AND 387.350 HAS CORROSION ON TOP SURFACE AND INSIDE CHANNEL. REPLACED SEAT TRACK.SDR QXEA9902242Skin · chafedPDX - LEFT WING INBOARD FLAP .015: DEEP CHAFFED DAMAGE TO REPAIR ON FLAP. REPAIRED IAW RD 8-57-037.SDR QXEA9902241Skin · chafedPDX - LEFT WING OUTBOARD FLAP CHAFFED .010 ON REPAIR PATCH. REPAIRED IAW RD 8-57-037.SDR QXEA9902238Angle · gougedPDX - LOWER FORWARD SPAR LEADING EDGE ATTACH ANGLE IS GOUGED IN THE AREA FOR LEADING EDGE 613AR. REPAIRED IAW DHC-8-102 M/M 20-32-02.SDR QXEA9902237Angle · gougedPDX - UPPER FORWARD SPAR LEADING EDGE ATTACH ANGLE IS GOUGED IN THE AREA FOR LEADING EDGE 613AR. REPAIRED IAW DHC-8-100 M/M 20-32-02.SDR QXEA9902236Angle · gougedPDX - LOWER FORWARD SPAR LEADING EDGE ATTACH ANGLE IS GOUGED IN AREA FOR LEADING EDGE 613CR ATTACHMENT. REPAIRED IAW DHC-8-100 M/M 20-32-02.SDR QXEA9902235Angle · gougedPDX - UPPER FORWARD SPAR LEADING EDGE ATTACH ANGLE IS GOUGED IN THE AREA FOR LEADING EDGE 613CR ATTACHMENT. REPAIRED IAW DHC-8-100 M/M 20-32-02.SDR CA991027069Actuator · cracked(CAN) ON APPROACH, PILOTS HEARD A LOUD BANG FOLLOWED BY LOSS OF NR 2 HYDRAULIC QUANTITY. MAIN LANDING GEAR DOOR ACTUATOR REPLACED.SDR QXEA9902125Mechanism · lack of lubeSEA- MAIN CABIN DOOR HARD TO OPEN. CLEANED AND LUBED DOOR ROLLERS, TRACKS AND STOPS, OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR CA991103037Line · leaking(CAN) DURING PRE-FLIGHT, MAINTENANCE NOTICED HYDRAULIC FLUID LEAKING FROM THE NOSE WHEELWELL. THE NOSE GEAR DOWN PRESSURE HYDRAULIC LINE WAS FOUND LEAKING.SDR CA991103036Line · leaking(CAN) A HYDRAULIC FLUID LEAK WAS NOTICED ON THE AIRCRAFT BELLY RT SIDE UNDER ROW 2 SEATS. A HYDRAULIC LINE WAS FOUND LEAKING AT THE PERMASWAGE FITTING.SDR QXEA9902294Seat Track · corrodedPDX - RIGHT INBOARD CABIN SEAT TRACK BETWEEN FUSELAGE STATION 267.000 AND 312.360 HAS CORROSION ON TOP SURFACE AND INSIDE CHANNEL. REPLACED RIGHT FORWARD INBOARD SEAT TRACK.SDR QXEA9902293Seat Track · corrodedPDX - RIGHT INBOARD CABIN SEAT TRACK BETWEEN STATION 312.360 AND 370.800 HAS CORROSION ON TOP SURFACE AND INSIDE CHANNEL. REPLACED RIGHT FORWARD INBOARD SEAT TRACK.SDR QXEA9902292Seat Track · corrodedPDX - RIGHT INBOARD CABIN SEAT TRACK AT STATION 387.350 HAS GOUGE MARKS ON TOP SURFACE WITH CORROSION TO INCLUDE INSIDE CHANNEL. REPLACED RIGHT FORWARD INBOARD SEAT TRACK.SDR CA991103035Acm · seized(CAN) DURING FLIGHT, THE FLIGHT ATTENDANT NOTICED A LOUD HUMMING SOUND ACCOMPANIED BY VIBRATION. THIS COULD BE HEARD AND FELT NEAR THE REAR OF THE CABIN IN THE CABIN FLOOR. THE SOUND AND VIBRATION WAS ACCOMPANIED BY AN OILY/ ELECTRICAL SMELL IN THE COCKPIT. SDR AU990972Pump · faulty(AUS) NR 1 PROPELLER OIL PUMP FAULTY.SDR QXEA9902257Skin · chafedPDX - FINGERNAIL DECK HAS A CHAFE ON UPPER SURFACE AT CENTERLINE OF NACELLE AT STATION XN 240. REPAIRED IAW DHC-8-100 SRM 51-40-11.SDR QXEA9902248Panel · gougedPDX - PANEL 521AT HAS TWO DEEP CORROSION GOUGES ON LEFT MATING SURFACE EDGE. REPAIRED IAW DHC-8 SRM 51-20-16.SDR QXEA9902247Panel · corrodedPDX - PANEL 521AT HAS FRETTING CORROSION ON INSIDE MATING SURFACE AT INBOARD AND OUTBOARD EDGES. REPAIRED IAW DHC-8 SRM 51-20-16, RD 8-57-617 AND -8 PSM 1-8-7A 51-00-04.SDR CA991027067Selector Valve · failed(CAN) LANDING GEAR WOULD NOT RETRACT. PANEL SHOWED 3 GREEN, 3 RED, AND 3 YELLOW TRANSIT LIGHTS ON. GEAR DOWN SELECTION MADE WITH 3 GREEN AND DOORS CLOSED. LANDING GEAR SELECTOR VALVE REPLACED.SDR CA991027022Deice Boot · separated(CAN) DURING ROUTINE INSPECTION, IT WAS DISCOVERED THAT THE LEFT OUTBOARD DEICE BOOT ON THE HORIZONTAL STABILIZER WAS SEPARATING FROM THE LEADING EDGE. LEADING EDGE REPLACED.SDR AU991102Selector Valve · faulty(AUS) LANDING GEAR SELECTOR VALVE FAULTY.SDR QXEA9902301Skin · corrodedPDX - CORROSION FOUND ON AIRCRAFT SKIN UNDER AFT DME ANTENNA. REPAIRED IAW DHC-8 SRM 51-20-11, PAGE 5, STEP 3, SRM 53-00-16, PAGE 3, TABLE 1, SHEET 2.SDR QXEA9902053Connector · looseSEA - FORWARD FOUR RED CENTER AISLE EMERGENCY LIGHTS INOPERATIVE. CONNECTED FORWARD FOUR RED EGRESS LIGHTS CONNECTOR TO POWER SUPPLY CONNECTOR UNDER FLOOR BOARD. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR HNAA9900135Hyd Line · chafedNR 1 HYD SYS QUANTITY LOSS INFIGHT HAD TO DECLARE EMERGENCY LANDING. REMOVED AND REPLACED CHAFED LINE ANTI-SKID VALVE AND INSTALLED TFL. SERVICED 6 QTS IN NR 1 SYS, LEAK AND OPS CHECK GOOD.SDR CA991027024Seal · leaking(CAN) NR 2 BRAKE FOUND LEAKING. ONLY OPERATOR USING THIS P/N BRAKE AND IS AWARE OF PROBLEMS.SDR CA991027023Seal · leaking(CAN) NR 1 BRAKE FOUND LEAKING AT ACTUATOR PISTON. OPERATOR AWARE OF THIS PROBLEM WITH BRAKE AND IS ONLY OPERATOR USING THIS P/N.SDR CA991028022Line · chafed(CAN) FUEL WAS FOUND LEAKING FROM THE WING ON THE OUTBOARD SIDE OF THE NACELLE. FUEL SUPPY LINE FROM COLLECTOR BOX TO NACELLE HAD TWO CHAFE MARKS IN IT.SDR CA991103033Line · leaking(CAN) DURING PRE-FLIGHT, HYDRAULIC FLUID WAS FOUND TO BE LEAKING FROM THE RIGHT HAND WING ROOT AREA. THE NR 2 SYSTEM PRESSURE LINE WAS FOUND LEAKING WHERE IT RUNS THROUGH THE OVERWING AREA. THE DAMAGED SECTION OF LINE WAS REPLACED.SDR HNAA9900134Intercostal · crackedNR 2 ENGINE OIL COOLER DOOR I/B INTERCOSTAL CRACKED FROM LARGE RIVET JUST FWD OF HINGE POINT RUNNING AFT TO HINGE POINT HOLE. DEFERED PER ESR8-54-91-11. REPLACE WITH POST MOD 8/1619 INTERCOSTAL WITHIN 500 HRS. REMOVED AND REPLACED OIL COOLER DOOR I/B INTERCSDR HNAA9900133Skin · dentedDENT LOCATED BETWEEN STRINGER 17 AND 18, 4 INCHES AFT OF ICE SHIELD, .044 DEEP .6 BY .1. C/W EO8-53-99-338 AS REQUIRED.SDR HNAA9900132Skin · chafedWHEEL WELL CUT-OUT RADIUS CHAFED IN AFT RT SIDE APPROX .031 DEEP. DISPOSITION: BLEND OUT CHAFE AT 20:1 BLEND RATIO. EDDY CURRENT TO VERIFY NO CRACKS. TOUCH-UP W/ALODINE PER SRM 51-20-16 AND EPOXY PRIME PER SRM 51-20-36. COMPLIED WITH STATED DISPOSITION.SDR HNAA9900131Trunnion · corrodedRT NLG SHOCK STRUT TRUNNION CORRODED. FWD SIDE MATING SURFACE FOR TRUNNION CAP, APPROX .016 DEEP. REPAIRD IAW RD8-53-4535. PLACED ON A 1000 HR DEFERAL FOR PERM REPAIR.SDR CA991028023Harness · shorted(CAN) OIL PRESSURE DROPPED BETWEEN 5-8 PSI WHEN PROP SYNC SELECTED. SHORT BETWEEN PINS 6 AND 16 IN HARNESSES 9811P17 AND 9811P29.SDR CA991007013Valve · leaking(CAN) DURING PRE-FLIGHT, CREW NOTICED FUEL LEAKING FROM SINGLE POINT ADAPTER MANIFOLD DRAIN. MASTER REFUEL/DEFUEL SHUT-OFF VALVE AND ACTUATOR REPLACED.SDR CA991028021Floorbeam · cracked(CAN) DURING INSPECTION, NLG WELL UPPER FRAME WAS FOUND CRACKED. CRACK RAN FROM THE LOWER FORWARD RADIUS TO THE BACK OF THE FRAME UNDER THE UPLOCK ACTUATOR FITTING.SDR CA991027017Cable · worn(CAN) DURING INSPECTION, NR 1 ENGINE CONTROL CABLE WAS FOUND WORN TO LIMITS IN AREA OF STEEL FIREWALL PULLEY. CABLE REPLACED.SDR CA991027013Bushing · worn(CAN) AIRSTAIR WAS JAMMED. FORWARD HANDLE HAD WORN BUSHING THAT CAUSED RAIL TO FOUL.SDR CA991007095Oil Cooler · leaking(CAN) OIL PRESSURE LIGHT ILLUMINATED IN-FLIGHT WITH OIL PRESSURE DROPPING RAPIDLY. OIL LEAK FOUND AT OIL COOLER. COOLER IN SERVICE FOR ONLY 23.2 HOURS.SDR CA990915016Smoke Detector · failed(CAN) BAGGAGE COMPARTMENT SMOKE WARNING LIGHT CAME ON MOMENTARILY AND WENT OUT. SMOKE DETECTOR U/S.SDR CA991007089Line · cracked(CAN) HYDRAULIC FLUID FOUND LEAKING FROM NR 2 NACELLE WHILE AIRCRAFT PARKED. NR 2 EDP PRESSURE LINE FOUND LEAKING AT PRESSURE MANIFOLD.SDR CA991007004Power Supply · inoperative(CAN) TWO EMERGENCY LIGHTS FOUND INOPERATIVE. POWER SUPPLY AT 3352 PS1 FOUND U/S.SDR CA991007003Control Cable · loose(CAN) PILOT REPORTED CONSIDERABLE FREE PLAY IN CONTROL YOKE ROLL CONTROL. CABLE LOOP IN BOTH COLUMNS UNDERTENSIONED AND ADJUSTED.SDR HNAA9900129Stringer · corrodedSTRINGER 31S FROM X467 - X445 HAS CORROSION, MOSTLY AROUND RIVET HOLES. RIVETS CIRCLED IN RED NEED REMOVED FOR FURTHER EVALUATION. REMOVED RIVETS. SEVERAL AREAS OF CORROSION MEASURE FROM .003 - .012 DEEP. SPLICED STRINGER IAW RD8-53-1834.SDR HNAA9900128Stringer · corrodedSTRINGER 31S FROM X488 - X467 HAS CORROSION AROUND RIVET HOLES. RIVETS CIRCLED IN RED NEED REMOVED AND CORROSION EVALUATED. REMOVED RIVETS. SEVERAL AREAS OF CORROSION MEASURES FROM .003 - .022 DEEP. SPLICED STRINGER 31S IAW RD8-53-1834.SDR CA991007012Boot · delaminated(CAN) INSPECTION OF NR 2 ENGINE INTAKE DEICER BOOT FOUND DISBONDING AT THE 3 AND 9 O'CLOCK POSITIONS. COWL REPLACED.SDR CA991004018Switch · contaminated(CAN) WHILE STARTING NR 2 ENGINE, FLIGHT CREW NOTICED EXCESSIVE ENGINE TORQUE. MAINTENANCE TRACED THE PROBLEM TO MICROSWITCH 7611-S8 UNDER THE CONDITION LEVER CONSOLE. THE SWITCH WAS CONTAMINATED WITH COFFEE.SDR QXEA9901930Wire · loosePDX - EMERGENCY LIGHTS DO NOT OPERATE FROM FLIGHT ATTENDENTS PANEL SWITCH. PILOTS SWITCH OPERATES NORMAL. RECONNECTED LOOSE WIRE AT SWITCH, OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS WERE REPLACED.
Back to Boeing DHC-8-102