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 HNAA2012080100888Bulb · failedROW 7 CEILING EMERGENCY LIGHT IS INOPERATIVE. REMOVED LENS, R & R BULB, AT SAID LOCATION. REINSTALLED LENS. OPS CHEKCED GOOD.SDR HNAA2012080100887Bulb · failedMID CABIN CEILING EMERGENCY LIGHT IS INOPERATIVE. R & R LIGHT BULB IAW 33-51-00. OPS CHECKED GOOD.SDR HNAA2012080100886Bulb · malfunctionedRIGHT FORWARD EMERGENCY LIGHT ON OUTSIDE OF FUSELAGE IS DIM. R & R BULB. OPS CHECKED GOOD.SDR HNAA2012073000885Lamp · failedTHIRD AFT EMERGENCY FLOOR TRACK LIGHT, THIRD FROM THE REAR IS INOPERATIVE. R & R EMERGENCY FLOOR LIGHT. REINSTALLED TRACK, OPS CHECKED GOOD.SDR HNAA2012073000884Line · failedLOST NR 1 HYDRAULICS ON RUNWAY PRIOR TO TAKEOFF. ISOLATION VALVE ILLUMINATED. INSTALLED TEMP FLEX LINE IAW WORKCARD 20-50-52. OPS CHECKED GOOD.SDR HNAA2012072700883Lamp · failedLEFT AFT FUSELAGE EMERGENCY LIGHT DIM. R & R LAMP IAW MM 33-51-00.SDR HNAA2012072700882Control Unit · failedECU POWER UPTRIM LIGHT ILLUMINATED ON TAKE-OFF ROLL. R & R NR 1 TSCU IAW AMM 61-26-00. OPS CHECKED IAW SRT, SECTION 5. NO DEFECTS NOTED AT THIS TIME. OK FOR SERVICE.SDR CA120727004Valve · leaking(CAN) DURING FLIGHT, CREW NOTICED NR 2 HYDRAULIC SYS FLUID DEPLETING. THEY RETURNED TO THEIR DEPARTURE AIRPORT FOR AN UNEVENTFUL LANDING. MAINTENANCE FOUND THE RT NACELLE FLIGHT SPOILER UNLOAD VALVE HAD 2 BOLTS WITH THE HEADS SHEARED FROM THE VALVE BODY. THSDR CA120801002Case · fractured(CAN) DURING THE PUSH BACK, A MAJOR HYDRAULIC FLUID LEAK FROM THE LT WING WAS NOTICED. THE ACFT WAS TOWED BACK AND MAINTENANCE ADVISED. ON-SITE MAINTENANCE FOUND THE LEFT OTBD ROLL SPOILER ACTUATOR CASING FRACTURED. THE ACTUATOR WAS REPLACED, THE NR 2 HYDRAULSDR CA120725006Proximity Sensor · failed(CAN) IN THE CLIMBOUT, THE CREW GOT A LANDING GEAR INOPERATIVE CAUTION MESSAGE. CREW DECIDED TO RETURN TO DEPARTURE. MAINTENANCE REPLACED PROXIMITY SENSING ELECTRONIC UNIT AND RELAYS K5, K6, K7 & K11. LANDING GEAR SWING CARRIED OUT NO FAULT FOUND.SDR HNAA2012072500881Bulb · failedEMERGENCY FLOOR LAMP IS INOPERATIVE AT 4TH RED LIGHT FROM REAR OF ACFT. R & R BULB AT 4TH AFT FLOOR EMERGENCY. OPS CHECKED GOOD.SDR HNAA2012072500880Bulb · failedEMERGENCY LIGHT BUTTON ON F/A PANEL WILL NOT COME ON. REMOVED BULB FROM EMERGENCY LIGHT BUTTON ON F/A PANEL. INSTALLED NEW BULB. OPS CHECKED GOOD.SDR HNAA2012072500879Ecu · failedDURING TAKEOFF, NR 1 NP WENT TO 1213 FOR APPROX 1 SEC, ABORTED TAKEOFF. GROUND RAN ACFT WITH NR 1 PROP WITH IN LIMITS AT THIS TIME. R & R ENGINE ECU IAW MM 72-01-10. GROUND RAN ENGINE AS REQUIRED. OPS CHECKED GOOD. OK FOR SERVICE AT THIS TIME.SDR HNAA2012072500878Indicator · malfunctionedWEATHER RADAR SHOWS TEST PATTERN WHEN SELECTED ON. R & R WEATHER RADAR INDICATOR, OPS CHECKED GOOD. OK OR SERVICE.SDR CA120723021Scoop · cracked(CAN) NR 2 L/E RAM AIR SCOOP DUCT ASSY CRACKED AND PIECE BLOWN OUT. LANDING LIGHTS, LEADING EDGE REPLACEDSDR HNAA2012072000876Bolt · corrodedLOCK BOLTS ARE CORRODED INSIDE OF VERTICAL STAB, FORWARD TUNNEL, AT RIB 4. CLEANED OFF LIGHT SURFACE CORROSION ON LOCK BOLTS, INSIDE VERTICAL STAB, FORWARD TUNNEL AT RIB 4.SDR HNAA2012072000875Seat Track · corrodedLIGHT CORROSION FOUND IN SEAT TRACK SECTION AT STA 598. LIGHTLY BLENDED SEAT TRACK. INSPECTED SEAT TRACK AND FOUND THEM TO BE OUT OF LIMITS IAW RD8-53-4936.SDR HNAA2012072000874Web · corrodedSPOTS OF CORROSION ON WEB FLANGE AT STA X225 TO X235 AND STR 25P. CLEANED LIGHT SURFACE CORROSION, ALODINED, PRIMED AND REAPPLIED AV30 RUST INHIBITOR.SDR CA120720006Bracket · cracked(CAN) DURING PRE-FLIGHT CHECK, FLIGHT CREW REPORTED THAT AN ABNORMAL FORCE WAS REQUIRED TO OPERATE THE ALTERNATE MLG, RELEASE HANDLE. DURING TROUBLESHOOTING, MAINTENANCE FOUND THE LT ALTERNATE MLG RELEASE CABLE, CHAFING ON THE ENGINE TOP FIREWALL. FURTHER INSDR CA120719007Battery · thermal runaway(CAN) DURING CRUISE, FLIGHT CREW RECEIVED A MAIN BATTERY HOT RED WARNING LIGHT AND CONFIRMED THE BATTERY OVERHEAT CONDITION ON THE BATTERY TEMPERATURE DISPLAY SCALE. AN EMERGENCY WAS DECLARED AND DECISION WAS TAKEN TO RETURN AND LAND. THE ACFT LANDED WITHOUT SDR HNAA2012071800873Stringer Splice · corrodedSTRINGER SPLICE AT STA X639, STR 32S HAS SEVERAL SPOTS OF LIGHT CORROSION. CLEANED AREA, REMOVED 3 RIVETS, LIGHTLY BLENDED STRINGER 32S TO REMOVED LIGHT CORROSION. ALODINE AND PRIMED AREA IAW SRM 51-20-36.SDR HNAA2012071800872Frame · corrodedFRAME LEG HAS CORROSION AT STA X252 BETWEEN STR 31S AND 30S. LIGHTLY BLENDED AROUND 1 RIVET HOLE. REMOVING MINOR CORROSION, ALODINE AND PRIMED AREA IAW SRM 51-20-16 AND 51-20-36.SDR HNAA2012071800871Frame · corrodedFRAME LEG HAS CORROSION AT STA.X222 BETWEEN STR.31S AND 30S. LIGHTLY BLENDED CORROSION FROM FRAME LEG, ALODINED AND PRIMED AREA IAW SRM 51-20-16 AND 51-20-36.SDR HNAA2012071800870Frame · corrodedFRAME LEG HAS CORROSION AT STA X312, BETWEEN STR 31S AND 30S. FRAME LEG HAD DIRT ACCUMULATION, CLEANED FRAME LEG AND FOUND NO CORROSION. ALODINE AND PRIMED AREA IAW SRM 51-20-16 AND 51-20-36.SDR HNAA2012071800868Oil System · lowNR 2 ENGINE OIL PRESSURE LIGHT ILLUMINATED ON TAKEOFF. CREW DEPARTED RUNWAY. OIL PRESSURE NORMAL. INSPECTED ENGINE, FOUND 3 QUARTS LOW. SERVICED AS REQUIRED. GROUND RAN ACFT. NO DEFECTS NOTED.SDR HNAA2012071600867Bulb · failedROW 5, OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. REMOVED LIGHT LENS PANEL, R & R BULB. OPS CHECKED GOOD. INSTALLED PANEL WITH RETAINED HARDWARE.SDR HNAA2012071600866Bulb · failedEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE AT ROW 5. R & R FLOOR PATH LIGHT BULB AT ROW 5 AND CLOSED ACCESS PANEL.SDR HNAA2012071600865Transceiver · failedWEATHER RADAR NOT PAINTING KNOWN WEATHER AS REPORTED BY ATC. R & R WEATHER RADAR R/T. OPS CHECKED GOOD IAW MM 34-41-04.SDR HNAA2012071600864Control Box · intermittentEMERGENCY LIGHTS FLICKERED ENROUTE AND ON TAXI. R & R EMERGENCY LIGHT CONTROL BOX IAW MM 33-52-00. OPS CHECKED GOOD. GROUND RAN GOOD. OK FOR SERVICE.SDR HNAA2012071300858Seat Track · corrodedCORROSION ON RT INBD SEAT TRACK AROUND ATTACH POINT FOR GALLEY. REMOVED CORRODED PORTION OF SEAT TRACK IAW RD8-53-3074. SPLICE IN NEW PORTION OF SEAT TRACK IAW RD8-53-3074.SDR HNAA2012071300863Fitting · corrodedBOTTOM OF AIRSTAIR DOOR OPENING THRESHOLD FITTING IS CORRODED. R & R THRESHOLD MEMBER IAW ENG DWG 85321241.SDR HNAA2012071300862Stringer · corrodedCORROSION AT STR 31P AND FRAME X201.300 ON THE LT SIDE OF TENSION FITTING. BLENDED CORROSION IAW SRM 51-20-11, ALODINED AND PRIMED AREA IAW SRM 51-20-16 AND 51-20-36.SDR HNAA2012071300861Stringer Splice · corrodedCORROSION AT STRINGER 32S AND AFT OF FRAME 488.500. REMOVED STRINGER SPLICE AT BS 488.5. REMOVED STRINGER SECTION FROM BS 488.5 THROUGH 528. REINSTALLED STRINGER SPLICE AND STR SECTION FROM BS 488.5 TO 528 IAW DWG 85330033.SDR HNAA2012071300860Stringer · corrodedCORROSION ON STRINGER 31S BETWEEN BS 445.500 AND 467.000. BLENDED CORROSION IAW SRM 51-20-11, ALODINE AND PRIMED IAW SRM 51-20-16, 51-20-36.SDR HNAA2012071300859Frame · corrodedMINOR CORROSION ON FRAME LEG AT BS 436.500 AND STR 31S. BLENDED CORROSION IAW SRM 51-20-11, ALODINED AND PRIMED IAW SRM 51-20-16, 51-20-36.SDR HNAA2012071300857Bulb · failedONE EMERGENCY LIGHT IS INOPERATIVE ON BASE OF F/A'S WALL. R & R BULB. OPS CHECKED GOOD.SDR HNAA2012071200856Frame · corrodedMINOR CORROSION AT BOTTOM OF VERTICAL FRAME MEMBER AT STA X510.00 BETWEEN STR 32S AND 31S. BLENDED CORROSION IAW SRM 51-20-11, ALODINED, PRIMED AREA IAW SRM 51-20-16, 51-20-36.SDR HNAA2012071200855Frame · corrodedCORROSION AT FRAME LEG STA X531.5 BETWEEN STR 32S AND 31S. BLENDED CORROSION IAW SRM 51-20-11, ALODINED, PRIMED AREA IAW SRM 51-20-16, 51-20-36.SDR HNAA2012071200854Stringer · corrodedCORROSION ON STR 31S, JUST AFT OF FRAME BS 445.5.SDR HNAA2012071200850Hinge Fitting · corrodedLAVATORY SERVICE AREA DOUBLER HINGE AND DOOR ARE CORRODED. R & R LAVATORY DOUBLER AND DOOR ASSY IAW DWG 85320983.SDR CA120711008Case · fractured(CAN) DURING TAXI OUT FROM THE GATE, FLIGHT CREW OBSERVED THE HYDRAULIC SYSTEM NR 1 FLUID LEVEL DEPLETING. THE ACFT RETURNED TO THE GATE. ON-SITE MAINTENANCE FOUND THE LEFT INBD ROLL SPOILER ACTUATOR CASING FRACTURED. THE ACTUATOR WAS REPLACED, LEAK CHECKED SDR HNAA2012071100849Skin · debondedSKIN DISBONDED ALONG STR 32S FROM X506 TO X520 AND AT FRAME X510 AT FRAME LEGS INBD AND OTBD OF STR 32S. REMOVED RIVETS IN FRAME X510 FROM STR 30S TO 31P, FROM STR31S TO 32S,33S AND 32P. REPAIRED SKIN DISBOND IAW EO8-53-12-0282.SDR HNAA2012071100848Generator · failedRIGHT AC BUSS CAUTION LIGHT ILLUMINATED IN FLIGHT WITH ASSOCIATED CAUTION LIGHTS. COULD NOT DUPLICTE ON GROUND RUN. FOUND PROP HEAT SELECTED ON AT THE TIME. INSPECTED WIRING AND CURRENT LIMITERS IN RT AC CONTACTOR BOX. NO DEFECTS NOTED. R & R NR 2 AC GENERSDR HNAA2012071000845Smoke Detector · failedBAG BAY SMOKE WARNING LIGHT ILLUMINATED CONTINUOSLY. NO SMOKE IN BAG BAY (DOOR OPEN WITH LIGHT ON). R & R NR 2 BAG BAY SMOKE DETECTOR IAW MM 27-12-01. OPS CHECKED GOOD. CLEARED MEL.SDR HNAA2012071000844Ground Wire · damagedDURING TAXI, RT RED GEAR UNSAFE LIGHT HANDLE LIGHT AND HORN SOUNDED, CREW INSTALLED GEAR PINS. REPAIRED BROKEN GROUND WIRE AT SENSOR. SWUNG LANDING GEAR SEVERAL TIMES IAW AMM 32-30-00. NO FAULTS NOTED. OPS CHECKED GOOD. OK FOR SERVICE.SDR HNAA2012071000843Bulb · burned outF/A'S EMERGENCY LIGHT SWITCH BACKLIGHT IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR CA120709002Solenoid Valve · shorted(CAN) ON INITIAL CLIMB, FLAPS WERE SELECTED TO 0. DURING RETRACTION, CIRCUIT BREAKER L7 FLAP CONT POPPED AND FLAPS JAMMED AT 5. THE ACFT RETURNED AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE TRAVELED TO THE ACFT LOCATION AND FOUND THE FLAP POWER UNIT, FSDR CA120629011Tube · fractured(CAN) ON SHORT FINAL, FLIGHT CREW REPORTED A LOSS OF POWER ON THE NR 2 ENGINE. THE APPROACH WAS CONTINUED AND THE ACFT LANDED WITHOUT INCIDENT. DURING TROUBLESHOOTING, MAINTENANCE FOUND THE NR 2 PROPELLER OVERSPEED GOVERNOR P3 PRESSURE TUBE FRACTURED NEAR THSDR HNAA2012062700836Bulb · failedCEILING EMERGENCY LIGHT IS INOPERATIVE AT ROW 2. R & R EMERGENCY LIGHT BULB AT ROW 2. OPS CHECKED GOOD.SDR CA120627004Actuator · fractured(CAN) THE ACFT ARRIVED AT A MAINTENANCE BASE WITH A HYDRAULIC LEAK ON THE RT WING. MAINTENANCE TRACED THE LEAK TO THE RT OTBD ROLL SPOILER ACTUATOR AND FOUND THAT THE ACTUATOR HOUSING WAS FRACTURED. THE ROLL SPOILER ACTUATOR WAS REPLACED. ROLL SPOILER ACTUA
Back to Boeing DHC-8-102