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 P2EA99291Floorbeam · crackedSJO - FLOORBEAM WEB CRACKED AT BS 578 BETWEEN RBL 55 AND RBL 55 AT WL 206. REPAIRED IAW SERVICE BULLETIN 737-53-1061 REVISION 4. (M)SDR P2EA99262Floorbeam · damagedSJO - FLOORBEAM DAMAGED AT BS 360, WL 208 AND BETWEEN RBL 24 AND RBL 60. REPAIRED IAW SRM 53-10-9 FIG 1. (M)SDR DHL9972756CFloorbeam · damagedAT C-CHECK, STA 328 FLOORBEAM AT LBL 46 HAS FLOOR PANEL SCREW HOLE REWORKED BEYOND LIMITS. CUT OUT 3 PIECE OF FLOORBEAM, INSTALLED REPAIR PARTS PER SRM 53-10-8, 19 X 2 ANGLE 27 X 2.25 N/R 5810.SDR 9903911162Floorbeam · crackedDURING M-CHECK, FOUND CRACK IN FLOORBEAM AT FS 1099, LBL 58. REPAIRED PER EA 11-106300.SDR 20000515AP030Floorbeam · corrodedFOUND CABIN FLOORBEAM STATION 1030 LBL 25 THROUGH RBL 25 HAS CORROSION. REMOVED CORROSION, OUT OF LIMITS. FABRICATE ANGLE REPAIR AND STRAP IAW SRM 51-40-2 PAGE 6, 51-10-6 PAGE 12. (M)SDR UPS99230881Floorbeam · corrodedINSPECTION TYPE:SI, CORROSION (C53-111-01.00-02) ON BEAM BS 540-660 BL 0 WL 200. CUT OUT DAMAGED FLOOR STRAP BS 510 TO 6.70, FABRICATED REPLACEMENT PART AND SPLICE ANGLES, INSTALLED REPAIR PART PER ERO 99-6120.SDR 20000515AP053Floorbeam · corrodedFOUND CABIN FLOOR SUPPORT STATION 400 TO 420 RBL 4 HAS CORROSION. REMOVED FLOOR SUPPORT ANGLE, CRACKED. FABRICATED AND INSTALLED ANGLE SUPPORT IAW SRM 51-20-1 FIG 7, 51-30-2 PAGE 2. (M)SDR USAA990883Floorbeam · crackedTPA - DURING CX-4 CHECK VISUAL INSPECTION, FOUND A 3 INCH CRACK FLOORBEAM AT BS 807 AFT CARGO COMPT. INSTALLED DOUBLER PER EA 65091 SRM 51-70-10/53-00-51 SECT 41, 43 PAGE 201 AND 202. (M)SDR UPS99230531Floorbeam · corrodedINSPECTION TYPE: SI, CORROSION ON FLOORBEAM UPPER TEE BS 620 RBL 26 TO 43. CORROSION FOUND TO BE OUT OF LIMITS ON CHORD AT RBL 31-36.5. PERFORMED FLOORBEAM REPAIR PER SRM 53-10-8.SDR QXEA9901889Floorbeam · dirtyPDX - RIGHT-HAND FLOORBEAM 1127 REQUIRES CLEANING IN THE AREA OF FRAME 4900. CLEANED AREA AS REQUIRED.SDR DHL9972754CFloorbeam · corrodedAT C-CHECK, STA 340 FLOORBEAM UPPER CHORD HAS CORROSION BEYOND LIMITS FROM LBL 64 TO LBL 19. REMOVED T ANGLE FROM BS 344 FROM LBL 60 TO RBL 60, INSTALLED NEW T ANGLE PER SRM 53-10-2. INSTALLED NEW HAT CHANNEL FROM BS 320 TO 344 RBL 20 PER SRM 53-10-1, 36 INCSDR CALA9901075Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM UPPER SURFACE CORRODED AT STA 294 FROM LBL 20 TO RBL 30. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A NEW SECTION WAS INSTALLED USING SPLICE ANGLES IAW SRM 53-10-51, FIGURE 205.SDR 99ZZZX3440Floorbeam · corrodedDURING ACCOMPLISHMENT OF ROUTINE 'C' CHECK WORK CARD, FOUND FLOORBEAM CORRODED AT BS 312R RBL 62.5. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PER SRM 51-10-1.SDR 99UAL900440Floorbeam · corrodedCORROSION WAS DISCOVERED ON THE UPPER CHORD OF THE STATION 1070 FLOORBEAM (P/N 65-20821-21), CENTERED ABOUT RBL 26. THE DAMAGE COVERS A SPAN OF SIX (6) FASTENER ROWS LOCATED BETWEEN THE RBL 24.75 SEAT TRACK AND THE GALLEY RAIL INBOARD OF THIS LOCATION. A REPSDR 99UAL900439Floorbeam · misdrilledA .1562 INCH DIAMETER HOLE WAS MISDRILLED ON THE UPPER CHORD OF THE STATION 360 FLOORBEAM AT ABOUT RBL 54. THE HOLE GOES THROUGH THE HORIZONTAL FLANGE AND EXTENDS INTO THE VERTICAL WEB OF THE FLOORBEAM. THE DAMAGE WAS REPAIRED PER THE INSTRUCTIONS GIVEN IN TSDR RRXA991633Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, FLOOR SUPPORT AT STA 600, BETWEEN LONGERON 33 RIGHT AND LONGERON 36. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED FLOOR SUPPORT IAW DACSDR CALA9901073Floorbeam · corrodedINSPECTION FOUND MAIN DECK FLOORBEAM IN AFT CARGO COMPARTMENT CORRODED AT STA 1130 FROM BL 0 TO RBL 30. REPAIRED IAW SRM 53-10-8 AND ECRA 5310-03898.SDR CALA9901066Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, LBL 14 TO RBL 12. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR C2XA99IA488Floorbeam · corrodedDURING CONTINENTAL EXPRESS C-CHECK, FOUND RIGHT FLOORBEAM AT FRAME 39 CORRODED. REMOVED CORROSION IAW SRM 51-21-42. REPAIRED FLOORBEAM IAW CONTINENTAL EXPRESS EC5310-01037. AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR K4HA99082Floorbeam · corrodedDURING ROUTINE ACCOMPLISHMENT OF SCHEDULED C CHECK AND CPCP TASK CARDS, FOUND CORROSION AND CRACK IN FLOORBEAM FWD UPPER FLANGE. REMOVED FLOORBEAM FLANGE ANGLE PER L1011 SRM 51-40-01. INSTALLED FABRICATED ANGLE PER L1011 SRM 51-40-01.SDR K4HA99079Floorbeam · corrodedDURING ROUTINE ACCOMPLISHMENT OF SCHEDULED C CHECK AND CPCP TASK CARDS, FOUND CORROSION. FLOORBEAM WEB CRACKED AT TOOLING HOLE. REMOVED DAMAGE IAW L1011 SRM 51-50-01 FIGURE 2. FABRICATED REPAIR PARTS IAW L1011 SRM 51-50-01. INSTALLED REPAIR IAW L1011 SRM 5SDR AALA994145Floorbeam · corrodedAFW - FLOORBEAM AT STATION 1681 HAS CORROSION REMOVED. A .080 THICK 7075-T6 REPAIR ANGLE WILL BE INSTALLED UNDER FORWRD FLANGE OF FLOORBEAM. A .071 THICK 7075-T6 FILLER WILL BE ADDED IN THE AREA OF THE REMOVED DECK PLATE. A .080 THICK 7075-T6 DOUBLER WAS FASDR CALA9901059Floorbeam · corrodedINSPECTION FOUND CORROSION ON FLOORBEAM WITH FASTENERS PULLED THROUGH AT STA 328, LBL 11. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-10-51.SDR CALA9901056Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312 BETWEEN LBL 10 AND RBL 32. INSTALLED REPAIR IAW SRM 53-10-51, FIGURE 205.SDR CALA9901055Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 320, BL 0 TO LBL 42. THE CORRODED AREA WAS CUT OUT AND A REPAIR WAS INSTALLED IAW SRM 53-10-8, PAGE 51-52.SDR UPS99830350Floorbeam · crackedINSPECTION TYPE:C123, CORROSION FLOORBEAM FS 1600 RT. REPAIRED IAW REO-06679, INSTALLED IAW DC8 SRM 51-1-20D.SDR UPS99830334Floorbeam · crackedINSPECTION TYPE:N/A, FOUND FLOORBEAM CRACKS AT STA 1600 AND 1620. *S/D* REPAIR COMPLETED ON FLOORBEAM.SDR 9904172715Floorbeam · corrodedDURING M CHECK, FOUND CORROSION ON THE UPPER FLANGE OF THE FS 1050 FLOORBEAM BETWEEN LBL 2 AND THE ENF OF THE BEAM ON THE LEFT SIDE. REPAIRED PER EA 27-167983.SDR AT0000179Floorbeam · corrodedDURING A SCHEDULED INSPECTION AT TIMCO IN LAKE CITY FL, FOUND FORWARD CABIN FLOORBEAM AT BS 160 - 237 BL 0 TO HAVE CORROSION. REMOVED AND INSTALLED NEW FLOOR SUPPORT AT BS 160 - 237 BL 0 IAW DC9 SRM 51-10-02, 51-30-02, 51-10-04, 51-10-03.SDR COMA9960445Floorbeam · corrodedFLOORBEAM CAP RBL9 CORRODED BETWEEN FS 319 AND FS 339 P/N 601R31113-67. REMOVED CORROSION FROM FLOORBEAM CAP RBL9 BETWEEN FS 319.00 TO FS 339 IAW REO 601R-53-00-005 SURFACED TREATED IAW SRM 51-25-06, SRM 51-25-16.SDR UPS99230470Floorbeam · corrodedINSPECTION TYPE:C, FLOORBEAM LWR CHORD BS 1130 RBL 20-24 HAD CORROSION. CORROSION REMOVED IAW SRM 51-10-6 FIG 3, FOUND OUT OF LIMITS. AREA TRIMMED TO REMOVE CORROSION IAW SRM 51-10-6 FIG 3. REF SMRO EO 99-24-004 R1 UPS ENGINEERING FILE NR 727-53-2161.SDR C2XA99IA442Floorbeam · corrodedDURING CONTINENTAL EXPRESS C-CHECK, FOUND FLOORBEAM AT FRAME NR 38 CORRODED. REMOVED CORROSION AND REPAIRED IAW EC5310-01037. AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA99IA441Floorbeam · corrodedDURING CONTINENTAL EXPRESS C-CHECK, FOUND FLOORBEAM AT FRAME NR 39 CORRODED. REMOVED CORROSION AND REPAIRED IAW EC5310-01037. AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA99IA440Floorbeam · corrodedDURING CONTINENTAL EXPRESS C-CHECK, FOUND FLOORBEAM AT FRAME NR 40 CORRODED. REMOVED CORROSION AND REPAIRED IAW EC5310-01037. AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR 99ZZZX3425Floorbeam · corrodedDURING ACCOMPLISHMENT OF ROUTE C-CHECK WORK CARD, FOUND CORROSION ON FLOORBEAM AT FS 440 LBL 62 TO RBL 62. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PER SRM 53-10-8.SDR COMA9960446Floorbeam · corrodedFLOORBEAM CAP LBL9 CORRODED BETWEEN FS 319 AND FS 339 P/N 601R31113-67. REMOVED CORROSION FROM FLOORBEAM CAP LBL 9 BETWEEN FS 319.00 AND FS 339 IAW REO 601R-53-00-005. ETCHED, ALODINED, PRIMED AND PAINTED IAW SRM 51-25-06, SRM 51-25-16.SDR COMA9960441Floorbeam · corrodedFLOORBEAM CAP LBL 27 CORRODED BETWEEN FS 319, FS 339 (P/N 601R31113-67) CORRODED BEYOND LIMITS OF REO 601R-53-005 SPLICE IN NEW SECTION IAW REO 601R-53-00-027. REMOVED CORRODED SECTION OF FLOORBEAM LBL 27 BETWEEN FS 319.00 TO FS 339.00 (P/N 601R31113-67) AND SDR COMA9960440Floorbeam · corrodedFLOORBEAM CAP RBL 27 CORRODED BETWEEN FS 310 TO FS 362 (P/N 601R31113-67). ALSO, MINOR CORROSION AT RIVNUTS BETWEEN FS 349 AND FS 409. PERFORMED A MAJOR REPAIR REMOVED CORRODED SECTION OF FLOORBEAM CAP RBL 27 BETWEEN FS 315 TO FS 362 (P/N 601R31113-67) AND SSDR COMA9960438Floorbeam · crackedFS 280 CRACKED JUST OUTBOARD OF FLOORBEAM AT RBL 9 (P/N 600-34017-17). MAJOR REPAIRED FS 280 CRACK JUST OUTBOARD OF FLOORBEAM RBL 9 ON FS 780.00 600-34017 IAW WVAC EO 601R-53-0212A.SDR COMA9960435Floorbeam · corrodedFLOOR PLATE AT FS 349 BETWEEN LBL 27 AND LBL 9 CORRODED (P/N 601R38573-19). PERFORMED A MAJOR REPAIR, REMOVED CORRODED FLOORBEAM PLATE BETWEEN LBL 27 AND LBL 9 FS 349.00 AND INSTALLED NEW FLOORBEAM PLATE (P/N 601R38673-19) IAW WVAC EO 601R-53-0206.SDR COMA9960433Floorbeam · crackedLBL 9 FLOORBEAM WEB (P/N 601R31113-29) CRACKED APPROXIMATELY 2 INCHES ON OUTBOARD SIDE OF FLOORBEAM FS 281.00 UNDER L ANGLE (P/N 601R31113-57). REMOVED CRACKED WEB FROM OUTBOARD SIDE OF FLOORBEAM LBL 9 BETWEEN FS 280.00 AND 292.00. INSTALLED NEW WEB IAW WVACSDR COMA9960430Floorbeam · corrodedFLOOR PLATE AT FS 349.00 BETWEEN RBL 27, AND RBL 42 CORRODED (P/N 601R38673-25). PERFORMED MAJOR REPAIR, REMOVED CORRODED FLOORBEAM PLATE BETWEEN RBL 27 AND RBL 42 FS 349. INSTALLED NEW PLATE IAW WVAC EO 601R-53-02-6, 707ST6-100.SDR COMA9960429Floorbeam · corrodedFLOOR PLATE AT FS 349 BETWEEN LBL 42 AND LBL 27 CORRODED (P/N 601R38673-17). PERFORMED A MAJOR REPAIR REMOVED CORRODED FLOORBEAM PLATE BETWEEN LBL 42 AND LBL 27 FS 349.00. INSTALLED NEW PLATE (P/N 601R38673-17) IAW WVAC EO 601R-53-02-6.SDR CALA9901045Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 344, RBL 10 TO LBL 50. REPAIRED FLOORBEAM IAW SRM 53-10-51.SDR CALA9901044Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 328, LBL 15 TO RBL 50. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR USAA990862Floorbeam · crackedPIT - DURING CX 3 CONV CHECK, FOUND CRACK APPROX .500 INCH FLOORBEAM AT FS 344 AT LBL 11. REPAIRED PER SRM 53-10-51 AND EA 52604. (M)SDR UPS99830434Floorbeam · corrodedINSPECTION TYPE:C123, FS 798 FLOORBEAM AT RBL 48 WAS CORRODED OUT OF LIMITS. CUT OUT DAMAGED AREA AND REPAIRED THE FLOORBEAM IAW DH SK867-114.SDR SWAA991317Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM UPPER FACE, BS 772, LBL 3 - LBL 12. REPAIRED BEAM PER SWA RA NR 1-A53-2021.SDR SWAA991309Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM FWD FLANGE, BS 328, RBL 49. REPAIRED FLOORBEAM PER SRM.SDR SWAA991308Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION AT FLOORBEAM UPPER FACE, BS 986, RBL 43 - LBL 43. REPAIRED BEAM PER SRM.
Back to JASC 5315