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 HNAA2013040100195Skin · corrodedFORWARD FUSELAGE BELLY SKIN IS CORRODED AND RIVETS ARE PULLING THROUGH. CRACKS ARE RADIATING FROM RIVETS AT BELLY WATER DRAIN AFT OF STA X187.000, STR 33. SKIN WAS ALSO DISBONDED. REMOVED RIVETS FROM PORTION OF STR 33 AND CLEANED AREA FOR EVALUATION. CUT OUSDR HNAA2013040100194Bulb · inoperativeONE EMERGENCY FLOOR LIGHT IS INOPERATIVE UNDER ROW 9. R & R BULB. REINSTALLED LIGHT ASSY IN FLOOR TRACK. RESECURED WITH CLEAR STRIP.SDR CA130403005Relay · failed(CAN) AFTER TAKEOFF WITH GEAR UP SELECTION, THE GEAR DID NOT RETRACT WHICH WAS ACCOMPANIED WITH SOME NOISE. ALL 3 GEAR INDICATIONS REMAINED GREEN AND ADDITIONALLY, THE HANDLE LIGHT CAME ON. ALL WAS OK ON THE DOWN SELECTION. A 2ND RETRACTION WAS MADE WITH THESDR HNAA2013032900193Wire · brokenWIRE BROKEN IN EMERGENCY LIGHT AT PANEL 133CZ. R & R EMERGENCY LIGHT ASSY IAW 33-50-03Q. OPS CHECKED GOOD.SDR HNAA2013032900192Connector · unsecureUNABLE TO CONTROL DUCT TEMP BELOW 50C IN AUTO AND MANUAL. RESEATED CONNECTOR ON PACK VALVE ACTUATOR. OPS CHECKED GOOD. CABIN DUCT TEMP SENSING BULB WAS LATER CHANGED IAW MM 21-60-41. OPS CHECKED GOOD.SDR HNAA2013032900191Brush Block · failedPROPS AT 1050, EMERGENCY LIGHTS FLICKER WHEN ENGINE NR 2, BLADES 1 AND 3 ARE HEATING. R & R, R2 BRUSH BLOCK IAW 61-10-11. GROUND RAN ACFT. OPS CHECKED GOOD. OK FOR SERVICE.SDR HNAA2013032900190Generator · slowNR 1 AC GENERATOR IS SLOW TO COME ON LINE WHEN SELECTED ON WITH PROP AT 785. REQUIRES SEVERAL RESETS. COULD NOT DUPLICATE. GROUND RAN ACFT IAW RUN UP MANUAL. OK FOR SERVICE.SDR HNAA2013032900189Brush Block · dirtyEMERGENCY LIGHTS FLICKER WITH PROPELLER HEAT SELECTED ON AND PROPELLER RPM AT 1050. R & R NR 2 BRUSH BLOCK IAW 61-10-11. GROUND RAN ACFT. OPS CHECKED GOOD OK FOR SERVICE. EMERGENCY LIGHTS FLICKERED AGAIN IN MDT. 2 OLD STYLE PROP HEAT LEADS WERE REPLACED OSDR HNAA2013032900187Lockout · intermittentDURING NR 2 BETA LOCKOUT TEST, WITH BETA TEST SWITCH AT LOCKOUT AND NR 2 PROP INDICATOR BETA LOCK TEST BUTTON PRESSED, NR 2 PROPELLER GROUND RANGE LIGHT ILLUMINATED. PROBLEM IS INTERMITTENT. BETA LOCKOUT SYS WITH CR AND MOD DEACTIVATED IAW APPENDIX 1,61-4.SDR HNAA2013032700187Dump Valve · malfunctionedCIRCUIT BREAKER G6 RT OTBD ROLL SPOILER INDICATION WILL NOT RESET. R & R NR1 SYSTEM, NR 2 ROLL LIFT DUMP VALVE IAW MM 27. OPS AND LEAK CHECKED GOOD.SDR HNAA2013032600184Bulb · inoperativeFORWARD RT TOP, LT AFT AND RT MOST AFT TOP EMERGENCY SIGNS ARE DIM. R & R BULBS IN EMERGENCY EXIT SIGNS. OPS CHECKED GOOD. RESECURED LENS.SDR HNAA2013032600183Generator · warning lightRT AC BUSS CAUTION LIGHT ILLUMINATED AFTER NR 2 AC GENERATOR WAS BROUGHT ON LINE. CYCLED NR 2 AC GENERATOR. CAUTION LIGHT AND BUSS FAULT LIGHT WENT OUT. R & R NR 2 GCU IAW 24-21-02 AND NR 2 AC GENERATOR IAW WC 24-20-11R. OPS AND LEAK CHECKED GOOD.SDR HNAA2013032500171Bulb · inoperativeFOURTH EMERGENCY FLOOR PATH LIGHT IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013032500170Bulb · inoperativeSIDEWALL EMERGENCY LIGHT IS DIM AT ROW 1DF. R & R BULBS. OPS CHECKED GOOD.SDR HNAA2013032500169Light · brokenEMERGENCY EXIT SIGN AT FLOOR, FORWARD SIDE OF PAX DOOR IS BROKEN. R & R EMERGENCY LIGHT SUBASSEMBLY IAW WIRING PRACTICES. OPS CHECKED GOOD.SDR HNAA2013032200143Angle · crackedANGLE FOUND CRACKED ON TOP OF FUSELAGE , UNDER CENTER PANEL 261 FT. R & R WITH NEW PART IAW SRM 51-42-05 AND SRM 51-40-10.SDR HNAA2013032200142Bulb · failedEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE AT ROW 7. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013032100138Seat Track · corrodedCENTER RT SEAT TRACK HAS CORROSION AROUND LAVATORY AND GALLEY MOUNT BOLT HOLES. REMOVED DAMAGE SECTION OF SEAT RAIL. SPLICED IN NEW SECTION OF SEAT TRACK IAW RD8-53-3074.SDR CA130320005Bearing · rough(CAN) FLIGHT CREW REPORTED STIFF AILERONS WITH AUTO PILOT DISCONECTED. RT WING AILERON QUADRANT BEARINGS FOUND SIEZED. RT WING QUADRANT ASSY REMOVED DISASSEMBLED, BEARINGS REPLACED IN QUADRANT HSG. AILERON TERMINAL QUADRANT INSTALLED IAW 27-12-31 OF THE AMMSDR HNAA2013031900137Bulb · inoperativeROW 4 EMERGENCY LIGHT BULBS ARE INOPERATIVE. R & R EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR HNAA2013031900136Bulb · failedROW 8, EMERGENCY FLOOR PATH LIGHT IS INOPERATIVE. R & R BULB . OPS CHECKED GOOD.SDR HNAA2013031900133Strut · dischargedON GEAR RETRACTION, WW YELLOW CAUTION LIGHT AND NOSE GEAR ADVISORY LIGHT ILLUMINATED. ALSO A GRINDING NOISE FROM NOSE BAY HEARD. FOUND NLG SERVICING LOW. SERVICED ALL LANDING GEAR IAW MM 12-10-32. SWUNG GEARS. OPS CHECKED GOOD.SDR HNAA2013031800130Battery · inoperativeEMERGENCY LIGHTS GO DIM THEN OFF AFTER 30 SECONDS. R & R ALL EMERGENCY LIGHT BATTERIES IAW WC 33-50-05R AND WC 33-50-03Q FOR OPS CHECKSDR HNAA2013031500128Battery · inoperativeCENTER CEILING EMERGENCY LIGHT IS INOPERATIVE. INSTALLED NEW BATTERY. OPS CHECKED GOOD.SDR HNAA2013031500127Strut · low pressureON GEAR RETRACTION WOW CAUTION LIGHT AND NOSE GEAR YELLOW ADVISORY ILLUMINATED. A GRINDING NOISE FROM NOSE BAY HEARD. FOUND NLG SERVICING WAS LOW. SERVICED ALL LANDING GEAR IAW MM 12-10-32. GEAR SWINGS OPS CHECKED GOOD.SDR HNAA2013031500126None · noneAIRSTAIR DOOR EMERGENCY LIGHT SYS WOULD NOT EXTINGUSH. OPS CHECKED EMERGENCY LIGHT SYS IAW WC 33-50-03. OPS CHECKED GOOD. OK FOR SERVICE.SDR HNAA2013031300125Firewall · crackedNR 1 NACELLE AFT FIREWALL CRACKED ABOVE JET PIPE ATTACH COUPLING ON THE INBD AND OTBD SIDE. R & R ANGLE, DRILLED AND INSTALLED NEW ANGLE IAW DWG NR 85410024.SDR HNAA2013031300124Firewall · chafedNR 1 NACELLE FORWARD FIREWALL WEB CHAFED ON INBD SIDE. REPAIRED NR 1 NACELLE FIREWALL IAW EO 8-54-13-0128.SDR HNAA2013031200123Generator · inoperativeNR 2 AC GENERATOR HOT CAUTION LIGHT ILLUMINATED IN FLIGHT. R & R NR 2 AC GENERATOR IAW WC 24-20-11. OPS AND LEAKED CHECKED GOOD.SDR HNAA2013031100121Bulb · inoperativeEMERGENCY FLOOR PATH LIGHTS INOPERATIVE AT ROW 1DF. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013031100120Bulb · burned outEMERGENCY SIDEWALL LIGHTS ARE DIM AT ROWS 1DF AND 4DF.....REMOVED AND REPLACED BURNED OUT BULBS IN EMERGENCY SIDEWALL LIGHTS AT ROWS 1DF AND 4DF. OPS CHECKED GOOD.SDR CA130314001Trim System · binding(CAN) ELEVATOR TRIM JAM DURING AUTOPILOT DESCENT AT 16000 FT. AUTOPILOT WAS MANUALLY DISENGAGED. WHEN PILOT ATTEMPTED TO TRIM THE NOSE DOWN MANUALLY, IT WAS DISCOVERED THAT THE TRIM WHEEL HAD JAMMED. PILOT STILL HAD FULL PITCH AND ROLL CONTROL WITH THE YOKESDR CA130312013Pseu · faulted(CAN) WEIGHT ON WHEELS CAUTION LIGHT ILLUMINATED AND REMAINED ON DURING PREFLIGHT CHECKS. FOUND PSEU TO BE AT FAULT. REPLACED PSEU AND ACFT RETURNED TO SERVICE.SDR HNAA2013030800116Timer · failedAIRFRAME DEICE BOOTS ARE INOPERATIVE IN AUTO, FAST AND SLOW. OK IN MANUAL. R & R DEICE TIMER. OPS CHECKED GOOD IAW MM 30-10-00. OK FOR SERVICE.SDR HNAA2013030800115Relay · failedAT 5000 FEET, NR 2 ENGINE INTAKE HEAT INOPERATIVE. R & R RELAY 3021-K2. GROUND RAN ACFT. OPS CHECKED NORMAL. OK FOR SERVICE.SDR HNAA2013030600114Plate · corrodedPLATE ON TOP OF LAVATORY SERVICE BOX IS CORRODED, AROUND DRAIN TUBE VALVE. REMOVED & REPLACED PLATE IAW DWG 85320983.SDR HNAA2013030600113Bulb · inoperativeFLOOR EMERGENCY LIGHT AT ROW 4 INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013030600112Bulb · burned outLEFT SIDE, AFT EMERGENCY LIGHT IS DIM. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013030600110Indicator · inoperativeNR 1 TORQUE GAUGE ANOLOG AND DIGITAL DID NOT GO ABOVE 10 PERCENT. CLEANED CONNECTOR ON TSCU. R & R NR 1 TORQUE INDICATOR. OPS CHECKED GOOD ON THE GROUND RUN, IAW MM 77-10-00.SDR HNAA2013030400107Bulb · inoperativeEMERGENCY EXIT LIGHT AT PAX DOOR IS INOPERATIVE. R & R BULB. REINSTALLED LENS COVER. OPS CHECKED GOOD.SDR HNAA2013030400105Bulb · failedSIDEWALL EMERGENCY LIGHTS ARE DIM AT ROWS 1DF AND 4AC. R & R BURNED BULB IN SIDEWALL EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR HNAA2013030400104Bulb · failedRT AFT FUSELAGE EMERGENCY LIGHT IS INOPERATIVE. R & R BULB IN RT AFT FUSELAGE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR HNAA2013030400103Bulb · burned outEMERGENCY EXIT SIDEWALL LIGHT BY PAX DOOR IS DIM. R & R BURNED OUT BULB IN SIDEWALL EMERGENCE LIGHT BY PAX DOOR.SDR CA130304001Relay · failed(CAN) AFTER TAKEOFF AND GEAR UP SELECTION, THE FLIGHT CREW RECEIVED THE LT AND RT GEAR DOOR LIGHTS, THE RED CENTER AND THE RED HANDLE LIGHT. THIS EVENT HAD OCCURRED TWICE AND ACFT RETURNED TO BASE. MAINTENANCE ACTION HAD RELAYS 3261-K8, K9 AND K11 REPLACED.SDR CA130404004Shaft · sheared(CAN) DEFECT-1102548 NR 1 ENGINE DRIVEN HYD LIGHT ON CONFIRMED THAT THE NR 1 HYD PRESSURE WAS GOOD EVEN WITH SPU`S SELECTED OFF. PRESSURE WAS GOOD. DEFERRED THE CAUTION LIGHT. ONCE AIRBORNE FLT CREW REPORTS THAT THEY HAD NO NR 1 SYS PRESSURE AND THEY WERE RESDR HNAA2013030100100Bulb · failedLOWER LEVEL EMERGENCY EXIT LIGHT IS INOPERATIVE AT ROW 2 AND ROW 4. R & R EMERGENCY LIGHT BULB IAW 33-51-00.SDR HNAA2013030100099Transmitter · failedNR 2 MAIN HYD PRESSURE INDICATION DROPPED TO 0 PSI ON TAKEOFF ROLL. NO CAUTION LIGHTS ILLUMINATED AND HYD QUANTITY IS GOOD. R & R HYDRAULIC PRESSURE TRANSMITTER IN RT MLG WHEEL WELL. OPS CHECKED GOOD IAW MM 29-10-00.SDR HNAA2013030100098Wire · chafedF/A REPORTED EMERGENCY LIGHTS ILLUMINATED DURING CLIMBOUT FOR A FEW SECONDS AND REMAINED OFF FOR REST OF THE FLIGHT WITH NO OTHER ASSOCIATED LIGHTS. INSPECTED WIRING AT NR 1 RGB IN NACELLE. FOUND SEVERAL WIRES CHAFED NEAR AC GENERATOR CONNECTOR PLUG. APPLIESDR HNAA2013030100097Current Limiter · blownDC BUSS CAUTION LIGHT CAME ON DURING TAKEOFF ROLL. REJECTED TAKEOFF. CLEARED RUNWAY. ATTEMPED TO RESET. WILL NOT RESET. MX FOUND CURRENT LIMITERS BLOWN. R & R CURRENT LIMITERS.SDR HNAA2013022700096Bulb · failedSIDEWALL EMERGENCY LIGHT HAS 1 BULB INOP AT ROW 4DF. REMOVED LENS, REMOVED AND REPLACED BULB, AT SAID LOCATION. INSTALLED LENS. OPS CHECKED GOOD.
Back to Boeing DHC-8-102