JASC 5315
Service difficulty reports · 44,223
Reports filed under 5315 · Fuselage Main, Floor Beam, 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 = '5315' 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 = '5315' 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 AWXA200400473Stiffener · corrodedDURING C-07 CHECK EXFOLIATION CORROSION WAS FOUND ON TEE ANGLE STIFFENER UNDER SHEAR DECK BS 1716, BL "0". MAINTENANCE REMOVED CORRODED TEE ANGLE STIFFENER AT BS 1716, BL "0"; FABRICATED A NEW REPLACEMENT ANGLE STIFFENER PER DWG 146N5315; INSTALLED REPAIR PARTSDR 2004UALA00410Floorbeam · crackedAFT PIT RT SIDE STA 2120 T-CAP FOR WASTE TANK SUPPORT FITTING CRACKED RBL 41 - 33. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED NEW T-CAP SECTION.SDR 0400615532Floorbeam · crackedDURING "H" CHECK FOUND CRACK IN FLOORBEAM AT BS 700 LBL 25. REPAIRED PER EA 55-198777.SDR 0400825515Floorbeam · crackedDURING H-CHECK FOUND CRACK IN FLOORBEAM AT BS 700 LBL 45. REPAIRED PER EA 55-198769.SDR C2XA04SH249Doubler · corrodedSHV - DURING C-CHECK THE RIGHT HAND OMEGA BEAM DOUBLER AT FRAME 22 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DOUBLER IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA041177Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAMS AT BS 328, RBL 42, BS 344, LBL 50 TO RBL 0, CORRODED. REPAIRED FLOORBEAMS PER SRM.SDR ASAA0440114Floorbeam · corrodedFOUND FLOORBEAM UPPER CAP IS CORRODED AT CLIP FROM RBL 24-49. REMOVED CORROSION, MATERIAL LOSS OUT OF LIMITS. FABRICATED REPAIR, TREATED AND PRIMED AND INSTALLED, REF 737 SRM 53-00-51. (M)SDR ASAA0410211Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM VERT WED AT STATION 1016, RBL 42 IS CORRODED. REMOVED DMG DOUBLER AND INSTALLED RPLC DOUBLER IAW 51-20-1. (M)SDR USAA040208Floorbeam · corrodedFLOORBEAM 16 INCHES X 2 INCH AREA, CORROSION; NO LEVEL/ TASK AFT CABIN FLOOR STA 1480, LBL 27-43. INSTALLED REPAIR IAW SRM.SDR USAA040207Floorbeam · corrodedFLOORBEAM, 2 INCHES X 2 INCHES AREA, CORROSION; NO TASK/ LEVEL, CABIN FLOOR, TOP OF FLOORBEAM STA 1502, LBL 28. SPLICE REPAIR INSTALLED IAW SRM.SDR SWAA041178Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM AT BS 294.5, RBL 39, CORRODED. REPAIRED FLOORBEAM PER SRM.SDR ASAA0440118Floorbeam · corrodedFOUND STATION 986 FLOORBEAM UPPER CAP IS CORRODED AT CLIPNUT HOLES FROM RBL 24 TO RBL 49. REMOVED AND RELACED UPPER CAP AT STATION 986 RBL 24 TO RBL 49. (M)SDR USAA040173Floorbeam · corrodedFLOORBEAM, 1.0 INCH L X 1.5 INCH W X .022 INCH D AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500, FR 65-68, -Y 1244.6, Z240. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM 53-00-14 & 51-42-11.SDR F3LA200400062Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON FLOORBOARD HOLE AT STA 986, LBL 30, FLOORBEAM UPPER CHORD. CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-60-51, FIG. 101, DETAIL VII. REPLACED UPPER CHORD OF FLOORBEAM FROM SKIN TO SKIN IAW EA B3-53R-10397,SDR F3LA200400060Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM AT STA 328, RBL 15 AND 35. REMOVED DAMAGED TOP CHORD OF FLOORBEAM, FABRICATED AND INSTALLED NEW SECTION PER SRM 53-10-51 AND EA B3-53R10393.SDR F3LA200400055Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION AT FLOORBOARD HOLE AT STA 986, LBL 30, FLOOR BEAM UPPER CHORD. CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-60-51, FIG. 101, DETAIL VII. REPLACED UPPER CHORD OF STA 986 FLOOR BEAM FROM SKIN TO SKIN PER EA B3-SDR SWAA041155Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 772.5, RBL 2.5 TO LBL 2.5, CORRODED. REPAIRED FLOORBEAM PER EA.SDR C2XA04SH243Floorbeam · corrodedSHV- DURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 135 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWIA200413240Floorbeam · crackedDISCOVERED DURING C-CHECK INSPECTION, FS 280 RIGHT FLOORBEAM RBL 9.0 OUTBOARD ATTACH ANGLE CRACKED. ANGLE REPLACED AT FS280, RBL 9.0 IAW CRJ SRM 51-40-11, 51-42-13, 51-42-21, 51-23-00, 51-21-11, AND RII53-401.SDR SWIA200413239Floorbeam · crackedDISCOVERED DURING C-CHECK INSPECTION, FS 280 LEFT FLOORBEAM LBL 9.0 ATTACH ANGLE OUTBOARD CRACKED. ANGLE REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00, 51-21-11, AND RII 53-401.SDR C2XA04SH241Floorbeam · corrodedSHV- DURING C-CHECK THE CENTER FLOORBEAM AT FRAME 18 TO 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 04FDEA01044Floorbeam · corrodedFWD CABIN STA 442 RBL 30, FOUND FLOORBEAM CORRODED. FWD CABIN STA 442 RBL 30 FLOORBEAM REMOVED AND INSTALLED AS PER SRM 51-33-01 VOL II AND DWG ABA8305.SDR 04FDEA001044Floorbeam · corrodedFWD CABIN, STA 442 RBL 30 FOUND FLOORBEAM CORRODED. **** S/D COMING ****SDR ASAA0480317Floorboard · crackedOKC - DRING HV CHECK, FOUND METAL FLOORBOARD CHANNEL SUPPORT AT STATION 1003-1079 IS CRACKED. REMOVED DAMAGE AND INSTALLED RPR SPLICES AND ANGLES PER SRM 53-01. (M)SDR AWXA200400479Floorbeam · corrodedDURING C-14 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF CABIN FLOORBEAM AT BS 967, RBL 45. MAINTENANCE CUTOUT DAMAGED SECTION OF UPPER TEE CAP ON CABIN FLOORBEAM AT BS 967, RBL 45; FABRICATED A NEW REPLACEMENT SECTION OF UPPER TEE CAP, 2 EACH REPSDR SWAA041126Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM AT BS 727 + 18, RBL 44, CRACKED. REPAIRED FLOORBEAM SECTION PER ER.SDR F3LA200400054Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON FLOOR BEAM AT STA. 328, RBL 15 TO RBL 35. REMOVED DAMAGED TOP CHORD OF FLOOR BEAM, FABRICATED AND INSTALLED NEW SECTION PER SRM 53-10-51 AND EA B3-53R10393.SDR EIA2004029Floorbeam · damagedSTA 360 LT UPPER DECK FLOORBEAM UPPER CHORD HAS NUMEROUS HOLES WITH SHORT EDGE MARGIN BETWEEN LBL 55 & LBL 82. REPAIRED STA 360 LH UPPER DECK FLOORBEAM UPPER CHORD SHORT EDGE MARGIN HOLES, LBL 55-LBL 82, PER ECRA #486-53-025-2, PART "C"SDR EIA2004025Floorbeam · damagedSTA 340 LT UPPER DECT FLOORBEAM TO FRAME INTERFACE HAS ELONGATED HOLES. OVERSIZED ELONGATED HOLES AT BS 340 LT FLOORBEAM TO FRAME INTERFACE TO ROUND CONDITION PER ECRA 486-53-25-2, PART B, STEP 2. HFEC & 10X VISUAL INSP SHOWS HOLES ARE CRACK AND CORROSION FRSDR EIA2004024Floorbeam · damagedSTA 340 RT UPPER DECK FLOORBEAM TO FRAME INTERFACE HAS ELONGATED HOLES. OVERSIZED, ELONGATED HOLES TO ROUND CONDITION. HFEC & 1OX VISUAL INSPECTION SHOWS HOLES TO BE CRACK AND CORROSION FREE. (SEE ECRA 486-53-025-2) REMOVED EXISTING FREEZE PLUGS AT HOLES NSDR EIA2004023Floorbeam · damagedSTA 360 LT UPPER DECK FLOORBEAM, TO FRAME INTERFACE HAS (4) ELONGATED HOLES. OVERSIZED ELONGATED HOLES AT STA 360 LT UPPER DECK FLOORBEAMS TO FRAME INTERFACE TO ROUND CONDITION. HFEC & 1OX VISUAL INSP SHOWS HOLES TO BE CRACK AND CORROSION FREE. (SEE ECRA 486SDR C2XA04SH236Floorbeam · corrodedSHV- DURING C-CHECK THE LEFT HAND FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10, FIGURE 201. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA0410198Floorbeam · corrodedFOUND FLOORBEAM CORRODED AROUND FASTENER HOLES AT STATION 540-650. OPENED UP HOLES, INSPECTION WITH HFEC, TREATED AND PRIMED AREA IAW EA 5310-02341. (M)SDR ASAA0410197Floorbeam · corrodedFOUND SPOT CORROSON ON BEAM CAP SUPPORT JUNCTION AT STATION 360, RBL 12. REMOVED DAMAGE AND INSTALLED RPR SECTION IAW SRM 53-10-9. (M)SDR SWAA041121Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 947, RBL 10, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR C2XA04TY071Floorbeam · corrodedTYS - DURING A SCHEDULED 2C INSPECTION THE RT LAV FLOORBEAM CAP OVERFLOW WATER AND LINE FITTINGS, PLUS THE RIVETS AND NUTS WERE FOUND CORRODED. MAINT REMOVED AND REPLACED THE FLOORBEAM CAP AFTER COUNTERSINKING RIVETS WITH A NEW FLOORBEAM. REPLACED RIVETS ANDSDR SWAA041112Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM SECTION PER ER.SDR EIA2004022Floorbeam · damagedSTA 340, 360 RT UPPER DECK FLOORBEAM HAS NUMEROUS HOLES WITH SHORT EDGE MARGIN BETWEEN RBL 55-80. STA 340 AND 360 RT UPPER DECK FLOORBEAM WITH SHORT EDGE MARGIN HOLES REPAIRED PER ECRA 3486-53-025-2SDR SWAA041096Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAMS AT BS 727D + 5, LBL 13, AND BS 774 TO BS 777, LBL 8, CORRODED. REPAIRED FLOORBEAMS PER EA.SDR SWAA041101Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM SECTION PER EA.SDR SWAA041100Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM AT BS 770, RBL3, CORRODED. REPAIRED BEAM PER EA.SDR 04FDEA00987Floorbeam · corrodedFWD CABIN STA 427 LBL 53 - LBL 76 FOUND FLOOR SUPPORT BEAM CORRODED. REMOVED AND REPLACED FLOOR SUPPORT BEAM AS PER AMM 20-50-02.SDR SWIA200413344Floorbeam · crackedFS 280 RIGHT FLOORBEAM ANGLE RBL 9.0 CRACKED. DISCOVERED DURING C-CHECK INSPECTION. ANGLE REPAIRED IAW CRJ REO 601R-53-11-136 REV NC AND RII 53-401.SDR SWAA041083Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO FLOORBEAM AT BS 727D + 5, LBL 13, CORRODED. REPAIRED FLOORBEAM PER EA.SDR 2004UALA00366Floorbeam · corrodedSTA 987 RBL 45.5 FLOOR BEAM HAS CORROSION ON TOP AND BOTTOM SIDE OF NUT PLATE HOLES. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR ANGLES.SDR SWIA200413206Floorbeam · distortedCARGO PIT FLOORBEAM SIDE WEB BUCKLED AND DISTORTED; FS 589.00 - FS 605.00; LBL 27.0; OUTBOARD SIDE. (DISCOVERED DURING C-CHECK INSPECTION) REPLACED WEB IAW CRJ SRM 51-40-11, 51-23-00, 51-42-06, 51-42-21, 51-21-11, 51-25-16, AND REO 601R-53-61-989 REV., RII 53SDR SWIA200413205Floorbeam · crackedCARGO PIT FLOORBEAM ANGLE REPAIR ANGLE CRACKED AT FS 621.00 LBL 42.0. (DISCOVERED DURING C-CHECK INSPECTION) REPLACED REPAIR ANGLE IAW CRJ REO 601R-53-61-117 REV. A AND RII53-401.SDR SWIA200413193Attach Angle · crackedFS 280 LEFT FLOORBEAM RBL 9 INBOARD ATTACH ANGLE CRACKED. (DISCOVERED DURING C-CHECK INSPECTION) ANGLE REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-06, 51-42-21, 21-23-00, 51-25-00, 51-42-36 AND 51-21-11 AND RII 53-401.SDR SWIA200413192Attach Angle · crackedFS 280 RIGHT FLOORBEAM RBL 9 OUTBOARD ATTACH ANGLE CRACKED. (DISCOVERED DURING C-CHECK INSPECTION) ANGLE REPLACED IAW CRJ SRM 51-40-11, 51-40-13, 51-42-21, 51-23-00, 51-25-00, AND 51-24-36SDR SWIA200413191Fitting · crackedMAIN FUSELAGE; FS 460 RBL 9.0 OB FLOORBEAM FITTING CRACKED. (DISCOVERED DURING C-CHECK INSPECTION) REPLACED FITTING IAW CRJ SRM 51-40-11, 51-41-06, 51-23-00, 51-42-06, 51-23-00, 51-42-21, 51-21-11, 51-25-16, AND RII 53-401.
Back to JASC 5315