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 GAIA99113Floorbeam · corrodedDURING AN 'HC' INSPECTION BEING PERFORMED IN OKC AT AAR REPAIR STATION, IT WAS DISCOVERED THAT THE FLOORBEAM AT STATION 620 IS CORRODED BETWEEN LBL 24.75 AND RBL 24.75 SEAT TRACKS. REPAIRED IAW ATS DRAWING 2000-0276. THIS DRAWING WAS DER RECOMMENDED AND ACO SDR 99ZZZX3444Floorbeam · corrodedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK CARD, FOUND CORROSION ON FLOORBEAM AT BS 312, BL ZERO. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PER SRM 53-10-8.SDR 99ZZZX3435Floorbeam · corrodedDURING ACCOMPLISHMENT OF ROUTINE 'C' CHECK WORK CARD, FOUND FLOORBEAM CORRODED AT BS 460 LBL 62 TO RBL 62. REMOVED CORROSION AND FOUND OUT OF LIMITS PER SRM 53-10-1. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR TO UPPER CHORD PER SRM 53-10-8.SDR 99ZZZX3434Floorbeam · corrodedDURING ACCOMPLISHMENT OF ROUTINE 'C' CHECK WORK CARD, FOUND CORROSION ON FLOORBEAM AT BS 360 LBL 62 TO RBL 62. REMOVED FLOORBEAM UPPER CHORD PER SRM 51-30-2. FABRICATED AND INSTALLED NEW UPPER CHORD PER 53-10-8.SDR CALA9901017Floorbeam · corrodedINSPECTION FOUND FLOORBEAM WEB CORRODED AT FS 1338 BETWEEN RBL 45 AND LBL 45. THE CORROSION WAS REMOVED IAW SRM 51-10-3. A REPAIR DOUBLER WAS INSTALLED IAW ECRA 5310-03888 AND SRM 51-10-3.SDR CALA9901009Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CAP CORRODED AROUND NUT PLATE HOLES AT STA 947.5, LBL 15 TO RBL 8. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-00-51, PAGE 207-209.SDR CALA9901008Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, LBL 10 TO RBL 25. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR CALA9901007Floorbeam · corrodedINSPECTION FOUND LAV FLOORBEAM CORRODED AT STA 1332, LBL 58 TO RBL 58. THE FLOORBEAM WAS REPAIRED IAW SRM 53-08, FIGURE 2.SDR CALA9901000Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, LBL 44. THE CORRODED AREA WAS CUT OUT. A REPAIR DOUBLER AND FILLER WAS INSTALLED IAW SRM 53-10-8, 51-30-2, AND 51-10-6.SDR CALA9900991Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND NUT PLATE HOLES AND EDGES AT STA 986.5. A NEW SECTION OF FLOORBEAM WAS INSTALLED IAW ECRA 5310-03851.SDR CALA9900963Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1921 ON RT SIDE UNDER LAV J. A NEW FLOORBEAM WAS INSTALLED IAW SRM 51-30-00.SDR USAA990763Floorbeam · corrodedCLT - DURING A Q-1 CHECK VISUAL INSPECTION FOUND A 4 INCH BY 1 INCH AREA OF CORROSION AT STA 773, LBL 3 FLOORBEAM AFT CARGO. CORROSION LEVEL 2. CUT OUT CORROSION, INSTALLED REPAIR ANGLE, DOUBLER PER TR 53-10-06, SRM'S 51-30-09, 51-10-02, 51-20-01/05. (X)SDR USAA990762Floorbeam · corrodedCLT - DURING A Q-1 CHECK VISUAL INSPECTION, FOUND A 21 INCH BY 1 INCH AREA OF CORROSION AT STA 773, RBL 14 FLOORBEAM AFT CARGO. CORROSION LEVEL 2. INSTALLED NEW SECTION OF FLOORBEAM AND SPLICE PER SRM 53-00-53. (X)SDR USAA990706Floorbeam · crackedCLT - DURING A Q-1 CHECK VISUAL INSPECTION, FOUND A 4 INCH CRACK 1.5 INCHES AFT OF STA 663.75 AT BL ZERO BEAM (FRAME). INSTALLED FLOORBEAM REPAIR PER EA 64999 AND BOEING SB 737-57-1210 FIG 4 AND 8. (X)SDR UPS99830548Floor Beam · corrodedINSPECTION TYPE:C3, CORROSION AND POPPED RIVETS AROUND FASTENERS ON FLOOR SUPPORT BEAM FS 920 LT SIDE OF FUSELAGE. FABBED ANGLE ON TIMCO OPS 50017, SHOT PEENED IAW DC8 SRM 51-1-4A. DRILLED AND SLOTTED CRACK IN FLOORBEAM IAW REO 06663 REV B. FABBED DOUBLER ASDR SWAA991295Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM, BS 312, RBL 36. REPAIRED BEAM PER SWA RA NR 1-353-2136.SDR SWAA991294Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM, BS 947.5, LBL 50. REPAIRED BEAM PER SWA RA NR 1-353-2135.SDR UPS99230301Floorbeam · corrodedINSPECTION TYPE:C, WHILE WORKING CUSTOMER CARD 933983 INT 71, FOUND CORROSION ON BS 328 FLOORBEAM TOP FLANGE WL 208 AT LBL 7 AND LBL 25. REMOVED DAMAGED AREA ON FLOORBEAM. FABRICATED REPAIR PARTS AND INSTALLED IAW SRM 53-10-8, 51-10-2, 53-10-8.SDR CALA9900928Floorbeam · corrodedINSPECTION FOUND FORWARD LAV FLOORBEAM CORRODED AT STA 327, RBL 44-60. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03889.SDR UPS99230296Floorbeam · corrodedINSPECTION TYPE:C, WHILE WORKING CUSTOMER CARD NUMBER 933976 INT 64, FOUND CORROSION ON FLOORBEAM BS 312 LBL 3 WL 208. CORROSION OUT OF LIMITS. FABRICATED REPAIR PARTS AND INSTALLED ALL WORK DONE IAW SRM 51-10-6, 53-10-1, 51-30-5, 51-30-6 AND SRM 51-10-2.SDR UPS99830476Floorbeam · corrodedINSPECTION TYPE:C3 FWD PIT FS 100 RBL 41 FLOORBEAM CORRODED. FLOORBEAM FOUND TO BE OUT OF LIMITS IAW DC8 SRM 51-7-1 FIG 13 AND DC8 SRM 51-2-0, FIG 50 ORG 125. FABRICATED AND INSTALLED DOUBLER IAW REO- 06665, DC8 SRM 51-1-20. INSTALLED FLOORBOARD SECTIONS IASDR USAA990865Floorbeam · corrosionCLT - DURING Q-3 VISUAL INSPECTION, FOUND A AREA OF CORROSION IN CLIPNUT HOLES T-CAP OF FLOORBEAM STATION 294.5, RBL 15-52. CORROSION LEVEL 2. REPLACED T-CAP PER SRM 53-10-51 AND SRM 51-40-02. (M)SDR USAA990773Floorbeam · corrodedCLT - DURING Q-3 CHECK, FOUND CORROSION ON UPPER SURFACE OF FLOORBEAM T-CAP AT STATION 947 BETWEEN LBL 14 TO RBL 16, CORROSION LEVEL 2. CORROSION TASK NR C53-107-02. SPLICED T-CAP SECTION/DOUBLERS PER SRM 53-00-51 FIG 202. (M)SDR SIMA992094Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAMS 36 AND 38 WITH CORROSION AROUND THE NUTPLATE HOLES. REPAIRED FLOORBEAM 36 IAW SRM 53-00-00 FIGURE 435, AND REMOVED AND REPLACED FLOORBEAM 38 IAW SRM 51-25-04. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NRSDR SIMA992093Floorbeam · misdrilledSAW - DURING MBV-2 INSPECTION, FOUND FLOORBEAM 29 WITH AN OVERSIZED HI-LOCK HOLE AT THE LEFT INBOARD SEAT TRACK CENTER ATTACH POINT. REPAIRED THE FLOORBEAM IAW SRM 53-00-00. AIRCRAFT RETURNED TO SERVICE. (X)SDR COMA9960403Floorbeam · corrodedFLOOR SUPPORT BEAM CAPS P/N 601R31113-67 AT LBL 27 BETWEEN FS 314 TO FS 349, LBL9 BETWEEN FS 310.00 TO 409.00, RBL9 BETWEEN FS 310.00 TO FS 409.00 AND RBL 27 BETWEEN FS 310.00 TO 409.00 ARE CORRODED OUT OF LIMITS IAW CRJ REO 601R-53-00-005. PERFORMED A MAJOR SDR 99ZZZX3053Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAMS 36 AND 38 WITH CORROSION AROUND THE NUTPLATE HOLES. REPAIRED FLOORBEAM 36 IAW SRM 53-00-00 FIGURE 435, AND REMOVED AND REPLACED FLOORBEAM 38 IAW SRM 51-25-04. AIRCRAFT RETURNED TO SERVICE. REF: OPER CNTRL NRSDR CALA9900869Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT FS 400 BL 0 TO RBL 24. THE CORRODED AREA WAS CUT OUT AND A REPAIR WAS ACCOMPLISHED IAW SRM 53-10-8, PAGE 47.SDR TWAA9910703Floorbeam · crackedDURING OP 16 MAINT CHECK, FOUND FLOOR SUPPORT BEAM CRACKED AT LT SIDEWALL STA 680. CONFIRMED BY NDT. REPLACED FLOOR SUPPORT PER SPM 6-70-01.SDR USAA990743Floorbeam · corrodedTPA - DURING CX-1 CHECK, FOUND 2 INCH BY 10 INCH CORRODED AREA ON TOP SECTION OF 985.5 FLOORBEAM, RT SIDE AT PREVIOUS REPAIR. INSTALLED NEW REPAIR AT FLOORBEAM PER TYPICAL REPAIR MANUAL 53-60-01. (M)SDR C2XA99IA383Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FLOORBEAM WAS FOUND CORRODED AT FRAME 20. MAINTENANCE REMOVED THE CORROSION AND REPAIRED THE AFFECTED FLOORBEAM IAW CONTINENTAL EXPRESS ENGINEERING CHANGE AND REPAIR AUTHORIZATION EC5310-01109, AND THE AIRCRAFT WAS APSDR C2XA99IA382Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE CENTER FLOORBEAM WAS FOUND CORRODED FROM FRAME 15 TO FRAME 19. MAINTENANCE REMOVED THE CORROSION AND REPAIRED THE AFFECTED FLOORBEAM IAW EMBRAER FAX SST-1287/99, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (X) ASDR USAA990750Floorbeam · corrodedCLT - DURING C-4 CHECK VISUAL INSPECTION, FOUND A .75 INCH BY .75 INCH AREA OF CORROSION AT STATION 377, LBL 43 AROUND SCREW HOLES ON FLOORBEAM, CORROSION LEVEL 2. INSTALLED DOUBLER REPAIR ANGLE PER TR 53-15-02 AND SRM 51-10-00. (M)SDR SCNA99531Floorbeam · corrodedDURING A HEAVY MAINTENANCE CHECK, THE FLOORBEAM STABILIZER STRAP WAS FOUND CRACKED AT LBL 24 75 FORWARD OF THE FLOORBEAM AT BS 360. REMOVED DAMAGED AREA AND FABRICATED REPAIR PART AND INSTALLED IAW SRM 53108 FIG 6.SDR SCNA99530Floorbeam · corrodedDURING A HEAVY MAINTENANCE CHECK, THE FLOORBEAM STABILIZER STRAP WAS FOUND CRACKED AND SEVERED AT LBL 45 BETWEEN FLOORBEAMS AT BSTA 344 AND 360. REMOVED DAMAGED SECTION AND FABRICATED REPAIR SECTION IAW SRM 53108 FIG 6. ALODINED PRIMED AND INSTALLED IAW SRM SDR SCNA99528Floorbeam · corrodedDURING A HEAVY MAINTENANCE CHECK, THE FLOORBEAM AT STA 440 RBL 15 HAS CORROSION AROUND NUT PLATE HOLE. CORROSION WAS REMOVED AND FOUND OUT OF LIMITS PER SRM 53108. REMOVED DAMAGED SECTION AND FABRICATED UPPER CHORD FLOORBEAM REPAIR AND SUPPORT ANGLES AND REISDR SCNA99527Floorbeam · corrodedDURING A HEAVY MAINTENANCE CHECK, THE FLOORBEAM AT STA 460 RBL 12 WAS FOUND TO HAVE CORROSION. REMOVED CORROSION AND THE MATERIAL LOSS WAS FOUND TO BE OUT OF LIMITS PER SRM 53101. FABRICATED REPAIR ANGLES AND SHIMMED. TREATED PRIMED AND INSTALLED IAW SRM 5SDR SCNA99526Floorbeam · corrodedDURING A HEAVY MAINTENANCE CHECK, THE FLOORBEAM AT BS 328 LBL 195 WAS FOUND CORRODED AROUND THE FASTENER HOLE. REMOVED DAMAGED AREA AND FABRICATED REPAIRED PARTS PER 53108 FIG 9 AND INSTALLED TREATED AND PRIMED IAW 51102.SDR SCNA99524Floorbeam · corrodedDURING A HEAVY MAINTENANCE CHECK, THE FLOORBEAM UPPER CHORD AT STA 380 RBL 14 TO 41 WAS FOUND TO HAVE CORROSION DUE TO AN EXISTING REPAIR AT THIS LOCATION EXTENDING FROM LBL 7 TO THE RIGHT HAND FRAME. AN ENGINEERING ORDER WAS ISSUED TO ACCOMPLISH A REPAIR FORSDR SCNA99523Floorbeam · corrodedDURING A HEAVY MAINTENANCE CHECK, THE FLOOR BEAM AT BS 400 LBL 24 TO RBL 14 WAS FOUND TO HAVE CORROSION AROUND THE FASTENER HOLES. REMOVED CORROSION MATERIAL LOSS OUT OF LIMITS PER SRM 53101. FABRICATED UPPER CHORD IAW SRM 53108 FIG 3 AND SUPPORT ANGLES. INSDR SCNA99510Floorbeam · corrodedDURING A HEAVY MAINTENANCE CHECK, CORROSION WAS FOUND AROUND NUT PLATE HOLE ON TOP OF THE FLOORBEAM STATION 344 LBL 45. CORROSION WAS FOUND TO BE OUT OF LIMITS. REPAIRED FLOORBEAM PER SRM 53101 FIGURE 4.SDR GAIA99106Floorbeam · corrodedDURING A 'ZERO' LIGHT 'C' INSPECTION BEING PERFORMED IN OSC AT AMERICAN INTERNATIONAL AIRWAYS REPAIR STATION, CORROSION WAS DETECTED AT BS 1130 FLOORBEAM UPPER CAP, RBL 34-38. REPAIRED IAW AIA EDR B2-06516. DER APPROVED ON 8110-3 DATED MAY 12, 1999. (X)SDR CALA9901039Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED ON UPPER CHORD LOWER SURFACE FORWARD AND AFT OF STA 986.5, RBL 25-35. REPAIRED IAW ECRA 5310-03851.SDR SWAA991224Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON FLOORBEAM, BS 967, RBL 42. REPAIRED BEAM PER SRM.SDR 9903872285Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON THE UPPER FLANGE OF THE FLOORBEAM AT FS 1130, RBL 25 AND RBL 45. REPAIRED PER EA 22-167937.SDR 9903862285Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON THE UPPER FLANGE OF THE FLOORBEAM FS 380, RBL 8. REPAIRED PER EA 22-167934.SDR 9903269912Floorbeam · crackedDURING PERIODIC CHECK, A CRACK WAS FOUND IN THE VERTICAL WEB OF FS 237 FLOORBEAM. REPAIRED PER EA 99-164486.SDR UF6A990749Floorbeam · corrodedSBN - FOUND CORROSION ON ANGLE UNDER FLOOR AT STATION 378FS. MAINTENANCE REMOVED CORROSION BY MECHANICAL METHODS AND FABRICATED NEW SPLICE PLATE FROM ALCLAD 2024T3 .123. ALL WORK WAS DONE IAW DER REPORT 99-131. (M)SDR SWAA991217Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON FLOORBEAM UPPER SURFACE, BS 328, RBL 28- RBL 35. REPAIRED BEAM PER SRM.SDR 99UAL900387Floorbeam · corrodedCORROSION DAMAGE WAS FOUND ON THE STATION 1050 FLOORBEAM UPPER FLANGE AT RRL 30. THE RESULTING BLENDOUT WENT BEYOND ALLOWABLE LIMITS FOR MATERIAL REMOVAL. THE CORROSION WAS REMOVED BY BLENDING AND A REPAIR STRAP INSTALLED PER TIMCO REPAIR INSTRUCTIONS. THIS
Back to JASC 5315