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 SWIA200211338Floorbeam · crackedFOUND FS 280.0 LBL 9.0 FLOORBEAM INBOARD AND OUTBOARD ANGLES CRACKED. FOUND DURING C CHECK INSPECTION. FIT AND INSTALLED NEW ANGLES IAW CRJ SRM 51-40-11, 51-42-13, 51-42-21 & FABRICATED ANGLES IAW REO 601R-53-11-171.SDR ZW0A0209601Floorbeam · corrodedDURING CHECK-C MAINT IN THE AFT CARGO COMPT FOUND CORROSION IN CABIN FLOORBEAM, STATION 1155, FROM LBL 22 INCHES TO OTBD. REPLACED PART PER SRM 51-30-0 FASTENER INSTALLATION AND SRM 6-70-01 FOR PART INSTALLATION.SDR F3LA200200259Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED VARIOUS STAGES OF CORROSION ON AFT GALLEY/LAVATORY FLOOR BEAMS. REMOVED CORROSION ON FLOOR BEAM AT BS 986.5 PER SRM 53-60-51. CORROSION REMOVAL AT LBL 28 TO LBL 44 WAS OUT OF LIMITS AND REPAIRED PER SRM 53-00-51, FIG. 20SDR SWIA200211366Floorbeam · crackedFS 280.0 RBL AND LBL 9.0 FLOORBEAM INBOARD ANGLES CRACKED. FOUND DURING C CHECK INSPECTION, NEW ANGLES FITTED AND INSTALLED IAW CRJ SRM 51-40-11, 51-42-06 AND 51-42-20.SDR SIMA200226103Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND CORROSION ON GALLEY RIGHT FLOOR BEAM. REMOVED CORRODED GALLEY RIGHT BEAM. INSTALLED NEW BEAM IAW EMB-145, SRM 145/1142, CHAPTER 51, RV 19, 51-40-02, AMERICAN EAGLE AIRLINES INC ETN NR EM-53-028 AND STANDARD SRM PRACTICESDR SIMA200227911Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, GALLEY AREA CENTER BEAM HAS CORROSION. INSTALLED REPAIR DOUBLER AND FILLER IAW EMB GST-1736/02C AND ETN EM 53-034R1. (M)SDR SIMA200225501Floorbeam · corrodedABI - FOUND GALLEY CENTER HAT BEAM CORRODED BEYOND LIMITS. INSTALLED NEW CENTER HAT BEAM IAW EMB145 SRM 145/1142 CHAPTER 51, REV 19, 51-40-02, 51-40-04, 51-20-01, 51-20-03 AND EMB GST-2758/02. (M)SDR SIMA200225502Floorbeam · corrodedABI - FOUND CORROSION ON LEFT OMEGA BEAM AT FRAME 20. FABRICATED AND INSTALLED A DOUBLER ANGLE FILLER PLATE AND TWO SHIMS IAW EMB-145 SRM 145/1142, CHAPTER 53, REV 19 53-21-10, FIG 201 AND STANDARD SRM PRACTICES. (M)SDR USAA020354Floorbeam · corrodedPIT - FOUND BEAM CORRODED 6.5 INCHES BY .5 INCH AREA, NUT PLATE HOLES ON TOP FLANGE OF FLOORBEAM STATION 98. REMOVED CORRODED SECTION OF FLOORBEAM AND SPLICED IN NEW PER SRM 53-00-51. (M)SDR C2XA02SH064Floorbeam · corrodedSHV-DURING C CHECK CENTER ISLE CARBON FIBER BEAM WAS FOUND TO HAVE CORROSION UNDER IT LEFT OUTBOUND SIDE. MAINTENANCE REPAIRED DAMAGED AREA IAW EMB-145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02TY139Floorbeam · corrodedTYS DURING A SCHEDULED 2-C CHECK, CORROSION WAS FOUND ON LT LAV AREA FLOORBEAM. MAINTENANCE REMOVED AND REPLACED LT LAV AREA FLOORBEAM, ALODINED, PRIMED AND PAINTED IAW EMB 135/145 SRM 53-30-01; 51-40-02; 51-21-03; 51-40-01 AND EMB 135/145 CPM 51-21-04, 05, SDR SIMA200225403Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, MAINTENANCE FOUND AN AREA OF THE FORWARD DIGITAL CORRODED. BLENDED CORRODED AREA. FABRICATED A DOUBLER AND INSTALLED IAW EMB GST-2721.02 PARA 1 DATED SEP 5, 2002 AND STANDARD SRM PRACTICES. (M)SDR UPS02439485Floorbeam · crackedINSPECTION TYPE:C M/D BS 320 BL 0 - RBL 1 FLOORBEAM LOWER CHORD CRACKED. FLOORBEAM LOWER CHORD CRACKED AREA REPAIRED AS PER SRM 51-40-04 FIG 2.SDR CALA0200455Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, LBL 34. THE CORRODED AREA OF FLOORBEAM WAS CUT OUT. A CHORD AND SPLICE ANGLE REPAIR WAS INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR SIMA200226117Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, GALLEY CENTER HAT BEAM IS CORRODED ADJACENT TO PREVIOUS REPAIR. MAINTENANCE REMOVED AND INSTALLED NEW GALLEY HAT BEAM IAW EMB 145 SRM 51-20-01, 51-40-02 AND GST 2758/02. (M)SDR C2XA02TY133Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE LEFT HAND OMEGA BEAM AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE ACCOMPLISHED A BLEND-OUT REPAIR IAW EMB GST 1927/02A, EMB145 CPM 51-21-04, 05 AND 06. THE REPAIR WAS SATISFACTORY, THE AIRCRAFT WILL BE RELEASED UPOSDR C2XA02TY132Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE TOP CAP AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE ACCOMPLISHED A BLEND-OUT REPAIR IAW EMB GST 1927/02A AND EMB145 CPM 51-21-04, 51-21-05 AND 51-21-06. THE REPAIR WAS FOUND TO BE SATISFACTORY, THE AIRCRAFT WILL BSDR SWAA022079Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 24 TO RBL 54. REPAIRED FLOORBEAM PER SRM.SDR C2XA02SH058Floorbeam · corrodedSHV- DURING C CHECK INSPECTION, THE RT FLOORBEAM AT FRAME 22 WAS FOUND TO HAVE CORROSION. MAITENANCE REPAIRED AFFECTED AREA OF FLOORBEAM AND REMOVED AND REPLACED A DOUBLER IAW EC 5320-01073. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02TY126Floorbeam · corrodedTYS, DURING A SCHEDULED INSPECTION THE CENTER FLOORBEAM WAS FOUND CORRODED AROUND SEVERAL FASTENERS IN LAV. MAINTENANCE REMOVED AND REPLACED THE CENTER TOP CAP IAW-EMB-135/145-SRM-51-40-02. THE REPAIR WAS SATISFACTORY AND THE AIRCRAFT WILL BE RELEASED UPON SDR AWXA200200951Floorbeam · crackedYVR - MAJOR REPAIR - DURING C-03 CHECK A 1 INCH CRACK WAS FOUND ON FLOORBEAM UPPER TEE CAP AT FWD SIDE OF BS 520, RBL 25. MAINTENANCE REMOVED DAMAGED FLOORBEAM UPPER TEE CAP. FABRICATED A NEW REPLACEMENT FLOORBEAM UPPER TEE CAP AND INSTALLED REPAIR PART IAW SDR C2XA02SH059Floorbeam · crackedSHV- DURING C CHECK, SPLICE ANGLE WAS FOUND CRACKED AT LT FLOORBEAM BETWEEN FRAMES 16 AND 17. MAINTENANCE REMOVED AFFECTED AREA AND PERFORMED A SPLICE REPAIR ON LT FLOORBEAM BETWEEN FRAMES 16 AND 17. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH055Floorbeam · corrodedSHV - DURING C-CHECK, CENTER OMEGA BEAM AT AFT GALLEY MOUNTS NUT PLATE HOLES HAVE CORROSION. MAINTENANCE REMOVED AND REPLACED AFFECTED OMEGA BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR SIMA200226113Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, CENTER OMEGA BEAM RAMP REQUIRES REPLACEMENT. MAINTENANCE REMOVED AND REPLACED NEW CENTER OMEGA BEAM IAW EMB 145 SRM 51-20-01, 51-20-05, 51-40-02. (M)SDR SIMA200226112Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, PREVIOUS REPAIR ON LEFT OMEGA BEAM FRAME 20 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED OMEGA BEAM IAW EMB 145 SRM 53-21-10 AND 51-40-02. (M)SDR 2002UALA01397Floorbeam · corrodedFLOORBEAM FLANGE CORRODED STA 1640 RBL 53, WL 208. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR INSTALLED.SDR SWIA200211330Floorbeam · crackedFS 280.00 RBL 9.0 FLOOR BEAM INBOARD AND OUTBOARD ANGLES FOUND CRACKED DURING C-CHECK INSPECTION. FIT AND INSTALLED NEW ANGLES IAW CRJ SRM 51-40-11, 51-42-13 AND 51-42-21.SDR C2XA02SH061Floorbeam · corrodedDURING C CHECK INSPECTION, LT FLOORBEAM WAS FOUND TO HAVE CORROSION BETWEEN FRAMES 19 AND 21. MAINTENANCE REMOVED AFFECTED PARTS AND REPAIRED LT FLOORBEAM IAW EMB SRM 53-21-10. THE AIRCRAFT WAS RETURN TO MAINTENANCESDR UPS02839448Floorbeam · crackedINSPECTION TYPE:C1 FLOORBEAM STA 50 IS CRACKED ON UPPER FLANGE AT LT O/B END. REPAIRED IAW DC8 SRM 53-2-0 & TR 53-124.SDR C2XA02SH049Floorbeam · corrodedSHV- DURING C-CHECK INSPECTION, CENTER FLOORBEAM STRAP FOUND TO HAVE NUT PLATES CORRODED AND SURFACE CORROSION FROM FRAME 15 TO 17. MAINTENANCE REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS IAW EMB 145 SRM 53-21-10 PG 210 ITEM 4 FIG 203, INSTALLED REPAIR PARTSDR 2002UALA01382Floorbeam · damagedCABIN STATION 987 LEFT HAND SIDE FLOOR BEAM CAP IS DAMAGED. AFTER REWORK HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. INSTALLED FLOORBEAM UPPER CAP SPLICE REPAIR.SDR 2002UALA01392Floorbeam · corrodedFORWARD CABIN FLOOR BEAM T-CAP BODY STATION 324 FROM RBL 40 TO RBL 46 HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED.INSTALLED FLOOR BEAM T-CAP DOUBLER REPAIR.SDR 2002UALA01391Floorbeam · corrodedCABIN FLOOR BEAM BODY STATION 297 RBL 42 HAS MATERIAL LOSS DUE TO CORROSION REMOVAL. MAJOR REPAIR ACCOMPLISHED. ANGLE REPAIR INSTALLED.SDR 2002UALA01373Floorbeam · corrodedFORWARD CABIN FLOOR BEAM BODY STATION 365 BL 0 TO RBL 65 HAS EXCESSIVE CROSS SECTIONAL AREA AND DEPTH OF MATERIAL REMOVED. MAJOR REPAIR ACCOMPLISHED. REPAIRED SPLICE TO FLOOR BEAM.SDR ASAA0240092Floorbeam · corrodedSEA - DURING C-CHECK, FOUND FLOORBEAM CORRODED AT STATION 986.5 AND LBL 29-41 CORRODED AROUND NUT PLATE HOLES. REPAIRED PER EA. (M)SDR SWAA021955Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 40 TO RBL 40. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA021954Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA021953Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA021937Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AT BS 727D + 6, LBL 8. REPAIRED FLOORBEAM PER SWA RA.SDR F3LA200200247Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED CORROSION ON UNDERSIDE OF CARGO FLOORBEAMS AROUND NUT PLATES AT BS 727, LBL 7.5; BS 826, LBL 7.5; BS 727, LBL 12; BS 813, LBL 12; AND BS 945, LBL 12. REPLACED FLOORBEAMS FROM STA 727 - 947, LBL 12 PER SRM 51-10-02 AND 51-SDR UPS02439209Floorbeam · corrodedINSPECTION TYPE:C, COCKPIT BS 340 RBL 10 - 20 FLOOR BEAM UPPER CHORD CORRODED. CORROSION REMOVED IAW 51-10-01 EXCEED SRM LIMIT 53-10-07 FIG 16.SDR SWIA200211317Frame · crackedAT LEFT AND RIGHT FS 718.00 THE FRAME IS CRACKED AT THE PYLON FITTING. FOUND DURING C CHECK INSPECTION. REPAIRED CRACKED FRAME IAW CRJ REO 601R-53-61-193. ANGLE P/N: 600-36030-31, 2024T3-040.SDR SIMA200224012Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, MAINTENANCE FOUND CORROSION ON PREVIOUS REPAIR ON LEFT OMEGA BEAM AT FRAME 20. REMOVED PREVIOUS REPAIR AND FABRICATED AN EXTERNAL ANGLE, FILLER, PLATE AND TWO SHIMS. REPAIR DONE IAW EMB 145 9SRM 145/1142, CHAPTER 53, 53-21-10SDR SIMA200224014Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE FORWARD DIGITAL IN THE GALLEY WAS FOUND TO BE CORRODED. CUT OUT DAMAGED PORTION OF THE DIGITAL. FABRICATED TWO DOUBLER, ONE SHIM. REPAIR DONE IAW EMB 145 SRM (145/1142, REV 18) SRM 53-21-10, AND STANDARD SRM PRACTICES. SDR AALA20021205Floorbeam · corrodedFLOORBEAM CAP CORRODED BLO, STA 4610-4710. CUTOUT CORROSION, INSTALLED STRAP AND DOUBLER IAW AARD.SDR AALA20021206Floorbeam · corrodedFLOORBEAM, BL600R, CAP CORRODED, STA 3845-4850. CUTOUT CORROSION, INSTALLED FLOORBEAM CAP 3845-4850 PER SRM.SDR AALA20021207Floorbeam · corrodedFLOORBEAM CAP CORRODED. (PL600L, STA 3845-4850). CUTOUT CORROSION, INSTALLED FLOORBEAM CAP STA 4175-4575 PER AARD.SDR AALA20021208Floorbeam · corrodedFLOORBEAM CAP CORRODED. BL1127L, STA 3845-4850. REMOVED AND REPLACED TEE-CAP, STA 4175-4575.SDR SWAA021911Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 825, RBL 3. REPAIRED FLOORBEAM PER SRM AND SWA RA.SDR F3LA200200227Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED CORROSION ON UNDERSIDE OF CARGO FLOORBEAM AROUND NUT PLATES, BS 772 TO 513, LBL 2.5.
Back to JASC 5315