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 DHL2004803518Fitting · crackedFWD CARGO COMPT SPLICE FITTING CRACKED 9.000 STA FS 440.000 TO 460.000, L-31R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-1-0 PG 1. REMOVED CRACKED SPLICE FITTING IAW SRM 51-1-20D PG 21. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEWSDR HNAA0400032Door Frame · corrodedLIP AT PAX DOOR ENTERANCE WAY IS CORRODED ENTIRE LENGTH OF FLANGE, R&R AIRSTAIR DOOR THRESHOLDSDR SWAA040916Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 500D, STRINGER 26L, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR C2XA04SH185Crossbeam · corrodedSHV- DURING C-CHECK THE CROSSBEAM AT FRAME 22 BETWEEN THE RIGHT SILL AND THE CENTER FLOORBEAM 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 CALA0400331Shear Tie · crackedMAINTENANCE DISCOVERED A SHEAR TIE CRACKED IN TWO PLACES ALONG THE FASTENERS ATTACHING IT TO THE FUSELAGE SKIN. THE CRACKS WERE LOCATED BETWEEN STRINGERS 9L AND 10L AND BETWEEN STRINGERS 10L AND 11L, STA 277. REPAIRED IAW ECRA 5311-01193.SDR AALA20040412Beam · corrodedTUL - AFT CARGO DOOR BEAM CORRODED AT STATION 1160 - 1207. CORROSION WAS 6 INCHES BY 44 INCHES AND AT A DEPTH OF 0.034 INCHES. INSTALLED REPAIR DOUBLER PER SRM 53-10-00-3 FIG 1.SDR SWAA040901Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE AT BS 500B, STRINGER 16R CRACKED. REPAIRED SHEAR TIE PER SRM.SDR SWAA040897Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME SHEAR TIE CORRODED AT BS 460, STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA040894Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500D, OUTBOARD OF RT KEEL BEAM. REMOVED AND REPLACED SHEAR TIE SECTION PER SRM.SDR SWIA200413070Window Post · crackedANGLE BRACKET UNDER PILOT'S WINDOWSILL IS CRACKED (FRAME 10). (DISCOVERED DURING C-CHECK INSPECTION)REMOVED AND REPLACED ANGLE BRACKET UNDER PILOT'S WINDOW SILL IAW SRM 51-10-02, 51-40-00. SEE RII 53-301.SDR ASAA0440087Crease Beam · corrodedGYR - FOUND R1 DOOR THRESHOLD CREASEBEAM AT STATION 294.5 APPROX RBL 55, CORRODED IN NUMEROUS AREAS OF UPPER SURFACE. REMOVED AND REPLACED R1 DOOR THRESHOLD CHORD STATION 262 TO 380 RBL 55 PER SRM 51-40-02. (M)SDR KBM2004F00059Crossbeam · inoperativeCROSSBEAM LAMINATED BEARING. REMOVED AND REPLACED.SDR ASAA040150Shear Tie · corrodedOKC - DURING MAINTENANCE, FOUND E/E COMPARTMENT AT STATION 328 HAS SHEAR TIE FLANGE CORRODED. REPAIR IAW SRM. (M)SDR 04FDEA00734Shear Tie · corrodedCORROSION ON STUB FRAME SHEAR TIE STA 950E 4 BETWEEN STR 28R AND 29R.SDR UPS04M42529Door Frame · chafedINSPECTION TYPE: C, NR 2 ENGINE LEFT FAN COWL DOOR JAMB (FUSELAGE) FOUND LWR SURFACE CHAFE MARK AS MARKED. MEASURED CHAFE AREA FOUND (0.058 INCH), OUT OF LIMIT ORIG THK 0.100 INCH. NR 2 ENG LEFT FAN COWL DOOR JAMB LWR SURFACE SKIN TRIM PER EN1162-04. DOUBLESDR SWAA040864Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE AT BS 500B, BETWEEN STRINGERS 27R AND 28R, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040845Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM WEB AT BS 985, RBL 49, WL 207, CORRODED. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA040844Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM AT BS 992, RBL 47, WL 208, CORRODED. REPAIRED CREASE BEAM SECTION PER SRM.SDR GTIA040418Stop Fitting · corrodedFWD CARGO DOOR FUSELAGE SIDE, DOOR STOP CORRODED/ FROZEN. REMOVE DOOR STOP. INSTALLED NEW DOOR STOP.SDR 757BJ0010Door Frame · crackedNR 2 CARGO DOOR FWD FRAME AT STA.1380 WEB CRACKED AT SEAL RETAINER FASTENER LOCATION BETWEEN STR 25 RT AND STR26 RT. REPAIRED DAMAGE PER SRM 53-00-07.SDR 757BJ0009Door Frame · crackedNR 2 CARGO DOOR FRAME AFT WEB CRACKED AT NR 6 DOOR STOP FASTENER LOCATION. REPAIRED DAMAGE PER SRM 53-00-07.SDR ABXA040127Attach Angle · corrodedATTACH ANGLE TO UPPER PRESSURE DECK FLOOR FROM STA 960 - 980, 100 INCHES FROM RIGHT CUSP, HAD CORROSION. REPAIRED AREA IAW REA D853-48865MR.SDR SWAA040837Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM AT BS 960 TO BS 986, LBL 60 TO LBL 65, WL 208, CORRODED. REPAIRED CREASE BEAM PER SRM.SDR SWAA040831Shear Tie · corrodedDURING SCHEDULED SPV, FOUND SHEAR TIE AT BS 987, BL 0, CORRODED. REPAIRED SKIN PER SRM.SDR ABXA040115Structure · vibrationVIBRATION FELT IN AIRCRAFT (YOKE, FLOOR, & SEAT) ABOVE 320 KTS. NO CHANGE IN INTENSITY UNTIL SLOWED BELOW 320 KTS. VIBRATION STARTS AND STOPS ABRUPTLY. DEFERRED MACH TRIM SYSTEM IAW DC9 MEL. CLEARED MACH TRIM SYSTEM AFTER PERFORMING ADJ/TEST PROCEDURES IAWSDR ASAA0410128Shear Tie · corrodedOKC - DURING MAINTENANCE, FOUND AFT PIT SHEAR TIE CORRODED AT FS 967 AT STRINGER 19L-20L. REPAIR IAW SRM. (M)SDR ASAA0410122Shear Tie · corrodedOKC - DURING MAINTENANCE, FOUND SHEAR TIE AT FS 520 CORRODED. REPAIR IAW SRM. (M)SDR SWAA040825Shear Tie · crackedDURING SCHEDULED SPV, FOUND SHEAR TIES AT BS 360, STRINGERS 14R AND 14L, CRACKED. REPAIRED SHEAR TIES PER SRM.SDR C2XA04SH168Support Beam · corrodedSHV - DURING C-CHECK THE AFT GALLEY SUPPORT BEAM BETWEEN FRAMES 22 AND 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR GTIA040287Shear Tie · corrodedFTW - FOUND AFT CARGO SHEAR TIE FROM LONGERON 26R-26L, CORRODED AND TOOL MARKS. FABRICATED NEW SHEAR TIE. (M)SDR SWAA040815Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 360 BETWEEN STRINGERS 14R AND 15R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040814Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE CORRODED AT BS 967, LBL 1. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040813Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 616, RBL 71, WL 208. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR C2XA04SH163Door Frame · crackedSHV - DURING C-CHECK THE LEFT T-SECTION AT THE CARGO DOOR CUT FRAME 66 WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE CRACKED SECTION IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA0440079Shear Tie · corrodedGYR - FOUND FORWARD CARGO COMPARTMENT, STATION 520 RBL 3, LOWER FRAME SHEAR TIE 100 PERCENT EXFOLIATED. FABRICATED AND INSTALLED 65-46534-9 SHEAR TIE. (M)SDR ABXA040131Stop Fitting · crackedUPPER RIGHT VENTRAL DOOR STOP FITTING ON AFT PRESSURE BULKHEAD WAS CRACKED. REMOVED AND REPLACED FITTING IAW DC-9 SRM 51-30-1 AND 51-30-5.SDR C2XA04SH159Buttstrap · gougedSHV - DURING C-CHECK THE CENTER OMEGA BEAM BUTTSTRAP WAS FOUND TO BE GOUGED AT FRAME 21. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA040792Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM CORRODED AT BS 947 TO BS 986, RT SIDE. REPAIRED CREASE BEAM PER SRM.SDR SWAA040778Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM CHORD CRACKED AT BS 616 TO BS 639, RBL 63, WL 208. REMOVED AND REPLACED CREASE BEAM CHORD PER SRM.SDR C2XA04SH158Buttstrap · corrodedSHV - DURING C-CHECK, THE LEFT BUTTSTRAP AT FRAME 65 TO FRAME 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 USAA040048Beam · corrodedPIT- FOUND BEAM CORRODED 2 INCH BY 20 INCH AREA, BL 0 BS 345-365. CORROSION LEVEL 1. REMOVED CORROSION AND INSTALLED DOUBLERS AND SHIMS PER SRM 51-70-12. (M)SDR 04FDEA00642Frame · crackedAFT FUSELAGE COMPARTMENT, UPPER FUSELAGE FRAME CLIP AT CANTED AREA STA 2046 FOUND CRACKED. CRACKED CLIP AT CANTED AREA STA 2046 AT AFT FUSELAGE COMPARTMENT UPPER FUSELAGE FRAME REMOVED AND REPLACED AS PER SRM 51-31-01 VOL II. COMPLIED EA 1-5340-75915, FUSELASDR AALA20040361Beam · crackedTUL CRACK IN LOWER OUTBOARD FLANGE OF THE LEFT HAND GANTRY BEAM NR 4 AT FRAME 53. CRACK LENGTH IS 1.500 INCH. REPAIRED ACCORDING TO AIRBUS REPAIR TD 942.029285.004.2004, ISSUE B, DATED 10 MAR 2004 AND ESO 30595 DATED 12 MAR 2004.SDR ASAA0480179Door Frame · corrodedOKC - DURING HV CHECK, FOUND AFT CARGO BAY DOOR BEAM PREVIOUS REPAIR ANGLE/SKIN IS CORRODED UNDER FORWARD AND AFT LOWER DOOR STOP MOUNTS. REPLACED DOOR BEAM PER SRM 51-30-2. (M)SDR ASAA0440076Crease Beam · gougedGYR - FOUND CREASE BEAM WEB AT STATION 304, R1 DOOR HAS DEEP GOUGE JUST INBOARD OF CREASE BEAM INNER CHORD. REMOVED AND REPLACED WEB. (M)SDR GTIA040288Doubler · corrodedFTW - FOUND CORROSION ON MID PIT DOOR BEAM REPAIR DOUBLER FROM STATION 636 TO 693 AND ON FRAME AT STATION 693. REMOVED REPAIR STRAP. FABRICATED NEW REPAIR STRAP. INSTALLED REPAIR DOUBLER. (M)SDR SWIA200413048Beam · crackedCARGO PIT; FS 589.00 AND 605.00; TRANSVERSE BEAM ATTACH ANGLES FOR LANDING PLATE STOP FITTINGS CRACKED. REPLACED ANGLES (2 OF) IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-42-21, 51-21-11, 51-25-16, 51-41-04.SDR SWIA200413047Beam · crackedMAIN FUSELAGE; FS 280.00; LBL-9; UPPER FLANGE CRACKED ON TRANSVERSE BEAM. REPAIRED IAW CRJ REO 601R-53-11-138 REV. NC AND RII53-401.SDR SWIA200413046Beam · crackedMAIN FUSELAGE; FS 280.00, RBL 9.0, LOWER FLANGE CRACKED ON TRANSVERSE BEAM. REPAIRED IAW CRJ REO 601R-53-11-171 REV. NC AND RII53-401.SDR SWAA040745Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIES CORRODED AT BS 500D, LT AND RT KEEL BEAM, AND BS 520, LT KEELBEAM. REMOVED AND REPLACED SHEAR TIES PER SRM.
Back to JASC 5310