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 USAA980297Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 1.3750 INCH AREA OF CORROSION ON FLOORBEAM STA 106 LBL 18. INSTALLED T-CAP PER TR 53-10-05C. (X)SDR SIMA981733Floorbeam · corrodedSAW - DURING CPCP8 INSPECTION, FOUND FLOORBEAM 36 CORRODED. REMOVED AND REPLACED FLOORBEAM 36. (X)SDR CALA9801147Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CAP IN FORWARD GALLEY AREA CORRODED AT FS 294.5, RBL 8. THE FLOORBEAM CAP WAS REPAIRED IAW SRM 53-10-51.SDR ABXA9800568Floorbeam · crackedWHILE COMPLYING WITH C-INSPECTION, FOUND A FLOORBEAM AT FS 718 CRACKED AT RBL 48. REPLACED FLOORBEAM IAW DC9 SRM CHAPTERS 51-30-1, 51-30-2 AND 51-30-5.SDR UF6A980611Floorbeam · corrodedSBN - FLOORBEAM AT FORMER BS 378 HAS CORROSION. MAINTENANCE CUT OUT SECTION OF CORROSION AND FABRICATED NEW ANGLE FROM 2024-T3 .183 INCH IAW ENGINNERING REPORT NR 98-080. ACFT TT: 14,252 HOURS. (X)SDR SWAA981197Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOORBEAM AT BS 312, RBL 7 TO 25 LBL 10 TO 12, WL 207 TO 208. REMOVED AND REPLACED PER BOEING SRM.SDR AALA981240Floorbeam · corrodedTUL - HEAVY CORROSION ON TOP OF FLOORBEAM RBL 55 TO 62, STATION 460. TOP CAP OF FLOORBEAM RBL 55 TO 62. REMOVED FLOORBEAM, REPAIR PERFORMED PER 53-10-8 PAGE 9A. (M)SDR UPS98227292Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION (C53-224-01.05-01) ON UPPER CHORD OF FLOORBEAM AT FASTENER HOLE BS 312, LBL 3, WL 208. CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. FABRICATED AND INSTALLED REPAIR IAW SRM 53-10-8, 51-30-5, 51-30-2, AND MM 51-20-151.SDR UPS98227099Floorbeam · corrodedINSPECTION TYPE:SI CORROSION (C53-224-01.05-01) ON UPPER CHORD OF FLOORBEAM AT BS 328 LBL 45. CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REMOVED DAMAGE FROM BEAM AND INSTALLED STANDARD REPAIR PER SRM 53-10-8, 53-10-2 AND 51-30-2.SDR UPS98227096Floorbeam · corrodedINSPECTION TYPE:SI CORROSION (C53-224-01.05-01) ON UPPER CHORD OF FLOORBEAM AT FASTENER HOLE BS 312, LBL 3, WL 208. CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. FABRICATED AND INSTALLED REPAIR IAW SRM 53-10-8, 51-30-5, 51-30-2 AND MM 51-20-151.SDR SIMA981697Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND FLOORBEAMS 36 AND 38 CORRODED. REMOVED AND REPLACED BOTH FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR B4MR98067Floorbeam · crackedDURING ROUTINE CPCP INSPECTION, FOUND FLOORBEAM STA 760 RBL 44 HAS 2 INCH CRACK ON LOWER LEG. REPAIRED FLOORBEAM IAW AIA DRAWING 2730 AND EDR B2-05617. CORROSION TASK CARD NUMBER C53-224-01. NON-ROUTINE TASK CARD NUMBER 114273. AMERICAN INTERNATIONAL AIRWASDR B4MR98065Floorbeam · corrodedDURING ROUTINE CPCP INSPECTION, FOUND BS 312, BETWEEN LBL 10 AND LBL 30, FLOORBEAM WITH SIGNS OF CORROSION AT LWR AFT FACE. REMOVED DAMAGED PART AND FABRICATED NEW PARTS AND HEAT TREATED IAW B727 SRM 51-20-2 AND 51-10-3. TREATED AND PRIMED IAW SRM 51-10-2 MMSDR B4MR98056Floorbeam · corrodedDURING ROUTINE CPCP INSPECTION, FOUND FS 1110 TOP OF FLOORBEAM IN SEVERAL AREAS CORRODED. REPAIRED TOP OF FLOORBEAM AS PER BOEING 727 SRM 53-10-8 PAGE 44 FIG 8. CORROSION TASK CARD NUMBER C53-224-01. NON-ROUTINE TASK CARD NUMBER 114046. AMERICAN INTERNATIOSDR B4MR98049Floorbeam · corrodedDURING ROUTINE CPCP INSPECTION, FOUND BS 720 RBL 35 FLOORBEAM CORRODED AROUND NUT PLATES. CUT OUT DAMAGED AREA THAT WAS FOUND TO BE OUT OF LIMITS IAW SRM 51-10-06. REPAIRED IAW 727 SRM 53-10-8. CORROSION TASK CARD NUMBER C53-224-01. NON-ROUTINE TASK CARD NSDR 98ZZZM512Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND FLOORBEAMS 36 AND 38 CORRODED. REMOVED AND REPLACED BOTH FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR USAA980256Floorbeam · crackedINT - DURING Q-5 CHECK VISUAL INSPECTION FOUND CRACK .25 INCH LONG STATION 722 TO 725 BL '0' LONGITUDINAL FLOORBEAM. INSTALLED DOUBLER, REPAIRED PER SRM 51-40-2 AND BOEING DRAWING 65C34537. (M)SDR USAA980255Floorbeam · crackedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND 1 INCH LONG CRACK STATION 707 TO 714 LBL 25 INCHES LONGITUDIAL FLOORBEAM. INSTALLED DOUBLER, REPAIRED PER SRM 51-40-2. (M)SDR USAA980254Floorbeam · crackedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND 1.5 INCH CRACK BL '0' AT BS 661 FLOORBEAM. INSTALLED REPAIR ANGLES, REPAIRED PER BOEING REPAIR DRAWING 65C34537. (M)SDR USAA980253Floorbeam · crackedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND 1 INCH CRACK BS 707-714 25 INCH RBL WL 203.5 LONGITUDIAL FLOORBEAM WEB. CUTOUT CRACKED AREA AND INSTALLED WEB REPAIR, REPAIRED SRM 51-40-2. (M)SDR TWAA9810605Floorbeam · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND SURFACE CORROSION TOP SIDE OF FLOORBEAM, STATION 996 RBL 22 IN TO RBL 50 INCH. REPLACED ANGLE PER SRM 51-01 AND STD PRACTICES. (M)SDR SWAA981165Floorbeam · corrodedDURING SCHEDULED 1/4 D-CHECK, FOUND CORRODED FLOORBEAM UPPER AND LOWER SURFACE AT BS 770 LBL 17, FLOORBEAM AT BS 767 TO 787 RBL 13 UPPER SRFC, BS 770 RBL 3 AND BS 787 TO 847 LBL 12. REMOVED AND REPLACED PER BOEING SRM.SDR USAA980270Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM UPPER FLANGE STATION 294 RBBL 1.0. CORROSION TASK CARD NR C 53-107-01. REPLACED 'T' CAP PER SRM 53-10-51. (M)SDR USAA980269Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM UPPER FLANGE STATION 344 FROM BL 0 TO RT GALLEY DOOR. CORROSION TASK CARD NR C53-107-01. REPLACED 'T' CAP PER TR 53-10-03. (M)SDR USAA980268Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORROSION ON UPPER FLANGE OF FLOORBEAM STATION 344 FROM LBBL 13.0 TO 28.0. CORROSION TASK CARD NR C53-107-01. REPLACED 'T' CAP PER TR 53-10-03. (M)SDR USAA980234Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORROSION ON UPPER FLANGE OF FLOORBEAM STATION 312 AT BL 0 UPPER CHORD. CORROSION TASK CARD NR C53-107-01. INSTALLED DOUBLER REPAIR PLATES ON UPPER FLANGE (FWD) PER REPAIR DOCUMENT SRM 51-70-12. (M)SDR USAA9802267Floorbeam · corrodedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND CORROSION ON UPPER FLANGE OF FLOORBEAM UPPER CHORD. CORROSION TASK CARD NR C53-107-01. REPLACED 'T' CAP PER TYPICAL REPAIR NR 53-10-03. (M)SDR SWAA981156Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM HOLE AT BS 344, LBL 9 AND BS 344, RBL 1. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981146Floorbeam · corrodedDURING SCHEDULED 1/4 D-CHECK, FOUND CORROSION UNDER FLOORBEAM NUT PLATE AT BS 504 LBL 13.5, BS 505 LBL 8.5 AND BS 504 RBL 2.5. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981144Floorbeam · corrodedDURING SCHEDULED 1/4 D-CHECK, FOUND CORRODED FLOORBEAM HOLE AT BS 294, LBL 47. REMOVED AND REPLACED PER BOEING SRM.SDR DL72W981344Floorbeam · corrodedCORROSION AT FLOORBEAM STA 344 FROM LBL 13 TO RBL 17-MARKED. REPAIRED PER SRM 53-10-8 FIG 11.SDR SWAA981138Floorbeam · corrodedDURING SCHEDULED 1/4 D-CHECK, FOUND CORRODED FLOORBEAM NUT PLATE AT BS 429, RBL 8.5. REPAIRED PER BOEING SRM.SDR SWAA981136Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM BS 1006 AT FLOOR PANEL HOLE LBL 26. REPAIRED PER BOEING TYPICAL REPAIR TI NR A53-014.SDR SWAA981135Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED CARGO TIE DOWNS AT BS 787, STR 26R. REMOVED AND REPLACED PER BOEING SRM.SDR QXEA9800893Floorbeam · crackedCRACK IN FLOORBEAM UNDER FORWARD GALLEY AT STATION 3845 APPROXIMATELY 18 INCHES INBOARD FROM PASSENGER SERVICE EMERGENCY DOOR. REPAIRED IAW FOKKER SRM 53-11-05, PAGE 10, FIGURE 3, SRM 53-02-01 PAGE 7 FIGURE 5.SDR VJ9800268Floorbeam · corrodedAFT PIT FLOORBEAM HAS CORROSION BEYOND LIMIT UNDER NUT PLATES AT FS 965, BL17L AND 19L. REMOVED AND REPLACED FLOORBEAM AND 2 Z-ANGLES IAW DC9 SRM 51-10-3, 51-10-4, 51-30-2, 51-30-5 AND 53-11-3. REINSTALLED, RIGGED AND OPS CHECKED STAB TRIM CABLES AND ENGINESDR CALA9801055Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 980, LBL 12. A REPAIR WAS FABRICATED AND INSTALLED IAW SRM 51-10-3, 53-05, FIGURE 20A, AND 51-30-2.SDR AALA984142Floorbeam · corrodedAFW - FOUND FLOORBEAM CORRODED FOUND DAMAGE TO EXCEED SRM LIMITS AFTER BLENDING. ALODINED BLENDED AREA. FABRICATED AND INSTALLED REPAIR STRAP USING 0.050 INCH 301 1/2 HARD STAINLESS STEEL. APPROVED BY ENGINEERING PER MRB 767-1646. TST: 27,257.02 HOURS. SDR SWAA981120Floorbeam · corrodedDURING SCHEDULED 1/2 D CHECK, FOUND FLOORBEAM CORRODED AT BS 312, BL0. REPLACED PER BOEING SRM.SDR QXEA9800894Floorbeam · bentRHS FLOORBEAM AT BL 600R BETWEEN FRAME 16060 AND 16660 HAS BENT LOWER FLANGE. REPAIRED IAW HORIZON AIR EA 4-53-450.SDR CALA9801045Floorbeam · gougedINSPECTION FOUND FLOORBEAM GOUGED AT STA 968. THE GOUGED SECTION OF FLOORBEAM WAS CUT OUT. AN L-ANGLE DOUBLER AND FILLER WERE FABRICATED AND INSTALLED IAW SRM 53-05, FIGURE 20A, 53-05, 51-10-3, 51-30-2, AND 51-20-0.SDR CALA9801006Floorbeam · gougedINSPECTION FOUND AFT PIT UPPER FLOORBEAM GOUGED AT STA 917. A REPAIR DOUBLER AND FILLER WERE FABRICATED AND INSTALLED IAW SRM 53-05, FIGURE 86, 51-30-1, AND 51-30-2.SDR CALA9801001Floorbeam · corrodedINSPECTION FOUND LT FLOORBEAM AT BS 996, LBL 18 CORRODED. AN UPPER CAP WAS FABRICATED AND INSTALLED IAW SRM 51-30-0 AND 51-10-1.SDR TWAA9809805Floorbeam · corrodedMCI - DURING CHECK-C, MAINTENANCE FOUND CORROSION ON RT FLOOR SUPPORT ANGLE FROM STA 370 TO STA 418, AT RT SERVICE DOOR THRESHOLD. REPLACED ANGLE PER SRM 51-10-1, AND TWA STD PRACTICES. TOTAL TIME: 47,795 HOURS. TOTAL CYCLES: 30,953. (X)SDR SIMA981594Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THAT FLOORBEAM 33 AND 39 WS CORRODED. MAINTENANCE REPAIRED FLOORBEAM 33 AND 39 IAW SRM 53-00-00. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA981593Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE FLOORBEAM 36 AND 38 WAS CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAM 36 AND 38 IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 98ZZZM481Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THAT FLOORBEAM 33 AND 39 WS CORRODED. MAINTENANCE REPAIRED FLOORBEAM 33 AND 39 IAW SRM 53-00-00. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 98ZZZM480Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE FLOORBEAM 36 AND 38 WAS CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAM 36 AND 38 IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SWAA981107Floorbeam · damagedDURING SCHEDULED D-CHECK, FOUND DAMAGED FLOORBEAM WEB AT BS 328, RBL 35, WL 206. REPAIRED PER BOEING SRM.SDR TWAA9809803Floorbeam · corrodedMCI - DURING CHECK-C, MAINTENANCE FOUND CABIN FLOOR SUPPORT AT STA 418 WITH CORROSION FROM RBL 44 INTO OTBD END OF SUPPORT. NEW SUPPORT INSTALLED PER SRM 51-10-1, PAGES 4 AND 4A. TOTAL TIME: 47,795 HOURS. TOTAL CYCLES: 30,953. (X)
Back to JASC 5315