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 PCAA9700586Wire · failedONE SECTION OF EMERGENCY PATHWAY LIGHTS FOUND INOPERATIVE DURING ROUTINE MAINTENANCE. TROUBLESHOT SYSTEM, FOUND CIRCUIT OPEN UNDER AISLE FLOOR. REPAIRED CIRCUIT, SYSTEM OPERATIONALLY CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA9700687Connector · looseSEA - FAULT B LIGHT ON RIGHT ENGINE FIRE PANEL WILL NOT LIGHT UP WHEN TESTED. WILL LIGHT UP DURING ADVISORY LIGHT TEST. RESEATED CAUTION ADVISORY TEST BOX. FAULT B LIGHT NOW LIGHTS UP. NO PARTS REPLACED. OPERATIONAL CHECK GOOD.SDR QXEA9700686Smoke Detector · malfunctionedLAVATORY SMOKE DETECTOR WILL NOT TEST. NEW DETECTOR, NO HELP. REINSTALLED ORIGINAL. PLACED ON MEL. MEL CLEARED BY PERFORMING OPERATIONAL CHECK WITH NO DEFECTS NOTED. NO PARTS REPLACED.SDR QXEA9700685Control Box · malfunctionSEA - CHECK FIRE DECTECTION WARNING LIGHT ON, UNABLE TO RESET. REPLACED MASTER WARNING CONTROL BOX. OPERATION CHECK GOOD.SDR PCAA9700587Bulb · failedAFT CENTER CABIN OVERHEAD EMERGENCY LIGHT FOUND INOPERATIVE DURING ROUTINE MAINTENANCE. REMOVED AND REPLACED LIGHT BULB, OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700585Light · malfunctionedCOCKPIT OVERHEAD EMERGENCY LIGHT ILLUMINATES IN FLIGHT. CABIN EMERGENCY LIGHTS REMAIN OFF. CLEANED AND ADJUSTED CONTACTS AT COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT BRACKET. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR CA971113002Skin · cracked(CAN) A 7 INCH CRACK WAS FOUND IN THE SKIN AT THE TOP OF THE FORE RUDDER. AIRCRAFT TT: 11,513 HOURS.SDR CA971031007Line · ruptured(CAN) NR2 HYDRAULIC SYSTEM DEPLETED DURING TAXIING. RIGHT HAND MAIN LANDING GEAR ACTUATOR DOWN LINE HAD A HOLE IN THE FLEX PART OF THE HOSE.SDR QXEA9700680Battery · dischargedSEA - FORWARD TWO FLOOR EMERGENCY LIGHTS ON FLOOR STRIP INOP. REPLACED EMERGENCY POWER SUPPLY AND BATTERY ABOVE SEAT 1E. POWER SUPPLY SERIAL NUMBER 173, MANUFACTURER NUMBER 60-3844-1 TSN 25692 CSN 35543 TSR 9963, OPERATIONAL CHECK GOOD.SDR PCAA9700584Bulb · failedEMERGENCY FLOOR PATH LIGHT IN FORWARD CABIN INOPERATIVE. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700583Connector · looseEMERGENCY FOOT PATH LIGHTING ON THE RIGHT SIDE OF CABIN HAVE ONLY HALF OF THE LIGHTS LIT. FOUND CONNECTORS FOR FIRST TWO LIGHTS TO BE LOOSE. RECONNECTED LIGHTS AND SYSTEM OPERATIONALLY TESTED NORMALLY. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700582Wire · brokenBROKEN AND EXPOSED WIRING ON FLOOR LEVEL EMERGENCY LIGHT AT ROW 9. REPLACED BROKEN WIRE ON FLOOR LEVEL EMERGENCY LIGHT AT ROW 9 ALL LIGHTS OPERATIONALLY TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA9700672Engine · failedAFTER LEVELING AT FL230, THE FLT CREW HEARD A LOUD THUNK AND FELT A SINGLE JOLT. STRONG ODOR WAS IN THE CABIN. THE NR 2 ENGINE WAS SHUTDOWN, AN EMERGENCY WAS DECLARED AND THE FLT RETURNED TO GEG WITHOUT FURTHER INCIDENT. NR 2 PROP FEATHERED WHEN THE ALTERNASDR QXEA9700671Caution Light · illuminatedSEA - ON TAKEOFF MASTER CAUTION ROLL SPOILER INBOARD AND OUTBOARD HYDRAULIC LIGHTS CONTINUOUSLY ILLUMINATED. ABORTED TAKEOFF. CLEANED AND INSPECTED BOTH LEFT AND RIGHT LIFT DUMPERS SOLENOID VALVE C-PLUGS AND WIRING. RERACKED ADVISORY LIGHT CONTROL BOX. NO PSDR PCAA9700580Bulb · failedRIGHT AFT EXTERIOR EMERGENCY EGRESS LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700578Bulb · failedONE LIGHT INOPERATIVE IN FLOOR EMERGENCY PROXIMITY LIGHTING SYSTEM. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700576Selector Valve · failedFLT 3532 - ON APPROACH TO ALB LANDING GEAR WOULD NOT EXTEND WHEN GEAR WAS SELECTED DOWN. CREW PERFORMED SUCCESSFUL ALTERNATE EXTENSION PROCEDURE AND FLIGHT LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED LANDING GEAR SELECTOR VALVE. RETRACTION ANDSDR CA971113031Spring · broken(CAN) ON APPROACH, GEAR SELECTED DOWN, RIGHT MAIN GEAR DID NOT INDICATE DOWN AND LOCKED. ALTERNATE GEAR EXTENSION CARRIED OUT AND RIGHT STILL INDICATED AN UNSAFE CONDITION ON BOTH NORMAL AND ALTERNATE EXTENSIONS. PILOTS DECIDED TO DO A "TOUCH AND GO" TO SEE SDR AU971395Aircraft · lightning strike(AUS) AIRCRAFT SUFFERED A LIGHTNING STRIKE. DAMAGE TO BOTH PROPELLERS,RH AND LH INBOARD WINGS AND INBOARD FLAPS.SDR AU971350Propeller · lightning strike(AUS) AIRCRAFT SUFFERED A LIGHTNING STRIKE CAUSING DAMAGE TO NO1 AND NO2 PROPELLERS, RH AND LH INBOARD WINGS AND INBOARD FLAPS.SDR CA971113001Actuator · failed(CAN) ON GEAR EXTENSION, A NOSE GEAR UNSAFE CONDITION WAS INDICATED. MANUAL SYSTEM ALSO INDICATED UNSAFE. GEAR WAS RECYCLED WITH SAME RESULTS. GEAR WAS THEN MANUALLY EXTENDED WITH THE SAME UNSAFE INDICATION. FLYBY CARRIED OUT TWICE WITH VISUAL CONFIRMATIONSDR QXEA9700674Strut · malfunctionBOI - MAIN CABIN DOOR OCCASIONALLY BINDS AND DIFFICULT TO OPEN. REPLACED FORWARD LOWER STRUT, PERFORMED ADJUSTEMENT TEST AND OPERATIONAL CHECK GOOD.SDR QXEA9700673Seat Mechanism · lack of lubePDX - FIRST OFFICERS SEAT SLIPPED BACK IN ITS TRACK DURING FLIGHT. CLEANED AND LUBED FIRST OFFICERS SEAT TRACK MECHANISM. NO PARTS REPLACED, OPERATIONAL CHECK GOOD.SDR PCAA9700581Light · failedCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975713Bulb · failedDURING INSPECTION, ONE RED FLOOR TRACK LIGHT FOUND INOPERABLE. MAINTENANCE RE-LAMPED RED FLOOR TRACK LIGHT. AL CHECKS GOOD. (X)SDR MALA975708Bulb · failedDURING INSPECTION, BULBS BURNED OUT ON EMERGENCY EXIT SIGNS. MAINTENANCE REPLACED BULBS. ALL CHECKS GOOD. (X)SDR MALA975707Bulb · failedDURING INSPECTION, ONE RED FLOOR TRACK EMERGENCY LIGHT WAS FOUND INOPERABLE. MAINTENANCE RE-LAMPED RED FLOOR TRACK LIGHT. ALL CHECKS GOOD. (X)SDR PCAA9700575Bulb · failedAFT CENTER AISLE OVERHEAD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700574Light · inoperativeCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9700572Light · inoperativeCOCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT OVERHEAD PORTABLE EMERGENCY LIGHT ASSEMBLY WITH SERVICEABLE UNIT. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975704Lens · missingDURING INSPECTION ROW 4A MISSING EXIT SIGN. MAINTENANCE REPLACED WITH SERVICEABLE LENS COVER. ALL CHECKS GOOD. (M)SDR MALA975700Light · inoperativeDURING INSPECTION THIRD FLOOR TRACK LIGHT INOP. MAINTENANCE RELAMPED FLOOR TRACK LIGHT. ALL CHECKS GOOD. (M)SDR MALA975696Light · missingDURING INSPECTION, EXIT SIGN COVER AT ROW 4 MISSING. MAINTENANCE REPLACED LIGHT ASSEMBLY AT ROW 4. OPS CHECK GOOD. (M)SDR QXEA9700654Autofeather Sys · failed testLWS- NR 2 AUTO FEATHER SYSTEM FAILED FIRST FLIGHT OF THE DAY TEST. PERFORMED AUXILLARY PRESSURE PUMP AND MOTOR ELECTRICAL CHECK, CHECKS GOOD. PERFORMED AUTOFEATHER TEST, TEST GOOD. AIRCRAFT RETURNED TO SERVICE. NO COMPONENTS REPLACED.SDR PCAA9700573Fitting · crackedNOSE LANDING GEAR RETRACTION ACTUATOR FITTING CRACKED THROUGH INBOARD ATTACH BOLT BORE. REMOVED AND REPLACED NOSE LANDING GEAR RETRACTION ACTUATOR FITTING WITH SERVICEABLE UNIT. OPERATIONAL AND RETRACTION TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700571Bulb · failedOVERHEAD EMERGENCY LIGHT AT CENTER CABIN INOP. REMOVED AND REPLACED LAMP. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700570Windshield · crackedUPON CLIMB-OUT FROM SWF, CAPTAINS WINDSHIELD CRACKED. AIRCRAFT RETURNED TO FIELD. REMOVED AND REPLACED CAPTAINS WINDSHIELD IAW DASH 8 MM CHAPTER 56-10-11. AIRCRAFT RETURNED TO SERVICE. (M)SDR MALA975699Light Receptacle · failedDURING PREFLIGHT, NOTICED ELECTRICAL SMELL EMANATING FROM ROW 3-4 AREA. TROUBLESHOT PER MX CONTROL, FOUND THIRD OVERHEAD LIGHT ON RIGHT SIDE TO BE ARCING AT FORWARD CONNECTION. PULLED AND COLLARED RIGHT MAIN BUS. MAINTENANCE REPLACED FORWARD NR 3 LIGHT RECESDR MALA975695Lights · inoperativeDURING INSPECTION, ALL EMERGENCY LIGHTS INOP. MAINTENANCE CYCLED AIRCRAFT POWER. ALL CHECKS GOOD. (M)SDR QXEA9700657Oil Cooler · malfunctionPDX- NR 2 ENGINE OPERATED AT MAX OIL TEMPERATURE OF 125 DEGREES CELSIUS IN EXCESS OF 20 MINUTES. COMPLIED WITH UNSCHEDULED MAINTENANCE INSPECTION IAW PRATT AND WHITNEY MTX MANUAL 05-50-00. REPLACED OIL COOLER AND FILTERS. CHECKED CHIP DETECTORS, NO DEFECTS SDR MALA975693Light · inoperativeDURING INSPECTION, ONE FORWARD RED EMERGENCY LIGHT INOP. MAINTENANCE REPLACED LAMP MODULE. ALL CHECKS GOOD. (M)SDR QXEA9700658Battery · dischargedSEA- TWO EMERGENCY EXIT LIGHTS ARE INOP IN THE CABIN OVERHEAD AND LEFT AFT. REPLACED BATTERY POWER SUPPLY, OPERATIONAL CHECKS GOOD.SDR MALA975685Battery Pack · dischargedFLIGHT 3183 - DURING THE PREFLIGHT INSPECTION IN DTW, THE CREW NOTED THAT THE OVERHEAD EMERGENCY LIGHTS CAME ON MOMENTARILY AND THEN EXTINGUISHED UPON TESTING. MAINTENANCE REPLACED ALL BATTERY PACKS. ALL CHECKS WERE SATISFACTORY. (M)SDR MALA975691Light · inoperativeDURING INSPECTION, TWO FLOOR EMERGENCY LIGHTS INOP. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (M)SDR MALA975690Bulb · failedDURING INSPECTION THE DOOR EXIT SIGN HAS ONE BULB BURNT OUT. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (M)SDR MALA975686Fuel Pump · failedFLT 3453 - ON CLIMB-OUT FROM DTW, THE TORQUE ON THE NR 1 ENGINE DECAYED 10 PERCENT. THE CREW RESET THE POWER AND THE PROBLEM RECURRED. THE CREW RETURNED TO DTW. MAINTENANCE REPLACED THE FUEL PUMP, P/N 5009986B, ELECTRICAL HARNESS, P/N 3114792-003, AND HMU, SDR CA971024007Clock · shorted(CAN) CLOCK FAILED WITH SHORT. SHORT IN CLOCK CAUSED W.O.W. CAUTION LIGHT. ALSO ROLL SPOILERS DID NOT DEPLOY ON TOUCHDOWN. PROBLEM BEING INVESTIGATED BY DE HAVILLAND.SDR CA971015011Shaft · corroded(CAN) LEFT INBOARD AND RIGHT INBOARD AND OUTBOARD FLAP CARRIAGE SHAFTS FOUND WITH INTERNAL CORROSION. SHAFTS REPLACEDSDR 97ZZZM1102Wire Harness · failedFLT 3453 - ON CLIMB-OUT FROM DTW, THE TORQUE ON THE NR 1 ENGINE DECAYED 10 PERCENT. THE CREW RESET THE POWER AND THE PROBLEM RECURRED. THE CREW RETURNED TO DTW. MAINTENANCE REPLACED THE FUEL PUMP, P/N 5009986B, ELECTRICAL HARNESS, P/N 3114792-003, AND HMU, SDR QXEA9700642Sign · brokenBOI - MAIN CABIN DOOR LOWER EMERGENCY EXIT SIGN BROKEN. INSTALLED NEW EMERGENCY EXIT SIGN, OPERATIONAL CHECK GOOD.
Back to Boeing DHC-8-102