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 3PRA2011091100001Skin · dentedLOWER EXTERNAL SKIN IN ZONE 131 HAS MULTIPLE NICKS AND DENTS. BS 370 TO 424. REPAIRED LOWER SKIN IAW RD 8-53-12013.SDR CA110912003Manifold · failed(CAN) MTC CONTROL ADVISED DISPATCH THAT 815 HAD LOST NR 1 HYDRAULIC SYSTEM (LOSS OF FLAPS AND BRAKES). CREW DECLARED AN EMERGENCY WITH ATC AND ARFF WAS MEETING FLIGHT ON TOUCHDOWN. TOW CREW ARRANGED TO TOW ACFT TO GATE. FLIGHT LANDED WITHOUT INCIDENT AT 1957Z.SDR CA110908007Spring Assy · damaged(CAN) LIGHTNING STRIKE ON DESCENT, AT ABOUT 5000`. FOUND EXIT DAMAGE ON RT ELEVATOR SPRING TAB. HOLES BURNED THROUGH TOP AND BOTTOM SKIN AS WELL AS A PIECE BURNED FROM THE T/E. SPRING TAB WAS REPLACED.SDR HNAA2011091100279Failsafe · failedRT FWD MAIN GEAR DOOR WILL NOT CLOSED AFTER GEAR RETRACTION. R & R FAIL-SAFE PLATE, BELL CRANK LEVER TUBE HINGE PIN IAW MM 32-10-21 AND PERFORMED ALTERNATE EXTENSION IAW MM 32-35-00.SDR HNAA2011091100278Battery · failedNR 2 FWD FLOOR PATH LIGHTS INOPERATIVE. R & R EMERGENCY LIGHT BATTERY IAW AMM 33-51-00.SDR HNAA2011091100275Indicator · stuckRADAR STUCK IN STANDBY MODE AND WILL NOT CLEAR. R & R RADAR INDICATOR AND OPS CHECKED GOOD.SDR HNAA2011091100277Current Limiter · inoperativeLEFT SECONDARY BUSS INDICATES LOW VOLTAGE AND VOLTAGE REDUCES WHEN ITEMS ARE TURNED ON. OK WITH APU POWER. R & R CURRENT LIMITER F1, GROUND RUN, CHECKED GOOD.SDR HNAA2011091100274Bulb · burned outEMERGENCY PATH LIGHTING AT ROWS 4DF AND 7DF NOT WORKING. R & R EMERGENCY LOWER LEVEL FLOOR LIGHT BULBS IN ROWS 4DF AND 7DF.SDR HNAA11091100274AFuel Cap · unsecureAFTER LIFTOFF, CREW NOTICED WING FUEL CAP LIFTING UP. RETURN TO FIELD. INSPECTED LT WING FUEL CAP AND UPPER WING SURFACE. NO DEFECTS NOTED. R & R FUEL CAP AS PRECAUTION. CLEANED UP EXCESSIVE FUEL. OK FOR SERVICE.SDR 3S8R201109020006Frame · crackedNLG WHEEL WELL FRAME CRACKED AT Z112.000 AND X110.000, RT OF CTR LINE (GEAR RELEASE CABLE HOLE). CUT OUT DAMAGE AND INSTALLED REPAIR PARTS IAW DHC8102 RD 8-53-7878 AND 11973.SDR 3S8R201109020005Support Angle · crackedRT UPPER T-DUCT SUPPORT ANGLE CRACKED. REPLACED ANGLE IAW DHC8102 SRM 51-42-05 AND AC43, 13-1B, PAGE 4-22, PAR 4-57.SDR 3S8R201109020004Support Angle · crackedLEFT UPPER T-DUCT SUPPORT ANGLE CRACKED. REPLACED ANGLE IAW DHC8102, SRM 51-42-05 AND AC43,13-1B, PAGE 4-22, PAR 4-57.SDR 3S8R201109020003Doubler · cracked419CT HAS CRACKED DOUBLER AT POINT OF FINGERNAIL. REPLACED DOUBLER IAW SRM 51-42-05.SDR 3S8R201109020002Rib · cracked429CT FITTING CRACKED ON FINGERNAIL. REPLACED FITTING IAW SRM 54-78-11 AND 51-40-00.SDR HNAA2011090100270Battery Pack · failedEMERGENCY LIGHT ON FUSELAGE INOPERATIVE. R & R ROW 3 LT EMERGENCY BATTERY AT PS3 IAW AMM 33-52-20.SDR CA110905002Tube · fractured(CAN) AFTER LANDING , THE LOW OIL PRESSURE WARNING CAME ON AND AN OIL LEAK COULD BE SEEN FROM THE ENGINE. IT WAS SHUTDOWN IMMEDIATELY. INSPECTION FOUND A FRACTURED OIL TUBE TO NR 6 AND 7 BEARING HOUSING AND THE ENGINE APPEARS TO HAVE SEIZED.SDR HNAA2011090100268Attach Bracket · brokenAT 80 KNOTS, CREW EXPERIENCED AILERON CONTROL ANOMOLIES. EXCESSIVE FORCE HAD TO BE USED TO CTR RT TURN POSITION. AFTER ABORT SITTING, STATIC CONTROLS FELL NORMAL. FOUND RT TAB ATTACH BRACKET BROKEN AND HANGING FROM TAB. INSPECTED ACFT IAW 05-50-61 AND FOUNSDR CA110830012Pulley · seized(CAN) WHILE INVESTIGATING A DEFECT FOR THE LT MLG FWD DOOR NOT CLOSING AFTER GEAR RETRACTION, THE ACFT WAS PLACED ON JACKS. DURING THE TROUBLESHOOTING OF THE DEFECT, AN ALTERNATE GEAR EXTENSION WAS CARRIED OUT. DURING THE ALTERNATE GEAR EXTENSION THE LT MLG SDR HNAA2011090100267Socket · crackedDURING TAXI, ELECTRIC SMELL IN CABIN AND FLIGHT DECK. OVERHEAD LIGHTS AND C/B'S ARE ACTIVATED. FOUND OVERHEAD POWER STRIP FIXED, END SOCKET CRACKED. R & R LIGHT STRIP AT ROW 2DF. OPS CHECKED GOOD. CABIN INTERIOR NORMAL LIGHTING SYS, COMPLIED WITH SPECIAL SDR HNAA2011090100272Power Supply · failedAFT EMERGENCY EGRESS LIGHT INOPERATIVE ON LT SIDE OF FUSELAGE. R & R EMERGENCY LIGHTS POWER SUPPLY AT BASE PS3 LOCATION. OPS CHECKED GOOD.SDR HNAA2011090100271Light · failedROW 5 EMERGENCY FLOOR PATH LIGHT INOPERATIVE. R & R EMERGENCY FLOOR PATH LIGHT AT ROW 5. OPS CHECKED GOOD.SDR HNAA2011090100269Power Supply · failedLAST EMERGENCY CEILING LIGHT IS INOPERATIVE. R & R EMERGENCY LIGHTS POWER SUPPLY BASE AT A3 LOCATION, OPS CHECKED GOOD.SDR HNAA2011091900284Floor Support · corrodedAREA OF CORROSION AT STRINGER 23 FLOOR LEVEL FROM ROW 7DF TO ROW 9DF, X456.500 TO X531.500. POLISHED CORRODED AREA, INSPECTED AND FOUND NO FURTHER DEFECTS. CLEANED, ALODINED AND PRIMED AREA IAW AMM 51-25-03.SDR HNAA2011091900283Floor Support · corrodedSLIGHT CORROSION ON STRINGER 23 (FLOOR LEVEL) AT ROW 5DF. POLISHED CORRODED AREA, INSPECTED AND FOUND NO FURTHER DEFECTS. CLEANED, ALODINED AND PRIMED IAW 61-25-03.SDR HNAA2011090100265Lamp · inoperativeROW 4 WALL EMERGENCY LIGHTS ARE INOPERATIVE. RELAMPED ROW 4 SIDEWALL EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR HNAA2011090100264Pcu · failedON CLIMB OUT, NR 2 NP REACHED 1245 AND DROPPED TO 1236, THEN CREW RETARDED TO 1050 AND RETURNED TO FIELD. PROP OVERSPEED WITHIN LIMITS OF MM 61-10-00. R & R NR 2 PCU IAW WC 61-10-10. OPS CHECKED GOOD.SDR CA110822009Coffeemaker · shorted(CAN) IN CRUISE, THE F/A RECEIVED A LIGHT ELECTRICAL SHOCK WHEN ATTEMPTING TO TURN THE LT COFFEEMAKER ON. CREW REPORTED THAT THE ON/OFF SWITCH WAS COVERED WITH STEAM. THE LT COFFEEMAKER HAS BEEN DEFERRED IAW MEL 25-20-01 CATEGORY AND THE ACFT RETURNED INTO SSDR CA110825001Actuator · failed(CAN) ACFT EXPERIENCED A ROLL SPOILER THAT FAILED TO EXTEND. ADDITIONALLY, THERE WAS A LOSS OF HYD FLUID. INVESTIGATION REVEALED ROLL SPOILER ACTUATOR PISTON CAP SEPARATION. ACTUATOR WAS REPLACED AND FUNCTION CHECK ACCOMPLISHED.SDR HNAA2011090100262Power Supply · failedF/A EMERGENCY LIGHT SWITCH IS INOPERATIVE. R & R F/A PANEL EMERGENCY LIGHT SWITCH, NO FIX. R & R POWER SUPPLY AT PS1, OPS CHECKED GOOD. OK FOR SERVICE IAW WIRING MANUAL 33-51-01.SDR HNAA2011081700261Bulb · failedEMERGENCY WALKWAY BULB INOP AT ROW 1, MOST FORWARD BULB. RELAMP EMERGENCY FLOOR LIGHT. OPS CHECKED GOOD.SDR HNAA2011081700258Electronic Unit · failedAUTOFEATHER ARM LIGHT REMAINED ILLUMINATED INFLIGHT UNTIL TORQUE REDUCED BELOW 80 PERCENT, NR 1 TORQUE INDICATOR ERRATIC AND STICKS. R & R TSEU USING RETAINED HARDWARE AND RESECURED ALL CONNECTOR PLUGS AND BONDING WIRE. GROUND RAN ACFT WITH OPS CHECKS. OPS CHSDR HNAA2011081700255Engine · odorSTRONG BURNING ODOR IN COCKPIT DURNING APPROACH AND AFTER LANDING, ONLY WHEN BLEEDS ARE ON. R & R NR 2 ENGINE ASSY IAW WORK CARD 71-00-01R AND 71-00-02X.SDR HNAA2011081700254Unknown · odorSTRONG ODOR IN COCKPIT IN FLIGHT. CYCLED BLEEDS OFF, NO DIFFERENCE NOTED (NO ODOR IN CABIN). INSPECTED ACFT FOR ODORS, NONE FOUND. INSPECTED AVIONICS RACK, TRU'S AND INVERTERS DURING ENGINE RUNS. NO ODORS NOTED. ACFT OK FOR SERVICE.SDR CA110811001Computer · malfunctionedON DEPARTURE THE CREW REPORTED THAT THE NR1 AHRS (ATTITUDE HEADING REFERENCE SYSTEM) WAS OFF BY 10 DEGREES, THEN A MOMENT LATER REPORTED THAT THE NR 2 AHRS WAS DOING THE SAME. ACFT RETURNING TO DEPARTURE. NR 1 AHRS COMPONENT REPLACED. SYSTEM GROUND CHECKED SSDR HNAA2011081200248Warning Light · illuminatedPAX DOOR WARNING LIGHT ON IN FLIGHT. ENTRY DOOR INDICATION W/MOD APPENDEX 5. COMPLIED WITH. CIRCUIT BREAKER B/4 PULLED FOR FLIGHT OPS. PUSHED IN AFTER LANDING.SDR HNAA2011081200247Lamp · burnedEMERGENCY FLOOR LAMP AT ROW 7DF IN INOP. R & R LIGHT BULB IAW 33-52-00.SDR HNAA2011081700251Bracket · corrodedPAX DOOR STAIR ASSY VERTICAL SUPPORT, FORWARD OTBD AND INBD BRACKET HAS CORROSION ON IT. REMOVED BOTH BRACKETS, INSTALLED NEW BRACKETS IAW DWG 85210004.SDR HNAA2011081200246Pump · failedNR 2 STANDBY HYD PUMP HOT CAUTION LIGHT ILLUMINATED, FOLLOWED THEN BY STANDBY PUMP CIRCUIT BREAKER POPPED. SWAP OVER TEMP SENSOR TO SPARE. NO FIX. SWAP BACK TO ORIGINAL POSITION. R & R NR2 STANDBY PUMP IAW 29-11-17. LEAKED AND OPS CHECKED GOOD.SDR HNAA2011081100245Computer · failedSTICK SHAKER ACTIVATED IN FLIGHT, CREW DISCONNECTED BOTH YOKES TO DISENGAGE SYS FOR LANDING. R & R STALL WARNING COMPUTER AND CALIBRATED BOTH NR1 AND NR2 STALL WARNING SYSTEMS IAW DASH 8, MM 27-31-00. OPS CHECKED GOOD.SDR HNAA2011080500235Bulb · failedEMERGENCY FLOOR EGRESS LIGHT 2ND FROM THE FRONT IS INOP. R & R LAMP IAW 33-52-00.SDR HNAA2011080500234Bulb · failedRT EMERGENCY EXIT LIGHT OVER DOOR HAS BULB INOP. R & R BULB, OPS CHECKED GOOD.SDR HNAA2011080500230Brake Assy · overheatedNR 3 AND NR 4 BRAKE ASSY OVERHEATED AND CAUGHT FIRE DURING TAXI CHECK. R & R NR3 AND NR4 BRAKE ASSY IAW WORKCARD 32-42-11X.SDR HNAA2011080500229Brake Assy · fireNR 3 AND NR 4 MAIN WHEEL ASSY OVERHEATED. CAUGHT ON FIRE. R & R NR 3 AND NR 4 MAIN WHEEL ASSY IAW 32-10-03I.SDR HNAA2011080500233Unknown · odorACFT ESPECIALLY AFT AREA SMELLS LIKE BURNING PLASTIC IN FLIGHT. INSPECTED SIDEWALL AND OVERHEAD LIGHTING, NO DEFECTS NOTED. OK FOR SERVICE.SDR HNAA2011080500231Reservoir · leakingAFTER TAKEOFF NR 2 HYD QUANITY DROPPED AND NR 2 RUDDER ISO CAUTION LIGHT ILLUMINATED FOLLOWED BY NR2 HYD PUMP CAUTION LIGHT. QUANITY ON THE GROUND IS O. R & R NR 2 HYD RESERVOIR IAW MM 29-10-26. R & R NR2 ENGINE DRIVEN PUMP IAW MM 29-10-11. BLED AND SERVERSDR HNAA2011080500228Battery · failedWITH POWER OFF, OVERHEAD EMERGENCY LIGHT AT ROW 11 AND ONE EXTERIOR LIGHT ON RT FUSELAGE ILLUMINATED. ALL OTHER LIGHTS ARE OFF. R & R POWER SUPPLY FOR EMERGENCY BATTERY PS4. OPS CHECKED GOOD IAW AMM 33-51-05.SDR CA110803023Terminal Block · corrodedDURING CRUISE FLIGHT AT FL 210, THE CABIN PRESSURE WARNING LIGHT CAME ON AND THE CABIN CONTINUED TO CLIMB TO 11,000 ON ITS OWN. THE CREW HAD NO CONTROL IN AUTO OR MANUAL. THE ACFT DIVERTED. DURING DESCENT THE PRESSURIZATION SYS BEGAN WORKING NORMALLY AGAIN.SDR CA110803020Line · leakingON CLIMB OUT, CREW HAD A LOSS OF THE NR 1 HYD SYS. FLIGHT CONTINUED TO DESTINATION WHERE AN EMERGENCY WAS DECLARED DUE TO NO BRAKE OR STEERING. ACFT LANDED UNEVENTFULLY. MX FOUND A PIN HOLE IN THE NR 1 HYD SYS PRESSURE LINE (PN 82974010-119) (IPC 29-10-00, FSDR HNAA2011081700250Bracket · crackedFORWARD UPPER PAX DOOR SKIN TO STEP ATTACH POINT IS CRACKED ON STAIR ASSY. REMOVED OLD BRACKET. INSTALLED NEW BRACKET IAW DWG 85210004.SDR HNAA2011080500227Power Supply · failedTROUBLESHOOTING ROW 2 EMERGENCY FLOOR PATH LIGHTS INOPERATIVE. SLAVED NEW POWER SUPPLYS AND BATTERIES TO POSITION PS1, PS2, PS3 AND PS4. NO FIX. SLAVED FLIGHT COMPARTMENT SWITCH AND F/A SWITCH. NO FIX. R & R PS5 POWER SUPPLY AND SECURED WITH RETAINING HAR
Back to Boeing DHC-8-102