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 C2XA04SH195Buttstrap · corrodedSHV- DURING C-CHECK THE LEFT HAND FLOORBEAM BUTTSTRAP WAS FOUND TO BE CORRODED AT FRAME 59. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH194Buttstrap · corrodedSHV- DURING C-CHECK THE CENTER FLOORBEAM BUTTSTRAP WAS FOUND TO BE CORRODED AT FRAME 59. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH193Buttstrap · corrodedSHV- DURING C-CHECK THE RIGHT HAND FLOORBEAM BUTTSTRAP WAS FOUND TO BE CORRODED AT FRAME 59. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA0410259Floorbeam · corrodedPAE - FOUND CORROSION AFT CARGO BAY MAIN CABIN FLOORBEAM REPAIR STRAP LOWER FLANGE. REMOVED CORRODED REPAIR STRAP ON FLOORBAM LOWER FLANGE, FABRICATED REPAIR STRAP AND INSTALLED. (M)SDR AWXA200400408Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A 4 INCH CRACK WAS FOUND IN UPPER SURFACE OF CABIN FLOORBEAM UPPER CHORD AT BS 660, BL 0.07. MAINTENANCE REMOVED DAMAGED SECTION OF UPPER TEE BS 660, LBL 0.07; FABRICATED 2 EACH REPAIR STRAPS & SPLICE ANGLES; INSTALLED RESDR ASAA0440097Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM UPPER T-CAP STATION 360 HAS NUMEROUS AREAS OF CORROSION ON UPPER SURFACE. REPAIRED FLOORBEAM. (M)SDR ASAA0440096Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM STATION 294.5 HAS CORROSION FROM LBL 12 TO RBL 50. REPAIRED FLOORBEAM T-CAP CHORD. (M)SDR ASAA0440093Floorbeam · corrodedGYR - FOUND MAIN DECK FLOORBEAM AT FS 294.5 APPROX LBL 12 TO RBL 50, UPPER T-CAP HAS SEVERAL AREAS OF CORROSION ON UPPER SURFACE. BLENDED CORROSION CK OUT OF LIMITS. REMOVED 'T' AND FABRICATED NEW 'T' AND INSTALLED 'T' AND REPAIR ANGLE PER SRM 53-10-51. (M)SDR AWXA200400391Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-15 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF UPPER TEE AT BS 986, RBL 10 TO RBL 19, WL 208. MAINTENANCE CUTOUT DAMAGED SECTION OF UPPER TEE AT BS 986, RBL 10 TO RBL 19, WL 208; FABRICATED A NEW REPLACEMENT SECTION OF SDR AWXA200400390Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-15 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF UPPER TEE AT BS 986, BL "0" TO RBL 9.5, WL 208. MAINTENANCE CUTOUT DAMAGED SECTION OF UPPER TEE AT BS 986, BL "0" TO RBL 9.5, WL 208; FABRICATED A NEW REPLACEMENT SECTION OSDR SWAA040971Floorbeam · corrodedDURING SCHEDULED C1 CHECK, FOUND FLOORBEAM WEB AT BS 967, LBL 5, WL 208, CORRODED. REPAIRED WEB PER SRM.SDR CALA0400311Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 378, RBL 10. REPAIRED IAW ECRA 5320-01747.SDR CALA0400310Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER SURFACE CORRODED AT BS 700, LBL 58.2. REPAIRED IAW ECRA 5320-01746.SDR CALA0400309Floorbeam · corrodedINSPECTION FOUND TOP SURFACE OF FLOORBEAM CORRODED AROUND FASTENER HOLES AT BS 1640, BL 0 TO LBL 24.5. REPAIRED IAW ECRA 5320-01749.SDR CALA0400308Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON UPPER SURFACE AT BS 680, RBL 16 TO LBL 16. REPAIRED FLOORBEAM IAW SRM 53-00-51, FIGURE 203.SDR USAA040090Floorbeam · corrodedBFM - FOUND BEAM CORRODED 1 INCH BY 1 INCH BY .039 INCH DEEP, FRAME 68, Y1162, -Z240. REMOVED AND REPLACED BEAM PER SRM 51-74-00, 53-00-14, 51-42-11. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)SDR USAA040088Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH BY .02 AND .03, TWO AREAS, FS 66-68, Y1292, -Z240. REMOVED AND REPLACED FLOORBEAM PER SRM 53-00-14, 51-74-00 AND 51-42-11. REMOVED AND REPLACED BEAM PER SRM 53-00-14, 51-74-00 AND 51-42-11. CORROSION LEVEL 2, SDR USAA040087Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH BY .048D AREA, FRAME 68 Y 1292 -Z240. REMOVED AND REPLACED FLOORBEAM PER SRM 51-74-00, 53-00-14 AND 51-42-11. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)SDR SWAA040940Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL BEAM WEBS AT BS 709, RBL 25, BS 706, BL 0, CRACKED. REMOVED AND REPLACED WEB SECTIONS PER SRM.SDR USAA040083Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 3 INCHES BY 1 INCH BY .050 INCH AREA, FRAME 68-69, -Y1210, -Z2240. REMOVED AND REPLACED FLOORBEAM PER SRM 53-00-14, 51-74-00, 51-42-11. CORROSION LEVEL 2, TASK NR JA-260-53500. (M)SDR C2XA04SH190Floorbeam · corrodedSHV- DURING C-CHECK THE LEFT HAND OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A FILLER/SHIM REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR USAA040080Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 1 INCH IN DIAMETER BY .030 INCH DEEP, LAV E MOUNTHOLE, -Y720, 10 INCHES AFT OF FRAME 64 ON BEAM ASSEMBLY. REMOVED AND REPLACED FLOORBEAM PER SRM 53-00-14, 51-42-11. (M)SDR AWXA200400421Floorbeam · corrodedDURING C-8 CHECK STRESS CORROSION WAS FOUND ON FLOORBEAM Y765 LT AT FR 16. MAINTENANCE REMOVED CORRODED FLOORBEAM Y765 LT, FROM FR 12 TO FR 24, INSTALLED NEW REPLACEMENT FLOORBEAM IAW A320 SRM 51-42-11, FIG. 12 & 18.SDR AWXA200400420Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y1292 RT BETWEEN FR 68 AND FR 69. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 R/H FROM FR 68 TO FR 69; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRSDR USAA040069Floorbeam · wornFOUND FLOORBEAMBEAM WORN 1 INCH BY 1 INCH BY .070 INCH, FRAME 66 Y-254, -Z240. REMOVED AND REPLACED BEAM PER SRM 53-00-14, 51-42-11. (M)SDR AWXA200400418Floorbeam · corrodedDURING C-8 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y765 RT BETWEEN FR 66 AND FR 70. MAINTENANCE REMOVED CORRODED FLOORBEAM Y765 RT FROM FR 66 TO FR 70; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42-11, FIG. 8, 12, SDR AWXA200400415Floorbeam · corrodedDURING C-8 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y1292 L/H, FORWARD OF FR 68. MAINTENANCE CUTOUT CORRODED SECTION OF L-2 DOOR SILL FLOORBEAM Y1292 LT FROM FR 67 TO FR 69; PERFORMED HFEC INSPECTION OF CUTOUT; FABRICATED AN ANGLE AND SHIM; INSTALLEDSDR AWXA200400413Floorbeam · corrodedDURING C-8 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y765 RT AT FR 66. MAINTENANCE REMOVED CORRODED BEAM Y765 RT FROM FR 64 TO FR 66; FABRICATED A NEW REPLACEMENT FLOORBEAM PER DWG D53472-190; INSTALLED REPAIR PART IAW A320 SRM 51-42-11, FIG. 12.SDR AWXA200400412Floorbeam · corrodedDURING C-8 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y254 RT BETWEEN FR 68 AND FR 70. MAINTENANCE REMOVED CORRODED FLOORBEAM Y254 RT FROM FR 68 TO FR 70; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42-11, FIG. 12 & 18SDR AWXA200400403Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-8 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y765 LT BETWEEN FR 68 AND FR 69. MAINTENANCE REMOVED DAMAGED SECTION OF FLOORBEAM Y765 L/H FROM FR 66 AND FR 70; FABRICATED A NEW REPLACEMENT SECTION OF FLOORBEAM; INSTALLED REPSDR AWXA200400371Floorbeam · corrodedDURING C-08 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y1292 RIGHT, FORWARD OF FR 68. MAINTENANCE REMOVED CORRODED BEAM Y1292 RIGHT FROM FR 66 TO FR 68; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42-11, FIG 9, PG 6-7SDR C2XA04TY059Floorbeam · corrodedTYS DURING A SCHEDULED 1C INSPECTION THE LT FLOORBEAM WAS FOUND CORRODED AT FR 20. MAINT CUT OUT THE EFFECTED AREA, FAB DRILLED AND COUNTERSUNK A NEW REPAIR PART, ALODINED, PRIMED, PAINTED AND INSTALL THE NEW PART IAW EMB 135/145 SRM 53-21-10; 51-20-03-06 ANSDR C2XA04TY057Floorbeam · corrodedTYS DURING A SCHEDULED 2C INSPECTION THE LEFT FLOORBEAM CAP HAD AREAS OF CORROSION AT FR 19-23. MAINT REMOVED AND REPLACED THE LEFT FLOORBEAM TOP CAP IAW EMB 135/145 SRM 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE RELEASED UPON COMPLETION OF ALL WORK.SDR SWAA040911Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAMS AT BS 312, BS 344, BS BS 986, LBL 65 TO RBL 42 CORRODED. REPAIRED FLOORBEAM SECTIONS PER SRM AND ER.SDR ASAA0410183Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND AFT PIT STATION 947 CABIN FLOORBEAM CORRODED ALONG TOP T-CHORD. REPAIR IAW EA. (M)SDR ASAA0410175Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND FLOORBEAM CORRODED AT STATION 747. REPAIR IAW SRM. (M)SDR ASAA0410174Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND AFT CARGO PIT CABIN FLOORBEAM LOWER CHORD CORRODED AT STATION 767. REPAIR IAW EA. (M)SDR ASAA0410173Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND CORROSION ON UPPER CHORD BEAM AFT FLANGE AT STATION 947. REPAIR IAW EA. (M)SDR ASAA0410172Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND FORWARD PIT CABIN FLOORBEAM LOWER AREA AT STATION 480 CORRODED. REPAIR IAW EA. (M)SDR ASAA0410171Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND AFT PIT AT STATION 947 FLOORBEAM CORRODED AT BOTTOM T-CHORD. REPAIR IAW EA. (M)SDR ASAA0410170Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND AFT PIT CABIN FLOORBEAM LOWER T-CHORD IS CORRODED. REPAIR IAW EA. (M)SDR ASAA0410169Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND CORROSION AFT CARGO PIT STATION 887 LOWER FLOORBEAM AT CLIP NUTS. REPAIR IAW EA. (M)SDR ASAA0410166Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND CORRODED T-CHORD AT STATION 867. REPAIR IAW EA. (M)SDR ASAA0410165Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND FLOORBEAM UPPER CHORD CORRODED AT STATION 807. REPAIR IAW EA. (M)SDR ASAA0410161Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND CORROSION ON FLOORBEAM AT STATION 500A. REPAIR IAW EA. (M)SDR GTIA040312Floorbeam · crackedFTW - FOUND FLOOR SUPPORT CRACKED AT FS 905 36 INCHES LBL. REMOVED CRACKED FLOOR SUPPORT. LOCATED AND DRILLED NEW FLOOR SUPPORT. INSTALLED FLOOR SUPPORT. (M)SDR GAIA04060STFloorbeam · corrodedDURING C-CHECK, FOUND CORROSION ON THE FLOORBEAM AT FS 1130 RIGHT SIDE LOWER CHORD. INSTALLED REPAIR IAW BOEING 727 SRM 53-10-8. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR AALA20040413Floorbeam · crackedTUL - LEFT HAND GANTRY BEAM NUMBER 4 AT FRAME 52 IS CRACKED. INSTALLED REPAIR FITTING PER ESO 30595 DATED 3-25-2004 FOR LEFT HAND GANTRY BEAM NUMBER 4 AT FRAME 52.SDR AALA20040415Floorbeam · crackedTUL - LEFT HAND GANTRY BEAM NUMBER 4 AT FRAME 52.1 CRACKED. INSTALLED REPAIR FITTING PER ESO 30595 DATED 3/25/04 FOR LEFT HAND GANTRY BEAM NUMBER 4 AT FRAME 52.1.SDR CALA0400288Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FASTENER HOLE, BS 377.7, LBL 58, WBL 208.10. REPAIRED IAW SRM 53-00-51.
Back to JASC 5315