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 SIMA200224013Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND CORROSION ON THE GALLEY CENTER FLOORBEAM. REMOVED CORRODED GALLEY CENTER FLOORBEAM. INSTALLED SERVICEABLE FLOORBEAM IAW EMB 145 (SRM 145/1142, CHAPTER 51, REV 19) 51-40-02, 51-20--01, 51-20-03, 51-40-04, AEAI ETN NR EB SDR F3LA200200232Channel · corrodedDURING C-7 CHECK, INSPECTION REPORTED CORROSION ON UNDERSIDE OF CARGO FLOORBEAM AROUND NUTPLATE, BS 827, RBL 25. INSTALLED CHANNEL FOR FLOOR SUPPORT REPAIR PER 53-00-53.SDR F3LA200200218Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED CORROSION 1 FT LEFT OF CENTER LINE FLOORBEAM AT BS 294.5. FOUND CORROSION ON FLOORBEAM AT BS 294.5 TO BE OUT OF LIMITS FROM LBL 19.5 TO RBL 60 PER SRM 53-10-51. REMOVED THIS SECTION OF THE TOP CHORD, FABRICATED REPLACEMESDR SIMA200224015Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND CORROSION ON THE GALLEY RIGHT FLOORBEAM. REMOVED CORRODED GALLEY RIGHT BEAM. INSTALLED SERVICEABLE BEAM IAW EMB 145 (SRM 145/1142, CHAPTER 51, REV 19) 51-40-02, AEAI ETN EM 53-028 AND STANDARD SRM PRACTICES. (M)SDR UPS02439277Floorbeam · corrodedINSPECTION TYPE:C U/D - BS 440 RBL 20-40 FLOOR BEAM FOUND CORROSION. CORROSION BLEND OUT EXCEEDS SRM LIMIT, UPPER CHORD REPAIRED AS PER HAECO RS NR R53-15-34883 & UPS AUTH NR 747-53-20100.SDR UPS02439204Floorbeam · corrodedINSPECTION TYPE:C UPPER DECK BS 480 BL 0 - RBL 35 FLOORBEAM CORRODED. CORROSION BLEND OUT EXCEEDS SRM LIMIT. FLOOR SUPPORT UPPER BEAM REPLACED AS PER SRM 51-10-01 PG 8.SDR SWAA021898Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 294.5, LBL 11. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR UPS02439210Floorbeam · corrodedINSPECTION TYPE:C, COCKPIT - BS 340 LBL 100 FLOORBEAM UPPER CHORD FOUND CORRODED. CORROSION REMOVED IAW 51-10-01, CORROSION BLEND OUT EXCEEDS SRM LIMIT. FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 53-10-07 FIG 23.SDR UPS02439181Floorbeam · crackedINSPECTION TYPE:C BS 360 UPPER DECK FLOORBEAM UPPER CHORD, 2 FASTENER HOLES CRACK REVEALED AT RBL 28 & RBL 43 RESPECTIVELY. UPPER DECK BS 360 RBL 28 CRACKED HOLE CRACK REMOVED AS PER EO B747-5320-12407-C APPENDIX D. NO NECESSARY REPAIR. RBL 43 CRACKED FASTESDR UPS02439180Floorbeam · crackedINSPECTION TYPE:C BS 340 UPPER DECK FLOORBEAM UPPER CHORD, THREE FASTENER HOLES CRACKED, REVEALED AT LBL 18, RBL 15 & RBL 46 RESPECTIVELY. UPPER DECK BS 300 FLOORBEAM LBL 18 & RBL 15 CRACKED HOLE REF NRC 7305 SECTIONAL REPLACED FROM RBL 20 TO LBL 40 AS PER SRSDR UPS02439179Floorbeam · crackedINSPECTION TYPE:C BS 380 UPPER DECK FLOORBEAM UPPER CHORD, 1 FASTENER HOLE CRACK REVEALED AT RBL 60, RUNNING AFT APPROX .0625 INCH LENGTH. UPPER DECK BS 380 FLOORBEAM RBL 60 CRACKED HOLE REPAIRED AS PER EO B747-5320-12407-C APPENDIX D PLAN A.SDR 2002UALA01324Floorbeam · corrodedCABIN FLOOR STRUCTURE FLOOR BEAM UPPER T-CAP AT STATION 324 STRINGER 17R 38 RBL TO 63 RBL HAD EXCESSIVE MATERIAL REMOVED IN PROCESS OF CORROSION CLEAN UP. MAJOR REPAIR ACCOMPLISHED. REMOVED SECTION OF T-CAP FROM 9 LBL TO 63 RBL AND INSTALLED REPLACEMENT T-CASDR C2XA02TY124Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE LEFT HAND OMEGA BEAM BETWEEN FRAMES 20 AND 23. MAINTENANCE REMOVED AND REPLACED THE DAMAGED AREA AND FABRICATED NEW ANGLE SHIM AND FILLER IAW EMB-145 SRM 63-21-10, THE REPAIR WAS SATISFACTORY. THESDR 0202946730Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON THE TOP AFT FLANGE OF FLOORBEAM AT BS 1920 FROM BL 0 TO LBL 54 AND BL 0 TO RBL 58. REPAIRED PER EA 67-192359.SDR SWAA021859Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED (2 EA), BETWEEN BS 666 AND BS 670 AT RBL 25. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA021858Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED (4 EA), BETWEEN BS 662 AND BS 675 AT LBL 25. REPAIRED FLOORBEAMS PER BFG ER.SDR 2002UALA01318Floorbeam · corrodedCABIN FLOORBEAM AT STATION 365 STRINGER 17R HAD EXCESSIVE MATERIAL REMOVED DURING CORROSION CLEAN UP BETWEEN RBL 10 OUT TO 64 RBL ON THE UPPER T-CAP SURFACE. MAJOR REPAIR ACCOMPLISHED. REPLACEMENT T-CAP INSTALLED.SDR AWXA200200964Floorbeam · crackedDURING C-03 CHECK A 1 INCH CRACK WAS FOUND ON FLOORBEAM AT BS 294, LBL 28. MAINTENANCE TRIMMED OUT CRACK AND PERFORMED HFEC INSPECTION TO VERIFY NO CRACKS EXIST. FABRICATED A FILLER, 4 EACH REPAIR ANGLES, AND 2 EACH SHIMS, AND INSTALLED REPAIR PARTS IAW AWA ESDR SWAA021842Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR AMTA200201097Floorbeam · corrodedAT 53 - FUSELAGE, 60 - MID FUSELAGE SECTION, LOWER GALLEY FLOORBEAM FS 901, RBL 23 TO RBL 28 IS CORRODED. REPLACED CORRODED T-CAP SECTION IN EXISTING REPAIR PER SRM 51-40-02 AND 53-23-00.SDR AWXA200200830Channel · corrodedMCN - MAJOR REPAIR - DURING C-16 CHECK CORROSION WAS FOUND ON UPPER SURFACE OF L-1 ENTRY WAY CHANNEL (LOWER SCUFF PLATE ATTACHMENT INBOARD SIDE) BS 312 - 344, LBL 61. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS PER B737-300 SRM 53-10-15SDR PCAA0208095Floorbeam · crackedDURING ROUTINE MAINTENANCE VISIT NOSE WHEELWELL FLOOR BEAM P/N 85310380 (STATION X97) FOUND CRACKED AT AIRCRAFT CENTERLINE. DAMAGED AREA CUT OUT, EDDY CURRENT INSPECTED, AND REPAIRED IN ACCORDANCE WITH DEHAVILLAND REPAIR DRAWING RD8-53-1336. AIRCRAFT RETURNED SDR AWXA200200831Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A .75 INCH CRACK WAS FOUND IN THE UPPER FLANGE OF LONGITUDINAL FLOORBEAM AT RBL 45 APPROXIMATELY 2 INCHES FROM BS 727B, WL 208.1. MAINTENANCE CUT OUT CRACK IN UPPER FLANGE OF LONGITUDINAL FLOORBEAM RBL 45 AND PERFORMED HSDR 2002UALA01297Floorbeam · corrodedRIGHT HAND CABIN FLOOR FRAME, STATION 1640, RBL 55, WL 208 HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER.SDR SWAA021823Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, WL 208 AND RBL 15. REPAIRED FLOORBEAM PER SWA RA.SDR DHL2002363503Floorbeam · corrodedC-CHECK, CORROSION ON FLOORBEAM AT FRAME 6L BL 78 R. REMOVED SURFACE CORROSION IAW A 300 SRM 51-40-11. WITHIN LIMITS IAW A300 SRM 53-10-00 PG 602.SDR 02FDEA00611Floorbeam · chafedBS 740 FLOORBEAM IS CHAFED RBL 43 TO LBL 56 WL 208 UPPER AFT FLANGE. REMOVED AND REPLACED FLOORBEAM PER EA 7-5310-65351.SDR 02FDEA00601Floorbeam · corrodedCORROSION ON BS 344 FLOORBEAM TOP CHORD AT NUT PLATE LOCATIONS UPPER AND LWR FLANGES LBL 57 TO RBL 12, WL 208. R&R UPPER CHORD ON FLOORBEAM PER SRM 53-10-8.SDR 2002UALA01290Floorbeam · damagedCABIN FLOORBEAM AT STATION 986.5 HAS A STRAP REPAIR INSTALLED AT RIGHT HAND SIDE WALL, REQUIRES ANGLE REPAIR. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE REPAIR.SDR UPS02M39422Floorbeam · corrodedINSPECTION TYPE:C CABIN FLOORBEAM HAS SURFACE CORROSION AND FASTENERS CORRODED AT STA 1361 X=115.00 TO X=107.25. FLOORBEAM AREA CORROSION BLENDED OUT AND FOUND EXCEEDS LIMIT PER SRM 53-00-01 VOL I.SDR AWXA200200803Angle · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1/2" CRACK WAS FOUND ON TOP OF CABIN FLOOR BEAM SUPPORT ANGLE BS 344, LBL 12, WL 206. MAINTENANCE REMOVED DAMAGED FLOOR BEAM SUPPORT ANGLE BS 344, LBL 12. FABRICATED A NEW FLOOR BEAM SUPPORT ANGLE, AND INSTALLED REPAIRSDR BJNA020830Floorbeam · corrodedLEVEL 2 CORROSION ON 8 EACH SCREW HOLES ON BEAM BS 986.5 BETWEEN RBL 20 TO LBL 20. REMOVED UPPER FLOORBEAM CAP AT BS 986.5. FABRICATED AND INSTALLED REPAIR SECTINO 2 EACH CLIPS IAW TIMCO REO-L00584 REV. (M)SDR BJNA020834Floorbeam · corrodedFOUND LEVEL 2 CORROSION ON FLOORBEAM BS 328 AT EACH SCREW HOLE AT RBL 32. REMOVED EXISTING REPAIR IN AREA. REMOVED CORROSION FOUND REMAINING MATERIAL TO BE OUT OF LIMITS, FABRICATED REPAIR ANGLES FROM BAC1490-2734 33 INCHES AND 31 INCHES. INSTALLED IAW B737SDR AWXA200200823Shear Tie · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON THE AFT CARGO PIT FLOOR FRAME ON TOP OF THE FORWARD LEG OUTBOARD SIDE, INBOARD OF STR 27 L/H, WL 149, BS 807. MAINTENANCE REMOVED STIFFNER, STRINGER CLIP, AND CUTOUT DAMAGED SKIN ATTACHMENT (SHEAR TSDR BJNA020816Floorbeam · corrodedCORROSION AT 3 EACH SCREW HOLES ON BEAM AT BS 947.5 BETWEEN LBL 20 TO LBL 40. LEVEL 2 CORROSION SECTION OF FLOORBEAM. FABRICATED AND INSTALLED SECTION IAW SRM.SDR MALA020511Floorbeam · corrodedDURING C-CHECK INSPECTION IN CVG, FOUND EVIDENCE OF CORROSION ON FLOORBEAM 18 BETWEEN SEAT RAILS 3/4, 29 INCHES FROM A/C CENTERLINE ON RIGHT SIDE OF A/C. DAMAGE REPAIRED IAW BARA/ARV/6005/02-DC AND EO NR A53090.SDR 2002UALA01275Floorbeam · corrodedSTATION 986.5 CABIN FLOORBEAM HAS SMALL SPOT OF CORROSION TWO PLACES AT RBL 17 AND RBL 24. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLES.SDR UPS02439213Floorbeam · corrodedINSPECTION TYPE:C, M/D BS 460 RBL 58 - RBL 70 FLOORBEAM WEB FOUND CORRODED. CORROSION REMOVED IAW SRM 51-10-01, CORROSION BLEND OUT EXCEEDS SRM 53-10-01 FIG 1 LIMITS, REPAIRED BS 460 RBL 70 FLOORBEAM WEB IAW SRM FIG 53-10-07 FIG 11.SDR AWXA200200819Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK EXFOLIATION WAS FOUND ON THE UPPER SURFACE OF TEE CHORD AT BS 986, LBL 21 TO RBL 40, WL 208. MAINTENANCE BLENDED DAMAGED SECTION OF TEE CHORD, MATERIAL LOSS OUT OF LIMITS. REMOVED FLOOR SUPPORTS BS 966 TO BS 986.5, AND SDR AWXA200200765Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON THE UPPER SURFACE OF TEE CHORD BS 967, RBL 27 - 41, WL 208. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS; REMOVED TEE CHORD BS 967 FROM BL 0 TO RBL 43. FABRISDR AWXA200200802Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 2.7 INCH CRACK WAS FOUND ON THE LOWER SIDE OF FLOORBEAM UPPER CHORD AT BS 663, RBL 24, WL 202; VERIFIED BY HFEC INSPECTION. MAINTENANCE REMOVED CRACKED SECTION OF UPPER CHORD BS 663, RBL 24, WL 202. FABRICATED 2 REPAISDR ASOA02437Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, THE OMEGA BEAM WAS FOUND TO BE CORRODED OUT OF LIMITS AT FRAME STATION 4562. MAINTENANCE REPAIRED THE CORRODED OMEGA BEAM IAW WITH ASA E0120-53-0181. (M)SDR UPS02839258Floorbeam · corrodedINSPECTION TYPE:C2 MAIN CABIN FLOORBEAM IS CORRODED BEYOND LIMITS AT STA 920 AT RBL 65. CUTOUT CORRODED SECTION OF FLOORBEAM, NDT VERIFIED NO CRACKS AT DAMAGE REMOVAL, FABRICATED AND INSTALLED FLOORBEAM SECTION IAW UPS ENGINEERING FILE NUMBER DC8-53-20237, ANSDR AWXA200200780Crease Beam · corrodedLCQ - MAJOR REPAIR - DURING C-08 CHECK CORROSION WAS FOUND ON CREASE BEAM AT ATTACHMENT HOLE BS 1340, RBL 65. MAINTENANCE CLEANED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS, REMOVED CREASE BEAM CHORD FROM BS 1290 TO BS 1400, FABRICATED A NEW CREASE BEAM ASDR 02080802Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 1640, RBL 52, WL 208. FLOORBEAM UPPER TEE FOUND TO BE OUT OF LIMITS AT RBL 52 PER SRM 53-00-51. FLOORBEAM REPAIRED PER SRM 53-00-51 FIG. 205, 53-00-51 PG 216, AND SRM 51-20-01. (STANDARD STRAP, ANGLE, ANF FILLER REPAIR.). AIRCRAFT SDR N8TA02080801Floorbeam · corrodedCORROSION ON FLOORBEAM BODY STATION 377.7, LBL 17, WL 208. FLOORBEAM UPPER CHORD FOUND TO BE CORRODED OUT OF LIMITS AT LBL 6, LBL 11, AND LBL 17 PER SRM 53-00-51 FIG 101. FLOORBEAM REPAIRED PER SRM 53-00-51 FIG 205, M/M 51-21-04, AND SRM 51-40-02.SDR C2XA02TY116Gusset · corrodedTYS DURING A SCHEDULED 1-C INSPECTION THE AFT GUSSET IN THE GALLEY WAS FOUND CORRODED. MAINTENANCE R/R THE AFT GUSSET IAW 135/145 SRM 51-40-02.R/R SCREWS IAW EMB 135/14553-01-06. ALL WORK WAS ACCOMPLISH AND WILL BE REL. UPON COMPLETION OF ALL WORK.SDR C2XA02TY115Floorbeam · corrodedTYS, DURING A SCHEDULED INSPECTION THE FORWARD DIGITAL WAS FOUND CORRODED FROM FRAME 13 TO 16. MAINTENANCE CUT OUT DAMAGED AREA, FABRICATED DOUBLER, SHIM AND INSTALLED, ALODINED, PRIMED AND PAINTED IAW-EMB-135/145-SRM-53-21-10 AND 51-40-02. THE REPAIR WAS SASDR 2002UALA01258Floorbeam · corrodedAFT CABIN LEFT HAND SIDE FLOORBEAM UPPER SURFACE CORRODED AROUND NUT PLATE HOLES STATION 927 BETWEEN LBL 14 AND LBL 44. MAJOR REPAIR ACCOMPLISHED. MANUFACTURED AND INSTALLED ANGLE DOUBLER AND FILLER.SDR AWXA200200750Angle · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A 1" CRACK WAS FOUND ON FLOOR BEAM SUPPORT ANGLE BS 400, BL 0. MAINTENANCE REMOVED DAMAGED FLOOR BEAM SUPPORT ANGLE AT BS 400, BL 0. FABRICATED A NEW FLOOR BEAM SUPPORT ANGLE, AND INSTALLED REPAIR IAW B737-200 SRM 51-30-2
Back to JASC 5315