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 HNAA2012022300619Channel · corrodedJOINT CHANNEL CORRODED IN LAVATORY AREA. R & R WITH MADE REPAIR PART AND INSTALLED WITH SOLID RIVETS IAW SRM51-42-05.SDR HNAA2012022300618Seat Track · corrodedFOUND CORROSION ON LT INBD SEAT TRACK. BLENDED LT INBD SEAT TRACK TO WITHIN LIMITS IAW RD8-53-4936. HFEC INSP CARRIED OUT ON REWORKED AREA IAW RD8-53-4936. NO CRACK INDICATION FOUND.SDR HNAA2012022300617Seat Track · corrodedFOUND CORROSION ON RT INBD SEAT TRACK. BLENDED RT SEAT TRACK TO WITHIN LIMITS IAW RD8-53-4936. HFEC INSP CARRIED OUT ON REWORKED AREA IAW RD8-53-4936.SDR HNAA2012022300616Seat Track · corrodedCORROSION FOUND ON BOTH INBD SEAT TRACK. BLENDED BOTH LT AND RT SEAT TRACK TO WITHIN LIMITS IAW RD8-53-784.SDR HNAA2012022300615Seat Track · corrodedFOUND CORROSION ON LT INBD SEAT TRACK. BLENDED LT SEAT TRACK TO WITHIN LIMITS IAW RD8-53-1339. HFEC INSP CARRIED OUT ON REWORKED AREA IAW RD8-53-1339. NO CRACK INDICATED FOUND.SDR HNAA2012022300614Seat Track · corrodedFOUND CORROSION ON LT OTBD SEAT TRACK. BLENDED LT OTBD SEAT TRACK TO WITHIN LIMITS IAW RD8-53-3644. HFEC INSP CARRIED OTBD ON REWORKED AREA IAW RD8-53-3644. NO CRACK INDICATION FOUND.SDR HNAA2012022300613Seat Track · corrodedFOUND CORROSION ON RT OTBD SEAT TRACK. BLENDED RT OTBD SEAT TRACK TO WITHIN LIMITS IAW RD8-53-3644.SDR HNAA2012022300612Seat Track · corrodedFOUND CORROSION ON RT INBD SEAT TRACK. BLENDED RT SEAT TRACK TO WITHIN LIMITED IAW RD8-53-1339. HFEC INSPECTION CARRIED OUT ON REWORKED AREA IAW RD8-53-1339. NO CRACK INDICATIONS FOUND.SDR HNAA2012022300611Skin · damagedA LIGHTNING STRIKE FOUND ON LT AILERON TOP SKIN ABOUT 1.500" FORWARD OF REAR SPAR. REMOVE LT AILERON IAW AMM 27-12-11. DAMAGE WAS R & R IAW SRM 57-60-21, FIG 5.SDR HNAA2012022300610Channel · corrodedJOINT CHANNEL CORRODED. FABRICATED JOINT CHANNEL IAW DWG 320872.SDR CA120224010Alternator · inoperativeNR 2 AC GENERATOR CAUTION LIGHT ON AND SHOWING 0 VOLTS ON ALL PHASES. REPLACED NR 2 AC GENERATOR AND GROUND RUNS CARRIED OUT CHECKED SERVICEABLE. ACFT RETURNED TO SERVICE.SDR HNAA2012022100601Seat Track · corrodedCORROSION FOUND ON RT INBD SEAT TRACK BETWEEN BS 182 TO 262. SPLICED SEAT TRACK IAW RD8-53-3074. INSTALLED NEW SEAT TRACK SECTION.SDR HNAA2012022100600Seat Track · corrodedCORROSION FOUND ON LT INBD SEAT TRACK BETWEEN BS 182 AND 284. SPLICED LT SEAT TRACK IAW RD8-53-3074 AND NEW SEAT TRACK SECTION INSTALLED.SDR HNAA2012022100609Bulb · inoperativeEMERGENCY EXIT SIGN NEAR FLOOR BY AIRSTAIR DOOR HAS 1 BULB INOPERATIVE. R & R COVER PLATE. R & R BULB. OPS CHECKED GOOD. REINSTALLED COVER PLATE.SDR HNAA2012022100606Roller · lack of lubeRT GEAR DOOR REMAINED OPEN AFTER GEAR RETRACTION. CYCLED GEAR IAW CHECKLIST. DOOR CLOSED, BUT OPENED AGAIN. INBD CREW REPORTS NO DEFECTS NOTED. SWUNG GEAR MANY TIMES. NO DEFECTS NOTED. OK FOR SERVICE AT THIS TIME. ALSO CLEANED AND LUBED FORWARD DOOR UPLOCK SDR HNAA2012022100605Control Box · malfunctionedEMERGENCY LIGHTS FLICKER IN FLIGHT WHEN NR2 PROP 'A' PHASE IS SELECTED. R & R NR 2 PROP BRUSH BLOCK ASSY IAW -8 MM. GROUND RAN ACFT. OPS CHECKED GOOD. EMERGENCY LIGHTS FLICKERED IN CRUISE. OPS CHECKED EMERGENCY LIGHTS IAW MM 33-51-00. OPS CHECKED GOOD. RSDR HNAA2012022100603Seat Track · corrodedFOUND CORROSION ON LT OTBD SEAT TRACK BETWEEN STA X 264 TO X 504. BLENDED LT OTBD SEAT TRACK TO WITHIN LIMITS IAW RD8-53-1342.SDR HNAA2012022100602Seat Track · corrodedFOUND CORROSION ON RT OTBD SEAT TRACK BETWEEN STR X264 TO X504. BLENDED RT OTBD SEAT TRACK BETWEEN STA X264 TO X504 TO WITHIN LIMITS IAW RD8-53-1342. HFEC CARRIED OUT ON REWORKED AREA IAW RD8-53-1342. NO CRACK INDICATION FOUND.SDR HNAA2012022000594Bulb · out of positionBURNING ODOR WITH LOWER GALLEY LIGHTS ON (BUFFET LIGHTS), NO ODOR WITH LIGHTS OFF. INSPECTED LIGHT ASSY'S AND FOUND BULB TOUCHING LENS ON AFT POSITION. REPOSITIONED, OK FOR SERVICE. NO ODOR DETECTED WITH LIGHTS ON (NO DAMAGE TO LENS).SDR HNAA2012022000593Battery · weakLEFT AFT EMERGENCY EGRESS LIGHT IS INOP. R & R EMERGENCY LIGHT BATTERY AT ROW 3AC. OPS CHECKED GOOD.SDR HNAA2012022000592Battery · weakOVERHEAD CENTER AISLE EMERGENCY LIGHT AT ROW 7 INOPERATIVE. R & R EMERGENCY LIGHT BATTERY AT ROW 3AC. OPS CHECKED GOOD.SDR HNAA2012021700591Control Box · malfunctionedEMERGENCY LIGHTS FLICKERED DURING CRUISE, IN CABIN. OPS CHECKED EMERGENCY LIGHTS IAW MM 33-51-00. OPS CHECKED GOOD. R & R EMERGENCY LIGHT CONTROL BOX AS PRECAUTIONARY MEASURE. IF CONDITION RE-OCCURES MORE INFORMATION ON ACFT SYS CONDITIONS REQUIRED. OK FORSDR HNAA2012021700590Retainer · corrodedPAX DOOR LOWER SEAL RETAINER ON FUSELAGE CORRODED. R & R PAX DOOR LOWER SEAL RETAINER WITH NEW PART AND INSTALLED WITH SOLID RIVETS IAW SRM 51-42-05.SDR HNAA2012021700589Threshold · corrodedPAX DOOR ENTRY THRESHOLD FOUND CORRODED. R & R WITH NEW PART AND SOLID RIVETS IAW SRM 51-47-05.SDR HNAA2012021600588Smoke Detector · false activationLAVATORY SMOKE DETECTOR SOUNDED AFTER ROTATION. WOULD NOT GO OFF. RETURNED TO FIELD. TURNED OFF CABIN LIGHTS AND PSU. ALARM STOPPED. INSPECTED FWD CABIN AREA AND LAVATORY FOR HIDDEN DAMAGE IAW SPECIAL PROCEDURES 33.1. NO ODOR OR DAMAGE FOUND.SDR HNAA2012021600587Skin · corrodedCORROSION FOUND ON THE LOWER SURFACE OF THE MACHINE DOUBLER AROUND LT FUEL PUMP CUTOUT. THE LOWER SURFACE OF THE MACHINED DOUBLER AROUND LT FUEL PUMP CUTOUT BLENDED WITHIN LIMITS IAW RD8-57-1907. HFEC AND BOND TEST CARRIED OUT ON AFFECTED AREA IAW WITH RD8-57SDR HNAA2012021600586Skin · corrodedRT WING FUEL PUMP CUTOUT LIGHTLY CORRODED ON LOWER SURFACE UNDER CLAMP RING. HFEC AND BOND TEST CARRIED OUT ON AFFECTED AREA IAW RD8-57-1907. NO CRACKS OR DEBOND INDICATION FOUND. RT WING FUEL PUMP CUTOUT ON LOWER SURFACE HAS BEEN REPAIRED IAW RD8-57-1907.SDR CA120220001Engine · malfunctioned(CAN) DURING CLIMB, ACFT HAD UNCOMMANDED AUTOFEATHER ON NR 2 ENGINE. CREW SHUTDOWN NR 2 ENGINE AND DECLARED AN EMERGENY WITH ATC. FLIGHT LANDED WITHOUT FURTHER INCIDENT. ENGINE NR 2 REPLACED AND ENGINE RUN CARRIED OUT FOUND SATISFACTORY.SDR CA120216003Wheel Half · broken(CAN) DURING TAXI OUT, THE CREW REPORTED A FLAT TIRE ON THE NR 2 MAIN WHEEL ASSY AND RETURNED TO THE GATE. VISUAL INSPECTION OF THE WHEEL ASSY REVEALED THAT A LARGE PIECE OF THE OUTER WHEEL HALF WAS MISSING. THE MISSING PART WAS LOCATED BY THE AIRPORT AUTHORISDR HNAA2012022000596Floor Support · corrodedUNDER F/A SEAT FLOOR, STRUCTURE FOUND CORRODED. TEE SUPPORT UNDER F/A SEAT FLOOR REPLACED WITH NEW ONE AND INSTALLED IAW SRM51-42-05.SDR HNAA2012021500582Warning Light · malfunctionedDURING GEAR EXTENSION, RT MLG UNSAFE LIGHT REMAINED ON DURING GEAR EXTENSION. COMPLIED WITH EMERGENCY CHECKLIST, ALT VISUAL INDICATION INDICATED RT GEAR UNSAFE.SDR HNAA2012021500581Shear Tie · corrodedCORRORSION SPOTS FOUND IN ZONE 120 ON FRAME SKIN FLANGE FROM X136.80 TO X167, BETWEEN STR 30L TO 30R. BLENDED MANY CORRSION SPOTS AND REPROTECTED IAW SRM 51-20-11 AND FOUND TO BE WITHIN LIMITS IAW SRM 53-00-16 AT X136 ON FRAME ANGLE BETWEEN STR 30 TO 32P AT SSDR HNAA2012021500580Frame Splice · crackedCRACK FOUND ON PILOT'S SIDE FRAME SPLICE ANGLE ABOVE NOSE WHEEL STEERING HAND CONTROL. REMOVED LT TOP CONTROL PANEL FOR ACCESS. LT FUSELAGE FRAME STA X136 AT STR 15AM, REPLACED ANGLE SPLICE AND 2 STRAPS. INSTALLED WITH SOLID RIVETS IAW SRM 51-42-05.SDR HNAA201202200059Support · crackedLEFT WING AILERON TERMINAL QUADRANT SUPPORT BOX CRACKED. LT AILERON TERMINAL QUADRANT SUPPORT BOX REPLACED WITH MADE REPAIR PART FABRICATION COVERED BY WO9120.SDR HNAA2012021400579Light · out of positionEMERGENCY FLOOR LIGHT PATH ROW 9 IS TOO FAR UNDERNEATH SEAT AT ROW 9. (MOVE FWD TO FRONT EDGE OF SEAT). REMOVED LENS, POSITIONED ROW 9 EMER FLOOR PATH LIGHT, OUT TO FRONT EDGE OF SEAT, REINSTALLED LENS.SDR HNAA2012021400576Wire · brokenONE RED FLOOR EMERGENCY LIGHT AT ROW 4 IS INOP. MX FOUND WIRES BROKEN. ROA VERIFIED DISCREPANCY REPAIRED BROKEN WIRE, OPS CHECKS.SDR HNAA2012021400575Smoke Detector · activatedLAVATORY SMOKE DETECTOR GOES OFF WITH APU BLEED SELECTED ON. NORMAL WITH BLEED OFF.SDR HNAA2012021000574Wire · chafedWOW CAUTION LIGHT ILLUMINATED IN CRUISE. FOUND CHAFED WIRE ON 3261-38C22 AT RT MLG DISCONNECT. REPAIRED WIRE IAW AMM 20-45-08. CHECKED PROX SENSOR TARGET GAP ON ALL LANDING GEAR. ADJUSTED AS REQUIRED. IAW AMM 32-10-11. PERFORMED GEAR SWINGS. OPS CHECKED SDR HNAA2012021000572Attach Angle · crackedOTBD AFT ATTACH ANGLE FOR FILLET PANEL IS CRACKED. FABRACATED NEW ANGLE IAW DWG 85418256. REMOVED OLD CRACKED ANGLE. INSTALL NEW ANGLE IAW DWG 85410042.SDR HNAA2012021000571Angle · corrodedINBD NACELLE TO FORWARD SPAR CLOSING ANGLE IS CORRODED ON NR 1 NACELLE. REMOVED INBD CLOSING ANGLE, FABRACATED INBD SIDEWALL ANGLE IAW DWG 85710414. INSTALLED INBD SIDEWALL ANGLE IAW DWG 85710413.SDR HNAA2012021000570Flap Track · corrodedNR 2 FLAP TRACK IS CORRODED ON MATING SURFACE. R & R NR 2 FLAP TRACK ASSY.SDR HNAA2012021000569Flap Track · corrodedNR 2 FLAP TRACK BADLY CORRODED ON MATING SURFACE. R & R NR 3 FLAP TRACK.SDR CA120214007Computer · no test(CAN) NR 2 STALL WARNING TEST FAILED WHILE DOING A LINE CHECK INSPECTION. FOUND TO BE THE STALL WARNING COMPUTER AT FAULT. REPLACED STALL WARNING COMPUTER. ACFT RETURNED TO SERVICE.SDR HNAA2012020800568Shutoff Valve · inoperativeWHEN PERFORMING FIRE PROTECTION TEST, PULLED NR 2 TEE HANDLE AND IT DID NOT ILLUMINATE FUEL OFF VALVE. LIGHT FILAMENT TESTS OK. R & R NR 2 ENGINE FUEL SHUTOFF VALVE ACTUATOR IAW MM 28-21-21. OPS CHECKED GOOD.SDR HNAA2012020800560Bracket · corrodedTOP AFT BRACKET IS CORRODED. R & R TOP AFT BRACKET UNDER PAX STAIRS IAW DWG 85210302.SDR HNAA2012020800567Recorder · failedFDR CAUTION LIGHT ILLUMINATED. R & R FDR IAW 31-33-02. OPS CHECKED GOOD.SDR HNAA2012020800566Warning Light · illuminatedON LANDING, WOW CAUTION LIGHT ILLUMINATED AND SPOILERS DID NOT DEPLOY. NO NORMAL BRAKING UNTIL WOW LIGHT EXTINGUISHED AT WHICH TIME SPOILERS DEPLOYED. PERFORMED MEMORY RECALL OF PSEU. NO FAULT FOUND. PERFORMED NEAR/FAR TEST AND VISUALLY INSPECTED WOW SENSOSDR HNAA2012020800563Bulb · inoperativeFORWARD LEFT FUSELAGE EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. CLEANED SOCKET, REINSTALLED BULB. OPS CHECKED GOOD. REINSTALLED COVER PANEL.SDR HNAA2012020800562Light · out of positionROW 4 RED EMERGENCY LIGHTS POSITIONED IMPROPERLY ON FLOOR. REPOSITION EMERGENCY LIGHTS AT ROW 4.SDR HNAA2012020800561Bulb · failedEXIT SIGN AT EMERGENCY EXIT DOOR AT ROW 4AC IS INOPERATIVE. R & R BULB AS REQUIRED.
Back to Boeing DHC-8-102