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 HNAA2012111201041Warning Light · false activationRIGHT WINDSHIELD HOT LIGHT ILLUMINATED. INSPECTED SENSOR WIRING ARRANGEMENT. FOUND TO BE ON PRIMARY SENSOR. CHECKED SENSORS RESISTANCE. FOUND TO BE WITHIN LIMITS IN REF TO PPO CMM 56-10-01. SENSOR REF 30-41-00. OPS CHECKED GOOD AT THIS TIME.SDR HNAA2012111201039Brush Block · dirtyON CLIMB OUT, EMERGENCY LIGHTS FLICKERED MOMENTARILY. OPS NORMAL AT THIS TIME. INSPECTED AND CLEANED BRUSH BLOCK AND CONNECTOR PLUGS. GROUND RAN ACFT. PROPELLER HEAT AND EMERGENCY LIGHTS OPS CHECKED GOOD AT THIS TIME. OK FOR SERVICE.SDR HNAA2012111201038Bulb · failedEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE. R & R EMERGENCY FLOOR PATH LIGHT BULB. OPS CHECKED GOOD.SDR HNAA2012111201037Lamp · failedF/A EMERGENCY LIGHT SWITCH IS NOT BACK ILLUMINATED. RELAMPED F/A EMERGENCY LIGHT SWITCH. OPS CHECKED GOODSDR HNAA2012111201036Bulb · failedEMERGENCY LIGHT IS INOPERATIVE. REMOVED PLASTIC COVERING. R & R BULB. REINSTALLED PLASTIC COVERING. OPS CHECKED GOOD.SDR HNAA2012100500998Apu · fumesFUEL FUMES ENTERING CABIN WITH APU BLEEDS ENGAGED, FOLLOWED BY APU SHUTDOWN.SDR CA121109001Wire · damaged(CAN) DURING CLIMB, FLIGHT CREW NOTICED THE FLAPS WERE STUCK AT 5. FUEL CALCULATION WAS MADE AND DECISION TAKEN TO CONTINUE WITH THE FLIGHT. ACFT LANDED WITHOUT FURTHER INCIDENT. AN ELECTRICAL WIRE AT THE FLAP SELECTOR WAS REPAIRED, THE SYS TESTED SERVICEABSDR CA121108005Bearing · seized(CAN) THE FLIGHT CREW REPORTED STIFF ROLL CONTROL. ON THE GROUND THEY DID A ROLL DISCONNECT AND FOUND THAT THE F/O CONTROL WHEEL WAS VERY STIFF TO OPERATE. MAINTENANCE INVESTIGATION FOUND THE LT WING AILERON QUADRANT CORRODED AND BEARINGS SEIZED. THE LT AILESDR HNAA2012110501027Spigot · corrodedAFT PAX DOOR HANDRAIL SPIGOT PITTED. REMOVED EXCESSIVE CORROSION, PREVENTATIVE COMPOUND AND REINSPECTED. FOUND SPIGOT TO HAVE MINOR SURFACE CORROSION. REMOVED SURFACE CORROSION. APPLIED THIN LAYER OF CORROSION PREVENTATIVE COMPOUND.SDR CA121108004Union · leaking(CAN) AFTER TAKEOFF, 1 ENGINE HYDRAULIC PUMP CAUTION LIGHT ILLUMINATED AFTER FLAP RETRACTION. THE HYDRAULIC FLUID QUANTITY INDICATION SHOWED 0.5 LITERS FOR THE NR 1 SYSTEM. THE ACFT HAD AN UNEVENTFUL FLAPLESS LANDING. MAINTENANCE PERSONNEL FOUND THE LEAK AT SDR HNAA2012110501034Warning Light · illuminatedRT AC BUSS C/L ILLUMINATED INFLIGHT. WITH ASSOCIATED C/L. CONFIRMED OK WITH RT TRU DISABLED.SDR HNAA2012110501030Lamp · burned outROW 2 FLOOR LEVEL EMERGENCY LIGHTS IS INOPERATIVE. R & R BULB, OPS CHECKED GOOD,SDR CA121105020Actuator · fractured(CAN) DURING TAXI THE CREW LOST NORMAL BRAKING DUE LOSS OF PRESSURE AND RETURNED TO THE GATE. HYDRAULIC FLUID WAS DISCOVERED LEAKING FROM THE LT NACELLE AREA. INVESTIGATION FOUND THE LT INBD ROLL SPOILER ACTUATOR HSG FRACTURED AND LEAKING. THE LH INBOARD ROLLSDR HNAA2012110501033Inverter · odiferousSTRONG FISHY ODOR IN COCKPIT. R & R AUX INVERTER REF 24-22-00, OPS CHECKED GOOD, NO ODOR FOUND. OK FOR SERVICE.SDR HNAA2012110501032Connector · damagedEMERGENCY LIGHTS COME ON WHEN SELECTED OFF WHEN CYCLING APU GEN OFF TO ON. ALSO COME ON WHEN SHUTTING ENG DOWN POSITIONED SPADE CONNECTOR ON WIRE 4D22 AT BACK SIDE OF F/A EMERGENCY LIGHT SWITCH. F/A PANEL REMOVED AND REINSTALLED IAW SMP, PERFORMED EMERGENCYSDR HNAA2012110501031Brush Block · inoperativeEMERGENCY LIGHTS FLICKER ON TAKEOFF ROLL. R & R RIGHT BRUSH BLOCK IAW 61-10-11 AND FUSE 2421 F10. IN RT AC CONTACTOR BOX. GROUND RAN ACFT, OPS CHECKED GOOD, OK 4 SERVICE.SDR HNAA2012110501029Lamp · burned outEMERGENCY LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT LAMP, OPS CHECKED GOOD.SDR HNAA2012110501028Bulb · burned outSECOND EMERGENCY CEILING LIGHT INOPERATIVE. R & R BURNED BULB & REINSTALLED COVER.SDR HNAA2012110201026Unknown · odorWHEN APU BLEED AIR IS ENGAGED A FUEL ODOR ENTERED THE CABIN.SDR HNAA2012103101025Battery · failed2 EMERGENCY FLOOR PATH LIGHTS ARE INOPERATIVE AT ROW 1. R & R BATTERY AT POSITION PS5. OPS CHECKED GOOD.SDR HNAA2012103101024Bulb · failedEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE AT ROW 2DF. R & R BULB AT ROW 2DF EMERGENCY FLOOR PATH LIGHTING.SDR HNAA2012102901023Bulb · failedINOPERATIVE EMERGENCY PATH LIGHTS AT ROW 6 AND 9. R & R BULBS FOR EMERGENCY PATH LIGHTING. SECURED LENS COVER. OPS CHECKED GOOD.SDR CA121029002Solenoid Valve · leaking(CAN) ON FINAL APPROACH, NR 2 ENGINE HYD PUMP CAUTION LIGHT ILLUMINATED AND FLIGHT CREW CONFIRMED HYD NR 2 SYS QTY INDICATOR DOWN TO ZERO. ACFT LANDED WITHOUT FURTHER INCIDENT. INITIAL INSPECTION REVEALED THAT THE HYD FLUID LEAK ORIGINATED FROM THE LT MLG DOSDR HNAA2012102601021Bulb · failedEMERGENCY FLOOR PATH LIGHT, THIRD FROM FRONT IS INOPERATIVE. R & R BULB FOR FLOOR EMERGENCY PATH LIGHT, 3RD FRONT FRONT. OPS CHECKED GOOD.SDR CA121026002Potentiometer · failed(CAN) ON DEPARTURE THE FLIGHT CREW FOUND THAT IT TOOK A SIGNIFICANT AMOUNT OF FORCE TO TURN THE CONTROL WHEEL TO THE LEFT. ONCE THE ACFT WAS TRIMMED TO FLY LEVEL THEY NOTED THAT THE AILERON TRIM WAS INDICATING FULL LWD. THE CREW DECLARED AN EMERGENCY FOR FLISDR HNAA2012102201019Bulb · failedWALL EMERGENCY LIGHT DIM AT ROW 1DF. REMOVED COVERS, REMOVED BURNED BULB. INSTALLED NEW BULB AND REINSTALLED COVER. OPS CHECKED GOOD.SDR HNAA2012101901017Bulb · failedRT FORWARD EMERGENCY LIGHT IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD IAW WC 33-50-03Q.SDR HNAA2012101901016Bulb · failedFORTH RED EMERGENCY LIGHT IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR CA121020001Windshield · smoke(CAN) AN ACFT EXPERIENCED LT WINDSHIELD HEATING FAILURE, CAUSING SMOKE IN COCKPIT. LT WINDSHIELD HAS BEEN REPLACED. BURNED WIRE FOUND ON L2 LUG.SDR HNAA2012101501014Bulb · failedAFT OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. REMOVED OVERHEAD PANEL, R & R BULB. REINSTALLED PANEL WITH ATTACHED HARDWARE. OPS CHECKED GOOD.SDR CA121015002Proximity Sensor · out of adjust(CAN) AFTER REPORTING RT GEAR DOOR AMBER LIGHT REMAINED ON AFTER GEAR UP SELECTION, THE FLIGHT CREW ELECTED TO RETURN. QRH COMPLETED AND GEAR CYCLED AT FLAP 0, LIGHT REMAINED ON, HOWEVER, THE F/A REPORTED ALL GEAR DOORS APPEARED TO BE FULLY CLOSED. MAINTENANSDR CA121015009Shaft · scored(CAN) WHILE BUILDING UP A RENTAL ENGINE FOR A SCHEDULED ENGINE CHANGE ON OUR ACFT AN INSPECTION OF THE PROPELLER SHAFT INNER BORE SHOWED SIGNS OF SCORING. THESE SCORE MARKS WERE FURTHER INSPECTED WITH A MAGNIFYING GLASS AND SHOWED SIGNS OF BEING A POSSIBLE CSDR HNAA2012101201012Bulb · failedEMERGENCY FLOOR LIGHT IN ROW 7D IS INOPERATIVE. R & R BULB IN ROW 7D. OPS CHECKED GOOD.SDR HNAA2012101001011Bulb · failedEMERGENCY FLOOR PATH LIGHT HAS TWO INOPERATIVE SEGMENTS IN ROW 1. R & R BULB. OPS CHECKED GOOD.SDR HNAA201210100110Door · out of rigLEFT DOOR AMBER LIGHT REMAINED ILLUMINATED WITH GEAR UP. RECYCLED GEAR STILL ILLUMINATED. FORWARD DOOR REMAINED OPEN. ACFT RETURNED TO FIELD. RERIGGED NR 1 FORWARD GEAR DOOR IAW MM32-10-21. OPS CHECKED GOOD.SDR HNAA2012100901009Battery · failedLEFT FORWARD EXTERIOR EMERGENCY LIGHT IS DIM. R & R BATTERY. OPS CHECKED GOOD.SDR HNAA2012100901008Battery · failedTWO FORWARD RED EMERGENCY FLOOR PATH LIGHTS ARE DIM AND EXIT SIGN ON RT FORWARD SIDEWALL ARE INOPERATIVE. R & R EMERGENCY LIGHT BATTERY AT PS1 IAW AMM33-52-00.SDR HNAA2012100901007Light · damagedEMERGENCY LIGHT AT ROW 1 IS DISCOLORED. SHOULD BE RED, LOOKS LIKE WHITE. R & R EMERGENCY LIGHT MODULE AT ROW 1. OPS CHECKED GOOD.SDR HNAA2012100901005Connector · damagedFORWARD CENTER CEILING EMERGENCY EXIT SIGN IS INOP. FOUND FORWARD CENTER CEILING LIGHT WIRE UNPLUGGED AND MATRIX CONNECTOR DAMAGED. R & R MATRIX CONNECTOR AND PLUGGED WIRES ACCORDINGLY. OPS CHECKED GOOD.SDR HNAA2012100901004Torque Sensor · failedDURING TAKEOFF, NR 2 TORQUE INDICATOR BOTH DIGITAL AND ANOLOG, DID NOT SHOW AN INCREASE. R & R NR 2 TORQUE INDICATOR IAW AMM 77-10-00. INSPECTED ASSOCIATED CONNECTOR PLUGS, NO DEFECTS NOTED. GROUND RAN ACFT. OPS CHECKED GOOD AT THIS TIME. OK FOR SERVICE.SDR HNAA2012100901003Pressure Switch · malfunctionedROLL SPOILER INBD HYD CAUTION LIGHT ILLUMINATED IN FLIGHT. PRESSURE AND QUANTITIES ARE NORMAL. R & R INBD LOW PRESSURE SWITCH. GROUND RAN ACFT. OPS AND LEAKED CHECKED GOOD. OK FOR SERVICE.SDR HNAA2012100901001Receptacle · burnedGROUND POWER CART PLUG CAUGHT ON FIRE AFTER BEING INSTALLED ON ACFT FOR APPROX. 40 MINUTES. FIRE DAMAGE WAS FOUND AT DC POWER RECEPTACLE AT FORWARD FRAME STA X97 AND FORWARD OF FORWARD PRESSURE BULKHEAD. ACFT IS IN MX FOR REPAIRS.SDR HNAA2012100501000Bulb · failedROW 1 AND ROW 9 EMERGENCY FLOOR LIGHTS ARE INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2012100500999Bulb · failedROW 4 FLOOR EMERGENCY LIGHT IS INOPERATIVE. R & R BULB, OPS CHECKED GOOD.SDR HNAA2012100500997Gauge · failedNR 2 ENGINE FUEL TEMP INDICATOR RED LINED AFTER ENGINE START. R & R FUEL TEMP GAUGE, FUEL TEMP TRANSMITTER AND FUEL TEMP TRANSMITTER CONNECTOR PLUG. CHECKED ALL GROUNDS IAW 73-33-00 AND 71-00-02. OPS CHECKED GOOD. OK FOR SERVICE.SDR HNAA2012100300995Bolt · corrodedRT WING TO FUSELAGE STRUT HAD RUSTED BOLT AND BORE INSIDE OF PANEL 264CR. CLEANED BORE WITH BARREL BRUSH. CORROSION WAS TRANSFERED FROM CORRODED BOLT. INSTALLED NEW BOLT AND PLI WASHER.SDR HNAA2012100300994Bolt · corrodedAFT OTBD BOLT AND BORE IF LT AFT WING TO FUSELAGE STRUT IS RUSTED INSIDE OF PANEL 263CL. REAMED HOLE IAW DWG 85320339. CLEANED CORRSION, R & R BOLT AND PLI WASHER.SDR HNAA2012100300993Bolt · corrodedFORWARD INBD BOLT IS PITTED ON AFT STRUT, LT WING TO FUSELAGE ATTACH POINT. R & R BOLT AND PLI WASHERS.SDR HNAA2012100300997Floorbeam · corrodedUPPER BAG BAY FLOORBEAM ABOVE STR 31S AT BS 600 HAS CORROSION. REMOVED CORROSION FROM UPPER BAGBAY FLOORBEAM. ALODINED AND PRIMED AREA.SDR HNAA2012100300996Bracket · corrodedSURFACE CORROSION AT ANGLE BRACKET JUST BELOW FLOOR AT STA X600 FRONT OF UPPER BAG BAY FLOOR. CORROSION WAS REMOVED, APPLIED ALODINE AND PRIMER TO ANGLE BRACKET AT STA X600.
Back to Boeing DHC-8-102