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 F3LA200200329Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON FLOOR BEAM UPPER CHORD, BS 344. REPAIRED FLOORBEAM PER SRM 53-10-51 AND EA 53-737-184.SDR 0203355515Floorbeam · crackedDURING "L" CHECK FOUND CRACK IN FLOORBEAM UPPER CAP AT BS 700 LBL 45. REPAIRED PER EA 55-191543.SDR C2XA02SH090Floorbeam · corrodedDURING C CHECK INSPECTION, LT LATERAL FLOORBEAM WAS FOUND TO HAVE CORROSION AT RE-ENFORCEMENT ANGLE BETWEEN FRAMES 19 AND 21. MAINTENANCE REMOVED DAMAGE AND PERFORMED AN ANGLE REPAIR IAW EMB 145 SRM 51-30-01, SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURNSDR C2XA02SH091Floorbeam · corrodedSHV- DURING C CHECK INSPECTION CENTER FLOORBEAM BUTT STRAP BETWEEN FRAMES 59 AND 61 WAS FOUND TO HAVE CORROSION ON NUTPLATES AND NUTPLATES HOLES. MAINTENANCE REMOVED AND REPLACED AFFECTED BUTTSRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TSDR SWIA200211428Floorbeam · crackedFS 280 RBL 9.0 FLOORBEAM ANGLES IB & OB CRACKED. FOUND DURING C CHECK INSPECTION. FIT AND INSTALL NEW ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-42-21. P/N: 601R31113-58SDR SWIA200211427Floorbeam · crackedFS 280 LBL 9.0 FLOORBEAM IB ANGLE CRACKED. FOUND DURING C CHECK INSPECTION. FIT AND INSTALLED NEW ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21.SDR AWXA200201019Channel · crackedMCN - MAJOR REPAIR - DURING C-12 CHECK A 1/2" CRACK WAS FOUND ON FLOOR SUPPORT IN THE AFT CARGO COMPARTMENT AT BS 767 TO BS 787, STR 25 R/H. MAINTENANCE REMOVED THE CRACKED FLOOR SUPPORT AT BS 767 TO BS 787, STR 25 R/H; FABRICATED A NEW REPLACEMENT FLOOR SUPPSDR CALA0200487Floorbeam · crackedINSPECTION FOUND FLOORBEAM CRACKED ON UPPER ANGLE AT STA 328, LBL 12. THE CRACKED SECTION OF FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR C1HA200293009Floorbeam · corrodedT-CHORD CORRODED AT STA 328 AS VIEWED FROM FUSELAGE INTERIOR ON RT SIDE.SDR USAA020393Floorbeam · crackedANGLE/BEAM BS 616 VERTICAL FLOORBEAM SUPPORT, FORWARD OF RIGHT EMERGENCY EXIT. CUT OUT DAMAGE, INSTALLED FILLER AND DOUBLER IAW TR.SDR 2002UALA01542Floorbeam · corrodedCABIN FLOOR BEAM UPPER CAP HAD EXCESS MATERIAL REMOVED DURING CORROSION CLEAN UP AT STATION 680 RBL 5 TO RBL 12, TWO SPOTS STRINGER 17R. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP REPAIR.SDR 2002UALA01535Floorbeam · corrodedFORWARD CABIN STATION 360 RBL 12 FLOORBEAM HAS SURFACE CORROSION. MAJOR REPAIR ACCOMPLISHED, INSTALLED STRAP REPAIR.SDR AWXA200201001Angle · crackedMCN - MAJOR REPAIR - DURING C-17 CHECK 3 EACH 1 1/2" CRACKS WERE FOUND ON FLOOR SUPPORT ANGLE FROM BS 500D TO BS 520, BL 0. MAINTENANCE REMOVED CRACKED FLOOR SUPPORT UPPER ATTACH ANGLE FROM BS 500D TO BS 520, FABRICATED A NEW REPLACEMENT UPPER ATTACH ANGLE, ANSDR F3LA200200320Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION BY SCREW HOLES IN REAR GALLEY FLOOR BEAMS AT BS 986. FABRICATED AND INSTALLED REPLACEMENT T CAP PER SRM 53-00-01, 53-30-01 AND SOPM 20-41-02.SDR 0203345527Floorbeam · crackedDURING "L" CHECK FOUND CRACK IN FLOORBEAM UPPER CAP AT BS 700 LBL 25. REPAIRED PER EA 55-191542.SDR C2XA02SH085Floorbeam · corrodedSHV DURING C CHECK INSPECTION, THE RT FLOORBEAM AT FRAME 20 WAS FOUND TO HAVE CORROSION AT NUTPLATE HOLES AND UNDER DOUBLER. MAINTENANCE REMOVED DAMAGED SECTION AND PERFORMED A FLOORBEAM REPAIR IAW EC 5320-01077. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICESDR C2XA02SH084Floorbeam · corrodedSHV DURING C CHECK, NUTPLATE HOLES WERE FOUND WITH CORROSION ON LT LATERAL FLOORBEAM BETWEEN FRAMES 15 AND 17. MAITENANCE REMOVED DAMAGED SECTION AND PERFORMED FLOORBEAM REPAIR IAW EC 5320-01078. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH082Floorbeam · corrodedDURING C CHECK INSPECTION, RT FLOORBEAM BUTT STRAP BETWEEN FRAMES 59 AND 61 WAS FOUND TO HAVE CORROSION IN NUTPLATE HOLES. MAITENANCE REMOVED AND REPLACED AFFECTED BUTT STRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH081Floorbeam · corrodedSHV-DURING C CHECK, LT CARGO SILL FLOORBEAM WAS FOUND TO HAVE CORROSION. MAITENANCE REMOVED AND REPLACED AFFECTED SILL FLOORBEAM IAW EMB SRM 57-220-03, SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH079Floorbeam · corrodedSHV-DURING C CHECK INSPECTION, LT LATERAL FLOORBEAM AROUND NUTPLATE HOLES WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED DAMAGE AND PERFORMED A FLOORBEAM REPAIR IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH077Floorbeam · corrodedSHV-DURING C CHECK INSPECTION DOUBLER ON RT LATERAL FLOORBEAM AT FRAME 20 WAS FOUND WITH CORROSION. MAINTENANCE REMOVED AND REPLACED DAMAGED DOUBLER IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH078Floorbeam · corrodedSHV-DURING C CHECK INSPECTION NUTPLATE WAS FOUND WITH CORROSION ON CENTER FLOORBEAM AT FRAME 22. MAINTENANCE REMOVED DAMAGE AND REPLACED FLOORBEAM BETWEEN FRAMES 16 AND 24 IAW EMB SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH076Floorbeam · corrodedDURING C CHECK INSPECTION NUTPLATE WAS FOUND CORRODED ON CENTER FLOORBEAM AT FRAME 18. MAINTENANCE REMOVED AND REPLACED FLOORBEAM BETWEEN FRAMES 16 AND 24 IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN SERVICE.SDR C2XA02SH075Floorbeam · corrodedSHV-DURING C CHECK FLOORBEAM DOUBLER AT FWD CARGO PARTITION WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED AND REPLACED DAMAGED DOUBLER IAW EMB 145 SRM 51-20-03 AND SRM 51-04-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH073Floorbeam · corrodedDURING C CHECK INSPECTION BUTTSRAP ON CENTER FLOORBEAM WAS FOUND TO HAVE CORROSION BETWEEN FRAMES 18 AND 23. MAINTENANCE REMOVED AND REPLACED CENTER FLOORBEAM BETWEEN FRAMES 18 AND 23 IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR C2XA02SH072Floorbeam · corrodedSHV- DURING C CHECK THE CENTER FLOORBEAM WAS FOUND TO HAVE CORROSION AT GALLEY MOUNT HOLES BETWEEN FRAMES 18 AND 23. MAINTENANCE REMOVED AND REPLACED CENTER FLOORBEAM BETWEEN FRAMES 18 AND 23 IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SSDR UPS02839701Fitting · crackedINSPECTION TYPE: C1, FWD PIT FS 340 RT FLOORBEAM END FITTING CRACKED. REMOVED AND REPLACED CRACK FITTING P/N 6754022-504A IAW DC8 SRM 51-1 -20D AND 51-3-0SDR 2002F01081Floorbeam · corrodedDURING SCHEDULED INSPECTION, LEVEL 2 CORROSION DISCOVERED ON MAIN CABIN FLOORBEAM UPPER CHORD NEAR R1 DOOR. FUSELAGE STATION 365, WL 208, RBL 48. MAINTENANCE REPAIRED FLOORBEAM UPPER CHORD IAW SRM.SDR SIMA20023034Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, LEFT OMEGA BEAM FLOOR SUPPORT ANGLE HAS CORROSION. REMOVED AND REPLACED FLOOR ANGLE IAW EMB 145 SRM 51-40-02. (M)SDR ABXA020290Floorbeam · corrodedCORROSION FOUND ON NOSE LANDING GEAR WELL HORIZONTAL PRESSURE PANEL, BETWEEN FS 12 TO FS 27. ALSO FOUND CORROSION ON FLOORBEAM LOWER FLANGE AT FS 12, BUTT LINE '0'. REPAIRED AREA IAW REA 853-41975MR.SDR SIMA200228217Floorbeam · corrodedDURING A IMBV INSPECTION LEFT HAND BEAM AT FRAME 25 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT SECTION OF DAMAGED BEAM. FABRICATED A FILLER, TWO SHIMS AND EXTERNAL ANGLE. REPAIR DONE IAW SRM.SDR F3LA200200310Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON 312 FLOOR BEAM UPPER CHORD. FABRICATED AND INSTALLED REPLACEMENT UPPER CHORD PER SRM 51-40-02, 51-40-06 AND SOPM 20-41-01.SDR F3LA200200309Floor Support · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON DIAGONAL FLOOR SUPPORT BETWEEN BS 1006 AND 1016, L/H. FABRICATED AND INSTALLED REPLACEMENT FLOOR SUPPORT PER SRM 53-60-51 ANDD 51-40-02.SDR F3LA200200307Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON FLOOR BEAM UPPER CHORD AT BS 294.5. FABRICATED REPLACEMENT PARTS AND INSTALLED REPAIR PER SRM 53-10-51, SRM 51-40-02 AND SOPM 20-41-02.SDR SIMA200228207Floorbeam · corrodedDURING AN IMBV INSPECTION, CORROSION WAS FOUND ON THE GALLEY CENTER FLOORBEAM. REMOVED CORRODED GALLEY CENTER FLOORBEAM INSTALLED NEW BEAM IAW SRM.SDR AUS20021207Floorbeam · corroded(AUS) FLOORBEAM UPPER T CHORD LOCATED AT STA 460 CORRODED. FOUND DURING CPCP INSPECTION.SDR SIMA200228220Floorbeam · corrodedDURING AN IMBV INSPECTION, THE DIGITAL WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. REMOVED DAMAGED SECTION OF THE FORWARD DIGITAL BY CUT OUT. FABRICATED A REPLACEMENT STRAP AND TWO DOUBLERS, SHIMS. REPAIR DONE IAW SRM.SDR AWXA200200985Attach Angle · crackedMCN - MAJOR REPAIR - DURING C12 CHECK A 1/4" CRACK WAS FOUND ON FLOOR SUPPORT ATTACH ANGLE AT BS 500D TO BS 520, BL 0. MAINTENANCE REMOVED THE DAMAGED FLOOR SUPPORT ATTACH ANGLE FROM BS 500D TO BS 520, FABRICATED A NEW REPLACEMENT FLOOR SUPPORT ATTACH ANGLE, SDR USAA020375Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED 25 SQUARE INCHES, FLOORBOARD INTERCOSTAL AT FRAME 16, 20 INCHES LEFT OF CENTER. CORROSION LEVEL 2. (M)SDR USAA020376Floorbeam · corrodedFOUND FLOORBEAM CORRODED 2 INCH AREA, FLOORBOARD INTERCOSTAL FRAME 16, 30 INCHES LEFT OF CENTER. CORROSION LEVEL 2. SPLICED IN NEW SECTION OF FLOORBEAM FROM FRAME 16 FORWARD PER SRM 53-11-14 FIG 202. (M)SDR USAA020377Floorbeam · corrodedTPA - FOUND FLOOR BEAM CORRODED 1 SQUARE INCH, OUTBOARD FLOORBEAM AT FLOORBOARD HOLE FORWARD OF GIRT BAR PAD. CLEANED AREA AND INSTALLED REPAIR ANGLE PER SRM 53-41-14 FIG 201, REPAIR PRINCIPAL 2. (M)SDR USAA020379Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED, LEFT AFT LAVATORY, AFT INBOARD LAVATORY MOUNT HOLE. DEFECTIVE PART REPLACED WITH IDENTICAL PART NR. (M)SDR USAA020378Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED, LEFT AFT LAVATORY, AFT OUTBOARD LAVATORY MOUNT HOLE. CORROSION LEVEL 2. DEFECTIVE PART REPLACED WITH IDENTICAL PART NR. (M)SDR SIMA200228223Floorbeam · corrodedDURING AN IMBV INSPECTION OF AIRCRAFT, CORROSION WAS FOUND ON THE LEFT HAND OMEGA BEAM AT FRAME 29. REMOVED CORROSION BY CUT OUT. FABRICATED AN EXTERNAL ANGLE, FILLER, TWO SHIMS. REPAIR DONE IAW SRM.SDR 2002UALA01508Floorbeam · crackedCABIN FLOOR BEAM INTERCOSTAL UPPER FLANGE IS CRACKED BODY STATION 500D-520, BL0, WL208. MAJOR REPAIR ACCOMPLISHED. REPLACED INTERCOSTAL UPPER FLANGE .SDR SIMA200228216Floorbeam · corrodedDURING AN IMBV INSPECTION THE RIGHT FLOORBEAM WAS FOUND TO BE CORRODED BEYOND SRM LIMITS AT FRAME 23. BLENDED THE DAMAGED AREA TO COMPLETELY REMOVED THE CORROSION. FABRICATED A U SHAPED DOUBLER. REPAIR DONE IAW SRM.SDR C2XA02SH068Floorbeam · corrodedSHV - DURING C CHECK THE GALLEY FLOORBEAM ANGLE WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED AN REPLACED FLOORBEAM ANGLE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR 2002UALA01500Floorbeam · corrodedCABIN FLOOR BEAM EXCESSIVE MATERIAL LOSS DUE TO CORROSION STATION 1640 RBL36-38.5 UPPER CAP. MAJOR REPAIR ACCOMPLISHED. REMOVED 2 STRAPS AND ANGLE INSTALLED.SDR 2002UALA01499Floorbeam · corrodedCABIN FLOOR BEAM AT STA 947 LBL 15 CORROSION REMOVAL EXCEEDED BLEND LIMITS. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE REPAIR.SDR AALA20021375Floorbeam · crackedTUL - FOUND FLOORBEAM CRACKED, FS 1022. FABRICATED NEW FLOORBOARD SUPPORT AND REPLACED AT STATION 1022 PER SRM 51-01. (M)
Back to JASC 5315