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 SWAA020647Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT RBL 3.0, BS 727D TO BS 847. REPAIRED FLOORBEAM PER SWA RA.SDR 2002UALA00567Floorbeam · corrodedFLOORBEAM T-CAP CORRODED UNDER NUT PLATE BODY STATION 153, LBL 10. MAJOR REPAIR ACCOMPLISHED. REPAIRED T-CAP WITH FABRICATED NEW SECTION AND SPLICE.SDR SWAA020640Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, WL 208 AND LBL 25.5. REPAIRED FLOORBEAM PER SRM.SDR SIMA200209307Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, LEFT OMEGA BEAM CORRODED BETWEEN FRAMES 58 AND 59. REMOVED CORRODED, ACCEPTED AS IS IAW EMB GST-1014/02, RETREATED AREA IAW EMB 145 CPM 51-21-04, 51-21-05. (M)SDR SIMA200208802Floorbeam · corrodedABI - DURING INSPECTION OF AIRCRAFT, FOUND FORWARD DIGITAL IN GALLEY AREA CORRODED. REMOVED CORROSION BY CUT OUT. FABRICATED A STRAP, DOUBLERS AND A SHIM IAW EMB145 SRM 145-1142 CHAPTER 53, REV 17, 53-21-10, AND STANDARD SRM PRACTICES. (M)SDR UPS02537963Floorbeam · corrodedINSPECTION TYPE:MOD FLOORBEAM CORRODED STA 1200 TOP SURFACE LBL 25 - 45.SDR 2002UALA00547Splice · gougedSTATION 880, RBL 33, TRANSBEAM INBOARD SPLICE IS GUOGED BEYOND LIMITS. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SPLICE.SDR 2002UALA00546Splice · gougedSTATION 880, RBL 54, TRANSBEAM OUTBOARD SPLICE GOUGED BEYOND LIMITS. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR SPLICE.SDR 2002UALA00544Clip · brokenFLOOBEAM ATTACH CLIP BROKEN STATION 390LH, FORWARD PIT ABOVE STRINGER 33L. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW CLIP.SDR 2002UALA00543Clip · brokenFLOOR BEAM ATTACH CLIP BROKEN STATION 434 LFT HAND, FORWARD PIT ABOVE STRINGER 33L. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED CLIP.SDR 2002UALA00542Cap · corrodedCABIN STAION 832-RBL 11, TRANSBEAM UPPER CAP IS CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPAIRED AND INSTALLED WITH SPLICE BEAM.SDR 2002UALA00541Cap · corrodedCABIN STATION 832, RBL 11, TRANSBEAM UPPER CAP IS CORRODED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPAIRED AND INSTALLED SPLICE.SDR USAA020149Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH AREA, STATION 344 BL0 BEAM. CORROSION LEVEL 2, FABRICATED SECTION, SPLICE ANGLES PER 53-10-51. (M)SDR SIMA200208805Floorbeam · corrodedABI - DURING INSPECTION OF AIRCRAFT, FOUND CORROSION ON LEFT OMEGA BEAM AT FRAME 24 BEYOND SRM LIMITS AFTER BLENDING. REMOVED CORROSION BY CUT OUT. FABRICATED A DOUBLER ANGLE, FILLER, AND TWO SHIMS. REPAIRED IAW EMB145 SRM (SRM 145-1142 CHAPTER 53, REV 17) SDR SIMA200209406Floorbeam · corrodedSAW - DURING CPCP2 INSPECTION, FOUND FLOORBEAM 40 TO BE CORRODED. REPLACED FLOORBEAM 40 IAW ATR 42 SRM 51-25-02. (M)SDR SIMA200209402Floorbeam · corrodedSAW - DURING CPCP2 INSPECTION, FOUND FLOORBEAMS 36, 38, AND 39 TO BE CORRODED BEYOND LIMITS. REPLACED FLOORBEAMS IAW ATR 42 SRM 51-25-02. (M)SDR SWAA020603Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 727B, LBL 2 TO LBL 12. REPAIRED FLOORBEAM PER SWA RA.SDR F3LA200200116Floorbeam · corrodedDURING C-2 CHECK, INSPECTION REPORTED FLOORBEAM AT R-2 DOOR CORRODED. FABRICATED AND INSTALLED REPAIR PER SRM 53-60-51 AND 53-00-51 FIG 203.SDR ASOA02191Floorbeam · corrodedDURING C-CHECK FOUND INSPECTION IN BNA, THE LOWER AFT FLOOR FLANGE AT FRAME 13 WAS CORRODED. MAINTENANCE REPAIRED THE CORRODED FLOOR FLANGE IAW SRM 51-40-02. (M)SDR 2002UALA00518Floorbeam · corrodedBODY STATION 800-852 LBL 54.81 TRANSVERSE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR SPLICES.SDR 2002UALA00517Floorbeam · corrodedBODY STATION 852 RBL 54-81 TRANSVERSE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR SPLICES.SDR DL75A020335Floorbeam · corrodedTHE UPPER CAP OF THE FS 1681 FLOORBEAM WAS FOUND WITH SEVERAL AREAS OF CORROSION. THE UPPER CAP WAS TRIMMED OFF TO REMOVE ALL AREAS OF CORROSION. A NEW CAP WAS FABRICATED AND INSTALLED PER ER/A 382554-14, REV A.SDR 2002UALA00494Floorbeam · corrodedFORWARD CABIN FLOOR BODY STATION 365 RBL 15 TO RBL 48 T-CAP HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. REPLACED T-CAP.SDR 2002UALA00492Floorbeam · corrodedCABIN STATION 850, LBL 33, TRANSBEAM UPPER CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED. REPAIRED TRANSBEAM WITH NEW SECTION AND SPLICE ANGLES.SDR 2002UALA00488Floorbeam · crackedCABIN FLOORBEAM STATION 303, RBL 88 IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM NEW SECTION WITH SPLICE ANGLES.SDR 2002UALA00473Floorbeam · crackedFOUND 2 EA APPROX 3.0 INCH CRACKS BOTH SIDES OF UPPER FLANGE ON FWD CARGO FLOORBEAM AT STA 676 UNDER THE RIGHT SIDE AUXILIARY GUIDE. CRACK EXTENDS INTO UPPER FLANGE FILLET. MAJOR REPAIR ACCOMPLISHED. MANUFACTURED AND INSTALLED REPAIR.SDR 2002UALA00499Floorbeam · corrodedCABIN FLOORBEAM UPPER FLANGE HAS CORROSION STATION 324 RBL 50 TO 60. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP AND ANGLE REPAIR.SDR 2002UALA00496Floorbeam · corrodedCABIN FLOORBEAM STA 310 RBL 40 HAS EXCESSIVE MATERIAL LOSS FROM CORROSION REMOVAL. MAJOR REPAIR ACCOMPLISHED. INSTALLED TWO STRAPS REPAIRS ON EACH SIDE OF T-FLANGE.SDR C2XA02TY054Floorbeam · corrodedTYS, DURING A SCHEDULED INSPECTION THE FORWARD DIGITAL, AFT OF THE COCKPIT DOOR WAS FOUND CORRODED.SDR C2XA02TY050Beam · corrodedTYS, During a scheduled inspection the center omega beam between FR18 and FR24 was found corroded. Maintenance removed and replaced the omega beam. I/A/W-EMB-SRM-51-40-02 and 51-21-02. Repair procedures where satisfactory and the aircraft will be released uponSDR 2002UALA00497Channel · corrodedCABIN FLOOR SUPPORT CHANNEL HAD EXCESSIVE CORROSION ON UPPER SURFACE BETWEEN STATION 310 AND 324 RBL 40" STRINGER 17R. MAJOR REPAIR ACCOMPLISHED.INSTALLED NEW OUTSIDE CENDER NEW CHANNEL INTERCOSTAL FLOOR SUPPORT.SDR ASOA02164Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, THE CABIN FLOOR CENTER OMEGA BEAM HAD CORROSION THAT WAS BLENDED OUT OF LIMITS AT FRAME 16. MAINTENANCE REPAIRED THE FLOOR CENTER OMEGA BEAM IAW ASA EO 120-53-0175. THIS EO REFERENCES EAC FAX GST-0894/02, DATED 18 MARCH 2002SDR 2002UALA00462Floorbeam · corrodedBODY STATION 800 LBL 11 TRANSBEAM UPPER CHORD IS CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED TRANSBEAM AND SPLICES.SDR 2002UALA00461Floorbeam · corrodedBODY STATION 852 RBL 33 TRANSBEAM CORRODED ON UPPER CAP. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR SPLICES.SDR 2002UALA00446Crease Beam · corrodedFORWARD CABIN RIGHT HAND CREASE BEAM BODY STATION 297-377, RBL 64 HAS EXCESSIVE MATERIAL LOSS ON INBOARD CHORD. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPLACED CHORD.SDR 2002UALA00445Intercostal · corrodedCABIN BODY STATION 400 WL 208 RBL40, FLOORBEAM INTERCOSTAL TOP SURFACE DAMAGED FROM EXCESSIVE MATERIAL LOSS. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. REPLACED INTERCOSTAL.SDR 2002UALA00443Floorbeam · corrodedBODY STATION 324 FLOORBEAM CAP RBL 55 CORRODED. MAJOR REPAIR ACCOMPLISHED. FLOORBEAM CAP DOUBLER REPAIR INSTALLED.SDR 2002F00430Floorbeam · corrodedDURING SCHEDULED INSPECTION LEVEL 2 CORROSION DISCOVERED ON CABIN FLOORBEAM UPPER CAP, FS 901, WL 200, LBL 115 TO RBL 14. MAINTENANCE REPAIRED THE FLOORBEAM IN ACCORDANCE WITH LOCKHEED SRM 53-21-00, FIGURE 815.SDR 2002UALA00436Floorbeam · corrodedSTATION 1681 RBL 49 FLOORBEAM HAS EXCESS MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. REPAIR DOUBLER STRAP INSTALLED.SDR 2002UALA00427Floorbeam · corrodedCABIN FLOORBEAM BODY STATION 310 RBL 39 IS CORRODED ON UPPER SURFACE. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR STRAP AND NESTED ANGLE T-CAP ON FLOORBEAM.SDR 2002UALA00426Floorbeam · corrodedFLOORBEAM CORRODED, STATION 365 RBL 618. MAJOR REPAIR ACCOMPLISHED. ANGLE REPAIR INSTALLED.SDR AWXA200200292Floorbeam · corrodedMAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON THE TOP OF FLOORBEAM AT BS 986.5, LBL 58. MAINTENANCE CLEANED CORROSION OFF FLOORBEAM AND FOUND MATERIAL LOSS EXCEEDING ALLOWABLE LIMITS. FABRICATED FLOORBEAM REPAIR STRAP AND INSTALLED REPAIR PART AT BSSDR AWXA200200279Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON FLOOR SUPPORT BEAM AND NUTPLATES IN THE AFT CARGO COMPARTMENT AT BS 727D+6, LBL 7.5. MAINTENANCE REMOVED CORROSION IAW B737-300 SRM 51-10-2, PG. 24, FABRICATED 2 EACH REPAIR ANGLES FROM 7075-0-.071,SDR AWXA200200278Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOOR SUPPORT BEAM AND NUTPLATES IN THE AFT ACRGO COMPARTMENT AT BS 860, LBL 7.5. MAINTENANCE FABRICATED 3 EACH REPAIR ANGLES, TREATED AND PRIMED, AND INSTALLED REPAIRS IAW B737-300 SRM SDR AWXA200200277Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOOR SUPPORT BEAM IN THE AFT CARGO COMPARTMENT AT BS 860, RBL 7.5. MAINTENANCE FABRICATED 2 EACH REPAIR ANGLES, TREATED AND PRIMED ANGLES, AND INSTALLED REPAIR PARTS IAW B737-300 SRM 53SDR AWXA200200276Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON FLOOR SUPPORT BEAM AND NUTPLATE IN THE AFT CARGO COMPARTMENT AT BS 860, LBL 2.5. MAINTENANCE REMOVED THE NUTPLATE AND CLEANED CORROSION ON FLOOR SUPPORT BEAM AT FS 860, LBL 2.5 IAW 51-40-02 PG 1, 53SDR AWXA200200275Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON FLOOR SUPPORT BEAM IN THE AFT CARGO COMPARTMENT AT BS 773, RBL 2.5. MAINTENANCE CLEANED CORROSION ON FLOOR SUPPORT BEAM AT FS 773, RBL 2.5 AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS. FABRICATED 2 ESDR DL73K020299Floorbeam · crackedCENTER WING / LONGITUDINAL OVERWING FLOORBEAM / BL 24.82 / FS 678 : CHORD AND WEB CRACK REPAIR INSPECTION OF THE LBL & RBL 24.82 LONGITUDINAL FLOORBEAMS PER AD 2001-17-18 REVEALED TYPICAL CRACKS IN THE BEAM WEB, WEB DOUBLER, AND UPPER CHORD AT FS 678 AT THE SDR AWXA200200274Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON AFT CARGO PIT RT FLOOR SUPPORT BEAM BS 727D+6, RBL 7.5. MAINTENANCE REMOVED CORROSION AND MATERAIL REMAINING .039, FABRICATED 2 EACH REPAIR ANGLES FROM 7075-0.071, 7075-0-.081, HEAT TREATED IAW B737SDR AWXA200200270Floorbeam · crackedLCQ - MAJOR REPAIR - DURING C-15 CHECK A CRACK WAS FOUND RUNNING FROM SEAT TRACK FLOORBEAM TEE CAP LOWER EDGE TO A FASTENER HOLE ON INBOARD SIDE, BS 663.75, RBL 26. FABRICATED A REPAIR STRAP, SHIMS AND INSTALLED REPAIR PARTS IAW B737-300 SRM 51-40-02 PG 10 AN
Back to JASC 5315