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 RRXA002342Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT FS 700, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES IAW EO NR 00-047 WITH APPROVED 8110-3 DATED SDR RRXA002264Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE FLOORBEAM AT STA 1420 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC-8 SRM 51-1-21 ANSDR RRXA002258Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM 1360 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLERS IAW DC-8 SRM 51-1-4, 51-1-21 SDR RRXA002228Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES TO THE FLOORBEAM 1240 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC-8 SRM 51-1-20D AND EO NSDR RRXA002210Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES TO THE FLOORBEAM IN THE UPPER CARGO COMPT AT FS 640, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED STRAPS/FILLERS AND INSTALLED IAW SDR RRXA002205Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES IN THE FLOORBEAM AT THE UPPER CARGO COMPT FS 1500, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED STRAPS AND FILLERS IASDR RRXA002202Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE FLOORBEAM 1020 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED STRAPS/FILLERS IAW EO NR 00-047 WITH ASDR F3LA00097Floorbeam · corrodedDEN - DURING C-7 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM AT BS 966 ABOVE WATER TANK. MAINTENANCE REMOVED DAMAGED AREA, FABRICATED REPLACEMENT PARTS AND REPAIRED PER EO 51-00-737-001 AND SRM 55-10-9 FIG 7. (X)SDR USAA000707Floorbeam · crackedCLT - Q-4, FLOORBEAM HAD 1.5 INCH CRACK, BS 520 AND RBL 24.75. REPLACED REPAIR ANGLE PER EA 67167 AND SB 737-53-1120. (X)SDR USAA000706Floorbeam · crackedCLT - Q-4, FLOORBEAM HAD 1.5 INCH CRACK, BS 520 AND RBL 45.5. INSTALLED NEW DOUBLER AND CHANNEL PER SB 737-53-1120 AND EA67167. (X)SDR USAA000708Floorbeam · crackedCLT - Q-4, FLOORRBEAM HAD 1.50 INCH CRACK, BS 520 AND LBL 24.75. NEW PART INSTALLED PER EA 67167. (X)SDR F3LA00090Floorbeam · corrodedDEN - DURING C-7 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM AT BS 947, ABOVE WATER TANK. MAINTENANCE REMOVED CORROSION FROM FLOORBEAM AND FOUND TO BE WITHIN LIMITS PER SRM 53-10-01. CORROSION WAS ALSO FOUND ON LBL 30 TRACK SHIMS PER SRM 51-10-06. FABRSDR F3LA00089Floorbeam · corrodedDEN - DURING C-7 CHECK, INSPECTION REPORTED BARE METAL AND CORROSION ON FLOORBEAM WHERE AFT LAVATORY FORWARD WALL MOUNTS TO FLOOR, BS 990. MAINTENANCE REPLACED SUPPORT ASSY PER SRM 51-10-2. (X)SDR F3LA00088Floorbeam · corrodedDEN - DURING C-7 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM AFT OF RT OUTBOARD SEAT TRACK AT BS 947. MAINTENANCE FABRICATED REPLACEMENT FLOORBEAM AND INSTALLED PER SRM 51-40-3, 53-10-2, 51-10-2, AND EA 53-737-071. (X)SDR RRXA002341Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND SEVERAL MISDRILLED HOLES TO THE FLOORBEAM AT FS 780, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED MISDRILLED HOLES IAW DC-8 SRM 51-1-21 AND EO NR 00-047 WITH ASDR SWAA000896Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND BS 733 FLOORBEAM CORRODED, RBL 8. REPAIRED BEAM PER SWA RA NR1-353-2021.SDR SWAA000889Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 328 FLOORBEAM CORRODED ON UPPER SURFACE, RBL 13 TO RBL 51. REPAIRED FLOORBEAM PER SRM.SDR CALA0000675Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED JUST INSIDE R-1 DOOR AT STA 200, RBL 54. THE FLOOR SUPPORT WAS REPAIRED IAW SRM 53-05, FIGURE 55 AND EA 9-5311-2-AD67B.SDR AWXA0000320Floorbeam · corrodedC-CHECK, RT CABIN FLOORBEAM DOUBLER CORRODED AT FS 1006 - 1014 RBL 16. REMOVED AND REPLACED FLOORBEAM DOUBLER IAW 737 SRM 51-40-02, FABRICATED FROM 7075 T6 X.071 IAW 737 SRM 53-60-51.SDR AWXA0000313Floorbeam · corrodedC-CHECK, FLOORBEAM AT AFT LT LAV ENTRANCE FS 990 LBL 7 - 14 BOLT HOLES CORRODED BEYOND LIMITS. REMOVED FLOORBEAM, FABRICATED BEAM FROM AND 10140-1204 7075 T7 AND SHIM FROM 7075 T6 X .0125, INSTALLED PARTS IAW 737 SRM 51-40-02.SDR AWXA0000311Floorbeam · corrodedC-CHECK, CORROSION LEVEL 1. CABIN FLOORBEAM DOUBLER AT FS 1006 - 1014 LBL 16 CORRODED. REMOVED AND REPLACED FLOORBEAM DOUBLER IAW 737 SRM 51-40-02, FABRICATED PART FROM 7075-T6 X .071 IAW 737 SRM 53-60-51 FIG 1.SDR AWXA0000310Floorbeam · corrodedC-CHECK, AFT LAV ENTRANCE FLOORBEAM AT FS 990 RBL 14 TO RBL 7, BOLT HOLES CORRODED BEYOND LIMITS. REMOVED FLOORBEAM IAW 757 SRM 51-40-02, FABRICATED REPLACEMENT BEAM IAW 53-60-51. MATERIAL USED 7075 T76311. INSTALLED PARTS IAW 737 SRM 51-40-02. TREATED ANDSDR AWXA0000305Floorbeam · corrodedC-CHECK, FLOORBEAM AT STA 380 RBL 14 OUT OF LIMITS. REMOVED UPPER FLANGE DAMAGE AT STA 380 RBL 14, SUPPORT AND INTERCOSTAL. FABRICATED INTERCOSTAL, SHIM, AND STRAP. ALODINED, PRIMED, AND INSTALLED REPAIR PARTS IAW 737 SRM 51-40-02, 53-10-51 AND 51-20-01.SDR SWAA000892Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 294 FLOORBEAM CORRODED ON UPPER SURFACE, RBL 14 TO RBL 27. REPAIRED BEAM PER SRM.SDR USAA000695Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 70 INCHES, FS 328 BETWEEN RBL 56 AND RBL 14. INSTALLED NEW T-CAP PER SRM 53-10-51. CORROSION LEVEL 2. (M)SDR USAA000704Floorbeam · corrodedCLT - FLOORBEAM HAD LEVEL 2 CORROSION, 3 INCHES BY 15 INCHES, BS 986.5 LBL 14 TO RBL 16. INSTALLED T-CAP PER TR 53-60-1. (X)SDR USAA000702Floorbeam · corrodedCLT - T-CAP FLOORBEAM HAD LEVEL 1 CORROSION, .50 INCH, BETWEEN LBL 37 AND RBL 34, STA 947.5 T-CAP. (X)SDR USAA000692Floorbeam · corrodedCLT - FLOORBEAM HAD LEVEL 2 CORROSION, 1 INCH BY 1 INCH, BS 986.5 LBL 43. INSTALLED T-CAP PER TR 53-60-01. (X)SDR USAA000690Floorbeam · corrodedCLT - FLOORBEAM HAD LEVEL 2 CORROSION, 1 INCH BY 6 INCH, AT BS 986.5, RBL 27, RBL 33. INSTALLED T-CAP PER TR 53-60-1. (X)SDR USAA000688Floorbeam · corrodedCLT - FLOORBEAM HAD LEVEL 2 CORROSION, 1 INCH BY 2 INCH, BS 986.5, RBL 40 TO RBL 42. INSTALLED T-CAP PER TR 53-60-1. (X)SDR USAA000686Floorbeam · crackedCLT - FLOORBEAM CRACKED .50 INCH, UPPER FLANGE STA 520, LBL 45. INSTALLED DOUBLER AND PIVOT LINK PER EA 67143. (X)SDR USAA000683Floorbeam · corrodedCLT- FLOORBEAM HAD LEVEL 1 CORROSION, .250 INCH BY .250 INCH, BS 312, LBL 08 TO RBL 08. INSTALLED NEW T-CAP PER TR 53-10-13. (X)SDR USAA000682Floorbeam · corrodedCLT- FLOORBEAM HAS LEVEL 1 CORROSION, 1 INCH BY 2 INCH, BS 986.5, RBL 37 TO RBL 45. INSTALLED T-CAP PER TR 53-60-1. (X)SDR USAA000681Floorbeam · corrodedCLT - FLOORBEAM HAD LEVEL 1 CORROSION, 1 INCH BY 1 INCH, BL 1006, LBL 19. REPAIRED ANGLE, INSTALLED PER EA67218 AND SRM 51-10-6. (X)SDR COMA0010075Floorbeam · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-121-01I, THE LT COCKPIT FLOOR SUPPORT AT FRAME 13 WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPAIRED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND EMBRAER REPAIR EST-145-/96.SDR COMA0010073Floorbeam · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-122-01I, THE RT COCKPIT FLOOR SUPPORT AT FRAME 13 WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPAIRED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND EMBRAER REPAIR EST-145/96.SDR RRXA002412Floorbeam · crackedDURING A MAINTENANCE VISIT FOUND A SEVERED FLOORBEAM AT FS 360-XCW 52.5 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIRS IAW DC-8 SRM 51-1-21 AND EO NR 00-047 WITH APPSDR RRXA002409Floorbeam · crackedDURING A MAINTENANCE VISIT FOUND A SEVERED FLOORBEAM AT FS 400-XCW 52.5 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIRS IAW DC-8 SRM 51-1-20D, 51-1-21 AND EO NR 00-04SDR RRXA002408Floorbeam · crackedDURING A MAINTENANCE VISIT FOUND A SEVERED FLOORBEAM AT FS 380-XCW 52.5 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIRS IAW DC-8 SRM 51-1-4, 51-1-20D, 51-1-21 AND EO SDR RRXA002324Floorbeam · crackedDURING A MAINTENANCE VISIT FOUND A SEVERED FLOORBEAM AT FS 340 AND XCW 52.5 LT, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW DC-8 SRM 51-1-21 AND EO NR 00-047 WITH SDR RRXA002203Floorbeam · gougedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE UPPER CHORD FLOORBEAM AT STA 1400, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. BLENDED GOUGES SMOOTH IAW EO NR 00-047 WITH APPROVED 8110-3 DATSDR 20000801SH012Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FLOORBEAM AT STA 1090 RBL 18 ON UPPER FLANGE. (X)SDR 20000801SH011Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FLOORBEAM AT BS 1030 ON UPPER FLANGES AT RBL 30 AND RBL 55. (X)SDR 20000801SH004Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FLOORBEAM AT STA 344, RBL 14. (X)SDR 20000801SH002Floorbeam · corrodedDURING A C-CHECK, CORROSION NOTED ON FLOOR CHORD, FLOOR SURROUNDING OF FE''''S AFT SEAT TRACK AREA. (X)SDR 20000731SH037Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FLOORBEAM AT STA 380 FROM RT MOPSILL AND R-1 DOOR TO BL ZERO. (X)SDR 20000731SH036Floor Support · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FLOOR SUPPORT, STA 400 - STA 420, BETWEEN BL ZERO AND RBL 24.75. (X)SDR F3LA00094Floorbeam · corrodedDEN - DURING C-7 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM AT BS 294.5 BETWEEN RBL 11 AND BLBL 53. MAINTENANCE DETERMINED CORROSION TO BE OUT OF LIMITS PER SRM 53-10-1. REMOVED DAMAGED AREA, FABRICATED REPLACEMENT UPPER CHORD AND REPAIRED PER SRM 51-SDR L1GA200000114Floorbeam · misrepairedINTERFERENCE FROM EXISTING REPAIR STATION 980 FLOORBEAM BL 21 TO 35 LT. SPLICED IN NEW FLOORBEAM CAP TO AVOID MOD INTERFERENCE-AFT LAV RECONFIGURATION.SDR L1GA200000106Floorbeam · misrepairedINTERFERENCE FROM EXISTING REPAIR AT FS 996 BL 32 TO 43L SPLICED NEW SECTION OF FLOORBEAM CAP TO AVOID MOD INTERFERENCE. REF MOD IS AFT LAV COMPLEX FOR INTERIOR RECONFIGURATION.
Back to JASC 5315