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 HNAA2009020700043Terminal Block · smokeSMOKE AND ODOR COMING FROM CAPTAIN WINDSCREEN TERMINAL BLOCK. R&R CAPTAIN WINDSCREEN IAW WORK CARD 56-00-00R, OPS CHECK GOOD.SDR CA090204010Line · brokenSHORTLY AFTER TAKEOFF, THE NR 1 ENG HYD PUMP CAUTION LIGHT ILLUMINATED AND NR 1 HYD QTY GAGE WENT TO ZERO. THE CREW DECLARED AN EMERGENCY AND RETURNED FOR A SAFE FLAPLESS LANDING. MAINTENANCE FOUND IN THE LEFT WHEEL WELL A BROKEN HYDRAULIC LINE. THE LINE ISSDR CA090203003Line · leakingSHORTLY AFTER TAKEOFF, NR 1 HYD SYS WAS LOST, AIR CREEBEC FLIGHT 921 DECLARED AN EMERGENCY AND TURN BACK TO YUL AIRPORT ACFT LANDED SAFELY AND WAS TOWED TO GATE FOR PASSENGER OFFLOAD. AFTER MAINTENANCE INSPECTION THEY FOUND THE NR 1 ENG DRIVEN PUMP CASE DRASDR HNAA2009012900033Light · inoperativeSECOND FLOOR EMERGENCY LIGHT INOP. R&R LAMP IAW AMM 33-25-00.SDR HNAA2009012800032Connector · dirtyWHILE CLIMBING OUT AFTER TAKE OFF, THE CREW NOTED THAT THE NR 2 ENGINE OIL PRESSURE WAS READING ONLY 45PSI WITH NO ASSOCIATED CAUTION INDICATORS. THE CREW THEN DECLARED AN EMERGENCY AND RETURNED TO THE ORIGINATING AIRFIELD. MX CHECKED THE ENGINE OIL LEVEL, ANSDR HNAA2009061700178Strap · corrodedUPPER AFT STRAP CHAFED ON RT FWD EMERGENCY EXIT AT STA X270 BETWEEN STRINGER 10S-11S. FABRICATE STRAP ON RT EMERGENCY EXIT IAW DHC DROWING 85320571.SDR CA090127006Pump · failedWHEN SPU`S WERE SELECTED OFF, HYDRAULIC PRESSURE WAS LOST ON THE NR 2 HYDRAULIC SYSTEM. ASSOCIATED "RUDDER PRESSURE", "NR 2 RUDDER HYDRAULIC" AND "RUDDER FULL PRESSURE" ILLUMINATED. RECTIFICATION, NR 2 HYDRAULIC ENGINE DRIVEN PUMP REPLACED, GROUND RUNS AND LSDR HNAA2009012700030Unknown · odorDURING WORK ON A DIFFERENT PROBLEM ON THE ACFT, THE FLIGHT ATTENDANT REPORTED AN ELECTRICAL ODOR IN THE AREA OF THE WARDROBE. MX INSPECTED THE AVIONICS COMPARTMENT AND THE WARDROBE AREAS AND FOUND NO SIGNS OF ELECTRICAL DEFECTS OR ODORS.SDR HNAA2009012700029Battery · dischargedDURING RON MX THE FIRST 2 EMERGENCY EXIT FLOOR LIGHTS IN THE PASSENGER CABIN WERE FOUND TO BE INOPERATIVE. THE EMERGENCY BATTERY LOCATED AT 3352/PS2 WAS CHANGED OUT. SYSTEM OPS CHECKED GOOD.SDR CA090126004Link · brokenWHILE CARRYING OUT LANDING GEAR RETRACTIONS, IT WAS FOUND THAT THE NOSE LANDING (NLG) WAS HUNG UP AT THE EXTENSION CYCLE. FURTHER INVESTIGATION REVEALED THAT THE NOSE LANDING (NLG) WAS NOT CENTERED AND THIS WAS PROBABLY CAUSED BY THE CENTERING SPRING NOT OVERSDR HNAA2009013000034Switch · failedWHILE ADVANCING THE POWER LEVERS TOWARD TAKE OFF POWER, THE NR 2 PROPELLER FEATHERED, THE AUXILIARY PUMP LIGHT ILLUMINATED AND THE PROP TORQUE SPIKED TO 100% FOR APPROXIMATELY 1 TO 2 SECONDS. THE TAKE OFF WAS ABORTED AND THE ACFT WAS RETURNED TO THE MX FACILISDR HNAA2009012200014Battery · dischargedFWD 2 MID CABIN CEILING LIGHTS ARE INOP. R&R EMERGENCY LIGHT BATTERY AT ROW 3 LT LOCATION IAW 33-51-00. OPS CHECK GOOD.SDR HNAA2009061700181Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT WARDROBE AT STA X16 BETWEEN STA 182 TO X223 AND Y32 BETWEEN STA X 182 TO X223. REMOVED AND REPLACED FLOOR SUPPORT AT STA YA6 BETWEEN STA X182 TO X223 AND Y 32 BETWEEN STA X182 TO 223. IAW STRUCTURE REPAIR MANUAL 51-40-00.SDR HNAA2009012200013Bulb · burned outEMERGENCY LIGHTING "NORM" BACK LIGHT INOP. INSTALLED NEW BULB IAW AMM 33-20-00. OPS CHECK GOOD.SDR HNAA2009012200012Lamp · burned out2ND FLOOR LEVEL EMERGENCY LIGHT INOP. R&R BULB IAW AMM 33-20-00. OPS CHECK GOOD.SDR CA090210014Indicator · malfunctionedPIREP NR 1 ENGINE FUEL FLOW INDICATOR ANALOG FLICKERING FOR APPROX 1 HOUR, WITH DIGITAL READ OUT SHOWING STEADY INDICATION. ACTION, FUEL FLOW GAUGE REPLACED WITH NEW. STRIP REPORT FROM SHOP, "FINDINGS: POINTER AND FDR OUTPUTS OSCILLATING, WORK PERFORMED. RESDR HNAA2009012000006Light · inoperativeDURING A LINE CHECK INTERIOR INSPECTION THERE WAS AN AFT CEILING EMERGENCY LIGHT INOPERATIVE.SDR HNAA2009061700182Seat Track · corrodedRT INBD SEAT RAIL FOUND CORRODED FROM STA X 182 TO X260. REMOVED AND REPLACED SEAL RAIL IAW MFG 85320490 AND EO8-53-09-3047.SDR HNAA2009011900008Warning Horn · false activationDURING TAKEOFF ROLL, THE TAKEOFF WARNING HORN BEGAN TO SOUND. THE TAKEOFF WAS ABORTED AND THE ACFT RETURNED TO GATE. MX POWERED DOWN THEN POWERED UP THE ACFT AND GROUND RAN THE ACFT TWICE. NO DEFECTS WERE NOTED AND THE ACFT WAS THEN RETURNED TO SERVICE.SDR HNAA2009012000398Lamp · inoperativeFORWARD CEILING EMERGENCY LIGHT WAS INOPERATIVE. RELAMPED.SDR HNAA2009061700180Panel · unknownALL WING STRESS PANEL NEEDS REWORK. REWORK PANEL IAW RD8-57-1420 AND RD857-1715.SDR HNAA2009012000002Unknown · odorBURNING ELECTRICAL ODOR IN COCKPIT. INSPECTED COCKPIT AREA, AVIONICS RACK AND RELAY PANEL IN WARDROBE CLOSET. GROUND RAN ACFT WITH ALL SYSTEMS. NO DEFECTS OR ODOR EVIDENT, OK FOR SERVICESDR CA090116002Windscreen · cracked(CAN) DURING FLIGHT ENROUTE TO YBC WHILE OVERHEAD YQB, THE CREW OBSERVED A CRACKED WINDSHIELD ABOUT 1/2 `` ON THE CAPTAIN SIDE. THE FLIGHT DIVERTED TO YQB FOR MX. MX REPLACED THE PILOT WINDSCREEN.SDR HNAA2009012000005Apu · smokeWITH AUXILIARY POWER UNIT RUNNING AND BLEEDS ON, SMOKE IN CABIN AND LAVATORY SMOKE DETECTOR SOUNDS. RAN AUXILIARY POWER UNIT WITH BLEED ON, VISIBLE HAZE APPEARS. INSP AUXILIARY POWER UNIT AREA NO DEFECTS NOTED. RAN ENGINES WITH BLEEDS NO HAZE NOTED. R&R AUXISDR CA090210013Indicator · failedPIREP, STANDBY ATTITUDE INDICATOR FAILED. MADE GRINDING NOISE THEN TOPPLED. WOULD NOT RE-ERECT. LIGHTS REMAINED POWERED AND FLAG NOT IN VIEW. STANDBY INDICATOR REPLACED AND FUNCTION TEST SERVICEABLE. STRIP REPORT FROM AVIONICS SHOP ON SN 12395 STBY ATT INSDR CA090119005Brake · leakingLEFT INBOARD BRAKE PACK LEAKING HYDRAULIC FLUID FROM ONE PISTON PUCK.SDR HNAA2009011200010Seat Track · corrodedDURING 'C' CHECK INSPECTIONS, THE RT FORWARD I/B SEAT RAIL WAS FOUND TO HAVE CORROSION MEASURING .020 DEEP. THE SEAT RAIL SECTION WAS REPLACED IAW DHC RD8-53-3074.SDR HNAA2009012000004Lens · brokenLOWER EMERGENCY LIGHT SIGN AT ROW 4 A AND C NEED RESECURED. R&R LIGHT ASSY.SDR CA090112012Control System · malfunctioned(CAN) AIRCRAFT AILERONS BINDING, MUST OVER CORRECT TO MOVE AILERONS, TO MUCH FORCE NEEDED. AILERON CONTROL SYSTEM ADJUSTMENT/TEST DONE IAW AMM 27-12-00. FUSELAGE AND WING CABLE TENSIONS FOUND TO BE HIGH, ADJUSTED AS PER FIG 201 SHEETS 344. 2. REPLACED RT AISDR HNAA2009011200389Light · inoperativeFWD EMERGENCY LIGHT IN INOPERATIVE ON THE CEILING. CYCLED EMERGENCY LIGHT POWER FWD EXIT LIGHT FUNCTION NORMAL. REPLACE (2) BURNED BULBS, IAW MM 33-51-00. OPS CHECK GOOD.SDR HNAA2009011200388Light · defectiveLT FWD EMRGENCY EGRESS LIGHT DIM. R&R EGRESS LIGHT BULB, IAW MM 33-51-00. OPS CHECK GOOD.SDR CA090112003Duct · contaminated(CAN) OIL ODOR AND SMOKE IN COCKPIT AND CABIN. RECTIFICATION TAKEN, ALL AIR CONDITIONING EQUIPMENT AND DUCTING REMOVED FROM AFT EQUIPMENT BAY. ALL EQUIPMENT AND DUCTING CLEANED OF ANY EXISTING OIL CONTAMINATION. EQUIPMENT AND DUCTING RE-INSTALLED AND FUNCTISDR HNAA2009011200395Ahrs · failedNR 2 ATTITUDE HEADING AND REFERENCE SYSTEM. R&R NR 2 ATTITUDE HEADING AND REFERENCE SYSTEM COMPUTER. OPS CHECK GOOD IAW MM 34-20-01.SDR CA090112013Pitot Head · inaccurate(CAN) AIRSPEED ON CAPTAIN SIDE 10KTS SLOWER THAN CO-PILOTS SIDE. RECTIFICATION, NR 1 PITOT HEAD REPLACED IAW AMM 34-11-00 AND NR 2 AIRSPEED INDICATOR REPLACED IAW AMM 34-11-31 PAGE 201. (TC 20090112013)SDR CA090109005Line · broken(CAN) AIRCRAFT TOOK OFF WITH NORMAL POWER. SHORTLY AFTER TAKEOFF NR 1 ENG TORQUE ROLLED BACK TO 45-50 PERCENT, ECU MANUAL ON OR OFF NO CHANGE. AIRCRAFT CONTINUED TO DESTINATION FOR NORMAL LANDING. MAINTENANCE INSPECTION FOUND `P3` LINE FAILED/BROKEN AT END SDR HNAA200901200394Pulley · wornABORTED TAKE-OFF DUE TO EXTREMELY STIFF AND HARD TO MOVE AILERONS. R&R SPOILER CABLE PULLEY ABOVE BAG BAY DOOR WHICH WERE FOUND TO BE GRINDING NOISE. CHECKED AILERON SPOILER CABLE TENSION IAW 27-12-00.SDR HNAA200911200393Bypass Switch · failedNR 1 FUEL FILTER BYPASS CAUTION LIGHT ILLUMINATED WHEN SETTING TAKE OFF POWER THEN EXTINGUISHED WHEN POWER REDUCED TO FLIGHT IDLE. R&R NR 1 HIGH PRESSURE FILTER AND BYPASS SWITCH. INSPECTED OLD FILTER NO DEBRIS FOUND. GROUND RUN ACFT OPS CHECK GOOD. LOW PRESDR HNAA200911200392Connector · dirtyNR 2 ENGINE OIL TEMPERATURE FLUCTUATES IN FLIGHT. CLEAN CONNECTOR PLUG, OPS CHECK GOOD.SDR HNAA2009011200390Battery · dischargedLT AFT EMERGENCY LIGHT EXTERIOR LIGHT INOPERATIVE. R&R EMERGENCY LIGHT BATTERY BASE AT 3351 PS3 AT ROW 3. IAW MM 33-51-00.SDR HNAA2009011200391Battery · dischargedEMERGENCY CEILING LIGHT INOPERATIVE IN ROW 1 AND ROW 7. R&R LIGHT BATTERY BASE AT 3351 PS3 AT ROW 3 IAW 33-51-00.SDR HNAA2009010800381Roller · damagedDURING TAKEOFF ROLL, THE AILERONS BECAME VERY STIFF AND HARD TO MOVE. THE TAKEOFF WAS ABORTED. THE ACFT WAS INSPECTED AND A FERRY PERMIT ISSUED TO RELOCATE TO A MX BASE WITH MORE EXTENSIVE FACILITIES. UPON FURTHER INVESTIGATION, THE SPOILER CABLE GUIDE ROLLERSSDR CA090112005Control Cable · out of rig(CAN) AILERON CONTROLS VERY STIFF (ARE LOCKING IN THE WINGS LEVEL POSITION). RECTIFICATION, AILERON CONTROL SYSTEM CABLES RIGGED IAW AMM 27-12-00-02. (TC NR 20090112005)SDR HNAA2009010300374Indicator · inoperativeWHILE ADVANCING POWER LEVERS FOR TAKEOFF, THE NR 1 ENGINE TORQUE GAUGE WAS FOUND TO BE INOPERATIVE. THE CIRCUIT BREAKER FOR THE GAUGE WAS FOUND TO BE POPPED. THE TAKEOFF WAS ABORTED AND THE ACFT WAS RETURNED TO THE GATE. MX CHANGED THE NR 1 ENGINE TORQUE INSDR HNAA2009010300375Resistor · blownRAMP PEOPLE ADVISED THAT POWER ON ACFT FLUCTUATED WHILE CLEANING ACFT AND THERE WAS BURNING SMELL. CONTRACT MX CONFIRMS SMELL IS FROM LT AUTOPILOT DISENGAGE LT AND AUTOPILOT DISENGAGE LT CIRCUIT BREAKER POPPED. FOUND RESISTOR ON AUTO PILOT DISENGAGE BOARD BLOWSDR HNAA2009010300370Light · inoperativeFLOOR EMERGENCY LIGHT INOPERATIVE AT 11TH 1 FROM THE FRONT. R&R RED LAMP MODULE, IAW MX MANUAL 20-45-07. OPS CHECK GOOD.SDR CA090112007Landing Gear · malfunctioned(CAN) ON DEPARTURE WHEN GEAR WAS SELECTED UP, THE LEFT GEAR DOOR OPEN LIGHT REMAINED ILLUMINATED. GEAR WAS SELECTED DOWN AND LEFT MAIN GEAR DID NOT LOCK DOWN. GEAR WAS CYCLED AGAIN AND IT DID NOT LOCK. GEAR WAS CYCLED UP AND ALL DOORS CLOSED. GEAR WAS SELESDR HNAA2009010300737Lens · defectiveMIDDLE RT EMERGENCY EXIT BETA LIGHT DID NOT PASS COMPARATOR TEST. R&R FROSTED LENS WITH CLEAR LENS IAW WORK CARD 33-50-02F. OPS CHECK GOODSDR HNAA2009010300372Lens · wrong partFWD RT EMERGENCY EXIT BETA LIGHT DID NOT PASS COMPARATOR TEST. REMOVED AND REPLACE FROSTED LENSE WITH CLEAR LENSE IAW WORK CARD 33-50-02F. OPS CHECK GOOD.SDR HNAA2009010300371Lens · wrong partMIDDLE LT EMERGENCY EXIT BETA LIGHT DID NOT PASS COMPARATOR TEST. REMOVED AND REPLACE IAW WORK CARD 33-50-02F REPLACED FROSTED LENSE WITH CLEAR LENSE COMPARATOR PASSED.SDR HNAA2000910700377Light · intermittentWHILE ACFT WAS ON THE GROUND, THE EMERGENCY LIGHTS WERE OBSERVED TO FLICKER INTERMITTENTLY. ACFT WAS RUN ON GROUND AND EMERGENCY LIGHTS WERE OPERATED, BUT THE PROBLEM COULD NOT BE DUPLICATED. NO HISTORY OF SIMILAR PROBLEMS WAS FOUND. ACFT WAS THEN RELEASED
Back to Boeing DHC-8-102