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 HNAA2009012500025Support Angle · corrodedFORWARD CARGO FLOOR AFT SUPPORT ANGLE CORRODED ON RT. R&R FORWARD CARGO FLOOR AFT SUPPORT ANGLE WITH SOLID RIVET AS PER STRUCTURAL REPAIR MANUAL 51-40-00.SDR HNAA0800304Threshold · corrodedPAX DOOR THRESHOLD CORRODED. REPLACED PAX DOOR THRESHOLD IAW SRM 51-40-00.SDR HNA2008F00052Seat Track · corrodedSEVERAL SPOTS OF MINOR CORROSION FOUND ON RT INBD SEAT TRACK FROM STA X259 TO X597. REMOVED CORROSION IAW RD8-53-1339 FROM X426 TO X526, R&R SEAT RAIL FROM X182 TO X425 AND X526 IAW SRM 51-40-00.SDR HNAA0800303Seat Track · corrodedSEVERAL SPOTS OF MINOR CORROSION FOUND ON RT INBD SEAT TRACK FROM STA X259 TO X597. REMOVED CORROSION IAW RD8-53-1339 FROM X426 TO X526, R&R SEAT RAIL FROM X182 TO X425 AND X526 IAW SRM 51-40-00.SDR HNAA0800305Structure · dentedPROTRUDING DENT FOUND AT STATION X183.35 BETWEEN 24P AND 26P. REPAIRED DENT IAW RD 8-53-2181, HIGH FREQ EDDY CURRENT PERFORMED, NO DEFECT NOTED.SDR HNA2008F00044Radar · inoperativeWEATHER RADAR W/N PAINT, TX FAULT AND AFC MESSAGE. ACFT DIVERTED TO LGA. MAINTENANCE REMOVED AND REPLACED RADAR RT. OPS CHECK GOOD. (S)SDR HNA2008F00041Wheel · out of balanceAFTER TAKEOFF SEVERE NOSE TIRE SHIMMY. CREW BURNED FUEL TIL GOOD TO LAND, RETURNED TO PHL. BURNED OFF FUEL, RETURNED TO FIELD. MAINTENANCE REPLACED NOSE WHEELS. NO OTHER DEFECTS NOTED. (S)SDR HNA2008F00040Light · malfunctionedEMERGENCY LIGHTS FLASHED OFF AND ON DURING TAXI IN. CREW REPORTED TO MAINTENANCE. MAINTENANCE PERFORMED EMERGENCY LIGHTS OPS CHECK PER WORK CARD 33-50-03. OPS CHECK GOOD. (S)SDR HNA2008F00039Light · malfunctionedEMERGENCY LIGHTS FLASHED OFF AND ON DURING TOUCHDOWN. PILOT REPORTED TO MAINTENANCE. PERFORMED EMERGENCY LIGHTS CHECK PER WORK CARD 33-50-03. OPS CHECK GOOD. (S)SDR HNAA2009020100039Skin · dentedPROTRUDING DENT FOUND AT STATION X178.200 BETWEEN STRINGER 30S AND 31S. REPAIRED DAMAGE IAW RD8-53-2181.SDR HNA2008F00038Wire · brokenABORTED TAKEOFF DUE TO AUTOFEATHER ARM LIGHT DID NOT ILLUMINATE. FERRIED TO SBY. MAINTENANCE REPAIRED WIRE AT POWER LEVER MICROSWITCH 6121S13. OPS CHECK GOOD. (S)SDR HNA2008F00037Brake Assy · smokeNR 2 BRAKE ASSY SMOKING. RETURNED TO GATE. INSPECTED BRAKE ASSY, NO DEFECTS NOTED. FLIGHT 4615 PHF. (S)SDR CA080811003Brake Assy · damaged(CAN) WHILE THE ACFT WAS BEING TOWED OFF THE RAMP A STRANGE NOISE WAS HEARD IN THE RT WHEEL AREA. UPON INVESTIGATION IT WAS FOUND THAT 3 OF THE 6 TORQUE PLATE TO PISTON HSG RETAINING BOLTS ON THE RT INBD BRAKE UNIT HAD SHEARED. NO OTHER DAMAGE WAS NOTICED. THSDR CA080807004Housing · fractured(CAN) WHEN THE FLIGHT/TAXI SWITCH WAS SELECTED TO FLIGHT IN PREPARATION FOR TAKE OFF, THE CREW RECEIVED SOME HYDRAULIC CAUTION LIGHTS ASSOCIATED WITH A LOW HYDRAULIC LEVEL INDICATION ON THE NR 1 SYSTEM . THE ACFT RETURNED TO THE GATE AND A MAJOR HYDRAULIC LEAKSDR CA080805010Heater · burned(CAN) THE CREW OBSERVED SPARKS COMING FROM THE FRONT OF THE RT ENGINE. THE CREW SHUTDOWN THE ENGINE IN FLIGHT AND DECLARED AN EMERGENCY. THE ACFT LANDED SHORTLY AFTER WITHOUT INCIDENT. INVESTIGATION REVEALED THAT THE RT PROPELLER BLADE NR2 ELECTRICAL HEATER BUSDR HNAA0800234Display · burnedRADAR SCREEN WENT BLANK INFLIGHT WITH A BURNING SMELL. CREW DECLARED EMERGENCY TO ATC. CREW TURNED RADAR OFF. MAINTENANCE REPLACED RADAR INDICATOR. OPS CHECK GOOD. (S)SDR CA081103002Socket · melted(CAN) DURING A C-CHECK INSP OF THE CABIN LIGHTING SYS IT WAS FOUND THAT THE NR 5 FLOURESCENT CABIN LIGHTING BALLAST WAS MELTED AT THE BULB SOCKET. BALLAST WAS REMOVED AND REPLACED. TT ON THE BALLAST CAN NOT BE ACURATLY DETERMINED BUT WITH A DATE STAMP OF FEB SDR HNAA0800232Battery · dischargedEMERGENCY EXIT SIGN FWD RT INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY. OPS CHECK GOOD. (S)SDR HNAA0800233Connector · dirtyEMERGENCY LIGHTS WERE FLASHING FOR ABOUT ONE MINUTE AFTER ROTATION. CREW REPORTED. (S)SDR HNAA0800231Control Unit · faultedNR 1 ENG PROP SPEED WENT TO 1217 ON TO ROLL ABORTED TAKEOFF. ABORTED T/O RETURNED TO GATE. MAINTENANCE REPLACED NR 1 PROP CONTROL UNIT AND TRANSFER TUBE OPS AND LEAK CHECK GOOD FLIGHT 4436. (S)SDR HNAA0800230Transceiver · faultedRADAR SHOWED TX FLT IN FLIGHT AND WOULD NOT PAINT WEATHER. AIR RETURN TO LGA. MAINTENANCE REPLACED RADAR R/T OPS CHECK GOOD. (S)SDR HNA2008F00005Power Supply · brokenRT FWD EMERGENCY LIGHT IS DIM. REMOVED AND REPLACED BATTERY, FOUND CAMLOCK ON BATTERY BROKEN , CAUSING LOOSE CONNECTION. OP CHECK GOOD. (K)SDR HNA2008F00004Power Supply · brokenRT FWD EMERGENCY LIGHT IS DIM. REMOVED AND REPLACED BATTERY, FOUND CAMLOCK ON BATTERY BROKEN CAUSING LOOSE CONNECTION. OPS CHECK GOOD. (K)SDR HNA2008F00022Battery · dischargedEMERGENCY LIGHT ABOVE AIRSTAIR DOOR INOPERATIVE. ALSO, LT FWD EXTERIOR EMERGENCY LIGHT OUT. REMOVED AND REPLACED 3351PS1, CHECK GOOD BY OBSERVING LIGHT ILLUMINATE. (K)SDR HNA2008F00021Control Box · malfunctionedCABIN EMERGENCY LIGHTS INTERMITTENT ILLUMINATION DURING TAXI AND FLIGHT. A/C FERRIED FOR REPLACEMENT OF LIGHTS CONTROL BOX. OPS CHECKED GOOD. (K)SDR HNA2008F00020Light · malfunctioned3 OCCURRENCES IN A ROW OF EMERGENCY LIGHTS GOING ON IN FLIGHT. NR 1 FLT 4577 CLT, NR 2 4276 GSP, NR 3 4196 MDT. CREW REPORTED: NR 1 REMOVED AND REPLACED EMERGENCY LIGHTS CONTROL BOX AC RELEASED FOR SERVICE. FAILED AGAIN, SAME PROBLEM NR 2 FLIGHT, F/A PANEL ESDR HNA2008F00002Radar · failedRADAR SPIKES RADAR FAILED ENROUTE TO FLO. THUNDERSTORM ACTIVITY WAS AHEAD OF THE FLIGHT. DISPATCHER AND CAPTAIN CHOSE TO HAVE FLIGHT RETURN. REMOVED AND REPLACED RADAR RT. OPS CHECK GOOD IAW SB 34-18. (K)SDR HNA2008F00001Transceiver · failedRADAR SPIKES, RADAR FAILED ENROUTE, THUNDERSTORM ACTIVITY WAS AHEAD OF THE FLIGHT. DISPATCHER AND CAPTAIN CHOSE TO HAVE FLIGHT RETURN. REMOVED AND REPLACED RADAR TR. OPS CHECK GOOD IAW SB 34-18. (K)SDR HNA2008F00000Transmitter · failedLOG PAGE 269950-2. RADAR SHOWS FAULT MESSAGES "STAB OFF" AND "IN FIT 6" IN FLIGHT. REMOVED AND REPLACED WEATHER RADAR TRANSMITTER UNIT. (K)SDR HNA2008F00018Unknown · odorUNKNOWN ELECTRICAL ODOR ACCOMPANIED BY LIGHT SMOKE. MAINT WAS ON AC FOR APPROX 2.5 HOURS, SUSPECT WATER GOT ON TOP OF ADVISORY DISPLAY PANEL WHICH WAS CURRENTLY MEL`D. (K)SDR HNA2008F00026Warning Light · illuminatedREJECTED TO AT 45 KNOTS DUE TO SECONDARY INVERTER CAUTION LIGHT COMING ON DURING ROLL. GOT OFF THE RUNWAY AND CALLED MX CONTROL. DID NOT RETURN TO GATE, MEL WAS ISSUED. (K)SDR HNAA0800215Display · malfunctionedRETURN TO FIELD WEATHER RADAR SCREEN PAINTS MULTIPLE LINES AND COLORS RRD WEATHER RADAR RT, OPS CHECK GOOD. (A)SDR HNAA0800214Transmitter · malfunctionedAIR RETURN NR 1 OIL PRESS GAUGE FLUXED FROM 50 TO 0 THEN BACK TO 40. W/NO OIL WARNING LIGHT SO ENGINE WAS NOT SHUT DOWN. REMOVED AND REPLACED OIL PRESS XMITTER OPS AND LEAK CHECK GOOD. DEPARTURE AIR READINGS NORMAL. REMOVED AND REPLACED NR 2 ENGINE OIL PRESDR HNAA2009061600176Threshold · corrodedCORROSION FOUND ON PAX DOOR THRESHOLD. THRESHOLD 85320686-101 REPLACED AND PAD NYLON RUBBING REPLACED AND INSTALLED WITH SOLID RIVET IAW SRM 51-40-00.SDR HNA2008F00025Bulb · burned out7TH FLOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPS CHECK GOOD. (K)SDR HNAA2009010900387Skin Panel · damagedDURING C-CHECK INSP, THE TRAIL RUDDER SKIN WAS FOUND TO BE DAMAGED ON THE LT SIDE NEAR THE LOWER HINGE POINT. THE DAMAGE WAS REPAIRED IAW SRM PROCEDURES AND EO8-55-08-3203.SDR HNAA2009010900386Spar · crackedDURING C-CHECK INSP, THE REAR SPAR OF THE LT ELEVATOR SPRING TAB WAS FOUND TO BE CRACKED AT THE OTBD EDGE. THE SPAR WAS REPAIRED IAW RD8-55-068.SDR HNAA2009021300056Structure · corrodedDURING C-CHECK INSPECTIONS, THE INBOARD WIRING TROUGH (GUTTER) UNDER THE WARDROBE AREA WAS FOUND TO BE CORRODED ON THE LOWER SURFACE. A REPLACEMENT WAS FABRICATED AND INSTALLED.SDR HNAA2009021300055Seat Track · corrodedDURING C-CHECK INSPECTIONS, THE LT I/B FORWARD SEAT RAIL WAS FOUND TO BE CORRODED. THE SEAT RAIL SECTION WAS REMOVED AND REPLACED.SDR HNAA2009010900385Bracket · corrodedDURING C-CHECK INSP, THE PAX DOOR THRESHOLD WAS FOUND TO BE CORRODED. THIS ITEM WAS R&R IAW SRM PROCEDURES. A BRACKET UNDERNEATH THE THRESHOLD, P/N 85321069-101, WAS ALSO FOUND CORRODED. A REPLACEMENT WAS FABRICATED AND THE BRACKET REPLACED. ADDITIONALLY, TSDR HNAA2009020100042Tab · dentedDENT ON TRAILING ARM OF LT STRING TAB 3.3" FROM INBD EDGE. REPAIR DAMAGE IAW WITH RD8-55-037.SDR HNAA0800208Receptacle · burnedWARMER NR 1 SOCKET ON AIRCRAFT LOOKS DAMAGED AND DOES NOT WORK. WARMER NR 2 OPERATES NORMALLY. WARMER NR 2 HAS SMOKE ODOR WHEN SELECTED ON. INSPECTED FOR DAMAGE FOUND BOTH AIRCRAFT SOCKETS TO BE DAMAGED DURING HIDDEN DAMAGE INSPECTION, REF LOG BOOK PG 26925SDR HNA2008F00012Power Supply · dischargedEMERGENCY EXIT SIGN ABOVE AIRSTAIR DOOR ENTRANCE INOPERATIVE. REMOVED AND REPLACED 3351, PS1 BATTERY PACK IAW 33-52-00. (K)SDR HNAA0800193Battery · dischargedRT EGRESS LIGHT IN INOPERATIVE FORWARD. REMOVED AND REPLACED EMERGENCY BATTERY IAW W/C 33-50-05R. (S)SDR HNAA0800194Lamp · burned outEMERGENCY FLOOR FLIGHTS OUT 3 & 5 POSITION. (S)SDR HNAA0800192Battery · dischargedRT EGRESS LIGHT IS INOPERATIVE FORWARD. REMOVED AND REPLACED EMERGENCY BATTERY IAW W/C 33-50-05R. P/N OFF 61-0478-9, P/N ON 60-1721-1XC S/N OFF 138, S/N ON JAX12. (S)SDR HNAA0800196Indicator · defectiveNR 1 TO GAUGE, ANALOG PORTION INOPERATIVE. REMOVED AND REPLACED NR 1 TQ IND IAW MM 77-10-00, PAGES 201 & 202. OPS CHECK GOOD, OK FOR SERVICE. (S)SDR HNAA0800198Lamp · burnedSECOND FLOOR EMERGENCY LIGHT IS INOPERATIVE (FLOOR PROX EMERGENCY ESCAPE PATH RED LIGHTS). REMOVED AND REPLACED BULB, WORK COMPLETE. OPS CHECK GOOD. (S)SDR HNA2008F00014Oil System · leakingAPU BLEED ON, VAPOR VISIBLE IN CABIN. INSPECTED AND FOUND APU HAS AN OIL LEAK, NO VAPOR VISIBLE OFF ENGINE BLEEDS. REMOVED AND REPLACED APU. (K)SDR HNAA0800190Door · out of adjustAIRSTAIR DOOR INSIDE HANDLE IS HARD TO OPEN. DFRL 05JUN08 14:27 AVP MT LUBED DOOR STOPS NO FIX. FERRY ACFT TO MDT FOUND DOOR TO BE HANGING UP AT THE SILL AREA. ADJUSTED DOOR IAW 8M/M 52-10-00. OPS CHECK OK. (S)
Back to Boeing DHC-8-102