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 SWIA200413462Floorbeam · crackedFS 280 RIGHT FLOORBEAM RBL 9.0 OUTBOARD ATTACH ANGLE CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-13, 51-41-21, 51-42-06, AND 51-23-00.SDR 04FDEA01742Floorbeam · corrodedCORROSION ON FLOORBEAM, STA 760, LBL 66, WL 206. *S/D* CORROSION OUT OF LIMITS. REMOVED STUB FLOORBEAM BS 760 LT SIDE. DRILLED UP & INSTALLED NEW STUB FLOORBEAM WL 200 PER SRM 51-30-2, 51-30-5, 53-10-1.SDR COMA0460369Floorbeam · corrodedCARGO BAY FLOORBEAM CAP AT LBL 9 CORRODED BETWEEN FS 589 AND FS 610. REMOVED CORRODED CAP AND INSTALLED NEW CAP P/N 601R35031-3 I/A/W CRJ SRM 51-42-13 AND CRJ SRM 51-42-06.SDR COMA0460378Floorbeam · corrodedCARGO BAY FLOORBEAM CAP AT LBL 27 HAS SURFACE CORROSION. REMOVED CORRODED CAP AND INSTALL NEW (P/N 601R35031) IAW CRJ SRM 51-42-06 AND 51-42-13. LOCATED AND INSTALLED REPAIR DOUBLER IAW REO 601R-53-61-1049 AND REO 601R-53-61-1046.SDR DL73S040557Floorbeam · crackedFUSELAGE CABIN FLOORBEAM AT STATION 520 FOUND WITH A CRACK AT THE UPPER CHORD. AREA REPAIRED IAW ERA 090614-14.SDR UPS04842636Floorbeam · crackedINSPECTION TYPE: C2, LOWER FLOORBEAM ANGLE IS CRACKED AT STATION 759 AT RBL 50. REMOVED, FABRICATED AND REPLACED ANGLE IAW DWG 3643110, AND SRM 51-1-20D.SDR C2XA04SH365Stringer · corrodedDURING C-CHECK THE UPPER STRINGER ON THE CENTER FLOORBEAM BETWEEN FRAMES 22 AND 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED STRINGER IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH363Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 24 AND 25 WHERE THE CARBON FIBER CROSSMEMBER ATTACHES. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-22-10. THE AIRCRAFT WAS APPROVED FSDR AWXA200400704Floorbeam · corrodedMAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON THE Y1292 BEAM AT FR66. MAINTENANCE REMOVED AND REPLACED FLOORBEAM AT Y1292 FR66-68 IAW A320 SRM 51-42-11 PAGES 6,7,28 AND SRM 51-49-00 PAGES 2 AND 3 TABLE 1.SDR AWXA200400703Floorbeam · corrodedMAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON THE Y1292 BEAM BETWEEN FR 67-68. MAINTENANCE REMOVED AND REPLACED FLOORBEAM AT Y1292 FR 67-68 IAW A320 SRM 51-42-11 PAGES 6 & 7.SDR 04FDEA01702Floorbeam · corrodedFLOORBEAM AND SHEAR WEB STA 1130, RBL 19 (TOP CHORD) EXFOLIATED. INSTALLED SEAT TRACK, 2 STRAPS AND T-CHORD IAW SRM 51-30-2. INSTALLED REPAIR IAW SRM 53-10-8.SDR C2XA04SH358Floorbeam · corrodedDURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 23. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EC 5320-01124. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR USAA040287Floorbeam · corrodedPIT - FOUND BEAM CORRODED THREE 1 INCH DIAMETER AREAS, BS 947 LBL 30 TO LBL 46. REMOVED CORROSION, TREATED AND PRIMED, PERFORMED TYP REPAIR 53-15-01B, SRM 51-10-02. CORROSION LEVEL 1, TASK NR C53-107-02. (M)SDR USAA040325Floorbeam · corrodedBFM - FOUND BEAM CORROED 1.5 INCHES BY 1 INCH BY .25 INCH CORRODED, BETWEEN FRAME 68 AND 69, BL -Y1292, -Z240. REPLACED WITH NEW PART PER SRM 53-00-14, FIG 102. (M)SDR USAA040326Floorbeam · corrodedBFM - FOUND BEAM CORRODED 1 INCH BY 1 INCH BY .20 INCH AREA, FS 66, BL -Y1292, -Z240. REPLACED WITH NEW PART PER SRM 53-00-14 FIG 102. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)SDR USAA040324Floorbeam · corrodedBFM - FOUND BEAM CORRODED 1 INCH BY .50 I NCH BY .20 INCH AREA, BETWEEN FRAME 66 AND 68 BL -Y1292. REPLACED WITH NEW PART PER SRM 53-00-10 FIG 102. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)SDR SWAA041652Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM AT BS 727D + 5, LBL 12, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR C2XA04SH357Floorbeam · corrodedDURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A SHIM FILLER REPAIR IAW EMB 145 SRM 53-21-10 FIG 202, SHEET 1. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH356Floorbeam · corrodedDURING C-CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH354Floorbeam · corrodedDURING C-CHECK THE LEFT CROSSBEAM AT FRAME 19 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 C2XA04SH352Floorbeam · corrodedSHV - DURING C-CHECK, THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A SHIM FILLER REPAIR IAW EMB 145 SRM 53-21-10, FIG 201, SHEET 2. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR IXXA060215SFloorbeam · corrodedDURING ROUTINE C CHECK FOUND FLOORBEAM UPPER FLANGE CORRODED AT STATION 420 BETWEEN -X29 AND -X42. REPAIRED FLOORBEAM PER ALL APPLICABLE DATA.SDR IXXA060213SFloorbeam · crackedDURING ROUTINE C CHECK FOUND FLOOR BEAM CRACKED AT STATION 1420, Z0, -X45. REPAIRED PER COOPESA EO COO-8-53-243-04 DATED 7/7/04.SDR IXXA060210SFloorbeam · crackedDURING ROUTINE C CHECK FOUND FLOORBEAM UPPER FLANGE CRACKED AT STATION 380, +X32. REPAIRED PER COOPESA EO COO-8-53-245-04 DATED 6/10/04.SDR IXXA060209SFloorbeam · crackedDURING ROUTINE C CHECK FOUND CRACKED FLOORBEAM AT STATION Y360 AT +X28 AND +X32. REPAIRED PER COOPESA EO COO-8-53-264-04 DATED 6/15/04.SDR SWIA200413580Floorbeam · crackedFLOOR SUPPORT ANGLE CRACKED AT FS 621.0, RBL 45, WS 73.5. ITEM FOUND AT C-CHECK. INSTALLED NEW ANGLES AT FS 621 RBL 45 WL 73 IAW BOMBARDIER REO 601R-53-61-117.SDR SWAA041625Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM WEB AT BS 328, RBL 20, CORRODED. REPAIRED WEB PER SRM.SDR 2004UALA00556Floorbeam · corrodedCABIN FLOORBEAM FS 1640 HAS CORROSION AROUND NUT PLATE HOLES FROM RBL 14 TO RBL 44 UPPER AFT FLANGE BOTH SIDES OF FLANGE. FABRICATED & INSTALLED FLOORBEAM AND SPLICE ANGLES.SDR 2004UALA00555Floorbeam · corrodedEXFOLIATION ON MAIN CABIN FLOORBEAM STA 324, RBL 62. TEE ANGLE REPAIR INSTALLED.SDR 04FDEA01633Floorbeam · crackedFOUND LWR FLOORBEAM IN CENTER CARGO COMP AT APPROX FRAME STA 1701 AT APPROX 30 INCHES FROM CENTER LINE ON RT SIDE. NOTE: THERE IS ALSO DAMAGE TO LT SIDE.SDR 04FDEA01630Floorbeam · corrodedCORROSION ON FLOORBEAM STRAP AT BS 950, LBL 9, WL 138.SDR 04FDEA01629Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 950, RBL 27.5, WL 208 UPPER FLANGE.SDR C2XA04SH344Floorbeam · corrodedSHV - DURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE PERFORMED A DOUBLER REPAIR TO THE AFFECTED BEAM IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA041592Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 860 LBL 17 TO RBL 13.8, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA041591Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 944, RBL 13.8, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR USAA040261Floorbeam · corrodedBFM - FOUND BEAM CORRODED 1 INCH BY 1 INCH BY .032 INCH DEEP, FS 66, Y765, Z240. REMOVED AND REPLACED BEAM PER SRM 53-00-14. CORROSION LEVEL 2, TASK NR JA 260 53500. (M)SDR A6WA200440091Floorbeam · crackedFOUND FLOORBEAM ANGLES CRACKED AT FS 280, WL 73.50, LBL 9 AND RBL 9, FLOOR LEVEL. REMOVED OLD FLOOR SUPPORT ANGLES AT FS 280 WL 73.50 INBOARD SIDE OF LBL 9 AND RBL 9. INSTALLED NEW ANGLES PART NR RH 601R31113-58, LH 601R31113-57. ALL WORK IAW CRJ200 SRM 51-SDR A6WA200440072Floorbeam · crackedFLOOR ANGLE AT FS 484, RBL 27 RIGHT INBOARD IS CRACKED. REMOVED CRACKED RT INBOARD FLOOR ANGLE AT FS 484 WL 73.5 AND FABRICATED NEW ANGLE FROM S6144-14 AND INSTALLED IAW REPAIR NUMBER 601R-53-0029. (M)SDR ABXA040223Floorbeam · corrodedFLOORBEAM WEB AT BS 180 WAS CORRODED AT 3 ATTACH FASTENERS FOR SPLICE PLATE LEFT BUTTLINE 57. REPAIRED AREA IAW REA D853-49182MR.SDR ABXA040222Floorbeam · crackedFLOORBEAM WEB AT BS 240 HAD 4 CRACK INDICATIONS AT SPLICE PLATE ATTACH FASTENERS LEFT BUTTLINE 57. REPAIRED AREA IAW REA D853-49184MR.SDR SWIA200413459Clip · crackedFUSELAGE FLOORBEAM ATTACH CLIP IS CRACKED INBOARD LOCATION FS 280.00 LBL 9.0. DISCOVERED DURING C-CHECK INSPECTION. REPLACED CLIP IAW CRJ SRM 51-40-11, 51-23-00, 51-42-06, 51-42-21, 51-25-16, 51-21-11SDR SWIA200413458Clip · crackedFUSELAGE FLOORBEAM ATTACH CLIPS ARE CRACKED (2) INBOARD AND OUTBOARD FS 280.00 RBL 9.0. DISCOVERED DURING C-CHECK INSPECTION. REPLACED CLIPS IAW CRJ SRM 51-40-11, 51-23-00, 51-42-06, 51-42-21, 51-42-13, 51-25-16, 51-21-11.SDR SWIA200413448Clip · crackedFUSELAGE FLOORBEAM ATTACH CLIP IS CRACKED; OUTBOARD LOCATION FS 280.0 LBL 9.0. DISCOVERED DURING C-CHECK INSPECTION. REPLACED CLIP IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00, 51-21-11, 51-42-13, 51-25-16.SDR SWIA200413447Floorbeam · crackedFUSELAGE FLOORBEAM ATTACH CLIPS ARE CRACKED; INBOARD AND OUTBOARD FS 280.0 RBL 9.0. DISCOVERED DURING C-CHECK INSPECTION. REPLACED CLIPS IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00, 51-21-11, 51-42-13, 51-25-16, 51-42-13.SDR 2004UALA00550Floorbeam · corrodedCABIN FLOORBEAM STA 1640 HAS CORROSION AROUND SEVERAL NUT PLATES HOLES FROM RBL 14 TO RBL 44, UPPER FLANGE, LWR AND UPPER SURFACES. FABRICATED & INSTALLED NEW TEE AND DOUBLERS.SDR C2XA04SH342Floorbeam · corrodedDURING C-CHECK THE RIGHT CROSS BEAM ANGLE AT FRAME 24 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED ANGLE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR EIA2004100Floorbeam · crackedWEB BETWEEN FLOORBEAM STA 320-330, STR 12L IS CRACKED. REMOVED DAMAGED WEB, FAB & INSTL PER B747 SRM 51-30-02, 51-10-02, 51-20-01, & SOPM 20-41-02SDR AWXA200400688Floorbeam · corrodedDURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 LT AT FR 68. MAINTENANCE REMOVED CORRODED BEAM Y1292 LT FROM FR 68 TO FR 69; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW SRM 51-42-11, FIG. 2-3, 13-14, AND 16-18.SDR 04FDEA01605Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 950 RBL 27.5 WL 208 UPPER FLANGE. REMOVED CORROSION ON FLOORBEAM IAW SRM 51-10-6 AND FED EX EA 7-5310-55308.SDR 04FDEA01604Floorbeam · corrodedWHILE CLOSING MAIN CARGO FLOOR PANELS FOUND BS 1070, LBL 25 TO RBL 60, WL 200 LOWER FLOORBEAM FWD SIDE CORRODED. REPAIRED FLOOR BEAM BS 1070 PER FED EX EA 7-5310-55306.
Back to JASC 5315