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 UPS96221503Floor Beam · corrodedINSPECTION TYPE: SI. CORROSION ON STA 680 FLOORBEAM BOTTOM SIDE OF UPPER CHORD LBL 25-RBL 25 WL 207. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REPAIRED, WILL ADVISE OF REPAIRS.SDR UPS96221500Floor Beam · corrodedINSPECTION TYPE: SI. CORROSION ON STA 328 FLOORBEAM LBL 3 AND LNL 44 WL 207. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS PER SRM 51-10-6. REPLACED UPPER CHORD FLOOR BEAM PER SRM'S 53-10-8, 51-10-2, 53-10-8.SDR AWXA9600671Floor Beam · corrodedPAE - FLT 7838 - DURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOOR BEAM STATION 294.5, LBL 12 TO RBL 12, WL 208. FABRICATED REPAIR AND INSTALLED PER IAW SRM 53-10-51. (M)SDR ABXA9700405Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM, AT STATION 7080. REPAIRED IAW ABX REA Y153-16865-MR.SDR ABXA9700404Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM, AT STATION -8280, RBL 37. REPAIRED IAW ABX REA Y153-16865-MR.SDR ABXA9700403Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM AT STATION 6120, RBL 12 TO 25. REPAIRED IAW ABX REA Y153-16865-MR.SDR ABXA9700395Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND FLOORBEAM AT STATION 7080. REPAIRED IAW ABX REA Y153-16864-MR.SDR ABXA9700394Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM AT STATION 6120, RBL 12 TO 25. REPAIRED IAW ABX REA Y153-16864-MR.SDR ABXA9700392Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM AT STATION 5160, LBL 11. REPAIRED IAW ABX REA Y153-16864-MR.SDR 96FDEA01619Floorbeam · corrodedNR 0652, CORROSION (C53-224-01) ON TOP CHORD OF FLOORBEAM BS 720D RBL 23, LBL 3, 15, 20. *S/D* REPAIRED PER FEDEX SRM 53-10-8.SDR 9624529760Floorbeam · corrodedDURING H-CHECK, FOUND CORROSION IN THE FS 1056 FLOORBEAM LEFT SIDE. REPAIRED BEAM (P/N 9958187) PER EA 97-111777.SDR DHL9672016CFloorbeam · corrodedAT C-CHECK, FLOORBEAM STA 420 LBL 62 CORRODED. REPLACED FLOORBEAM PER SRM 51-10-1, 24 INCHES LONG.SDR ABXA9700391Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM AT STATION 4200. REPAIRED IAW ABX REA Y153-16864-MR.SDR 9623766631Floorbeam · crackedDURING P-CHECK, FOUND A CRACK IN THE BS 460 UPPER DECK FLOORBEAM WEB AT RBL 55. REPAIRED WEB (P/N 65B10933-34) PER EA 66-120426.SDR CALA9601669Floorbeam · corrodedINSPECTION FOUND FORWARD CABIN FLOORBEAM AT STA 328 CORRODED FROM 29 LEFT OF CENTER TO AIRCRAFT CENTERLINE. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR P5CA9600877Floor Beam · corrodedLEVEL 1 CORROSION ON MAIN DECK FLOOR BEAM AT BS 1860 LBL 85 TO LBL 95. REMOVED CORROSION PER BAC SRM 51-10-01 AND REPROTECTED PER BAC MM 51-24-11.SDR CALA9601518Floorbeam · crackedINSPECTION FOUND A 1.5 INCH CRACK IN LOWER RADIUS OF FLOORBEAM AT STA 675, BBL 0. THE LOWER T-CHORD WAS REMOVED, A NEW CHORD WAS FABRICATED AND INSTALLED IAW SRM 51-20-2, 51-30-2 AND BOEING DRAWING NR 65-45410.SDR 96FDEA01620Floor Beam · corrosionNR 0186 012. CORROSION (C53-113-01(2)) ON LOWER CHORD OF FLOOR BEAM AT NUTPLATE HOLES BS 1070 LBL 41 - RBL 51 WL 200. REPAIRED LOWER CHORD OF FLOORBEAM AT NUTPLATE HOLES BS 1070, LBL 41-RBL 51, WL 200. PER FEDEX SRM 53-10-8.SDR CALA9601668Floorbeam · corrodedINSPECTION FOUND FORWARD CABIN FLOORBEAM CORRODED AROUND SCREW HOLES AT STA 312, FROM R-1 DOOR TO 10 LEFT OF CENTER. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR CALA9601667Floorbeam · corrodedINSPECTION FOUND FORWARD CABIN FLOORBEAM CORRODED AROUND SCREW HOLES AT STA 294.5 AND STA 344. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR C2XA96IA264Floor Beam · crackedIAH - DURING C-CHECK INSPECTION, THE FLOOR SUPPORT AT FRAME 16 WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACD THE AFFECTED FLOOR BEAM AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA96IA261Floor Beam · corrodedIAH - DURING C-CHECK INSPECTION, THE FLOOR SUPPORT FROM FRAME 39 TO 44 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOOR BEAM, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR CALA9601660Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 947.5, LBL 3 TO 8. THE CORRODED AREA WAS CUT OUT AND A REPAIR WAS INSTALLED IAW SRM 53-00-51.SDR ABXA9700400Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORRODED FLOORBEAM, AT STATION 3720. REPAIRED IAW ABX REA Y153-16865-MR.SDR 96FDEA01595Floor Beam · corrosionNR0180 - 001, CORROSION (C53-113-01, -2) ON LOWER CHORD OF FLOORBEAM AT BS 1010 LBL 1 TO LBL 43 WL 200 AT NUTPLATE HOLES. *S/D* B/S 1010 LBL 1 TO LBL 43 WL 200 REPAIRED LOWER CHORD OF FLOORBEAM PER FEDEX SRM 53-10-8 FIG 8.SDR CKSA96179Floor Beam · corroded/splitKOSC - DURING C-2 CHECK INSPECTION FOUND: STA 1820 LBL 67 FLOOR BEAM UPPER CORD SPLIT AND CORRODED. REPAIRED FLOOR BEAM STA 1820 LBL 67 IAW REPORT NR 96AIA-152 AND 8110-3 DATED 10/15/96. CORROSION TASK CARD NR C53-110-01 TASK CARD NR 87061.SDR CKSA96168Floor Beam · corrodedKOSC - DURING C-2 CHECK INSPECTION FOUND: MAIN CARGO COMPARTMENT STA 1780 BL-ZERO UPPER CHORD OF FLOOR BEAM HAS EXFOLIATION. REPAIRED IAW B747 SRM 51-40-4 AND 51-50-2. CORROSION CARD NR C53-210-01, PART 4 OF 8. TASK CARD NR 76169.SDR AWXA960639Floor Beam · corrodedPAE - FLT 7820 - DURING ROUTINE MAINTENANCE CHECK, FOUND FLOOR BAM STATION 294.5 HAS CORROSION ON UPPER SURFACE AND AROUND FASTENER HOLES, LBL 15 TO RBL 50, WL 208. REMOVED, FABRICATED AND INSTALLED TOP CHORD OF FLOOR BEAM AT BS 294.5, LBL 10 - RBL 65, WL 208SDR AWXA960638Floor Beam · corrodedPAE - FLT 7820 - DURING ROUTINE MAINTENANCE CHECK, FOUND FLOOR BEAM STATION 312 HAS CORROSION ON UPPER SURFACE AND AROUND FASTENER HOLES, RBL 12 TO LBL 17, WL 208. CUT OUT CORRODED AREA OF FLOOR BEAM AND REPAIRED PER SRM 53-10-51. (M)SDR AWXA960634Floor Beam · corrodedPAE - FLT 7814 - DURING ROUTINE MAINTENANCE CEHCK, FOUND CORROSION ON FLOOR BEAM UPPER CHORD AT BS 98G5, LBL 21 THROUGH RBL 12, WL 208. REMOVED, FABRICATED AND INSTALLED NEW UPPER CHORD SECTION PER ER 3-53-1590. (M)SDR AALA961544Floor Beam · corrodedAFW - FLOOR BEAM AT STATION 377 HAS CORROSION, REMOVAL ON UPPER SURFACE MATERIAL REMAINING IS BEYOND SRM LIMITS. REPAIR PER MRB 980. (M)SDR AALA961543Floor Beam · damagedAFW - FLOOR BEAM AT STATION 365 HAS DRILL MARK BLENDOUT, MATERIAL REMAINING IS BEYOND SRM ALLOWABLE LIMITS. REPAIR PER MRB 757-981. (M)SDR AALA961539Floor Beam · corrodedAFW - FLOOR BEAM AT STATION 1640 HAS CORROSION REMOVAL, REMAINING MATERIAL IS BEYOND SRM ALLOWABLE LIMITS. REPAIR PER MRB 757-982. (M)SDR SCNA96351Floorbeam · corrodedDURING HEAVY MAINTENANCE, FOUND CORROSION AROUND FOUR NUTPLATES ON STATION 1921 FLOOR BEAM, FROM LBL 20 TO LBL 38. REMOVED CORRODED SECTION OF FLOOR BEAM, FABRICATED AND INSTALLED A NEW SECTION OF FLOOR BEAM IN ACCORDANCE WITH SRM 51-31-00.SDR F3LA96046Floorbeam · crackedPAE - FOUND FLOORBEAM CRACKED IN UPPER RADIUS BS 520 WL 207.75, RBL 25 AND RBL 46. REPAIRED FLOORBEAM CRACK AT BS 520, WL 207.75, RBL 25 AND RBL 46 IAW EWO 396-0643. (M)SDR F3LA96045Floorbeam · crackedPAE - FOUND FLOORBEAM CRACKED IN UPPER RADIUS AT BS 520, WL 207.75, LBL 25 - LBL 47. REPAIRED CRACKS IN FLOORBEAM AT BS 520, WL 207.75, LBL 25, LBL 45 AND LBL 47 PER EWO NR 96-0643. (M)SDR 97ZZZX1478Floor Beam · corrodedDURING C-7 INSPECTION, LEVEL 2 CORROSION NOTED ON LOWER CHORD OF CABIN FLOOR BEAM AT STA 1130 AT LBL 10.SDR SWAA961118Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, WL 208, RBL 3 TO 8. REPAIRED PER BOEING SRM.SDR CALA9601622Floorbeam · corrodedINSPECTION FOUND CORROSION ON TOP OF FLOORBEAM AT BS 380, RBL 48 TO RBL 67. THE CORRODED AREA WAS CUT OUT, A REPAIR WAS INSTALLED IAW SRM 53-10-8, FIGURE 1.SDR USAA960682Floor Beam · corrosionCLT - DURING C-1 CHECK VISUAL INSPECTION, FOUND 1 INCH BY 1 INCH CORRODED AREAS STATION 1664 FLOOR BEAM. REPLACED UPPER CHORD SECTION, REPAIRED PER SRM 53-00-51, AND SRM 53-00-01. (M)SDR USAA960681Floor Beam · corrosionCLT - DURING C-1 CHECK VISUAL INSPECTION, FOUND SEVERAL CORRODED AREAS 1 INCH BY 1 INCH STATION 1640 FLOOR BEAM. NEW CHORD SECTIONS INSTALLED, REPAIRED PER EA 58911 SRM 53-00-51 FIG 201 AND 203. (M)SDR SWAA961121Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 294, WL 1208, RBL 14, 26, 27 AND 32. REPAIRED PER BOEING SRM.SDR 96FDEA01583Floorbeam · corrodedNR 0437 AND 022, CORROSION (C53-111-01, -3) IN THE AFT CARGO BAY AT BS 1148 LBL 11 TO 23 WL 199 ON FLOORBEAM AT NUTPLATE HOLES. *S/D* CORROSION FOUND TO BE OUT OF LIMITS. REPAIRED FLOORBEAM AT BS 1148 LBL 11 TO 23 WL 199 IAW FEDEX EA 7-5310-31191.SDR TWAA9613006Floor Beam · corrodedMCI - DURING OP-16, FOUND CORROSION ON CABIN LOWER FLOOR BEAM. INSTALLED NEW ANGLE PER SRM 51-01, PAGE 1, ITEM C. (M)SDR 96FDEA01582Floorbeam · corrodedNR 0609 AND 021, CORROSION (C53-224-01, -3) ON STA 1110 RBL 23 WL 208 UNDER TOP FLANGE OF FLOORBEAM. *S/D* FOUND CORROSION TO BE OUT OF LIMITS. CUT OUT DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR IAW FEDEX EA 7-5310-31193.SDR SRAA1074Floorbeam · corrosionDURING C-CHECK, FOUND CORROSION ON CARGO COMPARTMENT FLOORBEAM AT TIE DOWN MOUNT HOLES FS 737E BL 0. REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. CUT OUT CORRODED AREA, FABRICATED AND INSTALLED L-ANGLE AND STRAP IAW LAC SRM 51-140-22.SDR SWAA961101Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 987, LBL 53, WL 208 AND AT BS 1006, WL 208, LBL 30. REPAIRED PER BOEING SRM.SDR SWAA961100Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 53, WL 208. REPAIRED PER BOEING SRM.SDR SWAA961094Bulkhead Angle · corrodedDURING SCHEDULED D-CHECK, FOUND LOWER BULKHEAD ANGLE CORRODED AT BS 520, AT S26 LT AND RT. REPAIRED PER BOEING SRM.SDR SWAA961093Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO BAY FLOOR BEAM CRACKED AT BS 440 AND 500, ABOVE S27R. REPAIRED PER BOEING SRM.
Back to JASC 5315