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 03FDEA01507Floorbeam · corrodedCORROSION ON UPPER CHORD OF FLOORBEAM BS 1130 LBL 32 AND 37 WL 208. REMOVED DAMAGED AREA OF FLOORBEAM, FABRICATED REPAIR ALODINED, PRIMED, PAINTED & INSTALLED REPAIR IAW SRM 53-10-8 FIG 10 BS 1130 LBL 32-38 WL 208.SDR 03FDEA01511Floorbeam · corrodedCORROSION BS 1070, WL 201, LBL 25-45 AROUND AND IN NUT CLIP HOLES. CORROSION ON FLOORBEAM BS 1070, WL 201, LBL 25-45 AROUND END IN NUT CLIP HOLES FOUND TO BE OUT OF LIMITS IAW SRM 53-10-1. REPAIRED FLOOR BEAM IAW SRM 53-10-8.SDR C2XA03TY161Floorbeam · corrodedDURING A SCHEDULED INSPECTION THE RT HAND FORWARD DIGITAL UNDER THE GALLEY WAS FOUND TO BE CORRODED. MAINTENANCE ACCOMPLISHED A DOUBLER REPAIR IAW EMB SRM 53-21-10 AND CPM 51-21-04,05AND 06. THE REPAIR WAS SATISFACTORY, THE AIRCRAFT WILL BE RELEASED UPON COMPSDR C2XA03TY159Floorbeam · corrodedDURING A SCHEDULED INSPECTION THE FORWARD FLOORBEAM TOP CAP WAS FOUND TO BE CORRODED UNDER SEAT TRACK LF1. MAINTENANCE REMOVED AND REPLACED THE TOP CAP IAW EMB SRM 51-40-02 AND M.M. 53-01-06, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COSDR 03FDEA01500Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD, STA 340, RBL 4 WL 208.SDR 03FDEA01518Floorbeam · corrodedCORROSION ON FLOORBEAM UPR FLANGE UPR SURFACE STA. 1010 RBL 25-45 WL 208.SDR GAIA03094Floorbeam · corrodedDURNG B-2 CHECK, FOUND MAIN CABIN FLOORBEAM ANGLE CORRODED LBL 60 BS 848. REF FASI N/R 53138 ACCOMPLISHED DOUBLER REPAIR PER B727 SRM 51-40-3 AND 53-10-1 FIG 1. (M)SDR GAIA03093Floorbeam · corrodedDURING B-2 CHECK, FOUND MAIN CABIN FLOORBEAM UPPER 'T' CAP CORRODED RBL 45.5 BS 765 TO 848. REF FASI N/R 53136 REPLACED DAMAGED 'T' CAP P/N 65-16279-10 PER B-727 SRM 51-30-5, AND 51-30-2. (M)SDR GAIA03096Floorbeam · corrodedDURING B-2 CHECK, FOUND FORWARD LAVATORY FLOORBEAM UPPER 'T' CORRODED BS 344 RBL 25 TO RBL 50 ALSO AT LBL 25. REF FASI N/R 53195, REPLACED FLOORBEAM UPPER 'T' CAP RBL 60 TO LBL 60 PER B77 53-10-8 FIG 3 AND 51-30-2. (M)SDR GAIA03095Floorbeam · corrodedDURING B-2 CHECK, FOUND MAIN CABIN FLOORBEAM BS 480 CORRODED AT LBL 30 AND CRACKED AT LBL 59. REF FASI N/R 53187, CUT OUT DAMAGED AREA, INSTALLED REPAIR PER B727 SRM 53-10-8 FIG 1. (M)SDR SWIA200312472Floorbeam · crackedRT ANGLE CRACKED COCKPIT ENTRY BELOW FLOOR. (DISCOVERED DURING C-CHECK INSPECTION)APPLIED DOUBLER TO RT BRACKET BELOW FLOOR AT COCKPIT IAW SRM 12051-10-02.SDR SWIA200312471Floorbeam · crackedLT ANGLE CRACKED COCKPIT ENTRY BELOW FLOOR. (DISCOVERED DURING C-CHECK INSPECTION) APPLIED DOUBLER TO LT BRACKET BELOW FLOOR AT COCKPIT IAW SRM120 51-10-02 .SDR C2XA03TY151Floorbeam · corrodedDURING A SCHEDULED INSPECTION THE FLOORBEAM AT FRAME 22 RT, WAS FOUND TO BE CORRODED IN SEVERAL AREAS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FRAME 22 IAW EMB SRM 51-40-02, THE REPAIR WAS FOUND TO BE SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPOSDR UPS03241354Floorbeam · crackedINSPECTION TYPE: C, ON INSPECTION OF CONTROL CABLES BS 740 - 950 CRACK FOUND ON FLOORBEAM WEB BS 520 LBL 50. REPAIR CARRIED OUT IAW SRM 51-40-2SDR AWXA200301072Floorbeam · corrodedDURING C-04 CHECK INTERGRANULAR CORROSION WAS FOUND ON UPPER SURFACE OF Y1292 FLOORBEAM 3 INCHES FORWARD OF FR 68. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. REMOVED CORRODED Y1292 FLOORBEAM FR 68; FABRICATED A NEW REPLACEMENTSDR 2003UALA00678Floorbeam · crackedSTA. 927 AT RBL45 INCH FLOORBEAM HAS A CRACK IN THE WEB AND A CRACK IN THE RADIUS OF THE T CAP. MAJOR REPAIR ACCOMPLISHED, INSTALLED ANGLES AND STRAPS.SDR 2003UALA00674Floorbeam · crackedSTATION 927 AT RBL45 INCH, FLOORBEAM HAS A CRACK IN THE WEB AND A CRACK IN THE RADIUS OF THE T-CAP. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE AND STRAP REPAIRS.SDR F3LA200300129Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM CORRODED AT STA 312. REPLACED FLOORBEAM T-CAP AND SPLICES AT STA 312, RBL 24 TO LBL 34, PER SRM 53-10-51, FIG 205, 51-40-02, 51-10-02 AND SOPM 20-41-02.SDR AWXA200301069Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF Y1292 FLOORBEAM BETWEEN FR 65-66. MAINTENANCE FOUND CORROSION TO BE OUT OF LIMITS. REMOVED CORRODED Y1292 FLOORBEAM BETWEEN FR 65-66; FABRICATED A NEW REPLACSDR AWXA200301068Floorbeam · corrodedDURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF Y924 FLOORBEAM AT FR 66. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. REMOVED CORRODED Y924 DUMMY RAIL AT FR 66; INSTALLED NEW REPLACEMENT RAIL IAW A320 SRM 5SDR C1HA200386006Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD AT BS 1166 RBL 45.SDR C1HA200386005Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD AT BS 312.SDR C1HA200386002Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD AT BS 344.SDR 0704004Floorbeam · crackedANGLE CRACKED RBL 24 AT FLOORBEAM.SDR 2003UALA00670Stiffener · crackedFLOORBEAM STIFFENER AT STA 246, LBL 40 IS CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW STIFFENER.SDR C2XA03SH318Floorbeam · corrodedSHV-DURING C CHECK THE CENTER OMEGA BEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-22-10 FIGURE 201 SHEET 2. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR UPS03441233Floorbeam · corrodedBS 400 FLOORBEAM UPPER SECTION UPPER FACE BTN RBL 0 / RBL 37 CORRODED. CORROSION REMOVED IAW SRM 51-10-01 CORROSION BLEND OUT 0.050 INCH X 1 INCH X 1 INCH EXCEED SRM 53-10-01 FIG 1 LIMITS, FOR BS400 RBL 0" REPAIR REFER SRM 53-10-07 FIG 8. CIC APPLIED IAW EO MSDR CALA0300529Floorbeam · corrodedINSPECTION FOUND CORROSION ALONG THE ENTIRE UPPER SECTION OF FLOORBEAM AT STA 967. THE CORRODED AREA OF FLOORBEAM WAS CUT OUT AND A REPAIR SECTION WAS INSTALLED IAW ECRA 5311-01142.SDR C2XA03SH317Floorbeam · corrodedSHV-DURING C CHECK THE LEFT HAND OMEGA BEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 202 SHEET 2. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH315Floorbeam · corrodedSHV-DURING C CHECK THE LEFT HAND OMEGA BEAM BETWEEN FRAMES 19 AND 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EC 5320-01099. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SIMA200325303Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE CENTER OMEGA BEAM AT FRAME 25 WAS FOUND CORRODED BELOW SRM LIMITS. CUT OUT SECTION OF THE OMEGA BEAM. FABRICATED AN EXTERNAL ANGLE, FILLER AND TWO SHIMS. REPAIR DONE IAW EMB REPAIR STATEMENT IC2003-145/2917. (M)SDR AWXA200301139Floorbeam · corrodedDURING C-16 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOORBEAM AT BS 305, FORWARD FLIGHT ATTENDANT SEAT MOUNT. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED FLOORBEAM AT BS 305 BETWEEN LBL 10 AND LBL 40; FABRICATSDR AWXA200301136Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-16 CHECK INTERGRANULAR CORROSION WAS FOUND AT FASTENER HOLES ON UPPER SURFACE OF FLOOR BEAM AT BS 294, LBL 12 TO LBL 30. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT DAMAGE ON UPPER T CHORDSDR SWIA200312453Floorbeam · crackedFS 280 RT FLOORBEAM RBL 9.0 I/B & O/B ATTACH ANGLES CRACKED. DISCOVERED DURING C-CHECK INSPECTION. ANGLES REPLACED IAW CRJ SRM 51-40-11.SDR 2003UALA00663Floorbeam · dentedAFT PIT STA 1580 FLOORBEAM AT RBL48 FLOOR LINE DENTED 2.8IN BY 0.90IN BY 0.260 DEEP. MAJOR REPAIR ACCOMPLISHED. FABRICATED A NESTED ANGLE REPAIR. INSTALLED WITH SHIMS AND FILLERS, SEALED AND PAINTED.SDR SIMA200325302Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE LEFT OMEGA BEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. REMOVED THE DAMAGED SECTION OF THE LEFT OMEGA BEAM, THE CUTOUT OF THE FLANGED AREA WAS EXTENDED BEYOND THAT OF THE WEB TO EMCOMPASS THE RESDR SIMA200325306Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE GALLEY FLOOR CENTER BEAM WAS FOUND TO BE CORRODED BELOW SRM LIMITS. REMOVED EXISTING CENTER BEAM AND INSTALLED NEW BEAM. REPAIR DONE IAW EMB 145 SRM, SRM EMB 145/1142 REV 22, 51-40-02, AND 51-40-04 AND CPM 51-21-04. (M)SDR 2003UALA00654Floorbeam · crackedAFT CARGO COMPT AT STA. 1580, RBL 48 INCH FLOORBEAM CRACKED BELOW UPPER T-CHORD. MAJOR REPAIR ACCOMPLISHED. WEB REPAIRED AND DOUBLER INSTALLED.SDR 2003UALA00660Floorbeam · corrodedCABIN FLOORBEAM CHORD CORRODED. MAJOR REPAIR ACCOMPLISHED. FLOOR BEAM UPPER 'T' CAP.SDR 2003UALA00653Floorbeam · bentFLOORBEAM BENT AT STA 760 AND RBL 42.50. INSTALLED NESTED ANGLE EXTRUSION REPAIR USING FILLER AND WEB.SDR 03FDEA01399Floorbeam · corrodedCORROSION ON BS 1130 FLOORBEAM UPPER CHORD AROUND HOLES AND UNDER NUT PLATES, LBL 48, WL 208. CORROSION WAS FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REPAIRED FLOORBEAM AT BS 1130, LBL 48, WL 208 FWD UPPER FLANGE PER SRM 53-10-8.SDR SWAA031925Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO COMPT LONGITUDINAL FLOORBEAM CORRODED AT BS 860, LBL 8. REPAIRED BEAM PER SRM AND SWA EA.SDR 03FDEA01397Floorbeam · corrodedA/C BAY LT SIDE, ABOVE PANEL 3355L, CORROSION ON TORQUE BOX LWR FLANGE NUT CLIPS FOUND DAMAGE TO LOWER FLANGE TO BE .066 MATERIAL LOSS ORIGINAL THICKNESS .125. FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED CHORD. DRILLED UP NEW CHORD. ALODINED, PRIMED & INSTASDR 03FDEA01398Floorbeam · corrodedCORROSION AT NUT PLATES BS 351 TO 341, LBL 18 TO RBL 18, W/L 152. REMOVED CORROSION ON T-CHORD AT VARIOUS LOCATIONS 1 X 1 X .077 INCH FROM ORIGINAL THICKNESS OF .097 INCH AT BS 341-351, LBL 18, RBL 18, WL 152 AND IS FOUND TO BE OUT OF LIMITS IAW SRM 53-10-1SDR C2XA03TY142Floorbeam · corrodedTYS DURING A SCHEDULED 2C INSPECTION THE FLOORBEAM AT FR 22 RT SIDE WAS FOUND CORRODED IN SEVERAL AREAS. MAINT R&R THE FLOOR BEAM AT FR 22 IAW EMB 135/145 SRM 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE REL. UPON COMPLETION OF ALL WORK.SDR C2XA03SH302Floorbeam · corrodedSHV-DURING C CHECK THE LEFT HAND OMEGA BEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 202 SHEET 1. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH301Floorbeam · corrodedSHV-DURING C CHECK THE CENTER OMEGA BEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-22-10 FIGURE 201 SHEET 2. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH299Floorbeam · corrodedSHV-DURING C CHECK THE RIGHT HAND OMEGA BEAM AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 204 SHEET 2. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH298Floorbeam · corrodedSHV-DURING C CHECK THE CENTER OMEGA BEAM BETWEEN FRAMES 20 AND 22 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 CALA0300493Floorbeam · corrodedINSPECTION FOUND FORWARD CARGO COMPARTMENT FLOORBEAM CORRODED AT STA 500D BETWEEN S26L AND S27L, LOWER AREA. THE CORRODED AREA WAS CUT OUT AND FILLER, DOUBLER AND A SHIM WERE INSTALLED IAW SRM 53-00-07, FIGURE 203 AND 204.
Back to JASC 5315