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 MALA975469Heat Controller · failedFLT 3195 - DURING FLIGHT, CREW REPORTED BURNT OR ELECTRIC SMELL IN COCKPIT FOLLOWED BY THE RIGHT WINDSHIELD HOT LIGHT. MAINTENANCE REPLACED RIGHT AND LEFT WINDSHIELD HEAT CONTROLLER. OPS CHECK GOOD. (X)SDR PCAA9700452Lens · missingLEFT EMERGENCY EXIT SIGN MISSING LENS. INSTALLED EXIT LENS ON LEFT EMERGENCY EXIT SIGN PER 8MM 33-51-00. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700449Windshield · crackedCAPTAINS WINDSHIELD WAS FOUND CRACKED ON POST FLIGHT INSPECTION. REMOVED AND REPLACED CAPTAINS WINDSHIELD IAW DHC MM. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975467Bulb · failedDURING INSPECTION, ONE FLOOR TRACK LIGHT WAS FOUND INOPERABLE. MAINTENANCE RELAMPED. OPS CHECK GOOD. (X)SDR PCAA9700447Tube · failedUPON DESCENT INTO BGM, THE CREW REPORTED THE NR 1 HYDRAULIC QTY AND PRESSURE WERE LOST. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE HYDRAULIC PRESSURE LINE FROM THE NR 1 PRESSURE MANIFOLD TO THE ANTI-SKID BROKEN. REMOVED AND REPLACED LINE IAW DHSDR PCAA9700453Light · brokenRIGHT AFT EMERGENCY EXIT DOOR LIGHT FOUND BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW DHC MM. OPERATION CHECKED GOOD. A/C RETURNED TO SERVICE. (M)SDR PCAA9700450Light · inoperativeLEFT AFT CABIN EMERGENCY EXIT INTERIOR LIGHT BROKEN. REMOVED AND REPLACED LEFT AFT EMERGENCY LIGHT ASSEMBLY. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700448Seat Track · corrodedDURING C-CHECK, THE LEFT INBOARD SEAT RAIL WAS FOUND CORRODED IN AREA OF WARDROBE. REPAIRED CORRODED AREA IAW DHC REPAIR DRAWING 8-53-2893. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975464Gcu · failedFLT 3003 - DURING FLIGHT, THE RIGHT AC GENERATOR FELL OFF LINE AND WILL NOT RESET. AIRCRAFT RETURNED TO MSP. MAINTENANCE REMOVED AND REPLACED NR 2 GCU. OPS CHECK GOOD. (X)SDR MALA975463Bulb · failedDURING INSPECTION, EMERGENCY EXIT LIGHT WAS FOUND INOPERABLE. MAINTENANCE RELAMPED. OPS CHECK GOOD. (X)SDR CA970625006Line · chafed(CAN) #2 HYDRAULIC QUANTITY SYSTEM AT ZERO. #2 HYDRAULIC SYSTEM LINE FROM ENGINE DRIVEN HYDRAULIC PUMP FOUND CHAFED AND LEAKING.SDR CA970625005Line · chafed(CAN) #2 HYDRAULIC QUANTITY AT ZERO. DRAG STRUT ACTUATOR LINE FOUND CHAFED AND LEAKING. LINE REPLACEDSDR QXEA9700235Indicator · malfunctionABORTED TAKEOFF, FOR TAKEOFF WARNING HORN. REPLACED FLAP POSITION INDICATOR, OPERATIONAL CHECKS GOOD.SDR PCAA9700437Actuator · failedFLT 3642 - RIGHT MAIN FORWARD GEAR DOOR REMAINED OPEN AFTER GEAR RETRACTION. AIRCRAFT RETURNED TO PHL. REMOVED AND REPLACED RIGHT FORWARD GEAR DOOR ACTUATOR. RETRACTION TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700436Takeoff Warning · soundedTAKEOFF WARNING SOUNDED ON TAKEOFF ROLL RECONFIGURED AIRCRAFT AND PERFORMED GROUND CHECK OF TAKEOFF WARNING HORN SYSTEM. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR SABA9700028Temp Monitor · inoperativeCLT - FLT 5136 - SMELL OF SMOKE IN COCKPIT, INDICATION OF BOTH MAIN AND AUX BATTERIES BEING HOT (SUSPECT BAD SENSOR FPR INDICATION CREW MADE INSPECTION OF BATTERIES WERE NOT HOT). REMOVED AND REPLACED BATTERY TEMP MONITOR. OPS CHECKED GOOD. (M)SDR PCAA9700438Prox Switch · out of adjustFLT 3535 - RIGHT FORWARD MAIN LANDING GEAR DOOR REMAINED OPEN AFTER GEAR RETRACTION. RETURNED TO FIELD. ADJUSTED RIGHT FORWARD MAIN LANDING GEAR DOOR PROXIMITY SWITCH. OPERATIONAL AND RETRACTION TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA9700230Battery Pack · dischargedAFT LEFT OUTSIDE EMERGENCY LIGHT INOP. REPLACED BATTERY PACK, OPERATIONAL CHECK GOOD.SDR PCAA9700439Light · inoperativeONE LIGHT INOPERATIVE IN FLOOR EMERGENCY PROXIMITY LIGHTING. REMOVED AND REPLACED LAMP. OPERATIONAL CHECK NORMAL. A/C RETURNED TO SERVICE. (M)SDR HNAA9791654Hinge · failedFLT 3395 - YYZ-BWI - THE RIGHT MAIN LANDING GEAR DOOR WAS HANGING DOWN IN FLIGHT. THE AIRCRAFT CONTINUED ON TO BWI AND LANDED WITHOUT INCIDENT. REMOVED AND REPLACED FORWARD GEAR DOOR AFT HINGE ARM ASSEMBLY AND HARDWARE. PERFORMED EXTENSION AND RETRACTION THSDR PCAA9700446Light · inoperativeSEVERAL EMERGENCY EXIT SIGN LIGHTS OUT. REMOVED AND REPLACED LAMPS. OPERATIONAL CHECK NORMAL. A/C RETURNED TO SERVICE. (M)SDR CA970618021Spring · broken(CAN) GUST LOCK FELT WEAK. TOP SPRING FOUND BROKEN FROM AFT END ATTACHING POINT. SPRING HAD BECOME JAMMED BETWEEN PULLEY AND PULLEY BRACKET AND CAUSED SLIGHT WEAR ON PULLEY. BOTH TOP AND BOTTOM SPRINGS REPLACED.SDR PCAA9700445Battery · dischargedSEVERAL EMERGENCY LIGHTS IN AISLE AND RIGHT AFT EXTERIRO EGRESS LIGHT IS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AND REPLACED BULB IN RIGHT AFT EXTERIOR EGRESS LIGHT. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700443Bulbs · failedTWO BULBS INOPERATIVE IN FLOOR EMERGENCY PATH LIGHTING. REMOVED AND REPLACED LAMPS. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA9700231Light · inoperativeCOCKPIT OVERHEAD EMERGENCY LIGHT INOP. REPLACED LIGHT ASSEMBLY, OPERATIONAL CHECK GOOD.SDR QXEA9700227Smoke Detector · no testNR 2 BAGGAGE SMOKE DETECTOR IN THE CARGO COMPARTMENT WILL NOT TEST. PLACED ON MEL, REFERENCE 26-6.SDR MALA975460Bulb · failedDURING INSPECTION, ONE FLOOR TRACK LIGHT WAS FOUND TO BE INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR PCAA9700434Acm Machine · failedIN FLIGHT, CABIN AND COCKPIT FILLED WITH SMOKE VISIBLE WITH ODOR. SMELLED LIKE SMOKING OIL OR OVERHEATED DUCTING NO COCKPIT INDICATIONS OF PROBLEM. REMOVED AND REPLACED ACM AND HEAT EXCHANGER. OPERATIONAL TEST IN ALL MODES NORMAL. AIRCRAFT RETURNED TO SERVSDR QXEA9700224Bolt · missingAFTER TAKEOFF ON LANDING GEAR RETRACTION, THE RIGHT MAIN LANDING GEAR FORWARD DOOR REMAINED IN THE OPEN POSITION. AIRCRAFT RETURNED TO THE FIELD AND ACCOMPLISHED AN UNEVENTFUL LANDING. INSPECTED AND FOUND SAFE FOR FERRY FLIGHT FROM SEA TO PDX. IN PDX, FOUNDSDR MALA975454Brush Block · failedFLT 3281 - DURING CRUISE FLIGHT THE NR 2 A/C GENERATOR LIGHT ILLUMINATED. CREW FOLLOWED QUICK REFERENCE HANDBOOK, WITH NO CHANGE. AIRCRAFT RETURNED TO MSP. MAINTENANCE REMOVED AND REPLACED NR 2 ENGINE BRUSH BLOCK P/N 782689-3 AND NR 1 ENGINE GCU P/N 51608-0SDR CA970610009Tube Assembly · cracked(CAN) HYDRAULIC LINE FOUND LEAKING AT LEFT HAND INBOARD ROLL SPOILER ACTUATOR. A SMALL CRACK WAS FOUND IN THE 180 DEGREES RADIUS.SDR CA970609001Wire · broken(CAN) TORQUE INDICATION WENT TO 160 PERCENT. ENGINE AND PROP FUNCTIONING NORMALLY. NO EVIDENCE OF OVER-TORQUE OCCURRING. BROKEN WIRE FOUND AT PLUG 9811 P14 IN THE WING ROOT AREA.SDR PCAA9700435Dc Gen System · malfunctionedFLT 7810 - BWI-MDT - DURING CLIMB NR 1 AND NR 2 DC GENERATOR LIGHTS FLICKERED. LOST PRESSURIZATION CONTROLLER, TCAS, RNAV, ALTITUDE SELECT, RADAR ALTIMETER, CAPTAINS FLIGHT DIRECTOR AND CAPTAINS ALTIMETER. FIRST OFFICERS SIDE NORMAL. REMOVED AND REPLACED APSDR MALA975461Battery Pack · dischargedDURING INSPECTION, BOTH FRONT EXIT SIGNS WERE FOUND TO BE INOP. MAINTENANCE REPLACED BATTERY PACKS. (M)SDR MALA975451Connector · looseON START, LEFT ENGINE FAILED TO LIGHT OFF ON 2 START ATTEMPTS. LOOSE WIRE CONNECTION ON LEFT FIRE HANDLE FUEL VALVE MICROSWITCH ADJUSTED. OPS CHECKS GOOD. (M)SDR MALA975450Light Switch · failedDURING C-CHECK, JOB CARD 3350/03, NOTED FLIGHT ATTENDANT'S EMERGENCY LIGHTING SWITCH DID NOT INDICATE NORMAL IN STEP 3 OF JOB CARD. RELAMPED LIGHT SWITCH. OPS CHECK GOOD. (X)SDR MALA975449Battery Pack · dischargedDURING INSPECTION, FOUND BOTH FRONT EXIT SIGNS INOPERABLE. REPLACED BATTERY PACKS. FUNCTIONAL CHECK GOOD. (X)SDR MALA975448Bulb · failedDURING INSPECTION, FOUND EMERGENCY FLOOR BULB INOP. REMOVED AND REPLACED BULB. FUNCTIONAL CHECK GOOD. (M)SDR CA970612009Bearing Race · chipped(CAN) UPON REMOVAL OF PROPELLER BLADES FROM HUB INNER RACE AT #3 BLADE POSITION, DAMAGE FOUND ON BEARING SURFACE. WHEN RACE REMOVED DAMAGE FOUND ON HUB SURFACE OF RACE, AS WELL AS THE HUB. HUB REMOVED FOR OVERHAUL. INVESTIGATION UNDERWAY TO DETERMINE IF PITTINSDR PCAA9700432Retract Mech · malfunctionedFLT 3596, EN ROUTE ALB-BUF, LEFT GEAR DOOR ADVISORY LIGHT ILLUMINATED. GEAR DOOR VERIFIED OPEN. REMOVED AND REPLACED BUSHINGS, BOLTS AND SPACERS ON LEFT MAIN GEAR AFT DOOR BELLCRANK. ADJUSTED DOOR PROXIMITY SWITCH. OPERATIONAL CEHCK OD DOOR SYSTEM NORMAL. SDR MALA975443Bulb · failedDURING INSPECTION, ONE BULB ON FORWARD EMERGENCY EXIT IDENTIFIER WAS FOUND INOP. MAINTENANCE RELAMPED. FUNCTION CHECK GOOD. (M)SDR MALA975442Light Assembly · inoperativeDURING INSPECTION, THREE FLOOR EMERGENCY LIGHTS WERE FOUND INOP. MAINTENANCE RELAMPED. FUNCTION CHECK GOOD. (M)SDR CA970609017Line · leaking(CAN) NOSE GEAR LINE FOUND LEAKING DURING WALKAROUND. LINE REPLACED.SDR QXEA9700215Smoke Detector · no testNR 1 BAGGAGE SMOKE DETECTOR WILL NOT TEST. REPLACED TEST LAMPS, OPERATIONAL CHECKS GOOD.SDR MALA975445Lens · crackedDURING INSPECTION, ONE EMERGENCY EXITSIGN WAS FOUND CRACKED. MAINTENANCE REPLACED LENS. FUNCTIONAL CHECK GOOD. (M)SDR MALA975444Light Assembly · inoperativeDURING INSPECTION, ONE FLOOR TRACK LIGHT WAS FOUND INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR QXEA9700213Smoke Detector · dirtySMOKE DETECTOR IN LAVATORY IS INOP. CLEANED SMOKE DETECTOR, OPERATIONAL CHECKS GOOD.SDR QXEA9700205Hmu · malfunctionAT LEVEL OFF AT FLIGHT LEVEL 19,000, NOTICED A GRADUAL POWER LOSS ON NR 1 ENGINE (19 PERCENT IN 2 MINUTES). RETURNED TO THE FIELD AND ACCOMPLISHED AN UNEVENTFUL LANDING. REPLACED NR 1 HYDROMECHANICAL UNIT, OPERATIONAL CHECKS GOOD.SDR MALA975438Bulb · failedFLT 3381 - DURING APPROACH, THE NOSE WHEEL ALTERNATE EXTENSION LIGHT WAS FOUND INOP. MAINTENANCE REPLACED BULB. ALL CHECKS GOOD. (M)SDR MALA975437Bulb · failedDURING INSPECTION, FOUND ONE EMERGENCY EXIT LIGHT INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)
Back to Boeing DHC-8-102