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 SCNA97201Floorbeam · crackedDURING HEAVY MAINTENANCE VISIT, THE FLOORBEAM WEB AT STATION 950A TO 950B WAS FOUND CRACKED. REMOVED, FABRICATED AND INSTALLED NEW WEB IAW B727 SRM 51-20-1, 51-30-6, 51-10-2 AND MAINTENANCE MANUAL 51-20-11.SDR P5CA9701020Floorbeam · corrodedLEVEL 1 ZONE-C STATION 1100 RBL 101 FLOORBEAM FOUND CORRODED. CORROSION REMOVED AND REPROTECTED PER BOEING SRM 51-10-01 AND 51-10-02, PAINT TOUCH UP PER MM 51-24-11.SDR P5CA9700835Floorbeam · deformedAFT CARGO FLOORBEAM UPPER CHORD DEFORMED AT STA 1900 LBL 23. SMOOTHED OUT AND REPROTECTED PER BOEING SRM 51-10-02.SDR P5CA9700744Floorbeam · crackedCRACKED FLOORBEAM UPPER CHORD. REPAIRED PER BOEING SRM 51-40-04.SDR P5CA9700585Floorbeam · corrodedLEVEL 1 CORROSION, BS 520 RBL 9 TO 47 LONGIT, FLOORBEAM UPPER CHORD. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND MM 51-24-11.SDR P5CA9700584Floorbeam · corrodedLEVEL 1 CORROSION, ZONE C STA 1100 RBL 101 FLOORBEAM. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01, TREATED PER 51-10-02 AND 51-24-11.SDR DHL9770224DFloorbeam · corrodedAT D-CHECK, BS 344 FLOOR IS CORRODED LB 61 RBL 15. REMOVED CORROSION, OUT OF LIMITS FROM RBL 12 TO LBL 19. CUT OUT DAMAGED SECTION AND REINSTALLED UPPER CHORD REPAIR PER SRM 53-10-8, 32.5 LONG.SDR P5CA9700709Floorbeam · sheared rivetsRIVETS (2 EA) SHEARED AT FLOORBEAM UPPER CHORD AT STA 2040, LBL 15. REPLACED PER BOEING SRM 51-30-02.SDR P5CA9700708Floorbeam · missing rivetsRIVETS (4 EA) MISSING AT FLOORBEAM UPPER CHORD AT STA 2080 AND RBL 44. REPLACED PER BOEING SRM 51-30-02.SDR AU970570Web · cracked(AUS) UPPER DECK FLOOR BEAM UPPER WEB AT RBL63 CRACKED THROUGH FOUR FASTENER HOLES - CRACK LENGTH 127MM (5IN) - FOUND DURING INSPECTION IAW ENGINEERING DIRECTIVE 28/97 REVISION1SDR ASAA9710038Floorbeam · corrodedSEA - DURING C-CHECK, THE FLOORBEAM UPPER CHORD AT STATION 344 WAS FOUND TO BE CORRODED ON THE LOWER SURFACE OF THE HORIZONTAL FLANGE AT LBL 40. REPAIRED PER EA 5310-01519. (M)SDR AALA970950Floorbeam · corrodedAFW - FLOORBEAM AT STATION 1640 HAD CORROSION BLENDED BEYOND SRM LIMITS, E58 NR'S 1699029, 1699030, 1699032. REPAIRED PER MRB NR 757-1172. (M)SDR UPS97823144Floorbeam · corrodedINSPECTION TYPE:D, MAIN CABIN FLOORBEAM F/S 902 LBL 48 FWD LOWER FLANGE CORRODED BEYOND LIMITS REF N/R 535880. FABRICATED AND INSTALLED TWO SPLICES AND REPAIR IAW DHC SK 894-763A.SDR SWAA970484Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM STRAP AT BS 430, LBL 18.25, TO RBL 19 CORRODED AROUND NUT PLATE HOLES, TOP AND BOTTOM. REPAIRED PER BOEING SRM.SDR CALA9700776Floorbeam · corrodedINSPECTION FOUND CORROSION ON TOP OF FLOORBEAM AT STA 986.5. THE CORRODED AREA WAS CUT OUT AND A T-SECTION WAS INSTALLED IAW ECRA 5310-03450.SDR AALA970936Floor Beam · corrodedTUL - RBL 70 SA 380 CORROSION ON TOP OF FLOOR BEAM. CUT OUT CORROSION AND INSTALLED DOUBLER PER SRM CHAPTER 53-10-8 PAGES 9A AND 9B. REFERENCE ES8 22 01 431 FOR INSTALLATION OF FLOOR TRACK. TST: 55,741 HOURS. CYCLES, 34,503. (X)SDR AALA970934Floor Beam · corrodedTUL - CORROSION ON FLOOR BEAM, STA 380 RBL 13 - RBL 70. CUT OUT CORROSION AND INSTALLED DOUBLER PER SRM 53-10-8 FIG 1. TST: 55,741 HOURS. CYCLES, 34,503. (X)SDR AALA970933Floor Beam · crackedTUL - STA 760 RT RBL 70.5, APPROXIMATELY 6 INCH, 2 EACH, CRACKS IN LIGHTNING HOLE OF FLOOR BEAM LOWER OUTBOARD RADIUS UPPER I/A RADIUS .75 INCH PLUS 1 INCH LONG. REPLACED WEB SECTION AND ACCOMPLISHED TYPICAL WEB REPAIR 51-40-2 PG 6. TST: 55,741 HOURS. CYCSDR TWAA9810004Floorbeam · corrodedMCI - DURING OP 16 MAINTENANCE CHECK FOUND CORROSION OF FLOORBEAM NUT PLATE HOLE AREA FROM STA 703 TO STA 720, ABOVE S28L. REPAIRED PER SRM 51-40-4, AND STANDARD PRACTICES. INSTALLED DOUBLER. TOTAL TIME: 72,114 HOURS. TOTAL CYCLES: 78,035. (X)SDR DL73K970929Floorbeam · corrodedFLOORBEAM T-CAP FS 328 CORRODED AT LBL 27 AND FROM RBL12 TO RT SIDE OF FUSELAGE, C53-107-02. REMOVED ALL HARDWARE FROM DAMAGED BEAM SECTION. COMPLETED REMOVING DAMAGED SECTION. DRILLED REPAIR PARTS AND BEGAN INSTALLING REPAIR AND REPLACEMENT T-CAP PER M/M 5SDR 97FDEA00286Floorbeam · corrodedNR 0621 013, WHILE WORKING NR 0440 FOUND CORROSION ON FLOORBEAM BS 560, RBL 45, WL 208 UNDER SEAT TRACK. *S/D* REMOVED CORROSION AT BS 560, RBL 45, WL 208 ON FLOORBEAM UNDER SEAT TRACK FOUND TO BE OUT OF LIMITS IAW 727 FED-EX SRM 53-10-02. REPAIRED DAMAGED SDR 9710032293Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON FLOORBEAM UPPER SURFACE OF UPPER FLANGE FS 1030, LBL 13 TO RBL 24. REPAIRED PER EA 22-150313.SDR 9710022293Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD UPPER SURFACE FS 380, LBL 7 TO RBL 70. REPAIRED PER EA 22-150312.SDR SWAA970469Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES, BS 967.5, LBL 44 , WL 208. REPAIRED PER BOEING SRM.SDR SWAA970468Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES, BS 987, LBL 4.5, 33, 27, 21, WL 208. REPAIRED PER TRAMCO EWO 97-0212.SDR SWAA970467Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CRACKED AROUND FASTENER HOLE, BS 947, LBL 53. REPAIRED PER BOEING SRM.SDR CALA9700761Floorbeam · corrodedINSPECTION FOUND MAIN DECK FLOORBEAM CORRODED AT FS 520 LBL 24.5. NEW DOUBLERS WERE FABRICATED AND INSTALLED IAW SRM 51-30-2 AND 51-10-6.SDR AALA970953Floorbeam · corrodedAFW - FLOORBEAM AT STATION 324 HAS CORROSION REMOVAL ON SURFACE, MATERIAL REMAINING IS BEYOND SRM LIMITS REF E58 NR 1698996. REPAIRED PER MRB NR 757-1173. (M)SDR AALA970952Floorbeam · corrodedAFW - FLOORBEAM AT STATION 365 HAS CORROSION REMOVAL ON UPPER SURFACE, MATERIAL REMAINING BEYOND SRM LIMITS REF E58 NR 1699007. REPAIRED PER MRB NR 757-1170. (M)SDR EIAA970154Floorbeam · corrodedHKG - DURING C5/D-CHECK INSPECTION, DISCOVERED MID BS 2320 RBL 28-32 FLOORBEAM TOP FLANGE CORRODED. REPAIRS ACCOMPLISHED IAW SRM 53-10-07 FIGURE 8. (M)SDR EIAA970126Floorbeam · corrodedHKG - DURING C5/D CHECK INSPECTION, DISCOVERED UPPER DECK BS 400 RBL 60 FLOORBEAM CORRODED AT FASTENER HOLE. REPAIR ACCOMPLISHED IAW SRM 53-10-07 FIGURE 8 FROM RBL 40 T0 RBL 70. (M)SDR EIAA970125Floorbeam · corrodedHKG - DURING C5/D CHECK INSPECTION, DISCOVERED UPPER DECK BS 480 RBL 55 FLOORBEAM CORRODED. REPAIR ACCOMPLISHED IAW SRM 53-10-07 FIGURE 8. (M)SDR EIAA970096Floorbeam · corrodedDURING C-CHECK INSPECTION, DISCOVERED CORROSION ON THE UPPER SURFACE OF THE UPPER FLOORBEAM CHORD BETWEEN BS 1450-1460, RLB 57.7 BLEND OUT OF CORROSION EXCEEDED SRM LIMITS AND REQUIRES TRIMMING TO REMOVE CORROSION. REINFORCEMENT REPAIR ANGLES AND FILLER WERE SDR DHL9780528CFloorbeam · crackedAT C-CHECK, FWD CARGO COMPT AT STA 240L FLOORBEAM HAS A 6 INCH CRACK AT INTERSECTION OF LONGITUDINGAL STIFFENER. INSTALLED REPAIR PER DACO DRAWING D85310-7515 AND SRM 55-1-21.SDR 97FDEA00278Floorbeam · corrodedNR 0659 010, CORROSION (C53-111-0, 2) ON LOWER CHORD OF FLOORBEAM BS 600, LBL 18 TO RBL 18, WL 200. *S/D* REPAIRED LOWER CHORD OF FLOORBEAM AT BS 600, LBL 23, RBL 30 IAW FED-EX SRM 53-10-8.SDR UPS97223301Floorbeam · corrodedINSPECTION TYPE:SI, WHILE ACCESSING ON NRC 685905 INTERIOR 124 FOUND 880 FLOORBEAM LWR FLANGE TO BE CORRODED AT RBL 45 RBL 46 WL 201. REMOVED AND REPLACED 880 FLOORBEAM PER UPS ENGINEERING FILE NR B727-53-1427 INSTALLED FUEL FEED LINES AND SHROUD PER MM 28-22SDR AWXA9700315Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM STATION 312, WL 208, LBL 10. REPAIRED PER SRM 53-10-51.SDR 9709962293Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION AT NUTPLATE HOLES IN CABIN FLOORBEAM LOWER CHORD FS 1130, RBL 28 TO 40. REPAIRED PER EA 22-124025.SDR 97FDEA00285Floorbeam · corrodedNR 0390 012, CORROSION (C53-224-02) ON FLOORBEAM BS 620, WL 208, LBL 7 TO LBL 21 AND AROUND NUT PLATE AT LBL 47. *S/D* WHILE REMOVING CORROSION FOUND CRACK IN UPPER CHORD IN EXISTING REPAIR AT LBL 20, STA 620 TO BE OUT OF LIMITS PER FED-EX SRM 53-10-1. REMOSDR AU970569Chord · cracked(AUS) UPPER DECK CHORD AT LBL 60 CRACKED - FOUND DURING REPAIR OF FLOOR BEAM FOUND IN MDR 97/0568SDR ABXA9700990Floorbeam · corrodedDURING C-CHECK, FOUND THE FLOORBEAM AFT LOWER FLANGE HEAVILY CORRODED AT F/STA 965 AND LBL 10. REPAIRED IAW ABX REA D953-19401-MR.SDR SWIA97973Floorbeam · corrodedLEFT FORWARD OMEGA BEAM CORRODED THROUGH TOP SIDE. REPLACED LEFT FORWARD OMEGA BEAM WITH NEW ONE.SDR SWIA97956Floorbeam · corrodedON FLOORBEAM LBL 27-00 AT FS 345 ON OUTBOARD WING OF BEAM, CORROSION AT RIVETS. FABRICATED AND INSTALLED A DOUBLER REPAIR ON FLOORBEAM LBL 27 AT FS 345.SDR SWIA97955Floorbeam · corrodedON FLOORBEAM RBL 27-00 AT FS 336 CORROSION AT OUTBOARD NUT PLATE. FABRICATED AND INSTALLED A DOUBLER REPAIR ON THE FLOORBEAM IAW MM.SDR SWIA97954Floorbeam · corrodedON FLOORBEAM RBL 9-00 AT FS 345 HAS CORROSION AT INBOARD NUT PLATE. FABRICATED AND INSTALLED DOUBLER REPAIR ON THE FLOORBEAM RBL 9-00 AT 345 IAW.SDR SWIA97953Floorbeam · corrodedON FLOORBEAM LBL 9-00 AT FS 348 CORROSION AT INBOARD NUT PLATE. FABRICATED AND INSTALLED BACK UP ANGLE ON FLOORBEAM LBL 9-00 AT FS 348 IAW MM SRM 51-40-02.SDR CALA9700722Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED IN CENTER CARGO COMPARTMENT AT STA 1701. REPAIRED IAW SRM 53-60-01, FIGURE 2.SDR ABXA9700989Floorbeam · corrodedDURING C-CHECK, FOUND THE FLOORBEAM AT F/STA 965, LBL 47 LOWER FLANGE HEAVILY CORRODED. REPAIRED IAW ABX REA D953-19407-MR.SDR COMA9710252Floorbeam · corrodedON 2C TASK 5310-132-01I, THE RT FLOORBEAM T-SECTION AT FRAME 16 WAS FOUND CORRODED. REPLACED PER SRM STANDARD PRACTICES.SDR COMA9710251Floorbeam · corrodedON 2C TASK 5310-131-01I, THE LT CABIN FLOORBEAM T-SECTION AT FRAME 16 WAS FOUND CORRODED. REPLACED PER SRM STANDARD PRACTICES.
Back to JASC 5315