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 2002UALA01701Beam · corrodedCABIN FLOOR BEAM UPPER CAP CORRODED. STA 365 RBL 10 - RBL 40. MAJOR REPAIR ACCOMPLISHED.INSTALLED SPLICE AND ANGLE REPAIR.SDR SWAA022658Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 773, LBL 13. REPAIRED FLOORBEAM PER SWA RA.SDR MWEA020686Floorbeam · corrodedFLOORBEAM AT STATION 1338 RIGHT OUTBOARD SIDE HAS CORROSION. FABRICATED AND INSTALLED FILLER, DOUBLER, AND STAR FITTINGS.SDR 02FDEA00828Floorbeam · corrodedCORROSION ON TRANSVERSE FLOORBEAM AT BS 900, LBL 65, WL 205. REMOVED AND REPLACED FLOORBEAM IAW EA AND SRM.SDR 02FDEA00869Floorbeam · corrodedCORROSION ON LWR CHORD OF BS 950F AT NUT PLATEHOLE, RBL 24, WL 200.SDR 02FDEA00857Floorbeam · corrodedCORROSION ON UPPER SURFACE OF FLOORBEAM AT BS 328, LBL 3, WL 208. REMOVED CORROSION FOUND TO BE OUT OF LIMITS CUT OUT DAMAGE AREA. FABRICATED REPAIR ANGLES, AND FILLERS, & INSTALLED IAW SRM 51-30-2, 51-30-5, 51-30-8.SDR 02FDEA00827Floorbeam · corrodedCORROSION ON UPPER SURFACE OF FLOORBEAM AROUND FLOOR BOARD HOLES AT BS 360, LBL 6 - RBL 6, WL 208. INSTALLED REPAIR AT LBL 7 BS 360 IAW SRM.SDR 2002UALA01707Floorbeam · corrodedCABIN FLOORBEAM CORRODED, STA 310, RBL 40 TO 44. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2002UALA01705Floorbeam · corrodedCABIN FLOOR BEAM UPPER T-CAP CORRODED, STA 324, RBL 45. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP ANGLE REPAIR.SDR USAA020457Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED 1 SQUARE INCH, FLOOR ATT HOLE, OUTBOARD FLOORBEAM 12 INCHES INBOARD AFT GIRT BAR. REMOVED CORROSION, AND DAMAGED AREA, INSTALLED TRIPLER OVER SPLICE DOUBLER PER EA 94369. (M)SDR USAA020456Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED 2 SQUARE INCH, AFT END OF BEAM AT LEFT AFT LAVATORY, AFT INBOARD ATT HOLE. DEFECTIVE PART REPLACED WITH IDENT PART NR. (M)SDR USAA020455Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED .25 INCH, FLOORBOARD ATTACH HOLE, FORWARD OF FORWARD GIRT BAR PAD. CLEANED CORRODED AREA, DIMENSIONAL CHECK PER SRM AND INSTALLED REPAIR ANGLES PER SRM 53-41-14 FIG 201. (M)SDR SIMA200231702Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND CORROSION ON A PREVIOUS REPAIR TO THE LEFT OMEGA BEAM AT FRAME 20. REMOVED PREVIOUS REPAIR AND INSPECTED THE UNDERLYING BEAM. NO ADDITIONAL DAMAGE NOTED. FABRICATED AN EXTERNAL ANGLE, FILLER, TWO SHIMS AND PLATE. REPASDR 02FDEA00830Floorbeam · corrodedFLOORBEAM SURFACE CORROSION OUT OF LIMITS. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR SIMA200231701Floorbeam · corrodedABI - DURING AN MBV INSPECTION, FOUND CORROSION ON THE LEFT OMEGA BEAM AT FRAME 20. REMOVED CORROSION BY CUT OUT. FABRICATED AN EXTERNAL ANGLE, FILLER AND TWO SHIMS. REPAIR DONE IAW EMB 145 (SRM 145/1142, CHAPTER 53, REV 19) 53-21-10 PARA 2 FIG 201 SHEET 2 SDR 02FDEA00818Floorbeam · corrodedCORROSION ON FLOORBEAM LOWER CHORD BS 1070, RBL 46, WL 200. REPAIRED FLOORBEAM IAW SRM 53-10-8 FIG 8.SDR USAA020454Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED .25 INCH, Y503.2, 1 INCH AFT OF C-14. BLENDED DAMAGED AREA PER TYPICAL REPAIR 53-11-01. (M)SDR USAA020453Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED 1 SQUARE INCH, FRAME 66 AT STATION 71292 LEFT AFT LAVATORY AREA. REMOVED CORROSION, USED NDT PROCEDURE, SEALED AND RESTORED FINISH PER EA 94371. (M)SDR SIMA200232303Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, A PREVIOUS REPAIR ON THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND CORRODED BELOW SRM LIMITS. REMOVED EXISTING REPAIR AND CLEANED AREA. FABRICATED A FILLER, TWO SHIMS, PLATE AND EXTERNAL ANGLE. REPAIR DONE IAW EMB145 SRM (EMB 145SDR SWIA200211512Support Angle · crackedFS 621 LEFT FLOOR SUPPORT ANGLE CRACKED. FOUND DURING C CHECK INSPECTION. REPAIRED DAMAGE IAW CRJ REO 601R-53-61-117 REV. ''A''. ANGLE P/N: 601R53-61-117-1.SDR EIA2002144Floorbeam · damagedMZJ - FOUND LEFT BS 340 UPPER FLOORBEAM HAS OVERSIZED HOLES. DISCREPANT HOLES OVERSIZED AND OVERSIZED FASTENERS INSTALLED ECRA 480-53-122-2. (M)SDR 2002UALA01665Floorbeam · corrodedCABIN FLOOR BEAM CORRODED, STA 1520, STR 27L. MAJOR REPAIR ACCOMPLISHED. INSTALLED INTERNAL ANGLE REPAIR.SDR 2002UALA01664Floorbeam · corrodedCABIN FLOORBEAM UPPER CAP CORRODED, STA 310, RBL 38, STR 17R. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP REPAIR AND L-ANGLE DOUBLER.SDR AWXA200201101Angle · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON THE UPPER SURFACE OF SPLICE ANGLE (AFT R/H CREASE BEAM) BS 1006 TO BS 1016, RBL 52. MAINTENANCE REMOVED THE DAMAGED SPLICE ANGLE; FABRICATED A NEW REPLACEMENT SPLICE ANGLE; AND INSTALLED REPAIR PARTSDR SIMA200231005Floorbeam · corrodedABI - DURING A IMBV INSPECTION, THE RIGHT HAT BEAM AT FRAME 23 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. REMOVED EXISTING HAT BEAM. INSTALLED NEW BEAM IAW EMB 145 SRM, EMB 145/1142 REV 19, CHAPTERS 51-20-03, 51-40-02, AND 51-40-07. (M)SDR 2002UALA01653Floorbeam · corrodedCABIN FLOOR BEAM CORRODED ON UPPER SURFACE OF CAP, STA 324, RBL 8 STR 17R. MAJOR REPAIR ACCOMPLISHED. INSTALLED TWO NESTED ANGLES BELOW UPPER CAP WITH FILLER.SDR C2XA02TY164Floorbeam · corrodedDURING A SCHEDULED INSPECTION THE GALLEY FLOOR FORWARD FLOORBEAM CAP WAS FOUND TO BE CORRODED. MAINTENANCE ACCOMPLISHED A DOUBLER REPAIR IAW EMB-145 SRM 53-21-10, 51-40-02 AND CPM 51-21-04,05,06. THE REPAIR WAS SATISFACTORY, THE AIRCRAFT WILL BE RELEASED UPOSDR C2XA02TY163Floorbeam · corrodedDURING A SCHEDULED INSPECTION THE RT FLOORBEAM WAS FOUND TO BE CORRODED. MAINTENANCE ACCOMPLISHED A BLEND-OUT REPAIR IAW EMB GST 1927/02A, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR AWXA200201130Channel · corrodedYVR - MAJOR REPAIR - DURING C-19 CHECK EXFOLIATION CORROSION WAS FOUND UNDER AFT CARGO FLOOR SUPPORT CHANNEL AT SEVERAL ANCHOR NUTS BETWEEN BS 847 - BS 867; MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT DAMAGED SECTION OF FLSDR C1HA2002027Floorbeam · corrodedFS 1110 MAIN CABIN FLOORBEAM IS EXFOLIATED AT LBL 25 ON THE BOTTOM SIDE OF THE UPPER 'T'.SDR SIMA200231004Floorbeam · corrodedABI - DURING IN IMBV INSPECTION, THE LEFT OMEGA BEAM AFT OF FRAME 24 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT DAMAGED SECTION OF LEFT OMEGA BEAM AND TREATED BARE METAL EDGES. FABRICATED AN EXTERNAL ANGLE, TWO SHIMS AND FILLER. REPAIR DONE IAW EMB SDR 2002UALA01633Web · corrodedRH MID CABIN STA 968.5 TO 969.5 RH CREASE BEAM WEB UPPER SURFACE CORRODED. MAJOR REPAIR ACCOMPLISHED.REPLACED CREASE BEAM WEB.SDR AWXA200201142Angle · corrodedYVR - MAJOR REPAIR - DURING C-19 CHECK INTERGRANULAR CORROSION WAS FOUND AT SCREW HOLES ON THE UNDERSIDE OF INTERCOSTAL BEAMS BS 927 TO BS 1016. MAINTENANCE REMOVED ANGLE UNDER DOOR SILL CHORD AT R/H SIDE BS 967 TO BS 987; BLENDED CORROSION ON INTERCOSTALS BS SDR AWXA200201113Floorbeam · corrodedDURING C-04 CHECK 1 INCH SCATTERED SPOTS OF CORROSION WERE FOUND ON FLOORBEAM ADJACENT TO THE R-1 DOOR, BS 311 TO BS 327. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED FLOORBEAM BS 311 TO BS 327; FABRICATED A NEW RESDR AWXA200201112Floorbeam · corrodedDURING C-04 CHECK 1 INCH SCATTERED SPOTS OF CORROSION WERE FOUND ON UPPER SURFACE OF FLOORBEAM BS 294, FROM RBL 28 TO RBL 54. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT DAMAGED SECTION OF FLOORBEAM AT BS 294, RBL 28 TO RBSDR AALA20021554Floorbeam · corrodedTUL - FOUND 14 SCREW HOLES CORRODED ON FLOOR FRAME AT FS 1640. INSTALLED 'T' ANGLE REPAIR PER SRM 53-00-51-2. (M)SDR 0203831230Floorbeam · crackedDURING "H" CHECK FOUND CRACK IN FLOORBEAM AT BS 575 RBL 101. REPAIRED PER EA 12-162234.SDR 0203699981Floorbeam · corrodedDURING HCK IN ATL, CORROSION WAS FOUND IN THE VERTICLE FLANGE OF THE STATION 200 FLOORBEAM LOWER CAP. THE CORROSION EXTENDED TO THE LEFT OF STATION X=0 ALL THE WAY TO THE END OF THE PART. REPAIRED PER EA 99-190813.SDR AWXA200201121Channel · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON THE UPPER AND LOWER SURFACE OF AFT CARGO R/H SIDEWALL TO FLOOR SUPPORT STRAP ASSEMBLY BS 767 - 792. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS; REMOVED DAMAGED SSDR SIMA200230330Floorbeam · corrodedABI - DURING MBV INSPECTION, FOUND CORROSION ON THE LEFT OMEGA BEAM AT FRAME 20. COMPLETELY REMOVED CORROSION BY CUTOUT. PERFORMED AN EDDY CURRENT INSPECTION OF THE CUT OUT AREA WITH NO DEFECTS NOTED. FABRICATED AN EXTERNAL ANGLE, FILLER, TWO SHIMS. REPAIRSDR LR7A02104Floorbeam · corrodedDURING SCHEDULED C4 INSPECTION PER HST5302 FOUND FLOORBEAM TOP CAP CORRODED FS 737E, LBL 61-RBL 61, WL 146. REPLACED BEAM CAP IAW SRM SMP 583-51-60, 51-70 AND DWG 3317069.SDR LR7A02097Floorbeam · corrodedDURING SCHEDULED C4 INSPECTION PER HST5302 FOUND CORROSION ON FLOORBEAM FS 457, LBL 61-RBL 61, WL 146. REPLACED BEAM CAP IAW SRM SMP 583-51-70-00, 51-60, AND DWG 356120.SDR LR7A02096Floorbeam · corrodedDURING SCHEDULED C4 INSPECTION PER HST5302 FOUND CORROSION ON FLOORBEAM FS 297E, LBL 61-RBL 61, WL 146. REPLACED BEAM CAP IAW SRM SMP 583-51-70, 51-60, AND DWG 364242.SDR LR7A02095Floorbeam · corrodedDURING SCHEDULED C4 INSPECTION PER HST5302 FOUND CORROSION ON FLOORBEAM FS 357, LBL 61-RBL 61, WL 146. REPLACED BEAM CAP IAW SRM SMP 583-51-70-00, 51-60, AND DWG 364242.SDR LR7A02094Floorbeam · corrodedDURING SCHEDULED C4 INSPECTION PER HST5302 FOUND CORROSION ON FLOORBEAM FS 537, LBL 61-RBL 61, WL 146. REPLACED BEAM CAP IAW SRM SMP 583-51-70-00, 51-60, AND DWG 395220.SDR LR7A02093Floorbeam · corrodedDURING SCHEDULED C4 INSPECTION PER HST5302 FOUND FLOORBEAM WITH CORROSION ON TOP FS 257E, LBL 61-RBL 61, WL 146. REPLACED BEAM CAP IAW SRM SMP 583-53-40-06, 51-60, 51-70, AND DWG 364242.SDR AWXA200201127Floorbeam · corrodedDURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF REPAIR "T" CAP AT BS 986, RBL 24 - 57. MAINTENANCE BLENDED CORROSION ON FLOORBEAM "T" CAP UPPER SURFACE AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED 2 EACH FLOOR SUPPORTS AND FLOORBESDR C2XA02TY159Floorbeam · corrodedDURING A SCHEDULED INSPECTION THE AFT FLOORBEAM TOP CAP WAS FOUND CORRODED UNDERNEATH THE GALLEY AREA. MAINTENANCE ACCOMPLISHED A BLEND-OUT REPAIR IAW EMB-145 SRM 53-21-10 AND CPM 51-21-04,05. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA02TY158Floorbeam · corrodedDURING A SCHEDULED INSPECTION THE CENTER FLOORBEAM TOP CAP WAS FOUND CORRODED UNDERNEATH THE GALLEY AREA. MAINTENANCE ACCOMPLISHED A BLEND-OUT REPAIR IAW EMB-145 SRM 53-21-10, 51-21-04,05. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR BJNA021010Floorbeam · corrodedCORROSION ADJACENT TO WATER DRAIN LINE FORWARD UNDER SIDE OF R2 DOOR SCUFF PLATE AREA BS 958 RBL 53. REMOVED CORROSION FROM LOWER OUTBOARD FLOORBEAM SUPPORT, CORROSION WENT OUT OF LIMITS. FABRICATED REPAIR DOUBLER AND INSTALLED IAW B737 SRM 51-40-3, 51-10-2,
Back to JASC 5315