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 QXEA0100107Seat Track · corrodedPDX- CORROSION ON LEFT INBOARD SEAT TRACK FLANGE LOCATED IN CARGO AREA AT STATION 580.50. REPAIRED IAW DHC-8 SRM 51-20-16.SDR HNAA0100007Housing · crackedCRACK FOUND IN AILERON QUADRANT MOUNTING BRACKET/HOUSING ON LOWER OUTBOARD CORNER RUNNING TO THE FIRST RIVET THEN .25 INCHES INBOARD OF RIVET TOWARDS THE NEXT RIVET. CRACK IS TO BE EDDY CURRENT INSPECTED EVERY 70 HOURS AND REPAIRED WITH IN 500 HOURS PER PIEDMSDR CA010301004Line · leaking(CAN) DURING ROUTINE INSPECTION, HYDRAULIC FLUID WAS FOUND LEAKING FROM THE LT WING INBOARD FLAP CANOE. INVESTIGAITON RESULTED IN REPLACEMENT OF A LEAKING FLIGHT SPOILER UNLOAD LINE.SDR CA010213007Capacitor · exploded(CAN) CAPACITOR C104 IN POWER SUPPLY EXPLODED RELEASING A STRONG BURNING SMELL WHICH WAS NOTICED BY PILOTS.SDR QXEA0100075Skin · misrepairedPDX- LEFT HAND OUTBOARD FLAP FAILED CLEARANCE CHECK AT REPAIR DOUBLER ON TOP SKIN AT STATION YW 391.5 TO 405. REPAIRED IAW HORIZON AIR EA 9-57-551.SDR HNAA0100008Oil Cooler · dirtyNR 2 ENGINE OIL GAUGE FLUCTUATING BETWEEN 55 PSI TO 45 PSI, NEVER BELOW 40. COMPLIED WITH ABNORMAL OIL PRESSURE CHECKLIST. REMOVED AND REPLACED OIL COOLER.SDR AU010052Relay · separated(AUS) RELAY BASE SEPARATED AT PRODUCTION BREAK ALLOWING THE RELAY CONTACTS TO COME AWAY FROM THE RELAY. BASE MANUFACTURER CLOVER. THE RELAYS ARE USED IN NUMEROUS AREAS.SDR AU010116Pipe · fractured(AUS) HYDRAULIC PIPE FRACTURED ON RADIUS AT STA. 110.0. LOSS OF HYDRAULIC FLUID.SDR CA010301009Rod End · broken(CAN) THE FLIGHT CREW REPORTED A LOUD NOISE FROM THE FLOOR AREA DURING FLIGHT. MAINTENANCE INVESTIGATION REVEALED A BROKEN LT NOSE LANDING GEAR AFT DOOR ACTUATING ROD. THE ROD END WAS REPLACED AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR HNAA0100009Mount · brokenDURING ENGINE CHANGE, THE AFT OUTBOARD VERTICAL MOUNT STRUT WAS FOUND BROKEN. THE STRUT WAS REPLACED.SDR AU010118Uplock Sensor · out of adj(AUS) RT MAIN LANDING GEAR UPLOCK SENSOR OUT OF ADJ.SDR CA010301012Solenoid Valve · failed(CAN) THE FLIGHT CREW REPORTED A RED GEAR UNSAFE LIGHT ASSOCIATED WITH THE NOSE LANDING GEAR WHEN GEAR WAS SELECTED DOWN DURING APPROACH. THE CREW INITIATED AN OVERSHOOT, AND PRFORMED AN ALTERNATE EXTENSION. THE AIRCRAFT LANDED UNEVENTFULY. MAINTENANCE REPLACESDR CA010223010Line · leaking(CAN) A PUDDLE OF HYDRAULIC FLUID WAS NOTICED AROUND THE LT MAIN WHEEL AREA. INVESTIGATION REVEALED THAT THE LEAK WAS COMING FROM THE LT OUTBOARD ROLL SPOILER LIFT DUMP LINE.LINE REPLACED.SDR CA010223008Line · leaking(CAN) UPON ARRIVAL AT THE GATE HYDRAULIC FLUID WAS NOTICED TO BE LEAKING FROM THE LT WHEEL WELL AREA. INVESTIGATION REVEALED THAT THE AFT NR 1 DOOR CLOSE LINE WAS LEAKING.LINE REPLACED.SDR QXEA0100074Skin · misrepairedPDX- LEFT HAND OUTBOARD FLAP FAILED CLEARANCE CHECK AT REPAIR DOUBLER ON TOP OF SKIN. REPAIRED IAW DHC-8 MRD8-57-1908.SDR QXEA0100073Skin · tornPDX- RIGHT HAND NACELLE SKIN TORN LEFT HAND SIDE AT STATION XN137.35, ADJACENT TO MAIN LANDING GEAR FORWARD DOOR CUTOUT. REPAIRED IAW DHC-8 RD8-54-729.SDR QXEA0100065Skin · dentedPDX- ENGINE NACELLE RIGHT HAND SIDE, BOTTOM INBOARD SIDE IS A DENT IN SKIN, INBOARD OF OIL COOLER. REPAIRED IAW DHC-854-30-21 AND HORIZON AIR EA 9-54-266.SDR QXEA0100071Seal · tornPDX- SEAL IS TORN AND LEFT WING LOWER SURFACE TRAILING EDGE IS DAMAGED AT STATION YW139-00. REPAIRED IAW DHC-8 SRM 51-40-11 AND HORIZON AIR EA 9-57-549.SDR QXEA0100064Angle · cutPDX- RIGHT HAND ENGINE FIREWALL AFT SIDE OUTBOARD ANGLE IS CUT INTO BY TGT HARNESS. REPAIRED IAW DHC-8 RD8-54-991.SDR QXEA0100044Seat Track · damagedPDX- LEFT HAND INBOARD SEAT TRACK HAS RAISED MATERIAL AT STATION X424.124. REPAIRED IAW HORIZON AIR EA 9-53-592, AND DHC-8 RD8-53-1339, AND SRM 51-20-13, PAGES 1-4.SDR QXEA0100043Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK HAS LIGHT CORROSION ON TOP AREA AT STATION X456.500. REPAIRED IAW HORIZON AIR EA 9-53-592 AND DHC-8 RD8-53-1339, AND SRM 51-20-16, PAGE 1-4.SDR QXEA0100042Seat Track · damagedPDX- LEFT HAND INBOARD SEAT TRACK HAS PAINT MISSING THROUGH OUT THE TRACK. REPAIRED IAW HORIZON AIR EA 9-53-592 AND DHC-8 SRM 51-20-16, PAGES 1-4.SDR QXEA0100069Spar · corrodedPDX- LEFT WING FRONT SPAR LOWER SURFACE HAS FRETTING CORROSION AT STATION YW210-220. REPAIRED IAW HORIZON AIR EA 9-57-548.SDR QXEA0100068Spar · corrodedPDX- LEFT WING FRONT SPAR, UPPER SURFACE HAS FRETTING CORROSION AROUND ATTACH HOLES FOR PANEL 511AL. REPAIRED IAW DHC-8 RD8-57-811 AND SRM 51-2011, AND HORIZON AIR EA 9-57-546.SDR QXEA0100063Firewall · crackedPDX- NR 2 FIREWALL CRACKED AT INBOARD SIDE AT CORNER OF CUTOUT ON CLOSING MEMBER. REPAIRED IAW DHC-8 RD8-54-109, PAGE 3.SDR QXEA0100062Angle · chafedPDX- LEFT HAND ENGINE FIREWALL APERTURE ANGLE IS CHAFED ON FRONT FLANGE RADIUS AND EDGE OF ANGLE NEAR TGT HARNESS AREA. REPAIRED IAW DHC-8 RD8-54-991.SDR QXEA0100054Skin · dentedPDX- LEFT HAND SIDE OF FUSELAGE THERE IS A DENT JUST FORWARD OF AFT CARGO DOOR, BELOW FLOOR LEVEL. REPAIRED IAW HORIZON AIR EA 9-53-590.SDR QXEA0100051Arm · gougedPDX- NOSE LANDING GEAR TRAILING ARM HAS A GOUGE WITH RAISED METAL. REPAIRED IAW DHC-8RD 8-32-289.SDR QXEA0100052Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK AT STATION X257 HAS PITTING CORROSION. REPAIRED IAW HORIZON AIR EA 9-53-589 AND DHC-8 RD8-53-1339.SDR QXEA0100049Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION AT STATION X376.110. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100048Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION AT STATION X405.737. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100047Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION AT STATION X434.500. REPAIRED IAW DHC-8 RD8-53-1342.SDR QXEA0100046Seat Track · corrodedPDX- LEFT HAND OUTBOARD SEAT TRACK HAS SOME SMALL PITTING AT STATION X307.400. REPAIRED IAW DHC-8 SRM 51-40-00, PAGES 1-4 AND RD8-51-102 AND RD8-53-1339.SDR QXEA0100045Seat Track · corrodedPDX- LEFT HAND INBOARD SEAT TRACK HAS LIGHT PITTING ON TOP AT STATION X282.400. REPAIRED IAW DHC-8 RD8-53-1339.SDR QXEA0100032Seat Track · gougedPDX- RIGHT HAND INBOARD SEAT TRACK HAS MISSING MATERIAL AND GOUGED UPAT STATION X434.500. REPAIRED IAW DHC-8 RD8-53-1339.SDR HNAA0100003Battery Pack · dischargedFIRST TWO FLOOR LEVEL EMERGENCY EXIT LIGHTS INOP. REPLACED EMERGENCY LIGHT BATTERY PACK.SDR QXEA0100056Clip · crackedPDX- CLIP CRACKED BELOW LEFT HAND EMERGENCY EXIT. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA0100055Clip · crackedPDX- CLIP CRACKED AT FRAME 333 OUTBOARD OF LEFT HAND OUTBOARD SEAT TRACK. REPAIRED IAW DHC-8 SRM 51-40-11.SDR QXEA0100039Seat Track · damagedPDX- RIGHT HAND OUTBOARD SEAT TRACK HAS RAISED MATERIAL AT STATION X280.400. REPAIRED IAW HORIZON AIR EA 9-53-587 AND DHC-8 RD8-53-1342, AND SRM 51-20-16.SDR QXEA0100038Seat Track · damagedPDX- RIGHT HAND OUTBOARD SEAT TRACK HAS RAISED MATERIAL AT STATION X361.050. REPAIRED IAW HORIZON AIR EA 9-53-587 AND DHC-8 RD8-53-1342 AND SRM 51-20-13.SDR QXEA0100036Seat Track · corrodedPDX- RIGHT HAND OUTBOARD SEAT TRACK HAS LIGHT CORROSION ON TOP SIDE AT STATION X280.400. REPAIRED IAW HORIZON AIR EA 9-53-587 AND DHC-8 RD8-53-1342 AND SRM 51-20-13.SDR QXEA0100035Seat Track · corrodedPDX-RIGHT HAND OUTBOARD SEAT TRACK HAS PITTING ON TOP SIDE AT STATION X264.100. REPAIRED IAW DHC-8 RD8-53-1342 AND SRM 51-20-16, AND HORIZON AIR EA 9-53-587.SDR QXEA0100070Spar · corrodedPDX- LEFT WING FRONT SPAR, LOWER SURFACE HAS FRETTING CORROSION AT STATION YW 48-82. REPAIRED IAW DHC-8 RD8-57-811 AND RD8-57-1150.SDR QXEA0100061Flange · tool damagePDX- VERTICAL STAB LEADING EDGE SPAR ATTACH FLANGE FOR LEADING EDGE 321GT HAS TOOLING SCRATCH ON LEFT HAND FLANGE. REPAIRED IAW DHC-8 51-10-00 AND SRM 51-20-16.SDR QXEA0100060Flange · tool damagePDX- VERTICAL STAB LEADING EDGE SPAR ATTACH FLANGE FOR LEADING EDGE 321GT HAS TOOLING SCRATCH ON RIGHT HAND FLANGE. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-10-00.SDR QXEA0100059Flange · tool damagePDX- VERTICAL STAB LEADING EDGE SPAR ATTACH FLANGE FOR LEADING EDGE 321GT HAS TOOLING GOUGES. REPAIRED IAW DHC-8 SRM 51-10-00 AND SRM 51-20-16.SDR QXEA0100057Fairing · corrodedPDX- TWO AREAS OF CORROSION AT FORWARD END OF LEFT WING ROOT FAIRING BETWEEN STA X312 AND X333 AND IN LINE WITH Z168. REPAIRED IAW DHC-8 SRM 51-10-00 AND SRM 51-20-16.SDR QXEA0100033Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS PITTING ON TOP SIDE AT STATION X300.400. REPAIRED IAW DHC-8 RD8-53-1339 AND HORIZON AIR EA 9-53-588.SDR QXEA0100031Seat Track · corrodedPDX- RIGHT HAND INBOARD SEAT TRACK HAS PITTED AREA AT STATION X519.000. REPAIRED IAW HORIZON AIR EA 9-53-588 AND DHC-8 RD8-53-1339.SDR AU010038Tape · loose(AUS) LT PROPELLER BLADE LEADING EDGE TAPE LOOSE ON ONE BLADE.
Back to Boeing DHC-8-102