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 CA090406006Case · rupturedDURING TAXI FOR TAKEOFF, THE CREW LOST ALL HYDRAULIC NR 1, THEREBY CAUSING NORMAL BRAKING TO BE INOPERATIVE. THE AIRCRAFT RETURNED TO GATE USING EMERGENCY BRAKES AND REVERSE (PROPELLER) THRUST. UPON ARRIVAL, A FLUID LEAK MIDWAY UNDER THE RT WING WAS NOTICED.SDR HNAA2009040700106Gcu · failedLEFT ALTERNATING CURRENT BUS FAILED IN FLIGHT. REMOVED AND REPLACED NR 1 ALTERNATING CURRENT GENERATOR CONTROL UNIT AND CLEANED CONNECTOR TO NR 1 ALTERNATING CURRENT GENERATOR. GROUND OPERATIONS CHECK GOOD. REFERENCE AIRCRAFT MAINTENANCE MANUAL AMM 24-21-02SDR HNAA2009040500105Receptacle · brokenUPON INSPECTION IN SBY, FOUND EMERGENCY LIGHT POWER SUPPLY AT ROW 7AC HAD A BROKEN CAMLOCK RECEPTACLE. REMOVED AND REPLACED POWER SUPPLY. OPERATIONAL CHECK GOOD.SDR HNAA2009033100103Control Box · faultyEMERGENCY LIGHTS FLICKER WHEN SELECTING GEAR UP OR DOWN. REMOVED AND REPLACED EMERGENCY LIGHTS CONTROL BOX IN ACCORDANCE WITH 33-51-00. AIRCRAFT RELEASED FOR EVALUATION FLIGHT DUE TO EMERGENCY LIGHTS FLICKER DURING GEAR EXTENSION AND RETRACTION. MAINTENANCESDR HNAA2009033000100Light · inoperativeFOUND FLOOR LEVEL EMERGENCY LIGHT INOPERATIVE DURING ROUTINE LINE CHECK AT MAINTENANCE FACILITY. REMOVED AND REPLACED BULB, OPERATIONAL CHECK GOOD.SDR HNAA2009033100102Light · sparksFLIGHT ATTENDANT REPORTS SPARKS COMING FROM SIDEWALL OVERHEAD LIGHT SWITCH AT FLIGHT ATTENDANT POSITION. HAPPENED ONCE. MAINT INSPECTED AND FOUND 3 BULBS OUT. NO OTHER DEFECTS NOTED. RELAMPED, OPS CHECK GOOD.SDR HNAA2009033100101Brake · malfunctionedSMOKE COMING FROM RIGHT BRAKES. REMOVED AND REPLACED NR 4 BRAKE ASSY IN ACCORDANCE WITH MAINTENANCE MANUAL 32-42-11, LEAK AND OPS CHECKED GOOD.SDR HNAA2009032800099Light · inoperativeUPON INSPECTION AT SBY, IT WAS NOTICED THAT AN EMERGENCY LIGHT AT ROW 1 WAS INOPERATIONAL. REPLACED THE LIGHT BULB AND THE OPERATIONAL CHECK WAS GOOD.SDR CA090325002Structure · cracked(CAN) ACFT SUSTAINED A BIRD STRIKE TO THE NOSE GEAR AREA ON APPROACH. MX INVESTIGATION FOUND EVIDENCE OF IMPACT AND DAMAGE TO THE RT AFT NOSE LANDING GEAR DOOR LEADING EDGE. THE RT AFT NLG DOOR P/N 85310278-010, S/N 24BAC025 WAS REMOVED AND DEFERRED IAW THE CSDR HNAA2009031900097Light · inoperativeUPON LINE INSPECTION AT SBY THERE WAS AN EMERGENCY LIGHT FOUND INOPERATIVE ON THE FLOOR, SECOND ROW BACK FROM THE FRONT OF THE CABIN. REMOVED AND REPLACED LIGHT BULB AND THE OPERATIONAL CHECK WAS GOOD.SDR HNAA2009031700096Wire · brokenROLL SPOILER INBOARD GROUND CAUTION LIGHT ILLUMINATED WHILE ADVANCING POWER FOR TAKEOFF. FOUND BROKEN WIRE ON NUMBER ONE SYSTEM FLIGHT SPOILER LIFT/DUMP VALVE PRESS SWITCH CONNECTOR. REPAIRED WIRE, OPS CHECK SYSTEM. OPS CHECK GOOD. OK FOR SERVICE AT THIS TISDR CA090316001Case · ruptured(CAN) NO RESPONSE NOTICE FROM THE RT OTBD SPOILER DURING PRE-FLIGHT CHECKS BY THE CREW. THE ACFT RETURNED TO GATE AND A HYDR LEAK WAS OBSERVED AT THE RT WING. FURTHER INVESTIGATION REVEALED THAT THE RT OTBD SPOILER ACTUATOR CASING HAD RUPTURED AND CAUSED THE SDR HNAA2009031400095Light · inoperativeUPON LINE INSPECTION AT SBY, AN EMERGENCY EXIT LIGHT AT ROW 5 WAS FOUND INOPERATIVE. REMOVED AND REPLACED LIGHT BULB, OPERATIONAL TIME WAS GOOD.SDR HNAA2009031200088Light · inoperativeUPON LINE CHECK AT SBY IT WAS FOUND THAT SEVERAL BULBS WERE BURNED OUT IN THE EMERGENCY EXIT SIGN AT ROW 1. RELAMPED BULBS AND THE OPERATIONAL CHECK WAS GOOD.SDR HNAA2009031400092Light · inoperativeONE FLOOR EMERGENCY ESCAPE PATH LIGHT INOP. REMOVED AND REPLACED LIGHT BULB.SDR HNAA2009031400093Light · inoperativeSIX LAMPS INOPERATIVE BEHIND EXIT SIGN AT BUFFET OVERHEAD DISPLAY. REMOVED AND REPLACE LIGHT BULB.SDR HNAA2009031400094Light · inoperativeEMERGENCY FLOOR LIGHT FOUND INOPERATIVE AT ROW 4. REMOVED AND REPLACED BULB.SDR HNAA2009031400090Brake · wornLEFT MAIN BRAKES SMOKING AFTER LANDING. REMOVED AND REPLACED NR 1 AND NR 2 BRAKE ASSY'S REF -8 MAINTENANCE MANUAL 32-42-11. OPS AND LEAK CHECK GOOD AT THIS TIME.SDR HNAA2009031400089Actuator · failedNOSE LANDING GEAR RED UNSAFE LIGHT ILLUMINATED AFTER GEAR EXTENSION, COMPLY WITH ALTERNATE GEAR EXTENSION & NOSE GEAR EXTENDED & LOCKED. CREW REPORTED NO NLG DOOR LIGHT, REMOVED AND REPLACED NLG DOOR ACTUATOR, OP'S CHECK SEVERAL TIMES, LEAK CHECK GOOD IAW MM SDR HNAA2009031400091Light · inoperativeONE EMERGENCY ESCAPE PATH FLOOR LIGHT AT ROW 7 INOP. REMOVED AND REPLACED LIGHT BULB.SDR CA090305014Engine · leaking(CAN) SHORTLY AFTER TAKEOFF THE CREW NOTICED SMOKE IN THE CABIN. THEY RETURNED TO DEPARTURE AND LANDED SAFELY. INSP OF THE ACFT REVEALED OIL IN THE LT ENG INTERCOMPRESSOR CASE. THE ENGINE IS BEING REPLACED PRIOR TO THE ACFT BEING RETURNED TO SERVICE.SDR HNAA2009030400087Control Panel · faultyINFLIGHT, CIRCUIT BREAKER FOR LEFT AIRCRAFT VOLT METER B AND C PHASES AND RIGHT AIRCRAFT VOLT METER A, B, C PHASES AND CIRCUIT BREAKER J9 ON RIGHT ESSENTIAL BUSS "PWR MONITOR" "AC" POPPED AND ELECTRICAL SMELL OBSERVED. SMELL DISSIPATED WHILE STILL IN FLIGHT. SDR HNAA2009030400089Linkage · brokenAFTER TAKEOFF ON GEAR RETRACTION HAD RED NOSE GEAR LIGHT, AFTER APPROX 1 MIN ALL LIGHTS CLEARED FOLLOWED BY NOTICEABLE VIBRATION IN YOKE AND RUDDER. JACKED AND SWUNG GEAR REF MM 32-30-00. GEAR AND INDICATION ARE WORKING CORRECTLY. INSPECTED NOSE GEAR AREA, SDR HNAA200903010008APressure Switch · defectiveAFTER TAKEOFF RIGHT INBOARD TAIL DEICE BOOT DID NOT ILLUMINATE, LIGHT DOES TEST. REMOVED AND REPLACED TAIL DEICE BOOT PRESS SWITCH. GROUND RAN BOTH ENGINES, OPS CHECK GOOD. OK FOR SERVICE.SDR HNAA2009030100085Light · inoperativeUPON LINE INSPECTION AT SBY AN EMERGENCY LIGHT AT ROW 1 WAS FOUND BURNT OUT. REMOVED AND REPLACED LIGHT BULB AND THE OPERATIONAL CHECK WAS GOOD.SDR HNAA2009030100084Light · inoperativeAT A LINE CHECK INSPECTION AT SBY AN EMERGENCY LIGHT WAS FOUND INOPERATIVE IN THE CABIN. REMOVED AND REPLACED EMERGENCY LIGHT AND THE OPERATIONAL CHECK WAS GOOD.SDR HNAA2009022800079Light · inoperativeEMERGENCY LIGHTING - LIGHT BULB INOPERABLE. REMOVED AND REPLACED LIGHT BULB WITH NEW ONE IN ACCORDANCE WITH 33-51-11. LOCATION FIRST FLOOR PATH. OPERATIONAL CHECK IS GOOD.SDR HNAA2009022800078Gyro · faultyAFTER STARTUP FLIGHT CREW SMELLED FUMES AND DETERMINED IT TO BE A DIRECTIONAL GYRO CONTROLLER. REMOVED AND REPLACED SAHS CONTROLLER & OPERATION CHECKED GOOD. NO DEFECTS. IN REFERENCE TO AMM 34-20-50.SDR CA090312005Frame · cracked(CAN) WHILE CARRYING OUT A ROUTINE INSP OF THE ACFT, A CRACK WAS NOTICED IN THE AFT FRAME MEMBER OF THE RT FWD EMERGENCY EXIT SURROUND AT THE LWR CORNER (STN X264.1 RHS). THE FRAME MEMBER (P/N 85320534-103) WAS CRACKED FROM THE LIGHTENING HOLE TO THE INNER SURSDR HNAA2009022800081Control Box · failedFIRST TWO EMERGENCY LIGHT OUT. REMOVED AND REPLACED BASE ASSY 3352 PS2.SDR HNAA200902260075Light · inoperativeTHIRD RED FLOOR EMERGENCY LIGHT INOP. RELAMPED THIRD RED FLOOR EMERGENCY LIGHT IAW AMM 33-54-00. OPS CHECK GOOD.SDR HNAA2009022600074Light · inoperativeROW 7 FLOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED LIGHT BULB. OPS CHECK GOOD.SDR HNAA2009022800082Switch · intermittentDURING TAKEOFF ROLL AUTOFX ARM SWITCH POPPED OUT, RESEATED SWITCH OPS CHECK GOOD. COMPLY WITH OPS CHECK OF AUTOFX ARM LIGHT/SWITCH, NO DEFECTS NOTED. AT NEXT RON, REMOVED AND REPLACED AUTOFX SWITCH LIGHT ASSEMBLY. REMOVED AND REPLACED AUTO FEATHER SWITCH ASSDR HNAA2009022800080Wire · cutRED EXIT FLOOR LIGHTS ARE INOPERABLE AT ROW 1. FOUND DURING DIODE CHECK. INSPECTION REVEALED WIRE TO BE CUT GOING TO CONNECTOR. REPAIRED CUT WIRE AND REPINNED WIRE TO THE CONNECTOR IN PROPER PLACE. OPERATIONAL CHECK GOOD. INSPECTION WAS GENERATED BY WORK SDR HNAA2009022300064Light · defectiveROW ONE DF SIDE WALL EMERGENCY EXIT LIGHT DIM. REMOVED AND REPLACED LIGHT BULBS IN ACCORDANCE WITH MAINTENANCE MANUAL 33-51-00.SDR HNAA2009022300065Light · inoperativeFLOOR EMERGENCY LIGHT ROW 1 INOPERATIVE. REMOVED AND REPLACED LIGHT BULB IN ACCORDANCE WITH MAINTENANCE MANUAL 33-51-00.SDR HNAA2009022300063Light · inoperativeFLOOR EMERGENCY LIGHT OUT LOCATED AT ROW 1. REMOVED AND REPLACED FLOOR EMERGENCY LIGHT BULB.SDR HNAA2009022300071Light · inoperativeNUMBER ONE EMERGENCY ESCAPE PATH LIGHT IN ROW ONE INOPERATIVE. REMOVED AND REPLACED BULB, OPS CHECK GOOD.SDR HNAA2009022300067Target · missingWEIGHT ON WHEELS LIGHT ILLUMINATED AND STAYED ON UNTIL GEAR EXTENDED FOR LANDING. PERFORMED PSEU TEST FOUND NLG WOW TARGET FAULT. INSPECTED NLG WOW SENSOR AND TARGET, FOUND TARGET TO BE MISSING. REPLACED TARGET IN ACCORDANCE WITH COMPONENT MAINTENANCE MANUASDR HNAA2009022300066Door · out of adjustUPON GEAR RETRACTION, LEFT FORWARD GEAR DOOR CLOSED AND THEN RE-OPENED, LEFT AMBER DOOR LIGHT REMAINED ILLUMINATED. THE CREW FOLLOW EMERGENCY CHECKLIST AND ADVISED THE AIR TRAFFIC CONTROL ACFT RETURNING TO FILED. AN EMERGENCY WAS NOT DECLARED. UPON EXTENSIOSDR HNAA2009022100062Engine · power lossON CLIMBOUT AT 500 FEET THE NR 1 ENGINE TORQUE DECREASED TO 50 WITH ASSOCIATED NR 1 ENGINE AUTO FEATHER AND THE NR 1 PROPELLER WENT TO 200 RPM. THE NR 1 ENGINE WAS SHUT DOWN AND THE FLIGHT RETURNED TO MDT. THE FLIGHT LANDED WITHOUT INCIDENT. NO REPORTS OF ASDR HNAA2009021900061Light · inoperativeTHE 3RD EMERGENCY FLOOR LIGHT FROM FRONT OF CABIN INOP. REMOVED AND REPLACED BULB IAW AMM 33-51-00, OPS CHECK GOOD.SDR HNAA2009022300072Gcu · intermittentEMERGENCY LIGHT CAME ON DURING FLIGHT. FOUND AC GENERATOR CONTROL UNIT BAD. REMOVED AND REPLACED AC GENERATOR CONTROL UNIT ON BOTH ENGINES. REMOVED AND REPLACED FUSES 2421 F8 AND F10, OPS CHECK GOOD.SDR HNAA2009020700045Smoke Detector · false indicationBAG SMOKE WARNING LIGHT CAME ON IN FLIGHT. NO EVIDENCE OF SMOKE. R&R NR 1 AND NR 2 BAGBAY SMOKE DETECTORS IAW 26-12-01, OPS CHECK GOOD.SDR HNAA2009022300070Doubler · corrodedAREA AROUND LAVATORY SERVICE POST CORRODED ON BOTTOM AFT EDGE. REMOVED AND REPLACED CORRODED DOUBLER AT LAVATORY SERVICE POST.SDR HNAA2009022300069Seat Track · corrodedRIGHT INBOARD SEAT RAIL IS CORRODED AT GALLEY BUFFET MOUNTING HOLES. REMOVED AND REPLACED SEAT RAILS IN ACCORDANCE WITH RD8-53-3074.SDR HNAA2009022300068Seat Track · corrodedLEFT OUTBOARD FORWARD SEAT RAIL HAS SPOTS OF CORROSION AND MISSING SURFACE PROTECTIVE COATING WHERE SEAT LEGS ATTACHED. REMOVED AND REPLACED SEAT TRACK IN ACCORDANCE WITH DEHAVILLAND.SDR CA090205003Torque Tube · delaminatedFLAP POWER LIGHT INTERMITTENT. TORQUE TUBE P/N 234187B OF PRIMARY FLAP DRIVE SYSTEM FOUND TO HAVE 300 DEGREES OF ROTATION FREE PLAY. BONDED ENDS (RUBBER) FOUND DISINTEGRATED. TORQUE TUBE REPLACED AND LUBRICATED IAW AMM 27-52-00. ADDITIONAL CHECKS OF INSTALSDR HNAA2009020900048Oil Cooler · leakingNR 1 ENGINE OIL PRESSURE AT 20 PSI WITH NR 1 ENGINE PRESSURE CAUTION LIGHT ILLUMINATED ON TAKE OFF ROLL. (LIGHT/PIS ON FOR 4 TO 5 SECONDS). FOUND OIL COOLER LEAKING, R&R OIL COOLER IAW MM 79-20-11. PERFORMED LOW OIL PRESSURE INSPECTION IAW MM 05-50-00. GROUNSDR HNAA2009020700046Bulb · burnedEMERGENCY CEILING LIGHT AT ROW 2 INOPERATIVE. R&R BULB, OPS CHECK GOOD.
Back to Boeing DHC-8-102