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 HNAA2013112200583Bulb · inoperativeMIDDLE O/H EMERGENCY LIGHT IS INOPERATIVE. R & R BULB, OPS CHECKED GOOD.SDR CA131120008Control Valve · faulty(CAN) AFTER LANDING THE CREW REPORTED THAT THE LT BRAKES SEEMED TO BE GLOWING AND THAT THE LT MAIN WHEELS WERE GOING FLAT. AT THE GATE, MAINTENANCE FOUND THE NR 2 MAIN WHEEL DEFLATED AND THE BRAKES VERY HOT. BOTH LT BRAKE UNITS AND WHEELS WERE REPLACED. AFTSDR HNAA2013112200582Relay · inoperativeCAPTAIN`S WINDSHIELD HEAT INOPERATIVE. R & R RELAY 3041-K9. OPS CHECKED GOOD.SDR HNAA2013111800581Gcu · warning lightNR 1 PROP DEICE A-PHASE SHOWS NO ADVISORY LIGHT OR LOAD. NR 1 AC GENERATOR A-PHASE SHOWS ONLY 86 VOLTS AND .06 LOAD WITH PROP HEAT SELECTED OFF AND 67 VOLTS WITH PROP HEAT SELECTED ON. R & R NR 1 AC GCU AND CURRENT LIMITER. GROUND RAN ACFT. OPS CHECKED GOODSDR CA131119002Arm · chafed(CAN) DURING ROUTINE INSPECTION THE RT MLG CENTER DOOR FWD HINGE ARM, PN 85420015-003 WAS FOUND WITH CHAFING WEAR BEYOND LIMITS. THERE ARE ALSO INDICATIONS THAT A CRACK MAY BE PRESENT. THE HINGE ARM WAS REPLACED. SDR IS BEING SUBMITTED AS WE HAD THIS, PN HINSDR CA131119001Arm · damaged(CAN) DURING ROUTINE INSPECTION THE RT MLG CENTER DOOR FWD HINGE ARM, PN 85420015-003 WAS FOUND WITH A DEEP NICK THAT WAS BEYOND LIMITS. THE HINGE ARM WAS REPLACED. RESULTING IN IN-FLIGHT LOSS OF THE DOOR.SDR CA131118022Control Panel · shorted(CAN) DURING THE DESCENT THROUGH 14,000 FEET TO THE DESTINATION AIRPORT THE CREW NOTICED A BURNING SMELL IN THE COCKPIT BUT NO NOTICEABLE SMOKE. THEY ACTIONED THEIR QRH AND TURNED THE ENGINE BLEED AIR OFF. THEY DONNED THEIR OXYGEN MASKS AND DECLARED AN EMERGENSDR HNAA2013111500575Actuator · leakingNLG UNSAFE LIGHT FLASHING INTERMITTENTLY WITH GEAR HANDLE, ACCOMPANIED BY NLG ATTEMPTING TO CYCLE. PERFORMED ALTERNATE EXTENSION AND RECEIVED THREE GREEN LIGHTS. PERFORMED NORMAL LANDING. CHECKED PSEU. FOUND NO CODES. CHECKED PROXIMITY SENSORS. FOUND GAPSDR HNAA2013111500574Unknown · odorEXHAUST ODOR IN COCKPIT. RAN BOTH ENGINES AND BLEEDS. RAN ALL DEICE SYSTEMS. CHECKED ALL CIRCUIT BREAKERS. CHECKED ALL AVIONICS SYSTEMS. ALL CHECKED GOOD. NO EVIDENCE OF SMOKE OR EXHAUST ODOR. ALL COCKPIT LIGHTING CHECKED GOOD.SDR HNAA2013111500573Unknown · odorELECTRICAL ODOR IN COCKPIT. RADAR CIRCUIT BREAKER FOUND TRIPPED WITH TERRAIN INOPERATIVE. CAUTION LIGHT AND MASTER CAUTION LIGHT ILLUMINATED. REMOVED RT NAV PANEL WITHOUT DISCONNECTING CONNECTOR, INSPECTED AREA. NO DEFECTS NOTED OR ODOR. REINSTALLED RT NAV SDR HNAA2013111300570Controller · failedLEFT WINDSHIELD HOT CAUTION LIGHT ILLUMINATED IN FLIGHT. R & R CAPTAIN'S WINDSHIELD HEAT CONTROLLER. OPS CHECKED GOOD ON GROUND RUN IAW MM 30-41-00.SDR CA140303016Isolation Valve · cracked(CAN) DURING SERVICING, MAINTENANCE FOUND RUDDER ISOLATION LEAKING. A HAIRLINE CRACK WAS FOUND ON THE BODY OF THE RUDDER ISOLATION VALVE.SDR HNAA2013111100569Snubber · failedUNABLE TO OPEN PAX DOOR FROM OUTSIDE. R & R PAX DOOR HANDLE SNUBBER IAW WC 52-10-00R. OPS CHECKED GOOD.SDR CA131111007Seal · leaking(CAN) AFTER TAKEOFF THE CREW OBSERVED THE RT ENGINE LOW OIL PRESSURE WARNING LIGHT ILLUMINATE. THE CREW FOLLOWED THEIR QRH AND SHUTDOWN THE RT ENGINE. THEY DECLARED AN EMERGENCY AND RETURNED TO THE DEPARTURE AIRPORT FOR AN UNEVENTFUL LANDING. CONTRACT MAINTESDR HNAA2013110800568Bulb · inoperativeEMERGENCY LIGHT IS INOPERATIVE AT ROW 7. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013110600567Battery · no testFLOOR LEVEL EMERGENCY LIGHTS WILL NOT ILLUMINATE DURING TEST. R & R ALL EMERGENCY LIGHT BATTERIES IAW WC 33-50-03Q. OPS CHECKED GOOD.SDR HNAA2013110600566Blade · vibrationNR 2 PROPELLER HAS EXCESSIVE VIBRATION IN FLIGHT. SHIMMED NR 3 AND NR 4 BLADES IAW MM 61-10-00. OPS CHECKED GOOD.SDR HNAA2013110600565Bulb · failedFOURTH RED EMERGENCY FLOOR LIGHT IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013110600564Bulb · dimLEFT FWD EXTERIOR EMERGENCY LIGHT IS DIM. R & R BULB . OPS CHECKED GOOD.SDR CA131108001Bearing · seized(CAN) THE CREW REPORTED THAT THE LT MLG FWD DOOR WAS OPEN A LITTLE IN FLIGHT, HOWEVER COCKPIT INDICATION WAS NORMAL. MAINTENANCE INVESTIGATION FOUND THE AFT HINGE BEARING ON THE LT MLG FWD DOOR SEIZED. THIS PREVENTED THE DOOR FROM FULLY CLOSING OR OPENING. ASDR HNAA2013110400563Transceiver · odorHOT ELECTRICAL ODOR FROM CAPTAINS SIDE OF GLARE SHIELD AROUND 801 PANEL. FOUND CAPTAINS NAV CONTROL HEAD INOPERATIVE. R & R NAV TRANCEIVER IAW MM 34-55-02. GROUND RAN ACFT. OPERATED WINDOW HEAT. NO DEFECTS NOTED. OK FOR SERVICE.SDR HNAA2013110400562Valve · failedLIGHT SMOKE IN FLIGHT DECK, CABIN AND BAG BAY IN FLIGHT AT 19,000 FT COMPLIED WITH UNKNOWN SMOKE CHECKLIST, RECIRCULATION FAN AND BLEEDS SELECTED OFF. AFTER BLEEDS OFF, SMOKE DISSIPATED. R & R AIR SWITCHING VALVE IAW MM 72-30-00. GROUND RAN ACFT WITH BLEEDSSDR HNAA2013110400561Transceiver · faultedRADAR INDICATOR DISPLAYS TEXT FAULT MESSAGE. R & R RADAR R/T IAW MM 34-41-04 AND SB 34-18. NO DEFECTS NOTED. OPS CHECKED GOOD.SDR HNAA2013110100560Bulb · malfunctionedFORWARD RT TOP EMERGENCY EXIT SIGN IS DIM. R & R BULBS AT RT TOP EMERGENCY EXIT SIGN. OPS CHECKED GOOD.SDR HNAA2013110100559Bulb · inoperativeEMERGENCY FLOOR PATH LIGHT IS INOPERATIVE AT ROW 3DF. R & R BULB AT ROW 3DF. OPS CHECKED GOOD.SDR HNAA2013110100557Bulb · inoperativeAFT OVERHEAD EMERGENCY LIGHT INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013110100556Plate · crackedLEFT WING LADDER PLATE IS CRACKED FOR ACCESS PANEL 522AT AT INBD FWD CORNER. REPAIRED LADDER PLATE IAW RD8-57-6203, RD8-57-2413 AND EO8-57-13-0616.SDR HNAA2013110100555Threshold · corrodedTOP SURFACE OF PAX DOOR THRESHOLD HAS CORROSION AROUND NUT PLACES. REMOVED PAX DOOR THRESHOLD AND REPLACED WITH NEW AND RUB STRIP IAW DWG 85321241.SDR HNAA2013110100554Seat Track · corrodedSEAT TRACK CORRODED. CUT AND SPLICED NEW SECTION OF SEAT TRACK AT BS 262 IAW RD8-53-3074. COMPLIED WITH HFEC INSPECTION. NO DEFECTS NOTED.SDR HNAA2013103000553Gauge · inaccurateNR 1 OIL PRESSURE GAUGE READS 68-69 AT CHARTED TORQUE. REMOVED TWO SHIMS FROM OIL PRESSURE REGULATOR AND REPLACED MAIN OIL FILTER. RAN ACFT AND OPS AND LEAKED CHECKED GOOD IAW MM 72-01-50 AND 72-00-00.SDR HNAA2013102800552Bulb · inoperativeFLOOR EMERGENCY ESCAPE PATH LIGHT HAS ONE BULB INOPERATIVE AT ROW 1. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013102500549Monitor · faultedNR 1 AC GENERATOR SHOWING NO VOLTAGE ON PHASE A OR B IN FLIGHT. FOUND ACFT POWER MONITOR AT FAULT. R & R ACFT POWER MONITOR. RAN ACFT, OPS CHECKED GOOD IAW MM 24-21-05.SDR HNAA2013102500548Relay · warning lightRIGHT BUSS CAUTION LIGHT CAME ON IN FLIGHT FOLLOWED BY RT TRU, RT ELEVATOR HORN HEAT AND RT STALL WARNING CAUTION LIGHTS. CYCLES BOTH GENERATOR SWITCHES, LIGHTS CLEARED. GROUND RAN ACFT AND COULD NOT DUPLICATE. R & R UNDER VOLTAGE RELAY FOR POSITIVE MAINTENSDR HNAA2013102500547Light · inoperativeEMERGENCY LIGHT IS INOPERATIVE AT ROW 1. R & R EMERGENCY LIGHT IAW AMM 33-51-00. OPS CHECKED GOOD.SDR HNAA2013102500546Bulb · malfunctionedEMERGENCY EXIT DOOR SIGN IS DIM. R & R EXIT SIGN BULBS. OPS CHECKED GOOD IAW AMM 33-51-00.SDR CA131022001Wire · chafed(CAN) DURING MAINTENANCE INSPECTION, 1 OF THE LT AC GENERATOR OUTPUT WIRES WAS FOUND CHAFED/SHORTING TO A FRAME NEAR THE LT AC CONTACTOR BOX CONNECTOR 2421-P29 NR 1 NACELLE. IT HAD BURNED A SIGNIFICANT NOTCH IN THE FRAME AT THE AREA OF CONTACT. A SEARCH OF TSDR HNAA2013102100542Bulb · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROWS 1 AND 3. R & R BULBS, OPS CHECKED GOOD.SDR HNAA2013102100541Display · failedWEATHER RADAR FAILED ENROUTE. TEXT MESSAGE APPEARED IN LOWER RT CORNER. R & R RADAR RT AND INDICATOR IAW 34-41-04 AND BULLETIN 34-18. OPS CHECKED GOOD ON GROUND. OK FOR SERVICE.SDR HNAA2013102100539Unknown · odorON APU BLEED START, STRONG FUEL ODOR ENTERED CABIN. NO LEAKS FOUND OR OBVIOUS DEFECTS. GROUND RAN ACFT WITH DOORS OPEN FOR 10 MINUTES AND CABIN ODOR CLEARED AT THIS TIME,SDR CA131018004Transfer Tube · leaking(CAN) IN CRUISE, FLIGHT CREW RECEIVED A STEADY NR 2 ENGINE OIL PRESSURE WARNING MESSAGE AND OBSERVED A FLUCTUATING OIL PRESSURE. THE ENGINE NR 2 PROPELLER WAS FEATHERED AND THE OIL PRESSURE DROPPED EVEN MORE. THE ENGINE WAS SHUTDOWN AND AN EMERGENCY WAS DECLSDR CA131016002Fuel Heater · loose(CAN) FUEL HEATER HAS AN ACCESS PORT INBD THAT IS NOT USED ON THIS INSTALL AND A LOOSE METAL SHIPPING PLUG HAS FOUND INSTALLED INSTEAD OF THE REQUIRED STEEL MS9902-04 PLUG LOCK WIRED IN PLACE. THE LOOSE PLUG ALLOWED FUEL TO LEAK INTO THE LOWER COWL AND OUT THSDR HNAA2013101100533Hose · kinkedF/O`S ASI READS HIGHER THAN CAPTAIN'S AFTER TAKEOFF AND FOR DURATION OF FLIGHT IAW CHECKLIST. SWITCHED TO ALT SOURCE. NO FIX, FOUND RT PITOT HOSE KINKED. REPLACED HOSE. LEAK CHECKED PITOT SYS. OPS CHECKED GOOD IAW MM 34-11-11 AND 34-11-02.SDR HNAA2013101000532Bulb · dimRT FORWARD EXTERIOR EMERGENCY LIGHT IS DIM. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013101000531Lamp · inoperativeONE RED FLOOR EMERGENCY LIGHT IS OUT AT ROW 5. REPLACED LAMP. OPS CHECKED GOOD. OK FOR SERVICE.SDR CA131011003Pulley · seized(CAN) DURING ROUTINE MAINTENANCE, IT WAS NOTICED THAT THE FORCE REQUIRE TO OPERATE THE MLG ALTERNATE RELEASE HANDLE WAS HIGHER THAN NORMAL. TROUBLESHOOTING REVEALED THAT THE LT MLG FWD DOOR ACTUATOR END PULLEY WAS SEIZED. THE PULLEY WAS REPLACED AND THE SYS TSDR CA131009004Control Unit · smoke(CAN) DURING APPROACH, CREW REPORTED SMOKE HAD BEEN DETECTED IN THE CABIN. THE ACFT LANDED SAFELY ABOUT 2 MINUTES LATER, THE PASSENGERS RAPIDLY DEPLANED. THE AIRLINE SAID ELECTRICAL WIRING OVERHEATED CAUSING THE SMOKE. OVERHEATED, RUNNING HOT, CA SWITCH PANELSDR HNAA2013100900530Bulb · inoperativeSEVERAL FLOOR EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED BULBS FROM FLOOR EMERGENCY LIGHT MODULES, RESECURED FLOOR TRIM. OPS CHECKED GOOD.SDR HNAA2013100900529Bulb · dimRT FORWARD EMERGENCY EXIT LIGHT IS DIM. R & R BULB. OPS CHECKED GOOD.SDR CA131009012Tscu · failed(CAN) DURING CLIMB, FLIGHT CREW REPORTED THAT THE NR 1 ENGINE TORQUE INDICATOR SURGED TO 152 PERCENT. AS THE FLIGHT CREW WAS EVALUATING THE SITUATION, THE NR 2 TORQUE STARTED TO FLUCTUATE. DECISION WAS TAKEN TO RETURN AND LAND. AN EMERGENCY WAS DECLARED AND TSDR HNAA2013100700528Lamp · inoperativeEMERGENCY EXIT DOOR PATH LIGHT IS INOPERATIVE AT ROW 6DF. R & R LAMP AT EMERGENCY EXIT FLOOR PATH LIGHT. OPS CHECKED GOOD.
Back to Boeing DHC-8-102