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 QXEA9901580Angle · crackedPDX - RIGHT AFT WING SPAR TO FUSELAGE CLOSING ANGLE IS CRACKED. REPAIRED IAW DHC8 SRM 51-40-11.SDR QXEA9901592Hinge · corrodedPDX - FORE RUDDER BOTTOM SAFETY HINGE LUG IS CHAFFED AND HAS FRETTING CORROSION ACROSS ENTIRE LUG TOP SURFACE. REPAIRED IAW RD 8-55-537.SDR QXEA9901586Angle · crackedPDX - LEFT AFT WING SPAR TO FUSELAGE CLOSING ANGLE IS CRACKED. REPAIRED IAW DHC8 SRM 51-40-11.SDR HNAA9900100Cover · missingLOW BULKHEAD EMER LIGHT COVER MISSING RT SIDE ROW 4. REMOVED AND REPLACED EMERGENCY LIGHT ASSY.SDR CA990817006Wire · loose(CAN) AIRCRAFT RETURNED TO GATE AFTER TAKEOFF WITH RT AC BUS, TRU, ELEVATOR HORN, AND STALL WARNING HEAT CAUTION LIGHTS ON. WIRE TB2421A FOUND NOT SECURED.SDR QXEA9901590Skin · crackedPDX - LEFT NACELLE LOWER INBOARD FORWARD CORNER CUTOUT IS CRACKED. REPAIRED IAW DHC-8 RD 8-54-724.SDR CA990804029Adc · failed(CAN) PILOTS ALT FAILED ON TAKEOFF ROLL. NR 1 ADC REPLACED.SDR AU990703Coaming · cracked(AUS) FUSELAGE COAMING CRACKED. SIGNS OF IMPACT DAMAGE SUGGEST DAMAGE WAS CAUSED BY A BAGGAGE TUG.SDR QXEA9901598Seat Track · gougedPDX - RIGHT OUTBOARD SEAT TRACK AT X346 HAS A GOUGE. REPAIRED IAW DHC8 SRM 51-20-16.SDR QXEA9901595Seat Track · corrodedPDX - RIGHT OUTBOARD SEAT TRACK HAS PITS IN THE HAT CHANNEL AT X406. REPAIRED IAW DHC8 SRM 51-20-16.SDR QXEA9901593Spar · scratchedPDX - THERE IS A 3.5 INCH SCRATCH IN REAR SPAR AT YW RIGHT. REPAIRED IAW DHC8 SRM 51-20-11.SDR QXEA9901587Panel · chafedPDX - FUEL PANEL 524CT IS CHAFED AT INBOARD EDGE. REPAIRED IAW RD 8-57-320.SDR QXEA9901579Plate · corrodedPDX - FRETTING CORROSION AT BOTH ENDS OF LADDER PLATE 624AT. REPAIRED IAW RD 8-57-611 AND DHC8 SRM 51-20-16.SDR QXEA9901578Plate · corrodedPDX - FRETTING CORROSION AT BOTH ENDS OF LADDER PLATE 624BT. REPAIRED IAW RD 8-57-633.SDR CA990804028Transmitter · failed(CAN) WHILE IN CLIMB, NR 1 OIL PRESSURE READ APPROXIMATELY 52 PSI AND DROPPED SLOWLY TO 45-48 PSI. OIL PRESSURE STABLIZED AT 54 PSI WITH POWER LEVER AT FLIGHT IDLE AND CONDITION LEVER IN FEATHER.SDR CA990728012Deice Boot · disbonding(CAN) DURING A DAILY INSPECTION, IT WAS NOTED THAT THE RIGHT INBOARD DEICE BOOT WAS DISBONDING FROM THE LEADING EDGE. BOOT INSTALLATION WAS ONLY 161 HOURS.SDR CA990817001Tire · delaminating(CAN) DURING INSPECTION, NR 4 MAIN WHEEL TIRE WAS FOUND DELAMINATING THROUGH APPROXIMATELY 75 PERCENT OF THE INBOARD CIRCUMFERENCE OF THE TIRE TREAD AREA. TIRE WAS A THOMPSON RECAP.SDR CA990804025Line · leaking(CAN) BOTH NLG DRAG STRUT FLEX LINES FOUND WEEPING FLUID.SDR CA990728006Control Box · shorted(CAN) ERROR CODE 54 LEAD TO REPLACEMENT OF ANTI-SKID CONTROL UNIT WHICH WAS SHORTED INTERNALLY.SDR QXEA9901581Skin · chafedPDX - RIGHT OUTBOARD FLAP HAS A SMALL CHAFED AREA ON OUTBOARD END OF TOP SURFACE. REPAIRED IAW 57-20-11.SDR CA990804030Connector · failed(CAN) NR 1 A.C. GENERATOR FAILED ON TAKEOFF ROLL. PIN 'N' OF CONNECTOR 2421 -P5 AND J5 WAS BURNT. CONNECTOR REPAIRED.SDR CA990804022Flex Hose · chafed(CAN) PRESSURE LINE FROM NR 1SPU TO PRESSURE MANIFOLD WAS FOUND TO BE LEAKING WHERE THE LINE WAS SECURED. LINE CHAFED WHERE IT RUNS THROUGH THE SECURING BLOCK.SDR CA990804021Selector Valve · failed(CAN) ON APPROACH WITH GEAR DOWN, THE NLG DOOR AMBER, UNSAFE LIGHT AND HORN MOMENTARILY SOUNDED. PSEU REPLACED.SDR CA990804020Pseu · failed(CAN) ON APPROACH WITH GEAR DOWN ,THE NLG DOOR AMBER, UNSAFE LIGHT AND HORN MOMENTARILY SOUNDED. PSEU REPLACED.SDR HNAA9900097Battery · dischargedFIVE EMERGENCY FLOOR LIGHTS INOP. REMOVED AND REPLACED EMERGENCY PACK.SDR HNAA9900095Cover · leakingFUEL BOOST PUMP COVER HAS RUNNING LEAK. REPAIRED IAW EO8-57-99-730 & EO8-57-99-732. THIS HA-300 COVERS LEAK CHECK ONLY.SDR CA990728013Line · leaking(CAN) DURING INSPECTION, HYDRULIC FLUID FOUND DRIPPING FROM LEFT TRAILING EDGE. PRESSURE LINE TO THE OUTBOARD ROLL SPOILER WAS FOUND CHAFED.SDR CA990728011Brush Block · worn(CAN) NR 1 PROPELLER DEICE PHASE B CIRCUIT BREAKER TRIPS. PROPELLER DEICE BRUSH BLOCK REPLACED.SDR CA990728008Reu · failed(CAN) TOTAL COMM FAILURE ON FINAL APPROACH. REMOTE ELECTRONIC UNIT REPLACED.SDR HNAA9900092Angle · chafedNR 1 ENG HORSE COLLAR CHAFED ON INBOARD SIDE, FWD ANGLE DOUBLER. PART OF MONOCOQUE STRUCTURE OF NAC CAUSE BY BONDING STRAP DEPTH= .016. BLENDED AREA IAW EO8-54-99-727.SDR CA990804019Line · cracked(CAN) HYDRAULIC LEAK RIGHT REAR SPAR. LIFT DUMP PRESSURE LINE FOR THE RIGHT SPOILER VALVE WAS CRACKED.SDR PCAA9900023Relay · failedFLT 3629 - PHL, LANDING GEAR INOP AND CAUTION LIGHT ILLUMINATED. CREW DIVERTED INTO PHL. TROUBLESHOT LANDING GEAR CAUTION LIGHT SYSTEM. MEGGED AND RAN WIRES FROM COCKPIT TO RELAY PANEL. INSPECTED ALL WIRES FROM COCKPIT TO RELAY PANEL. FOUND COMPUTER ON MASSDR PCAA9900022Socket · failedFLT 3733 - ABE, LANDING GEAR INOP AND CAUTION LIGHT ILLUMINATED IN FLIGHT. CREW DIVERTED INTO ABE. MAINTENANCE TROUBLESHOT AND FOUND RELAY SOCKET AT 32-61-K7 BAD. REPLACED SOCKET, OPERATIONAL CHECK GOOD.SDR HNAA9900093Pcu · malfunctionedNR 2 ENG EXCEEDED 135 PERCENT TQ FOR LESS THEN 10 SEC. REMOVED AND REPLACED PROP, PCU, HMU, TSCU AND TQ PROB. INSPECTED OIL FILTERS AND BORESCOPED ENGINE.SDR CA990804024Line · leaking(CAN) DURING A WALK-A-ROUND, FLUID WAS NOTED COMING FROM THE NOSEWHEEL AREA. AFTER RUNNING THE A/C, A PINHOLE WAS FOUND IN THE NLG DOWN LINE IN THE OXYGEN BOTTLE AREA.SDR PCAA9900024Pseu · failedFLT 3559 - PHL, LANDING GEAR INOP AND CAUTION LIGHT CAME ON DURING CRUISE FLIGHT. CREW DIVERTED INTO PHL. MAINTENANCE TROUBLESHOT SYSTEM, PERFORMED SEVERAL RETRACTION TESTS AND COULD NOT DUPLICATE PROBLEM. REMOVED AND REPLACED PSEU FOR TROUBLESHOOTING.SDR PCAA9900021Valve · malfunctionedFLT 3635 - BWI, IN FLIGHT AFTER CRUISE POWER LEVERS WERE BROUGHT BACK TO IDLE, AN ELECTRICAL ODOR WAS NOTICED. MAINTENANCE RAN ACFT AND ISOLATED NR 2 ENGINE. INSPECTED ENGINE, NO LEAKS NOTED. REMOVED AND CLEANED AIR SWITCHING VALVE. REINSTALLED VALVE IAW PSDR HNAA9900096Ring · corrodedAREA WHERE ANTI-FRET RING RESTS AGAINST WITH CLAMP RING HAS SIGNS OF CORROSION APPROX DEPTH .005 - .008. REPAIRED IAW EO8-57-99-732.SDR CA990728007Line · leaking(CAN) FLUID LEAK IN THE NR 2 NACELLE AREA. HYDRAULIC RETURN LINE FROM THE NR 2 ACTUATOR. LINE WAS PART OF MOD 8/2781.SDR HNAA9900091Skin · dentedDENT ON INBOARD GROUND SPOILER UPPER SKIN AT INBOARD END. EXCEEDS MAX, CHORDWISE DIMENSION A OF RD8-27-014. COMPLIED WITH EO 8-53-99-240. MARKED DENT WITH YELLOW DOT.SDR HNAA9900090Skin · dentedDENT ON OUTBOARD ROLL SPOILER INBOARD OF CENTER HINGE. EDGE DISTANCE TO FWD FASTENER .625 OUT OF LIMITS OF RTD8-27-014. DENT IS ON UPPER SKIN. COMPLIED WITH EO 8-53-99-240. MARKED DENT WITH YELLOW DOT.SDR CA990728005Discharge Wicks · out of tolerance(CAN) PILOTS REPORTED BOTH RADIOS WERE UNREADABLE DUE TO STATIC WHILE FLYING IN CLOUD. SEVERAL TRAILING EDGE STATIC DISCHARGERS WERE TESTED OUT OF TOLERANCE AND REPLACED. REPLACED ALL CONDUCTIVE SEALS ON THE COMPOSITE NOSE COMP. ACCESS DOORS.SDR CA990715018Unknown · smoke(CAN) FLIGHT ATTENDANT REPORTED A SMOKY ODOR FROM THE LAV/GALLEY AREA. SMOKE DETECTED IN LAVATORY, DETECTOR WENT OFF SHORTLY AFTER. THERE WAS A STRONG SMELL OF SMOKE WITH NO VISIBLE SIGNS OF SMOKE. NO ABNORMALITIES FOUND.SDR CA990728004Electronic Cntrl · failed(CAN) ON TWO OCCASIONS, THE FLIGHT CREW EXPERIENCED A TORQUE ROLLBACK ON NR 1 ENGINE DURING CLIMB-OUT. THE EEC HAD REVERTED BACK TO MANUAL. CYCLING THE SELECTOR BROUGHT IT BACK ON LINE. EEC REPLACED.SDR CA990707058Indicator · stuck(CAN) ON TO ROLL NR 1 HYDRAULIC ISO VALVE CAUTION LIGHT AND INBOARD ROLL, SPOILER CAUTION LIGHT ILLUMINATED. INVESTIGATION REVEALED NO LEAKS, HOWEVER, THE NR 1 SYSTEM LEVEL WAS LOW. HYDRAULIC QUANTITY INDICATOR WAS STUCK WITH AN INDICATION HIGHER THAN WHAT WSDR CA990707022Tire · failed(CAN) NR 4 MAIN WHEELTIRE FAILED ON LANDING TO A 6 RUPTURE IN THE INNER SIDEWALL. TIRE WAS A THOMPSON RECAP ON ITS 3RD CYCLE.SDR QXEA9901374Light · inoperativePDX- COCKPIT OVERHEAD EMERGENCY LIGHT IS INOP. MAINTENANCE REPLACED THE OVERHEAD LIGHT ASSEMBLY, OPERATIONAL CHECKS GOOD.SDR HNAA9900076Frame · corrodedFRAME AT STATION X510 HAS CORROSION AND IS SPLIT WHERE IT MEETS THE SKIN. DAMAGE IS JUST O/B OF STRINGER 31S. MANUF REPAIR ANGLE IAW SRM 53-20-21. ALODINED AND PRIMED ANGLE, INSTALLED ANGLE AS REQUIRED.SDR HNAA9900073Fasteners · corrodedHORIZONTAL STAB ON UNDERSIDE, 4 HI-LOKS CORRODED AT CENTER BOX, CENTER DOUBLER AFT ROW (MARKED). REMOVED AND REPLACED HI-LOKS.SDR HNAA9900072Frame · corrodedFRAME AT STATION X510 HAS CORROSION AND IS SPLIT WHERE IT MEETS THE SKIN. DAMAGES ARE JUST O/B OF STRINGER 31S. MANUFACTURED REPAIR ANGLE IAW SRM 53-20-21, ALODINED AND PRIMED ANGLE. REMOVED AND REPLACED FRAME LEG.
Back to Boeing DHC-8-102