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 USAA990076Floorbeam · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND CORROSION AT NUTPLATE HOLES STATION 967 LBL 16 - LBL 50 FLOORBEAM. CORROSION TASK NR C53-107-02. INSTALLED REPAIR STRAP PER SRM 53-00-57 FIG 203. (M)SDR USAA990074Floorbeam · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND 8 INCH CORROSION AT STATION 312 LBL 12 FLOOR SUPPORT. REMOVED AND REPLACED SUPPORT PER SRM 51-10-2. (M)SDR USAA990073Floorbeam · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND CORROSION 8 INCH STATION 328 LBL 12 FLOORBEAM. REPAIRED 'T' CAP SLICE PER SRM 53-10-51 FIG 205. (M)SDR USAA990071Floorbeam · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND CORROSION AT TOP SURFACE 'T' CAP STATION 312 LBL 40 - LBL 36 FLOORBEAM. REPAIRED ANGLES 'T' CAP PER SRM 53-10-51 FIG 205. (M)SDR UPS99228774Floorbeam · corrodedINSPECTION TYPE-D, LIGHT CORROSION ON FLOORBEAM LOWER FLANGE BS 680 RBL 25 APPROX. REPAIRED IAW SRM 51-10-02 AND 51-20-151.SDR CALA9900147Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, LBL 52 TO RBL 10. A NEW FLOORBEAM CAP WAS INSTALLED IAW SRM 53-10-51.SDR AT9900139Floorbeam · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE FLOORBEAM AT STA 965 HAS CORROSION AND BLUE WATER STAINS ON LOWER LEG AND AROUND NUT PLATES HOLES LEFT HAND LAVATORY. MECHANICALLY REMOVED CORROSION, FABRICATED TWO DOUBLERS AND INSTALLED IAW DC9 SRM 53-05 FIGSDR ASAA9940049Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE AFT CABIN UPPER SURFACE FLOORBEAM AT STATION 947 LBL 4 AND RBL 5 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01642. (M)SDR ASAA9940048Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE AFT CABIN UPPER SURFACE FLOORBEAM AT STATION 967 RBL 18 WAS FOUND TO BE CORRODED. INSTALLED REPAIR SECTION, SPLICE AND STRAP PER SRM 53-00-51. (M)SDR ASAA9940036Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE AFT CABIN UPPER SURFACE FLOORBEAM AT STATION 987 LBL 36 - RBL 43 WAS FOUND TO BE CORRODED. REPAIRED FLOORBEAM PER EA 5310-01641. (M)SDR ASAA9940035Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE FORWARD CABIN UPPER SURFACE FLOORBEAM AT STATION 344 LBL 14-55 WAS FOUND TO BE CORRODED. REPLACED UPPER CHORD FLOORBEAM PER SRM 53-10-51. (M)SDR ASAA9940034Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE FORWARD CABIN UPPER SURFACE FLOORBEAM AT STATION 312 LBL 13 - RBL 10 WAS FOUND TO BE CORRODED. REPLACED T-CHORD PER SRM 53-10-51. (M)SDR ASAA9940031Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE UPPER SURFACE OF THE FLOORBEAM AT STATION 1016 LBL 29 WAS FOUND TO BE CORRODED. REPAIRED PER SRM 53-00-51. (M)SDR ASAA9940030Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE FLOORBEAM AT STATION 360 RBL 20-30 WAS FOUND TO BE CORRODED. REPLACED FLOORBEAM SECTION PER SRM 53-00-51. (M)SDR 99ZZZX1301Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED AT STA 312 LBL 24 ON FLOORBEAM (AFT OF COCKPIT DOOR).SDR CALA9900131Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, LBL 10 TO RBL 36. A SPLICE REPAIR WAS INSTALLED IAW SRM 53-10-51.SDR AALA994036Floorbeam · crackedAFW - FOUND SMALL CRACK IN VERTICAL LEG OF FLOORBEAM AT STATION 783 RBL 11.06 AND LBL 11.06. REMOVED DAMAGED SECTION OF FLOORBEAM. SPLICED IN NEW SECTION OF FLOORBEAM. INSTALLED ALL REPAIR PARTS WET WITH BMS 5-95. (M)SDR 99ZZZX1287Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FLOOR BEAM STA 380, E/E BAY.SDR UPS99228710Floorbeam · corrodedINSPECTION TYPE:C, CORROSION ON FLOORBEAM UPPER CHORD AT BS 267, LBL 2, COCKPIT FLOOR. CORROSION CLEAN UP WENT BEYOND ACCEPTABLE LIMITS. REMOVED AND REPLACED FLOORBEAM UPPER CHORD.SDR ASAA9940018Floorbeams · corrodedSEA - DURING SCHEDULED SI, FOUND CORROSION IN THE UPPER FLANGE OF THE CARGO FLOORBEAMS BETWEEN BS 727F AND 727G. REPAIRED PER EA 5310-01645. (M)SDR ASAA9940014Floorbeam · corrodedSEA - DURING SCHEDULED SI, THE UPPER FLANGE OF THE CARGO FLOORBEAM AT STATION 772 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01646. (M)SDR RRXA991077Floorbeam · gougedDURING A MAINTENANCE VISIT FOUND GOUGE, FLOORBEAM, FUSELAGE, AT STA 52, UPPER AFT FLANGE HAS DEEP TOOL GOUGE AT BL 36 LEFT ON UNDERSIDE OF FLANGE. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. REPAIRED IAW FAA APPROSDR RRXA991076Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED, FLOORBEAM, AT STA 660, UPPER FLANGES. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. REPAIRED IAW FAA APPROVED TIMCO DER ENGINEERING SKETCH NR REO-06273 AND DC08-53-0351, SDR GAIA99021Floorbeam · corrodedDURING SCHEDULED PHASE IN C-CHECK, CORROSION ON FLOORBEAM UPPER CHORD AT RBL 15 TO 44, FS 1130. AFTER CORROSION REMOVAL THE UPPER CHORD WAS FOUND BEYOND LIMITS. THE DAMAGED AREA TO THE FLOORBEAM WAS REPAIRED AS PE AIA EDR B2-06351, AIA/E/2922 REV ORIG. REPASDR C2XA99IA138Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE FLOORBEAM AT FRAME 39 WAS FOUND CORRODED. MAINTENANCE PERFORMED A DOUBLER REPAIR ON THE AFFECTED FLOORBEAM IAW CONTINENTAL EXPRESS ENGINEERING CHANGE AND REPAIR AUTHORIZATION EC 5310-01037, AND THE AIRCRAFT WAS APPROVED FOSDR C2XA99IA137Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE FLOOR BEAM AT FRAME 36 WAS FOUND CORRODED. MAINTENANCE PERFORMED A DOUBLER REPAIR ON THE AFFECTED FLOORBEAM IAW CONTINENTAL EXPRESS ENGINEERING CHANGE AND REPAIR AUTHORIZATION EC 5310-01037, AND THE AIRCRAFT WAS APPROVED FSDR C2XA99IA135Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE FLOORBEAM AT FRAME 38 WAS FOUND CORRODED. MAINTENANCE INSTALLED A DOUBLER REPAIR TO THE AFFECTED FLOORBEAM IAW CONTINENTAL EXPRESS ENGINEERING CHANGE AND REPAIR AUTHORIZATION EC 5310-01037, AND THE AIRCRAFT WAS APPROVED FOSDR AT9900237Floorbeam · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE CABIN FLOORBEAM ON UPPER FLANGE CORRODED AT BS 1006 LBL18 TO 28. REMOVED AFT CABIN FLOOR STRUCTURE, FABRICATED WEBS, FLOORBEAMS, ANGLE SUPPORTS, DOUBLER AND INSTALLED IAW B737 SRM 53-10-9, 51-30-2, 51-40-2, MMSDR AWXA9900059Floorbeam · corrodedFLOORBEAM AT STA 294.5 LBL 36 CORROSION OUT OF LIMITS. REMOVED DAMAGED AREA PER SRM 53-10-9 FIG 1. FABRICATED T-CAP PER SRM 53-10-9 FIG 1. INSTALLED PER SRM 51-30-2.SDR AWXA9900058Floorbeam · corrodedFLOORBEAM AT STA 328 RBL 20 CORRODED OUT OF LIMITS. REMOVED DAMAGED CAP, FABRICATED AND INSTALLED REPLACEMENT CAP PER SRM 53-10-9, 51-10-2, 51-30-2.SDR AT9900172Floorbeam · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE AFT CABIN FLOORBEAM CORRODED ON UPPER AND LOWER SURFACE OF AFT CARGO COMPARTMENT CABIN CLIPNUTS AT BS 947 FROM LBL 24 TO RBL 36 WITH HEAVY CORROSION AT RBL 14. REMOVED ALL STRUCTURE ASSOCIATED WITH REPAIR AT BSDR UPS99228715Floorbeam · corrodedINSPECTION TYPE:C, FLOORBEAM UPPER CHORD CORRODED BS 344 RBL 15 WL 208. CORROSION CLEANUP BEYOND ACCEPTABLE LIMITS. REPAIRED FLOORBEAM PER SRM 53-10-8 FIGURE 9.SDR SWAA990227Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM CORRODED AT BS 727 TO 947, LBL 3. SPLICED IN NEW SECTION PER BOEING SRM.SDR EIA990044Floorbeam · crackedHKG - DURING C-CHECK, MAIN DECK, BS 440 FLOORBEAM UPPER CHORD AND INTERCOSTAL WEB CRACKED AT LBL 66, NRC 5721 AND 5722. REPAIRED FLOORBEAM FROM BL 0 - LBL 75 AND INTERCOSTAL WEB IAW SRM 53-10-07. (M)SDR EIA990040Floorbeam · crackedHKG - DURING C-CHECK, AFT CARGO COMPARTMENT, BS 1720 FLOORBEAM WEB CRACKED AT LBL 25, NRC 6060. REPAIRED IAW SRM 51-40-02. (M)SDR EIA990039Floorbeam · crackedHKG - DURING C-CHECK, AFT CARGO COMPARTMENT, BS 1720 FLOORBEAM WEB CRACKED AT LBL 25, NRC 6060. REPAIRED IAW SRM 51-40-02. (M)SDR EIA990031Floorbeam · crackedHKG - DURING C-CHECK, BULK CARGO COMPARTMENT, BS 2000 FLOORBEAM CRACKED FROM RBL 9 - RBL 19, NRC 6436. REPLACED FLOORBEAM FROM LBL 51 - RBL 35 IAW SRM 51-10-01. (M)SDR EIA990018Floorbeam · crackedHKG - DURING C-CHECK, UPPER DECK FLOORBEAM CRACKED AT BS 440 AT RBL 65, NRC 6431. REPAIRED IAW HAECO RS R-53-15-34037, 8110-3 AND ECRA. (M)SDR UPS99828668Floorbeam · damagedINSPECTION TYPE-AD, FASTENER HOLE OVERSIZED ON FLOORBEAM. CUT OUT DAMAGED AREA, FABRICATED REPAIR ANGLE, ALODINED AND PRIMED, INSTALLED REPAIR ANGLE. ALL WORK DONE IAW TIMCO DWG DC08-53-0351 R A SHEET 3.SDR UPS99828667Floorbeam · corrodedINSPECTION TYPE-AD, STA 1680 FLOORBEAM VERTICAL LEG CORRODED BETWEEN UPPER TEE AND 2ND ROW OF FASTENERS 3 INCHES INBOARD FROM L21R. SMOOTHED AND BLENDED OUT DAMAGE, FABRICATED REPAIR ANGLE, ALODINED AND PRIMED REPAIR ANGLE AND FLOORBEAM, INSTALLED REPAIR ANGLSDR UPS99828666Floorbeam · crackedINSPECTION TYPE-D, FLOORBEAM CRACKED AT STA 1660 L21R AFT SIDE LOWER FLANGE. CUT OUT DAMAGED AREA, FABRICATED REPAIR ANGLE AND FILLER, ALODINED AND PRIMED REPAIR ANGLE FILLER IAW DC SRM 51, INSTALLED REPAIR ANGLE AND FILLER IAW TIMCO REO6262.SDR TWAA9902708Floorbeam · corrodedDURING CHECK-C MAINT, FOUND IN FORWARD GALLEY THE FLOORBEAM HAD CORROSION JUST FORWARD OF NR 2 GALLEY ON RT SIDE. REPLACED FLOORBEAM SUPPORT PER DRAWING NR 65-64950, AND TRACK PER SRM 53-10-5.SDR RRXA991073Floorbeam · damagedDURING A MAINTENANCE VISIT FOUND DAMAGE, FUSELAGE, FLOORBEAM AT STA 1140, BL 0.0, NO SRM. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR SHIM, ANGLE, AND DOUBLER IAW FAA APPROVED TIMCOSDR RRXA991072Floorbeam · misrepairedDURING A MAINTENANCE VISIT FOUND TWO CUTOUTS, FUSELAGE, FLOORBEAM, UPPER FORWARD FLANGE, AT STA 680. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLERS IAW FAA APPROVED TIMCO DER ENGINESDR TWAA9902201Floorbeam · corrodedDURING OP 16 MAINT CHECK, FOUND SURFACE CORROSION ON FLOORBEAM AT STA 218 TO 237, BL 0. MECHANICALLY REMOVED CORROSION PER TWA STD PROCESS MANUAL. REPAIRED MEMBER PER SRM 53-01, PAGE 10.SDR SWAA990209Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORROSION AT BS 773. REPAIRED PER SWA RA 1-353-2009.SDR SWAA990208Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORROSION AT BS 328, ON FWD FLANGE. REPAIRED PER BOEING SRM.SDR SWAA990207Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORROSION AT BS 825, RBL 7.5. REPAIRED PER SWA RA 1-353-2008.SDR TWAA9902002Support · corrodedDURING OP 15 MAINT CHECK, FOUND FLOOR SUPPORT AT STA 197, OBL TO LBL 44, CORRODED. REPLACED FLOOR SUPPORT PER SPM 6-70-01, PAGE 2.SDR SWAA990213Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FWD FLANGE TOP SIDE OF FLOORBEAM BS 328, RBL 42,5. REPAIRED PER BOEING SRM.
Back to JASC 5315