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 UPS00833575Floorbeam · corrodedINSPECTION TYPE:C123, STA 1520 FLOORBEAM IS CORRODED BEYOND LIMITS AT LBL 50. REPAIRED FLOORBEAM IAW 8110-3 APPROVED DH SK 806-429.SDR UPS00233556Floorbeam · corrodedINSPECTION TYPE:SI, CORROSION (C53-111-01.00-03) FWD CARGO BAY BS 660 FLOORBEAM FWD SIDE UPPER FLANGE LOWER SURFACE AT LBL 45 TO LBL 50. REMOVED CORROSION IN DESCREPANT AREA AT LBL 45 IN A 2.4 X 1.0 X .030 ORIGINAL THICKNESS .240 OUT OF LIMITS. REMOVED UPPERSDR UPS00233555Floorbeam · corrodedINSPECTION TYPE:SI, CORROSION (C53-111-01.00-02) FWD CARGO BAY STA 540 FLOORBEAM FWD SIDE, UPPER FLANGE, LWR SURFACE AT LBL 45. REMOVED CORROSION ON UPPER CHORD LOWER FLANGE IN AN AREA OF 1.0 X 2.0. FOUND TO BE OUT OF LIMITS PER SRM 53-10-1 FIG 5. CUT OFF TSDR 00FDEA00485Floorbeam · corrodedCORROSION (C53-111-01, 3) ON LOWER CHORD BS 1030 FLOORBEAM LBL 10 - 12, 18, 40 RBL 34, WL 200. *S/D* REMOVED AND REPLACED PER FEDEX SRM 53-10-1, 53-10-8.SDR 00FDEA00487Floorbeam · corrodedCORROSION (C53-224-01, 3) AROUND NUT PLATE HOLES UPPER CHORD BS 1110 FLOORBEAM, RBL 15, LBL 15, LBL 21, LBL 41 - 44, WL 208. *S/D* REMOVED AND REPLACED PER FEDEX SRM 53-10-1, 53-10-8 & FEDEX EA NR 7-5310-52116.SDR SWAA001385Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 420 FLOORBEAM UPPER SURFACE CORRODED RBL 10 TO RBL 16. REPAIRED BEAM SECTION PER SRM.SDR 00FDEA00488Floorbeam · corrodedCORROSION (C53-224-01, 3) ON UPPER CHORD BS 950D FLOORBEAM RBL 10, 2, LBL 10, 21, WL 208. *S/D* BLENDED CORROSION IAW FEDEX SRM 51-10-6. REMOVED AND REPLACED RBL 10 PER FEDEX SRM 53-10-8.SDR 00FDEA00486Floorbeam · corrodedCORROSION (C53-111-01, 3) ON LOWER CHORD BS 1070 FLOORBEAM LBL 27 - 43, RBL 40, WL 200. *S/D* REMOVED, FABRICATED, ALODINED, PRIMED AND INSTALLED NEW REPAIR ANGLES AND FILLERS PER IAW FEDEX SRM 53-10-1 FIG 4 AND FEDEX SRM 53-10-8 FIG 8.SDR UPS00833539Floorbeam · corrodedINSPECTION TYPE:C123, MAIN CABIN FLOORBEAM AT STA 1560 LBL 50 IS CORRODED BEYOND LIMITS. REPAIRED FLOORBEAM IAW 8110-3 APPROVED DH SK 806-427.SDR EISA20000085Floorbeam · corrodedDURING ROUTINE C-CHECK INSP, FOUND FLOORBEAM LEG AT STA 1090 RBL 50, WL 208.1 CORRODED. FABRICATED REPAIR DOUBLER, ALODINED, PRIMED, AND INSTALLED REPAIR DOUBLER, IAW SRM 51-10-1, 53-10-8, 51-10-2, 57-31-2.SDR EISA20000084Floorbeam · misdrilledDURING ROUTINE C-CHECK INSP OF CABIN, AT STA 950 BL 63L FOUND DOUBLE DRILLED HOLE IN FLOORBEAM. FABRICATED REPAIR DOUBLER, ALODINED, PRIMED, AND INSTALLED REPAIR DOUBLER IAW SRM 53-10-8, 51-10-2, 51-30-2.SDR EISA20000083Floorbeam · corrodedDURING ROUTINE C-CHECK INSP OF CABIN STA 1090 BL 47R TO 56R CORROSION ON FLOORBEAM. FABRICATED DOUBLER, ALODINED, PRIMED, AND INSTALLED DOUBLER, IAW SRM 51-10-1, 53-10-8, 51-10-2, 51-30-2.SDR EISA20000080Floorbeam · corrodedDURING ROUTINE C-CHECK INSP, FOUND CORROSION ON TOP OF FLOORBEAM AT STA 1110 BL 10L TO BL 2L. FABRICATED DOUBLER, ALODINED, PRIMED AND INSTALLED, IAW TIMCO REOWOOO19, BOEING DRAWING 65-20821, SRM 51-10-2, 51-20-4, 53-10-8, AND PEMCO STC NR SA144450.SDR EISA20000076Floorbeam · corrodedDURING ROUTINE C-CHECK INSP, FOUND CORROSION AT FLOOR SUPPORT UPPER CAP STRIP STA 1176 LBL 45 TO LBL 60. INSTALLED CHORD SPLICE KIT AND FABRICATED AND INSTALLED WEB REPAIR IAW SB 727-53-0184, BOEING DRAWING 65C33557 AND SRM 51-40-2, 51-10-6, 51-10-2.SDR EISA20000070Floorbeam · crackedDURING ROUTINE C-CHECK INSP, FOUND FLOORBEAM AT STA 380 RBL 30 CRACKED AND CORRODED. FABRICATED REPAIR ANGLES AND FILLER, ALODINED, PRIMED, AND INSTALLED ANGLE AND FILLER IAW SRM 51-10-1, 53-10-8, 51-10-2, 51-30-2.SDR EISA20000060Floorbeam · corrodedDURING ROUTINE C-CHECK CARD INSP, CABIN STATION 1050 BL 642 CORROSION AROUND SCREW HOLES LOWER SIDE FLOORBEAM. FABRICATED FILLER AND DOUBLER, ALODINED, PRIMED, AND INSTALLED DOUBLER AND FILLER IAW B727-200 SRM 51-10-6, 51-30-2, 51-40-2, 51-10-2, 53-10-1.SDR CALA0001143Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER T-CHORD CORRODED AT STA 344, LBL 49 TO RBL 2. THE UPPER T-CHORD WAS REMOVED AND REPLACED IAW SRM 53-10-51, PAGE 222.SDR SWAA001360Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER SURFACES CORRODED, BS 328, RBL 25 AND BS 344, LBL 2 TO RBL 2. REPAIRED BEAMS PER SRM.SDR USAA001038Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 2 INCHES, FS 328 BETWEEN RBL 42 AND LBL 29. CORROSION 12 AREAS LEVEL 1. REMOVED DAMAGED PER SRM 53-10-51 FIG 205. (M)SDR SIMA20310Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED FLOORBEAM 40 CORRODED IN THE LAVATORY AREA. MAINTENANCE REPAIRED THE FLOORBEAM IAW SRM 53-00-00 FIGURE 438. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA2036Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE FOUND FLOORBEAM 38 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IAW SRM 53-00-00 P/N S5367240720202, P/N S5367240820200 AND REPAIRED FLOORBEAM 39 IAW SRM 53-00-00. AIRCRAFT WAS RETURNED TO SERVICE. SDR TWAA0013113Floorbeam · corrodedDURING CHECK-C MAINT, FOUND CORROSION ON FLOORBEAM STA 616 TO 712, RBL 8, AT FASTENER HOLES. REMOVED FLOOR SUPPORT BEAM FROM STA 616 TO 712, RBL 8. INSTALLED NEW BEAM PER DRAWING 5936587.SDR SWAA001347Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 827 FLOORBEAM UPPER SURFACE CORRODED, LBL 25-RBL 25. REPAIRED BEAM PER SRM.SDR USAA001004Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES, STATION 344, LBL 36. FABRICATED T-CAP PER REPAIR DOCUMENT 53-10-51. (M)SDR USAA001003Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES, STATION 344, LBL 28. REMOVED AND REPLACED T-CAP PER SRM 53-10-51. CORROSION LEVEL 1. (M)SDR USAA001002Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES, STATION 344, LBL 14. CORROSION LEVEL 1. FABRICATED T-CAP PER SRM 53-10-51. (M)SDR USAA001001Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH, STATION 312, LBL 12. REMOVED DAMAGED T-CAP PER SRM 53-10-51 FIG 205. (M)SDR USAA001023Floorbeam · corrodedCLT - FOUND T-CAP FLOORBEAM CORRODED 120 INCHES BY 2 INCHES, STATION 986.5 FULL LENGTH OF FLOORBEAM. CORROSION LEVEL 1. FABRICATED NEW T-CAP PER TR 53-60-01. (M)SDR USAA001022Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES, STATION 328, LBL 28. CORROSION LEVEL 1. FABRICATED NEW T-CAP AND INSTALLED PER REPAIR 51-70-12. (M)SDR USAA001021Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES, STATION 312, BL 0. CORROSION LEVEL 1. FABRICATED NEW T-CAP AND SPLICE ANGLE PER SRM 53-10-51. (M)SDR USAA001020Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH, STATION 312, RBL 36. FABRICATED NEW T-CAP AND SPLICE ANGLE PER SRM 53-10-51. CORROSION LEVEL 1. (M)SDR AT0000407Floorbeam · corrodedDURING A SCHEDULED INSPECTION AT TIMCO IN LAKE CITY FL, FOUND FLOORBEAM AT BS 980 RBL 22 - 50 CORRODED BEYOND LIMITS. FABRICATED REPAIR ANGLE AND FILLER IAW DC9 SRM 53-05 FIG 204, 51-10-04, 51-10-03, 51-30-05, AND 51-30-02.SDR AT0000406Floorbeam · corrodedDURING A SCHEDULED INSPECTION AT TIMCO IN LAKE CITY FL, FOUND CORROSION ON UPPER CAP OF FLOORBEAM AT BS 996 BL 36R - 46R. REMOVED AND REPLACED UPPER CAP ON FLOORBEAM IAW DC9 SRM 51-10-04, 51-30-01, 51-30-02, AND 51-30-08.SDR SCNA00351Floorbeam · corrodedDURING HEAVY MAINTENANCE CHECK, CORROSION WAS FOUND OUT OF LIMITS ON THE RT FLOORBEAM AT STA 344. REMOVED CORROSION IAW B727 SRM 511006. FABRICATED 1 ANGLE FROM BAC1498231, 1 ANGLE FROM BAC14982785 AND 1 FILLER FROM BAC14982785. TREATED AND PRIMED IAW B727 SDR ABXA000349Floorbeam · corrodedFLOORBEAM WEB AT STATION 786 AND LBL 13.0 IS EXFOLIATED. REPAIRED IAW ABX REA D957-38011.SDR USAA001049Floorbeam · damagedPIT - FOUND FLOORBEAM HAS MECHANICAL DAMAGE IN 3 SPOTS, .250, .200, .500, BS 827, 9 INCHES RIGHT OF BL0, BOTTOM T. REMOVED AND REPLACED T-ANGLE PER SRM 53-00-51 AND EA 55434. (M)SDR USAA001054Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 3 SQUARE INCHES, BS 1016 TOP OF T-CAP AND AT NUTPLATE HOLES. CORROSION LEVEL 1. REPAIRED PER EA 55695 AND TR 53-20-10, REF A. (M)SDR USAA001051Floorbeam · corrodedPIT - FOUND WEB CORRODED 110 INCHES IN 10 PLACES, STATION 1016 TO 986 SUPPORT WEBS, LEFT SIDE WET AREA. CORROSION TASK NR C53-107-02, LEVEL 1. REMOVED AND REPLACED FLOORBEAM 986.5 AND SUPPORT WEBS PER SRM 51-20-01, 51-40-03. (M)SDR SWAA001310Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR BEAM CORRODED, BS 967, LBL 18, WL 208. REPAIRED BEAM PER SRM.SDR AWXA0000461Floorbeam · corrodedC-CHECK CORROSION LEVEL 1, FLOORBEAM AT STA 312 TO 344 LBL 60 MOP SIL HAS CORROSION. CUT OUT DAMAGED AREA, FABRICATED REPAIR PARTS, TREATED AND INSTALLED PARTS IAW B737 SRM 51-30-01 AND 53-10-15.SDR AWXA0000459Floorbeam · damagedNON-ROUTINE LINE, FLOORBEAM AT FS 986.5 LOWER FLANGE HAS PREVIOUS BLEND OUT OF LIMITS. CUT OUT DAMAGED AREA, FABRICATED ANGLES AND FILLER, ALODINED, PRIMED, AND INSTALLED REPAIR PARTS IAW B737 SRM 53-30-51 FIG 202, SRM 51-20-01, AND SRM 51-40-02.SDR SWAA001303Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO BIN FLOORBEAM CORRODED ON UPPER SURFACE, BS 772, RBL 8 AND RBL 3. REPAIRED BEAM PER SWA RA.SDR UPS00233468Floorbeam · corrodedINSPECTION TYPE:C+SI, BS 328 FLOORBEAM HAS SURFACE CORROSION AROUND FASTENERS ON TOP CAP, LBL30. CORROSION REMOVED IAW MM SRM 51-10-06. AREA FOUND TO BE OUT OF LIMITS IAW MM SRM 53-10-1 FIG 5 MAX 0.020 INCH. REPAIR CARRIED OUT IAW MM 53-10-8 FIG 7.SDR GAIA00424Floorbeam · corrodedDURING A C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM, UPPER SURFACE AT BS 380, RBL 25. INSTALLED NEW FILLER PER B727 SRM 53-10-8. (M)SDR GAIA00430Floorbeam · damagedDURING A C-CHECK INSPECTION, FOUND ELONGATED HOLE IN FLOORBEAM AT BS 720B, RBL 63. REPAIRED PER B727 SRM 53-10-8. (M)SDR GAIA00434Floorbeam · damagedDURING A C-CHECK INSPECTION, FOUND ELONGATED HOLE IN FLOORBEAM AT BS 460, RBL 61. REPAIRED FLOORBEAM PER B727 SRM 53-10-8. (M)SDR RIVA0000016Floorbeam · corrodedDURING C CHECK INSPECTION, IT WAS NOTED THAT ON THE LOWER SURFACE ON FLOORBEAM FLANGES AT STATION 344 HAVE CORROSION THAT WAS FOUND TO BE OUT OF LIMITS IAW SRM 53-10-8 FIG 1. REPAIRED CORRODED UPPER CHORD OF FUSELAGE FLOORBEAM AT STATION 344 FROM LBL 60 TO RBSDR SWAA001262Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 987 FLOORBEAM UPPER SURFACE CORRODED, LBL 4. REPAIRED BEAM PER ER NR 00-0718 AND SRM.SDR CALA0001048Floorbeam · chafedINSPECTION FOUND FLOORBEAM CHAFED AT FS 653, RBL 22. REPAIR PARTS WERE INSTALLED IAW SRM 53-05, FIGURE 86, 51-10-04, AND 51-10-03.SDR CALA0001046Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED UNDER AND AROUND NUT PLATES AT FS 1322, RBL 22 - 58. THE AREA WAS REPAIRED IAW SRM 53-05, FIGURE 20A.
Back to JASC 5315