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 AALA984234Floorbeam · corrodedAFW - FLOORBEAM AT RBL 33 HAD CORROSION BLENDED BEYOND SRM LIMITS. ROTO-PEEN BLENDED AREAS PER SRM. ALODINED ALL BARE ALUM SURFACES FINISH BLENDED AREAS WITH 2 COATS BMS 10-11 PRIMER. FILL BLENDS WITH BMS PROSEAL 870. (M)SDR AALA984233Floorbeam · corrodedAFW - FLOORBEAM AT STATION 1565 LBL 77 HAD CORROSION BLENDED BEYOND SRM LIMITS. FABRICATE REPAIR STRAP OUT OF 301 1/2H STAINLESS STEEL .050 INCH THICK. ALODINE ALL BARE ALUMINUM SURFACE FINISH BLEND AND REPAIR PARTS WITH 2 COATS BMS10-11 PRIMER FILL BLENDS WSDR AALA984232Floorbeam · corrodedAFW - FLOORBEAM AT LBL 11 HAD CORROSION BLENDED BEYOND SRM LIMITS. ROTO-PEEN, BLENDED AREAS PER SRM. ALODINE ALL BARE ALUM SURFACES FINISH BLENDED AREAS WITH 2 COATS OF BMS10-11 PRIMER. FILL BLENDS WITH BMS5-95 PROSEAL 870. (M)SDR AALA984236Floorbeam · corrodedAFW - FLOORBEAM AT RBL 54 HAS CORROSION BLENDED BEYOND SRM LIMITS. ROTO PEEN BLENDED AREA PER SRM, ALODINED ALL BARE ALUM SURFACES. FINISH BLENDED WITH 2 COATS OF BMS10-11, PRIMER FILL BLENDS WITH BMS 5-95 PROSEAL 870. (M)SDR AALA984238Floorbeam · corrodedAFW - FLOORBEAM AT STAITON 325 RBL 20 HAD CORROSION BLENDED BEYOND LIMITS. REMOVED ALL CORROSION IAW REF C ALODINE, FINISH WITH TWO COATS FO BMS10-11, FILL WITH BMS 5-95. (M)SDR AALA984237Floorbeam · corrodedAFW - FLOORBEAM AT STATION 266 RBL 26 HAD CORROSION BLENDED BEYOND SRM LIMITS. FABRICATE REPAIR STRAP OUT OF 301.5 INCH STAINLESS STEEL .050 INCH THICK. ALODINE, FINISH BLEND AND REPAIR PARTS WITH 2 COATS OF BMS10-11 PRIMER, FILL BLENDS WITH BMS 5-92. INSTASDR CALA9802108Floorbeam · corrodedINSPECTION FOUND CORROSION UNDER NUT PLATE ON FLOORBEAM AT STA 218 LBL 54, UNDER FORWARD LAV FLOOR PANEL. A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-05, FIGURE 20A.SDR 99ZZZX314Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON UPPER CAP OF FLOORBEAM FS 1050, LBL 5 - RBL 33.SDR CALA9802097Floorbeam · corrodedINSPECTION FOUND AFT CARGO FLOORBEAM CORRODED AT STA 1070, RBL 12 TO 48. A REPAIR WAS INSTALLED IAW SRM 53-10-8.SDR CKSA98665Floorbeam · corrodedFLOORBEAM UPPER CAP 65B38085 AT AFT MAIN DECK ZONE 200, STA 1700 WL 199 LBL 18 TO LBL 23 HAS LEVEL 2 EXFOLIATED CORROSION ON AFT EDGE OF -3 CAP. REPAIRED IAW ASA CKF-AMD-127 SUPP SHT 1 AND 2. FOUND DURING ACCOMPLISHMENT OF CARGO CONVERSION, ROUTINE C-CHECK, SDR CKSA98663Frame · corrodedFLOORBEAM CAP LOCATED AT ZONE 200 AFT MAIN DECK, STA 2260, WL 199, RBL 44 HAS SCREW HOLE SHOWING CORROSION AREA OF 0.60 DIAMETER. REPAIRED IAW ASA CKF-AMD-115 SUPP SHT 1. FOUND DURING ACCOMPLISHMENT OF CARGO CONVERSION, ROUTINE C-CHECK, AND ACCOMPLISHMENT OFSDR CKSA98661Floorbeam · corrodedFLOORBEAM UPPER CAP AT ZONE 200, STA 2349 WL 199 LBL 32 HAS AREA 1 X 1 OF SEVERE CORROSION. DEPTH OF CORROSION EXCEEDS 20 PERCENT OF MATERIAL. REMOVED AND REPLACED THE 65B06161-7 UPPER CAP IAW BOEING DWG 65B06161 SHTS PL & 2. FOUND DURING ACCOMPLISHMENT OF SDR CKSA98655Floorbeam · corrodedUPPER CAP OF FLOORBEAM LOCATED ZONE 200 STA 1820 WL 200 FROM LBL 11 TO RBL 25, HAS AREA OF EXFOLIATED CORROSION COVERING APPROX 40 PERCENT OF CAP. REPLACED IAW SRM 51-30-02 DWG 65B17767. FOUND DURING ACCOMPLISHMENT OF CARGO CONVERSION, ROUTINE C-CHECK, AND ASDR CKSA98647Floorbeam · corrodedTOP SURFACE OF FLOORBEAM UPPER CAP AT STA 1740, WL 200, LBL 8 TO LBL 38 HAS 4 AREAS 1-2 DIAMETER WITH EXFOLIATED LEVEL 2 CORROSION. REPAIRED IAW DWG 65B38087 SHT 4. FOUND DURING ACCOMPLISHMENT OF CARGO CONVERSION, ROUTINE C-CHECK, AND ACCOMPLISHMENT OF CPCP SDR CKSA98646Floorbeam · corrodedTOP SURFACE OF FLOORBEAM UPPER CAP AT STA 1660, WL 200, LBL 33-39 HAS AREA 6 X 2.5 WITH EXFOLIATED LEVEL 2 CORROSION. REPAIRED IAW DWG 65B38083 SHT 2. FOUND DURING ACCOMPLISHMENT OF CARGO CONVERSION, ROUTINE C-CHECK, AND ACCOMPLISHMENT OF CPCP TASK CARDS AT SDR CKSA98644Floorbeam · corrodedSTA 1780 WL 200 RBL 24 THE TOP SURFACE OF UPPER CAP HAS AREA 1.20 X 2.50 OF LEVEL 2 CORROSION. REPAIRED IAW SRM 51-10-01 FIG 18.01. FOUND DURING ACCOMPLISHMENT OF CARGO CONVERSION, ROUTINE C-CHECK, AND ACCOMPLISHMENT OF CPCP TASK CARDS AT BOEING WICHITA (KIASDR CKSA98637Floorbeam · corrodedTOP CHORD OF FLOORBEAM AT UPPER DECK ZONE 230, STA 520, WL 307, LBL 27.99 TO LBL 46.65 HAS AREA 20 X 2 OF LEVEL 2 CORROSION. REPAIRED IAW DRAWING 65B10936 SUPP SHEET 1 AND 2. FOUND DURING ACCOMPLISHMENT OF CARGO CONVERSION, ROUTINE C-CHECK, AND ACCOMPLISHMENSDR CKSA89648Floorbeam · corrodedTOP SURFACE OF FLOORBEAM UPPER CAP AT STA 1720, WL 200, BL 0 TO LBL 108 HAS SEVERAL AREAS 1 INCH DIAMETER WITH EXFOLIATED LEVEL 2 CORROSION. REPAIRED IAW DWG 65B38134-6 ITEMS 2 AND 3. FOUND DURING ACCOMPLISHMENT OF CARGO CONVERSION, ROUTINE C-CHECK, AND ACCOSDR ABXA9801088Floorbeam · crackedDURING C-CHECK, FOUND FLOORBEAM AT STATION 680 AND LBL 54 CRACKED. REPLACED FLOORBEAM IAW DC9 SRM 51-30-1, 51-30-2, AND 51-30-5.SDR ABXA9801087Support · crackedDURING C-CHECK, FOUND FLOORBEAM SUPPORT CRACKED STATION 680 AND RBL 44. REPLACED SUPPORT FITTING IAW DC9 SRM 51-30-1 AND 51-30-2.SDR ABXA9801085Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM AT STATION 965 CORRODED FROM LBL 22 TO LBL 44. REPAIRED FLOORBEAM IAW ABX REA D953-25565MR.SDR SWAA982975Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORROSION AT BS 986.5, LBL 25, 40, 43, WL 208. REPAIRED PER BOEING SRM.SDR SWAA982950Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORROSION AT BS 328, RBL 14, WL 208. REPAIRED PER BOEING SRM.SDR RRXA98592Floorbeam · misdrilledDURING MAINTENANCE VISIT, FOUND FLOORBEAM AT FS 1700 WITH MISDRILLED HOLES IN UPPER HORIZONTAL FLANGE. REMOVED DAMAGED SECTION, TREATED AREA IAW DC-8 SRM 51-1-8, FABRICATED AND INSTALLED REPAIR ANGLES AND FILLERS IAW FAA DER APPROVED TIMCO ENGINEERING SKETCH SDR P2EA98290Floorbeam · crackedSJO - FLOORBEAM CRACKED AT BS 578, RBL 50, WL 206, DEFECT SIZE .5 INCH. REPAIRED FLOORBEAM WEB AT BS 578, BETWEEN RBL 45 INCHES TO RBL 70 INCHES, FROM WL 208 TO WL 204 PER SRM 51-30-2 AND 51-10-1 PAGE 5. (M)SDR ARWA981122Floorbeam · corrodedC-CHECK, CORROSION BLISTERS ON FLOORBEAM TOP FWD EDGE AT NUT PLATES STA 1140 BETWEEN NR 2 AND NR 4 SEAT TRACKS. REMOVED ENTIRE UPPER SECTION AND INSTALLED DOUBLER PER EO NR 98-924-04 0N 8110-3, DATED SEPT 24, 1998 UNDER WORK ORDER NR 1302.SDR USAA980597Floorbeam · corrodedCLT - DURING Q-1 CHECK VISUAL INSPECTION, FOUND .5 INCH BY .5 INCH AREA OF CORROSION AT STATION 947.5 LBL 14 TO RBL 33 FLOORBEAM. CORROSION TASK NR C53-107-02. SPLICED IN NEW 'T' CAP PER TR 53-60-02. (M)SDR USAA980590Floorbeam · corrodedCLT - DURING C-1 CHECK VISUAL INSPECTION, FOUND .5 INCH BY .5 INCH BY 37 INCHES OF CORROSION ON TOP OF FLOORBEAM AT STATION 377 LBL 25 TO RBL 12. FABRICATED 'T' CAP REPAIR AND SPLICE ANGLES PER SRM 53-00-51 PAGE 209-213E. (M)SDR SWAA982979Floorbeam · corrodedDURING SCHEDULED RON, FOUND COCKPIT FLOORBEAM CORROSION. REPAIRED PER BOEING SRM.SDR SWAA982972Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND A 2 INCH FLOORBEAM CRACK AT BS 540, RBL 45. REPAIRED PER BOEING SRM.SDR SWAA982971Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND A 2.3 FLOOR BEAM CRACK AT BS 540, LBL 24. REPAIRED PER SWA ACO 3198-53 AND BOEING DRAWING 65C34688.SDR RRXA98571Floorbeam · damagedDURING MAINTENANCE VISIT, FOUND FLOORBEAM UPPER FLANGE AT FS 960 WITH DRILL NICK AT 5.75 INCHES INBOARD OF LT CUSP. BLENDED AND REPAIRED IAW FAA DER APPROVED TIMCO ENGINEERING SKETCH REO-05539 AND TREATED AREA IAW DC-8 SRM 51-1-8.SDR MWEA981087Floorbeam · corrodedFLOORBEAM CORRODED STA 160 47 RBL BOTTOM SIDE. MTC REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR ANGLES.SDR EIAA980338Floorbeam · damagedHKG - DURING C1 CHECK, UPPER DECK FLOORBEAM HAS TEMPORARY REPAIRS AT BS 440 ON LEFT AND RIGHT SIDES. REPAIRED PER SRM 53-10-07 FIG 11, 8110-3 AND ECRA 470-53-98-1A. (M)SDR DL72K982462Floorbeam · corrodedAT MV2, FOUND CONTINUATION OF N/R 610. INSTALLED CAP PER SRM 53-10-9-11.SDR DL72K982461Floorbeam · corrodedAT MV2 FOUND FLOORBEAM CORRODED FS 344 RBL 20-LBL65. REMOVED CORROSION PER SRM 53-10-8 FIG 11. REMOVED T-CAP, FAB'D REPAIR, INSTALLED PER SAME. CONTINUED ON N/R 1043.SDR CALA9802067Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 328, LBL 50 TO RBL 50. THE CORRODED AREA WAS REMOVED AND AN UPPER CHORD REPAIR SPLICE WAS INSTALLED IAW SRM 53-10-51.SDR AALA982111Floorbeam · crackedTUL - FLOORBEAM WEB CRACKED TWO PLACES STATION 760 AT RBL 58 - RBL 62. STOP DRILLED CRACKS AND REPAIRED FRAME WEB PER SRM 51-40-2 PAGE 1-3 AND 51-40-2 PAGE 5 FIG 1 SHEET 5. TWO ROWS OF .25 INCH HI-LOCK UPPER AND LOWER, TWO ROWS .1875 HI-LOCKS INBOARD AND OUTSDR AALA982097Floorbeam · corrodedTUL - FLOORBEAM 380 HAS CORROSION ON TOP SURFACE STATION 380 RBL 49 INCH TO RBL 65 INCH, EXTENDING BELOW FLOORBOARD OUTBOARD SUPPORT CHANNEL. REPAIRED FLOORBEAM AT STATION 380, RBL 42-RBL 66 PER SRM 53-10-08, PAGES 9A AND 9B. (M)SDR AALA982096Floorbeam · corrodedTUL - STATION 344, LBL 15 INCH TO RBL 12 INCH CORROSION IN AND AROUND FASTENERS HOLES FLOORBEAM. REMOVED CORROSION AND CRACKED TOP CHORD FROM RBL 16 TO LBL 30. REPAIR PER SRM 53-10-8 FIG 9 AT RBL 16 AND ATTACHED TOP CHORD OF FLOORBEAM TO EXISTING SPLICE AT LSDR AALA982095Floorbeam · crackedTUL - FOUND STATION 344 RBL 15 INCHES FLOORBEAM UPPER FLANGE CRACKED. CUT OUT DAMAGED AREA OF FLOORBEAM. ACCOMPLISHED REPAIR IAW 53-10-8 FIG 9. (M)SDR EISA98266Floorbeam · corrodedROUTINE C-CHECK WORK CARD ACCOMPLISHMENT REVEALED CORROSION ON TOP OF FLOORBEAM FS 1110, LBL 15. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED FILLER AND DOUBLER PER SRM 53-10-8. (M)SDR USAA980571Floorbeam · crackedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND A 1.5 INCH CRACK STATION 520 LBL 24.75 FLOORBEAM. INSTALLED DOUBLER PER EA 62987 AND SB 737-53-1120 REV 1. (M)SDR USAA980570Floorbeam · crackedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND A 1.5 INCH CRACK STATION 520 RBL 24.75 FLOORBEAM. INSTALLED DOUBLER PER EA 62987 AND SB 737-53-1120 REV 1. (M)SDR GAIA98121Floorbeam · corrodedLEVEL 2 CORROSIO NFOUND DURING A TRANSITION LIGHT 'C' PHASE IN PLAN. MAIN CABIN FLOORBEAM HAS SURFACE CORROSION, TOP FLANGE, AT BS 1070 RBL 48 AND 53. REMOVED CORROSION FROM UPPER SURFACE OF FLOORBEAM IAW B727 SRM 53-10-01. FABRICATED REPAIR PARTS IAW BAC 7SDR GAIA98120Floorbeam · corrodedLEVEL 2 CORROSION FOUND DURNIG A TRANSITION LIGHT 'C' PHASE IN PLAN. MAIN CABIN FLOORBEAM TOP SURFACE HAS CORROSION AT BS 1070, RBL 53. REMOVED CORROSION FROM UPPER SURFACE OF FLOORBEAM IAW B727 SRM 53-10-01. INSTALLED REPAIR PARTS IAW B727 SRM 51-30-02 ANDSDR GAIA98117Floorbeam · corrodedLEVEL 2 CORROSION FOUND DURING A TRANSITION LIGHT 'C' PHASE IN PLAN. MAIN CABIN FLOOR CHORD AND UPPER ANGLE HAS SURFACE CORROSION AT BS 1176.9, LBL 61 - LBL 66. REMOVED CORRSOSION AND REPAIRED DAMAGED CHORD IAW AMERICAN INTERNATIONAL AIRWAYS EDR. ENGINEERINSDR GAIA98116Floorbeam · corrodedLEVEL 2 CORROSION FOUND DURING A TRANSITION LIGHT 'C' PHASE IN PLAN, MAIN CABIN FLOORBEAM HAS SURFACE CORROSION ON TOP FLANGE, BS 1110, RBL 43. REMOVED CORROSION IAW B727 SRM. FABRICATED REPAIR PARTS IAW B727 SRM. FABRICATED REPAIRPARTS IAW B727 SRM 53-10-8SDR DHL9872083DFloorbeam · corrodedAT D CHECK, FLOORBEAM CORRODED TOP AND BOTTOM SIDES OF UPPER FLANGE FS 1070 RBL 65. CUT OUT DAMGAGED AREA. INSTALLED REPAIR PER SRM 53-10-8, 2 BY 30, N/R 3668.SDR CALA9802060Floorbeam · corrodedINSPECTION FOUND COCKPIT FLOORBEAM CORRODED AT STA 242 FORWARD OF RT GEAR MANUAL EXTENSION. SUPPORT BRACKET AND FASTENERS WERE REMOVED AND A NEW BRACKET AND ANGLE SUPPORTS WERE INSTALLED IAW SRM 53-10-8 PAGE 52 AND 51-10-2 FIGURE 4.
Back to JASC 5315