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 QXEA9900446Angle · crackedPDX - RIGHT-HAND FORWARD WING SPAR TO FUSELAGE CLOSING ANGLE IS CRACKED. REPAIRED IAW SRM 51-41-11.SDR HNAA9900028Power Supply · inoperativeNUMEROUS INTERIOR AND EXTERIOR EMERGENCY LIGHTS INOPERATIVE. REPLACED 3351-PS2 POWER SUPPLY, OPERATIONAL CHECK GOOD.SDR QXEA9900531Tip · crackedYXX - RIGHT-HAND WING TIP UPPER ANCHOR NUT LAND CRACKED. REPAIRED IAW DHC-8 RD 8-57-1331, CONAIR EO 2223 AND HORIZON AIR EA 9-57-403.SDR QXEA9900526Skin · chafedYXX - NR 1 NACELLE AFT FINGERNAIL DECK SKIN CHAFED AT STA 236. REPAIRED IAW DHC-8 RD 8-54-376, 8-54-1032 AND DHC-8 SRM 51-40-00.SDR QXEA9900453Clip · corrodedPDX - FRAME CLIP CORRODED AT STRINGER 31R AND STATION 510. REPAIRED IAW SRM 53-00-16.SDR QXEA9900447Angle · crackedPDX - LEFT-HAND FORWARD WING SPAR TO FUSELAGE CLOSING ANGLE IS CRACKED. REPAIRED IAW SRM 51-40-11.SDR CA990330001Pin · loose(CAN) AIRCRAFT NOSED OVER ON G/S.SDR QXEA9900455Clip · corrodedPDX - FRAME CLIP CORRODED AT STRINGER 32R AND STATION 545. REPAIRED IAW SRM 53-00-16, PARAGRAPH 1, TABLE 1.SDR QXEA9900454Clip · corrodedPDX - FRAME CLIP CORRODED AT STRINGER 31R AND STATION 545. REPAIRED IAW SRM 53-00-16, PARAGRAPH 1, TABLE 1.SDR QXEA9900452Clip · crackedPDX - FRAME CLIP CRACKED AT STRINGER 31R AND STATION 222.7. REPAIRED IAW SRM 53-20-21, PAGE 1.SDR QXEA9900448Sill · corrodedPDX - SLIGHT CORROSION ON TOP SURFACE OF LOWER SILL AT RIGHT-HAND CENTER EMERGENCY EXIT AT AFT INBOARD NUT PLATE. REPAIRED IAW SRM 51-00-04.SDR QXEA9900533Spar · scratchedYXX - RIGHT-HAND WING FUEL BAY INTERNAL STATION YW288 LOWER SPAR FLANGE HAS 2 SCRATCHES. REPAIRED IAW DHC-8 SRM 51-20-11 AND SRM 51-20-16.SDR QXEA9900520Seat Track · corrodedYXX - LEFT-HAND INBOARD SEAT TRACK HAS CORROSION. REPAIRED IAW DHC-8 RD 53-1339, STEP 1, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9900519Seat Track · corrodedYXX - MINOR CORROSION FOUND ON RIGHT-HAND INBOARD SEAT TRACK. REPAIRED IAW DHC-8 RD 53-1339, STEP 1, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9900518Seat Track · corrodedYXX - RIGHT-HAND OUTBOARD SEAT TRACK HAS MINOR CORROSION. REPAIRED IAW DHC-8 SRM 51-20-16 AND 51-20-30.SDR QXEA9900515Skin · dentedYXX - FOUR DENTS IN FUSELAGE SKIN AT STATION 312 TO 333 BELOW STRINGER 23 ON LEFT-HAND SIDE. REPAIRED IAW DHC-8 RD8-53-4038 AND SRM 51-40-00.SDR QXEA9900511Seat Track · corrodedYXX - SEAT TRACK CORROSION RIGHT SIDE CENTER AT STATION 600. REPAIRED IAW DHC-8 SRM 51-40-00 AND SRM 51-20-26.SDR QXEA9900435Castellation · crackedPDX - FRAME 4 HAS CRACKED CASTELLATION AT STRINGER 12S. REPAIRED IAW SRM 53-20-21.SDR QXEA9900434Castellation · crackedPDX - FRAME 4 HAS CRACKED CASTELLATION AT STRINGER 12P. REPAIRED IAW SRM 53-20-21.SDR QXEA9900310Mechanism · lack of lubeSEA- THE MAIN CABIN DOOR LEVER IS VERY HARD TO OPEN FROM THE INSIDE. MAINTENANCE CLEANED AND LUBRICATED THE DOOR STOPS, OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR HNAA9900031Seat Track · corrodedLEFT FORWARD INBOARD SEAT TRACK HAS CORROSION BEYOND LIMITS. REPLACED SEAT TRACK.SDR QXEA9900530Spar · scratchedYXX - LEFT-HAND WING FORWARD SPAR CAP FLANGE SCRATCHED IN RADIUS AT STATION YW97.00. REPAIRED IAW DHC-8 SRM 51-20-16 AND 51-20-36.SDR QXEA9900527Skin · damagedYXX - NR 1 NACELLE INBOARD AND OUTBOARD SIDE RIVETS PULLED THROUGH SKIN AT STA 134.55 AND ZN15. REPAIRED IAW CONAIR EO 2224, HORIZON AIR EA 9-54-188 AND DHC-8 RD 8-54-953.SDR QXEA9900524Skin · damagedYXX - NR 2 NACELLE INBOARD AND OUTBOARD AT STA 130.60, RIVETS ARE PULLED THROUGH SKIN. REPAIRED IAW DHC-8 RD 8-54-953.SDR AU990150Line · chafed(AUS) HYDRAULIC PIPE SEVERELY CHAFED ON UNION P/N 824-6D. PIPE WALL WAS APPROXIMATELY 90 PERCENT WORN THROUGH. FOUND DURING INSPECTION IAW AD/DHC8/47.SDR QXEA9900522Sill · gougedYXX - GOUGING DAMAGE TO RIGHT-HAND SIDE WINDOW SILL AT BOTTOM FORWARD CORNER. REPAIRED IAW DHC-8 SRM 51-20-16, 51-20-36 AND SRM 51-40-11.SDR QXEA9900514Skin · dentedYXX - THREE DENTS BEYOND LIMITS FROM STATION 312.5 TO 333.3, ABOVE AND BELOW STRINGER 10, UNDER ICE SHIELD. REPAIRED IAW DHC-8 RD 8-53-403, SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9900540Plate · corrodedYXX - RIGHT-HAND WING UPPER SURFACE LADDER PLATE CORROSION AND LADDER PLATE O-RING GROOVE CORROSION AT STATION YW333.0 TO YW405.0. REPAIRED IAW DHC 8 RD 8-57-1252 AND DHC 9 SRM 51-20-16.SDR QXEA9900539Plate · corrodedYXX - RIGHT-HAND WING UPPER SURFACE LADDER PLATE CORROSION AND LADDER PLATE O-RING GROOVE CORROSION AND SCRATCHES AT STATION YW261.0 TO YW333.0. REPAIRED IAW DHC 8 RD 8-57-633, 8-57-1252 AND DHC 8 SRM 51-20-16.SDR QXEA9900538Plate · corrodedYXX - RIGHT-HAND WING UPPER SURFACE LADDER PLATE CORROSION AND O-RING GROOVE CORROSION AT STATION YW171.2 TO YW261.0. REPAIRED IAW DHC-8 RD 8-57-1252 AND DHC-8 SRM 51-20-16.SDR QXEA9900537Plate · corrodedYXX - LEFT-HAND WING UPPER SURFACE LADDER PLATE CORROSION AND LADDER PLATE O-RING GROOVE CORROSION AT STATION YW261.0 TO YW333.0. REPAIRED IAW DHC 8 SRM 51-20-16 AND DHC-8 RD 8-57-633.SDR QXEA9900536Plate · corrodedYXX - LEFT-HAND WING UPPER SURFACE LADDER PLATE CORROSION AT STATION YW171.2 TO YW261.0. REPAIRED IAW DHC-8 RD 8-57-611 AND DHC-8 SRM 51-20-16.SDR QXEA9900535Plate · corrodedYXX - LEFT-HAND WING UPPER SURFACE LADDER PLATE CORROSION AND LADDER PLATE O-RING GROOVE CORROSION. REPAIRED IAW DHC-8 RD 8-57-1252, 8-57-984 AND DHC-8 SRM 51-20-16.SDR QXEA9900457Wall · crackedPDX - LEFT-HAND WALL OF NOSE GEAR WHEEL WELL IS CRACKED THROUGH A PREVIOUS REPAIR AT STATION 57. REPAIRED IAW RD 8-53-675.SDR QXEA9900529Spar · corrodedYXX - LEFT-HAND WING FORWARD SPAR AT YW5700 LOWER SPAR CAP FLANGE HAS FRETTING CORROSION AND BARE ALUMINUM AROUND ANCHOR NUTS. REPAIRED IAW DHC-8 SRM 51-20-16 AND SRM 51-20-36.SDR QXEA9900528Spar · gougedYXX - RIGHT-HAND WING UPPER AND LOWER SPAR CAP FLANGE, OUTBOARD OF NACELLE FROM STATION YW171.400 TO YW490 HAS MANY GOUGES. REPAIRED IAW DHC-8 RD 8-57-1119 AND SRM 51-20-16, 51-20-36.SDR QXEA9900449Seat Track · damagedPDX - PILOTS SEAT TRACKS HAVE LOOSE OR MISSING REPAIR BUSHINGS. REPLACED BUSHINGS IAW RD 8-53-219.SDR QXEA9900436Fitting · corrodedPDX - LEFT-HAND NACELLE HAS MINOR FRETTING CORROSION UNDER MAIN LANDING GEAR RETRACTION ACTUATOR ATTACHMENT FITTING. REPAIRED IAW RD 8-54-735.SDR CA990310031Switch · contaminated(CAN) TAKEOFF WARNING DUE TO NR 2 CONDITION LEVER SWITCH 3151-S4. CLEANED AND ADJUSTED.SDR HNAA9900027Wire · chafedFORWARD CABIN EMERGENCY EXIT SIGNS INOPERATIVE. FOUND AFTER CHANGING EMERGENCY BATTERIES FOR SCHEDULED MAINTENANCE. REPAIRED CHAFED WIRES AND REPLACED DIODE AT RIGHT HAND CABIN SIDE WALL, OPERATIONAL CHECK GOOD.SDR CA990224012Control Cable · loose(CAN) OPERATOR REPORTED FLAPS JAMMED AT 4 DEGREES. FOUND THE LEFT SECONDARY CABLE TWISTED WITH ONE STRAND LOOSE JAMMING THE CABLE IN THE SLEEVE.SDR QXEA9900525Skin · damagedYXX - NR 2 NACELLE OUTBOARD SKIN AT STA 179.10 HAS RIVETS PULLED THROUGH STRAP. REPAIRED IAW DHC-8 SRM 51-20-36, 51-20-16 AND RD 8-54-215.SDR QXEA9900287Handle · dirtyPDX- MAIN CABIN DOOR HANDLE IN CABIN IS HARD TO OPERATE. MAINTENANCE CLEANED THE SEAL CONTACT AREA FOR THE TOP OF THE MAIN CABIN DOOR. OPERATIONAL CHECKS GOOD. NO PARTS REPLACED.SDR HNAA9900025Control Box · failedCABIN EMERGENCY LIGHTS COME ON WHEN FLIGHT DECK SWITCH IS IN OFF POSITION. REPLACED EMERGENCY LIGHTS CONTROL BOX.SDR AU990109Frame · cracked(AUS) FUSELAGE FRAME LOCATED AT STN 354.25 CRACKED FROM THE OUTSIDE EDGE TO THE LIGHTENING HOLE IN THE AREA BETWEEN STRINGER 21S AND STRINGER 22S (RT). PART TC: 24,813.SDR HNAA9900024Connector · dirtySMOKE WARNING LIGHT ILLUMINATED FOR 3-4 SECONDS ON SHORT FINAL, AFTER LANDING AND DURING ROLLOUT FOR 3-4 SECONDS. POST FLIGHT INSPECTION FOUND NO SMOKE OR FUMES IN BAG BAY. CLEANED CANNON PLUGS ON BOTH SMOKE DETECTORS IN BAG BAY. TESTED OPERATIONAL CHECK OKSDR CA990310022Light · failed(CAN) F/A REPORTED ELECTRICAL SMELL IN FORWARD GALLEY. AIR SUPPLY TUBE FOR GASPER FOUND RESTING ON TOP OF LAMP ASSY. TUBE RE-ROUTED.SDR CA990310017Terminal Block · burnt(CAN) NR 1 AC AUXILIARY FUEL PUMP NOT WORKING, CIRCUIT BREAKER TRIPPED. TERMINAL BLOCK 2821 TBL FOUND BURNT THROUGH.SDR CA990310016Pump · failed(CAN) ON GEAR DOWN EXTENSION, GEAR DOORS OPENED BUT GEAR DID NOT EXTEND, NR 2 HYDRAULIC CAUTION LIGHTS ILLUMINATED. ALTERNATE GEAR EXTENSION CARRIED OUT, AIRCRAFT LANDED......NR 2 EDP REPLACED, SUSPECT AIR IN SYSTEM.SDR QXEA9900308Control Head · failedSEA- ELECTRICAL SMELL IN COCKPIT. MAINTENANCE INSPECTED AND DETERMINED TO BE FROM THE ADF CONTROL HEAD. REPLACED ADF CONTROL HEAD, OPERATIONAL CHECK GOOD.
Back to Boeing DHC-8-102