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 AWXA200500278Floorbeam · corrodedSAL - MAJOR REPAIR - DURING BC-4 CHECK, EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM Y1292 AT FS 67+3". MAINTENANCE REMOVED CORRODED FLOORBEAM Y1292 FROM FS 67+3" TO FS 68, FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AALA20050167Floorbeam · corrodedAFW - TOP CAP OF FLOORBEAM AT STATION 325 RIGHT BUTTLINE 40 CORRODED. BLENDED BEYOND SRM LIMITS. AREA IS ONE INCH BY ONE INCH WITH DEPTH OF 0.10 BY 0.044 INCH FROM PARENT 0.090 INCH. REMOVED CORROSION. FABRICATED REPAIR STRAP OUT OF 301 1/2 H STAINLESS STESDR AALA20050166Floorbeam · corrodedAFW - FLOORBEAM AT STATION 347 AT RIGHT BUTTLINE 30 CORRODED. REMOVED CORROSION AT RIGHT BUTTLINE 30. THE BLEND IS 0.090 INCH BY 0.047 DEPTH FROM 0.090 INCH PARENT. VERIFIED ALL CORROSION WAS REMOVED. FABRICATED REPAIR STRAP OUT OF 301 1/2 H STAINLESS STEESDR USAA050286Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED .5 INCH BY .5 INCH, STATION LBL 34 TO RBL 60. INSTALLED T-CAP IAW SRM 53-10-51. (M)SDR AWXA200500274Floorbeam · corrodedMCN - MAJOR REPAIR - DURING 8-DAY CHECK, CORROSION WAS FOUND ON FLOORBEAM Y29 AT FS 68. MAINTENANCE REMOVED CORRODED FLOORBEAM Y29 AT FS 68; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42-11.SDR AWXA200500272Floorbeam · corrodedMCN - MAJOR REPAIR - DURING 8-DAY CHECK, CORROSION WAS FOUND ON FLOORBEAM -Y29 BETWEEN FS 64 AND FS 66. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y29 FROM FS 64 TO FS 66; FABRICATED A NEW REPLACEMENT FLOOR BEAM, INSTALLED REPAIR PART IAW A320 SRM 51-49-00.SDR AWXA200500271Floorbeam · corrodedMCN - MAJOR REPAIR - DURING 8-DAY CHECK, CORROSION WAS FOUND ON FLOORBEAM -Y50 AT FS 66. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y50 AT FS 66; FABRICATED A NEW REPLACEMENT FLOORBEAM, INSTALLED REPAIR PART IAW A320 SRM 51-42-11.SDR AWXA200500270Floorbeam · corrodedMCN - MAJOR REPAIR - DURING 8-DAY CHECK, CORROSION WAS FOUND ON FLOORBEAM -Y50 BETWEEN FS 66 AND FS 68. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y50 FROM FS 66 TO FS 68; FABRICATED A NEW REPLACEMENT FLOORBEAM, INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200500266Floorbeam · corrodedMCN - MAJOR REPAIR - DURING 8-DAY CHECK, CORROSION WAS FOUND ON FLOORBEAM -Y50 BETWEEN FS 68 AND FS 69. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y50 FROM FS 68 TO FS 69; FABRICATED A NEW REPLACEMENT FLOORBEAM, INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR CALA0500054Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER STRAP CORRODED AT BS 720 FROM LBL 60 TO RBL 60. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND REPLACED IAE SRM 51-40-05.SDR CALA0500051Floorbeam · corrodedINSPECTION FOUND CORROSION ON FLOORBEAM IN L-2 DOOR AREA AT BS 720, LBL 65. REPAIRED IAW SRM 53-00-51, FIGURE 201.SDR SWAA050479Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM TEE CAP AT BS 986, FROM RBL 48 TO BL 0, CORRODED. REPAIRED TEE CAP PER EA.SDR SWAA050469Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 344, FROM LBL 7 TO RBL 9, CORRODED. REPAIRED CHORD PER SRM.SDR SWAA050468Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT BS 270, FROM LBL 11 TO RBL 11, CORRODED. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA050467Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 986.5, FROM LBL 50 TO RBL 50, CORRODED. REPAIRED FLOORBEAM CHORD PER ER.SDR USAA050283Floorbeam · damagedCLT - FOUND FLOORBEAM WITH HOLE .250 INCH, STATION 328 RBL 25. ACCOMPLISHED T-CAP REPAIR IAW SRM 53-10-51. (M)SDR 2005UALA00162Floorbeam · corrodedAFT CABIN FLOORBEAM HAS CORROSION UPPER CAP STA 1640, RBL 11 TO RBL 12. TYPICAL FLOOR BEAM CORROSION. DAMAGE WAS TRIMMED. NEW SECTION OF FLOOR BEAM WAS SPLICED IN USING SPLICE ANGLES.SDR AWXA200500275Floorbeam · corrodedMCN - MAJOR REPAIR - DURING 8-DAY CHECK, CORROSION WAS FOUND AROUND FASTENER HOLES ON FLOORBEAM Y44 JUST FORWARD OF FS 68. MAINTENANCE REMOVED CORRODED FLOORBEAM Y44 AT FS 68; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-42-11SDR AWXA200500268Floorbeam · corrodedMCN - MAJOR REPAIR - DURING 8-DAY CHECK, CORROSION WAS FOUND ON FLOORBEAM Y29 FORWARD OF FR 68. MAINTENANCE REMOVED CORRODED FLOORBEAM Y29 AT FS 68; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-49-00.SDR AWXA200500264Floorbeam · corrodedMCN - MAJOR REPAIR - DURING 8-DAY CHECK, CORROSION WAS FOUND ON FLOORBEAM Y19 AT FS 64. MAINTENANCE REMOVED CORRODED FLOORBEAM Y19 AT FS 64; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200500263Floorbeam · corrodedMCN - MAJOR REPAIR - DURING 8-DAY CHECK, CORROSION WAS FOUND ON FLOORBEAM Y35 AT FS 64. MAINTENANCE REMOVED CORRODED FLOORBEAM Y35 AT FS 64; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-49-00.SDR SWAA050441Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 664, RBL 24.75, CRACKED. REPAIRED FLOORBEAM CHORD PER EA.SDR SWAA050440Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND 4 EACH CRACKS ON FLOORBEAM UPPER CHORD BETWEEN BS 659 AND BS 668, RBL 24.82. REPAIRED FLOORBEAM CHORD PER EA.SDR UPS05443992Floorbeam · corrodedBS 1700 LBL 58 - 76 FLOORBEAM FOUND CORRODED. CORROSION BLEND OUT 0.045 X 2 X 2 INCH, M/D BS 1700 BL 0 TO LBL 69 FLOORBEAM REPAIRED AS PER SRM 53-10-07 FIG 12.SDR UPS05443971Floorbeam · corrodedINSPECTION TYPE: C, BS 1700, RBL 11 - 33 FLOORBEAM FOUND CORRODED. CORROSION BLEND OUT 0.050 X 2 X 2 EXCEED SRM 53-10-01 FIG 1, LIMIT FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 1.SDR 2005UALA00157Stiffener · crackedFLOORBEAM AT STA 246 HAS A CRACKED VERTICAL STIFFENER ON FWD FACE OF BEAM AT APPROX LBL 26. REPLACED CRACKED STIFFENER.SDR 2005UALA00156Stiffener · crackedFLOORBEAM AT STA 246 HAS A CRACKED VERTICAL STIFFENER ON FWD FACE OF FLOORBEAM AT APPROX RBL 26.39. CRACKED STIFFENER WAS REPLACED.SDR SWAA050414Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 1016, RBL 31, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER EA.SDR UPS05443970Floorbeam · corrodedINSPECTION TYPE: C, BS 460 RBL 66 - 65 FLOORBEAM WEB CORROSION FOUND. CORROSION BLEND OUT 0.025 X 1 X 4 EXCEED SRM 53-10-01 FIG 1, LIMIT FLOORBEAM WEB REPAIR AS PER SRM 53-10-07 FIG 11.SDR UPS05443969Floorbeam · corrodedINSPECTION TYPE: C, BS 460, RBL 11 - 30 FLOORBEAM WEB CORROSION FOUND. CORROSION BLEND OUT 0.025 X 1 X 3 EXCEED SRM 53-10-01 FIG 1, LIMIT FLOORBEAM WEB REPAIRED AS PER SRM 53-10-07 FIG 11.SDR AALA20050151Floorbeam · corrodedTUL - CORROSION AT FLOORBEAM AT RIGHTHAND BUTTLINE 0 INCH TO 24 INCH. INSTALLED REPAIR IN ACCORDANCE WITH SRM 53 00 51 2.SDR AWXA200500277Floorbeam · corrodedMCN - MAJOR REPAIR - DURING 8-DAY CHECK, CORROSION WAS FOUND AROUND MOUNT HOLE OF FLOORBEAM -Y18 BETWEEN FS 68 AND FS 69. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y18 FROM FS 68 TO FS 69; FABRICATED A NEW REPLACEMENT FLOORBEAM, INSTALLED REPAIR PART IAW A320 SSDR UPS05443928Floorbeam · corrodedINSPECTION TYPE: C, M/D BS 1500 RBL 5-10 FLOORBEAM FOUND CORROSION. CORROSION BLEND OUT 2 X 2 X 0.060 INCH FLOORBEAM REPAIRED PER SRM 51-40-04 FIG 1.SDR USAA050261Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 1 INCH BY .65 INCH BY .035 AND 1.5 BY .75 BY .037 INCH AREA, FRAME C76 -Y1470--Y1840 MAIN CABIN FLOOR. REPLACED WITH NEW BEAM PER SRM 53-41-14. (M)SDR UPS05443946Floorbeam · corrodedINSPECTION TYPE:C - STA 1500, LBL 65 FLOORBEAM UPPER SURFACE CORROSION. CORROSION BLEND OUT 0.050 X 2 X 2 INCH EXCEED SRM 53-10-01 FIG 1, LIMIT. FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 1.SDR SWIA200514566Floorbeam · crackedFLOORBEAM ANGLE CRACKED AT FS 621.00 LBL 41.0. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLOOR SUPPORT ANGLE IAW CRJ REO 601R-53-61-117 REV B.SDR SWIA200514565Floorbeam · crackedFLOOR SUPPORT ANGLE CRACKED AT FS 621.00 RBL 41.0. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLOOR SUPPORT IAW CRJ REO 601R-53-61-117.SDR SWIA200514563Floorbeam · crackedMAIN FUSELAGE FLOORBEAM AT RBL 9.0 HAS ATTACH ANGLES CRACKED AT FS 280.00. ITEM FOUND AT C-CHECK INSPECTION. ANGLES REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-21-11, 51-25-16, 51-23-00SDR SWAA050388Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM TEE CAP AT BS 986, LBL 15, CORRODED. REPAIRED FLOORBEAM PER TRM T1-453-037.SDR SWAA050387Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 1006, LBL 19, CORRODED. REPAIRED FLOORBEAM CHORD PER SRM AND BAC DRAWING.SDR SWIA200514551Clip · crackedFS 280 LEFT FLOORBEAM AT LBL 9.0 INBOARD AND OUTBOARD ATTACH CLIPS CRACKED. ITEM FOUND AT C-CHECK INSPECTION. REPLACED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00.SDR AWXA200500235Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM STIFFENER ANGLE ON AFT SIDE FLOORBEAM AT BS 328, BETWEEN RBL 43 AND RBL 60. MAINTENANCE REMOVED CORRODED FLOORBEAM STIFFENER ANGLE AT BS 328, FROM RBL 43 TO RBL 60; FABRICATESDR SWAA050369Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 277, FROM LBL 39 TO RBL 47, CORRODED. REPAIRED FLOORBEAM PER SRM.SDR SWAA050368Support · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOOR SUPPORT AT BS 267, FROM LBL 12 TO RBL 12, CORRODED. REPAIRED FLOOR SUPPORT PER EA.SDR SWAA050364Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT BS 328, FROM LBL 49 TO RBL 55, CORRODED. REMOVED AND REPLACED CHORD SECTION PER SRM.SDR SWAA050363Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT BS 360, BL 0, CORRODED. REMOVED AND REPLACED CHORD SECTION PER SRM.SDR SWAA050362Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD AT BS 294, LBL 11, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD PER SRM.SDR SWIA200514765Floorbeam · corrodedRIGHT FLOORBEAM ANGLE AT FRAME 38 TO 44 IS CORRODED. ITEM FOUND AT C-CHECK INSPECTION. CORROSION BLENDED AND ASSESSED IAW EMB 120 SRM 53-00-01, FIG 101. FOUND TO BE WITHIN LIMITS. DEPTH .002, REPROTECTED AREA IAW EMB 120 SRM 51-21-02 & AMM 20-30-05.SDR SWIA200514764Floorbeam · corrodedRIGHT FLOOR SUPPORT ANGLE AT FRAME 44-47 IS CORRODED. ITEM FOUND AT C-CHECK INSPECTION. SUPPORT ANGLE REPLACED IAW EMB 120 SRM 57-40-02, 57-25-00, 51-23-00.SDR SWIA200514782Buttstrap · corrodedBUTTSTRAP CORRODED FROM FR13-RR21 YR 479.00. ITEM FOUND AT C-CHECK INSPECTION. BUTTSTRAP REPLACED IAW EMB 120 SRM 51-40-02, 51-25-00, 51-22-00.
Back to JASC 5315