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 AWXA200300966Floorbeam · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF Y1162 FLOORBEAM FORWARD OF FR 68. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS, REMOVED CORRODED Y1162 FLOORBEAM FROM FR 68 TO FR 69; FABRICATED A NEW REPLACEMENT FSDR AWXA200300961Floorbeam · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON PANEL MOUNTING HOLE OF FLOORBEAM Y1792, AFT OF FR 66, INBOARD OF L-2 DOOR FORWARD GIRT BAR MOUNTING BLOCK. MAINTENANCE ENLARGED MOUNTING HOLE TO MAXIMUM ALLOWABLE DIAMETER, CORROSION STILL PRESENT; CUTOUT DAMAGSDR AWXA200300959Floorbeam · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF Y1162 FLOORBEAM AT FR 68. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SECTION OF Y1162 FLOORBEAM FROM FR 68 TO FR 69; FABRICATED A NEW REPLACEMENTSDR AWXA200300952Floorbeam · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM Y765 AT FR 16. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED DAMAGED SECTION OF FLOORBEAM Y765 AT FR 16; FABRICATED A NEW SECTION OF BEAM AND SDR AWXA200300951Floorbeam · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF RT OUTBOARD FLOOR SHEAR PLATE WEB BETWEEN FR 69 AND FR 70, AFT OF FLOORBEAM Y1792. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED SHEAR PLATE WEB BETWEEN FR SDR AWXA200300943Floorbeam · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON UPPER SURFACE OF Y1292 FLOORBEAM AT FR 16. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT DAMAGED SECTION OF FLOORBEAM FR 16 TO FR 18; FABRICATED A NEW SECTION OF FLOORBEASDR AWXA200300934Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND AT AFT ENDS OF AFT CABIN FLOORBEAM Y1162, FR 68 TO FR 69. MAINTENANCE REMOVED FLOORBEAM FROM FR 68 TO FR 69; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42SDR AWXA200300923Floorbeam · corrodedDURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND AROUND FASTENER HOLES OF AFT CABIN FLOORBEAM Y1292 L/H, FR 66 TO 68. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED AFT CABIN FLOORBEAM FROM FR 66-68, Y1292 L/H; FABRICATED ASDR SWAA031758Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CRACKED AT BS 947.5, WL 208 AND LBL 53. REPAIRED FLOORBEAM PER BFG ER.SDR C1HA200381016Floorbeam · corrodedCORROSION ON TOP OF FS 1030 FLOORBEAM BETWEEN LBL 22 AND RBL 22.SDR AWXA200300922Floorbeam · corrodedDURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON MAIN CABIN FLOORBEAM AFT OF FR 64, Y1292. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED MAIN CABIN FLOORBEAM FROM FR 66-67, Y1292; FABRICATED A NEW REPLACEMENT SECTION OFSDR C2XA03SH258Floorbeam · corrodedDURING C-CHECK, THE CENTER FLOORBEAM BETWEEN FRAMES 24 AND 25 FROM FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-22-10 FIGURE 201 SHEET 2. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH257Floorbeam · corrodedDURING C-CHECK, THE LT FLOORBEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 202 SHEET 1. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH252Floorbeam · corrodedSHV-DURING C CHECK THE CENTER OMEGA BEAM AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2003UALA00605Floorbeam · crackedAFT CABIN BS 941.5 RBL 45.5 HAS FLOORBEAM CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW PARTS.SDR C2XA03TY105Floorbeam · corrodedDURING A SCHEDULED 3C INSPECTION, THE LEFT HAND GALLEY FLOORBEAM WAS CORRODED AND PREVIOUS REPAIR WAS CORRODED. MAINTENANCE REMOVED THE OLD REPAIR, FAB FILLER AND ANGLE, ALODINED AND PRIMED NEW FAB PART. INSTALLED NEW PARTS IAW EMB 135/145 SRM 53-21-04, 05, SDR C2XA03TY103Floorbeam · corrodedTYS DURING A SCHEDULED 3C INSPECTION THE CENTER FLOORBEAM WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM IAW EMB135/145 SRM 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE REL UPON COMPLETION OF ALL WORK.SDR SWIA200312319Support Angle · crackedFS 621 LT FLOOR SUPPORT ANGLE LBL 42 CRACKED. (DISCOVERED DURING C-CHECK) ANGLE REPAIRED IAW CRJ REO 601R5361117 REV. ''A''. REF. RII 53-401.SDR C2XA03SH249Floorbeam · corrodedDURING C-CHECK, THE CENTER FLOORBEAM WAS FOUND TO HAVE CORROSION AT FRAME 20. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA03SH241Floorbeam · corrodedSHV- DURING C-CHECK, THE CENTER FLOORBEAM RAMP ANGLE WAS FOUND TO HAVE CORROSION AT FRAME 20. MAINTENANCE REMOVED AND REPLACED AFFECTED ANGLE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR SIMA200321809Floorbeam · corrodedABI - DURING AN MBV INSPECTION, THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT DAMAGE SECTION OF LEFT OMEGA BEAM. FABRICATED AN EXTERNAL ANGLE, FILLER AND TWO SHIMS. REPAIR DONE IAW EMB SRM, SRM 145/1142, REV 22, CHAPTER 5SDR C2XA03SH238Floorbeam · corrodedSHV- DURING C CHECK THE CENTER OMEGA BEAM IN GALLEY WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED AND REPLACED AFFECTED OMEGA BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR ASOA03344Floorbeam · corrodedDURING A C-CHECK IN MCN, THE FLOORBEAMS AT FS 349 ON THE RIGHT INBOARD AND OUTBOARD SIDES WRE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE FLOORBEAMS AT FS 349 ON THE RIGHT INBOARD AND OUTBOARD SIDES IAW ASA EO 600-53-0052. (SDR 03FDEA01157Floorbeam · bulgedPLATE ON 25G BEAM UNDER FE'S SEAT BULGED. ACCESSED FLOOR PANELS; REMOVED 25G BEAM; REPLACED WITH NEW PART; PER SRM 51-30- 2; REINSTALLED ACCESSED GROUP.SDR C2XA03SH237Floorbeam · corrodedSHV- DURING C-CHECK, THE LT FLOORBEAM AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 201 SHEET 2. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SIMA200321005Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE LEFT OMEGA BEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT THE DAMAGED AREA AND PERFORMED AN NDT INSPECTION. FABRICATED A FILLER, EXTERNAL ANGLE AND SHIMS. REPAIR DONE IAW EMB 145 SRM, SRSDR C2XA03TY097Floorbeam · corrodedTYS- DURING A SCHEDULED 2C INSPECTION THE LT AND RT AISLE OMEGA BEAM AT THE SECOND CARBON CROSS BAR WAS FOUND CORRODED. MAINTENANCE CUT OUT DAMAGED SECTIONS ON LT AND RT FLOORBEAM, FAB EXTERNAL ANGLE SHIM AND FILLER ALODINED, PRIMED, PAINTED AND INSTALLED FA SDR ASAA0340325Floorbeam · corrodedOAK - DURING C-CHECK, FOUND FLOORBEAM AT STATION 947 CORRODED. REPAIRED IAW SRM. (M)SDR SIMA200321002Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUTOUT THE DAMAGED AREA OF LEFT OMEGA BEAM AND PERFORMED NDT INSPECTION. FABRICATED AN EXTERNAL DOUBLER, FILLER, PLATE AND TWO SHIMS. REPAIR DONE IAWSDR AWXA200300905Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOOR BEAM AT BS 858, RBL 5. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT FLOOR BEAM BS 858, RBL 5; FABRICATED 2 EACH REPAIR ANSDR AWXA200300904Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOOR BEAM AT BS 858, RBL 15. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT FLOOR BEAM BS 858, RBL 15; FABRICATED 2 EACH REPAIR SDR AWXA200300887Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOORBEAM AT BS 770, RBL 5. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT CORRODED AREA OF AFT CARGO COMPARTMENT FLOORBEAM ASDR AWXA200300886Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON AFT CARGO COMPARTMENT FLOORBEAM AT BS 770, RBL 10. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT CORRODED AREA OF AFT CARGO COMPARTMENT FLOORBEAM SDR SIMA200321006Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE FORWARD DIGITAL BETWEEN FRAMES 16 AND 18 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUTOUT A 16 INCH BY 21 INCH SECTION OF DAMAGED FORWARD DIGITAL. PREPARED A SECTION OF DIGITAL MATERIAL. FABRICATED SHIM AND TWO DOUBLERSSDR EIA2003095Floorbeam · damagedUPPER DECK FLOORBEAM HAS MISSING FASTENERS AND WEB IS TORN AND GOUGED AT BS 440 RBL 32. FABRICATED REPAIR PER ECRA 485-53-145-2.SDR SIMA200321004Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE FORWARD DIGITAL WAS FOUND TO BE CORRODED BELOW SRM LIMITS. BLENDED THE CORRODED AREA AND PERFORMED NDT INSPECTION. APPLIED TREATMENT TO THE BARE METAL SURFACE. FABRICATED A REPAIR DOUBLER, REPAIR DONE IAW EMB REPAIR STATSDR 2003UALA00589Floorbeam · bentFORWARD CARGO FLOORBEAM AT STA 640 LBL 40 TOP CHORD BENT. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM CHORD.SDR 2003UALA00588Floorbeam · bentFLOORBEAM UPPER FLANGE IS BENT AT BL 0 AND BS 1800. MAJOR REPAIR ACCOMPLISHED. REPLACED UPPER CHORD.SDR C2XA03TY091Floorbeam · corrodedTYS, DURING A SCHEDULED INSPECTION THE RIGHT CENTER FLOORBEAM WAS FOUND CORRODED UNDER THE AFT WALL COMPOSIT FLOOR SUPPORT. MAINTENANCE REMOVED AND REPLACED THE CENTER LAV FLOORBEAM CAP. I/A/W-EMB-145-SRM-51-40-02, THE REPAIR WAS SATISFACTORY AND THE AIRCRAFT SDR SIMA200320802Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, CORROSION FOUND ON THE LEFT OMEGA BEAM AT FRAME 20. COMPLETELY REMOVED CORROSION BY CREATIN A CUTOUT. FABRICATED AN EXTERNAL ANGLE, FILLER AND A PLATE. REPAIR DONE IAW EMB 145 SRM, 145-1142 REV 22, 53-21-10 PARA 2 FIG 201 SHSDR SWAA031652Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AT BS 660, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR 03FDEA01224Floorbeam · chafedBS 740 FLOORBEAM UPPER CHORD CHAFED ALONG AFT EDGE LBL 44 RBL 44 WL 208. R/R FLOORBEAM.SDR ARWA20030708Floorbeam · corrodedDURING A-CHECK INSPECTION, THE FOLLOWING WAS FOUND; AFT ACCESSORY COMPARTMENT STATION 1520, RBL 32 FLOORBEAM UPPER FLANGE WITH CORROSION. REPAIRED FUSELAGE FLOORBEAM UPPER AFT FLANGE AT STATION 1520 RBL 32 IAW AVITAS ENGINEERING ORDER AROW-034RO-1, PAGES 1 TOSDR CALA0300424Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED UNDER LAV-A AT STA 294.5, LBL 24.67. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 51-10-51 AND ECRA 5311-01159.SDR SWAA031613Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 312, WL 208 AND LBL 11 TO RBL 11. REPAIRED FLOORBEAM PER SRM.SDR GAIA03038SPSplice · crackedDURING C-CHECK, FOUND MAIN CARGO DOOR DECK BS 640, FLOORBEAM SPLICE PLATE CRACKED FROM SLOT RADIUS FASI N/R 35932. REMOVED AND REPLACED FLOORBEAM SPLICE PLATE P/N AE727-1-42-11, PO NR 319397 IAW STC AE179850 DTD 4-7-93. (M)SDR GAIA03037SPSplice · crackedDURING C-CHECK, FOUND MAIN CARGO DECK BS 600, FLOORBEAM SPLICE PLATE CRACKED AT SLOT RADIUS FASI N/R 35931. REMOVED AND REPLACED FLOORBEAM SPLICE PLATE P/N AE727-1-42-11, PO NR 319397 IAW STC AE 179850 DTD 4-7-93. (M)SDR GAIA03036SPFloorbeam · crackedDURING C-CHECK, FOUND MAIN CARGO DECK BS 580, FLOORBEAM SPLICE PLATE CRACKED AT SLOT RADIUS, FASI N/R 35930. REMOVED AND REPLACED SPLICE PLATE P/N AE 727-1-42-11, PO NR 319397 IAW STC AE 179850-DTD 4-7-93. (M)SDR SIMA200321807Floorbeam · corrodedABI - DURING AN MBV INSPECTION, THE LEFT OMEGA BEAM AT FRAME 25 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. REMOVED NUT PLATE FROM ATTACHED AREA. COMPLETELY REMOVED CORROSION BY BLENDING. PERFORMED EDDY CURRENT INSPECTION OF BLENDED AREA WITH NO DEFECTS NOTESDR SWIA200312294Floorbeam · crackedFS 589 + 605 TRANVERSE BEAM ANGLES LBL 42 CRACKED. DISCOVERED DURING C-CHECK, REPLACED ANGLES IAW CRJ SRM 51-40-11. P/N: 601R-35011-13
Back to JASC 5315