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 HNAA0700168Switch · malfunctionedEMERGENCY LIGHTS FLICKER ON & OFF IN FLIGHT. PROBLEM FOUND TO BE IN F/A SWITCH. REMOVED AND REPLACED EMERGENCY LIGHT SWITCH.SDR HNAA0700194Stringer · crackedBOTH STRINGERS CRACKED IN LEFT NACELLE UNDER HEAT SHIELD FOR EXHAUST. BOTH STRINGERS CUT AND REPAIRED IAW RD8-54-310, INSTALLED WITH SOLID RIVETS AND HI-LOKS IAW SRM 51-40-00.SDR HNAA00194Stringer · crackedBOTH STRINGERS CRACKED IN LEFT NACELLE UNDER HEAT SHIELD FOR EXHAUST. BOTH STRINGERS CUT AND REPAIRED IAW RD8-54-310, INSTALLED WITH SOLID RIVETS AND HI-LOKS IAW SRM 51-40-00.SDR CA071016008Adapter · leaking(CAN) AFTER TAKEOFF ENGINE OIL PRESSURE WAS LOST AND THE ENGINE WAS SHUT DOWN IN FLIGHT. SUBSEQUENT INSPECTION REVEALED A LEAKING GENERATOR MOUNTING PAD ADAPTER. (TC NR 20071016008)SDR CA070911005Adapter · pulled(CAN) WHILE ENROUTE FLIGHT CREW RECEIVED A NR 1 ENGINE OIL PRESSURE LOW INDICATION AND ALSO HAD A VISUAL INDICATION OF DECLINING OIL PRESSURE. CREW SHUTDOWN NR 1 ENGINE AND DIVERTED TO AN ALTERNATE AIRPORT. CREW DID NOT DECLARE AN EMERGENCY AND LANDED SAFELY WSDR HNAA0700191Threshold · corrodedPAX DOOR CORRODED AROUND TEFLON STRIP. PAX DOOR THRESHOLD REPLACED WITH NEW PART 85320686-101 AND 85321229-101 NYLON RUBSTRIP INSTALLED WITH SOLID RIVETS IAW SRM 51-40-00.SDR HNAA0700192Panel · corrodedLAV SERVICE DOOR PNL SURROUND LOWER STRUCTURE IS CORRODED. DAMAGE CUT OUT AND REPAIR PACKER & ANGLE INSTALLED ON LAV SERVICE PANEL AS PER EO08-53-07-3346. HFEC CUTOUT, NO CRACKS FOUND.SDR HNAA0700189Panel · corrodedCORROSION FOUND ON RIGHT STRESS PANEL 622AT. GREEN PRIMER APPLIED ON COUNTER SINKS OF PANEL 622AT AS PER AMM 20-34-11 CORROSION FOUND OUT OF LIMITS, NEW ACCESS PANEL INSTALLED PER 05-00-21.SDR HNAA0700188Seat Track · corrodedCORROSION FOUND ON RIGHT SEAT TRACK AT STATION X597.500. RIGHT INBOARD SEAT TRACK REPLACED FROM STATION X526.500 TO X618.00. INSTALLED WITH SOLID RIVETS PER SRM 51-41-00.SDR CA070906003Attach Fitting · cracked(CAN) DURING SCHEDULED NOSE LANDING GEAR CHANGE, IT WAS DISCOVERED THAT THE NLG UPLOCK ACTUATOR FITTING ASSEMBLY P/N 85311176-009 WAS CRACKED. FITTING REPLACED AND FITTING FASTENERS INSTALLED IAW RD8-53-3805. AFTT: 42865 HRS. TOTAL CYCLES: 50005. (TC NR 200709SDR CA070904002Lever · broken(CAN) THE FLIGHT CREW SNAGGED THAT THE GROUND SPOILER LIGHT ILLUMINATED IN FLIGHT. UPON INVESTIGATION MAINTENANCE FOUND THE LT OB GROUND SPOILER LEVER BROKEN AT THE SPOILER ACTUATOR ATTACH POINT. THE LEVER WAS REPLACED AND THE AIRCRAFT RETURNED TO SERVICE. (TCSDR HNAA0700175Mechanism · lack of lubeDURING TAKEOFF ROLL, THE CAPTAINS SEAT BECAME DISLODGED AND FELL FROM THE TRACKS TO THE FLOOR. MTX LUBED VERTICAL ADJUSTMENT LOCK MECHANISM.SDR HNAA0700171Smoke Detector · malfunctionedAFTER PUSHBACK AND ENGINE START, FLIGHT GO A BAG COMPARTMENT SMOKE DETECTOR WARNING LIGHT. CAPTAIN NOTIFIED F/A TO HASTILY DEPLANE THE PASSENGERS AND HAD THE F/O CALL FOR A FIRE TRUCK TO CHECK IT OUT. THERE WAS NO FIRE OR SMOKE EVIDENT.SDR HNAA0700190Stringer Splice · corrodedCORROSION FOUND ON SPLICE STRINGER 32 RIGHT SIDE AT STA 531. SPLICE STRINGER 32 RIGHT AT 531 REPLACED WITH NEW PART LOCALLY MADE AS PER DWG 85300129 AND INSTALLED.SDR HNAA0700170Radar · inoperativeFLIGHT 4353 MDT/PHL RETURNED TO MDT DUE TO THE WX RADAR WENT INOP. DUE TO WEATHER EN ROUTE THE FLIGHT COULD NOT CONTINUE. THE FLIGHT RETURNED TO MDT WITHOUT INCIDENT.SDR HNAA0700163Socket · defectiveROW 7DF FLOOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED EMERGENCY LIGHT SOCKET.SDR CA070823005Impeller · leaking(CAN) ON TAXI, THE F/O NOTICED SMOKE IN THE FLIGHT DECK AND F/A CONFIRMED HAZE IN CABIN. BLEEDS WERE TURNED OFF. AS AIRCRAFT TURNED ONTO GATE LAV SMOKE DETECTOR WENT OFF. CREW STOPPED 10 FEET SHORT OF THE GATE SHUT DOWN AIRCRAFT AND DEPLANED PASSENGERS. IT WSDR CA070817002Flap Track · corroded(CAN) EXCESSIVE CORROSION FOUND ON FLAP TRACKS NR 4 AND NR 5 ON BOTH LT AND RT WINGS DURING 60K REPLACEMENT OF FLAP TRACKS. SUPPORT BRACKETS REMOVED FOR TRANSFER TO NEW BEAMS, CORROSION FOUND IN RECESSES OF TRACKS BEHIND BRACKETS. LT NR 4 TRACK FOUND FULL OF WSDR HNAA0700193Bracket · corrodedSEVERE CORROSION FOUND ON LOWER AFT PAX DOOR BRACKET (INBOARD). LOWER AFT PAX DOOR BRACKET I/B REPLACED WITH NEW PART INSTALLED WITH BOLT IAW AMM 20-14-01.SDR HNAA0700176Cable · damagedAFTER PUSHBACK, WITH NUMBER 2 ENGINE RUNNING, ATTEMPTED TO START NUMBER 1 ENGINE AND GOT BUSS FAULTS. TURNED OFF APU GEN. F/A THEN INDICATED A CLOUD OF SMOKE CAME OUT OF THE CEILING VENTS, LIMITED TO THE BACK OF THE AIRCRAFT, DID NOT FILL THE CABIN AND DISSISDR HNAA0700167Tscu · inoperativeAUTOFEATHER ARM LIGHT REMAIN ILLUMINATED AFTER AUTOFEATHER SWITCH SELECTED OFF. DIVERTED TO MDT. REMOVED AND REPLACED TSCU AND REMOTE C/B 2431-CB4. OPS CHECKS GOOD.SDR HNAA0700187Uplock Hook · wornAFTER GEAR RETRACTION LEFT GEAR DOOR REMAINED IN YELLOW. CYCLED GEAR PER PROCEDURE THEN THE LEFT GEAR WOULD NOT COME DOWN AT ALL. USED ALTERNATE EXTENSION, GOT ALL GREEN LIGHTS. CIRCLED AND RETURNED TO HPN. NO EMERGENCY WAS DECLARED BUT CAPTAIN DID REQUESTSDR HNAA0700177Radar · inoperativePDT FLT 4189 PHL/CRW HAD THE WEATHER RADAR FAIL IN FLIGHT. CAPTAIN TRIED SEVERAL METHODS OF GETTING RADAR TO WORK, FLIGHT LANDED WITHOUT INCIDENT. REMOVED AND REPLACED WEATHER RADAR, OPS CHECK OK.SDR HNAA0700162Transmitter · malfunctionedNR 1 ENG OIL PRESS WENT TO 40 PSI IN FLT NO WARNING LIGHT. SHUT DOWN NR 1 ENGINE. REMOVED AND REPLACED NR 1 OIL PRESSURE TRANSMITTER. LEAK AND OPS CHECK GOOD.SDR FDKA200708370Power Supply · dischargedFDM 6076 JFK-PHL (1447 PHX LCL) - ALL EMERGENCY LIGHTS WILL NOT SHUT OFF. REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES (8).SDR FDKA200708367Battery · dischargedFDM 6208 JFK (1315 PHX LCL) - ALL EMERGENCY LIGHTS WILL NOT SHUT OFF. MX REMOVED AND REPLACED FWD EMERGENCY LIGHT BATTERY.SDR FDKA200708359Light · malfunctionedASH 6208 JFK-SYR (1713 PHX LCL). PILOT REPORTED THAT THE EMERGENCY LIGHTS WILL NOT GO OFF WHEN SELECTED OFF. EMERGENCY LIGHTS SYSTEM WAS RESET WITH NO FURTHER ACTION REQUIRED.SDR HNAA0700161Windshield · damagedTHERE WAS A BIRD STRIKE NEAR THE F/O WINDSHIELD ON CLIMBOUT. THE FLIGHT WAS 20 MINUTES OUT OF CLT. THE FLIGHT CREW WAS HEARING A NOISE AND THEN IT WENT AWAY. FLIGHT DIVERTED TO ROA. AFTER LANDING IN ROA THE CAPTAIN REPORTED THERE WAS A LOSS OF PRESSURE. MSDR HNAA0700158Radar · failedWHILE EN ROUTE GSO-DCA WEATHER RADAR STOPPED PAINTING WEATHER. CREW SHUT THE WX RADAR DOWN FOR 5 MINUTES THEN RESTARTED AND THAT DID NOT FIX IT. WITH THUNDERSTORMS AHEAD THE CREW CALLED DISPATCHER AND THEY BOTH DECIDED TO DIVERT TO ROA AWAY FROM THE THUNDERSSDR HNAA0700157Radar · failedJUST AFTER TAKEOFF CREW NOTICED WX RADAR WAS NOT PAINTING ANY STORMS THEN RED DOTS BEGAN TO DISPLAY ON THE RADAR. AFTER TALKING WITH DISPATCH WITH DISPATCH AND WITH THUNDERSTORMS ON THEIR ROUTE OF FLIGHT, RETURNED TO LGA.SDR HNAA0700159Battery Pack · failedEMERGENCY LIGHTS AT 1DF INOP. REMOVED AND REPLACED EMERGENCY LT PWR SUPPLY BASE AND BATTERY, OPS CHECK GOOD.SDR HNAA0700156Mixer Box · wornCABIN GOT VERY HOT AFTER TAKEOFF FLIGHT DECK COLD. AFTER SEVERAL PAX GOT SICK, F/A INFORMED CREW THAT THE CABIN WAS TOO HOT TO CONTINUE. ACFT WAS APPROX 20 MILES OUT OF LGA, ACFT RETURNED TO FIELD. CONTACTED LGA MX. ACFT HAS BEEN WRITTEN UP TWICE BEFORE. SDR HNAA070156Mixer Box · wornCABIN GOT VERY HOT AFTER TAKEOFF, FLIGHT DECK COLD. AFTER SEVERAL PAX GOT SICK, F/A INFORMED CREW THAT THE CABIN WAS TOO HOT TO CONTINUE. ACFT WAS APPROX 20 MILES OUT OF LGA, ACFT RETURNED TO FIELD. CONTACTED LGA MX. ACFT HAS BEEN WRITTEN UP TWICE BEFORE. SDR CA070827002Housing · cracked(CAN) WHILE DOING A LAYOVER INSPECTION A HYDRAULIC LEAK WAS FOUND IN THE LT FLAP AREA. THE LEAK WAS FOUND TO BE COMING FROM THE LT OB ROLL SPOILER ACTUATOR. UPON REMOVAL OF THE ACTUATOR IT WAS FOUND THAT THE HOUSING HAD CRACKED IN THE AREA SUROUNDING ONE OF TSDR HNAA0700155Line · leakingHYD LEAK IN NR 2 GEAR WELL LEFT SIDE ABOVE JET PIPE. ROA MX CANNOT REACH LEAK, CREW WILL TAKE A/C TO HANGAR, LOOKING TO TAKE A/C 980 AS A SPARE WILL HAVE TO USE LOWER COWL FOR 980. SWAP 980 AND TAKING LOWER COWL OFF OF 906. FOUND RIGHT LIFT DUMP SPOILER HYDSDR HNAA0700154Valve · malfunctionedUPON DESCENT INTO TYS POWER LEVERS AT FLT IDLE FLT DECK/CABIN STARTED TO FILL WITH SMOKE WITH BOTH BLEEDS ON. TURNED OFF ENGINE BLEEDS AND SMOKE STARTED TO DISSIPATE. F/A REPORTED THAT THE CABIN GOT VERY WARM AT THIS TIME. INSPECTED NR 1 ENGINE FOR OIL OTY SDR HNAA0700153Valve · stickingUPON DESCENT INTO HHH POWER LEVERS AT FLY IDLE FLT DECK/CABIN STARTED TO FILL WITH SMOKE WITH ENGINE BLEEDS ON. TURNED OFF BLEEDS AND SMOKE STARTED TO DISSIPATE. CONTACTED CONTRACT MX AT 1055 WILL HEAD TO A/C ETA 10 MIN. GOING TO LOOK AT OIL LEVELS AND RUN SDR HNAA0700180Acm · leakingSMOKE WARNING LIGHT ILLUMINATED IN FLT ON APPROACH TO LANCASTER (LNS) GOING ON AND OFF INTERMITTENTLY, WITH ASSC MASTER WARNING LIGHT. INSP BAG BAY NO FIRE OR SMOKE DETECTED. REMOVED AND REPLACED FWD AND AFT SMOKE DET'S AS REQ. MECH FOUND ACM LEAKING OIL. SDR HNAA0700151Acm · leaking,ACM LEAKING OIL. MECH FOUND ACM LEAKING OIL, BAG BAY SMOKE DET'S REMOVED AND REPLACED.SDR HNAA0700150Smoke Detector · false activationSMOKE WARN LIGHT ILLUMINATED IN FLT & ON APPROACH INTO LANCASTER GOING ON & OFF INTERMITTENTLY, WITH ASSC MASTER WARN LIGHT. INSP BAG BAY, NO FIRE OR SMOKE DETECTED. REMOVED AND REPLACED FWD AND AFT CEILING BAG BAY SMOKE DET'S AS REQUIRED.SDR FDKA200707337Warning Light · illuminatedFDM 6181 JFK-SYR (0950 PHX LCL) - RUDDER PRESS CAUTION WHEN FLAPS EXTENDED. MX PERFORMED OPS CK AND OPS CK GOOD, NO FAULTS NOTED.SDR HNAA070144Mount · brokenENGINE WAS REMOVED FROM A/C IN MDT ON 7-3-07. RECEIVED IN SBY MAINTENANCE SHOP FOUND TORQUE MOUNT END BROKE OFF. ENGINE S/N 120042.SDR HNAA0700149Valve · malfunctionedAT 20 MILES OUT OF MHT, THE FLIGHT CREW SAW THE NUMBER TWO HYDRAULIC QUANTITY DROP TO TWO QUARTS. ALSO, NOTICED THE NUMBER ONE HYDRAULIC QUANTITY DROP TO ONE AND ONE HALF QUARTS. THE NUMBER TWO HYDRAULIC QUANTITIES THEN STARTED DROPPING BELOW TWO QUARTS AMOUSDR HNAA0700148Engine · malfunctionedNR 1 ENGINE TQ AND WF FLUX PLUS OR MINUS 15 PERCENT. PROP RPM FOLLOWED. NO MANUAL LIGHT. CREW DID NOT CONTACT MX BEFORE RETURN TO FIELD. REMOVED AND REPLACED NR 1 ENGINE, OPS CHECK ALL SYSTEMS ON RUN CHECK, CHECK GOOD.SDR HNAA0700139Stringer · corrodedLIGHT CORROSION AT STR 29 AND STA X291.400 JOINING AREA.SDR HNAA0700140Stringer · corrodedLIGHT CORROSION AT STR 29 AND X467.00.SDR HNAA0700143Stringer · corrodedLITE CORROSION ON STR 29 BETWEEN X488.500 AND X510.00.SDR HNAA0700142Strap · corrodedLITE CORROSION BETWEEN X510.00 AND X531.500 ON STR 29 STRAP.SDR HNAA0700152Strap · corrodedLIGHT CORROSION BETWEEN X510.00 AND X531.500 ON STR 29 STRAP.SDR HNAA0700141Strap · corrodedLITE CORROSION AT STR 29 STRAP BETWEEN STA X467 AND X488.500.
Back to Boeing DHC-8-102