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 DL76G070302Floorbeam · corrodedAFT CARGO COMPARTMENT STA 1197+66 FLOORBEAM AFT FACE UNDER SIDE CORRODED AND REPAIRED PER SRM53-00-07 REPAIR 4 FIG 201 DETAIL VI.SDR DL76G070301Floorbeam · corrodedAFT COMARTMENT STA 1153 RBL 28 FLOORBEAM AFT FACE UNDERSIDE CORRODED AND REPAIRED PER SRM53-00-07 REPAIR 4 FIG 201 DETAIL V.SDR DL76G070300Floorbeam · corrodedAFT CAGRO COMPARTMENT STA 1153 RBL 29 FLOORBEAM FWD FACE UNDERSIDE CORRODED AND REPAIRED AS PER SRM 53-10-07 REPAIR 4 FIGURE 201 DETAIL 3.SDR DL76G070299Floorbeam · corrodedBS 346 RBL 38 TO 45 FLOORBEAM FOUND CORRODED AND REPAIRED AS PER DRD53-00-51D FIG 201.SDR DL76G070298Floorbeam · corrodedBS 1461 LBL 33-40 FLOORBEAM FOUND CORRODED AND REPAIRED AS PER DRD 53-00-51D FIG 201.SDR DL76G070297Floorbeam · corrodedBS 654+88 RBL 28 FLOORBEAM UPPER CHORD FOUND CORRODED AND REPAIRED AS PER DRD 53-00-51D.SDR DL76G070296Floorbeam · corrodedBS 654 + 121 RBL 28 TO 55 FLOORBEAM UPPER CHORD CORRODED AND REPAIRED PER DRD53-00-51D FIG 201 ON NR CARD 51907.SDR CALA0700167Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT STA 1016, RBL 9. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51.SDR 07FDEA01360Floorbeam · crackedFWD LOWER CARGO COMPARTMENT FLOOR SUPPORT IS CRACK LT SIDE OF FS 38.2 BETWEEN CL TO LBL 24". CRACK LENGTH .5 " CRACK LENGTH WOULD NOT ALLOW TO SUBMIT SDR WHEN ENTERED ON BLOCK 7C. REMOVED FLOOR SUPPORT IAW SRM 51-40-44. FABBED NEW SUPPORT, LOCATED AND DRILLSDR 07FDEA01359Floorbeam · crackedFWD LOWER CARGO COMPARTMENT FLOORBEAM IS CRACK LT SIDE OF FR 38.2 BETWEEN CL TO LBL 24". REMOVED FLOOR SUPPORT IAW SRM 51-40-44. FABBED NEW SUPPORT, LOCATED AND DRILLED IAW SRM 51-40-44. INSTALLED FLOOR SUPPORT IAW SRM 51-40-21.SDR DHL2007806525Floorbeam · damagedMAIN CARGO COMPT FLOORBEAM HAS A MISDRILLED HOLE, STA 600.000 RBL 38" (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 51-2-1 FIG 1, TR NR 51-130 DATED 01-26-04. REMOVED FASTENERS IAW SRM 51-1-21. CUT OUT DAMAGED SECTION IAW SRM 51-2-1 FIG 1, TR NR 51-130 SHESDR SIMA200710702Floorbeam · corrodedSTATION 280 FLOORBEAM CORRODED ALONG TOP FLANGE. SPLICE IN FRAME 280 AND EXTENTION MOUNTS IAW AMERICAN EAGLE ENGINEERING ORDER CR-53MR-114.SDR 07FDEA01347Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER FLANGE IS CORRODED AT BS 1110, RBL 22, WL 208 CORROSION DAMAGE REPAIRED REFERENCE EA NR 7-5310-106997.SDR KCSA071115Floorbeam · damagedUPPER DECK FLOORBEAM AT STA 600 HAS DAMAGE TO UPPER CHORD AT LBL 39 WL 308.SDR 07FDEA01312Floorbeam · dentedMAIN DECK CARGO FLOORBEAM LOWER FLANGE AT STA 939 X=-82 FOUND DENTED. [SUP 4-20-07] COMPLIED WITH FEDEX E.A. 1-5310-109846 PART 1.SDR USAA070261Floorbeam · corrodedAROUND SCREW HOLE, FRAME 66, RIGHT SIDE Y -1292 HAS CORROSION. CUT OUT DAMAGE, INSTALLED REPAIR ANGLES & FILLER PER SRM 53-41-14; CORR TASK JA-260-53500, LEVEL 1, DEFECT SIZE: .75 INCH DIA.SDR USAA070266Floorbeam · corrodedFLOORBEAM NUT PLATE HOLES, INTERCOSTAL, STA 967 RBL 50 - LBL 50 HAS CORROSION. FAB'D FILLER FOR INTERCOSTAL BECAUSE OF REPAIR STRAP ON BEAM PER SRM 53-60-5 TYP 53-15-01B; DEFECT SIZE: 100 INCHES.SDR SIMA200709910Floorbeam · corrodedLEFT OMEGA BEAM CORRODED AT FRAME 33. PERFORMED CUTOUT TO REMOVE CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW EMB SRM 53-00-10, FIGURE 202. RETURNED AIRCRAFT TO SERVICE.SDR SWAA071715Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 294.5, LBL 53. REPAIRED FLOORBEAM PER SRM.SDR 07FDEA01304Floorbeam · corrodedLOWER AFT PIT FLOORBEAM, VERTICAL CHANNEL HAS CORROSION AT LWR END AROUND FASTENER HEAD AT STA 950E, LBL 8 FABRICATED NEW FLOORBEAM VERTICAL CHANNEL AT STA 950E, LBL 8. HEAT TREATED AND HARDNESS TESTED FOR 7075 T6 CONDITION REF BAC DWG 69-44559 AND BAC 5602 RSDR 07FDEA01264Floorbeam · corrodedHEAVY CORROSION ON TOP CAP BEAM, C38.2 IN FWD CARGO COMPARTMENT. REPLACEMENT OF TOP CAP BEAM (A537-73651-212-00) IAW 51-72-10.SDR SWIA200718255Attach Bracket · crackedCABIN FLOORBEAM CLIP CRACKED AT FS484 RBL27, DISCOVERED AT C-CHECK. INSTALLED NEW CLIP AT CABIN FLOORBEAM FS 484 RBL 27 PER REO 601R-53-41-059.SDR NWAA071686744Floorbeam · corrodedDURING "M" CHECK, FOUND CORROSION ON UPPER DECK FLOORBEAM UPPER CHORD BS 440 LBL 76. REPAIRED PER EA 67-209236.SDR ABXA070105Floorbeam · crackedFLOORBEAM CRACKED TO LIGHTENING HOLE APPROXIMATELY STA 175, BUTT LINE 0. REPAIRED AREA IAW REA D953-55576MR.SDR UPS07849626Floorbeam · crackedINSPECTION TYPE:C2 MAIN CARGO FLOORBEAM AT STA 280 RBL 24 CRACKED FROM EXFOLIATION CORROSION. CUT OUT DAMAGED AREA OF FLOORBEAM AT STA 280 RBL 24 IAW SRM 51-2-1 PG 8 FIG 1. FABRICATED AND INSTALLED REPAIR ANGLE AND FILLER IAW SRM TR 51-130 FIG 1 SHEET 1.SDR A6WA200740168Floorbeam · crackedRT FS 484.0 ANGLE CRACKED APPROX .1 INCH LONG AT PRESSURE FLOORBEAM RBL 27.0. (K) [SUP 5-1-07] MAINTENANCE REMOVED CRACKED ANGLE AT FS 484 RBL 27 ON THE PRESSURE FLOORBEAM AND INSTALLED A NEW SERVICEABLE ANGLE P/N 601R31171-9 IAW CRJ 200 SRM 51-42-06 AND 51SDR DU4R2007082Floorbeam · corrodedFOUND CORROSION AT CABIN FWD FLOORBEAM UPPER SURFACE AROUND NUTPLATE HOLES AT BS 345 B/L 0 RBL 56. REPAIRED BY REMOVING CORROSION, FABRICATED AND INSTALLED REPAIR SECTION 32-1/2 FROM BAC1505-100617 IAW B757 53-00-51, 51-20-01 AND 51-10-2.SDR DU4R2007081Floorbeam · corrodedFOUND CORROSION AROUND HOLES AT BS 345 LBL 6 AND LBL 12 W/L 0 AROUND 2 HOLES AND B/L, TO RBL 56. REPAIRED BY REMOVING CORROSION, FABRICATED AND INSTALLED REPAIR SECTION 32-1/2 FROM BAC1505-100617 IAW B757 53-00-51, 51-20-01, 51-10-2 AND DRD 53-10-51D.SDR SWAA071686Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 665, BL 0. REPAIRED BEAM PER ER.SDR 07FDEA01241Floorbeam · cracked1 CRACK EXIST IN FLOORBEAM VERTICAL STIFFENER AT FR 36 BETWEEN SEAT TRACK L4 AND L5, MEASURING 0.450" P/N 537B1041000 A310-200 AMM 53-10-15-6. REMOVED 1 CRACK IN FLOORBEAM VERTICAL STIFFENER AT FRAME 36 BETWEEN SEAT TRACK L4 AND L5 IAW A310-200 SRM 53-10-15 FSDR 07FDEA01218Floorbeam · corrodedFLIGHT DECK FLOORBEAM HAS CORROSION ON TOP OF BEAM LOCATED AT BS 277, RBL 10.5. REMOVED CORROSION, ALL WORK FOR BLEND WAS ACCOMPLISHED ON FED EX EA NR 7-5310-107004.SDR KCSA071104Floorbeam · corrodedUPPER DECK FLOORBEAM UPPER CHORD IS CORRODED AT STA 540, RBL 16.SDR NWAA071526744Floorbeam · damagedDURING "M" CHECK, FOUND SHORT EDGE MARGIN ON UPPER DECK FLOORBEAM REINFORCEMENT STRAPS AT BS 380 RT AND LT. ALSO, FOUND CRACK IN FLOORBEAM CHORD FASTENER HOLE AT BS 380 RBL 74. REPAIRED PER EA 67-208994.SDR F3LA200700079Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED CORROSION AROUND NUTPLATE HOLE AT FR 66 ON FLOORBEAM BETWEEN FR 66 AND FR 64 AT Y1292. REMOVED AND REPLACED FLOORBEAM ASSY IAW A319 SRM 51-42-11.SDR F3LA200700054Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM BETWEEN FR 68 AND FR 69 AT Y1292. FLOORBEAM FOUND TO BE OUT OF LIMITS PER A319 ARM 51-00-14, FIG 101. REPLACED FLOORBEAM IAW A319 SRM 51-42-11 AND SRM 51-44-11.SDR F3LA200700064Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM BETWEEN FR68 AND FR69 AT -Y1162. FOUND TO BE OUT LIMITS IAW A319 SRM 53-00-14, FIG. 101. REMOVED AND INSTALLED FLOORBEAM ASSY IAW A319 SRM 51-42-11.SDR F3LA200700055Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM BETWEEN FR 67 AND FR 68 AT-Y1292. FLOORBEAM WAS FOUND TO BE OUT OF LIMITS PER A319 SRM 51-00-14, FIG 101. REMOVED AND REPLACED FLOORBEAM IAW A319 SRM 51-42-11.SDR F3LA200700070Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED LIGHT CORROSION AROUND NUT PLATE HOLE ON SEAT TRACK AT -Y1292, FR65. REMOVED AND INSTALLED FLOORBEAM IAW A319 SRM 51-42-11; 51-42-11, FIG 8; 51-42-11, PARA 7; AND 51-42-11, STEP 7 B.SDR 07FDEA01204Splice · corrodedLOWER AFT PIT FLOOR STRUCTURE FLOOR PANEL SPLICE STRAP AT STA 980 4" HAS CORROSION ON UNDERSIDE AT MANY NUTPLATES AND CRACKED AT RBL 8. MANUFACTURED STRAP PER BOEING DWG 65-57567. REMOVED AND REPLACED AFT PIT FLOOR SPLICE STRAP REF SRM 51-30-07.SDR AWXA200700430Floorbeam · corrodedSAL - CORROSION ON CABIN FLOORBEAM, -Y1292, FR 66 + 8" - FR 68. REPLACED CABIN FLOORBEAM, -Y1292, FR 66 - FR 68 IAW A320 SRM 51-72-11.SDR 07FDEA01186Floorbeam · corrodedCABIN FLOORBEAM FS 680,BL-0 TO RBL 24.75 CORRODED ON UPPER SURFACE. REMOVED CORROSION IAW SRM 51-10-06, ORIGINAL MATERIAL IS .125" MATERIAL LOSS IS .011", MATERIAL REMAINING IS .114", IT IS OUT OF LIMIT IAW SRM P TO F 63-10-1. REMOVED DAMAGED IAW SRM 53-10-0SDR DL76P070275Floorbeam · corrodedDURING HMV, FOUND STA 287 FLOORBEAM CORRODED 18 INCHES FROM BL 0 RT. CAUSE OF CORROSION WAS ENVIRONMENTAL. DAMAGE WAS REPAIRED PER SRM 53-00-51D. CORROSION WAS FOUND DURING HMV ROUTINE INSPECTION.SDR KCSA071098Floorbeam · damagedUPPER DECK FLOORBEAM STA 420 RBL 5 HAS ELONGATED FASTENER HOLE IN UPPER CHORD FWD SIDE.SDR KCSA071097Floorbeam · dentedSTA 1720 RBL 46 FLOORBEAM UPPER CAP DENTED WL 118.SDR 07FDEA01185Floorbeam · cracked1 CRACK EXIST IN FLOORBEAM VERTICAL STIFFENER AT FRAME 36 BETWEEN SEAT TRACK L2 AND L3 MEASURING .5" REF R537B1041000 A310-200 AMM 53-10-15-6. REMOVED CRACK PER A310 SRM SUPP 53-10-15 FIG 201. NDT C/W PER NTM 51-10-08, NO CRACK INDICATIONS NOTED. FABBED RESDR 07FDEA01184Floorbeam · cracked1 CRACK FOUND .75" IN UPPER SUPPORT LEG ON AFT SIDE OF FLOORBEAM FR 58 BETWEEN SEAT TRACK 4L AND 5L EXTENDING INTO FLOORBEAM WEBBING UNDER CLS ADAPTER IAW A310-200 AMM 53-16-11-6. REMOVED DAMAGED AREA AND REPAIRED IAW AB DWG R53270150 AND EA 6-5310-107708.SDR COEA0701913Floorbeam · corrodedDURING CHECK, FOUND CORROSION ON LEFT FLOORBEAM FS 17 AT NUT PLATE HOLE. REMOVED CORROSION, CUT OUT DAMAGED SECTION, FABRICATED AND INSTALLED FABRICATED FLOORBEAM SECTION IAW ATR42 SRM. (M)SDR SWIA200718168Floorbeam · crackedFS 280 RBL 9 FLOOR SUPPORT UPPER ANGLE IS CRACKED, DISCOVERED AT C-CHECK. FABRICATED AND INSTALLED REPAIR PART -6, -4 SPLICE ANGLE AND -2 FILLER ANGLE IAW CRJ 200 SRM 51-42-10 AND REO 601R-53-11-137 REV NC.SDR SWIA200718167Floorbeam · crackedFLOOR SUPPORT STRUCTURE AT FS 484 RBL 30 HAS A CRACKED ANGLE, DISCOVERED AT C-CHECK. REPLACED CLIP PN 601R31171-9 PER REO 601R-53-41-059.SDR SIMA200709403Floorbeam · corrodedLEFT OMEGA BEAM AT FRAME 20 CORRODED. REMOVED CORROSION BY CUTOUT, FABRICATED AND INSTALLED NEW REPAIR PARTS IAW EMB SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.
Back to JASC 5315