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 2003UALA00061Floorbeam · corrodedCABIN FLOORBEAM STATION 947, RBL10 TO RBL53, WL 208 UPPER SURFACE HAS SEVERAL AREAS OF CORROSION. MAJOR REPAIR ACCOMPLISHED. SPLICE REPAIR.SDR 03FDEA000034Floorbeam · corrodedCORROSION ON FLOORBEAM, BS 1030 LBL 9 WL 208. REPAIRED IAW SRM.SDR 03FDEA00028Floorbeam · corrodedCORROSION ON LOWER FLOORBEAM CORD, AROUND NUTPLATES, STA 1070, 0 BL - RBL 45, WL 200. BLENDED CORROSION ON BS 1070 LOWER CHORD AND FOUND OUT OF LIMITS AT RBL 11 TO RBL 34. REMOVED LOWER CHORD FROM RBL 11 TO RBL 34. FABRICATED REPAIR PARTS AND INSTALLED REPASDR 03FDEA00039Floorbeam · corrodedCORROSION ON FLOORBEAM BS 312 AT FASTENER HOLES WL 207.SDR 2003UALA00057Floorbeam · crackedSTATION 660, LBL 46, FLOORBEAM IS CRACKED AT FLOOR SUPPORT ATTACH CLIP. MAJOR REPAIR ACCOMPLISHED AT FLOOR BEAM UPPER CAP. PERFORMED SPLICE REPAIR.SDR 2003UALA00056Floorbeam · corrodedSTATION 680, CABIN FLOORBEAM UPPER CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. UPPER FLANGE REPAIRED WITH DOUBLER.SDR SIMA200301501Floorbeam · corrodedABI - DURING A IMBV INSPECTION, THE FORWARD DIGITAL WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT A 16.5 BY 21 SECTION OF THE DIGITAL. FABRICATED A REPLACEMENT STRAP. FABRICATED TWO REPAIR DOUBLERS, AND SHIMS. REPAIR DONE IAW EMB 145 SRM (145/1142 REVSDR UPS03240093Floorbeam · corrodedINSPECTION TYPE: C&SI, SURFACE CORROSION ON FLOORBEAM TOP CAP BS 312 LBL 10 & LBL 24.75. CARRIED OUT REPAIR AT ABOVE LOCATION IAW SRM 53-10-8.SDR ABXA030044Floorbeam · crackedF.S. 1072 FLOORBEAM UPPER ANGLE CRACKED, RBL 54. REPAIRED FS 1072 FLOORBEAM UPPER ANGLE AT RBL 54 IAW DC-9 SRM.SDR CALA0300007Floorbeam · crackedINSPECTION FOUND A 1" CRACK IN RADIUS OF FLOORBEAM ON AFT SIDE OF STA 540 UNDER EXPANSION JOINT AT R/H I/B SEAT TRACK. REPAIRED IAW ECRA 5320-01406.SDR 2003UALA00048Floorbeam · corrodedCABIN FLOOR BEAM UPPER CHORD HAS INTERGRANULAR CORROSION BODY STATION 310, RBL 40-45. MAJOR REPAIR ACCOMPLISHED. REPLACED FLOORBEAM UPPER CAP.SDR F3LA200300002Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED TOP SIDE OF I-BEAM AT STA 947 BETWEEN LT AND RT SEAT TRACKS. REMOVED CORRODED SECTION OF FLOORBEAM UPPER CAP PER SRM 53-00-51, FIG 202. FABRICATED AND INSTALLED SECTION OF STA 947.5 UPPER CAP PER SRM 53-00-51, FIG 202, SSDR 2003UALA00039Floorbeam · corrodedSTATION 1640 RBL 58 FLOORBEAM UPPER CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. REPAIR T CAP INSTALLED.SDR C2XA03TY002Floorbeam · corrodedDURING A SCHEDULED 2C INSPECTION THE RT LAV FLOORBEAM WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE RT LAV FLOORBEAM, PRIMED AND PAINTED IAW EMB 135/145 SRM 51-40-02, CPM 51-21-05,06. ALL WORK WAS ACCOMPLISHED AND WILL BE RELEASED UPON COMPLETION SDR C2XA03TY001Floorbeam · corrodedDURING A SCHEDULED 2C INSPECTION THE CENTER LAV FLOORBEAM SHOWS SIGNS OF CORROSION. MAINTENANCE REMOVED AND REPLACED THE CENTER LAV FLOORBEAM, REMOVED AND REPLACED THE CENTER CARBON FIBER BEAM, PRIMED AND PAINTED THE CENTER LAV FLOORBEAM IAW EMB 135/145 SRM 5SDR SWIA200311756Support Angle · crackedFS 621 LH FLOOR SUPPORT ANGLE CRACKED. FOUND DURING C CHECK INSPECTION. REPAIRED DAMAGE IAW CRJ REO 601R-53-61-117 REV ''A''. ANGLE P/N: 601R53-61-117-1 REPAIR ANGLE P/N: 601R53-61-117-3.SDR SWIA200311754Floorbeam · crackedFS 280 LBL AND RBL 9.0 INBOARD AND OUTBOARD FLOORBEAM ANGLES CRACKED. FOUND DURING C-CHECK INSPECTION. REMOVED AND INSTALLED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-42-21 AND 51-23-00. P/N: 601R3113-57.SDR AALA20030056Floorbeam · corrodedFOUND FLOORBEAM UPPER FLANGE AT STATION 347 RBL 45.5 HAD CORROSION BLENDED BEYOND SRM LIMITS. REQ ENGINEERING APPROVAL TO REPAIR PER ATTACHED DRAWING. FLOORBEAM REPAIRED AT STATION 347 PER MRB 767-2428. (M)SDR AWXA200300084Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND FLOORBEAM AT FR 16, THIRD BEAM FROM OUTBOARD RT SIDE. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS; FABRICATED A FILLER AND REPAIR ANGLE; INSTALLED REPAIR PARTS IAW ASDR AWXA200300082Floorbeam · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND RT SIDE OUTBOARD TRACK BEAM EXTENSION OF CABIN FLOORBEAM FRAME 16. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS; CUT OUT DAMAGED SECTION OF FLOORBEAM FR 16; FABRICATED A FILLER AND 2 EACH RESDR DHL2004752500Strap · crackedDURING C-CHECK, CABIN FLOORBEAM SUPPORT STRAP CRACKED AT BS 328 0 (SEEN FROM BELOW). CABIN FLOORBEAM SUPPORT STRAP AT BS 328 BL 0 CRACKED IN HALF OUT OF LIMITS IAW B-727 SRM 53-10-1. FABRICATED REPAIR STRAP FROM 7075-T6 .050 SIZE 2.5 INCH X 8 INCH PO 900489 SDR DHL2003752500Strap · crackedDURING C-CHECK, CABIN FLOORBEAM SUPPORT STRAP CRACKED AT BS 328 0 (SEEN FROM BELOW). CABIN FLOORBEAM SUPPORT STRAP AT BS 328 BL 0 CRACKED IN HALF OUT OF LIMITS IAW B-727 SRM 53-10-1. FABRICATED REPAIR STRAP FROM 7075-T6 .050 SIZE 2.5 X 8 INCH PO 900489 IAW BSDR DL73K030038Floorbeam · corrodedCORROSION DAMAGE ON STA 986.5 FLOORBEAM UPPER CHORD AT LBL 6 AND RBL 6. REPAIRED PER SRM DRD 53-20-1D FIG 803D, UPPER CHORD REPLACEMENT.SDR AWXA200300050Seat Track · corrodedLCQ - MAJOR REPAIR - DURING C-13 CHECK CORROSION WAS FOUND ON R/H OUTBOARD CABIN SEAT TRACK AT BS 649 TO BS 706. MAINTENANCE REMOVED CORRODED SEAT TRACK AT RBL 44 FROM BS 536 TO BS 727; FABRICATED A NEW REPLACEMENT SEAT TRACK; AND INSTALLED REPAIR PART IAW B73SDR 2003UALA00011Floorbeam · crackedCRACK IN UPPER FLANGE OF CABIN FLOOR INTERCOSTAL AT BS 346 FLOORBEAM BL0 SEEN FROM LOWER SIDE. MAJOR REPAIR ACCOMPLISHED. INSTALLED FILLER AND DOUBLER.SDR SIMA200300801Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE CENTER SECTION OF THE FORWARD DIGITAL WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED DAMAGED SECTION OF THE FORWARD DIGITAL BY CUT OUT. FABRICATED A REPLACEMENT FORWARD DIGITAL CENTER SECTION, TWO DOUBLERS AND SHIMS.SDR C2XA02SH169Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM WAS FOUND TO HAVE CORROSION AT FRAME 20. MAINTENANCE REMOVED DAMAGE AREA AND REPAIRED AFFECTED OMEGA BEAM IAW EMB SRM 145 53-21-10. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR OZI2003F00001Floorbeam · corrodedFORWARD SIDE OF LAVATORY FLOORBEAM (FRAME 35) CORRODED.SDR SWIA200311729Floorbeam · crackedFS 280 LBL 9.0 FLOORBEAM I/B & O/B ANGLES CRACKED. FOUND DURING C-CHECK INSPECTION. ANGLES REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, AND 51-42-21. P/N: 601R3113-57.SDR SWIA200311728Floorbeam · crackedFS 280 RBL 9.0 FLOORBEAM I/B ANGLE CRACKED. FOUND DURING C-CHECK INSPECTION. ANGLE REPLACED IAW CRJ SRM 51-40-11, 51-42-06 AND 51-42-21. P/N: 601R3113-58.SDR UPS03840029Floorbeam · crackedINSPECTION TYPE: C2, FLOORBEAM TO VERTICAL STIFFENER ATTACH ANGLE IS CRACKED AT STA 680 AT RBL 48. REMOVED, FABRICATED AND REPLACED ANGLE IAW DWG 5773275, AND SRM 51-1-20.SDR DL757030016Floorbeam · corrodedTHE UPPER CAP OF THE FS 377 FLOORBEAM WAS FOUND CORRODED. THE UPPER CAP WAS TRIMMED OFF AND A NEW SECTION FABRICATED. DURING INSTALLATION OF THE NEW SECTION, SEVERAL ATTACH HOLES COMMON TO THE FS 377 FRAME AT LBL 65 WERE DAMAGED. THE AFFECTED HOLES WERE OVESDR DL757030014Floorbeam · corrodedTHE UPPER CAP OF THE FS 1681 FLOORBEAM WAS FOUND WITH SEVERAL AREAS OF CORROSION. TO REMOVE ALL OF THE DAMAGE, THE UPPER CAP WAS TRIMMED OFF FROM LBL 60 TO RBL 60. A NEW CAP WAS FABRICATED AND INSTALLED PER ER/A 384247-14, REV A.SDR 2003UALA00002Floorbeam · corrodedCABIN FLOORBEAM UPPER CHORD CORRODED, STA 365, RBL 5-15. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLES.SDR AWXA200300025Intercostal · crackedLCQ - MAJOR REPAIR - DURING C-10 CHECK A 1" CRACK WAS FOUND ON MAIN CABIN INTERCOSTAL AT BS 1620, LBL 45. MAINTENANCE CUTOUT CRACKED SECTION ON MAIN CABIN INTERCOSTAL BETWEEN BS 1620 TO BS 1640, LBL 45; FABRICATED A REPAIR DOUBLER AND FILLER; AND INSTALLED REPSDR AWXA200300032Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-10 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOOR BEAM UPPER CAP AT BS 1640, LBL 60. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED CORRODED TEE CHORD BS 1640, LBL 65 TO RBL 55; FABRICATED A NSDR AWXA200300024Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-10 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOOR BEAM UPPER CAP AT BS 1640, BL 0 TO LBL 5. MAINTENANCE REMOVED CORROSION ON FLOOR BEAM AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED CORRODED UPPER FLOOR BEAM TEE CAP BS 16SDR C2XA02TY188Floorbeam · corrodedTYS, DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE FORWARD DIGITAL AT COCKPIT ENTRANCE. MAINTENANCE CUT OUT DAMAGED AREA, FABRICATED, ALODINED, PRIMED AND INSTALLED STRAPS, DOUBLERS AND SHIMS I/A/W-EMB-135/145-SRM-51-21-10, CMP-51-21-04, 05 AND 06.SDR SIMA200300811Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING FOUND DURING AN IMBV INSPECTION, GALLEY AREA CENTER BEAM HAS CORROSION AT FRAME 20. REMOVED AND INSTALLED SERVICEABLE BEAM IAW EMB 135 SRM 53-21-40. (M)SDR C2XA02SH159Floorbeam · corrodedSHV - DURING C-CHECK LEFT HAND OMEGA BEAM WAS FOUND TO HAVE CORROSION ON DOUBLER INBOARD AT FRAME 20. MAINTENANCE REMOVED DAMAGE AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR SIMA200300605Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE CENTER SECTION OF THE FORWARD DIGITAL WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED DAMAGED 15.5 INCHES BY 21.25 INCH SECTION OF THE FORWARD DIGITAL BY CUTOUT. FABRICATED A REPAIR DOUBLER FOR FLANGE TO BE INSTALLED SDR RYN2003F00003Floorbeam · crackedAT B CHECK, CRACK FOUND IN FUSELAGE INTERIOR AT FLOORBEAM LOWER CHORD ANGLE BS295, LBBL30.SDR 02FDEA00972Floorbeam · gougedLONGITUDINAL FLOORBEAM OUTBOARD, LOWER FLANGE SIDE IS GOUGED JUST BELOW FASTENER HOLES BS 760-848, LBL 51, WL 208. LONGITUDINAL FLOORBEAM, BS 760-848, FOUND TO BE OUT OF LIMITS IAW SRM. REMOVED DAMAGED BEAM, FABRICATED, ALODINED, PRIMED AND INSTALLED REPLACESDR AWXA200300020Seat Track · crackedLCQ - MAJOR REPAIR - DURING C-10 CHECK A 3/4" CRACK WAS FOUND ON THE UPPER RADIUS OF THE OUTBOARD R/H SEAT TRACK IN THE AFT CARGO COMPARTMENT. MAINTENANCE REMOVED THE SEAT TRACK FROM BS 1180 TO BS 1280, RBL 45.5; FABRICATED A NEW REPLACEMENT SEAT TRACK ; INSTASDR 02FDEA00964Floorbeam · gougedLONGITUDINAL FLOORBEAM OUTBOARD, LOWER FLANGE, UPPER SIDE IS GOUGED, JUST BELOW FASTENER HOLES FROM BS 740-848, RBL 51, WL 208. FABRICATED AND REPLACED LONGITUDINAL BEAM UPPER CHORD IAW SRM.SDR 0204246628Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON AFT CARGO FLOOR BEAM UPPER CHORD AFT FLANGE AT BS 1920 RBL 33. REPAIRED PER EA 66-193799.SDR AWXA200300022Seat Track · corrodedMCN - MAJOR REPAIR - DURING C-16 CHECK CORROSION WAS FOUND ON SEAT TRACK BS 335 TO BS 338, RBL 45. MAINTENANCE BLENDED OUT CORROSION ON SEAT TRACK AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS PER B737-300 SRM 51-30-02, PG. 68, FIG. 1; REMOVED DAMAGED SEAT TRACKSDR SWAA022973Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 777, LBL 8.0. REPAIRED FLOORBEAM PER SWA RA.SDR SIMA200300812Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING DURING AN IMBV INSPECTION, GALLEY AREA AFT DIGITAL HAS CORROSION. REMOVED AND INSTALLED SERVICEABLE DIGITAL IAW EMB 145 SRM 51-40-02. (M)SDR SWAA022959Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND CENTER LONGITUDINAL FLOORBEAM CRACKED AT BS 663, BL O. REPAIRED FLOORBEAM PER SWA EA.
Back to JASC 5315