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 2004UALA00802Floorbeam · corrodedAFT CABIN FLOORBEAM AT STA 1661, RBL 54 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP REPAIR.SDR 2004UALA00801Floor Support · corrodedCABIN STATION 365, CL TO RBL 15 FLOOR SUPPORT HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP AND L-ANGLE REPAIR.SDR DHL2004366004Floorbeam · corrodedDURING A-7 CHECK, FWD CARGO FLOOR ATTACH FITTINGS HAVE CORROSION STR 42 FWD & AFT SIDE FRAME 31 & FWD SIDE FRAME 32. REMOVED FLOOR PANELS FOR ACCESS TO FLOORBEAM AREA FWD LOWER CARGO COMPT. CUT OUT DAMAGE AREA FLOORBEAM FRAME NR 32 RBL 19 AREA FWD LOWER CARGSDR USAA040548Floorbeam · corrodedCLT - FOND FLOORBEAM HAS CORROSION EMINATING FROM FASTENER HOLES, STATION 365 AT RBL 60. INSTALLED FASTENERS PER SRM 51-40-02 AND EA 95736. (M)SDR USAA040549Floorbeam · corrodedPIT - FOUND FLOORBEAM CORROSION EMINATING FROM FASTENER HOLES, STATION 377 AT LBL 6 TO RBL 30. REMOVED UPPER T-CAP AND REPLACED WITH FABRICATED PART PER SRM 53-00-01 FIG 203, EA 95751. (M)SDR USAA040550Floorbeam · corrodedCLT - FOUND UPPER T-CAP EMINATING FROM FASTENER HOLES, FS 345 AT RBL 58. CORROSION LEVEL 1 TASK NR C53-221-03, CR3-222-03. FABRICATED REPLACEMENT T-CAP AND INSTALLED PER EA 95747 AND SRM 51-20-07. (M)SDR USAA040535Floorbeam · corrodedCLT - FOUND UPPER CHORD WITH CORROSION, EMINATING FROM FASTENER HOLES, FS 377 RBL 1, UPPER CHORD ON UPPER SURFACE. FABRICATED REPAIR CHORD PER SRM 53-00-51 FIG 203 AND EA 95751. (M)SDR USAA040482Floorbeam · corrodedPIT - FOUND FLOORBEAM UPPER CAP CORRODED 2 FT BY 70 INCH AREA, BS 986.5 CABIN FLOORBEAM UPPER CAP. REMOVED CORRODED T-CAP AND REPLACED WITH NEW PER TYPICAL REPAIR 53-10-05B. CORROSION LEVEL 1, TASK NR C53-107-02. (M)SDR USAA040428Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 3 SQUARE INCHES BY .039 INCH, FRAME 66 AT Y254. INSTALLED DOUBLER PER EA 95752. (M)SDR USAA040427Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 5 SQUARE INCHES BY .030 INCH, FRAME 65-66 Y 765. INSTALLED DOUBLER PER EA 95741. (M)SDR USAA040431Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 SQUARE INCHES BY .035 INCH AREA, FRAME 66-68 Y1292. REMOVED CORROSION PER SRM 51-74-00. (M)SDR USAA040432Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED 1 INCH CIRCULAR AREA, SCREW HOLE ON FLOORBEAM T-CAP, STATION 1640 LBL 40. DAMAGE REMOVED, T-CAP REPLACED PER EA 95744. (M)SDR USAA040430Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 SQUARE INCHES BY .043 INCH AREA, FRAME 66Y 1292. INSTALLED DOUBLER PER EA 95743. (M)SDR USAA040429Floorbeam · corrodedCLT - FOUND FLOORBEAM WITH CORROSION 5 SQUARE INCHES BY .35 INCH AREA, FRAME 66-68. INSTALLED DOUBLER PER EA 95742. (M)SDR C2XA04TY149Floorbeam · corrodedDURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE FORWARD DIGITAL JUST AFT OF THE COCKPIT DOOR STEP. MAINTENANCE ACCOMPLISHED A BLEND OUT REPAIR IAW SRM 53-21-10 AND CPM 51-21-04,05,06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA04TY148Floorbeam · corrodedDURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE CENTER OMEGA BEAM TOPCAP AT FRAME 22. MAINTENANCE ACCOMPLISHED A BLEND OUT REPAIR IAW SRM 53-21-10 AND CPM 51-21-04,05,06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR 04FDEA02391Floorbeam · corrodedLOWER FUSELAGE BULK CARGO PIT LATERAL FLOORBEAM AT FR66 LT OF CENTERLINE HAS EXFOLIATED CORROSION AROUND FASTENER HOLE (LEVEL 2). REMOVED DAMAGED AREA, FABRICATED FILLER, ANGLE AND INSTALLED IAW A310/200 SRM 53-10-15 AND 51-25-00.SDR USAA040463Floorbeam · corrodedPIT - FOUND BEAM CORRODED 20 INCHES LONG BY .035 INCH, STATION 294 LBL 10 TO RBL 10. INSTALLED SPLICE PER SRM 53-10-08. (M)SDR AWXA200400925Floorbeam · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON BEAM Y1292 LT BETWEEN FR 68 AND FR 69. MAINTENANCE REMOVED CORRODED BEAM Y1292 LT FROM FR 68 TO FR 69; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200400924Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON BEAM Y1292 LT AFT OF FR 66 TO FORWARD SIDE OF FR 68. MAINTENANCE REMOVED CORRODED BEAM Y1292 LT FROM FR 66 TO FR 68; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SRM 5SDR AWXA200400895Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RT AT FORWARD END OF FR 20. MAINTENANCE REMOVED AND REPLACED BEAM Y1292 RT AT FR 20 IAW A320 SRM 51-42-11 FIG 8, 9 & 12.SDR C1HA200476004Floorbeam · corrodedCORROSION ON FLOORBEAM STA 1010 LBL 0 - 15 LBL. CLEAN, TREAT & INSTALLED REPAIR DOUBLER.SDR AMTA200400977Floorbeam · corrodedFOUND AFT CABIN FLOOR SUPPORT BEAM AT FS 1681 FROM BL 0 TO RT DOOR SILL HAS EXFOLIATION CORROSION. CUT OUT DAMAGED SECTION AND FABRICATE AND INSTALLED DOUBLER REPAIR IAW B757 SRM 53-60-51. (M)SDR AMTA200400984Floorbeam · corrodedFOUND GALLEY G1B FLOOR BS 370-BS 370 RBL 58 TO BL 0 CORROSION. REMOVED AND REPLACED DAMAGED SECTION OF FLOORBEAM AT FS 365, RBL 9 TO RBL 69 IAW B757 SRM 53-00-51-2, FIG 203 AND 51-40-2. (M)SDR C1HA200476005Floorbeam · corrodedCORROSION ON FLOORBEAM STA 1010 LBL 0 - 15 LBL. CLEANED, TREATED & INSTALLED REPAIR DOUBLER.SDR 2004UALA00811Floorbeam · cracked09MAY OAK CF -9 :FWD PIT FLOORBEAM UPPER AFT FLANGE CRACKED IN RADIUS APPROX BS 15 RBL 29. REPAIR INSTALLED PER 53-00-53, (INTERIM REPAIR) AND MUST BE REPLACED WITH A CAT-A OR CAT-B BEFORE 4000 FLIGHT CYCLES. MAJOR REPAIR ACCOMPLISHED. PERMANENT REPAIR ACCOSDR ASOA04631Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FS 39 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FS 39 IAW SRM 51-25-01. (M)SDR SWAA042200Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND FLOORBEAM WEB AT BS 178 TO BS 182, LBL 24 TO LBL 37, CRACKED. REMOVED AND REPLACED FLOORBEAM WEB SECTION PER SRM.SDR ASOA04624Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAMS AT FS 36 BETWEEN STRINERS 16R AND 16L, AND FS 38 BETWEEN STRINGERS 15R AND 15L WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS AT FS 36 BETWEEN STRINGERS 16R AND 16L, AND FS 38 BSDR USAA040426Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 8 SQUARE INCHES BY .040 INCH, FRAME 66-68 Y1292. INSTALLED DOUBLER PER EA 95738. (M)SDR C2XA04TY133Floorbeam · corrodedTYS - DURING A SCHEDULED 4C INSPECTION CORROSION WAS FOUND ON THE CENTER AREA OF THE FLOORBEAM AT FR 20>23. REMOVED AND REPLACED THE FLOORBEAM IAW EMB 135/145 SRM 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE RELEASED UPON COMPLETION OF ALL 4C INSPECTION.SDR C2XA04SH476Floorbeam · corrodedSHV - DURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 22 1/2. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A SHIM FILLER REPAIR IAW EMB 145 SRM 53-21-10, FIG 208. MAINTENANCE IS AWAITING ENGINEERING APPROVAL FOR REPAIR.SDR C2XA04SH475Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA042191Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 772, BETWEEN RBL 8 TO LBL 8 CORRODED. REPAIRED FLOORBEAM PER EA.SDR C2XA04SH474Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED AT THE CROSSBEAM BETWEEN FRAMES 24 AND 25. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SIMA200422407Floorbeam · corrodedABI - DURING AN IMBV INSPECTOIN, MAINTENANCE FOUND FLOORBEAM CORROSION IN CENTER FUSELAGE. REMOVED CORROSION BY MAKING A CUTOUT. FABRICATED A REPAIR ANGLE, FILLER, TWO SHIMS AND PLATE. REPAIR DONE IAW EMB SRM, SRM 145/1142 REV 26, 53-21-10 FIGURE 201. (M)SDR C2XA04SH472Floorbeam · corrodedSHV - DURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 24 AND 25. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A SHIM FILLER REPAIR IAW EMB 145 SRM 53-21-10, STEP 3 FIG 202, SHEET 1. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVSDR AWXA200400877Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-19 CHECK CORROSION WAS FOUND ON LOWER SURFACE UPPER AFT LEG OF FLOORBEAM UPPER CHORD AT BS 294, RBL 13, WL 208. MAINTENANCE CUT OUT DAMAGE ON FLOORBEAM UPPER CHORD AT BS 294, FROM LBL 22 TO RBL 23; FABRICATED A NEW REPLACEMENT SESDR C2XA04SH470Floorbeam · corrodedDURING C-CHECK THE LT FLOORBEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EC 5310-01283. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AWXA200400868Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-19 CHECK CORROSION WAS FOUND ON FLOORBEAM UPPER CHORD AT BS 328 BETWEEN RBL 12 AND RBL 52, WL 208. MAINTENANCE REMOVED CORRODED FLOORBEAM UPPER CHORD AT BS 328 FROM RBL 12 TO RBL 52, WL 208; FABRICATED A NEW REPLACEMENT FLOORBEAMSDR C2XA04SH469Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 24, GREATER THAN 30 PERCENT OF ORIGINAL THICKNESS OF .070 INCH (OUT OF LIMITS) BUT WITHIN REPAIRABLE LIMITS.SDR AALA20040785Floorbeam · corrodedTUL - CORROSION ON TOP OF FLOORBEAM AT STATION 1640 LEFT BUTTLINE 15 TO LEFT BUTTLINE 53. CORRODED AREA IS 2 INCHES BY 40 INCHES. REPAIRED CORROSION ON TOP OF FLOORBEAM AT STATION 1640 LET BUTTLINE 15 TO LEFT BUTTLINE 53 IN ACCORDANCE WITH STRUCTURAL REPAIR SDR 04FDEA02220Floorbeam · crackedRIGHT HAND CAC COMPARTMENT AT STA 6-90 AT APPROX 64 INCHES FROM CENTER FOUND CRACK AT FLOORBEAM LOWER CHORD. CRACK AT CAC, RT COMPARTMENT AT STA 6-90 AT APPROX. 64 INCHES FROM CENTER AT FLOORBEAM LOWER CHORD CARRIED OUT REPAIR AS PER FEDEX EA NR 1-5310-79813,SDR AWXA200400878Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-19 CHECK CORROSION WAS FOUND ON FLOORBEAM AT BS 986, BETWEEN LBL 25 AND LBL 31, WL 208. MAINTENANCE REMOVED UPPER CHORD OF FLOORBEAM AT BS 294, FROM LBL 51 TO RBL 10; FABRICATED A NEW REPLACEMENT SECTION OF UPPER CHORD; INSTALLEDSDR C2XA04SH468Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA042143Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 294, RBL 53, CORRODED. REPAIRED CHORD PER SRM.SDR SWAA042142Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 270, RBL 11, CORRODED. REMOVED AND REPLACED CHORD PER SRM.SDR M562004F00001Floorbeam · corrodedMAIN CABIN AFT LBL46 HAS CORROSION ON TOP OF FLOORBEAM AT STA 980. REMOVED CORROSION, PERFORMED EDDY CURRENT. RETURNED TO SERVICE. C1,C2 AND C3 INSP 8/4/04.SDR SIMA200422404Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND CORRODED BEYOND SRM LIMITS. REMOVED CORROSION BY MAKING A CUTOUT. FABRICATED DOUBLER, FILLER AND SHIMS. REPAIR DONE IAW EMB SRM, SRM 145/1142 REV 26, 53-21-10 FIGURE 201. (M)SDR 2004UALA00698Floorbeam · corrodedCABIN FLOORBEAM AT FS 365 RBL 10 TO RBL 15 CORRODED. FABRICATED & INSTALLED NEW WEB AND ANGLE REPAIRS.
Back to JASC 5315