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 DU4R2006422Floorbeam · corrodedFOUND CORROSION AFT PIT ON FLOOR SUPPORT ANGLE LWR SIDE BS 1510, RBL 7. FABRICATED AND INSTALLED REPAIR ANGLE 8.75 INCHES LONG FROM 7075-T6 .080 IAW B757 SRM 53-60-53 PG 221 AND 222.SDR AWXA200600780Floorbeam · corrodedMCN - DURING BC 4 CHECK DISCOVERED LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT Y1292 AND FROM FS 67 TO FS 67 +16". CORROSION WAS FOUND OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14 FIG 102. MAINTENANCE REMOVED AND INSTALLED NEW FLOORBEAM AT Y1292 AND FS 67 IAWSDR CALA0600145Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT NUT PLATE HOLE, STA 986.5, RBL 43. INSTALLED REPAIR IAW SRM 53-60-51.SDR AWXA200600778Floorbeam · corrodedMCN - DURING BC 4 CHECK DISCOVERED LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT Y-1292 AND FROM FS 68 TO FS 69. CORROSION WAS FOUND OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14 FIG 102. MAINTENANCE REMOVED AND INSTALLED NEW FLOORBEAM AT Y-1292 FROM FS 68 TO FSSDR AWXA200600777Floorbeam · corrodedMCN - DURING BC 4 CHECK DISCOVERED LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT Y1292 AND FROM FS 68 TO FS 69. CORROSION WAS FOUND OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14 FIG 102. MAINTENANCE REMOVED AND INSTALLED NEW FLOORBEAM AT Y 1292 FROM FS 68 TO FS SDR SWAA061432Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 941, RBL 8. REPAIRED FLOORBEAM PER SRM.SDR 06FDEA1628Floorbeam · cutCUT MARK INTO VERTICAL FLANGE OF FLOORBEAM JUST BELOW UPPER FLANGE BS 1010 RBL 57 WL 207 AFT SIDE. REPAIRED FLOORBEAM PER SR27-53-034 SHEET 5.SDR 06FDEA1627Floorbeam · cutCUT MARK INTO VERTICAL FLANGE OF FLOORBEAM JUST BELOW UPPER FLANGE BS 990 RBL 57 WL 207 AFT SIDE. REPAIRED FLOOR BEAM PER SR27-53-034 REV F.SDR USAA060637Floorbeam · corrodedFOUND FLOORBEAM CORRODED -Y1292 STA 66 - 68. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 53-11-15, DWG 53474180, DEFECT SIZE: 2" BY 60" BY .100".SDR USAA060634Floorbeam · corrodedFOUND FLOORBEAM CORRODED Y1292 STA 66 - 68. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 53-11-15, DWG D53474180; CORROSION TASK JA-260-53500, DEFECT SIZE: 2" BY 60" BY .100".SDR USAA060629Floorbeam · corrodedFOUND CORROSION ON BEAM AT -Y254 C18 AND C16. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 53-11-15; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1-1/2" BY 1-1/2" BY .040".SDR USAA060626Floorbeam · corrodedFOUND CORROSION STATION 986.5 FLOORBEAM TOP ENTIRE LENGTH. REMOVED AND REPLACED TOP CAP OF FLOORBEAM IAW 53-10-05B LEVEL 1 C53-107-02, DEFECT SIZE: 10".SDR USAA060638Floorbeam · corrodedFOUND CORROSION FLOORBEAM AT Y1292 LEFT FRAME 66-68. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 51-72-11; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 2 AREAS - 1" DIA AND 1" BY 2".SDR SWAA061415Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT FLOOR BEAM CORRODED AT BS 773, LBL 12. REPAIRED AFT CARGO COMPARTMENT FLOOR BEAM PER SWA EA.SDR CALA060141Floorbeam · corrodedAFT CABIN FLOORBEAM AT STA 986.5 AND LBL 30 IS CORRODED. REPAIRED BEAM PER SRM 53-00-51, FIG 203, PG 208.SDR CALA0600144Floorbeam · corrodedFWD ENTRY FLOORBEAM CORRODED STA 328. REPAIRED PER SRM 53-00-51, FIG 203.SDR CALA0600142Floorbeam · corrodedAFT ENTRY FLOORBEAM UPPER CHORD CORRODED AT STA 986.5 AND LBL 4 AND RBL 34. REPAIRED BEAM PER SRM 53-00-51 FIG 203, PG 208.SDR ASAA0640501Floorbeam · corrodedFOUND CORRODED FLOORBEAM. CUTOUT DAMAGED AREA AND INSTALLED REPAIR PER SRM 53 10 51.SDR DL757071121Floorbeam · corrodedDURING HMV AT YVR, THE STA 365 PASSENGER FLOORBEAM WAS FOUND CORRODED AT RBL 33.SDR DL757060392Floorbeam · corrodedTHE BS 365 FLOORBEAM WAS CORRODED ON THE UPPER CHORD AT RBL 33. REPAIR ANGLES WERE INSTALLED.SDR SWAA061401Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOOR BEAM ZEE CHORD CORRODED AT BS 270, RBL 12 TO LBL 12. R&R ZEE CHORD PER SRM.SDR SWIA200616993Floorbeam · crackedFORWARD SIDE OF AFT PRESSURE BULKHEAD STA 621 FLOORBEAM CRACK ON THE RIGHT SIDE, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED RT SIDE 621 FLOOR SUPPORT ANGLE PER REO 601R-RE-06557 SRM 51-42-06 PG 1-7; 51-42-21 PG 1-13. C/W REO 601R-53-61-117 REV 'A' AND SDR ASAA0640491Floorbeam · corrodedFOUND FLOORBEAM CORRODED. FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53 00 51SDR SWAA061360Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 43. REPAIRED FLOORBEAM PER SRM AND ER.SDR CA060422003Floorbeam · corroded(CAN) FLOORBEAM AT BS 986, LBL 18 TO LBL 52 CORRODED REPAIRED IAW CUSTOMER EA. (TC NR 20060422003)SDR CA060421032Floorbeam · corroded(CAN) FLOORBEAM AT BS 520 LBL 45 CORRODED AND REPAIRED IAW CUSTOMER EA. (TC NR 20060421032)SDR CA060421026Floorbeam · corroded(CAN) AFT CARGO PIT FLOORBEAM UPPER CHORD CORRODED AT BS 727B FROM LBL 25-45 AND REPAIRED IAW CUSTOMER EA. (TC NR 20060421026)SDR 0600956719Floorbeam · crackedDURING L-CHECK FOUND CRACK IN UPPER DECK FLOORBEAM FLANGE AT BS 240. REPAIRED PER EA 67-206225.SDR ASAA0640490Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPAIRED FLOORBEAM UPPER CHORD PER SRM 53 10 51 REPAIR 5.SDR USAA060604Floorbeam · corrodedFOUND FLOORBEAM CORRODED, TOP SIDE. REPLACED FLOORBEAM PER SRM 51-72-11L, CORROSION LEVEL 1; TASK JA-220-53500, DEFECT SIZE: 1" BY 1".SDR USAA060602Floorbeam · corrodedFOUND FLOORBEAM CORRODED 2 AREAS, AT Y 1292 LEFT FRAME 66 - 68. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-72-11; CORROSION LEVEL 2; TASK JA-260-53500, DEFECT SIZE: 1" DIAMETER AND 1" AND 2".SDR CA060421006Floorbeam · cracked(CAN) FLOORBEAM AT BS 767 LBL 24.5 CRACKED AND REPAIRED IAW CUSTOMER EA. (TC NR 20060421006)SDR CA060421002Floorbeam · corroded(CAN) FLOORBEAM CAP AT BS 967 LBL 18 CORRODED AND REPAIRED IAW CUSTOMER EA. (TC NR 20060421002)SDR CA060421001Floorbeam · corroded(CAN) FLOORBEAM CAP AT BS 947 LBL 39 CORRODED AND REPAIRED IAW CUSTOMER EA. (TC NR 20060421001)SDR EIA2006104Floorbeam · damagedFOUND BS 2020 RBL 120 FLOORBEAM UPPER TEE HAS ELONGATED HOLE. REMOVED DAMAGE, FABBED AND INSTALLED REPAIR PER B747 SRM 53-10-07 FIG 12.SDR 0600751236Floorbeam · corrodedDURING LINE CHECK DISCOVERED CORROSION ON FORWARD CARGO DOOR SCUFF PLATE. THE CORROSION HAS PUSHED UP THE FUSELAGE SKIN AND IT APPEARS THERE ARE CRACKS AND CORROSION ON THE FLOORBEAM. CURRENTLY ENGINEERING IS EVALUATING THE DAMAGE TO DETERMINE COURSE OF ACTISDR DUR42006415Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM BETWEEN R-1 AND L-1 DOORS BS 345. FABRICATED AND INSTALLED REPLACEMENT UPPER CAP 11 FEET BY 2" FROM BAC1505-100617 7075-T73 IAW B757 SRM 53-10-51 PG 217.SDR DU4R2006409Floorbeam · corrodedFOUND CORROSION ON FLOOR FRAME UPPER SURFACE, BS 700 INBD OF L2 DOOR AND UNDER CENTER FLOOR PANEL. CUT OUT CORRODED AREA. FABRICATED AND INSTALLED REPAIR DOUBLER 14-1/2" BY 1-1/4" FROM 2075-T6 .063 AND 13" BY 1" BY 1/2" FROM 7075-T6 .080 IAW B757 SRM 53-00-5SDR QXEA200601559Floorbeam · corrodedYYC - C3 FORWARD FUSELAGE UNDER FLOOR PANEL 132CE, STATION X116, FLOOR SUPPORT BEAM IS CORRODED UNDER ELECTRICAL CABLE TRAY, ABOVE RIGHT STRINGER 31. REPAIRED IAW DHC-8-400 SRM 51-21-00-350-801 AND 51-25-10-370-801.SDR CALA0600125Floorbeam · corrodedFLOORBEAM CORRODED AT BS 325, LBL 28 TO 56. REPAIRED IAW SRM 53-00-51, REPAIR 1, FIG 201.SDR SWAA061314Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986.5, BETWEEN BL 0 TO LBL 44. REPAIRED FLOORBEAM PER SWA EA.SDR AALA20060269Floorbeam · corrodedAFW - FLOORBEAM AT STATION 347 HAS CORROSION REMOVAL ON UPPER SURFACE. BLEND IS LOCATED AT STATION 347 AND RIGHT BUTTLINE 11 AND IS APPROXIMATELY ONE INCH IN DIAMETER AND 0,023 INCH DEEP. MATERIAL REMAINING IS WITHIN SRM LIMITS. VERIFIED THE CORROSION WAS CSDR DU4R2006418Floorbeam · corrodedFOUND CORROSION ON UPPER SURFACE OF FLOORBEAM AT BS 720 INBD OF L2 DOOR AND UNDER CENTER FLOOR PANEL. FABRICATED AND INSTALLED FLOORBEAM REPAIR 12.25" BY 1.75" BY .9" FROM 7075-T6 .080" AND 15.25" BY 1.8" BY 1" FROM 7075-T6 .063" IAW B757 SRM 53-30-51D FIG 20SDR 2006UALA00714Floorbeam · corrodedBS 947.5 FLOORBEAM CORRODED ON UPPER SURFACE AT RBL 28-36. REMOVED CORROSION, FABRICATED & INSTALLED NESTED ANGLES ON FWD & AFT SIDES OF UPPR CHORD REF MM 53-10-95 & SRM 51-20-01.SDR TRAX200600115Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM END AT FS 349 - BL45RT, RESOLVED ON W/O: 22159 TASKCARD: N/R-00209. REPAIRED CORROSION ON FLOORBEAM IAW REO601R-53-21-659 AND REO 601R-53-21-326 AND REO 601R-53-21-661.SDR CALA0600127Floorbeam · corrodedFLOORBEAM CORRODED AT BS 303, LBL 30 TO 35. REPAIRED BEAM IAW SRM 53-00-51, REPAIR 1, FIG 201.SDR SWAA061299Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986.5, BETWEEN BL 0 TO RBL 44. REPAIRED FLOORBEAM PER SWA EA & SRM.SDR ASAA0640456Floorbeam · corrodedFOUND FLOORBEAM CORRODED AROUND NUTPLATE HOLES. REMOVED COMPLETE UPPER TEE HORIZONTAL FLANGE FABRICATED AND INSTALLED UPPER TEE SPLICE ANGLES STRAPS FILLERS AND SHEAR TIES IAW ASA EA 5310 02615.SDR ASAA0640455Floorbeam · corrodedFOUND FLOORBEAM HAS CORROSION AROUND NUTPLATE HOLES. REMOVED COMPLETE UPPER TEE HORIZONTAL FLANGE FABRICATED AND INSTALLED UPPER TEE SPLICE ANGLES SPLICE STRAPS FILLERS AND SHEAR TIES PER ASA EA 5310 02615.SDR SWAA061286Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 328, BETWEEN RBL 40 TO RBL 60. REPAIRED FLOORBEAM PER SWA EA.
Back to JASC 5315