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 CA971219042Tube · hole(CAN) PIN HOLE IN NR 2 HYDAULIC SYSTEM SPOILER LINE. IPC 29-00-00-20-50. PART TC: 33,653.SDR AU971492Skin · damag(AUS) REAR FUSELAGE DAMAGED JUST FORWARD OF THE CARGO DOOR DUE TO IMPACT BY BAGGAGE HANDLERS TRACTOR. NO TEARING OR CRACKING OF THE SKIN WAS EVIDENT ALTHOUGH THE LIMITS OF THE DAMAGE ARE BEYOND THE SIZE ALLOWABLE TO CONTINUE WITHOUT REPAIR. DAMAGE WAS LOCATED SDR QXEA9700781Conector · dirtyPDX- LEFT HAND OVERHEAD EMERGENCY LIGHTS ARE INOP. CLEANED TERMINALS ON THE PS1 POWER SUPPLY, OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE, NO PARTS REPLACED.SDR PCAA9700631Bulb · failedTHIRD EMERGENCY FLOOR LIGHT FROM FRONT INOPERATIVE. REPLACED BULB OPERATION CHECK GOOD. A/C RETURNED TO SERVICE. (M)SDR PCAA9700630Bulb · failedFORWARD LEFT FUSELAGE EXIT EMERGENCY LIGHT INOPERATIVE. REPLACED BULB. OPERATION CHECK GOOD. A/C RETURNED TO SERVICE. (M)SDR HNAA9792695Selector Handle · failedFLT 3219 - EWN-CLT - AFTER SELECTING GEAR DOWN, GOT 3 RED LIGHTS, GEAR DID NOT EXTEND. CYCLED GEAR, THE GEAR EXTENDED NORMALLY. THE AIRCRAFT LANDED WITHOUT INCIDENT. REMOVED AND REPLACED THE LANDING GEAR SELECTOR HANDLE ASSY. (M)SDR HNAA9792694Selector Valve · failedFLT 3450 - PHF-CLT - WHEN SELECTING GEAR DOWN ONLY GOT 3 RED LIGHTS AND NO GEAR EXTENSION. CYCLED HANDLE AND OPS WERE NORMAL. THE AIRCRAFT LANDED WITHOUT INCIDENT. REMOVED AND REPLACED LANDING GEAR SELECTOR VALVE. (M)SDR HNAA9790697Clutch Plate · failedFLT 3315 - PIT-CHO - ON LANDING, IN TURBULENCE, AILERON CHANNEL DISCONNECTED AND RECONNECTED WITH NORMAL YOKE MOVEMENT. NO ASSOCIATED CAUTION LIGHTS ILLUMINATED. THE AIRCRAFT LANDED WITHOUT FURTHER INCIDENT. REPLACED THE LEVER AND CLUTCH PLATE, SPROCKET ANDSDR CA971216012Windshield · cracked(CAN) FIRST OFFICER'S WINDSHIELD ARCING. SUBSEQUENTLY DEVELOPED A CRACK. AIRCRAFT TT: 21,967 HOURS.SDR CA971208014Piston Housing · cracked(CAN) DURING INSPECTION OF THE BRAKE ASSEMBLY, CRACKS APPROXIMATELY .25 INCH LONG WERE FOUND IN TWO OF THE CYLINDERS OF THE PISTON HOUSING. PART TC: 23,433.SDR 98ZZZM180Spring Pin · failedFLT 3315 - PIT-CHO - ON LANDING, IN TURBULENCE, AILERON CHANNEL DISCONNECTED AND RECONNECTED WITH NORMAL YOKE MOVEMENT. NO ASSOCIATED CAUTION LIGHTS ILLUMINATED. THE AIRCRAFT LANDED WITHOUT FURTHER INCIDENT. REPLACED THE LEVER AND CLUTCH PLATE, SPROCKET ANDSDR 98ZZZM179Sprocket · failedFLT 3315 - PIT-CHO - ON LANDING, IN TURBULENCE, AILERON CHANNEL DISCONNECTED AND RECONNECTED WITH NORMAL YOKE MOVEMENT. NO ASSOCIATED CAUTION LIGHTS ILLUMINATED. THE AIRCRAFT LANDED WITHOUT FURTHER INCIDENT. REPLACED THE LEVER AND CLUTCH PLATE, SPROCKET ANDSDR PCAA9700629Bulb · failedOVERHEAD EMERGENCY LIGHT INOPERATIVE. RELAMPED OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700628Light · inoperativeSECOND RED EMERGENCY FLOOR LIGHT INOP. REPLACED SECOND EMERGENCY FLOOR LIGHT MODULE. OPERATION CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR CA971210007Deice Boot · burnt(CAN) CREW REPORTED SPARKS FROM NR 2 PROPELLER, 2ND CYCLE LOAD INDICATOR NORMAL, GREEN LIGHT DID NOT ILLUMINATE. INSPECTION FOUND PROPELLER BLADE HEATER ELEMENT BURNT. BLADE ASSEMBLY REPLACED.SDR PCAA9700623Actuator · failedDURING CRUISE FLT, THE LEFT MAIN LANDING GEAR DOOR CAME OPEN. A/C LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT SYSTEM. FOUND THE LEFT FORWARD DOOR ACTUATOR AT FAULT. THE ACTUATOR WAS REMOVED AND REPLACED IAW DHC MM. OPERATIONAL AND LEAK CHECKED GOOD. SDR QXEA9700779Switches · dirtyBLI - ROLL SPOILER INBOARD/OUTBOARD CAUTION LIGHTS AND ADVISORY LIGHTS ILLUMINATED ON TAKEOFF ROLL. ABORTED TAKEOFF AND RETURNED TO GATE. CLEANED AND LUBRICATED SWITCHES ON QUADRANT. OPERATIONAL CHECK IS GOOD, NO COMPONENTS WERE REPLACED.SDR QXEA9700778Actuator · lack of lubePDX - AT CRUISE ALTITUDE WITH AN SAT OF -25'C, RECEIVED AN ADVISORY DISPLAY MESSAGE MISTRIM. PITCH TRIM WHEEL WAS DIFFICULT TO MOVE IN EITHER DIRECTION. AIRCRAFT LANDED WITHOUT INCIDENT. INSPECTED ELEVATOR TRIM TAB ACTUATOR, SERVO, AND CABLE RUN WITH NO DEFSDR QXEA9800125Z Member · crackedPDX - Z-MEMBER ON LHEFT HAND SIDE OF NLG SIDEWALL AT K97.0 AND APPROX Z109 HAS A CRACK RUNNING BETWEEN 2 RIVETS THROUGH THE RADIUS OF THE BEND. REPAIRED IAW 9-53-352.SDR QXEA9800124Skin · gougedPDX - GOUGE LOCATED ON LOWER RIGHT FUSELAGE SKIN. REPAIRED IAW EA9-53-184.SDR QXEA9800123Seat Track · corrodedPDX - CORROSION AT LEFT OUTBOARD SEAT TRACK AT STA 302.400 (MARKED AT TOP SECTION) REPAIRED IAW EA 9-53-353.SDR QXEA9700773Bulb · failedPDX - NR 1 TEST POSITION OF THE BAGGAGE SMOKE DETECTOR INOP. REPLACED LAMP IN NR 1 SMOKE DETECTOR. OPERATIONAL CHECK GOOD.SDR PCAA9700621Battery · dischargedTWO FORWARD LIGHTS INOPERATIVE IN FLOOR EMERGENCY PROXIMITY LIGHTING SYSTEM. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AT POSITION NR 400. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR CA971216007Line · leaking(CAN) A FAIR QUANTITY OF HYDRAULIC FLUID FOUND DRIPPING FROM THE TAIL SECTION. LINE BETWEEN YAW DAMPER AND UPPER RUDDER ACTUATOR LEAKING.SDR CA971216006Start Generator · failed(CAN) ON TWO STARTS, THE NR 1 STARTER DID NOT AUTO CUT OUT. GENERATOR CONTROL UNIT (GCU) REPLACED. PROBLEM STILL OCCURRED. STARTER GENERATOR REPLACED.SDR QXEA9800126Bracket · corrodedPDX - LEFT MAIN LANDING GEAR ACTUATOR UPPER ATTACH BRACKET MOUNTING FACE ON AIRFRAME SIDE HAS LIGHT CORROSION AROUND UPPER ATTACH BOLD HOLE. REPAIRED IAW EA 9-54-146.SDR QXEA9800122Skin · damagedPDX - CARGO DOOR TOP AFT ADJUSTABLE STOP HAS BEEN STRIKING THE DOOR APATURE AND THE INNER SKIN HAS MATERIAL LOSS .400 DEEP FROM ORIGINAL. REPAIRED IAW EA 9-53-349.SDR QXEA9700772Power Supply · inoperativeSEA- FORWARD TWO FLOOR PROXIMITY LIGHTS INOP. REPLACED POWER SUPPLY AT 1DE, OPERATIONAL CHECK GOOD.SDR QXEA9700771Switch · dirtySEA- ABORTED TAKEOFF NO AUTO FEATHER ARM LIGHT. CLEANED POWER LEVER SWITCH QUADRANT, NO PARTS REPLACED AND OPERATIONAL CHECK GOOD.SDR QXEA9700768Actuator · required serviceSEA - AT 20,000 FEET AUTO PILOT ENGAGED IN ICING CONDITIONS, MISTRIM NOSE DOWN ADVISORY LIGHT ILLUMINATED. DISCONNECTED AUTO PILOT AND AIRCRAFT PITCHED UP, ELIVATOR TRIM STUCK, ELEVATOR SLUGGISH. SERVICED ELEVATOR TRIM ACTUATOR. NO PARTS REPLACED, OPERATIONSDR CA971219043Tube · leaking(CAN) ROLL SPOILER HYDRAULIC LINE FOUND LEAKING. PART TC: 29,237.SDR CA971216074Bearing Race · cracked(CAN) DURING DISASSEMBLY OF THE PROPELLER TO SHIP TO THE VENDOR FOR A MAJOR INSPECTION, THE NR 2 BORE BEARING RACE WAS FOUND CRACKED. PART TC: 22,383.SDR QXEA9700763Switches · dirtyBZN - ABORTED TAKEOFF ROLL, INBOARD/GROUND OUTBOARD SPOILER CAUTION LIGHTS ON. CLEANED PEDESTAL SWITCHES WITH CLEANER. NO PARTS REPLACED. GROUND RAN AT TAKEOFF POWER WITH NO FURTHER DEFECTS NOTED.SDR CA971210015Tube · leaking(CAN) PIN HOLE FOUND IN LEFT HAND SPOILER UNLOADING VALVE HYDRAULIC LINE. PART TC: 29,779.SDR QXEA9700760Oil System · required serviceYKM- SHORTLY AFTER TAKEOFF, NR 2 ENGINE OIL PRESSURE LIGHT ILLUMINATED. THE NR 2 OIL PRESSURE GAUGE WAS FLUCTUATING BELOW 40 PSI. AFTER LEVEL-OFF THE WARNING LIGHT WENT OUT AND OIL PRESSURE RETURNED TO NORMAL. RETURNED TO THE FIELD AND ACCOMPLISHED AN UNEVESDR QXEA9700759Battery · dischargedBOI- FLIGHT ATTENDANT FLASHLIGHT IS DIM. REPLACED FLASHLIGHT ASSEMBLY, OPERATIONAL CHECKS NORMAL.SDR PCAA9700619Battery · dischargedLEFT CABIN EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED EMERGENCY LIGHTING SYSTEM POWER SUPPLY AT POSITION NR 600. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9700615Window · crackedDURING CRUISE FLIGHT, THE CAPTAINS SIDE WINDOW CRACKED. A/C LANDED WITHOUT INCIDENT. REMOVED AND REPLACED CAPTAINS SIDE WINDOW IAW DASH 8 MM. A/C RETURNED TO SERVICE. (M)SDR PCAA9700620Bulb · failedCENTER CABIN OVERHEAD EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700618Bulb · failedRIGHT AFT EXTERIOR EMERGNCY EGRESS LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9700617Bulb · failedSEVERAL EMERGENCY FLOOR PROXIMITY LIGHTING SYSTEM BULBS INOPERATIVE. REPAIRED OPEN CIRCUIT IN EMERGENCY FLOOR PROXIMITY LIGHTING SYSTEM WIRING. OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR PCAA9700616Seat Track · wornDURING ROUTINE INSPECTION, THE CAPTAINS AND FIRST OFFICERS SEAT RAILS WERE FOUND WORN AT LOCKING PIN HOLES. INSTALLED STAINLESS STEEL WEAR STRIPS ON CAPTAINS AND FIRST OFFICERS SEAT TRACKS IAW SB 8-53-53. A/C RETURNED TO SERVICE. (M)SDR HNAA9793192Hyd Line · failedFLT 3270 - CLT-CRW - AFTER TAKEOFF, THE NR 1 HYDRAULIC SYSTEM BEGAN RAPIDLY LOOSING QUANTITY. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED AND LANDED AT CLT WITHOUT INCIDENT. INSTALLED TEMP FLEX LINE ON NR 1 ENGINE BETWEEN NR 1 AND NR 2 FLIGHT SPOILERSDR AU971451Hinge · damaged(AUS) LH AILERON OUTBOARD ATTACHMENT HINGE DAMAGED.SDR PCAA9700614Wire · looseEVERY OTHER BULB INOPERATIVE IN EMERGENCY FLOOR PROXIMITY LIGHTING SYSTEM. FOUND TWO JUMPER WIRES DISCONNECTED IN EMERGENCY FLOOR PROXIMITY LIGHTING CIRCUIT. SECURED JUMPER WIRES AND SYSTEM OPERATIONALLY TESTED NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700613Wire · brokenWIRE BROKEN AT BUTT SPLICE AFT OF THE FOURTH RED EMERGENCY FLOOR PATH LIGHT AT ROW ONE. REPAIRED WIRING TO CONFORM WITH WIRING DIAGRAM 33-51-00 OPERATIONAL TEST NORMAL. A/C RETURNED TO SERVICE. (M)SDR HNAA9793890Wire · failedFLT 3397 - YYZ-BWI - ON APPROACH INTO BWI, THE NOSE GEAR RED UNSAFE LIGHT REMAINED ON WITH GEAR HANDLE LIGHT ON. THE AIRCRAFT LANDED WITHOUT INCIDENT. FOUND NOSE LANDING GEAR DOWNLOCK PROX SENSOR WIRES CUT. REMOVED AND REPLACED SENSOR. (M)SDR CA971210006Line · cracked(CAN) HYDRAULIC LEAK FOUND COMING OUTBOARD SIDE OF RIGHT HAND NACELLE. ROLL SPOILER ACTUATOR LINE HAD A CRACK AT THE BEND IN THE LINE.SDR PCAA9700646Psu · failedUPON APPROACH INTO PHL, SMELL OF SMOKE WAS NOTICED COMING FROM OVERHEAD SEAT 1DF. MAINTENANCE INSPECTED AND FOUND PSU 1DF AT FAULT. THE PSU WAS ELECTRICALLY ISOLATED. SUBSEQUENTLY THE PSU WAS REMOVED AND REPLACED. AIRCRAFT RETURNED TO SERVICE. (M)SDR PCAA9700610Oil System · req'd serviceUPON TAKEOFF FROM ROC, THE NR 1 ENGINE OIL PRESSURE DROPPED 25 PSI. THE CREW SECURED THE ENGINE IAW PROCEDURES AND RETURNED TO FIELD. MAINTENANCE INSPECTED THE NR 1 ENGINE IAW PWC MM 05-50. NO DEBRIS OR DEFECTS NOTED. SERVICED THE ENGINE WITH 3 QUARTS OF O
Back to Boeing DHC-8-102