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 QXEA0002361Skin · gougedYXX- LEFT HAND WING CENTER SECTION OF UPPER SKIN AT YW70.00 HAS GOUGE. REPAIRED IAW DHC-8 SRM 51-20-11, 57-10-16 PAGE 2 AND 51-20-00 PAGE 5.SDR QXEA0002360Skin · gougedYXX- THREE GOUGES ON LEFT HAND UPPER WING SKIN BETWEEN YW139.000 AND YW171.000. REPAIRED IAW DHC-8 SRM 51-20-11, AND 57-10-16 PAGE 2.SDR QXEA0002355Structure · crackedYXX- RIGHT HAND NACELLE FOUND TO HAVE TWO CRACKS ABOVE ACCESS HOLES FOR MAIN LANDING GEAR RETRACT ACTUATOR ATTACH HARDWARE. REPAIRED IAW DHC-8 RD 8-54-109 PAGE 3 AND 4, SRM 54-00-00 PAGE 1 AND 20-21-18.SDR QXEA0002353Structure · crackedYXX- CRACKED STRUCTURE ON NR 2 NACELLE BETWEEN MID DOOR''S FORWARD HINGE AND FORWARD BRACKET OF EXTENSION HANDLE. REPAIRED IAW DHC-8 RD 8-54-239 AND SRM 51-40-11 PAGES 1-4 AND 32-10-21.SDR QXEA0002337Skin · dentedYXX- LEFT HAND FUSELAGE HAS A DENT JUST AFT OF STATION X636.00 BETWEEN STRINGER 16 AND 15. REPAIRED IAW DHC-8 SRM 53-00-16, 51-00-06, 51-00-05, RD 8-53-5230 AND HORIZON AIR EO 2857.SDR QXEA0002336Skin · dentedYXX- LEFT HAND FUSELAGE JUST FORWARD OF MAIN CABIN DOOR THERE IS A DENT FORWARD OF STATION X545.00 BETWEEN STRINGER 22 AND 23. REPAIRED IAW DHC-8 SRM 51-20-26, 53-00-16 AND 51-00-06.SDR PCAA0008056Skin · crackedMDT - DURING A FLEET INSPECTION THE REAR FUSELAGE AT FRAME 4 STRINGER 5 WAS FOUND CRACKED. REPAIRS WERE MADE IAW DHC RD8-55-535 AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR QXEA0002373Skin · chafedYXX- MAIN CABIN DOOR OUTER SHELL HAS CHAFE DAMAGE ON INTERIOR LIP, 18 INCHES FROM DOOR CABLE ATTACH POINT. REPAIRED IAW DHC-8 SRM 52-00-16 AND 51-20-16 PAGE 1-5.SDR QXEA0002354Firewall · crackedYXX- RIGHT HAND NACELLE FIREWALL FOUND CRACKED ABOVE INBOARD END OF OIL COOLER. REPAIRED IAW DHC-8 SRM 51-40-11, 54-00-00 PAGE 1 AND 20-21-18.SDR QXEA0002326Skin · dentedYXX- LEFT HAND FUSELAGE HAS DENTS BETWEEN 30 AND 31 AT STATION X151.600. REPAIRED IAW DHC-8 RD 8-53-5206, DHC-8 SRM 53-00-16 AND 51-00-05.SDR QXEA0002325Skin · dentedYXX- RIGHT HAND FUSELAGE HAS DENT BETWEEN STRINGER 29 AND 30 AT STATION X182.00. REPAIRED IAW HORIZON AIR EA 9-53-561 AND DHC-8 SRM 51-00-05.SDR QXEA0002312Threshold · corrodedYXX- SEVERAL AREAS OF PITTING AND SURFACE CORROSION ON THRESHOLD OF MAIN CABIN DOOR CUTOUT, AT FLOOR LEVEL BETWEEN FUSELAGE STATION 222.000AND X252.700. REPAIRED IAW DHC-8 SRM 51-20-00, 51-40-00 AND 20-21-21.SDR QXEA0002332Skin · dentedYXX- LEFT HAND FUSELAGE HAS DENT AND GOUGE BETWEEN STRINGER 17 AND 19 AT FRAME 151.600. REPAIRED IAW DHC-8 SRM 53-00-16, 51-20-11 AND 51-00-06.SDR QXEA0002315Seat Track · corrodedYXX- LEFT HAND OUTBOARD FORWARD SEAT TRACK HAS PITTING CORROSION WHERE SEATS ATTACH TO TRACK. REPAIRED IAW DHC-8 SRM 51-40-00 AND 51-40-11.SDR CA001228011Doubler · cracked(CAN) DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME NR 4, STRINGER NR 4 PORT SIDE, CRACK WAS REPAIRED USING DEHAVILLAND REPAIR DWG (RD8-55-199).SDR CA001228010Doubler · cracked(CAN) DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME NR 4, STRINGER NR 4 PORT SIDE, CRACK WAS REPAIRED USING DEHAVILLAND REPAIR DWG (RD8-55-199).SDR QXEA0002370Structure · chafedYXX- RIGHT HAND EMERGENCY EXIT DOOR, BOTTOM AFT CORNER OF DOOR HAS CHAFE DAMAGE TO DOOR STRUCTURE AND RIVETS. REPAIRED IAW DHC-8 SRM 51-20-00 PAGE 5, 51-40-11 PAGE 1-4 AND 52-00-16 TABLE 2.SDR PCAA0008054Structure · crackedMDT - DURING A FLEET INSPECTION THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4, STRINGER 4 ON THE LEFT SIDE. REPAIRS WERE MADE IAW RD8-55-199 AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR PCAA00087054Structure · crackedMDT - DURING A FLEET INSPECTION THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4, STRINGER 4, LEFT SIDE. REPAIRS WERE DONE IAW RD8-55-199 AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR PCAA0008053Structure · crackedMDT - DURING A FLEET INSPECTION THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4, STRINGER 4, RIGHT SIDE. REPAIRS WERE MADE IAW RD8-55-199 AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR QXEA0002346Intercostal · corrodedYXX- RIGHT HAND FORWARD OUTBOARD SEAT TRACK INTERCOSTAL TO FRAME X356, Z102 AND Y42 HAVE CORROSION. REPAIRED IAW DHC-8 SRM 53-00-16, 51-20-00 PAGE 5 AND 51-20-11.SDR QXEA0002260Strut · failedPDX- MAIN CABIN DOOR HARD TO OPEN FROM INSIDE. REMOVED AND REPLACED LIFTING ACTUATOR. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR QXEA0002259Stop · out of adjPDX- FLIGHT ATTENDANT UNABLE TO OPEN MAIN CABIN DOOR FROM INSIDE, HANDLE IS STIFF. ADJUSTED DOOR STOPS, CLEANED AND LUBED ROLLERS. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR CA001228005Doubler · cracked(CAN) DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURES WAS FOUND CRACKED AT FRAME NR 4, STRINGER NR 4 PORT SIDE/AFT FUSE, CRACK WAS REPAIRED USING DEHAVILLAND REPAIR DWG (RD8-55-199).SDR CA001228009Doubler · cracked(CAN) DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME #4, STRINGER #4 PORT SIDE/AFT FUSE, CRACK WAS REPAIRED USING DEHAVILLAND REPAIR DWG (RD8-55-199).SDR CA001221002Controller · smoke(CAN) SAHS CONTROL PANEL STARTED TO SMOKE IN FLIGHT. EMERGENCY DECLARED & A/C LANDED WITHOUT FURTHER INCIDENT. PROBLEM CONFIRMED TO BE SAHS STANDBY CONTROL. ASSEMBLY REMOVED AND REPLACED, OPS CHECKED SATISFACTORY, A/C RETURNED TO SERVICE.SDR PCAA0008048Structure · crackedMDT - DURING SPOT INSPECTION, THE REAR FUSELAGE STRUCTURE AT FRAME 4 STRINGER 4 ON THE RIGHT SIDE WAS FOUND CRACKED. REPAIRS WERE MADE IAW DHC RD8-55-199. AIRCRAFT WAS RETURNED TO SERVICE.SDR CA001228008Doubler · cracked(CAN) DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME NR 4, STRINGER NR 4 PORT SIDE/AFT FUSE, CRACK WAS REPAIRED USING DEHAVILLAND REPAIR DWG (RD8-55-199).SDR CA001228007Doubler · cracked(CAN) DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURES WAS FOUND CRACKED AT FRAME NR 4, STRINGER NR 4, PORT SIDE/AFT FUSE, CRACK WAS REPAIRED USING DEHAVILLAND REPAIR DWG (RD8-55-199).SDR CA001228006Doubler · cracked(CAN) DURING A FLEET INSPECTION, REAR FUSELAGE STRUCTURES WAS FOUND CRACKED AT FRAME NR 4, STRINGER NR 4, PORT SIDE/AFT FUSE, CRACK WAS REPAIRED USING DEHAVILLAND REPAIR DWG (RD8-55-199).SDR QXEA0002343Frame · gougedYXX- AFT FACE OF FRAME X240.50 BETWEEN STRINGER 19 AND 22 HAVE MINOR SCRATCHES AND GOUGES. REPAIRED IAW DHC-8 SRM 51-20-11, 53-00-16 AND 51-20-00.SDR PCAA0008052Structure · crackedMDT - DURING A SPOT INSPECTION, THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED AT FRAME 4 STRINGER 4, BOTH SIDES. REPAIRS WERE MADE IAW RD8-55-199. AIRCRAFT WAS RETURNED TO SERVICE.SDR PCAA0008051Structure · crackedMDT - DURING A SPOT INSPECTION, THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED ON THE LEFT SIDE AT FRAME 4 STRINGER 4. REPAIRS WERE MADE IAW RD8-55-965. AIRCRAFT WAS RETURNED TO SERVICE.SDR PCAA0008050Structure · crackedMDT - DURING A SPOT INSPECTION THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED, LEFT AND RIGHT SIDES AT FRAME 4 STRINGER 4. REPAIRS WERE MADE IAW DHC RD8-55-199. AIRCRAFT WAS RETURNED TO SERVICE.SDR PCAA0008049Structure · crackedMDT - DURING A SPOT INSPECTION, THE REAR FUSELAGE STRUCTURE WAS FOUND CRACKED ON THE RIGHT SIDE AT FRAME 4 STRINGER 4. REPAIRS WERE MADE IAW DHC RD8-55-199. AIRCRAFT WAS RETURNED TO SERVICE.SDR CA000824004Pseu · failed(CAN) TIME SINCE REPAIR 11145.ON TAKEOFF, ROLL SPOILER INBOARD GROUND, ROLL SPOILER OUTBOARD GROUND CAUTION LIGHTS ILLUMINATED. TAKEOFF REJECTED. POWER LEVER MICRO SWITCHES CHANGED. FOUND CARD 1A FAULT (CODE S4) ON PSEU. PSEU REPLACED AND AIRCRAFT RETURNED TO SDR CA000804007Pseu · failed(CAN) ROLL SPOILER INBOARD / OUTBOARD GROUND CAUTION LIGHTS ILLUMINATED WHEN POWER LEVERS ADVANCE. DURING GROUND RUNS. FAULT PERSISTED WITH AUTO-FEATHER ON OR OFF. DRIVER FAULT ON PSEU. PSEU REPLACED, MICRO SWITCHES CLEANED AND AIRCRAFT RETURNED TO SERVICE.SDR QXEA0002323Skin · corrodedYXX- CORROSION AROUND MARKER BEACON ANTENNA. REPAIRED IAW DHC-8 SRM 53-00-16, 51-20-11 AND 51-20-00.SDR QXEA0002316Seat Track · corrodedYXX- LEFT HAND INBOARD FORWARD SEAT TRACK HAS EVIDENCE OF PITTING CORROSION AT SEAT ATTACH SPOTS. REPAIRED IAW DHC-8 AD 8-53-3074 AND 8-53-1339.SDR QXEA0002365Skin · unbondedYXX- RIGHT HAND AILERON TIP TRAILING EDGE IS DISBONDING. REPAIRED IAW DHC-8 SRM 57-60-63.SDR QXEA0002345Seat Track · corrodedYXX- SURFACE CORROSION ON RIGHT HAND INBOARD SEAT TRACK AT CARGO HOLD DOWN ATTACH POINT X597.500 AND 9.250. REPAIRED IAW DHC-8 SRM 51-20-00 PAGE 5 AND RD 8-53-4936.SDR QXEA0002335Skin · scratchedYXX- CARGO DOOR SKIN IS SCRATCHED AT X581 AND STRINGER 14L. REPAIRED IAW DHC-8 SRM 51-20-26 AND 51-20-36.SDR QXEA0002330Skin · gougedYXX- LEFT HAND FUSELAGE EXTERIOR SKIN HAS A GOUGE BETWEEN STRINGER 16 AND 17 AT STATION X424.124. REPAIRED IAW DHC-8 SRM 53-00-16 AND 51-20-00 PAGE 5.SDR QXEA0002322Skin · corrodedYXX- CORROSION AROUND DME ANTENNA. REPAIRED IAW DHC-8 SRM 51-20-11 PAGE 7-8 AND 53-00-16 PAGE 3.SDR QXEA0002321Structure · crackedYXX- CRACKS IN INNER RIGHT HAND STRUCTURE OF NOSE LANDING GEAR WHEEL WELL ABOVE RETRACT ACTUATOR ATTACH FITTING. ALSO, ONE SHREDDED RIVET IN AREA. REPAIRED IAW DHC-8 RD 8-53-5209, HORIZON AIR EA 9-53-562 AND DHC-8 SRM 51-00-06.SDR QXEA0002320Seat Track · corrodedYXX- RIGHT HAND INBOARD AFT SEAT TRACK HAS CORROSION WHERE SEATS ATTACH. REPAIRED IAW DHC-8 AD 8-53-1339 AND DHC-8 SRM 51-00-06 AND 51-20-00 PAGE 5.SDR QXEA0002317Seat Track · corrodedYXX- LEFT HAND INBOARD AFT SEAT TRACK HAS PITTING CORROSION WHERE SEATS ATTACH TO TRACK. REPAIRED IAW DHC-8 AD 8-53-1339 AND DHC-8 SRM 51-20-00 PAGE 5.SDR QXEA0002314Seat Track · corrodedYXX- LEFT HAND OUTBOARD AFT SEAT TRACK HAS PITTING CORROSION. REPAIRED IAW DHC-8 SRM 51-20-00 PAGE 5.SDR QXEA0002311Bracket · corrodedYXX- CORROSION AT INBOARD AFT WARDROBE ATTACH BRACKET OF FUSELAGE STATION X222.00 AT LEFT HAND INBOARD SEAT TRACK. REPAIRED IAW DHC-8 SRM 51-20-00 PAGE 5 AND 53-00-16 TABLE 2.SDR QXEA0002310Floorbeam · corrodedYXX- CORROSION ON FLOORBEAM AROUND RIVET AT FUSELAGE STATION X222.000 ONE FOOT INBOARD OF FORWARD EDGE OF MAIN CABIN DOOR. REPAIRED IAW DHC-8 SRM 51-20-00 AND 53-00-16 TABLE 2.
Back to Boeing DHC-8-102