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 QXEA9700545Hyd Line · splitRDM - AIRCRAFT DIVERTED TO PDX, NR 2 HYDRAULIC SYSTEM QUANTITY DROPPED TO ZERO IN FLIGHT. NR 2 HYDRAULIC CAUTION LIGHT AND ASSOCIATED CAUTION LIGHTS ILLUMINATED. PERFORMED ALTERNATED GEAR EXTENSION METHOD NR 1. OPERATED AT ZERO QUANTITY FOR TEN MINUTES. RESDR QXEA9700543Autofeather Test · failedBOI - AUTO FEATHER TEST FAILED PRIOR TO DEPARTURE. NO ARM, OR UPTRIM, OR AUTO FEATHER LIGHTS. PERFORMED GROUND TEST OF AUTO FEATHER AND POWER UPTRIM. NO DEFECTS NOTED, NO PARTS REPLACED, OPERATION CHECK GOOD.SDR QXEA9700542Battery · dischargedPDX - LEFT HAND COCKPIT EMERGENCY FLASHLIGHT INOP. REPLACED BATTERY PACK, OPERATIONAL CHECK GOOD.SDR PCAA9700532Battery · dischargedSEVERAL CABIN EMERGNCY LIGHTS INOPERATIVE. TROUBLESHOT, REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AT 33-51 PS2 POSITION 200. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR 97ZZZM1079Socket · failedAFTER DEPARTURE FROM LGA, THE FLIGHT ATTENDANT REPORTED A SMELL OF SMOKE IN THE CABIN. THE A/C RETURNED TO FIELD AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND SOURCE OF SMOKE COMING FROM THE LIGHT SOCKETS AT ROW 1DF. MAINTENANCE ISOLATED SOCKSDR MALA975622Bulb · failedDURING INSPECTION, EMERGENCY OVERHEAD LIGHT 4E INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR MALA975620Engine Oil · req'd serviceFLT 3432 - DURING CLIMB-OUT, NR 2 ENGINE OIL PRESSURE FLUCTUATING. RETURNED TO DTW. MAINTENANCE SERVICED RIGHT ENGINE WITH THREE QUARTS OF OIL, NO LEAKS, ALL PARAMETERS NORMAL. ALL CHECKS GOOD. (X)SDR QXEA9700523Bulb · failedSEA- AFT OVRHEAD EMERGENCY EXIT LIGHT IS INOP. RELAMPED LIGHT, OPERATIONAL CHECK GOOD.SDR QXEA9700522Light · brokenSEA- EMERGENCY EXIT LIGHT BY SEAT 1E IS BROKEN. REPLACED EMERGENCY EXIT LIGHT ON SIDE WALL, OPERATIONAL CHECKS GOOD.SDR MALA975623Lamp · failedDURING INSPECTION, ROW 4 RED FLOOR TRACK LIGHT INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR QXEA9700524Battery · dischargedSEA- AFT OVERHEAD AND LEFT AFT OUTBOARD EMERGENCY EXIT LIGHTS ARE OUT. REPLACED BATTERY POWER SUPPLY, OPERATIONAL CHECKS GOOD.SDR QXEA9700610Ball Screw Act · damagedPDX - NR 3 AND NR 4 BALL SCREW ACTUATORS HAVE SLIGHT BRINELLING DAMAGE. REPAIRED IAW EA 9-27-69.SDR QXEA9700609Ball Screw · damagedPDX - BALL SCREWS WITH SLIGHT BRINELLING DAMAGE. REPAIRED IAW EA 9-27-69.SDR QXEA9700521Switch Light · malfunctionSEA- AUTO FEATHER WOULD NOT SELECT WHEN THE BUTTON WAS DEPRESSED. THIS OCCURRED DURING THE BEFORE TAKEOFF CHECKLIST. REPLACED AUTO FEATHER SWITCH LIGHT ASSY, OPERATIONAL CHECKS GOOD.SDR MALA975619Bulb · failedDURING INSPECTION, EMERGENCY EXIT SIGN INOP. MAINTENANCE RELAMPED. OPS CHECK GOOD. (M)SDR QXEA9700607Angle · crackedPDX - CRACK FLANGE OF THE NACELLE DRAG ANGLE, (P/N 85710323). REPAIRED IAW EA 9-57-291.SDR PCAA9700530Smoke Detectors · failedSMOKE LIGHT CAME ON IN FLIGHT, AIRCRAFT RETURNED TO FIELD PHL. MAINTENANCE TROUBLESHOT SYSTEM, REMOVED AND REPLACED BOTH DETECTORS. SYSTEM OPERATIONALLY CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR CA970904009Relays · failed(CAN) ON DEPARTURE AND GEAR SELECTED UP. GEAR RETRACTED NORMALLY THEN GEAR DOOR LIGHTS FLICKERED AND STAYED ON. GEAR RECYCLED WITH SAME RESULTS. GEAR LOWERED MANUALLY AND AIRCRAFT RETURNED TO AIRPORT. RELAYS 3261-K9 AND 3261-K11 REPLACED. SECOND RELAY P/N DSC SDR QXEA9700517T1 Probe · malfunctionYKM- ENGINE POWER ON NR 2 ENGINE DROPPED 20 TO 30 PERCENT ON APPROACH. REDUCED POWER TO FLIGHT IDLE. WHEN POWER LEVER ADVANCED TORQUE STAYED IN THE 0 TO 10 PERCENT RANGE. AS A PRECAUTION SHUT DOWN NR 2 ENGINE. ACCOMPLISHED AN UNEVENTFUL LANDING. REPLACED SDR QXEA9700516Switch · malfunctionSEA- AUTO FEATHER FAILED TO ARM ON TAKEOFF. ABORTED TAKEOFF AND RETURNED TO GATE. SWAPPED TORQUE SIGNAL CONDITIONERS, CONFIRMED LAYSHAFT SWITCHES. CHECKED RELAYS 6121-K3, K4 AND K5, NO DEFECTS FOUND. REPLACED NR 1 AUTO FEATHER TEST SWITCH, OPERATIONAL CHECSDR PCAA9700525Engine · lost powerLOST POWER ON NR 2 ENGINE AFTER TAKEOFF FROM PHL, THE ENGINE WAS SHUTDOWN AND THE A/C RETURNED TO FIELD. LANDED WITHOUT INCIDENT. MX INSPECTED NR 2 ENGINE AND RELATED SYSTEMS, SERVICED 4 QTS OF OIL. FOUND SMALL AMOUNT OF DEBRIS ON RGB CHIP DETECTOR. PERFORSDR QXEA9700608Web · chafedPDX - RIGHT HAND NACELLE FINGERNAIL UPPER DECK CHAFE HOLE IN WEB. DAMAGE IS JUST OUTBOARD OF YN=0.00 AND JUST AFT OX XN=245. REPAIRED IAW 9-54-139.SDR QXEA9700606Hinge Bolt · misinstalledPDX - RIGHT MAIN LANDING GEAR FORWARD DOOR AFT HINGE AFT FRAME (85410422) AND JOINT STRAP (85410426) THAT WAS DAMAGED BY THE HINGE BOLT BEING INSTALLED BACKWARDS CHAFING THE FRAME AND JOINT STRAP. REAIRED IAW EA 9-54-138.SDR QXEA9700514Battery · dischargedFLIGHT ATTENDANTS FLASHLIGHT UNDER SEAT SLOW TO FLASH. REPLACED BATTERIES, OPERATIONAL CHECK GOOD.SDR PCAA9700528Bleed Line · brokenSPZ PANEL INDICATES 63 DEGREES OUTSIDE AIR TEMP. ACRID SMELL IN COCKPIT AND CABIN OF OVERHEATED PLASTIC. FOUND RIGHT BLEED LINE BROKEN JUST OUTBOARD OF HIGH TEMP SWITCH. REMOVED PIPE ASSEMBLY. INSTALLED NEW BLEED LINE ASSEMBLY. AIRCRAFT RETURNED TO SERVICSDR MALA975615Bulb · failedDURING INSPECTION, BULB INOPERABLE ON EXIT SIGN ON WALL BY SEAT 4 D AND E. MAINTENANCE RECONNECTED LIGHT CONNECTOR. OPS CHECK GOOD. (X)SDR QXEA9700513Power Supply · inoperativeAFT OVERHEAD AND AFT LEFT HAND EXIT EMERGENCY LIGHTS INOP. REPLACED BATTERY POWER SUPPLY BOX P-3. ORIGINAL BATTERY IN AIRCRAFT EMERGENCY LIGHTS CHECKED GOOD, OPERATIONAL CHECK GOOD.SDR MALA975610Bulb · failedDURING INSPECTION, EXIT SIGN 4D AND E HAS A BURNED OUT BULB. MAINTENANCE REPLACED BULB. OPS CHECK GOOD. (X)SDR QXEA9700510Battery Pack · dischargedSEA - CENTER CEILING EMERGENCY LIGHT INOP AND AFT OUTSIDE RIGHT HAND EMERGENCY LIGHT INOP. REPLACED EMERGENCY LIGHT BATTERY PACK AND POWER SUPPLY. OPERATIONAL CHECK GOOD.SDR PCAA9700529Wire · brokenTWO LIGHTS INOPERATIVE IN EMERGENCY FLOOR PATH LIGHTING. REPAIRED OPEN CIRCUIT IN EMERGENCY FLOOR PATH LIGHTING WIRING. OPERATIONAL CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700524Seat Track · corrodedDURING A ROUTINE C-CHECK, THE LEFT INBOARD CABIN SEAT RAIL WAS FOUND CORRODED IN THE WARDROBE AREA. CORRODED SEAT RAIL SECTION WAS REPLACED WITH A SPLICED SECTION IAW DHC REPAIR DRAWING 8-53-1932, AND DHC DRAWINGS. A/C RETURNED TO SERVICE. (M)SDR MALA975616Connector · dirtyFLT 2942 - AFTER TAKEOFF, LEFT OIL TEMP GAUGE READS RED LINE AND THEN GOES TO NORMAL. ALL OTHER ENGINE GAUGES WERE NORMAL. MAINTENANCE CLEANED CANNON PLUG 9811-9. OPS CHECK GOOD. (X)SDR MALA975614Ground Lock · out of positionDTW - FLT 3318 - AFTER TAKEOFF, THE NOSE GEAR WOULD NOT RETRACT. AIRCRAFT RETURNED TO DTW. MAINTENANCE FOUND NOSE GEAR GROUND LOCK EXTENDED, RESET GROUND LOCK. ALL CHECKS GOOD. (X)SDR CA970904002Line · chafed(CAN) RIGHT HAND MAIN LANDING GEAR SIDE STAY DOWN PRESSURE LINE FOUND CHAFED THROUGH.SDR MALA975608Lamp · inoperativeDURING INSPECTION, ONE FLOOR TRACK BULB FOUND INOPERATIVE. MAINTENANCE RELAMPED. ALL CHECKS GOOD. (X)SDR MALA975607Bulb · failedDURING INSPECTION, EXIT SIGN HAS BULB THAT IS INOPERATIVE. MAINTENACE REPLACED BULB. OPS CHECK GOOD. (X)SDR MALA975606Lamp · inoperativeDURING INSPECTION, ONE FLOOR TRACK LIGHT FOUND INOPERATIVE. MAINTENANCE REPLACED LAMP. OPS CHECK GOOD. (X)SDR MALA975605Power Supply · inoperativeDURING INSPECTION, TWO EMERGENCY LIGHTS FOUND INOPERATIVE. MAINTENANCE REPLACED POWER SUPPLY. OPS CHECK GOOD. (X)SDR MALA975609Connector · dirtyDTW - FLT 3189 - AFTER TAKEOFF, NR 1 ENGINE OIL INDICATED HIGH OIL TEMPERATURE. AIRCRAFT RETURNED TO DTW. MAINTENANCE CLEANED MOISTURE FROM CANNON PLUG 7700P1. RAN AIRCRAFT AT SEVERAL POWER SETTINGS. ALL CHECKS GOOD. (X)SDR PCAA9700520Bulb · failedSECOND EMERGENCY LIGHT IN FLOOR PATH INOP. REMOVED AND REPLACED BULB OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700522Light · missingROW 4AC EMERGENCY EXIT COVER MISSING INSTALLED EXIT COVER OPS CHECK OK. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA9700503Wire · failedABORTED TAKEOFF, AUTO FEATHER WOULD NOT ARM TO TAKEOFF ROLL. REPAIRED WIRING AT THE POWER LEVER SWITCH.SDR QXEA9700497Lamp · failedTWO FORWARD EMERGENCY PATH LIGHTS INOP. RELAMPED AND RESTORED WIRING, OPERATIONAL CHECK GOOD.SDR PCAA9700519Light · inoperativeCOCKPIT EMERGENCY LIGHT INOP. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT. OPERATION CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700518Connector · looseHALF OF THE EMERGENCY FLOOR LIGHTS INOP ON LEFT SIDE. RECONNECTED AFT FLOOR STRIP CONNECTOR. OPERATION CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700516Actuator · failedUPON APPROACH INTO BWI, THE NOSE GEAR DID NOT EXTEND UNDER NORMAL PROCEDURES. CREW PERFORMED AN ALTERNATE EXTENSION AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND THE NOSE STEERING ACTUATOR AT FAULT. THE ACTUATOR WAS REMOVED AND REPLACED IAW DSDR QXEA9700498Wire · failedFLOOR EMERGENCY LIGHTS FROM FORWARD FIRST AND THIRD INOP. REPAIRED CRUSHED WIRES ON FLOOR EMERGENCY LIGHT, OPERATIONAL CHECK GOOD.SDR PCAA9700521Light · crackedLEFT MID CABIN, LOWER EMERGENCY EXIT LIGHT ASSEMBLY CRACKED. REMOVED AND REPLACED EMERGENCY LIGHT ASSY. OPS CHECKED GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR QXEA9700495Wire Harness · failedNUMBER 2 ALTERNATE FEATHER PUMP FAILS TO TEST ON THE 24 HOUR AUTO FEATHER CHECK. REPLACED THE HARNESS FROM THE TORQUE SIGNAL CONDITIONER TO THE FIRE WALL HARNESS, OPERATIONAL CHECK GOOD.SDR PCAA9700523Seat Track · corrodedLEFT INBOARD SEAT RAIL FOUND CORRODED UNDER WARDROBE FLOOR DURING C-CHECK FROM STATION X190 TO X210. SPLICED IN NEW SECTION OF SEAT RAIL IAW DHC RD 8-53-1932. AIRCRAFT RETURNED TO SERVICE. (M)
Back to Boeing DHC-8-102