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 SPAA0200061Floorbeam · corrodedCORROSION ON FLOORBEAM TOP FLANGE AT STA. 1016, LBL 6 TO RBL 5. BEYOND SRM LIMITS. REPAIRED FLOOR BEAM TOP FLANGE PER SRM 53-10-9, FIG 1 PGAS 1-9SDR AWXA200201261Angle · crackedLCQ - MAJOR REPAIR - DURING C-11 CHECK A CRACK WAS FOUND ON THE UNDERSIDE RADIUS OF FLOOR BEAM SUPPORT ANGLE BS 540, BL "O". MAINTENANCE REMOVED CRACKED FLOOR BEAM SUPPORT ANGLE AT BS 540, BL "0"; FABRICATED A NEW REPLACEMENT FLOOR BEAM SUPPORT ANGLE; AND INSTSDR AWXA200300005Floorbeam · crackedDURING C-16 CHECK, A .5000 INCH CRACK WAS FOUND ON LOWER FLOORBEAM TIE STRAP AT BS 340, STR 45 LT, JUST ABOVE AIR STAIR RAIL OUTBOARD END. MAINTENANCE STOP DRILLED END CRACK ON LOWER FLOORBEAM TIE STRAP AT BS 340; FABRICATED A REPAIR PLATE; REMOVED VERTICAL STSDR AWXA200300004Floorbeam · crackedDURING C-16 CHECK, A .5000 INCH CRACK WAS FOUND ON LOWER FLOORBEAM TIE STRAP AT BS 340 JUST ABOVE AIR STAIR RAIL RBL 24.75. MAINTENANCE STOP DRILLED HOLE ON LOWER FLOORBEAM TIE STRAP AT BS 340; FABRICATED A REPAIR PLATE; AND INSTALLED REPAIR PART IAW SRM.SDR 2002UALA01852Floorbeam · corrodedSTATION 1640, RBL 57 FLOORBEAM UPPER CAP CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPAIR ANGLE INSTALLED.SDR SWIA200211717Floorbeam · crackedFS 280 RBL 9.0 FLOORBEAM OUTBOARD, INBOARD AND AFT ANGLES FOUND CRACKED. FOUND DURING C-CHECK INSPECTION. REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-13, 51-42-20, & 51-23-00.SDR AWXA200201259Angle · crackedLCQ - MAJOR REPAIR - DURING C-11 CHECK A CRACK WAS FOUND AROUND FASTENER HOLE OF CABIN FLOOR SUPPORT ANGLE BETWEEN BS 500D AND BS 500E AT BL "0". MAINTENANCE REMOVED DAMAGE ON CABIN FLOOR SUPPORT ANGLE BETWEEN BS 500D AND BS 500E AT BL "0"; FABRICATED 3 EACH RSDR 2002UALA01850Floorbeam · corrodedCABIN FLOORBEAM UPPER CAP CORRODED AT STA 324, RBL 45, 50, 53, 57 AND 58 (BOTH FWD AND AFT SIDES OF UPPER CAP) MAJOR REPAIR ACCOMPLISHED. FLOORBEAM CAP REPLACED.SDR ASAA0210382Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 500B, RIGHT BUTTOCK LINE 20, LEFT BUTTOCK LINE 40 CORRODED. REMOVED AND REPLACED LOWER CHORD PER EA. (M)SDR 2002UALA01840Floorbeam · corrodedCABIN FLOORBEAM HAS CORROSION UNDER GUTTER AT BS 365, RBL 59-61. MAJOR REPAIR ACCOMPLISHED. INSTALLED CABIN FLOOR BEAM UPPER CAP "I" BEAM REDUCED SPLICE LENGTH REPAIR.SDR 2002F01125Floorbeam · corrodedDURING SCHEDULED INSPECTION, MAINTENANCE FOUND LEVEL 2 CORROSION ON TOP AND BOTTOM FORWARD EDGE OF FLOORBEAM TOP CAP AROUND FLOORBOARD ATTACH FORWARD BOLT HOLES. FS 365, RBL 0 TO RBL 52, TM 99. MAINTENANCE REPAIRED FLOORBEAM TOP CAP IAW SRM.SDR 2002UALA01829Floorbeam · corrodedAFT CABIN FLOORBEAM, STA 986, RBL 40 TO 46 HAS GOUGES AND CORROSION. MAJOR REPAIR ACCOMPLISHED. DOUBLER AND STRAP REPAIR.SDR SWIA200211631Floorbeam · crackedFS 280 RBL AND LBL 9.0 FLOORBEAMS INBOARD AND OUTBOARD ANGLES CRACKED. FOUND DURING C-CHECK INSPECTION. REPLACED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13 AND 51-42-21. P/N: 601R31113-58.SDR 2002UALA01836Floorbeam · corrodedFLOORBEAM UPPER T-CAP HAD EXCESS MATERIAL REMOVED DURING CORROSION CLEAN UP AT STA 365, RBL 42 AT STRINGER 17R. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR WITH TWO STRAPS UNDER FWD CAP AND TWO J-ANGLE PLATES ON AFT SIDE.SDR 2002F01086Floorbeam · corrodedDURING SCHEDULED INSPECTION, LEVEL 2 CORROSION DISCOVERED AT FORWARD FUSELAGE SECTION, CORROSION ON FLOORBEAM TOP CAP AT FS 345, LBL 15. MAINTENANCE REPAIRED FLOORBEAM TOP CAP AFT SECTION AT FS 345, LBL 15 IAW SRM.SDR MWEA020724Support · corrodedSTATION 180 FLOORBOARD SUPPORT FROM THE AIRCRAFT CENTERLINE OUTBOARD TO THE #4 SEAT TRACK HAS HEAVY CORROSION. -- REMOVED AND FABRICATED AND INSTALLED NEW PART.SDR MEWA020723Support · corrodedSTATION 160 TO 200 FLOORBOARD SUPPORT 18" INBOARD FROM THE GALLEY DOOR HAS CORROSION. -- REMOVED AND REPLACED NEW SUPPORT.SDR CALA0200574Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FASTENER HOLE, STA 312, RBL 37. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR ASAA0210363Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM FLANGE AT BS 986, LEFT BUTTOCK LINE 17-RIGHT BUTTOCK LINE 37 CORRODED. REMOVED CORROSION AND REPAIRED FLOORBEAM FLANGE PER EA. (M)SDR 2002UALA01824Floorbeam · damagedCABIN STATION 986 RBL 40 FLOORBEAM WEB HAS ELONGATED HOLE MEASURING .437. MAJOR REPAIR ACCOMPLISHED. INSTALLED FREEZE PLUG.SDR 2002UALA01823Floorbeam · damagedCABIN FLOOR BEAM UPPER CORD TOP SURFACE HAS EXCESSIVE MATERIAL LOSS AT BODY STATION 986 RBL 28 RBL 32 AND RBL 40. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR DOUBLER.SDR ASAA0210361Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM WEB AT BS 986-1016, RIGHT BUTTOCK LINE 40 RIGHT BUTTOCK LINE 45 CORRODED. REMOVED AND REPLACED FLOORWEB PER SRM. (M)SDR 02FDEA00922Floorbeam · corrodedCORROSION ON FLOORBEAM, BS 720D, LBL 5. BLENDED CORROSION ON FLOORBEAM, FOUND TO BE OUT OF LIMITS IAW SRM. CUT OUT DAMAGE FROM BS 720-720F, BL 0. FABRICATED AND INSTALLED REPAIR IAW EA.SDR 02FDEA00911Floorbeam · corrodedCORROSION ON UPPER FLANGES OF THE TRANSVERSE FLOORBEAM. BS 760 - 840, RBL 25, WL 208. REPAIRED TRANSVERSE FLOORBEAM BY REPLACEMENT IAW SRM 51-30-2, 53-10-1, DWG 65-16279.SDR 02FDEA00914Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM BS 344, RBL 17 TO LBL 64, WL 208. REMOVED AND REPLACED UPPER CHORD B.S. 344, LBL 65 - RBL 64, WL 208 IAW SRM 51-30-2, DWG SR 27-53-007.SDR ASAA0210345Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 1016, RIGHT BUTTOCK LINE 37, LEFT BUTTOCK LINE 38 CORRODED. REMOVED CORROSION AND REPAIRED FLOORBEAM PER SRM AND EA. (M)SDR 2002UALA01817Floorbeam · corrodedCABIN FLOORBEAM UPPER CHORD IS CORRODED BS 324, RBL 61, WL 208. MAJOR REPAIR ACCOMPLISHED. SPLICED CABIN FLOORBEAM UPPER CHORD.SDR 2002UALA01814Floorbeam · damagedBODY STATION 947, LBL 17 THROUGH LBL 21. FLOORBEAM UPPER FLANGE HAS MATERIAL LOSS EXCEEDING LIMITS. MAJOR REPAIR ACCOMPLISHED. FLANGE REPAIR DOUBLER STRAP INSTALLED.SDR ASAA0210337Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 1006, LEFT BUTTOCK LINE 14, LEFT BUTTOCK LINE 23 CORRODED. REMOVED CORROSION AND REPAIRED FLOORBEAM PER SRM. (M)SDR SIMA200233830Floorbeam · corrodedABI - DURING AN MBV INSPECTION, THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED BELOW SRM LIMITS. PERFORMED A CUT OUT OF THE DAMAGED SECTION OF THE LEFT FLOORBEAM. FABRICATED AN EXTERNAL ANGLE, FILLER AND SHIMS. REPAIR DONE IAW EMB 145 SRM (SRM 145/1142 REV 20) SDR SIMA200233814Floorbeam · corrodedDURING AN IMBV INSPECTION CORROSION AS FOUND ON A PREVIOUS REPAIR TO THE LEFT OMEGA BEAM AT FRAME 20. REMOVED PREVIOUS REPAIR AND INSPECTED THE UNDERLYING BEAM. NO ADDITIONAL DAMAGE NOTED. FABRICATED AN EXTERNAL ANGLE, FILLER, TWO SHIMS AND PLATE. REPAIR DSDR ASAA0210329Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 328-344, RIGHT BUTTOCK LINE 11 CORRODED. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR PER SRM. (M)SDR ASAA0210335Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 328, RIGHT BUTTOCK LINE 11-45 CORRODED. REMOVED, FABRICATED AND INSTALLED UPPER CHORD PER SRM. (M)SDR USAA020469Floorbeam · corrodedFLOORBEAM TOP FLANGE LOWER FORWARD SIDE CORRODED.SDR 2002UALA01785Floorbeam · corrodedBODY STATION 947 CABIN FLOOR BEAM, LBL19 UPPER FLANGE CORRODED UNDER TIEDOWN FITTING. MAJOR REPAIR ACCOMPLISHED. INSTALLED UPPER CAP SPLICE REPAIR.SDR 02FDEA00902Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 1110, RBL 45 TO LBL 45, WL 208. REPAIRED B.S. 1110 FLOOR BEAM LBL 45 - RBL 45 IAW FED EX E.A. 7-5310-68117.SDR 02FDEA00903Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM AT FASTENER HOLES BS 312, LBL 2 TO LBL 50, WL 208. REMOVED AND REPLACED SEAT TRACK AND T-CHORD OF LONGITUDINAL BEAM B.S. 760-850, LBL 25, WL 208 IAW SRM 51-10-5, 51-30-2, 51-30-5, 51-30-8.SDR AALA20021716Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM BETWEEN ROLLER TRAY 2 AND 3, FS 62. REMOVED CORRODED SECTION AND SPLICED IN NEW SECTION IAW SRM 53-10-15. (M)SDR AALA20021717Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM AROUND NUTPLATE HOLES AFT OF ROLLER TRAY NR 1. REMOVED AND REPLACED WITH SECTION OF SUPPORT IAW 53-10-15. (M)SDR 02FDEA00898Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 1070, RBL 53, WL 208. REPAIRED FLOORBEAM IAW SRM.SDR 02FDEA00880Floorbeam · corrodedCORROSION AT BS 1070, BL 0, LBL 65, WL 200 ON THE BOTTOM OF THE FLOORBEAM. REPAIRED FLOORBEAM IAW EA 7-5310-68121SDR 02FDEA00879Floorbeam · corrodedCORROSION AT BS 1070, BL 0, RBL 45, WL 200 ON THE UNDERSIDE OF THE FLOORBEAM. REPAIRED FLOORBEAM BS 1070, BL 0, RBL 45, WL 200 IAW FEDEX EA. 7-5310-68121SDR 02FDEA00878Floorbeam · corrodedCORROSION BS 1030, RBL 35, WL 208 UNDERSIDE OF FLOORBEAM UPPER CHORD AROUND FASTENER HOLE, REPAIRED FLOORBEAM BS 1030, RBL 35, WL 208 IAW SRM 53-10-8 FIG 8SDR SWAA022793Beam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED, BS 845 TO BS 860, RBL 8. REPAIRED BEAM PER SRM AND SWA RA.SDR 02FDEA00899Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM BS 560 BL 0 TO RBL 25, WL 208, LWR SURFACE OF UPPER FLANGE AT FASTENER HOLES.SDR 02FDEA00881Floorbeam · corrodedCORROSION ON LWR CHORD OF BS 1130 FLOORBEAM LBL 65 - RBL 65 WL 200 AROUND NUT PLATE HOLES.SDR 02FDEA00877Floorbeam · corrodedCORROSION BS 1050 RBL 35 WL 208 UNDERSIDE OF FLOORBEAM UPPER CHORD AROUND FASTENER HOLE.SDR SIMA200233813Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, A PREVIOUS REPAIR OF THE FORWARD DIGITAL WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED DAMAGE PREVIOUS REPAIR SECTION OF THE FORWARD DIGITAL. FABRICATED A REPLACEMENT STRAP AND TWO DOUBLERS. REPAIR DONE IAW EMB-145 (SRNSDR DL733021368Skin Panel · crackedSEVERAL CRACKS WERE FOUND IN THE KEEL BEAM LOWER SKIN PANEL FROM FS 661 TO FS 727. THE SKIN PANEL WAS REPLACED PER S/B 737-53-1104. THE DAMAGE WAS FOUND AT HMV.SDR UPS02839929Floorbeam · corrodedSTA 990, RT SIDE OUTBOARD FLOORBEAM LOWER FLANGE CORRODED POSSIBLE FERRY FOR REPAIR. FABBED REPAIR PARTS IAW REO G08940, ALODINED & PRIMED IAW DC8 SRM 51 -1-8 FABBED STIFFENER SPLICES AND STRAPS IAW DAC DWG SR08530029, INSTALLED REPAIR SPLICES AND STIFFENER
Back to JASC 5315