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 QXEA9700488Skin · gougedGOUGE ON TOP SURFACE OF LEFT INBOARD FLAP 4.5 FORWARD OF TRAINING EDGE AND 26 OUTBOARD OF INBOARD SIDE. REPAIRED FLAP TRAILING EDGE PER DHC SRM 51-70-00 REPAIR NR 5 PAGE 501-502.SDR PCAA9700485Connector · looseFORWARD RED EMERGENCY PATH LIGHTS INOP. CLEANED AND SECURED CANNON PLUG UNDER FLOOR. OPERATIONAL CHECK NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9700484Lamp · failedONE FLOOR EMERGENCY ESCAPE PATH LIGHT INOP AT ROW 8DF. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975515Bulb · failedDURING INSPECTION, EXIT LIGHT 1E WAS FOUND INOPERABLE. MAINTENANCE RE-LAMPED. ALL CHECKS GOOD. (X)SDR MALA975513Probes · internal faultFLT 3277 - AFTER TAKEOFF, NR 1 ENGINE ITT WAS 311 DEGREES. CYCLED BREAKER. NO CHANGE. RETURNED TO MSP. MAINTENANCE REPLACED FOUR THERMOCOUPLE PROBES. OPS CHECK GOOD. (X)SDR CA970715002Shaft · corroded(CAN) RIGHT HAND OUTBOARD SLAT CARRIAGE SHAFT FOUND CORRODED INTERNALLY. SHAFT TO BE REPLACED.SDR CA970715001Wire · broken(CAN) RIGHT HAND ROLL SPOILER CLUTCH WIRE BROKEN AT MICRO SWITCH. WIRE REPAIRED.SDR QXEA9700322Pseu · malfunctionON APPROACH WHEN LANDING GEAR SELECTED DOWN, HAD 3 RED LANDING GEAR UNSAFE LIGHTS AND A LANDING GEAR HANDLE DISAGREEMENT LIGHT. PERFORMED AND ALTERNATE EXTENSION OF THE LANDING GEAR, AND ACCOMPLISHED A UNEVENTFUL LANDING. REPLACED THE PROXMITY SENSOR ELECTROSDR PCAA9700483Bulb · failedFLT 3968 - ON APPROACH TO EWR UPON LANDING GEAR EXTENSION, LEFT MAIN GEAR DOWN INDICATION WAS IN OPERATIVE. CREW VERIFIED GEAR POSITION WITH ALTERNATE INDICATION SYSTEM. AN UNEVENTFUL LANDING WAS ACCOMPLISHED. REMOVED AND REPLACED BULBS IN LEFT MAIN LANDINGSDR MALA975512Lamp · failedDURING INSPECTION, ONE FLOOR TRACK LIGHT WAS FOUND INOPERABLE. MAINTENANCE RE-LAMPED. OPS CHECK GOOD. (X)SDR QXEA9700493Panel · elongated holesPANEL 624BT HAS AN ELONGATED SCREW HOLE ON THE FORWARD EDGE AT CENTER. REPAIRED PER EA 9-57-256.SDR PCAA9700482Wire · looseLOWER RIGHT CABIN EMERGENCY EXIT LIGHT INOPERATIVE. FOUND WIRE LOOSE IN PLUG. RESECURED WIRE IN PLUG. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975509Lamp · failedDURING INSPECTION, FLOOR TRACK EMERGENCY LIGHT WAS FOUND INOPERABLE. MAINTENANCE RE-LAMPED. OPS CHECK GOOD. (X)SDR MALA975507Computer · failedFLT 2902 - AFTER LIFT OFF, EXPERIENCED A STICK SHAKER CONTINUOUSLY SHAKING, SPEED INDICATOR ON ADI WAS STUCK ON LOW SIDE. RETURNED TO DTW. MAINTENANCE REPLACED NR 1 LIFT TRANSDUCER AND COMPUTER AND REPAIRED CHAFED WIRE. ALL CHECKS GOOD. (X)SDR QXEA9700319Battery Pack · dischargedSEA- TWO FORWARD RED EGRESS LIGHTS ARE INOP. REPLACED BATTERY PACK AT 1ED. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR PCAA9700481Light · inoperativeCOCKPIT PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT PORTABLE EMERGENCY LIGHT WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975506Lamp · failedDURING INSPECTION, ONE FLOOR TRACK LIGHT WAS FOUND INOPERABLE. MAINTENANCE RE-LAMPED. OPS CHECK GOOD. (X)SDR MALA975505Lamp · failedDURING INSPECTION, ONE FLOOR TRACK LIGHT WAS FOUND TO BE INOP. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (M)SDR QXEA9700483Angle · crackedCRACK IN FRAME JOINT SPLICE ANGLE AT STATION X 136.800 AND STRINGER 15A RIGHT SIDE. REMOVED AND REPLACED FRAME PER DHC SRM 51-40-11.SDR PCAA9700480Lamp · failedONE LAMP INOPERATIVE AT ROW 7 IN EMERGENCY FLOOR PATH LIGHTING. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700475Light · inoperativeCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700442Battery · looseSEVERAL LAMPS INOPERATIVE IN EMERGENCY FLOOR PATH LIGHTING. FOUND NR 3 BATTERY LOOSE IN CASE. RESECURED BATTERY. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA9700477Skin · corrodedCORROSION ON LOWER AIRCRAFT SKIN UNDER TCAS ANTENNA DOUBLER PLATE. REPAIRED PER EA 9-53-308.SDR QXEA9700476Beam · corrodedCORROSION ON LOWER SUPPORT BEAM FOR CLOSET VERTICAL BEAM JUST OUTBOARD OF STRINGER 31, LEFT SIDE FORWARD OF FRAME 215.500. REPLACED SUPPORT BEAM PER EA 9-53-307.SDR QXEA9700475Stringer · corrodedSTRINGER 31 RIGHT SIDE HAS CORROSION AROUND AND UNDER FASTENERS FROM FRAME 467 TO FRAME 510. REPLACED STRINGER PER EA 9-53-304.SDR PCAA9700474Lamp · failedAFT ISLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. ACTC: 7,916. (X)SDR PCAA9700472Battery · dischargedTWO LIGHTS IN EMERGENCY FLOOR PATH LIGHTING INOPERATIVE. FOUND BATTERY IN NR 400 POSITION BAD. REMOVED AND REPLACED BATTERY WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700470Selector Valve · leakingROC - EN ROUTE - THE LANDING GEAR WOULD NOT EXTEND UNDER NORMAL CONDITIONS. CREW PERFORMED AN ALTERNATE EXTENSION AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND THE LANDING GEAR SELECTOR VALVE LEAKING. REMOVED AND REPLACED VALVE IAW DHC MM. GSDR PCAA9700473Lamp · failedONE LIGHT INOPERATIVE IN EMERGENCY FLOOR PATH LIGHTING. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975500Light · inoperativeDURING INSPECTION, TWO FLOOR TRACK EMERGENCY LIGHTS AND ONE FORWARD EMERGENCY OVERHEAD EXIT LIGHT HAS BULBS BURNED OUT. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (M)SDR MALA975499Battery Pack · dischargedDURING INSPECTION, EMERGENCY FLOOR TRACK LIGHTS WERE FOUND INOP. MAINTENANCE REPLACED BATTERY PACK. OPS CHECK GOOD. (M)SDR PCAA9700479Seat Track · corrodedINBOARD RIGHT SEAT TRACK CORRODED FROM STATION 215 TO STATION 187. REMOVED AND REPLACED INBOARD RIGHT SEAT TRACK IAW DEHAV DRAWINGS 85320490, 85320019 AND REPAIR DRAWING 8-53-1102. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700478Seat Track · damagedLEFT INBOARD SEAT TRACK CORRODED UNDER WARDROBE FLOOR PANEL. REPLACED DAMAGED SECTION OF SET TRACK IAW DEHAVILLAND REPAIR DRAWINGS 8-53-1932, 8-53-1102, 8-53-2596 AND 8-53-2688. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700469Battery Pack · dischargedARMREST LEVEL EMERGENCY LIGHTS ON AIRSTAIR DOOR IN ROW 1A INOP. REMOVED AND REPLACED FORWARD BATTERY PACK. OPERATION CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700466Light · inoperativeCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975504Oil System · req'd serviceFLT 3482 - AFTER TAKEOFF, THE NR 1 ENGINE OIL PRESSURE GAUGE AND WARNING LIGHT INTERMITTENTLY ILLUMINATED. AIRCRAFT RETURNED TO MSP. MAINTENANCE ADDED OIL AND GROUND RAN AIRCRAFT. OIL PRESSURE NORMAL. ALL CHECKS GOOD. (M)SDR MALA975498Light · inoperativeDURING C-CHECK, FOUND ON FLOOR TRACK LIGHTING, 3RD LIGHT INOP. MAINTENANCE REPLACED LIGHT ASSEMBLY. OPS CHECK GOOD. (M)SDR HNAA9791659Hydraulic Line · failedFLT 3480 - HHH-CLT - WHILE DESCENDING FOR A CLT ARRIVAL, THE NR 1 HYDRAULIC SYSTEM LOST QTY AND PRESSURE. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT LANDED WITHOUT INCIDENT. INSTALLED A TEMP FLEX LINE FROM THE HYDRAULIC PRESSURE MANIFOLD IN TH NR 1 NACELLE TSDR CA970707001Shaft · corroded(CAN) RIGHT HAND INBOARD AND OUTBOARD FLAP SHAFT BOLTS FOUND WITH INTERNAL CORROSION.SDR QXEA9700487Skin · delaminatedLEFT OUTBOARD FLAP COMPOSITE LEADING EDGE IS DELAMINATED BETWEEN FLAP PANELS 524BL TO 524CL. INSTALLED NEW LEADING EDGE SECTION PER DHC SRM 51-20-11.SDR QXEA9700486Skin · delaminatedLEFT OUTBOARD FLAP TRAILING EDGE COMPOSITE IS DELAMINATED AROUND ATTACH RIVETS ALONG FLAP AFT SPAR LOWER CAP FROM YW 174 TO YW 232. INSTALLED NEW TRAILING EDGE SECTION PER DHC SRM 51-40-11.SDR QXEA9700482Structure · damagedLT APERATURE FORWARD INBOARD TO OUTBOARD RUN HAS HEAVY RUB DAMAGE. BLENDED AREA AND ACCOMPLISHED REPAIR PER EA 9-57-274.SDR QXEA9700481Fitting · damagedTHE RIGHT HAND AFT BATHTUB FITTING HAS RUB DAMAGE IN 2 PLACES FROM ALTERNATE FLAP DRIVE HOUSING. REPAIRED PER EA 9-53-287A.SDR PCAA9700467Lamp · failedONE CENTER AISLE OVERHEAD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. ACTC: 7,881. (X)SDR QXEA9700492Plate · corrodedRIGHT WING INBOARD END OF LADDER PLATE FOR PANEL 624CT HAS FRETTING CORROSION. REPAIRED PER EA 9-57-261.SDR QXEA9700491Plate · corrodedRIGHT WING OUTBOARD END OF LADDER PLATE FOR 624BT HAS FRETTING CORROSION. FOUND WITHIN LIMITS PER RD 8-57-611. REMOVED CORROSION.SDR QXEA9700490Plate · misdrilledRIGHT WING OUTBOARD END OF LADDER PLATE FOR 624AT FORWARD SIDE FIRST HOLE BEFORE CORNER WAS MISDRILLED INTO LADDER PLATE APPROX .075 TP .090 DEEP. REPAIRED PER EA 9-57-251.SDR QXEA9700485Plate · corrodedLEFT WING LADDER PLATE HAS FRETTING CORROSION UNDER INBOARD AND OUTBOARD ENDS OF PANEL 524AT. LADDER PLATE FOUND WITHIN LIMITS PER RD 8-57-611. REMOVED CORROSION.SDR QXEA9700484Plate · corrodedLEFT WING LADDER PLATE HAS FRETTING CORROSION UNDER INBOARD AND OUTBOARD ENDS OF PANEL 524CT. INSPECTED AND FOUND LADDER PLATE WITHIN LIMITS PER RD 8-57-611.SDR QXEA9700480Skin · dentedTHERE IS AN OIL CANNING STYLE DENT AT STATION 456, 5 ABOVE THE LEFT FUSELAGE SKIN SPLICE STRAP. REPAIRED PER EA 9-53-299.
Back to Boeing DHC-8-102