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 USAA020307Floorbeam · corrodedPIT - FOUND BEAM CORRODED 1 INCH BY 2 INCH AREA, FLOORBEAM LBBI 3.00 AFT OF STATION 767. CORROSION LEVEL 1, TASK NR C53-202-01. SPLICE REPAIR, JOGGLE KIT, PER SRM 53-00-53 FIG 202 AND TYPICAL REPAIR 53-10-06B. (M)SDR 2002UALA01254Floorbeam · corrodedFORWARD CABIN FLOORBEAM UPPER CAP CORRODED, STATION 324 RBL 42. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR STRAP.SDR 2002UALA01249Floorbeam · corrodedFORWARD CABIN FLOORBEAM UPPER T-CAP AT BODY STATION 365.25 RBL 09 TO RBL 60 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED T-CAP.SDR AWXA200200722Tee Chord · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOOR BEAM (TEE CHORD) BS 967, LBL 18. MAINTENANCE CUTOUT DAMAGED AREA OF UPPER TEE CHORD BS 967, LBL 18, FABRICATED 2 EACH SUPPORT ANGLES, 2 EACH STRAPS, AND A NEW SECTSDR AWXA200200721Tee Chord · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOOR BEAM (TEE CHORD) BS 986.5, RBL 3 - RBL 49. MAINTENANCE REMOVED UPPER TEE CHORD OF FLOOR BEAM BS 986.5, RBL 3 - LBL 49, FABRICATED 2 EACH SUPPORT ANGLES, 2 EACH STRSDR AWXA200200710Beam · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON THE UPPER SURFACE OF DIAGONAL FLOOR SUPPORT BETWEEN BS 986.5 AND BS 1006, RBL 8 TO RBL 17. MAINTENANCE REMOVED DIAGONAL FLOOR SUPPORT BETWEEN BS 986.5 TO BS 1006, RBL 8 TO RBL 17; FABRICSDR AWXA200200701Seat Track · chafedLCQ - MAJOR REPAIR - DURING C-08 CHECK SEVERAL CHAFE MARKS WERE FOUND ON SEAT TRACK AT BS 377-400, LBL 45. MAINTENANCE REMOVED DAMAGED SECTION OF SEAT TRACK AT BS 377-400, LBL 45. FABRICATED A NEW SECTION OF SEAT TRACK AND INSTALLED REPAIR IAW B757-200 SRM 53-SDR AWXA200200694Angle · corrodedLCQ - MAJOR REPAIR - DURING C-08 CHECK CORROSION WAS FOUND ON REPAIR ANGLE AT LOWER FLOOR BEAM BS 377, LBL 02. MAINTENANCE REMOVED REPAIR ANGLE AT LOWER FLOOR BEAM BS 377, LBL 02, FABRICATED A NEW REPAIR ANGLE, AND INSTALLED REPAIR IAW B757-200 SRM 53-00-51, PSDR 2002UALA01228Floorbeam · damagedCABIN STATION 947.5 BETWEEN LBL 5 & LBL 20 UPPER SURFACE OF FLOORBEAM HAS EXCESSIVE MATERIAL REMOVED. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE DOUBLER REPAIRS & FILLERS.SDR 2002UALA01220Floorbeam · damagedCABIN FLOORBEAM CAP UPPER SURFACE, STA 660 LBL 24, HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. STRAP AND ANGLE INSTALLED.SDR AWXA200200720Tee Chord · corrodedMCN - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOOR BEAM (TEE CHORD) BS 986, RBL 20 - 40. MAINTENANCE REMOVED UPPER TEE CHORD OF FLOOR BEAM BS 986, RBL 3 - 49, FABRICATED 2 EACH SUPPORT ANGLES, 2 EACH STRAPS, 2 EACHSDR 2002UALA01218Floorbeam · corrodedSTA 1640 FLOORBEAM UPPER CAP HAS EXCESS MATERIAL LOSS AT RBL 18 DUE TO CORROSION. MAJOR REPAIR ACCOMPLISHED USING STRAP REINFORCEMENT.SDR UPS02839151Floorbeam · crackedINSPECTION TYPE:C1 FLOORBEAM STA 879 RBL 60 IS CRACKED AT O/B LIGHTENING HOLE. SPLICED IN NEW SECTION OF FLOORBEAM IAW REO G08713.SDR UPS02839122Floorbeam · crackedINSPECTION TYPE:C1 FLOORBEAM STA 879 RBL 60 IS CRACKED AT O/B LIGHTENING HOLE. SPLICED IN NEW SECTION OF FLOORBEAM IAW REO G08713.SDR 02FDEA00542Floorbeam · corrodedCORROSION ON FLOORBEAM AROUND 2 FASTENER HOLES BS 480 RBL 10 WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8 FIG 8.SDR GTIA020916Longeron · crackedFTW - FOUND AT FS 236 6L LONGERON CRACKED. REMOVED LONGERON SPLICER AND DAMAGED LONGERON. FABRICATED NEW LONGERON SECTION AND REPAIR SPLICE. INSTALLED NEW LONGERON AND SPLICES. (M)SDR 02FDEA00528Floorbeam · corrodedCORROSION ON FLOORBEAM AT NUT CLIP LOCATION BS 950F LBL 10.5 WL 208. REMOVED AND REPLACED FLOORBEAM AT BS 950F, LBL 10.5, WL 208 PER SRM 53-10-8 FIG 8.SDR UPS02438884Floorbeam · crackedINSPECTION TYPE: C, CRACK FOUND AT 1 FASTENER HOLE AT BS 340 LT SIDE UPPER DECK FLOORBEAM UPPER CHORD AREA (VERTICAL FLANGE). CHORD REPAIRED AS PER RS R-53-25-34834 & UPS REPAIR/ALTERATION AUTHORIZATION 747-53-20085.SDR GTIA020931Floorbeam · corrodedFTW - FOUND FLOORBEAM WEB SUPPORT CORRODED STATION 1309 L23L. FABRICATED REPAIR PART. FABRICATED PART AND REINSTALLED. (M)SDR SWIA200211183Floorbeam · crackedDISCOVERED DURING C-CHECK, FS 280.0 RBL 9.0 I/B FLOORBEAM ANGLE CRACKED. REMOVED ANGLE AND INSTALLED NEW ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21 DWG JK601R31101.SDR SWIA200211182Floorbeam · crackedDISCOVERED DURING C-CHECK, FS 280.0 LBL 9.0 I/B & O/B FLOORBEAM ANGLES CRACKED. REMOVED ANGLES AND INSTALLED NEW ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21 DWG JK601R31101.SDR SWAA021652Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 774, LBL 3. REPAIRED FLOORBEAM PER SWA RA.SDR F3LA200200214Floorbeam · corrodedDURING C-7 CHECK, INSPECTION NOTED CORROSION ON STA 328 FLOORBEAM, NEAR PREVIOUS REPAIR NEAR L1 DOOR SILL. MAINTENANCE FOUND THE BEAM TO BE OUT OF LIMITS IN ACCORDANCE WITH SRM 53-10-51. MAINTENANCE REMOVED AND REPLACED THE UPPER CHORD OF STA 328 FLOORBEAM, SDR F3LA200200213Floorbeam · corrodedDURING C-7 CHECK, INSPECTION NOTED LIGHT SURFACE CORROSION IN FORWARD ENTRY AT STA 344. MAINTENANCE FOUND THE STA 344 FLOORBEAM TO BE OUT OF LIMITS IAW SRM 53-10-51. MAINTENANCE REMOVED AND REPLACED THE UPPER CHORD OF STA 344 FLOORBEAM, WL 208, RBL 17 THROUGSDR 0202426743Floorbeam · corrodedDURING "M" CHECK FOUND CORROSION ON FLOORBEAM AT BS 520 LBL 13 TO RBL 21. REPAIRED PER EA 67-191810.SDR SWAA021628Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 328, BL 0.0. REPAIRED FLOORBEAM PER SRM.SDR C2XA02TY111Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE CENTER FLOORBEAM JUST FORWARD OF STATION 20793.0 WAS FOUND TO BE CORRODED IN SEVERAL AREAS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM IAW EMB-145 SRM 51-40-02, 53-24-10, 51-20-03, 53-24-02 AND 51-40-01. THE REPAIR SDR SWAA021618Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 294, WL 208 AND LBL 38. REPAIRED FLOORBEAM PER SRM.SDR SIMA200220510Floorbeam · corrodedFOUND CORROSION ON GALLEY CENTER FLOORBEAM AT FRAME 20. REMOVED CORROSION BY CUTOUT. FABRICATED A REPAIR DOUBLER AND FILLER. REPAIR DONE IAW SRM.SDR 2002UALA01186Floorbeam · corrodedCABIN FLOORBEAM STATION 1660 BL 0 UPPER FLANGE HAS 18.6 PERCENT MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM UPPER CAP. BLEND OUT ANGLE AND STRAP REPAIR.SDR 0202436743Floorbeam · corrodedDURING "M" CHECK FOUND CORROSION ON MAIN DECK FLOORBEAM AT BS 620 BL 11 L&R. REPAIRED PER EA 67-191798.SDR MALA020454Floorbeam · crackedDURING C-CHECK IN CVG, CORROSION AND CRACKS WERE FOUND ON THE FRAME 18 FLOORBEAM. MAINTENANCE REMOVED DAMAGE IAW BAE APPROVED FAX BARA/AVR/5973/02-MN AND MESABA EO A53080.SDR CALA0200396Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 294, RBL 36 TO RBL 49. A REPAIR WAS INSTALLED IAW SRM 53-10-51.SDR DL757020815Floorbeam · corrodedTHE UPPER CAP OF THE FS 1681 PASSENGER FLOORBEAM WAS FOUND WITH SEVERAL AREAS OF CORROSION. THE UPPER CAP FLANGE WAS TRIMMED OFF ALONG THE ENTIRE LENGTH OF THE BEAM TO REMOVE ALL OF THE CORROSION. A NEW ALUMINUM EXTRUSION CAP WAS FABRICATED AND INSTALLED PERSDR C2XA0SH033Floorbeam · corrodedSHV-DURING C-CHECK INSPECTION THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 59 AND 61. MAINTENANCE REMOVED THE CORROSION AND PERFORMED A DOUBLER REPAIR IN ACCORDANCE WITH ENGINEERING CHANGE/REPAIR AUTHORIZATION EC 5320-01067 AND THE AIRCRAFT WSDR C2XA0SH032Floorbeam · corrodedSHV-DURING C-CHECK INSPECTION THE LEFT HAND OMEGA BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 59 AND 61. MAINTENANCE REMOVED THE CORROSION AND PERFORMED A DOUBLER REPAIR IN ACCORDANCE WITH ENGINEERING CHANGE/REPAIR AUTHORIZATION EC 5320-01067 AND THE AIRCRAFSDR C2XA02SH023Floorbeam · corrodedSHV - DURING C-CHECK INSPECTION, THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 16 AND 25. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF OMEGA BEAM IN ACCORDANCE WITH EMB-145 SRM 51-20-03, AND 51-40-02.SDR ABXA020221Floorbeam · bentAFT CARGO, STATION 1320, RIGHT BUTT LINE 33, FLOORBEAM WAS BENT. REPAIRED AREA IAW ABX REA D853-43921MR AND DC-8 SRM 51-1-8.SDR 2002UALA01157Floorbeam · gougedFORWARD CABIN, STATION 360 FLOORBEAM FORWARD SIDE HAS EXCESSIVE MATERIAL LOSS FROM GOUGE BLENDING LBL 18. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED L-REPAIR ANGLE & FASTENERS.SDR C2XA02SH034Floorbeam · corrodedSHV-DURING C-CHECK INSPECTION, THE LEFT HAND OMEGA BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 22 AND 23. MAINTENANCE REMOVED THE CORROSION AND PERFORMED A DOUBLER REPAIR IN ACCORDANCE WITH ENGINEERING CHANGE/REPAIR AUTHORIZATION EC 5320-01068. THE AIRCRAFTSDR SWAA021524Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 767 + 6, LBL 12.50. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA021506Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 727 PLUS 5, LBL 12. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA021504Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 767 PLUS 6, RBL 3. REPAIRED FLOORBEAM PER SWA RA.SDR LR7A02062Fitting · misalignedDURING SCHEDULED C3 INSPECTION LH FS 557 FLOOR END FITTING REPLACEMENT FOUND NEW FITTING PILOT HOLES NOT ALIGNED WITH STRUCTURE.REWORKED FITTING IAW LAC MEA 382-53-02-035. NR 0375.SDR AWXA200200628Angle · corrodedMCN - MAJOR REPAIR - DURING C-12 CHECK INTERGRANULAR CORROSION WAS FOUND ON THE BOTTON SIDE OF CREASE BEAM (ANGLE) AT NUT PLATE HOLE BS 326, LBL 60, WL 208. MAINTENANCE REMOVED DAMAGED SECTION OF ANGLE AT BS 326, LBL 60. FABRICATED A NEW ANGLE, AND INSTALLED RSDR 2002UALA01139Floorbeam · elongatedFORWARD CABIN FLOOR BODY STATION 395 LBL 2 T-CAP FASTENER HOLE IS ELONGATED. MAJOR REPAIR ACCOMPLISHED. INSTALLED 10 INCH STRAP AND NESTED ANGLE.SDR 2002UALA01138Intercostal · corrodedFORWARD CABIN FLOOR INTERCOSTAL AT STATION 301 TO 310.5 RBL 40 HAS EXCESSIVE MATERIAL REMOVED DURING CLEANUP. MAJOR REPAIR ACCOMPLISHED. REPLACED INTERCOSTAL.SDR 2002UALA01128Floorbeam · damagedFORWARD CABIN STATION 294 FLOORBEAM UPPER CAP HAS EXCESS MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. SPLICE CAP REPAIR.SDR 2002UALA01127Floorbeam · crackedCABIN FLOORBEAM INTERCOSTAL UPPER FLANGE IS CRACKED AT BODY STATION 384 BL 0 WL 208. MAJOR REPAIR ACCOMPLISHED. NEW WEB MANUFACTURED AND REPLACED ALONG WITH NEW ANGLE.SDR ABXA020095Floorbeam · corrodedAFT CARGO AT STA. 1300, RBL 16, FLOORBEAM WAS CORRODED. FABRICATED NEW REPAIR PARTS AND FLOORBEAM IAW ABX REA D853-43926-MR, 51-1-8, 53-2-0, 51-1-20D, 51-3-0, AND 51-1-21.
Back to JASC 5315