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 BJNA021005Floorbeam · corrodedDURING A SCHEDULED C-CHECK INSPECTION DISCOVERED LEVEL 2 CORROSION ADJACENT TO WATER DRAIN LINE FORWARD UNDER SIDE OF R2 DOOR SCUFF PLATE AREA BS 958 RBL 53. REMOVED CORROSION FROM LOWER OUTBOARD FLOORBEAM SUPPORT, CORROSION WENT OUT OF LIMITS. FABRICATED RESDR DL733021237Floorbeam · corrodedTHE FS 967 & 986.5 PASSENGER FLOORBEAMS WERE FOUND WITH SEVERAL AREAS OF CORROSION ON THE UPPER CAPS OF THE BEAMS. THE UPPER CAPS WERE TRIMMED OFF TO REMOVE THE CORROSION. NEW EXTRUDED CAP SECTIONS WERE INSTALLED TO REPAIR THE AREAS PER ER/A 383998-14, REV ASDR CALA0200504Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 967, LBL 6 TO RBL 6. A STRAP DOUBLER WAS INSTALLED IAW SRM 53-00-51.SDR C2XA02SH113Floorbeam · corrodedDURING C CHECK, THE CENTER FLOORBEAM AT FRAME 20 WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED DAMAGE AND REPLACED AFFECTED FLOORBEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURNED TO SERVICE.SDR SIMA200230321Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE LEFT OMEGA BEAM AT FRAME 24 WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. CUT OUT A SECTION OF THE CENTER OMEGA BEAM. FABRICATED A FILLER, SHIMS AND EXTERNAL ANGLE. REPAIR DONE IAW EMB 145 SRM (145/1142 REV 19) CHAPTER 53-2SDR SWAA022484Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 773, RBL 10 TO LBL 12. REPAIRED FLOORBEAM PER SWA RA.SDR 2002UALA01611Beam · corrodedCABIN FLOOR BEAM T-CAP CORRODED. STA 324 RBL 38-61. MAJOR REPAIR ACCOMPLISHED.INSTALLED REPAIR ANGLE ON FLOOR BEAM SUPPORT.SDR 0203515528Floorbeam · crackedDURING "L" CHECK FOUND CRACK IN FLOORBEAM AT BS 700 LBL 25. REPAIRED PER EA 55-192960.SDR SIMA200230320Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE CENTER OMEGA BEAM AT FRAME 24 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT A SECTION OF THE CENTER OMEGA BEAM. FABRICATED A FILLER, SHIMS AND EXTERNAL ANGLE. REPAIR DONE IAW EMB 145 SRM (EMB SRM 145.1142 REV 19) CHSDR 02FDEA00759Floorbeam · corrodedBULGE IN COCKPIT FLOOR. R&R BEAM PER SRM 51-30-2, 51-30-5, 51-30-8.SDR SIMA20020325Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND THE LEFT OMEGA BEAM AT FRAME 20 CORRODED BELOW SRM LIMITS. CUT OUT SECTION OF LEFT OMEGA BEAM. FABRICATED A FILLER, SHIMS, BACK PLATE AND EXTERNAL ANGLE. REPAIR DONE IAW EMB 145 SRM (145/1142 REV 19) CHAPTER 53-21-10 FSDR ABXA020301Floorbeam · corrodedFLOORBEAM WAS SEVERLY EXFOLIATED AT LEFT PYLON BULKHEAD, BUTT LINE 40 LEFT. INSTALLED 'J' CHANNEL AND AIR GRILL AT STA. 870 - 965. INSTALLED SEAT TRACK, STA. 908 - 965, BUTT LINE 44, IAW DC-9 SRM 51-30-1.SDR SIMA200230324Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, GALLEY RIGHT BEAM, WAS FOUND CORRODED BELOW SRM LIMITS. REMOVED DAMAGED BEAM AND INSTALLED NEW BEAM IAW EMB 145 SRM (EMB 145/1142 REV 19) CHAPTER 51-40-02. (M)SDR BJNA021007Floorbeam · corrodedDURING SCHEDULED C-CHECK INSPECTION DISCOVERED FORWARD LAVATORY FLOOR STATION 294.5 WL 208 LBL 12 FLOORBEAM HAS 12 INCHES OF CORROSION. FLOORBEAM CORRODED MORE THAN 50 PERCENT, OUT OF LIMITS. REMOVED CORRODED FLOORBEAM UPPER T-CAP AND SPLICE. FABRICATED REPSDR SIMA200230332Floorbeam · corrodedABI - DURING AN MBV INSPECTION THE LEFT OMEGA BEAM WAS FOUND TO BE CORRODED BELOW SRM LIMITS AT FRAME 20. CUT OUT SECTION OF DAMAGED OMEGA BEAM AND APPLIED SURFACE TREATMENT. FABRICATED A FILLER, TWO SHIMS, BACK PLATE AND DOUBLER. REPAIR DONE IAW EMB SRM (ESDR SIMA200230319Floorbeam · corrodedABI - DURING A IMBV INSPECTION, THE GALLEY CENTER BEAM WAS FOUND TO BE CORRODED BELOW SRM LIMITS. REMOVED EXISTING CENTER BEAM. INSTALLED NEW BEAM IAW AE ETN EM-53-028R1 AND EMB145 SRM (145/1142 REV 19) CHAPTER 51-40-02. (M)SDR AWXA200201075Floorbeam · corrodedDURING C-08 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER CAP OF CABIN FLOORBEAM BS 377.5, LBL 55. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; CUTOUT DAMAGED SECTION OF FLOORBEAM AT BS 377.5, LBL 55; FABRICATED 2 EACH ANGLES, A SDR C2XA02SH104Floorbeam · corrodedSHV- DURING C CHECK LT FLOORBEAM FOWARD OF FRAME 20 WAS FOUND WITH CORROSION. MAINTENANCE REMOVED DAMAGE AND PERFORMED AN ANGLE REPAIR IAW EMB 145 EMB SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH103Floorbeam · corrodedSHV-DURING C CHECK SUPPORT RAMP ON CENTER FLOORBEAM BETWEEN FRAME 18 AND FRAME 20 WAS FOUND WITH CORROSION. MAINTENANCE REMOVED DAMAGE AND REPLACED SUPPORT RAMP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH101Floorbeam · corrodedSHV- DURING C CHECK, LT FLOORBEAM AT FRAME 20 WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED DAMAGE AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR UPS02839880Floorbeam · corrodedINSPECTION TYPE:C-2 AFT ACCY COMPARTMENT FS 1680 AT LBL 48 LOWER SURFACE OF UPPER FLOORBEAM FLANGE IS CORRODED. REMOVED CORROSION IAW DC8 SRM 51-1-8, BEYOND LIMITS IAW DC8 SRM 53-2-0 FIG 1F. FABRICATED REPAIR ANGLES AND FILLER IAW DC8 SRM 53-2-0 FIG 1B SHEETSDR 02FDEA00745Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 620, RBL 10, WL 208. R&R FLOORBEAM PER SRM 53-10-8.SDR SIMA200230323Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE FORWARD DIGITAL WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED DAMAGED 16.5 INCHES BY 19.625 INCH SECTION OF THE FORWARD DIGITAL BY CUT OUT. FABRICATED A REPLACEMENT STRAP AND TWO DOUBLERS. REPAIR DONE IAW EMB-145, SDR AWXA200201072Floorbeam · crackedDURING C-08 CHECK A 3/4 INCH CRACK WAS FOUND ON UPPER FLOORBEAM "T" CAP AT SEAT TRACK ATTACH POINT BS 700, RBL 46. MAINTENANCE CUTOUT DAMAGED SECTION OF FLOORBEAM AT BS 700, RBL 46, AND PERFORMED A HFEC INSPECTION TO VERIFY NO CRACKS EXIST; FABRICATED A NEW RESDR AWXA200201071Floorbeam · crackedDURING C-08 CHECK A 2 INCH CRACK WAS FOUND ON UPPER FLOORBEAM "T" CAP AT SEAT TRACK ATTACH POINT BS 700, RBL 25. MAINTENANCE CUTOUT DAMAGED SECTION OF FLOORBEAM AT BS 700, RBL 25, AND PERFORMED A HFEC INSPECTION TO VERIFY NO CRACKS EXIST; FABRICATED A NEW REPLSDR AWXA200201030Stiffener · crackedYVR - MAJOR REPAIR - DURING C-20 CHECK A 1/2" CRACK WAS FOUND ON AFT SIDE OF CABIN FLOOR BEAM INTERCOASTAL ATTACH ANGLE (STIFFENER) BS 328, LBL 47. MAINTENANCE REMOVED DAMAGED INTERCOASTAL ATTACH ANGLE AT BS 328, LBL 47; FABRICATED A NEW REPLACEMENT ATTACH ANGSDR 2002UALA01595Floorbeam · corrodedFORWARD GALLEY FLOOR BEAM UPPER CAP REPAIR PLATE IS CORRODED AT BODY STATION 365 FROM RBL 13 TO RBL 54. MAJOR REPAIR ACCOMPLISHED. INSTALLED SUPPORT ANGLE-REINFORCEMENT STRAP.SDR 2002UALA01594Floorbeam · corrodedCABIN FLOOR BEAM STATION 310 RBL 39 TO 42 MATERIAL REMOVED EXCEEDS LIMITS. MAJOR REPAIR ACCOMPLISHED. INSTALLED SUPPORT ANGLE-REINFORCEMENT STRAP.SDR 2002UALA01589Floorbeam · corrodedCABIN STATION 640 FLOOR BEAM CAP CORRODED FROM LBL 43 TO RBL 23. MAJOR REPAIR ACCOMPLISHED. STRAP REPAIR INSTALLED.SDR SWIA200211521Frame · corrodedFRAME AT FS 364 BETWEEN STR 25P AND 25S CORRODED BEYOND LIMITS. FOUND DURING C CHECK INSPECTION. REPLACED FRAME SECTION IAW CRJ SRM 51-40-06, 51-40-11, 51-42-06, 51-42-21, 51-23-00.SDR SWIA200211520Floorbeam · crackedFS 280 PILOT'S BULKHEAD RBL AND LBL 9.0 AFT UPPER FLOORBEAM CRACKED. FOUND DURING C CHECK INSPECTION.HFEC INSPECTION CARRIED OUT ON CUTOUT REPAIR AS REQUESTED IAW RJ NDTM 51-20-06. NO CRACKS FOUND. REPAIRED DAMAGED AREA IAW CRJ REO 601R-53-11-137 REV. ''NSDR SWIA200211518Floorbeam · crackedFS 280 PILOT'S BULKHEAD FLOORBEAM CRACKED AT RBL 9.0 & LBL 9.0. FOUND DURING C CHECK INSPECTION. HFEC INSPECTION CARRIED OUT ON CUTOUT REPAIRS AS REQUIRED IAW RJ NDTM 51-20-06. NO CRACKS FOUND. REPAIRED DAMAGED AREA IAW CRJ REO 601R-53-11-171, REV. ''NC'SDR SWIA200211516Frame · crackedFRAME AT FS 640 IS CRACKED AT STR 9S. FOUND DURING C CHECK INSPECTION. FRAMED REPAIRED IAW CRJ REO 601R-53-61-532. HFEC INSPECTION CARRIED OUT ON CUTOUT REPAIR EDGE AS REQUIRED IAW REO 601R-53-61-532/RJ NDTM 51-20-06. NO CRACKS FOUND.SDR UPS02839814Floorbeam · corrodedINSPECTION TYPE:C-2 AFT ACCESSORY COMP AT STA 1660 FLOORBEAM ABOUT BL20 HAS CORROSION AND MISSING 4 EA ATTACHING BOLTS. REMOVED CORROSION IAW DC8 SRM 51-1-8, OUT OF LIMITS IAW DC8 SRM 53-2-0 FIG 1F. REMOVED DAMAGED AREA & FABBED 1 EA FILLER & 2 EA REPAIR ANGSDR 2002UALA01584Stiffener · crackedFLOOR BEAM VERTICAL STIFFENER CRACKED AT STATION 246, LBL40. MAJOR REPAIR ACCOMPLISHED. REPLACED STIFFENER.SDR 2002UALA01580Floorbeam · corrodedCABIN FLOORBEAM UPPER CAP EXCESSIVE MATERIAL REMOVED STATION 680 LBL 1 TO RBL 16. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLE STRAP.SDR C2XA02SH098Floorbeam · corrodedSHV- DURING C CHECK THE CENTER FLOORBEAM WAS FOUND TO HAVE CORROSION AT FRAME 20. MAITENANCE REMOVED AND REPLACED AFFECTED FLOORBEAM IAW EMB SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR USAA020405Floorbeam · chafedPIT - FOUND BEAM WITH CHAFFING 1 INCH AREA, TOP FLOOR BEAM, STATION 520 OUTBOARD LEFT OUTBOARD SEAT TRACK. BLENDED AND INSALLED STRAP PER SRM 53-00-51. (M)SDR BJNA021012Floorbeam · corrodedFLOORBEAM BS 976, LBL 53 HAS EXFOLIATED CORROSION. REMOVED FLOORBEAM, FABRICATED AND INSTALLED FLOORBEAM REPAIR 55 INCHES BY 1.5 INCHES BAC1505-100617, IAW TIMCO REO-L00597 REV A. (M)SDR 2002UALA01550Floorbeam · corrodedCABIN FLOORBEAM STATION 324 RBL 57 TO 61 MATERIAL REMOVED EXCEEDS LIMITS. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED MATERIAL AND INSTALLED T-CAP SPLICE REPAIR.SDR C2XA02SH093Floorbeam · corrodedDURING C CHECK INSPECTION, CORROSION WAS FOUND AT CENTER FLOORBEAM SUPPORT RAMP BETWEEN FRAMES 18 AND 20. MAINTENANCE REMOVED DAMAGED SECTION, PERFORMED AN ANGLE REPAIR, AND REPLACED AFFECTED SUPPORT RAMP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVEDSDR 02FDEA00747Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM AT BS 344, LBL 45-55, WL 208. R&R UPPER CHORD PER ER 02-1505.SDR 2002UALA01552Floorbeam · corrodedCABIN FLOOR SUPPORT T-CAP AT STATION 365, RBL 12-42, WL 208 CORRODED. MAJOR REPAIR ACCOMPLISHED. STRAP REPAIR INSTALLED.SDR 2002UALA01551Floorbeam · corrodedCABIN FLOOR STRUCTURE AT STATION 333 LBL 45-55, WL 208 FLOOR SUPPORT T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED T-CAP STRAP REPAIR.SDR F3LA200200345Floorbeam · corrodedDURING C-2 CHECK, INSPECTION REPORTED CORROSION ON CARGO FLOORBEAM, BS 813, RBL 8, WL 157. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53-10-5 AND 51-30-02.SDR F3LA200200343Floorbeam · corrodedDURING C-2 CHECK, INSPECTION REPORTED CORROSION ON CARGO FLOOR BEAM, BS 813, LBL 8, WL 157. REPAIRED DAMAGED AREA PER SRM 53-10-1 AND 53-10-5.SDR F3LA200200342Floorbeam · corrodedDURING C-2 CHECK, INSPECTION REPORTED CORROSION ON CARGO FLOORBEAM, BS 813, LBL 12, WL 157. FABRICATED AND INSTALLED REPLACEMENT PARTS PER SRM 53-10-5 AND 51-30-02.SDR SIMA200230310Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE FORWARD DIGITAL IN THE GALLEY AREA WAS FOUND TO BE CORRODED BELOW SRM LIMITS. REMOVED SECTION OF EXISTING DIGITAL. FABRICATED TWO REPAIR DOUBLERS AND SHIMS. REPAIR DONE IAW EMB 145 SRM, SRM 145/1142 REV 19, CHAPTER 53-21SDR SIMA200230303Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE FORWARD DIGITAL IN THE GALLEY AREA WAS FOUND TO BE CORRODED BELOW SRM LIMITS. REMOVED SECTION OF EXISTING DIGITAL. FABRICATED TWO REPAIR DOUBLERS AND SHIMS. REPAIR DONE IAW EMB145 SRM, SRM 145/1142 REV 19, CHAPTER 53-21-SDR 02FDEA00731Floorbeam · corrodedCORROSION ON UPR CHORD FLOORBEAM AT BS 344, LBL 3, WL 208.
Back to JASC 5315