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 CA130107008Engine · leaking(CAN) DURING THE APPROACH, FLIGHT CREW REPORTED SMOKE IN THE COCKPIT/CABIN AND DECLARED AN EMERGENCY. FLIGHT CREW PUT ON THEIR OXYGEN MASKS AND SMOKE GOGGLES, CONTINUED ON WITH THE APPROACH AND LANDED WITHOUT FURTHER INCIDENT. UPON LANDING THE ACFT WAS TAXIED SDR CA130107003Case · fractured(CAN) UPON LANDING, FLIGHT CREW NOTICED THAT THE RT OTBD SPOILER WAS NOT INDICATING ANY MOVEMENT. THE ACFT WAS TAXIED TO THE GATE WITHOUT ANY INCIDENT. MAINTENANCE FOUND THE RT OTBD SPOILER ACTUATOR CASING FRACTURED. THE ACTUATOR WAS REPLACED, TESTED AND THSDR HNAA2013010401147Unknown · malfunctionedCREW REPORTS AFTER LEVELING, AFTER DESCENT, ACFT RAN OUT OF NOSE DOWN TRIM. CHECKED LT AND RT ELEVATOR SPRING TABS AND TRIM TABS FOR TRAVELS. ALL TRAVELS ARE WITHIN LIMITS FOR AMM 27-00-00.SDR HNAA2013010401144Bulb · inoperativeFIRST EMERGENCY LIGHT IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013010401143Radio · malfunctionedNR 1 COMM STUCK IN TRANSMIT EVEN WITH CAPT AND F/O COM PANEL SELECTED TO NR 2. BOTH CAPT AND FO OPS NORMAL WHEN SELECTED TO NR 2 COM. TAXIED ACFT AND COULD NOT DUPLICATE, R & R REU AND NR 1 COM HEAD AS PRECAUTION.SDR HNAA2013010401142Control Cable · out of adjustELEVATOR CONTROLS VERY SLOPPY AND DIFFICULT TO MAINTAIN PITCH ATTITUDE ON APPROACH AND LANDING. ADJUSTED ELEVATOR CABLE TENSIONS IAW MM 27-00-00. COMPLETED RII OF ELEVATOR CABLE TENSION.SDR HNAA2013010201141Fitting · corrodedCORROSION AT LAVATORY, BELOW ORANGE TUBE AT LAV BOX. REMOVED CORRODED MACHINED FITTING. DRILLED NEW FITTING AND INSTALLED IAW DWG 85320983.SDR HNAA2013010201138Threshold · corrodedPAX DOOR THRESHOLD HAS SEVERAL AREAS OF CORROSION. R & R THRESHOLD ASSY IAW
DWG 85321241.SDR HNAA2013010201137Gauge · inaccurateNR 2 OIL PRESSURE ABOVE GREEN ARC ON TAKEOFF ROLL. R & R OIL PRESSURE/TEMP GAUGE IAW MM 79-32-00. OPS CHECKED GOOD. OK FOR SERVICE.SDR HNAA2012123101136Blade · sparksSPARKS OBSERVED COMING FROM NR 2 PROPELLER AFT OF THE SPINNER. NO VIBRATION AND PROP HEAT INDICATED NORMAL. FOUND RT PROPELLER NR 4 BLADE HEATER MAT BURNED. R & R NR 4 BLADE IAW 61-10-07.SDR HNAA2012122801134Socket · damagedCENTER ISLE LIGHT AT 1DF STARTS TO SMOKE. CIRCUIT BREAKERS S1, S2 AND R2 WERE PULLED AND COLLARED.SDR HNAA2012122801133Hmu · malfunctionedFUEL ODOR IN CABIN OFF ENGINE BLEEDS, SUSPECT NR 2 BLEED. R & R NR 2 ENGINE HMU AND FUEL PUMP IAW WC 73-20-01R AND 76-00-01Q. GROUND RAN, OPS CHECKED GOOD.SDR HNAA2012121701132B-Nut · leakingNOTICED NR 1 HYD FLUID QTY DECREASING IN FLIGHT. NR 1 HYD QTY AT 1.25 AFTER LANDING. FOUND B-NUTS ON NR 1 RESERVOIR LOOSE. VERIFIED ALL CONNECTIONS SECURE, IN NR 1 NAC. CLEANED TIRE, AND NAC OF RESIDUAL HYD FLUID. CKED EPA DRAINS FOR FLUID. NONE FOUND. CYCLSDR HNAA2012122701131Control Box · malfunctionedMASTER WARNING CHECK, FIRE DETECTION LIGHT ILLUMINATED INFLT FOR APPROX 2 MINUTES. NO OTHER INDICATIONS OF FIRE, SMOKE, OR OTHER ADV LIGHTS. R & R WARNING LIGHT CONTROL BOX AND WARNING LIGHT PANEL IAW MM 33-18-00 AND CHECKED GOOD.SDR HNAA2012122401130Brush Block · malfunctionedEMERGENCY FLOOR LIGHT FLICKER DURING CLIMB OUT WITH ASSOCIATED WARNINGS. NR 2 AC GENERATOR VOLTS DROP ON "B" PHASE. INSPECTED NR 2 PROP R & R BRUSH BLOCK AND OPS CHECKED IAW RUN UP MANUAL. OPS CHECKED GOOD.SDR HNAA2012122401129Bulb · looseLOWER EXIT SIGN LIGHTS ARE DIM AT LT EMERGENCY EXIT AND PAX DOOR. R & R LOWER EXIT SIGN LIGHT BULBS AT LT EMERGENCY EXIT AND PAX DOOR. RESECURED LENS. OPS CHECKED GOOD.SDR HNAA2012122101128Frame · corrodedCORROSION FOUND ON FORWARD SPAR FRAME AT STR 33P, RT SIDE OF CENTER. BLENDED CORROSION IAW RD 8-53-12757. COMPLIED WITH EDDY CURRENT INSPECTION. NO DEFECTS NOTED.SDR HNAA2012122101126Control Box · unknownEMERGENCY LIGHTS ILLUMINATED ON GROUND, CYCLED SWITCH, LIGHTS WENT OUT. R & R EMERGENCY LIGHTS CONTROL BOX IAW WC 33-50-03Q. OPS CHECKED GOOD. CLEANED CONNECTOR PLUG ON EMERGENCY LIGHTS CONTROL BOX. OPS CHECKED GOOD. NO DEFECTS FOUND.SDR HNAA2012122101125Spar · corrodedCORROSION FOUND ON FORWARD SPAR MAIN FRAME BETWEEN STR 31S AND 32S ON FORWARD SIDE. BLENDED CORROSION IAW RD8-53-12757. COMPLIED WITH EDDY CURRENT INSPECTION. NO CRACKS NOTED AT THIS TIME.SDR HNAA2012122101124Bulb · failedFORWARD MOST FLOOR PATH EMERGENCY LIGHT IS INOPERATIVE. R & R BULB, OPS CHECKED GOOD. REINSTALLED FLOOR COVER.SDR HNAA2012121901123Bracket · corrodedCORROSION AT BRACKET WHERE STR 32P IS ATTACHED TO MAIN FRAME AT STA X387. CORROSION FOUND TO BE MINOR AND ON SURFACE ONLY. REMOVED CORROSION, ALODINED AND PRIMED AREA IAW SRM 51-20-11, 51-20-16 AND 51-20-36.SDR HNAA2012121901122Threshold · corrodedCORROSION ON AIRSTAIR DOOR OPENING THRESHOLD AT NUT PLATES AND DOOR SEAL HOLE. CLEANED MINOR COROSION OF THRESHOLD AS REQUIRED. ALODINED AND PRIMED BARE METAL.SDR HNAA2012121901121Frame · crackedFRAME LEG CRACKED AT BS 252.3 AND STR 31S. CRACK IS AT MOST OTBD RIVET. CUT FRAME LEG OFF FRAME. REPAIRED FRAME LEG IAW SRM 53-20-21.SDR HNAA2012121901120Stringer · corrodedBELLY SKIN BOWED OUT BETWEEN RIVETS. SUSPECT CORROSION ON SEVERAL STRINGERS. BOND TESTED BELLY SKIN. NO DISBOND NOTED. REMOVED RIVETS TO CHECK, REINSTALLED RIVETS IAW ACFT DWG 85332724.SDR HNAA2012121901119Seat Track · corrodedRT SIDE OF RT CENTER SEAT TRACK HAS SIGNS OF CORROSION FOUND. CORROSION MINOR. CLEANED SURFACE, ALODINED AND PRIMED AREA IAW SRM 51-20-11, 51-20-16 AND 51-20-36.SDR HNAA2012121901118Clamp · corrodedLAVATORY FLOOR DRAIN LOWER HOSE CLAMP CORRODED. FOUND SMALL SECTION OF CLAMP CORRODED. CLEANED AS REQUIRED.SDR HNAA2012121901117Seat Track · corrodedRT CENTER SEAT TRACK HAS PITTING CORROSION AROUND BOLT HOLES. REPAIRED PITTING CORROSION AROUND BOLT HOLES IAW RD8-53-4698. PERFROMED EDDY CURRENT INSPECTION AND NO DEFECTS NOTED.SDR HNAA2012121901116Frame · corrodedCORROSION ON FRAME BS 405, BETWEEN STR 31 AND 32S. CORROSION WAS FOUND TO BE MINOR SURFACE SORROSION. CLEANED AREA, REMOVED MINOR CORROSION, ALODINED AND PRIMED AREA IAW SRM 51-20-11, 51-20-16 AND 51-20-36.SDR HNAA2012121901115Controller · intermittentEMERGENCY LIGHTS FLICKER WITH NR 2 PROP A PHASE ACTIVE. R & R EMERGENCY CONTROL BOX IAW -8 MM 33-51-00. GROUND RAN ACFT. OPS CHECKED GOOD.SDR HNAA2012121901114Relay · failedLEFT FRONT WINDSHIELD HEAT IN NORM IS INOPERATIVE. OHMED WINDSHIELD, CHECKED GOOD. SLAVED IN CONTROLLER, NO FIX. REINSTALLED ORIGINAL. R & R RELAY 3041-K6, NO FIX. R & R RELAYS 3041-K4 AND K9. OPERATED WINDSHIELD HEAT. OPS CHECKED GOOD AT THIS TIME.SDR HNAA2012121801112Frame · corrodedPAX DOOR SKIN CENTER LINE FRAME CORRODED AT INBD SIDE. REPLACED PAX DOOR STRUCTURE ASSY WITH NEW.SDR HNAA2012121801110Angle · corrodedPAX DOOR STOP ASSY INBD LOWER AFT ANGLE IS CORRODED. R & R INBD LOWER AFT ANGLE IAW DWG 8Z3623.SDR HNAA2012121801113Stringer · corrodedCORROSION ON STRINGER 26S. CLEANED MINOR CORROSION OFF STRINGER 26S ALODINED AND PRIMED BARE METAL.SDR HNAA2012121801111Skin · crackedNR 1 AFT PRESSURE STOP DOUBLER ON PAX DOOR SKIN IS CRACKED UNDER FITTING. REMOVED CRACKED DOUBLER ANGLE. FABRICATED NEW DOUBLER ANGLE IAW DWG 85210283. INSTALLED DOUBLER ANGLE IAW DWG 85210003.SDR HNAA2012121801109Bracket · corroded"L" BRACKET HAS MINOR CORROSION AT BS 597, LT SIDE. REMOVED MINOR SURFACE CORROSION FROM "L" BRACKET IAW SRM 51-20-11. ALODINED AND PRIMED BARE METAL AS REQUIRED.SDR HNAA2012121801108Skin · debondedSKIN DEBONDED AT STRINGER 31P AT BS 500. REMOVED AREA OF SKIN. BLENDED AREA OF LIGHT CORROSION ON WAFFLE DOUBLER ON STR 31P IN THIS AREA. REPAIRED IAW EO 8-53-12-0499.SDR HNAA2012121701107Structure · crackedUNDER PANEL 261FT, SHEET METAL STRUCTURE IS CRACKED EMINATING FROM RIVET HEAD. REPAIRED SHEET METAL STRUCTURE IAW EA 16-2012-026 AND EO 8 5312 0500.SDR CA121219002Case · fractured(CAN) AFTER LANDING, FLIGHT CREW NOTICED A RAPID DROP OF THE HYDRAULIC NR 2 SYS FLUID. ACFT TAXIED TO THE GATE WITHOUT FURTHER INCIDENT. MAINTENANCE FOUND THE LT OTBD ROLL SPOILER ACTUATOR CASING FRACTURED. THE ACTUATOR WAS REPLACED, TESTED AND THE ACFT RELESDR HNAA2012121401106Switch · brokenCOCKPIT EMERGENCY LIGHT SWITCH BROKEN. R & R SWITCH. OPS CHECKED GOOD.SDR HNAA2012121401105Bulb · failedF/A PANEL EMERGENCY SWITCH BACKLIGHTING IS INOPERATIVE. R & R BULB.SDR HNAA2012121401103Battery · dischargedF/A LEFT EMERGENCY LIGHT SWITCH IN ON POSITION, WITH ALL EMERGENCY LIGHTS NOW INOPERATIVE, BATTERIES DEAD. R & R EMERGENCY LIGHT BATTERIES IAW WC 33-50-05R. OPS CHECKED GOOD.SDR HNAA2012121201102Monitor · failedSECONDARY BUSS REMAINS POWERED WITH ONLY BATTERIES SELECTED ON. R & R POWER MONITOR. R & R RELAY 2431-K16. OPS CHECKED GOOD AT THIS TIME.SDR HNAA2012121201101Connector · dirtyNR 1 DC GENERATOR FAILED IN FLIGHT. CREW FOLLOWED CHECKLIST AND GENERATOR FAILED AGAIN. CLEANED WING ROOT CONNECTION, 2431-TB3. CLEANED GROUND AT T.1 CURRENT TRANSFORMER AND CONNECTORS AT AUX AND MAIN BATTERIES USING STANDARD MAINTENANCE PRACTICES. OPS CHECSDR HNAA2012121201100Bulb · failedDRIFT WALL NEAR F/A SEAT HAS 2 EMERGENCY LIGHTS INOPERATIVE. REMOVED LENS, R & R 2 BULBS. REINSTALLED LENS. OPS CHECKED GOOD.SDR HNAA2012121001099Pressure Switch · malfunctionedNR 2 ENGINE HYD PUMP CAUTION LIGHT ILLUMINATED IN FLIGHT AND REMAINED ON FOR 10 MINUTES. NO LOST OF PSI. NO FLUID LOSS AND NO ASSOCIATED CAUTION LIGHTS. R & R NR 2 EDP LOW PRESSURE SWITCH IAW AMM 291031 ACTUATED SYS. LEAK AND OPS CHECKED GOOD.SDR HNAA2012121001096Master Switch · failedDC BUSS FAULT ON NR 2 ENG S/D ASSOCIATED W/15 VOLTS. AFTER GPU HOOKUP NR 2 GEN SHOWED LOAD OF 1.15. R & R BATTERY MASTER SWITCH 2431 S7, USING STD MX PRACTICES. OPS CHECK GOOD AT THIS TIME.SDR HNAA2012121001097Actuator · leakingNR 1 HYD QTY DROPPED DURING TAXI. R & R RT INBD ACTUATOR FOR ROLL SPOILER. OPS AND LEAK CHECKED, OK REF MM 27-14-05. REMOVED AND REINSTALLED WING PANEL 632CB AND 632DT.SDR HNAA2012121001095Unknown · unknownNR 2 PROPELLER A PHASE CAUSES EMERGENCY LIGHTS TO FLICKER AT 1050. INSPECTED BRUSH BLOCK AND NR 2 PROP HEATER BLADE WIRING. GROUND RAN ACFT WITH NO DEFECTS NOTED AT THIS TIME.SDR HNAA2012121001094Terminal · looseCAPTAIN'S WINDSHIELD HEAT INOPERATIVE. REPLACED LOOSE RING TERMINAL ON TERMINAL "B", PRIMARY HEAT ELEMENT AND ALTERNATE HEAT ELEMENT OHM`D OUT NORMALLY. GROUND RAN ACFT WITH CREW AND OPS CHECKED GOOD.SDR HNAA2012121001093Controller · inoperativeCAPTAIN`S WINDSHIELD HEAT INOPERATIVE. NO LOADS AND COLD TO THE TOUCH. REMOVED AND REPLACED CAPTAIN'S WINDSHIELD HEAT CONTROLER (P3) IAW 30-41-00. GROUND OPS CHECKED GOOD.
Back to Boeing DHC-8-102