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 SWIA200514499Floorbeam · crackedFS 621 FLOOR SUPPORT ANGLE LBL 42 CRACKED. ITEM FOUND AT C-CHECK INSPECTION. FLOOR SUPPORT ANGLE REPAIRED IAW CRJ REO 601R-53-61-117 REV B.SDR QXEA200500395Floorbeam · corrodedYYC - CENTER FLOORBEAM AT STATION X32.000 DOUBLER JOINT AND RIVETS CORRODED. REPAIRED IAW Q400 SRM TASK 51-21-00-350-001, 51-21-10-380-001 AND 51-25-10-370-001.SDR AWXA200500313Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 344, BETWEEN RBL 12 AND LBL 50. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM UPPER CHORD AT BS 344, FROM RBL 12 TO LBL 50; FABRICATED A NSDR AWXA200500256Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 328, BETWEEN LBL 29 AND RBL 32, WL 208. MAINTENANCE CUT OUT DAMAGE IN FLOORBEAM UPPER CHORD AT BS 328, FROM LBL 35 TO RBL 67; FABRICATED A NEWSDR AWXA200500254Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK CORROSION WAS FOUND ON UPPER AND LOWER SURFACE OF FLOORBEAM UPPER CHORD AT BS 312, BETWEEN LBL 9 AND RBL 36, WL 208. MAINTENANCE CUT OUT DAMAGE IN FLOORBEAM UPPER CHORD AT BS 312, FROM LBL 9 TO RBL 36; FABRICATED A NEW RSDR SWIA200514475Floorbeam · crackedFS 280 RT FLOORBEAM RLB 9.0 OUTBOARD ATTACH ANGLE CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-23-00, 51-42-21, 51-21-11.SDR 05FDEA00146Floorbeam · corrodedSTA 340, FLOORBEAM HAS DENT & CORROSION IN DIFFERENT AREAS. REMOVED DAMAGED AREA & REPAIR PARTS IAW SRM 51-30-2. FABRICATED NEW T-CAP FROM 60- 893/18 BATCH 833835 & REPAIR SPLICES FROM 60-3408/18 BATCH 812526 & 7075-T6 .063C BATCH 784273 IAW SR 27-53-007. SDR SWIA200514710Floorbeam · crackedANGLE CRACKED AT FS 280 LBL 9 INBOARD SIDE OF FLOORBEAM. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED ANGLE PER CRJ/200 SRM 51-42-21 AND 51-42-06.SDR SWIA200514709Floorbeam · crackedTWO ANGLES CRACKED FS 280 RBL 9 (INBOARD AND OUTBOARD SIDE OF FLOORBEAM). INSTALLED ANGLES PER CRJ 200 SRM 51-42-21 AND 51-42-06.SDR SWIA200514707Floorbeam · crackedRIGHT SIDE FS 621.00 CRACKED. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED REPAIR ANGLES IAW REO 601R-53-61-117 REV B.SDR SWIA200514706Floorbeam · crackedLEFT SIDE FS 621.00 CRACKED. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED REPAIR PARTS IAW REO 601R-53-61-117 REV B.SDR 05FDEA00135Floorbeam · damagedREPAIR ON FLOORBEAM UPPER CORD BS 344, WL 208, LBL 20.5 TO RBL 70, 90.5 INCHES LONG NEEDS EVALUATION TO DETERMINE PER SRM OR APPROVED DATA . REMOVED AND REPLACED FLOORBEAM UPPER CHORD BS 344, WL 208, LBL 65 TO RBL 65 IAW SRM 51-30-2 & 53-10-8SDR CALA0500018Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND SCREW HOLE AT STA 986, LBL 44, L17L. REPAIRED IAW SRM 53-60-51.SDR CALA0500017Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 180, LBL 12 TO LBL 37. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-3 AND 51-30-2.SDR QXEA200500169Floorbeam · corrodedYYC - FUSELAGE STATION 280 RIGHT FLOORBEAM IS CORRODED ALONG TOP FLANGE FROM BL-0 TO RBL40. REPAIRED IAW REO 670-53-11-047.SDR QXEA200500168Floorbeam · corrodedYYC - FUSELAGE STATION 280 LEFTHAND SIDE FLOORBEAM ASSEMBLY IS CORRODED ALONG TOP FLANGE FROM BL-0 TO LBL 40. REPLACED IAW REO 670-53-11-047.SDR SWAA050151Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM WEB AT BS 246, RBL 9, CORRODED. REMOVED AND REPLACED FLOORBEAM WEB PER ER.SDR 0500075523Floorbeam · corrodedDURING H-CHECK, FOUND CORROSION ON FLOORBEAM AT BS 365 RBL 1 TO RBL 62. REPAIRED PER EA 55-202245.SDR 2005UALA00075Floorbeam · corrodedSTA 294 FLOORBEAM UPPER CAP HAS MATERIAL LOSS FROM CORROSION REMOVAL AT RBL 39 TO RBL 52. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. CUTOUT DAMAGED SECTION AND INSTALLED DOUBLE FLANGE REPAIR.SDR SWAA050145Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM AT BS 772, LBL 8, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER EA.SDR GTIA050047Floorbeam · corrodedAFT PIT FS 1338 APB FWD SIDE LOTER T-CHORD CORRODED L28L TO L28R. REMOVED CORROSION OUT OF LIMITS, REMOVED T-CAP (CHORD) STA 1338, L28L TO L29L, DRILLED AND LOCATED NEW T-CAP STA 1338. OK TO TOP COAT AND INSTALL NEW T-CAP. (K)SDR 05FDEA00119Floorbeam · damagedFLOORBEAM DAMAGE FR65 / Y1456.SDR CALA0500013Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND SCREW HOLES AT STA 986, RBL 3 TO RBL 12. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51.SDR RYNA200500002Floorbeam · corrodedMAIN CABIN FLOOR BEAM, UPPER CHORD, UPPER SURFACE CORRODED AT BS 1006, LBL 29. REMOVED CORROSION ON FLOOR BEAM, FABRICATED, TREATED AND INSTALLED REPAIR PARTS.SDR 2005UALA00073Floorbeam · corrodedSTA 986 FLOORBEAM FWD FLANGE HAS CORROSION FROM RBL 16 TO RBL 41. DATA MAJOR CUT-OUT DAMAGE AND INSTALLED REPAIR ANGLE AND FILLER.SDR GTIA050033Floorbeam · gougedFTW - FOUND MID PIT STATION 655 CEIING RBL 2 FLOORBEAM GOUGED. FABRICATED FILLER, ANGLE AND SHIM. TREATED, PRIMED AND INSTALLED. (M)SDR 2005UALA00072Floorbeam · corrodedFLOORBEAM AT STATION 947 HAS CORROSION FROM LBL 14 TO RBL 53. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. SPLICED IN NEW SECTION OF FLOOR BEAM.SDR 2005UALA00063Floorbeam · corrodedFLOORBEAM CORRODED ON AFT FLANGE STA 986 FROM RBL 10 TO LBL 6. SUPPLEMENTAL DATA UPDATE, MAJOR REPAIR ACCOMPLISHED. CUT-OUT DAMAGE AND INSTALLED REPAIR ANGLE AND FILLER.SDR CALA0500007Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND SCREW HOLES AT STA 986.5, RBL 29. REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR SIMA200501911Floorbeam · corrodedDURING CPCP INSPECTION MAINTENANCE FOUND THE FORWARD CABIN FLOORBEAM HAT SECTION HAS CORROSION THROUGH TOP IB EDGE AT FR 20 IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR SIMA200501910Floorbeam · corrodedDURING CPCP INSPECTION MAINTENANCE FOUND THE FORWARD CABIN FLOOR DIGITAL HAS CORROSION IN SEVERAL AREAS OF UPPER SURFACE. MAINTENANCE REMOVED AND REPLACED THE FLOOR DIGITAL IAW SRM. AIRCRAFT RETURNED TO SERVICE. (SW21200502486) (K)SDR 2005UALA00056Floorbeam · corrodedSTA 947 FLOORBEAM HAS MATERIAL LOSS FROM CORROSION AT LBL 4. REMOVED CORROSION INTALLED REPAIR STRAP.SDR USAA050146Floorbeam · corrodedBFM - FOUND BEAM ASSEMBLY CORRODED, 1 INCH LONG BY .750 INCH WIDE BY .065 INCH DEEP, MAIN CABIN, L-4 DOOR SILL AT Y+1915, Y-1912, 27 CM FORWARD OF FRAME 74. REMOVED AND REPLACED BEAM ASSEMBLY ASSY PER SRM 51-74-00, 51-23-11, 51-42-11, 51-44-11. (M)SDR USAA050214Floorbeam · corrodedPIT - FOUND BEAM CORRODED 2 INCH BY 100 INCH AREA, BS 986.5 FLOORBEAM ENTIRE UPPER SURFACE. SPLICED IN NEW UPPER CAP PER TYPICAL REPAIR 53-60-01 REV A. (M)SDR ASOA05087Floorbeam · corrodedDURING A C-CHECK, THE FLOORBEAMS AT FR 36, 38 AND 39 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS AT FR 36, 38 AND 39 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS AT FR 3SDR AWXA200500084Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK INTERGRANULAR CORROSION WAS FOUND ON LONGITUDINAL FLOORBEAM -Y189 BETWEEN FR 20 AND FR 21. MAINTENANCE REMOVED CORRODED LONGITUDINAL FLOORBEAM -Y189 FROM FR 20 TO FR 21; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED SDR SIMA200501906Floorbeam · corrodedDURING AN IMBV INSPECTION, A PREVIOUS REPAIR ON FORWARD DIGITAL WAS FOUND TO BE CORRODED. REMOVED THE EXISTING DAMAGED REPAIR. FABRICATED 2 DOUBLERS, AND FILLER. REPAIR DONE IAW SRM. (SW21200502482) (K)SDR USAA050142Floorbeam · corrodedBFM - FOUND BEAM ASSEMBLY CORRODED 1 INCH BY .5 INCH BY .012 INCH, FRAME 75.9, -Y1910 MAIN CABIN FLOOR. REMOVED AND REPLACED BEAM PER SRM 51-72-00. (M)SDR AWXA200500088Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOORBEAM Y1292 AT FR 66. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 AT FR 66; FABRICATED A NEW REPLACEMENT FLOORBEAM PER DWG D53472040; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200500086Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM -Y1292 BETWEEN FR 66 AND FR 68. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y1292 FROM FR 66 TO FR 68; FABRICATED A NEW REPLACEMENT FLOORBEAM PER DWG D53472800; INSTALLED REPAIR PARTSDR AWXA200500063Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1732 LT BETWEEN FR 65 AND FR 66. MAINTENANCE REMOVED CORRODED BEAM Y1732 LT FROM FR 65 TO FR 66; FABRICATED A NEW REPLACEMENT BEAM PER DWG D53474250; INSTALLED REPAIR PART IAW A32SDR AWXA200500053Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-4 CHECK GALVANIC CORROSION WAS FOUND ON FLOOR BEAM Y1292 LT, BETWEEN FS 66 AND FS 68. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 LT FROM FS 66 TO FS 68; FABRICATED A NEW REPLACEMENT FLOORBEAM INSTALLED REPAIR PART IAW A320 SRM SDR AWXA200500052Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-4 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM Y1292 LT, BETWEEN FS 68 AND FS 69. MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 LT FROM FS 68 TO FS 69; FABRICATED A NEW REPLACEMENT FLOORBEAM INSTALLED REPAIR PART IAW A320 SRM 5SDR SWAA050069Bracket · crackedDURING SCHEDULED 1/4D CHECK, FOUND SUPPORT BRACKETS AT BS 616, LBL 64 AND RBL 64, CRACKED. REPAIRED BRACKETS PER SRM T1-153-018.SDR AWXA200500044Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM Y920 AT FR 66 + 4". MAINTENANCE REMOVED DAMAGED FLOORBEAM Y920 FROM FS 66 TO FS 70; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200500042Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON FLOORBEAM Y510 AT FS 66 - 2 IN. MAINTENANCE REMOVED DAMAGED FLOORBEAM Y510 AT FS 66 - 2; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR 2005UALA00045Floorbeam · corrodedMAIN CABIN, RIGHT SIDE FLOORBEAM STA 365, TOP TEE CAP SURFACE CORRODED BEYOND LIMITS BL 0 - RBL 70 AT R-1 DOOR THRESHOLD. FABRICATED & INSTALLED TEE CHORD, REPAIR ANGLES AND STRAPS.SDR 2005UALA00044Floorbeam · corrodedMAIN CABIN, RIGHT SIDE, FLOORBEAM STA 324, RBL 28 - RBL 70, TOP T-CAP SURFACE CORRODED BEYOND LIMITS. FABRICATED & INSTALLED REPAIR STRAPS.SDR 2005UALA00043Floorbeam · corrodedFLOORBEAM AT STA 1640, RBL 58-RBL 60 CORRODED BEYOND LIMITS. INSTALLED REPAIR ANGLE, FILLER, STRAP.SDR ABXA050015Floorbeam · corrodedCORROSION DISCOVERED ON FLOORBEAM AT STA 920, LOCATED AT OUTBOARD END OF THE BEAM LOWER RIGHT FLANGE. CORROSION IS BEYOND 20 PERCENT OF MATERIAL THICKNESS. REPAIRED BEAM BY CUTTING AND REMOVING AFFECTED AREA AND SPLICING IN NEW SECTION IAW REA D853-51248-MR.
Back to JASC 5315