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 AWXA200200389Floorbeam · corrodedGYR - MAJOR REPAIR - DURING C-11 CHECK EXFOLIATION CORROSION FOUND ON UPPER HORIZONTAL FLANGE AT BS 1681. NUMEROUS AREAS OF CORROSION FROM LBL 50 - RBL 53. MAINTENANCE CUT OUT CORROSION AND INSTALLED REPAIR PARTS PER AWA ER 19-5360-02119-JS1.SDR 2002UALA00658Floorbeam · corrodedCABIN FLOORBEAM HAD CORROSION MATERIAL REMOVED EXCEEDS LIMITS, STATION 345 RBL 52 UPPER FLANGE AFT SIDE. MAJOR REPAIR ACCOMPLISHED. UPPER CAP REPAIRED.SDR C2XA02TY068Floorbeam · corrodedTYS DURING A SCHEDULED 1C/2C INSPECTION THE LEFT OMEGA BEAM HAS CORROSION IN THE GALLEY AREA. MAINTENANCE FABRICATED AND INSTALLED REPAIR IAW EMB135/145 SRM 53-21-10.SDR C2XA02TY066Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE CENTER FLOORBEAM UNDER THE LAVATORY WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER FLOORBEAM IAW EMB-SRM 51-40-02, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSSDR 0201635530Floorbeam · crackedDURING "L" CHECK FOUND CRACK IN FLOORBEAM AT BS 700 LBL 25. REPAIRED PER EA 55-189610.SDR SIMA200210204Floorbeam · corrodedABI - DURING INSPECTION OF AIRCRAFT, FOUND PREVIOUSLY REPAIRED GALLEY FLOOR FRAME 258 CORRODED. FABRICATED AND REPLACED DOUBLER, FILLER, AND TWO TRIPLERS IAW SAAB 340 SRM 53-70-30 AND STANDARD SRM PRACTICES. (M)SDR 2002UALA00653Floorbeam · corrodedAFT CABIN FLOORBEAM AT STATION 946 RBL 20 HAS EXCESSIVE MATERIAL LOSS DUE TO CORROSION REMOVAL. MAJOR REPAIR ACCOMPLISHED. INSTALLED REINFORCEMENT ANGLE.SDR 2002UALA00651Floorbeam · corrodedCABIN FLOOR BEAM UPPER CHORD STATION 1640 LBL 56 HAS EXCESSIVE MATERIAL REMOVED. MAJOR REPAIR ACCOMPLISHED. FLOORBEAM UPPER CHORD AFT FLANGE REPAIRED AND STRAP INSTALLED.SDR CALA0200184Floorbeam · corrodedINSPECTION FOUND UPPER CAP(ANGLE) OF FLOORBEAM CORRODED IN E&E COMPARTMENT OVERHEAD AT STA 120, RBL 15 TO RBL 30. THE ANGLE WAS REMOVED AND A NEW ANGLE AND REPAIR SPLICES WERE INSTALLED IAW SRM 51-10-4.SDR AALA20020443Floorbeam · corrodedAFW - FOUND FLOORBEAM AT BL33 LEFT AND RIGHT STATION 890 AND STATION 933 HAD CORROSION BLEND FROM TOP SURFACE BEYOND SRM LIMITS. SEE ATTACHED DRAWINGS. REQUEST ENG APPROVAL TO SHOT-PEEN, ALODINE, 2 COATS OF PRIMER AND SEAL W/BMS 5-95. REMOVED CORROSION PER SDR SIMA200210203Floorbeam · corrodedDURING INSPECTION OF AIRCRAFT, FOUND CORROSION ON GALLEY CENTER BEAM. REPLACED GALLEY CENTER BEAM IAW EMB 145 EMB SRM 145 51-40-02, GST-1128/02, AND STANDARD SRM PRACTICES. (M)SDR 2002UALA00646Floorbeam · corrodedAFT CABIN STATION 947 FLOORBEAM RBL 24 TO RBL 47 HAD CORROSION ON UPPER CAP WITH EXCESSIVE MATERIAL REMOVED DURING CORROSION REMOVAL. MAJOR REPAIR ACCOMPLISHED. INSTALLED 2 REPAIR ANGLES.SDR SIMA200210001Floorbeam · corrodedDURING AN HMBV INSPECTION OF AIRCRAFT, FOUND GALLEY FLOOR FRAME 272 CORRODED. REMOVED CORROSION BY CUT OUT. FABRICATED A DOUBLER ANGLE, A FILLER, AND A SHIM. WORK DONE IAW SAAB 340 SRM 53-70-30 AND STANDARD SRM PRACTICES. (M)SDR 2002UALA00640Floorbeam · corrodedCABIN FLOORBEAM AT STATION 365 RBL 43 HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. EXCESSIVE MATERIAL WAS REMOVED AND A STRAP REPAIR APPLIED.SDR SIMA20021003Floorbeam · corrodedABI - DURING AN MBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON LEFT OMEGA BEAM AT FRAME 20. REMOVED CORROSION BY CUT OUT. FABRICATED A DOUBLER, FILLER, AND TWO SHIMS. WORK DONE IAW EMB145 SRM 145/1142, CHAPTER 53, REV 17, 53-21-10, AND STANDARD SRM PRACTICESDR SIMA200210701Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING. RIGHT OMEGA BEAM HAS CORROSION BETWEEN FRAMES 23 AND 25. FABRICATED DOUBLER IAW EMB145 SRM 51-40-02, 51-40-06, 51-20-03 AND GST-1169/02. (M)SDR AWXA200200280Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON FLOOR SUPPORT BEAM AND NUTPLATES IN THE AFT CARGO COMPARTMENT AT BS 727+6, LBL 2.5. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS BEYOND LIMITS IAW B737 300 SRM 53-60-53, FIG 101, SHT 8. FABSDR 2002F00586Floorbeam · crackedAT C-CHECK, FOUND FORWARD CABIN FLOORBEAM CRACKED IN RADIUS 1.5 INCHES LONG AT STATION 326 RBL 24. (M)SDR 2002UALA00615Floorbeam · corrodedBODY STATION 852-870 LBL 55 FLOORBEAM T-CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM T-CAP.SDR U2RB040202Floorbeam · corrodedDURING CPCP 18 MONTH INSPECTION, AFT ACCESSORY COMPARTMENT INTERIOR. DETECTED LEVEL 2 CORROSION OF UPPER TEE OF FORWARD FLANGE OF FLOORBEAM 11.5 INCHES INBOARD OF RIGHT FUSELAGE CUSP LINE 1.75 INCHES LONG.SDR SWAA020708Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 845, LBL 12. REPAIRED FLOORBEAM PER SWA RA.SDR 200200196Floorbeam · corrodedCORROSION ON BS 400 FLOORBEAM AT RBL 70. SECTION OF FLOORBEAM UPPER AFT CHORD IS SPLICED IN FROM RBL 30 TO THE RT SIDE OF BODY PER ECRA 479-53-161-2.SDR SIMA200210706Floorbeam · corrodedTHIS IS A LEVEL 2 FINDING. LEFT OMEGA BEAM HAS CORROSION BETWEEN FRAMES 22 AND 23. BLENDED CORROSION, PERFORMED NDT, RESTORED PROTECTIVE FINISH, ACCEPTED AS IS IAW EMB GST-1140/02. (M)SDR SIMA200210707Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING. LEFT OMEGA BEAM CORRODED AT FRAME 25. BLENDED CORROSION, PERFORMED NDT, RESTORED PROTECTIVE FINISH, ACCEPTED AS IS IAW EMB 145 GST-1140/02. (M)SDR COOSDR020100Floorbeam · corrodedMAIN CARGO CABIN, FLOORBEAM LOWER CHORD ON STA Y980 BETWEEN +X45 TO -X25 CORRODED.SDR COOSDR020099Floorbeam · corrodedMAIN CARGO CABIN, FLOORBEAM LOWER CHORD ON STA Y857 BETWEEN +X60 TO -X60, CORRODED.SDR COOSDR02050Floorbeam · corrodedMAIN CARGO COMPONENT, STA 1680, Z0, +X7 INCHES AND X 15 INCHES, FLOOR BEAM UPPER CHORD CORRODED.SDR 2002UALA00619Floorbeam · corrodedBODY STATION 790 RBL 12-14 FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM SPLICE.SDR 2002UALA00616Floorbeam · corrodedBODY STATION 1197+88 LBL 40-41 FLOORBEAM UPPER CHORD CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED UPPER CHORD T-CAP.SDR 2002UALA00610Floorbeam · corrodedCABIN FLOORBEAM BODY STATION 440 UPPER SURFACE HAS EXCESSIVE MATERIAL LOSS DUE TO REMOVAL OF CORROSION AT RBL 4 TO RBL 5.5. MAJOR REPAIR ACCOMPLISHED. STRAP REPAIR INSTALLED.SDR 2002UALA00609Floorbeam · gougedCABIN FLOORBEAM BODY STATION 640 LBL 4 TO LBL 17 HAS EXCESSIVE MATERIAL REMOVED DUE TO GOUGE IN CENTER O/B BEAM. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP AND NESTED ANGLE REPAIR.SDR SWAA020686Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 663, BL-0. REPAIRED FLOORBEAM PER SWA RA.SDR EIAA2002025Floorbeam · corrodedMZJ - NUMEROUS HOLES IN UPPER FLOORBEAMS AT STATIONS 340, 360, AND 380 WERE FOUND TO HAVE CORROSION. REPAIRED PER ECRA 53-162-2. (M)SDR EIAA2002030Floorbeam · corrodedMZJ - FOUND DURING C-CHECK, STATION 400 FLOORBEAM AT RIGHT SIDE, 70 INCHES FROM BUTT LINE 0 WAS FOUND CORRODED. REPAIRED PER ECRA 479-53-262-2. (M)SDR SWAA020667Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED FROM BS 770 TO 846, LBL 8.0. REPAIRED FLOORBEAM PER SWA RA.SDR AWXA200200330Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A 1 INCH CRACK WAS FOUND ON THE CABIN FLOORBEAM UPPER TEE CHORD AND WEB AT BS 660, LBL 0.07. MAINTENANCE FABRICATED AND INSTALLED REPAIR PARTS IAW AWA ER 03-5717-02098-KB1.SDR AWXA200200329Web · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A 1" CRACK WAS FOUND ON THE CABIN FLOOR BEAM UPPER TEE CHORD AND WEB AT BS 660, LBL 0.07. MAINTENANCE REMOVED DAMAGED AREA OF WEB AT BS 660, LBL 0.07, FABRICATED 2 EACH REPAIR ANGLES, 3 EACH STRAPS, 2 EACH SPLICE PLATES, SDR 2002UALA00603Floorbeam · corrodedBODY STATION 832 RBL II TRANSBEAM UPPER CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SPLICES.SDR SIMA200209333Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND GALLEY AREA FORWARD DIGITAL, LEFT SIDE, CORRODED. REMOVED CORROSION BY BLENDING. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. REPAIRED IAW EMB GST -1014/02 ITEM 4B, AND STANDARD SSDR SIMA200209331Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND GALLEY AREA FORWARD DIGITAL (RIGHT SIDE) CORRODED. REMOVED CORROSION BY BLENDING. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED DOUBLER. WORK DONE IAW EMB GST-1014/02, SDR SIMA200210009Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING. FORWARD DIGITAL HAS CORROSION AROUND FASTENERS AT FRAME 16. REPAIRED CORROSION IAW EMB GST-1067/02. (M)SDR SIMA200210005Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING. OMEGA BEAM HAS CORROSION AT FRAME 20. FABRICATED A DOUBLER FILLER AND SHIMS AND INSTALLED IAW EMB135 SRM 53-21-10, 51-40-02. (M)SDR AALA20020392Floorbeam · corrodedTUL - FOUND CORROSION ON UPPER ANGLE AFT SIDE OF FLOORBEAM STATION 160 RBL 12. INSTALLED FLOORBEAM TEE CAP REPAIR ON TOP SIDE OF FLOORBEAM STATION 160 FROM RBL 1 TO RBL 18 PER 53-05 FIG 20B SHEET 2. (M)SDR 2002UALA00579Floorbeam · corrodedCABIN FLOORBEAM STATION 986 RIGHT HAND OUTBOARD WAS CORRODED WITH EXCESSIVE MATERIAL REMOVED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE, INSTALLED REPAIR ANGLE AND FILLERS.SDR SWAA020669Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED FROM BS 757 TO 947, RBL 12.0. REPAIRED FLOORBEAM PER SRM.SDR SWAA020664Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED FROM BS 793 TO 825, LBL 3. REPAIRED FLOORBEAM PER SRM.SDR AWXA200200323Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-12 CHECK EXFOLIATION CORROSION WAS FOUND ON THE UPPER SURFACE OF FLOORBEAM AT BS 947.5, LBL 2-4. MAINTENANCE FABRICATED AND INSTALLED REPAIR STRAP IAW B737-300 SRM 53-00-51, PG 212-215.SDR AWXA200200322Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-12 CHECK EXFOLIATION CORROSION WAS FOUND ON THE UPPER SURFACE OF FLOORBEAM AT BS 947.5, LBL 13-17. MAINTENANCE FABRICATED AND INSTALLED REPAIR IAW B737-300 SRM 53-00-51 PG 212, 215 AND SRM 51-20-01 PG 1.SDR 2002UALA00578Floorbeam · corrodedBODY STATION 1562 LBL 58 FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR PARTS AND BEAM.SDR 2002UALA00577Floorbeam · corrodedBODY STATION 850-855 RBL 33 FLOORBEAM T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM T-CAP.
Back to JASC 5315