JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, newest first.
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 jasc_code = '5310' 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 jasc_code = '5310' 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 CALA0300586Support Beam · corrodedINSPECTION FOUND MAIN DECK LT AND RT LAV WALL SUPPORT BEAMS CORRODED AT STA 993, LBL14-44 AND RBL 14-44. NEW SUPPORT BEAMS WERE INSTALLED IAW SRM 51-10-2.SDR QXEA200301336Door Frame · chafedWEB CHAFED ABOVE BAG DOOR CUTOUT AT FRAME X564.5. REPAIRED IAW RD 8-53-5461.SDR QXEA200301335Door Frame · chafedPDX - WEB CHAFED ABOVE BAG DOOR CUTOUT AT FRAME X580.5. REPAIRED IAW RD 8-53-5461.SDR UPS03441459Beam · crackedINSPECTION TYPE: C, LT SIDE BS 300 NOSE WHEEL WELL VERTICAL BEAM WEB ONE CRACK REVEALED AT INSULATION BLANKET STAND OFF HOLE BETWEEN 1 TO 2 HORIZONTAL STIFFENERS (COUNT FROM UPPER) AS MARKED. VERTICAL WEB REPLACED AS PER SRM 51-10-01 PG 8.SDR IXXA060518STorque Box · crackedDURING ROUTINE C CHECK, FOUND L-2 DOOR CUTOUT LOWER FORWARD TORQUE BOX WEB CRACKED. REMOVED DAMAGED WEB. FABRICATED NEW WEB, LOCATED, DRILLED, TRIMMED, TREATED, PRIMED, AND INSTALLED NEW REPAIR PARTS IAW DC8 SRM 51-1-21, 53-2-0, 51-1-8, 51-1-20D, AND DOUGLASSDR C2XA03SH375Crossbeam · corrodedDURING C-CHECK THE CROSSBEAM AT FRAME 22 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED CROSSBEAM IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR MWEA030406Door Frame · bentFORWARD GALLEY DOOR IS CATCHING ON DOOR JAMB, JAMB IS BENT AT TWELVE O'CLOCK POSITION. STRAIGHTENED EDGE, FABRICATED AND INSTALLED DOUBLER.SDR C2XA03SH370Buttstrap · corrodedDURING C-CHECK THE CENTER BUTTSTRAP BETWEEN FRAMES 17 AND 18 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR CALA0300575Door Frame · corrodedINSPECTION FOUND AFT CARGO COMPARTMENT LOWER DOOR JAMB CORRODED. A SPACER WAS FABRICATED AND INSTALLED IAW SRM 53-05.SDR 2003UALA00763Door Frame · gougedFORWARD CARGO DOOR FRAME GOUGED STA 490. MAJOR REPAIR ACCOMPLISHED. BLENDED AREA AND INSTALLED REPAIR PARTS.SDR SWAA032216Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CORRODED AT BS 500C + 8, LT SIDE. REPAIRED CREASE BEAM PER SRM.SDR CALA0300573Door Frame · corrodedINSPECTION FOUND MID BAGGAGE BIN LOWER DOOR JAMB CORRODED. A SPACER WAS FABRICATED AND INSTALLED IAW SRM 53-05.SDR CALA0300572Door Frame · crackedINSPECTION FOUND A 7 INCH CRACK IN FORWARD CARGO FORWARD DOOR FRAME CUTOUT POST AT STA 500. THE CRACK WAS STOP DRILLED AND A REPAIR WAS INSTALLED IAW ECRA 5310-04374. A DIP WAS ISSUED TO INSTALL A PERMANENT REPAIR WITHIN 4000 CYCLES NOT TO EXCEED 24 MONTHS.SDR C2XA03SH369Buttstrap · corrodedSHV-DURING C CHECK THE FWD DIGITAL BUTTSTRAP AT FR 14 TO FR 16 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-01. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH367Buttstrap · corrodedDURING C CHECK THE RT CENTER BUTT STRAP FROM FR 20 TO FR 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED AFFECTED MEMBER IAW EMB 145 SRM 53-10-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR GTIA030862Beam · crackedFOUND L1 DOOR FORWARD VERTICAL BEAM AND STRAP CRACKED/BENT. REMOVED T-ANGLE. REMOVED CRACKED STRAP. REMOVED FORWARD VERTICAL BEAM. FABRICATED REPLACEMENT VERTICAL BEAM AND STRAP. INSTALLED NEW VERTICAL BEAM, NEW STRAP AND T-ANGLE. (M)SDR QXEA200301235Crossbeam · wornFORWARD RIGHT HAND EMERGENCY EXIT UPPER FORWARD CROSSBEAM HAS STEP WEAR. REPAIRED IAW DHC-8 SRM 51-00-06 AND RD 8-52-349.SDR 03FDEA01666Structure · gougedNLG WHEEL WELL HAS NUMEROUS GOUGES AROUND RT AFT PRESSURE PANEL CUTOUT. REPAIRED AS PER SRM 51-40-2.SDR C2XA03SH362Buttstrap · corrodedDURING C CHECK THE LT BUTTSTRAP IN THE CARGO COMPARTMENT AT FR 65-68 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PART IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH359Buttstrap · corrodedDURING C CHECK THE LEFT BUTTSTRAP BETWEEN FRAMES 65 AND 68 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH358Buttstrap · corrodedDURING C CHECK THE CENTER BUTTSTRAP BETWEEN FRAMES 59 AND 61 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH356Buttstrap · corrodedDURING C CHECK THE RT BUTTSTRAP BETWEEN FRAMES 59 AND 61 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH355Buttstrap · corrodedDURING C CHECK THE AFT DIGITAL BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA032183Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BELOW STR 14L. REPAIRED SHEAR TIE PER SRM.SDR GTIA030871Door Frame · corrodedFTW - FOUND L1 DOOR LOWER JAMB CORRODED AT MATING SURFACE WHERE THRESHOLD ATTACHS. REMOVED LOWER DOOR JAMB. FABRICATED NEW PART. INSTALLED L1 LOWER DOOR JAMB. (M)SDR GTIA030841Shear Tie · corrodedFTW - FOUND MID PIT STATION 636, STATION 30-29L FRAME SUPPORT CORRODED AND STRINGER 29R-30 FRAME SUPPORT CORRODED. REMOVED SHEAR TIE. DRILL AND LOCATE NEW SHEAR TIE. INSTALLED NEW SHEAR TIE. (M)SDR 2003UALA00717Door Frame · damagedFWD LOWER FRAME OF THE FWD RT DOOR CUT-OUT HAS A PIECE MISSING. MAJOR REPAIR ACCOMPLISHED, INSTALLED DOUBLER REPAIR.SDR 03FDEA01620Stringer Clip · crackedBS 440 STR 6 LT STR CLIP CRACKED. REMOVED DAMAGED STR CLIP AT BS 440, STR 6L. DRILLED NEW STR CLIP AND INSTALLED IAW SRM 51-30-2, 51-30-5.SDR GTIA030875Beam · corrodedFOUND MID CARGO DOOR JAMB BEAM CORRODED AT FS 636-693. REMOVED JAMB BEAM. LOCATE AND DRILLED NEW JAMB BEAM. INSTALLED NEW JAMB BEAM. (M)SDR ASAA0340330Panel · corrodedGYR - DURING C-CHECK FOUND CORROSION AT ELECTRICAL DISCONNECT PANEL. REPAIRED IAW EA. (M)SDR AWXA200301241Crease Beam · corrodedDURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON RT AFT CREASE BEAM UPPER SURFACE OF BOTTOM LEG BS 940-993, RBL 52, WL 208. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED RT AFT CREASE BEAM BS 940-993, RBL 52 TO RBL 54,SDR AWXA200301238Shear Tie · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF LT AFT OUTBOARD SHEAR WEB BS 986-1016, LBL 38-46, WL 208. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED LT AFT OUTBOARD SSDR SWAA032106Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND SHEAR TIE CRACKED AT BS 360, STRINGER 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR C2XA03SH337Buttstrap · corrodedSHV-DURING C-CHECK THE LEFT HAND BUTTSTRAP BETWEEN FRAMES 19 AND 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH332Beam · corrodedSHV-DURING C CHECK THE CARGO DOOR CUT OUT LOWER BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR UPS03841424Shear Tie · crackedINSPECTION TYPE: C3, AT FUSELAGE STA 700 (APPROX) INSIDE STRESS PANEL AREA, SHEAR TIE ON LT SIDE CRACKED. FABRICATED SHEAR TIE FROM MAT 7075-0.071 AND HEAT TREATED TO T-6 IAW DAC DWG 5750365 & TPS 1003 REV A FOR HEAT TREAT. LOCATED, DRILLED, AND DEBURRED IASDR 03FDEA01569Shear Tie · corrodedCORROSION ON SHEAR TIE BETWEEN STR 26L AND 27L, BS 1050. REMOVED AND REPLACED SHEAR TIE.SDR SWAA032092Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500C, STR 28R TO STR 28L. REPAIRED SHEAR TIE SECTION PER SRM.SDR SWAA032090Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND RT CREASE BEAM CORRODED AT BS 859. REPAIRED CREASE BEAM PER SRM.SDR 03FDEA01581Shear Tie · corrodedCORROSION ON SHEAR TIE AFT SIDE OF FRAME BS 1150 BETWEEN STR 26L AND 27L. REPAIRED SHEAR TIE IAW SRM 53-10-1, 53-10-4.SDR 03FDEA01558Door Frame · dentedLOWER FWD CARGO BAY FRAME IS DENTED AT STA 600 BETWEEN STR 24 AND 25, WL 160 **SD** COMINGSDR ABXA030377Stop Fitting · crackedMAIN ENTRY DOOR AFT UPPER DOOR STOP A3, HAD CRACK FROM STOP HOLE TOWARDS DOOR OPENING APPROXIMATELY .1875 INCH LONG. REPAIRED AREA IAW DC-9 SRM AND EA 53100131-001.SDR QXEA200301145Door Frame · nickedRT AFT SERVICE DOOR APERTURE IS NICKED ON FORWARD SIDE 13.5 INCH DOWN FROM TOP. REPAIRED IAW Q400 SRM 51-14-00 AND 51-25-15.SDR MWEA030376Spacer · corrodedAFT CARGO DOOR LOWER JAMB HAS LIGHT CORROSION ALONG THE ENTIRE LENGTH AROUND AND INSIDE SCREW HOLES. FABRICATED AND INSTALLED JAMB SPACER.SDR 2004F00113Structure · corrodedAT C-CHECK, OFUND CORROSION ON AFT CABIN FLOOR STRUCTURE AT FRAME 67 PLUS 13 INCHES TO FRAME 67 AT LBL 45. REMOVED AND REPLACED AFT CABIN FLOOR STRUCTURE AT FRAME 67 PLUS 13 INCHES TO FRAME 67 AT LBL 45. (M)SDR 2004F00112Structure · corrodedAT C-CHECK, FOUND CORROSION ON FLOOR STRUCTURE AT FRAME 69 PLUS 3 INCHES TO 69 PLUS 10 INCHES AND LBL 50 IN CABIN. REMOVED AND REPLACED AFT CABIN FLOOR STRUCTURE AT FRAME 69 PLUS 3 INCHES TO FRAME 69 PLUS 10 INCHES, LBL 50. (M)SDR C2XA03SH327Buttstrap · corrodedDURING C CHECK THE CENTER BUTTSTRAP BETWEEN FRAMES 18 AND 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02.THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AUS20030940Door Frame · cracked(AUS) LT ENTRY DOOR FRAME PN 12843003 AND RT ENTRY DOOR FRAME PN 12843004 CRACKED IN AREA ABOVE SIDE WINDOW. CRACK LENGTHS APPROXIMATELY 457.2MM (18IN).SDR DXTA200300113Window Post · chafedWHILE PERFORMING MAINTENANCE NEAR PILOT'S SIDE WINDOW, NOTICED WINDSHIELD CENTER POST HAS CHAFE DAMAGE, FURTHER EVALUATION SHOWED DAMAGE MEASURED APPROX. .375 INCH LONG BY .100 INCH WIDE AND APPROX. .028 DEEP. THE THICKNESS OF THE POST IS .062 INCH. - ITEM IS SDR QXEA200301155Structure · nickedPDX- RIGHT SERVICE DOOR APERTURE IS NICKED ON FORWARD SIDE 13.5 INCHES DOWN FROM TOP. REPAIRED IAW Q400 SRM 51-26-10, 51-00-02, 51-00-04 AND RD 8/4-53-666.
Back to JASC 5310