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 HNAA2009060100164Acm · malfunctionedUPON TAXI AT LGA, A BURNING SMELL IN THE FLIGHT DECK. A FERRY FLIGHT WAS ISSUED FOR THE PLANE TO RELOCATE TO ROA. IN ROA AN AIR CYCLE MACHINE (ACM) WAS REMOVED AND REPLACED, WITH NO FURTHER BURNING SMELLS IN THE FLIGHT DECK.SDR CA090526007Pedestal · corroded(CAN) 2 CORRODED LINES WERE FOUND IN THE CONICAL AREA. ONE ON THE RT SIDE FOR 50 PERCENT OF THE CIRCUMFERENCE AND ONE ON THE LT SIDE FOR 33 PERCENT OF THE CIRCUMFERENCE.SDR HNAA2009052800163Light · inoperativeEMERGENCY LIGHT IN FLOOR ESCAPE PATH LIGHT 3RD FROM FRONT. RELAMPED EMERGENCY LIGHT AT ROW 1 IN ESCAPE PATH LIGHT.SDR HNAA2009052800162Light · inoperativeLAST TWO EMERGENCY LIGHT AT ROW 8 AND 9 FLOOR LAMP INOP. REMOVED AND REPLACED LIGHT BULB.SDR HNAA2009052600161Fixture · burnedFLIGHT ATTENDANT REPORTS BURNING SMELL AND EYE IRRITANTS IN FORWARD PART OF CABIN. FLIGHT DECK AND AFT CABIN AREA OK. GROUND RAN AIRCRAFT NO SMELL NOTICED WITH ENGINE BLEEDS OR APU BLEEDS. INSP SIDEWALL AND OVERHEAD LIGHT FIXTURES. FOUND ONE BAD AT 5DF. RSDR HNAA2009052100156O-Ring · leakingNUMBER 2 ENGINE OIL PRESSURE WARNING LIGHT ILLUMINATED ON TAKEOFF ROLL. REMOVED AND REPLACED O-RING AT FUEL HEATER REDUCTION GEAR BOX OUT PRESS LINE. LEAK AND OPS GOOD.SDR HNAA20090221155Hmu · failedDURING CLIMBOUT, NUMBER 2 ENGINE WON'T GO ABOVE 80 PERCENT. REMOVED AND REPLACED NUMBER 2 HYDRO MECHANICAL UNIT IN ACCORDANCE WITH WORKCARD 73-20-01R. GROUND RAN AIRCRAFT. OPS CHECK GOOD.SDR HNAA2009052600160Fuel Heater · brokenIN FLIGHT THE NR 2 FUEL TANK TEMPERATURE WAS ABOVE RED LINE ON THE GAUGE. THE TEMPERATURE DROPPED WHEN PULLING POWER BACK OR SELECTING AUXILIARY PUMP. THERE WAS A REPORT OF SMELLING BURNT POPCORN IN THE CABIN AREA. WHEN 934HA WAS IN ROA THE FUEL/OIL WAS REMSDR HNAA2009051500154Inverter · burnedFISH ODOR IN COCKPIT. INSPECTED ALL INVERTERS, FOUND PRIMARY INVERTER TWICE AS HOT AS OTHER 2 (INVERTERS), REMOVED AND REPLACED TOP PRIMARY INVERTER. GROUND RAN ACFT, NO DEFECTS OR NEW ODOR NOTED, OPS CK'DSDR HNAA2009051500152Bulb · burned outEMERGENCY FLOOR ESCAPE PATH HAS 2 LAMPS INOP, CEILING EMERGENCY LIGHT IS VERY DIM ROW 5. REMOVED AND REPLACED LIGHT BULB.SDR HNAA2009051300144Bulb · burned outONE EMERGENCY ESCAPE PATH FLOOR LIGHT INOP. RELAMPED EMERGENCY LIGHT.SDR HNAA2009051300143Syncronizer · out of rigON TAKEOFF ROLL, NUMBER ONE PROPELLER INDICATED 1214. FOUND NUMBER ONE ENGINE OUT OF RIG. PERFORMED RIGGING WORK CARD 76-00-01. OPS CHECK GOOD. OK FOR SERVICE.SDR CA090513001Engine · seized(CAN) WHILE CLIMBING THROUGH 17,000 FT AFTER DEPARTURE, THE NR 2 ENGINE FAILED. THE CREW FELT A BANG FOLLOWED BY THE NR 2 OIL PRESS WARNING LIGHT COMING ON, THE NR 2 ITT WAS SEEN INCREASING RAPIDLY ABOVE 816 DEGREE C AS THE ITT INDICATOR LIGHT CAME ON, THE ENGSDR HNAA2009050100141Wire · burnedNR 2 STANDBY HYD PUMP C/B POPPED DURING TAXI. REMOVED AND REPLACED NR 2 STANDBY HYD PUMP, NO FIX. FOUND BURNT WIRES BELOW 2921-P5 CONNECTOR AND REPAIRED WIRING TO 2921P5 CONNECTOR, OPS CHECKED GOOD.SDR HNAA2009051300149Light · inoperativeEMERGENCY LIGHT INOP IN CEILING AT ROW 8. REPLAMPED CEILING LIGHT, OPS GOOD.SDR HNAA2009051300150Light · inoperativeONE EMERGENCY LIGHT INOP. REMOVED AND REPLACED BULB, OPS CHECK GOOD.SDR HNAA2009051300142Pseu · faultyUPON GEAR RETRACTION NOSE GEAR DOOR AMBER LIGHT ILLUMINATED CYCLED GEAR PER EMERGENCY CHECKLIST AND RED UNSAFE LIGHT ILLUMINATED WITH NO ALTERNATE INDICATION, PERFORMED ALTERNATE EXTENSION ALL INDICATIONS NORMAL. INSPECTED AND FOUND DRAG STAY PROX SWITCH FOR SDR HNAA2009051300152Light · inoperativeEMERGENCY FLOOR LIGHT IS INOPERATIVE LOCATED AT SEAT 7 DF. REMOVED AND REPLACED LIGHT BULB.SDR HNAA2009051300148Light · inoperativeOVERHEAD EMERGENCY EXIT SIGN AT ROW 1 HAS SEVERAL LIGHT INOP. REMOVED AND REPLACED LIGHT BULB.SDR HNAA2009050100140Light · inoperativeRED EMERGENCY FLOOR LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT BULB IN ACCORDANCE WITH 33-20-00.SDR HNAA2009042900139Pseu · false indicationUPON GEAR RETRACTION NOSE GEAR DOOR AMBER LIGHT ILLUMINATED. CYCLED GEAR PER EMERGENCY CHECKLIST AND RED UNSAFE LIGHT ILLUMINATED WITH NO ALTERNATE INDICATION. PERFORMED ALTERNATE EXTENSION ALL INDICATIONS NORMAL. FOUND PSEU TO HAVE NUMEROUS CODES TARGET 17SDR HNAA2009042900138Terminal · looseCAPTAINS SIDE WINDOW HEAT PRODUCES ELECTRICAL SMELL. FOUND WIRE TERMINAL END LOOSE (L2) ON CAPTAIN SIDE WINDOW TERMINAL BLOCK. REPLACED TERMINAL END AND TIGHTENED OPS CHECK WINDOW HEAT SYSTEM IN REFERENCE TO MAINTENANCE MANUAL 30-41-02. OPS CHECK GOOD.SDR HNAA2009042800137Unknown · odorELECTRICAL BURNING SMELL WHEN APU BLEED IS ON AROUND MIDDLE CABIN AREA. INSPECTED OVERHEAD AND SIDEWALL LIGHTS NO BURNS OR ANY DEFECTS NOTED FROM MIDDLE TO AFT CABIN (SHORT SIGNED BY 9452). GROUND RAN AIRCRAFT OPERATED ENGINES AND AUXILIARY POWER UNIT BLEEDSSDR HNAA2009042800136Smoke Detector · faultySMOKE WARNING LIGHT ILLUMINATED IN FLIGHT. REMOVED AND REPLACED NUMBER 1 AND NUMBER 2 SMOKE DETECTORS IN ACCORDANCE WITH DASH 8 MAINTENANCE MANUAL 26-12-01. PERFORMED HIDDEN DAMAGE INSPECTION, NO DISCREPANCIES NOTED.SDR CA090428004Unknown · unknown(CAN) DURING CLIMB, FLT CREW NOTED A FLUCTUATION IN TORQUE & PROP RPM ON NR 1 ENGINE. PROP APPEARED TO BE GOING TO AN UNCOMMANDED FEATHER POSITION. AS A PRECAUTION, SECURED NR 1 ENG IAW SOP. RETURNED FOR LANDING. ACFT & ENG INSPECTED BY MX. ENGINE, PROP & SDR HNAA2009042600135Battery · dischargedUPON INSPECTION AT SBY, IT WAS FOUND THAT TWO EMERGENCY LIGHTS ON THE FLOOR (MOST FORWARD) WERE INOPERATIVE. THE EMERGENCY BATTERY AT THE 400 POSITION WAS CHANGED AND THE OPERATIONAL CHECK WAS GOOD.SDR HNAA2009042200133Light · inoperativeEMERGENCY PATH FLOOR LIGHT INOPERATIVE AT SEAT 3 DF. REMOVED AND REPLACED LIGHT BULB. OPS GOOD.SDR HNAA2009042000132Light · inoperativeCABIN FLOOR EMERGENCY LIGHT BULB AT ROW 4 RIGHT IS BURNT OUT. RELAMPED BULB IAW 33-52-00, OPERATIONAL CHECK GOOD.SDR HNAA2009042000131Light · inoperativeCABIN EMERGENCY FLOOR PATH LIGHT IS INOP, MOST FWD. REMOVED AND REPLACED EMERGENCY FLOOR PATH LIGHT, MOST FWD.SDR HNAA20090400130Light · inoperativeCABIN - CENTER CEILING EMERGENCY LIGHT INOP. REMOVED AND REPLACED BULB IAW 33-51-00, OPS CHECK GOOD.SDR HNAA20090400129Light · inoperativeFIRST ROW FLOOR EMERGENCY LIGHT INOPERATIVE. RELAMPED BULB IAW MM 33-52-00, OPERATIONAL CHECK GOOD.SDR HNAA2009041800128Light · inoperativeTHE 14TH BULB EMERGENCY FLOOR LIGHTING INOP. RELAMPED BULB IAW 33-52-00, OPERATIONAL CHECK GOOD.SDR HNAA2009041700125Bulb · burned outTHE 1ST FLOOR EMERGENCY FLOOR EMERGENCY LIGHT, 14TH FLOOR EMERGENCY FLOOR LIGHT AND CENTER CEILING EMERGENCY LIGHTS ARE INOP. RELAMPED BULBS IN ACCORDANCE WITH MAINTENANCE MANUAL 33-52-00.SDR HNAA2009042100133Battery · dischargedCREW REPORTED EMERGENCY LIGHT ABOVE PASSENGER AIRSTAIR DOOR INOPERATIVE. MAINTENANCE FOUND AN EXTERIOR EMERGENCY LIGHT INOPERATIVE AS WELL. MAINTENANCE TROUBLESHOT THE SYSTEM, FOUND BOTH A BATTERY AND IT'S ASSOCIATED POWER SUPPLY INOPERATIVE. REMOVED AND RESDR HNAA2009041800126Light · inoperativeEMERGENCY LIGHT SWITCH ON FLIGHT ATTENDANT SWITCH PANEL IS NOT BACKLIT. RELAMPED EMERGENCY LIGHT SWITCH BACKLIGHTING. OPERATIONAL CHECK GOOD.SDR HNAA2009041700127Light · inoperativeFORWARD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FORWARD EMERGENCY LIGHTING ON RIGHT FUSELAGE IAW 33-51-00-08. NO FIX. RE-ATTACHED BULB CONNECTION BEHIND LAVATORY. OPERATIONAL CHECK GOOD.SDR HNAA2009041700124Pressure Switch · faultyNUMBER TWO RUDDER HYDRAULIC CAUTION LIGHT ILLUMINATED IN FLIGHT WITH NO LOSS OF PRESSURE OR FLUID. REMOVED AND REPLACED NUMBER TWO RUDDER HYDRAULIC PRESSURE SWITCH IN ACCORDANCE WITH DASH 8 MAINTENANCE MANUAL 27-20-39. OPS CHECK AND LEAK CHECK GOOD.SDR HNAA2009041600122Pipe · leakingFLIGHT ATTENDANT REPORTS SULFUR ODOR BETWEEN ROWS 2 THRU 5 IN-FLIGHT AND ON GROUND. REMOVED AND REPLACED RIGHT CENTER WING BLEED PIPE. OPS CHECKS GOOD. OK FOR SERVICE.SDR HNAA2009041700123Brake · leakingSMOKE COMING FROM NUMBER ONE BRAKE AREA, INSPECT FOUND NUMBER TWO BRAKE TO HAVE A LEAK. REMOVED AND REPLACED NUMBER TWO BRAKE IN ACCORDANCE WITH 32-42-11, LEAK CHECK GOOD OK FOR SERVICE. S/N OFF 3741P.SDR HNAA2009041600121Panel · malfunctionedSMOKE, ELECTRICAL FIRE FROM UNDER GLARE SHIELD AFTER GROUND POWER APPLIED. REMOVED & REPLACED CAPTAIN'S AUTO PILOT DISENGAGE ANNUNCIATOR PANEL ASSEMBLY DUE TO A BURNT RESISTOR. INSPECT AREA IN THE VICINITY FOR OTHER DAMAGE NONE FOUND. OP'S CHECK GOOD. IN ASDR CA090420001Spring · looseUPON CARRYING OUT C-CHECK, INSPECTION 543E, THE LT AILERON SPRING TAB INBD HINGE (ON REAR SPAR OF AILERON) WAS FOUND WORN TO THE POINT THAT IT WAS NO LONGER SUPPORTING THE TAB. ONLY THE OUTBOARD AND CENTER HINGES WERE SUPPORTING THIS SPRING TAB- EXTREMELY LOOSDR HNAA2009041500120Generator · malfunctionedBOTH DIRECT CURRENT GENERATORS FELL OFF LINE AT SAME TIME WHEN STRUCK BY LIGHTNING. GROUND RAN ENGINES, BOTH DIRECT CURRENT GENERATORS OPERATE NORMALLY PER DASH 8 RUN UP MANUAL.SDR HNAA2009041500119Fan · overheatedCAPTAINS ADVISORY DISPLAY COOLING FAN OVERHEATED. REMOVED AND REPLACED OF AVIONICS COOLING FAN.SDR HNAA2009040900115Light · inoperativeONE RED FLOOR EMERGENCY LIGHT OUT IN FORWARD CABIN. RELAMPED BULB AS REQUIRED, OPS CHECK GOOD IN ACCORDANCE WITH DASH 8 MAINTENANCE MANUAL 33-52-00.SDR HNAA2009040800111Sign · brokenROW 4DF WALL MOUNTED EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN ASSEMBLY.SDR HNAA2009040800109Light · inoperativeFIRST WHITE EMERGENCY LIGHT, FLOOR PATH LIGHT DOES NOT ILLUMINATE. REMOVED AND REPLACED LIGHT BULB, OPS CHECK GOOD IN ACCORDANCE WITH MAINTENANCE MANUAL 33-51-11.SDR CA090407009Line · chafed(CAN) AFTER BEING AIRBORNE FOR ABOUT 30 MINUTES, CAPTAIN HAD AN INDICATION OF HYDR ISO VALVE, VERIFICATION REVEALED HE HAD LOST ALL THE HYDR FLUID FROM THE NR 1 SIDE. AN EMERGENCY WAS DECLARED AND THE ACFT RETURNED TO BASE. INVESTIGATION BY MX FOUND HYDR TUBE SDR HNAA2009040800108Tru · malfunctionedLEFT TRANSFORMER RECTIFIER UNIT FAILED WHEN ON RUNWAY AND RETURNED TO GATE. CREW GROUND RAN AIRCRAFT, PERFORMED TRUE OPS CHECK AND ALTERNATING CURRENT. VARIABLE FREQUENCY GENERATION SYSTEM OPS CHECK. ALL SYSTEMS OPERATE NORMALLY IN ACCORDANCE WITH THE PROCESDR HNAA2009040900112Wire · brokenSPOILER NR 1 SWITCH LIGHT ILLUMINATED ON TAKEOFF ROLL. ABORTED TAKEOFF AND RETURNED TO GATE. INSPECTED SWITCHES AND CONNECTORS AT BOTH SPLR CLUTCHES FOUND WIRE BROKEN AT SWITCH 27-62-57. REPAIRED WIRE ALL SWITCHES AND CONNECTORS CHECK GOOD, OPS GOOD PER MM SDR HNAA2009040800107Unknown · malfunctionedNR 2 PROPELLER WENT TO 1232 RPM, TORQUE 90 PERCENT AFTER TAKEOFF APPROX 300 FT. PULLED BACK ON CONDITION LEVERS AND PROPELLER REACTED NORMALLY FOR THE REMAINDER OF FLIGHT. PERFORMED BETA LOCKOUT WITH PARKING BRAKE INHIBIT SYS, OPS CK GOOD. AT THIS TIME NO D
Back to Boeing DHC-8-102