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 ASAA0310181Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM AT BS 1016, LT BUTTOCK LINE 8, LEFT BUTTOCK LINE 13 CORRODED. REMOVED AND REPLACED FLOORBEAM PER SRM. (M)SDR ASAA0310182Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM AT BS 663-706, RIGHT BUTTOCK LINE 25 CORRODED. REMOVED CORROSION AND REPAIRED FLOORBEAM PER SRM. (M)SDR ASAA0310183Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM AT BODY STATION 540-616, RIGHT BUTTOCK LINE 45 CORRODED. REMOVED CORROSION AND REPAIRED FLOORBEAM PER SRM. (M)SDR ASAA0310180Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM AT BS 986.5, LEFT BUTTOCK LINE 17, RIGHT BUTTOCK LINE 43 CORRODED. REMOVED AND REPLACED FLOORBEAM PER SRM. (M)SDR SIMA200308405Floorbeam · corrodedABI - DURING A MBV INSPECTION, THE LEFT FLOORBEAM AT FRAME 20 CORRODD BELOW SRM LIMITS. CUT OUT DAMAGE SECTION OF LEFT FLOORBEAM, CLEANED AND TREATED THE REPAIR AREA. FABRICATED AN EXTERRNAL ANGLE, FILLER, PLATE AND SHIMS. REPAIR DONE IAW EMB SRM (SRM EMB 1SDR CALA0300137Floorbeam · corrodedINSPECTION FOUND AFT GALLEY FLOORBEAM CORRODED AT FORWARD AND AFT FLANGES AT STA 986, LBL 10 TO RBL 20. REMOVED AND REPLACED T-CAP IAW SRM 51-20-02.SDR CALA0300136Floorbeam · corrodedINSPECTION FOUND FLOORBEAM SCREW HOLES CORRODED AT TOP AND BOTTOM OF UPPER CAP AT BS 1006, LBBL 16.5, 20, AND 27.75. REMOVED AND REPLACED T-CAP IAW SRM 51-20-02 AND PERFORMED SPLICE REPAIR IAW ECRA 5310-03851.SDR AUS20030335Floorbeam · corroded(AUS) FUSELAGE FLOORBEAMS CONTAINED LEVEL 2 CORROSION.SDR SIMA200308406Floorbeam · corrodedABI - DURING A IMBV INSPECTION, THE LEFT FLOORBEAM AT FRAME 20 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT THE DAMAGED SECTION OF THE LEFT FLOORBEAM, CLEANED AND TREATED THE REPAIR AREA. FABRICATED AN EXTERNAL ANGLE, FILLER, PLATE AND SHIMS. REPAIR DSDR CALA0300126Floorbeam · corrodedINSPECTION FOUND FORWARD GALLEY FLOORBEAM CORRODED ON TOP SURFACE AT NUTPLATE AND LOWER SURFACE AT STA 312, RBL 20 TO RBL 31. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51, PAGE 205, 51-40-02, AND 51-20-01.SDR CALA0300125Floorbeam · corrodedINSPECTION FOUND FORWARD GALLEY FLOORBEAM CORRODED AT NUTPLATES ON FORWARD FLANGE AT STA 328, RBL 15 TO RBL 23. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51, PAGE 205, 51-20-01, AND 51-40-02.SDR 2003UALA00303Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED ON TOP CAP BS 859.3, LBL 52 AND ENDS AT BS 890. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED AREA AND FABRICATED REPAIR.SDR CALA0300121Floorbeam · corrodedINSPECTION FOUND FORWARD GALLEY FLOORBEAM CORRODED ON FORWARD AND AFT FLANGES AT STA 344, RBL 12 TO LBL 12. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-5, FIGURE 205.SDR ASAA0310156Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM FLANGE AT BS 420, LEFT BUTTOCK LINE 2, LEFT BUTTOCK LINE 42 CORRODED. REMOVED DAMAGED AREA AND REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0310154Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM AT BS 787, LEFT BUTTOCK LINE 65, RIGHT BUTTOCK LINE 65 CORRODED. REMOVED DAMAGED AREA AND REPAIRED TRACK PER EA. (M)SDR AUS20030326Floorbeam · corroded(AUS) FUSELAGE FLOORBEAM CONTAINED LEVEL 2 CORROSION IN AREA LOCATED AT THE AFT END OF THE DUMMY RAIL AT FRAME 16. AREA OF CORROSION 63.5MM BY 50.8MM WITH A DEPTH OF 2.54MM (2.5IN BY 2IN BY 0.10IN DEEP). FOUND DURING INSPECTION IAW J9-IA53-0410.SDR ASAA0310150Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM FLANGE AT BS 480, LEFT BUTTOCK LINE 43 CORRODED. REMOVED CORROSION AND REPAIRED FLOORBEAM PER EA. (M)SDR SWAA030603Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772.5, LBL 3, LBL 17.24, RBL 3 & RBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR ASAA0310140Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM AT BS 867, LEFT BUTTOCK LINE 65 RIGHT BUTTOCK LINE 65 CORRODED. REMOVED DAMAGED AREA AND REPAIRED PER EA. (M)SDR UPS03M40440Floorbeam · corrodedINSPECTION TYPE:C GALLEY FLOORBEAM SUPPORT AT LBL 46 STA 2007 ATTACHMENT FOUND CORRODED. CORROSION AREA REMOVED AT LBL 46 STA 2007 GALLEY FLOORBEAM SUPPORT FOUND EXCEED LIMIT PER SRM 51-21-01 VOL II & 53-00-01 VOL I REV 32. NEW T-CHORD & SPLICE FABRICATED ASSDR 2003F00397Floorbeam · crackedAT C-CHECK, FOUND CRACK ON AFT CARGO FLOORBEAM AT STATION 950B, BL 0. FABRICATE NEW ANGLE. TREATED, PRIMED AND INSTALLED NEW ANGLE AT STATION 950B BL 0. (M)SDR 0300813224Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON FLOOR SUPPORT BEAM AT FRAME 20 LBL 30. REPAIRED PER EA 32-193626.SDR AWXA200300317Floorbeam · corrodedDURING C-03 CHECK CORROSION WAS FOUND AT 6 EACH NUT PLATES ON LOWER SURFACE OF FLOORBEAM BETWEEN FR 66+10 AND FR 68, LBL 57, Y1732. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT DAMAGED AREA OF FLOORBEAM BETWEEN FR 66+10 ANDSDR LR7A03019Floorbeam · crackedDURING SCHEDULED C4 INSPECTION PER JOB CARD HC4911 FOUND LT FLOORBEAM CHINE ANGLE CRACKED AT FS 477, LBL 61, WL 140. REPAIR IAW SRM SMP 583 53-40-27. NR 2108.SDR AWXA200300301Floorbeam · corrodedDURING C-03 CHECK CORROSION WAS FOUND ON THE UPPER SURFACE OF FLOORBEAM WHERE THE LT AFT FLIGHT ATTENDANT SEAT MOUNTS, (OUTBOARD FORWARD MOUNT) FR 66, LBL 35. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SECTION OFSDR SWAA030607Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 328, WL 208 & LBL 28 AND BS 344, WL 208 & LBL 8. REPAIRED FLOORBEAM PER SRM.SDR SIMA200307908Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, CORROSION ON THE CENTER OMEGA BEAM AT FRAME 20. REMOVED CORRODED AREA BY CUTOUT. FABRICATED AN EXTERNAL U-SHAPE DOUBLER. REPAIRE DONE IAW EMB 145 SRM (145/1142, REV 20) 53-21-10 PARA 5, FIG 204 SHEET 2 AND STANDARD SRM PRACTSDR 2003UALA00264Cap · erodedCABIN STA 1640, RBL 57" FLOORBEAM TOP CAP HAS EXCESS MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. PERFORMED SINGLE FLANGE BLENDOUT REPAIR.SDR ASAA0310128Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM AT BS 947, LEFT BUTTOCK LINE 44, RIGHT BUTTOCK LINE 54 CORRODED. REMOVED AND REPLACED FLOORBEAM PER SRM. (M)SDR ASAA0310129Floorbeam · corrodedPAE - DURING C-CHECK, FOUND FLOORBEAM AT BS 1006, LEFT BUTTOCK LINE 10, RIGHT BUTTOCK LINE 28 CORRODED. REMOVED AND REPLACED FLOORBEAM PER SRM. (M)SDR ASAA0380258Floorbeam · corrodedOAK - DUIRNG C-CHECK, FOUND FLOORBEAM CORRODED ON OUTBOARD OF PANEL F-6, FS 160-196. REPLACED SUPPORT BEAM PER SRM 51-10-4 AND 51-30-2. (M)SDR 2003UALA00250Floorbeam · corrodedAFT CABIN FLOOR BEAM CORRODED AT STA 986 RBL 7 TO RBL 44. MAJOR REPAIR ACCOMPLISHED. T-CAP REPAIR AND SPLICE REPAIR.SDR SIMA200307008Floorbeam · corrodedABI - DURING A IMBV INSPECTION THE LEFT OMEGA BEAM AT FRAME 33 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. BLENDED THE CORRODED AREA AND PEFORMED AN NDT INSPECTION. FABRICATED A DOUBLER, REPAIR DONE IAW EMB SRM (SRM EMB 145/1141 REV 20) CHAPTERS 53-21-10 FIG 2SDR AWXA200300255Angle · crackedMCN - MAJOR REPAIR - DURING C-14 CHECK A 1" CRACK WAS FOUND ON THE UPPER ANGLE OF INTERCOSTAL AT BS 380 TO BS 400, BL 0. MAINTENANCE REMOVED THE UPPER ANGLE ON INTERCOSTAL FROM BS 380 TO BS 400; FABRICATED A NEW REPLACEMENT ANGLE; INSTALLED REPAIR PART IAW B73SDR 03FDEA00287Floorbeam · corrodedCORROSION ON 950 FLOORBEAM UPPER AND LOWER SURFACE OF UPPER FLANGE AT NUT PLATE HOLE LBL 23 WL 208. REMOVED CORROSION ON BS 950 FLOORBEAM AT LBL 23 WL 208 OUT OF LIMITS IAW SRM 53- 10-1 FIG 5 REMOVED DAMAGED PORTION OF FLOORBEAM, FABRICATED AND INSTALSDR SIMA200307007Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE CENTER OMEGA BEAM BETWEEN FRAMES 23 AND 26 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT 6.25 INCH SECTION OF THE DAMGAED BEAM. FABRICATED AN EXTERNAL ANGLE, SHIMS AND FILLER. REPAIR DONE IAW EMB SRM (SRM 145/1142 RSDR SWAA030508Beam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 312, WL 208, LBL 35 TO RBL 22. REPAIRED FLOORBEAM PER SRM.SDR 03FDEA00279Floorbeam · corrodedCORROSION ON TOP OF UPPER LOBE FLOORBEAM AT BS 320 LBL 46. FOUND UPPER LOBE OF FLOOR BEAM AT BS 320 LBL-46 TO BE OUT OF LIMITS. REPAIRED FLOOR BEAM AT BS 320 LBL-46 IAW FED EX E.A. 7-5310-69427A.SDR ASAA0310093Floorbeam · corrodedOKC - DURING D-CHECK, FOUND FLOORBEAM WEB AT BS 947, LEFT BUTTOCK LINE 50 CORRODED. REMOVED AND REPLACED WEB PER SRM. (M)SDR SIMA200307005Floorbeam · corrodedABI - DURING A IMBV INSPECTION, THE OMEGA BEAM BETWEEN FRAMES 23 AND 25 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUTOUT 4 INCH SECTION OF DAMAGED OMEGA BEAM. FABRICATED AN EXTERNAL ANGLE, TWO SHIMS. REPAIR DONE IAW EMB SRM (SRM EMB 145/1142 REV 20) CHAPTESDR SWAA030498Beam · corrodedDURING SCHEDULED D CHECK, FOUND BS 987 FLOORBEAM UPPER CHORD CORRODED BETWEEN LBL 15 AND RBL 41, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR UPS03840392Floorbeam · corrodedINSPECTION TYPE: C2, LOWER RT SECTION FLOORBEAM CORRODED AT STA 879 BL60R WL 10. REMOVED AND FAB NEW SECTION OF FLOORBEAM IAW TIMCO REO G09098. ALODINED AND PRIMED BEAM IAW DC8 SRM 51-1-8. FAB 4 EA CLIPS IAW DAC DWG 5645332. ALODINED AND PRIMED CLIPS IAW SDR ZLW2003F00000Floorbeam · crackedDURING A ROUTINE CABIN BELOW FLOOR INSPECTION, IT WAS FOUND THAT THE AFT FLOORBEAM SECONDARY SUPPORT WAS CRACKED. A NEW PART IS AVAILABLE FROM MFG AND WILL BE INSTALLED PRIOR TO FURTHER FLIGHT.SDR AWXA200300275Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-03 CHECK A 1 5/8 CRACK WAS FOUND ON CABIN FLOOR SUPPORT BEAM FR 47, Y 254. MAINTENANCE CUTOUT DAMAGED AREA OF CABIN FLOOR SUPPORT BEAM FR 47, Y 254; PERFORMED HFEC INSPECTION OF CUTOUT TO VERIFY NO CRACKS EXIST; FABRICATED A REPAISDR SWIA200311906Floorbeam · crackedPILOTS BULKHEAD FS 280 RDL 9.0 FLOORBEAM CRACKED. FOUND DURING C-CHECK INSPECTION. HFEC INSPECTION COMPLIED WITH ON CUT OUT REPAIR AREA AS REQUIRED IAW RJ NDTM 51-20-06. NO CRACKS FOUND. DAMAGED AREA REPAIRED IAW CRJ REO 601R-53-11-137 REV NC.SDR SWAA030478Beam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 294, WL 208, RBL 1. REPAIRED FLOORBEAM PER SRM.SDR 03FDEA00192Floorbeam · corrodedCORROSION (C53-224-011) ON TOP OF UPPER LOBE FLOORBEAM AT BS 620, RBL 3, TO RBL 23. CORROSION AT BS 620, WL 208, RBL 3 TO RBL 23 DETERMINED TO BE OUT OF LIMITS IAW B727, SRM 53-10-1 FIG 4. REMOVED UPPER CHORD OF BEAM FROM LBL 32 TO RBL 36.5. FABRICATED REPASDR 03FDEA00193Floorbeam · corrodedCORROSION ON 950D FLOORBEAM UPPER FLANGE UPPER AND LOWER SURFACES RBL 25, LBL 25, WL 208. REMOVED CORROSION FROM FLOORBEAM BS 950D, RBL 10.5, FOUND OUT OF LIMITS IAW SRM 53-10-1. CUT OUT DAMAGED SECTION OF UPPER CHORD BS 950D LBL 37-RBL 37. FABRICATED REPAISDR AWXA200300308Floor Support · corrodedDURING C-09 CHECK CORROSION WAS FOUND ON UPPER SURFACE OF FLOOR SUPPORT FRAME BS 1480, RBL 12. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED CORRODED FLOOR SUPPORT FRAME BS 1480, RBL 12; FABRICATED A NEW FLOOR SUPPORT PSDR CALA0300086Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON UPPER AND LOWER SURFACES OF UPPER CAP AT STA 1006 FROM BL 0 TO RBL 40. REMOVED AND REPLACED T-CAP IAW ECRA 5310-03851.
Back to JASC 5315