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 ASAA0410003Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 520, RIGHT BUTTOCK LINE 60, LEFT BUTTOCK LINE 55 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0410004Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 260, BUTTOCK LINE 0, LEFT BUTTOCK LINE 10 CORRODED. REPAIRED FLOORBEAM PER SRM. (M)SDR ASAA0410001Floorbeam · damagedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 380, LEFT BUTTOCK LINE 11, RIGHT BUTTOCK LINE WITH ELONGATED HOLES. REPAIRED FLOORBEAM PER EA. (M)SDR UPS04441741Floorbeam · corrodedINSPECTION TYPE: C, UPPER DECK - BS 340 RBL 4 - 40 LATERAL FLOORBEAM FOUND SERVICE CORROSION. FLOORBEAM UPPER SECTION REPAIRED PER SRM 53-10-07 FIG 23. CORROSION BLEND OUT 0.050 X 1 X 1 INCH.SDR UPS04441735Floorbeam · corrodedINSPECTION TYPE: C, UPPER DECK, BS 400 RBL 30 FLOORBEAM FOUND CORRODED. CORROSION BLEND OUT 0.050 X 2 X 2 INCH. FLOORBEAM REPAIRED PER SRM 51-40-04 FIG 4.SDR 2005UALA00022Floorbeam · corrodedCABIN FLOORBEAM T-CAP CORRODED ON PREVIOUS REPAIR DOUBLER AT BS 1640, RBL 48-56.SDR 2005UALA00020Floorbeam · corrodedCABIN FLOORBEAM AT STA 324 RBL 40 IS CORRODED BEYOND LIMITS.SDR 2005UALA00019Floorbeam · corrodedFLOORBEAM HAS AREAS OF CORROSION FROM BL 0 TO RBL 60 AT BS 365.SDR UPS04441739Floorbeam · corrodedINSPECTION TYPE: C, COCKPIT - BS 340, LBL 8 - 44, FLOORBEAM UPPER SECTION FOUND CORRODED. CORROSION BLEND OUT 0.050 X 1 X 3 INCH. FLOORBEAM UPPER SECTION REPAIRED PER SRM 53-10-07 FIG 23.SDR UPS04441732Floorbeam · corrodedINSPECTION TYPE: C, COCKPIT BS 380, LBL 22-24, FLOORBEAM UPPER TEE AFT FLANGE FOUND CORRODED. FLOORBEAM REPAIRED PER SRM 51-40-04 FIG 1. CORROSION BLEND OUT 0.050 X 1 X 1 INCH.SDR C2XA04SH003Floorbeam · corrodedSHV- DURING C-CHECK THE LEFT HAND 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. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR CALA0400102Floorbeam · corrodedINSPECTION FOUND CORROSION ALONG THE UPPER SURFACE OF THE UPPER SECTION OF THE STA 967 FLOORBEAM. THE CORRODED UPPER SECTION WAS TRIMMED OUT AND A NEW REPAIR SECTION WAS INSTALLED IAW ECRA 5311-01142.SDR UPS04441707Floorbeam · crackedINSPECTION TYPE: C, BS 1220 LBL 110 FLOORBEAM WEB FOUND CRACKED AS MARKED. FLOORBEAM WEB REPLACED PER SRM 51-40-02 FIG 1.SDR 2005UALA00003Floorbeam · corrodedCABIN FLOORBEAM CAP AT STA 324 CORRODED FROM RBL 30 TO RBL 63.SDR SIMA200402006Floorbeam · corrodedABI - DURING MBV INSPECTION, THE LEFT FLOORBEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT DAMAGE SECTION OF LEFT FLOORBEAM, CLEANED AND TREATED THE REPAIR AREA. FABRICATED AN EXTERNAL ANGLE, FILLER AND TWO SHIMS. REPAIR DONSDR SIMA200402005Floorbeam · corrodedDURING AN MBV INSPECTION, THE CENTER FLOORBEAM BETWEEN FRAME 24 AND 25 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT DAMAGED SECTION OF THE CENTER FLOORBEAM, CLEANED AND TREATED THE REPAIR AREA. FABRICATED EXTERNAL ANGLE, FILLER AND TWO SHIMS. REPAIR DSDR COOSDR030066Floorbeam · corrodedPAX CABIN BODY STATION 380.0 INCHES, FLOORBEAM UPPER CHORD AFT FLANGE CORRODED AT RBL 62.0 INCHES.SDR ASAA0310609Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 847, RIGHT BUTTOCK LINE 24.75, RIGHT BUTTOCK LINE 61 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0310688Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 540-727B, BUTTOCK LINE 0 CORRODED. REPLACED FLOORBEAM PER SRM. (M)SDR SWAA032842Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 986.5, LBL 20 TO LBL 32. REPAIRED FLOORBEAM PER SRM.SDR C2XA03SH523Floorbeam · corrodedSHV-DURING C-CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 19. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH521Floorbeam · corrodedSHV- DURING C-CHECK THE RIGHT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A FILLER/SHIM REPAIR IAW EMB 135 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA03692Floorbeam · crackedDURING A C-CHECK IN MCN, THE FORWARD FLOORBEAM ANGLE AT FS 280 BETWEEN LBL 9 AND RBL 9 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FORWARD FLOORBEAM ANGLE AT FS 280 BETWEEN LBL 9 AND RBL 9 IAW SRM 51-00. (M)SDR 0302219935Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM WEB AT BS 996 RBL 50. REPAIRED PER EA 99-197352.SDR 0400029935Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM WEB AT BS 996 RBL 50. REPAIRED PER EA 99-197352.SDR COMA0360576Floorbeam · corrodedTHE FLOORBEAM CAP BETWEEN FS 559+12 TO FS 620, LBL 27 WAS CORRODED. REMOVED THE CORRODED FLOORBEAM CAP AND INSTALLED A NEW BEAM CAP IAW WVAC EO 601R-53-4501.SDR C2XA03TY220Floorbeam · corrodedTYS DURING A SCHEDULED 3C INSPECTION THE LEFT OMEGA BEAM WAS CORRODED AT THE BOTTOM OF THE GALLEY RAMP ANGLE. MAINT REMOVED THE OMEGA BEAM, FAB SPLICE DOUBLER, ALODINED, PRIMED AND INSTALL SPLICE DOUBLER AND INSTALL THE NEW OMEGA BEAM IAW EMB 135/145 SRM 51-SDR C2XA03SH516Floorbeam · corrodedSHV- DURING C-CHECK THE LEFT OMEGA BEAM WAS FOUND TO CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND INSTALLED A FILLER AND SHIM REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03TY218Floorbeam · corrodedTYS DURING A SCHEDULED 3C INSPECTION THE LT OMEGA BEAM WAS CORRODED AT BOLT HOLES BETWEEN FR 20 AND FR 25. MAINT REMOVED AND REPLACED THE OMEGA BEAM AT DAMAGE AREA AND REINSTALL THE TOPCAP IAW EMB 135/145 AMM 20-10-01 AND SRM 51-40-02. ALL WORK WAS ACCOMPLISDR SWIA200312725Floorbeam · crackedFS 280 RT FLOORBEAM RBL 9.0 INBOARD AND OUTBOARD ATTACH ANGLES CRACKED. DISCOVERED DURING C-CHECK INSPECTION. ANGLES REPLACED IAW CRJ SRM 51-40-11 AND RII 53-401.SDR SWAA032813Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD AT BS 947, RBL 42, WL 208. REPAIRED DAMAGED AREA PER ER.SDR 03FDEA02239Floorbeam · crackedON TOP OF FLOORBEAM STA 328 RT SIDE THERE IS A DENT. REWORKED AREA IAW SRM 51-40-1. NDT FOUND TO BE CRACKED. CUT OUT CRACKED AREA IAW SRM 51-40-4. FABRICATED REPAIR ANGLES IAW SRM 51-40-4. INSTALLED REPAIR ANGLES IAW SRM 51-40-4 & 51-30-2.SDR C2XA03SH511Floorbeam · corrodedSHV- DURING C-CHECK THE CABIN FLOOR STRUCTURE AFT DIGITAL WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFT DIGITAL IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA0310683Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 540-663, LEFT BUTTOCK LINE 24 CORRODED. REPLACED FLOORBEAM PER SRM. (M)SDR ASAA0310678Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 294, LEFT BUTTOCK LINE 11 CORRODED. REPLACED DAMAGED SECTION OF FLOORBEAM PER SRM. (M)SDR SWAA032802Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 25, WL 206. REPAIRED BEAM PER BFG ER.SDR 0302203255Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOORBEAM AT BS 1292 FRAME 66. REPAIRED PER EA 32-197317.SDR SWAA032768Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 44, WL 208, BS 986.5, LBL 12, WL 208, BS 986.5, LBL 13.5, BS 986, LBL 14, WL 209, BS 986, LBL 44, WL 209, BS 986.5 LBL 16, WL 210, BS 947.5, RBL 11, WL 208, BS 947.5, RBL 15 WL 208, BS 947, RBSDR CALA0300715Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986, RBL 18-42. THE CORROSION WAS REMOVED AND A STRAP WAS INSTALLED IAW SRM 53-00-51.SDR C2XA03TY213Floorbeam · corrodedTYS DURING A SCHEDULED 3C INSPECTION THE CENTER TOP CAP IN LAV WAS CORRODED. MAINT REMOVED AND REPLACED THE CENTER TOP-CAP IN THE LAV, ALL WORK WAS IAW SRM 51-40-02 AND WILL BE RELEASED UPON COMPLETION OF ALL WORK.SDR C2XA03TY210Floorbeam · corrodedDURING A SCHEDULED 1C INSPECTION THE LT FLOORBEAM WAS CORRODED. MAINT. REMOVED THE CARBON FIBER AT FR 20 AND FAB A NEW PART TO THE FLOORBEAM. ALODINED, PRIMED AND PAINTED AND REINSTALLED IAW SRM 53-21-10; CPM 51-21-04-05-06 AND SRM 51-40-02. ALL WORK WAS ASDR C2XA03SH506Floorbeam · corrodedSHV- DURING C-CHECK THE LEFT HAND OMEGA BEAM 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. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH505Floorbeam · corrodedSHV- DURING C-CHECK THE LEFT HAND OMEGA BEAM BETWEEN FRAMES 23 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. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH504Floorbeam · corrodedSHV- DURING C-CHECK THE CENTER OMEGA BEAM 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-22-10 FIGURE 201. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AWXA200400036Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-12 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM THAT EXTENDS UNDER R-1 DOOR THRESHOLD DRAIN PLATE BS 365, RBL 45 TO RBL 62. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM BS 365, RBL 45 TO RBL 62; FABRICSDR 2003UALA00965Floorbeam · corrodedCABIN FLOORBEAM 365 AT RBL 10 TO RBL 45.5 HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. CORROSION WAS REMOVED AND FLOORBEAM WAS REPAIRED.SDR C2XA03SH498Floorbeam · corrodedSHV-DURING C CHECK THE CENTER OMEGA BEAM BETWEEN FRAMES 16 AND 24 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 CALA0300712Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM UPPER CHORD CORRODED AT STA 328, LBL 30. A REPAIR WAS INSTALLED IAW SRM 53-10-51.SDR F3LA200300178Floorbeam · corrodedDURING C-CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM UPPER CAP, LBL 17 TO RBL 13. REPAIRED UPPER CHORD ON STA 947 PER EA B3-53R-10228.SDR AWXA200301613Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A .3125 INCH CRACK WAS FOUND ON FLOOR SUPPORT CHANNEL AT BS 540, RBL 0 TO RBL 25. MAINTENANCE REMOVED CRACKED FLOOR SUPPORT CHANNEL AT BS 540, RBL 0 TO RBL 25; FABRICATED A NEW REPLACEMENT CHANNEL PER DWG 65-52894; INSTA
Back to JASC 5315