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 QXEA9700479Skin · nickedTHERE ARE 2 NICKS IN THE FUSELAGE SKIN JUST FORWARD OF FRAME AT STRINGER 151.6. REPAIRED PER EA 9-53-295.SDR QXEA9700474Skin · damagedTHERE IS A DENT WITH A DEEP GOUGE JUST FORWARD OF FRAME 387.350, 10 OUTBOARD OF THE LOWER RIGHT SKIN SPLICE STRAP. REPAIRED DAMAGE IN FUSELAGE SKIN PER EA 9-53-298.SDR QXEA9700473Skin · dentedTHERE IS A DENT JUST FORWARD OF STATION 201.15 AND JUST OUTBOARD OF STRINGER 30, RIGHT HAND. INSPECTED AND PLACED ON MRSI FOR INSPECTION AT NEXT C-CHECK.SDR QXEA9700472Rivet · misinstalledOUTBOARD SIDE OF NOSE WHEEL BAY, RIGHT SIDE WALL UPPER EDGE HAS A RIVET WITH THE HOLE EDGE SHOWING NEXT TO A PREVIOUS REPAIR CUTOUT IN AREA OF O2 BOTTLE REGULATOR JUST FORWARD OF LATTERAL BEAM AT STATION X 97.00. FABRICATED AND REPAIRED PER RD 8-53-675.SDR QXEA9700469Beam · crackedNOSE COMPARTMENT DECK LATERAL BEAM AT STATION X 97.00 LEFT END OF FUSELAGE STRUCTURE IS CRACKED OUT AT RIVETS. REPAIRED PER EA 9-53-286.SDR PCAA9700468Lamp · failedLEFT FORWARD EMERGENCY EGRESS LIGHT INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR HNAA9792458Angle · crackedFOUND DURING PHASE CHECK, THE RIGHT OUTER NOSE LANDING GEAR WELL ANGLE WAS CRACKED AT THE SIDEWALL. REMOVED AND REPLACED THE ANGLE IAW ESR8-53-93-11. (M)SDR QXEA9700489Spar · scratchedRIGHT WING FRONT SPAR FROM APPROX YW 288.0 TO APPROX YW 243.00 HAS A DEEP SCRATCH APPROX .001 TO .003 DEEP. REPAIRED FRONT SPAR PER EA 9-57-249.SDR QXEA9700478Angle · crackedRIGHT FORWARD WING SPAR TO FUSELAGE CLOSING ANGLE IS CRACKED IN THE RADIUS. INSTALLED NEW CLOSING ANGLE PER DHC SRM 51-40-11.SDR QXEA9700471Support · crackedNOSE GEAR UPPER DECK SUPPORT STRUCTURE FOR TRUNNION ASSY HAS A CRACK IN SUPPORT STRUCTURE THAT EXTENDS THROUGH THE LOWER RADIUS ON THE LEFT FORWARD SIDE. REPAIRED PER EA 9-53-286.SDR QXEA9700470Support · sheared rivetsNOSE GEAR UPPER DECK SUPPORT STRUCTURE FOR TRUNNION ASSY HAS 2 SHEARED RIVET HEADS ON LEFT SIDE FORWARD. REPAIRED PER EA 9-53-286.SDR QXEA9700312Oil Cooler · malfunctionAFTER TAKEOFF, NR 2 ENGINE OIL TEMPERATURE STARTED UP INTO THE YELLOW AND NR 2 FUEL FLOW WAS IN THE YELLOW. PULLED TO FLIGHT IDLE AND RETURNED TO FIELD, LANDED WITHOUT INCIDENT. REPLACED NR 2 OIL TEMPERATURE INDICATOR, OIL TMPERATURE BULB, OIL COOLER AND VERSDR MALA975491Lens · missingDURING INSPECTION, 4A EMERGENCY LIGHT COVER MISSING. MAINTENANCE REPLACED LENS. OPS CHECK GOOD. (M)SDR CA970715016Proximity Sensor · wire broken(CAN) ON APPROACH, THE CREW RECEIVED AN UNSAFE LANDING GEAR INDICATION FOR THE NOSE GEAR. ALTERNATE GEAR EXTENSION CARRIED OUT. INSPECTION FOUND A BROKEN WIRE ON THE NOSE GEAR DRAG STRUT DOWNLOCK PROXIMITY SENSOR. SENSOR AND WIRING HARNESS REPLACED.SDR MALA975486Lens · fell offDURING INSPECTION, ONE EMERGENCY LIGHT LENS POPPED OFF. MAINTENANCE REINSTALLED LENS. (X)SDR MALA975490Bulb · failedDURING INSPECTION, EMERGENCY LIGHT BURNED OUT AT EMERGENCY EXIT ESCAPE. MAINTENANCE RELAMPED. OPS CHECK GOOD. (X)SDR CA970709014Release Cable · frayed(CAN) MAIN LANDING GEAR RELEASE EMERGENCY CABLE FOUND FRAYED WHERE IT ATTACHES TO THE HANDLE IN THE COCKPIT ROOF. CREW FOUND IT DURING PREFLIGHT. REF. DHC ACTIVITIES REPORT 96-07-3235.SDR PCAA9700461Light · inoperativeONE LIGHT INOPERATIVE IN FLOOR EMERGENCY PATH LIGHTING. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700460Tube Assembly · failedDURING CRUISE FLIGHT, THE NR 1 HYDRAULIC CONTENT DROPPED TO ZERO. A/C DIVERTED INTO PVD AND LANDED WITHOUT INCIDENT. MX FOUND THE HYDRAULIC LINE FROM THE NR 1 FAULT. INSTALLED INTERMIM FLEX LINE IAW DHC MM. OPERATION AND LEAK CHECKED GOOD. THE ENGINE DRIVSDR MALA975484Blade Assy · damagedCMX - FLT 2928 - DURING CLIMB OUT, LEFT ENGINE PROPELLER EROSION STRIP SEPARATED FROM PROPELLER. FLIGHT RETURNED TO CMX. MAINTENANCE REPLACED LEFT PROPELLER NR 1 BLADE ASSEMBLY. OPS AND LEAK CHECK GOOD. (X)SDR MALA975482Lamp · inoperativeDURING INSPECTION, ONE RED FLOOR TRACK EMERGENCY LIGHT FOUND INOPERABLE. MAINTENANCE RELAMPED. OPS CHECK GOOD. (X)SDR MALA975481Battery Pack · dischargedDURING INSPECTION, THREE CEILING EMERGENCY LIGHTS FOUND INOPERABLE. MAINTENANCE REPLACED BATTERY PACK. OPS CHECK GOOD.SDR AU970809Generator · failed(AUS) LH AND RH ENGINE DRIVEN DC GENERATORS FAILED - LH AC BUS ALSO FAILED - SUSPECT CAUSED BY STATIC DISCHARGESDR QXEA9700307Fuel Pump · malfunctionLEFT ENGINE LOST POWER, RETURNED TO FIELD WITHOUT INCIDENT. REPLACED THE NR 1 HP FUEL PUMP, OPERATIONAL CHECK GOOD.SDR PCAA9700462Light · inoperativeLIGHT AT ROW 9 IN FLOOR EMERGENCY PATH LIGHTING INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975479Bulb · failedDUIRNG INSPECTION, ROW 5D FLOOR TRACK LIGHT WAS FOUND TO BE INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR AU970824Autopilot · faulty(AUS) AUTOFLIGHT CONTROL SYSTEM (AFCS) SUSPECT FAULTY - UNUSUAL ADVISORY MESSAGES - SEE MDR 97/0808 FOR SIMILAR DEFECTSDR AU970808Autopilot · malfunction(AUS) AUTOFLIGHT CONTROL SYSTEM (AFCS) SUSPECT FAULTY - UNUSUAL ADVISORY MESSAGESSDR QXEA9700303Smoke Detector · malfunctionedNR 2 BAG SMOKE DETECTOR TESTS OK BUT DOES NOT STOP WHEN SWITCH IS RELEASED. REPLACED SMOKE DETECTOR, OPERATIONAL CHECK GOOD.SDR PCAA9700464Light · inoperativeTWO LAMPS INOPERATIVE IN EMERGENCY FLOOR PATH LIGHTING. REMOVED AND REPLACED LAMPS. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700463Battery Pack · dischargedTWO LIGHTS INOPERATIVE IN FLOOR EMERGENCY PATH LIGHTING BY ROW 1DF. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975478Lens · crackedDURING C-CHECK, THE AFT FLOOR TRACK EMERGENCY LIGHT LENS WAS FOUND TO BE BROKEN. A NEW LENS IS TO BE INSTALLED PRIOR TO COMPLETION OF THE C-CHECK. (M)SDR PCAA9700465Light · inoperativeOVERHEAD EMERGENCY LIGHT IN ROW 7 INOPERATIVE. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975477Oil System · req'd serviceFLT 2913 - AFTER TAKEOFF, NR 1 ENGINE OIL PRESSURE WARNING LIGHT ILLUMINATED. OIL PRESSURE GAUGE FLUCTUATED AND THEN RETURNED TO NORMAL. RETURNED TO AZO. MAINTENANCE SERVICED LEFT ENGINE OIL WITH TWO QUARTS. RAN AIRCRAFT. ALL ENGINE PARAMETERS ARE NORMAL.SDR MALA975476Lamp · failedDURING INSPECTION, THREE EMERGENCY FLOOR TRACK LIGHTS WERE FOUND INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR QXEA9700299Bulb · failedAFT CEILING EMERGENCY LIGHT INOP. RELAMPED AFT CEILING EMERGENCY LIGHT, OPERATIONAL CHECKS GOOD.SDR PCAA9700457Plate · corrodedRIGHT WING INBOARD STRESS PANEL LADDER PLATE HAS CORROSION PITS ON UPPER SURFACE, UNDER 622AT. REPAIRED CORRODED AREAS IAW DHC REPAIR DRAWING 8-57-915. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700456Access Panel · corrodedPANEL 622AT WAS FOUND TO EXHIBIT MINOR CORROSION, DURING A ROUTINE C-CHECK. REMOVED AND REPLACED PANEL IAW DHC MM. PANEL SCHEDULED FOR REPAIR IAW DHC INSTRUCTIONS. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975475Lamp · failedDURING INSPECTION, FLOOR TRACK LIGHTS 1D AND 7D WERE FOUND INOPERABLE AND RIGHT FORWARD SIDE WALL LIGHT WAS ALSO FOUND INOPERABLE. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (X)SDR PCAA9700455Cover · missingEMERGENCY EXIT LIGHT COVER MISSING IN ROW 4F, RT SIDE. INSTALLED NEW ASSEMBLY. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975473Bulb · failedDURING INSPECTION, RIGHT FORWARD EMERGENCY EXIT WALL LIGHT HAS THREE BULBS INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR CA970626018Battery · overtemp(CAN) BATTERY TEMPERATURE STARTED TO CLIMB DURING FLIGHT AND BATTERY CAUTION LIGHT CAME ON. BATTERY REPLACED.SDR QXEA9700298Fire Light · illuminatedNR 1 ENGINE FIRE DETECTION FAULT B ILLUMINATED. PLACED ON MEL. AIRCRAFT RETURNED TO SERVICE.SDR PCAA9700454Tube Assembly · failedEN ROUTE TO MHT, THE HYDRAULIC PRESSURE WENT TO ZERO ON THE NR 1 SYSTEM WITH A COMPLETE LOSS OF CONTENTS. INSTALLED INTERIM FLEX LINE ON NR 1 PRESSURE MANIFOLD TO ANTI-SKID CONTROL IAW DHC MM. PERFORMED PROCEDURES OUTLINED IN DHC MAINTENANCE MANUAL 05-30. SSDR MALA975471Bulb · failedDURING INSPECTION, THE FIRST RED FLOOR TRACK EMERGENCY LIGHT WAS FOUND INOPERABLE. MAINTENANCE RELAMPED. OPS CHECK GOOD. (X)SDR CA970625008Card · failed(CAN) DURING CLIMB, NOSE AND RIGHT DOOR AMBER, LEFT AND NOSE GEAR GREEN LIGHTS ON NOSE RED LIGHT AND AMBER HANDLE LIGHTS ALSO ON AT EXTENSION ALL GREEN AND NOSE AND RIGHT MAIN AMBER LIGHTS ON FAULT CODES IDENTIFIED DURING PSEU GROUND TEST. CARD FAULTS FOUNDSDR MALA975462Control · failedPOST-FLIGHT, EMERGENCY LIGHT WILL NOT SHUT OFF. REMOVED AND REPLACED EMERGENCY LIGHT CONTROL BOX AND BATTERY PACKS. ALL CHECKS GOOD. EMERGENCY LIGHT CONTROL 82410162-007. BATTERY PACKS 61-0478-9. REF: OPERATOR CONTROL NR 97ZZZX3063. (X)SDR CA970625007Spu · smoking(CAN) DURING OPERATION OF #2 HYDRAULIC STANDBY POWER UNIT FOR MAINTENANCE TASK, THE SPU BEGAN BILLOWING SMOKE AND SPARKS. IT WAS IMMEDIATELY SHUT DOWN, 2 EXTERNAL POWER FUSES (30 AMP) WERE FOUND BLOWN. FUSES AND SPU REPLACED.SDR 97ZZZX3063Battery Pack · dischargedPOST-FLIGHT, EMERGENCY LIGHT WILL NOT SHUT OFF. REMOVED AND REPLACED EMERGENCY LIGHT CONTROL BOX AND BATTERY PACKS. ALL CHECKS GOOD. EMERGENCY LIGHT CONTROL 82410162-007. BATTERY PACKS 61-0478-9. REF: OPERATOR CONTROL NR MALA975462. (X)SDR PCAA9700451Bulb · failedFORWARD LEFT EMERGENCY EXIT SIGN AT FLOOR LEVEL HAS 2 BULBS INOPERABLE. REMOVED AND REPLACED BULBS PER DASH 8 MM 33-51-11. OPERATION CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE. ACTC: 21,110. (X)
Back to Boeing DHC-8-102