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 SWAA961213Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM HOLE CORROSION AT BS 1006, LBL 18.5, 22.5, 26, AND 28.5. REPAIRED PER BOEING TI NR A53-014 AND BOEING SRM.SDR BJNA961111Floor Beam · corrodedDURING A SCHEDULED INSPECTION AT AERO COPR IN LAKE CITY, FLORIDA, THE LATERAL FLOOR SUPPORT ANGLE AT BS 268 BL 11L WAS FOUND WITH EXFOLIATED CORROSION ON THE UNDERSIDE OF THE FLT DECK. REMOVED CORRODED FLOOR BEAM. FABRICATED AND INSTALLED NEW FLOOR BEAM IAW SDR 96FDEA01654Floorbeam · corrodedNR 0816 32. WHILE WORKING NR 0636 FOUND CORROSION ON BS 328 FLOORBEAM WL 208 LBL 27, 29 AND 45. REPAIRED BS 328 FLOOR BEAM PER FEDEX SR 27-53-017.SDR UPS96221545Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION STA 1030 FLOORBEAM LBL 5 TO 61 AND RBL 5 TO 30 FWD AFT FLANGES RBL 48 TO 55 FWD FLANGE WL 208 AT NUTPLATE HOLES. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS PER SRM 53-10-1, REPAIRED PER EO 96-2563.SDR CALA9601811Floorbeam · corrodedINSPECTION FOUND CORROSION ON FLOORBEAM AT STA 480 TO 500, RBL 40. THE CORROSION WAS REMOVED, A REINFORCEMENT ANGLE AND FILLER WERE FABRICATED AND INSTALLED IAW SRM 51-10-01, 53-10-07 AND 51-10-02.SDR CALA9601618Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT STA 967. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03362.SDR CALA9601617Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT NUTPLATE HOLE, STA 1006, RBL 20. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03360.SDR CALA9601613Floorbeam · corrodedINSPECTION FOUND FLOORBEAM AT STA 986, LBL 15 TO DOOR SILL AREA CORRODED. THE AREA WAS REPAIRED IAW ECRA 5310-03361.SDR CALA9601611Floorbeam · corrodedINSPECTION FOUND RT SIDE AND CENTER OF FLOORBEAM CORRODED AT STA 986.5, RBL 3, RBL 5, AND RBL 15. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03361.SDR CALA9601610Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLE AT STA 986.5, RBL 40. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03361.SDR 96FDEA01676Floorbeam · corrodedUPPER LOBE FLOORBEAM HAS CORROSION STA 400 RBL 27 TO RBL 35. INSTALLED REPAIR STRAP TO FLOORBEAM PER SRM 53-10-8.SDR DHL9672021CFloorbeam · corrodedAT C-CHECK, CABIN FLOORBEAM AT BS 400 LBL 12 HAS HEAVY CORROSION. CUT OUT DAMAGED AREA OF FLOORBEAM, INSTALLED FLOORBEAM REPAIR PER SRM 53-1-8, REPAIR 13.5 LONG.SDR TWAA9613606Floor Beam · wornSTL - DURING OP-15, FOUND WORN SPOT ON FLOOR BEAM APPROXIMATELY FOUR INCHES LEFT OF CENTERLINE, STATION 370. REPAIRED FLOOR BEAM PER SRM 53-05, PAGE 31, FIGURE 20A. (M)SDR TWAA9613506Floor Beam · wornSTL - DURING OP-15, FOUND WORN SPOT ON FLOOR BEAM APPROXIMATELY FOUR INCHES LEFT OF CENTERLINE, STA 370. REPAIRED FLOOR BEAM PER SRM 53-05, PAGE 31, FIGURE 20A. AIRCRAFT TOTAL TIME: 46,296 HOURS; 43,121 CYCLES. (X)SDR EISA96210Floor Beam · corrodedDURING A SCHEDULED D-CHECK, FOUND A FLOOR BEAM CORRODED STATION 1050-1090 LBL 12. REPLACED FLOOR BEAM PER SRM 51-10-1 AND 51-30-2. (M)SDR EISA96197Floor Beam · corrodedDURING A SCHEDULED D-CHECK, FOUND A FLOOR BEAM CORRODED STATION 720 RBL 20. REPAIRED FLOOR BEAM PER SRM 51-40-6. (M)SDR CALA9601606Floorbeam · corrodedINSPECTION FOUND AFT RIGHT LAV WALL FLOORBEAM CORRODED. THE AREA WAS REPAIRED IAW ECRA 5310-03361.SDR AALA9641Floor Beam · corrodedAFW - FLOOR BEAM HAS CORROSION REMOVAL MATERIAL, REMAINING IS BEYOND SRM ALLOWABLE LIMITS. REPAIRED PER MRB 757-1000. (M)SDR AALA961659Floor Beam · corrodedAFW - FLOOR BEAM HAD 2 AREAS OF CORROSION BLENDED BEYOND SRM LIMITS. REPAIRED PER MRB 757-998. (M)SDR AALA961656Floor Beam · corrodedAFW - FLOOR BEAM HAS CORROSION REMOVAL, MATERIAL REMAINING IS BEYOND ALLOWABLE SRM LIMITS. REPAIRED PER MRB 757-997. (M)SDR AALA961652Floor Beam · corrodedAFW - FLOOR BEAM HAS CORROSION REMOVAL, MATERIAL REMAINING IS BEYOND SRM ALLOWABLE LIMITS. REPAIRED PER MRB 757-996. (M)SDR ZIAA961109Floor Beam · crackedMCN - DURING SCHEDULED CHECK, VISUAL, REFLECTIVE PROBE EDDY CURRENT AND ULTRASONIC INSPECTION TECHNIQUES REVEALED FUSELAGE FLOOR BEAM CRACKED. REPAIRED IAW DWG 174-R20. (X)SDR 96FDEA01646Floorbeam · corrosionNR 0635 026. CORROSION (C53-224-01(1) ON 344 BEAM FROM LBL 60 TO RBL 20 WL 208.1. REMOVED CORROSION ON 344 FLOOR BEAM, TOP CHORD FROM LBL 60 TO RBL 20, W/L 208.1. FOUND TO BE OUT OF LIMITS IAW 727 FEDEX SRM 53-10-01. REMOVED AND REPLACED FLOOR BEAM TOP CHOSDR USAA960720Floor Beam · corrosionINT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND 2 INCH BY 100 INCH CORROSION BS 328 LBBL 50 INCH THROUGH RBBL 50 INCH FLOOR BEAM T-CAP. FABRICATED NEW T-CAP AND SPLICE, REPAIRED PER TR 53-10-13. CORROSION TASK NR C53-107-02, CORROSION LEVEL 2. (M)SDR UPS96221694Floorbeam · corrodedINSPECTION TYPE-C, FLOORBEAM STA 344 RBL 18 UPPER CHORD FWD FLANGE CORRODED BEYOND LIMITS. REMOVED DAMAGED SECTION OF CHORD, FABRICATED AND INSTALLED REPAIR SECTION USING EXISTING SPLICE IAW SRM 51-30-2, 51-40-2.SDR SWAA961194Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM T-CAP CORROSION AT BS 344, RBL 1, 2, 7, 9 AND AT LBL 14, 18 AND 22. REPLACED T-CAPS PER BOEING SRM.SDR RAIA961039Floor Beam · corrosionSTL - CORROSION ON FLOOR BEAM AT FRAME 33. MAINTENANCE REPLACED THE FLOOR BEAM AT FRAME 33. (M)SDR RAIA961034Floor Beam · corrosionSTL - FOUND CORROSION AT SERVICE DOOR TORQUE BOX BEAMS BETWEEN FRAMES 36 AND 39. MAINTENANCE REPLACED FLOOR BEAM BETWEEN FRAMES 36-39. (M)SDR RAIA961030Floor Beam · corrosionSTL - FLOOR BEAM FROM FRAME 36 TO FRAME 39 HAS CORROSION. MAINTENANCE REPLACED THE FLOOR BEAM FROM FRAME 36 TO 39. (M)SDR ABXA9700406Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM AT STATION -9180, RBL 12 TO RBL. REPAIRED IAW ABX REA Y153-16865-MR.SDR ABXA9700399Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM AT STATION +5160, RBL 22. REPAIRED IAW ABX REA Y153-16864-MR.SDR ABXA9700398Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM AT STATION 9180, RBL 12 TO RBL 45. REPAIRED IAW ABX REA Y153-16864-MR.SDR SWAA961208Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND TOP CHORD OF FLOORBEAM CORRODED AT BS 344, LBL 7 AND AT RBL 1, WL 208. REPLACED DAMAGED SECTIONS PER BOEING SRM.SDR SWAA961205Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 270 AND AT BS 947.5, LBL 6 TO 17. REPAIRED PER BOEING SRM.SDR DL72K962438Floorbeam · corrodedTOP OF FLOORBEAM BS 344 RBL 6 TO LBL 36 CORRODED. INSTALLED REPAIR PER SRM 53-10-8.SDR CALA9601654Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1006, LBL 20 TO RBL 20. A NEW UPPER T-FLANGE WAS SPLICED IN IAW SRM 53-00-51.SDR AWXA9600679Floor Beam · corrodedPAE - FLT 7843 - DURING ROUTINE MAINTENANCE CHECK, FOUND CORRSION ON FLOOR BEAM BS 312, WL 208, RBL 10, LBL 10. REMOVED, FABRICATED AND REPLACED FLOOR BEAM TOP CAP FROM RBL 20 TO LBL 20, BS 312, WL 208. (M)SDR ABXA9700402Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM, AT STATION 5640. REPAIRED IAW ABX REA Y153-16865-MR.SDR ABXA9700397Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM AT STATION 600. REPAIRED IAW ABX REA Y153-16864-MR.SDR ABXA9700396Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM AT STATION 600, RBL 18 TO RBL 25. REPAIRED IAW ABX REA Y153-16864-MR.SDR 96FDEA01630Floorbeam · corrodedNR 0648 023, CORROSION (C53-224-01) ON FLOORBEAM AT BS 1030 RBL 48 TO RBL 55. *S/D* REMOVED CORROSION FROM FLOORBEAM AT BS 1030 RBL 48 TO RBL 55. BEAM OUT OF LIMITS IAW FEDEX 727 SRM 53-10-1, REPAIRED BEAM IAW FEDEX 727 SRM 53-10-8.SDR 9624176631Floorbeam · corrodedDURING P-CHECK, FOUND CORROSION ON THE BS 1740 FLOORBEAM UPPER CHORD AT RBL 58. REPAIRED BEAM (P/N 65B26535-7) PER EA 66-106423.SDR USAA960710Floor Beam · corrodedPIT - DURING Q-4/C-6 CHECK, FOUND LEVEL 2 CORROSION AT STATION 996 FLOOR BEAM. INSTALLED NEW BEAM AND MFG DOUBLERS PER SRM 53-05 PAGE 212A FIG 72. CORROSION LEVEL 2. CORROSION TASK NR C58-53300. (M)SDR CALA9601623Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1158, LBL 49. THE CORRODED AREA WAS CUT OUT, FILLER AND STRAP WERE FABRICATED AND INSTALLED IAW ECRA 5310-03355.SDR C2XA96IA273Floor Beam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND FRAME NR 36 FLOOR BEAM TO HAVE CORROSION. INSTALLED DOUBLER TO AFFECTED AREA. AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA272Frame · corrodedIAH - DURING C-CHECK INSPECTION, FOUND FRAME NR 39 FLOOR BEAM TO HAVE CORROSION. INSTALLED DOUBLER TO AFFECTED AREA. AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA271Floor Beam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND FRAME NR 38 FLOOR BEAM TO HAVE CORROSION. INSTALLED DOUBLER TO AFFECTED AREA. AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR AWXA9600674Floor Beam · corrodedPAE - FLT 7838 - DURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOOR BEAM STATION 328, RBL 24-55, WL 208. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53-10-51. (M)SDR 96FDEA01674Floorbeam · corrodedFUSELAGE UPPER LOBE; CORROSION ON FLOORBEAM BETWEEN LBL 0 TO LBL 26 SEAT TRACKS STA 560. REMOVED CORROSION PER SRM 51-10-6, ALODINED AND PRIMED AREA, FABRICATED AND INSTALLED STRAP REPAIR LBL 0 TO LBL 26 STA 560 AS PER EA 7-5310-78928. INSTALLED ADDITIONAL SDR ABXA9700401Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM, AT STATION 6600. REPAIRED IAW ABX REA Y153-16865-MR.
Back to JASC 5315