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 MWEA020270Fitting · crackedCRACKED VERTICAL FLOOR BEAM SUPPORT ANGLE ATTACH FITTING AT STATION 927, 44 INCHES TO THE LEFT OF CENTER. -- REMOVED AND INSTALLED NEW FITTINGS.SDR USAA020179Floorbeam · corrodedPIT - FOUND T-CAP FLOORBEAM CORRODED 2 INCHES LONG, FLOORBEAM STATION 328 AT LBL 28. CORROSION LEVEL 1. INSTALLED REPAIR DOUBLER AND NEW T-CAP PER SRM 53-10-51, PAGE 220. (M)SDR SIMA200212101Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON FORWARD DIGITAL. REMOVED CORROSION BY CUT OUT. PERFORMED AN NDT INSPECTION OF THE AREA AND FOUND NO REJECTABLE INDICATIONS. FABRICATED A REPLACEMENT STRAP, TWO DOUBLERS AND A SHIM IAW EMB 145 (SDR 2002UALA00748Floorbeam · corrodedFLOORBEAM AT BODY STATION 335 RBL 16 TO RBL 24 HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. REPLACED FLOORBEAM.SDR CALA0200223Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM UPPER CAP CORRODED AT STA 312. A SPLICE REPAIR WAS INSTALLED IAW SRM 53-10-51.SDR SIMA200212129Floorbeam · corrodedSAW - DURING CPCP2, FOUND FLOORBEAM 38 CORRODED ON TOP AND BOTTOM SIDES AND AROUND NUTPLATE HOLES. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (M)SDR UPS02438164Floorbeam · corrodedINSPECTION TYPE:C U/D - BS 540 LBL 20-40 FLOORBEAM FOUND CORROSION AS MARKED. FLOORBEAM REPAIR AT BS 540 LBL 30 TO LBL 55 AS PER SRM 53-10-07 FIG 21.SDR F3LA200200132Floorbeam · corrodedDURING C-2 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM TRACK TIE IN AFT CARGO COMPARTMENT, STA 772, RBL 13.80. REMOVED CORRODED AREA, FABRICATED AND INSTALLED REPAIR PER SRM 53-00-53.SDR 2002UALA00732Threshold · corrodedAFT CARGO PIT THRESHOLD LOWER BEAM PREVIOUS REPAIR HAD SEVERE EXFOLIATION CORROSION AT REPAIR ANGLE AND BOTH SPLICE PLATES STATION 1436 TO STATION 1383. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE. INSTALLED FILLER SECTION AND TWO EA REPAIR ANGLES.SDR CALA0200221Bulkhead · corrodedINSPECTION FOUND BULKHEAD CORRODED FORWARD OF FIRST OFFICER'S I/B SEAT TRACK AT FS 120, LBL 30 TO RBL 58. THE BULKHEAD WAS REPAIRED IAW SRM 53-01, FIGURE 2.SDR CALA0200219Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER T CAP CORRODED AT FASTENER HOLES, STA 294.5, LBL 20 TO RBL 58. REPAIRED IAW SRM 53-10-51.SDR USAA020162Floorbeam · corrodedPIT - FOUND FLOOR SUPPORT/BEAM CORRODED 8 INCHES LONG, LEFT AFT SIDE NOSE GEAR STATION 270 BL 0 WL 217 FLOORBEAM. CORROSION LEVEL 2. INSTALLED DOUBLERS AND REPAIR ANGLES PER TYPICAL REP 53-20-08 AND EA 73795. (M)SDR SIMA200212128Floorbeam · corrodedSAW - DURING CPCP2 FOUND FLOORBEAM 30 CORRODED. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA200212142Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, FORWARD DIGITAL CORRODED. INSTALLED SERVICEABLE SECTION OF FORWARD DIGITAL IAW EMB 145 SRM 53-21-10. (M)SDR SIMA200212146Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, LEFT OMEGA BEAM REPAIR CORRODED AT FRAME 20. REPAIRED IAW EMB145 SRM 51-40-02, 51-20-03 AND 53-21-10. (M)SDR 2002UALA00737Floorbeam · corrodedMAIN CABIN STATION 852, RBL 55, TRANSBEAM UPPER CHORD CORRODED BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED. FABRICATED REPAIR SECTION AND INSTALLED.SDR 2002UALA00734Floorbeam · corrodedMAIN CABIN STATION 852 LBL 55, TRANSBEAM T-CAP UPPER CHORD CORRODED BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED. FABRICATED REPAIR SECTION AND INSTALLED.SDR CALA0200216Floorbeam · corrodedINSPECTION FOUND FLOORBEAM T-CAP CORRODED AT FASTENER HOLES, STA 344. REPAIRED IAW SRM 51-10-51.SDR AWXA200200388Seat Track · corrodedYWG - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON FRAME (SEAT TRACK) AT Y254 R/H, FROM FR 16-20. MAINTENANCE REMOVED SEAT TRACK FROM FR 16-20, Y254 R/H PER DWG 053112729, FABRICATED NEW SEAT TRACK AND INSTALLED REPAIR IAW A320 SRM 51-44SDR AWXA200200384Floorbeam · corrodedYWG - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND FLOORBEAM AT Y765 RT, FR 67-68. MAINTENANCE REMOVED CORRODED FLOORBEAM FROM FR 67-70, Y765 RT, FABRICATED AND INSTALLED A NEW FLOORBEAM IAW A320 SRM 53-41-14, FIG 8 PG 34B.SDR 02FDEA00278Floorbeam · corrodedCORROSION ON UPPER FLANGE OF FLOORBEAM BS 312, LBL 3-19. REMOVED AND REPLACED FLOORBEAM PER DWG SR 27-53-017A.SDR SIMA200212106Floorbeam · corrodedABI - DURING AN MBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON LEFT OMEGA BEAM AT FRAME 20. REMOVED CORROSION BY CUT OUT. FABRICATED A DOUBLER ANGLE, FILLER, TWO SHIMS. WORK DONE IAW EMB 145 SRM 145/1141, CHAPTER 53, REV 17 53-21-10, AND STANDARD SRM PRACTISDR SIMA200212156Floorbeam · corrodedABI - DURING AN MBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON LEFT OMEGA BEAM AT FRAME 20. REMOVED CORROSION BY CUT OUT. FABRICATED A DOUBLER ANGLE AND FILLER. REPAIRED IAW EMB 145 SRM 145/1142, CHAPTER 53, REV 17 53-21-10, AND STANDARD SRM PRACTICES. (M)SDR AWXA200200385Floorbeam · corrodedYWG - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND FLOOR SUPPORT RAIL BEAM AT Y765 RT, FR 68. MAINTENANCE REMOVED CORRODED FLOOR SUPPORT RAIL BEAM FROM FR 66-70, Y765 RT, FABRICATED AND INSTALLED A NEW FLOOR SUPPORT RAIL BEAM IAW A320 SRM SDR 2002UALA00723Floorbeam · corrodedCABIN FLOORBEAM UPPER CAP HAD CORROSION ON UNDER SIDE AT STATION 365 AT APPROX RBL 36 STRINGER 17R. MAJOR REPAIR ACCOMPLISHED. REMOVED PORTION OF UPPER T-CAP AND USED SPLICE REPAIR IN INSTALLING NEW UPPER T-CAP.SDR ASOA02216Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, THE TOP AND BOTTOM SURFACES WERE CORRODED ON THE TOP FLANGE OF THE FLOORBEAM AT FRAMES 36, 38, 39 AND 40. MAINTENANCE REPAIRED THE CORRODED FLOORBEAM TOP FLANGES IAW ASA EO 72-53-0130. (M)SDR UPS02438178Floorbeam · crackedINSPECTION TYPE:C AFT COMPT - BS 1880 LBL 20 FLOORBEAM UPPER CHORD FOUND CORRODED CRACKED. AFT COMPT BS 1880 LBL 20 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-10-01 FIG 2.SDR UPS02438179Floorbeam · corrodedINSPECTION TYPE:C AFT COMPT - BS 1880 LBL 26 FLOORBEAM UPPER CHORD FOUND CORRODED. AFT COMPT - BS 1880 LBL 26 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-10-01 FIG 01.SDR 02FDEA00270Floorbeam · corrodedCORROSION ON LWR LONG FLOORBEAM UNDER NUT PLATES FROM BS 1030 TO 1060, WL 200, LBL 2 TO RBL 2. *S/D* REMOVED AND REPLACED FLOORBEAM PER SRM 51-30-5, 51-20-1 & 51-30-2.SDR 2002UALA00708Floorbeam · corrodedCABIN FLOORBEAM STATION 1640 DAMAGED AND CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED T-CAP.SDR 02FDEA00262Floorbeam · corrodedCORROSION ON LWR LONG FLOORBEAM UNDER NUT PLATES FROM BS 1030 TO 1160, WL 200, LBL 2-RBL 2. REMOVED AND REPLACED FLOORBEAM PER SRM 51-30-5, 51-20-1, 51-30-2 & BAC 1506-1706.SDR 02FDEA00263Floorbeam · damagedHOLES IN FLOORBEAM AT BS 420, RBL 60-65, WL 208. REMOVED AND REPLACED FLOORBEAM PER EA 7-5335-54192.SDR 02FDEA00266Floorbeam · damagedHOLES IN FLOORBEAM AT BS 400, RBL 60-65, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8 FIG 3 & EA 7-5335-54192.SDR 02FDEA00265Floorbeam · damagedHOLES IN FLOORBEAM AT BS 380, RBL 60-65, WL 208. REMOVED AND REPLACED FLOORBEAM PER EA 7-5335-54192 & SRM 53-10-8 FIG 3.SDR 02FDEA00264Floorbeam · damagedHOLE UPPER FWD FLANGE OF FLOORBEAM BS 480, RBL 49, WL 208. REMOVED AND REPLACED FLOORBEAM PER EA 7-5335-54192 & SRM 53-10-8 FIG 3.SDR 02FDEA00280Floorbeam · damagedHOLES IN FLOORBEAM AT BS 400, RBL 60-65, WL 208. REMOVED AND REPLACED FLOORBEAM PER EA 7-5335-54192 & SRM 53-10-8 FIG 3.SDR SIMA200212116Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, PREVIOUS REPAIR AT LEFT OMEGA BEAM AT FRAME 20 IS CORRODED. REPAIR DONE IAW EMB145 SRM 53-21-10, FIG 201. (M)SDR SIMA200212109Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, GALLEY FORWARD DIGITAL CORRODED. REPAIRED GALLEY FORWARD DIGITAL IAW EMB145 SRM 53-21-10. (M)SDR SIMA200212141Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, FORWARD GIGITAL IN GALLEY HAS CORROSION. INSTALLED REPAIR DOUBLER IAW EMB GST-1140/02 AND 1169/02. (M)SDR SIMA200212140Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, RIGHT OMEGA BEAM CORRODED AT FRAME 25. BLENDED CORROSION, PERFORMED NDT INSPECTION. RESTORED SURFACE FINISH, IAW EMB GST-1140/02. (M)SDR 02FDEA00256Floorbeam · damagedFOUND HOLES IN FLOORBEAM BS 440, RBL 60-65, WL 208. REMOVED AND REPLACED FLOORBEAM PER EA 7-5335-54192 & SRM 53-10-8 FIG 3.SDR TSAA0251107Floorbeam · crackedFOUND A 2.5 INCH CRACK AT BS 710 FLOORBEAM BBL .07 ON THE WEB. CUT OUT DAMAGED AREA ON THE WEB. FABRICATED A REPAIR DOUBLER IAW FIGURE 6. INSTALLED DOUBLER, STIFFENERS AND FILLERS. REPAIR COMPLETED IAW ECO 2223 R1. AIRCRAFT RETURNED TO SERVICE. (M)SDR TSAA0251106Floorbeam · crackedFOUND A CRACK AT FUSELAGE STATION 665 FLOORBEAM BL 0 ON THE UPPER CHORD. FABRICATED AND INSTALLED REINFORCING DOUBLER, STIFFENERS, FILLERS, SPLICE PLATE AND ANGLE. REPAIR COMPLETED IAW ECO 2223 R1 PART II DEVIATION D. AIRCRAFT RETURNED TO SERVICE. (M)SDR SWIA200210854Floorbeam · corrodedCENTER OMEGA BEAM AT BUTT STRAP SPLICE A BEAM LAV HAS VISIBLE CORROSION EXTENDING MORE THAN 10 PERCENT INTO MATERIAL. REMOVED AND REPLACED THE CENTER OMEGA BEAM IAW SRM 51-40-02.SDR 2002UALA00679Floorbeam · corrodedFORWARD CABIN FLOORBEAM AT STATION 297 RBL 40 CORRODED. MAJOR REPAIR ACCOMPLISHED DOUBLER REPAIR INSTALLED.SDR 2002UALA00678Floorbeam · corrodedFLOORBEAM AT STATION 365 RBL18 MATERIAL LOSS BEYOND 10 PERCENT LIMIT FORWARD EDGE. MAJOR REPAIR ACCOMPLISHEDFILLER INSTALLED AND TWO EACH ANGLES NESTED UNDER FLOORBEAM CAP.SDR SIMA200210710Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND CORROSION IN TWO AREAS, FORWARD AND AFT, ON FORWARD DIGITAL. REMOVED CORROSION BY BLENDING AREAS. FABRICATED TWO REPAIR DOUBLERS. REPAIR DONE IAW EMB GST-1140/02, DAMAGE NR 9, GST-1169/02, ITEM 4, AND STANDARD SRM PRACSDR SIMA200210712Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON RIGHT OMEGA BEAM BETWEEN FRAMES 23 AND 25. REMOVED CORROSION BY BLENDING. PERFORMED AN NDT INSPECTION OF THE AREA AND FOUND NO REJECTABLE INDICATIONS. FABRICATED A REPAIR DOUBLER. REPAIR DONE SDR 2002UALA00676Floorbeam · gougedBS 287, RBL 14 - LBL 10, FLOORBEAM GOUGED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SECTION AND SPLICES.SDR C2XA02TY070Floorbeam · corrodedTYS DURING A SCHEDULED 1C/2C INSPECTION, THERE WAS EVIDENCE OF CORROSION IN THE LEFT AND RIGHT SIDES OF THE CARGO COMPARTMENT FLOORBEAMS AT THE BULKHEAD AREA. MAINTENANCE REMOVED AND REPLACED THE LT AND RT FORWARD FLOORBEAMS IAW 135/145 SRM 51-40-02-03 AND 5
Back to JASC 5315