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 CALA9800513Floorbeam · tornINSPECTION FOUND WEB IN AFT CARGO BILGE AREA TORN AND DISTORTED AT FLOORBEAM, STA 1841, STRINGER 44L. THE DAMAGED AREA OF WEB WAS TRIMMED AND BLENDED OUT. THE AREA WAS REINFORCED WITH DOUBLER IAW SRM 53-00-01, 51-21-01, AND 51-31-01.SDR AALA980538Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM END FITTING RT SIDE AT FRAME 61. REMOVED AND REPLACED FLOORBEAM END FITTING PER SRM 51-72-10-0. (M)SDR TWAA9809108Floorbeam · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND FLOORBEAM CAP AT FS 160 TO 196, RBL 44, CORRODED BEYOND LIMITS. INSTALLED NEW FLOORBEAM PER SRM 51-01, PAGE 1 ITEM C. (M)SDR SWAA980321Floorbeam · corrosionDURING SCHEDULED D CHECK, FOUND CORROSION ON FLOORBEAM UPPER AND LOWER AT BS 986, RBL 44, WL 208. REPAIRED PER BOEING SRM.SDR SIMA980763Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED FLOORBEAM 38 CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAM 38 IAW SRM 53-25-03. A/C WAS RETURNED TO SERVICE. (M)SDR RRXA98174Floorbeam · damagedDURING A MAINTENANCE VISIT, FOUND FLOORBEAM WITH TOOL DAMAGE AT STA 857.188 BL 25 RIGHT. FABRICATED AND INSTALLED REPAIR DOUBLER IAW FAA APPROVED DER TIMCO ENGINEERING SKETCH REO-04472.SDR CALA9800485Floorbeam · brokenINSPECTION FOUND INTERIOR UPPER LOBE CABIN FLOORBEAM BROKEN AT STA 1275, RBL 103. THE FLOORBEAM WAS REPAIRED IAW ECRA 5320-01511 AND ENGINEERING ORDER MF MAN D10-53-896798.SDR CALA9800484Floorbeam · brokenINSPECTION FOUND INTERIOR UPPER LOBE CABIN FLOORBEAM BROKEN AT STA 1293, RBL 103. THE FLOORBEAM WAS REPAIRED IAW ECRA 5320-01511 AND ENGINEERING ORDER MF MAN D10-53-896798.SDR P2EA98073Floorbeam · corrodedSJO - Q-CHECK, FLOORBEAM CORRODED BEYONDED LIMITS AT BS 1006, BETWEEN LBL 12 INCHES AND RBL 4 INCHES. REPAIRED FLOORBEAM PER SRM 53-10-4 FIG 2. (M)SDR SWAA980315Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FLOORBEAM STIFFENER AT BS 328 RBL 32.5, WL 200. REPAIRED PER BOEING SRM.SDR SWAA980314Floorbeam · corrosionDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 344 LBL 25, 20.5, 17, 14, 7, RBL 8.5, WL 207 AND 208, BS 328 RBL 15 AND 28.5 WL 208, 207. REPAIRED PER BOEING SRM.SDR SWAA980313Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FLOORBEAM AT BS 328 LBL 45 WL 206, BS 328.5 LBL 45 WL 207. REPAIRED PER BOEING SRM.SDR SWAA980305Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 947.5 RBL 54. REPAIRED PER BOEING SRM.SDR 9807459941Floorbeam · crackedDURING M CHECK, FOUND CRACK IN FLOORBEAM UPPER FLANGE AT FS 321 JUST OUTBOARD OF CENTERLINE. REPAIRED PER EA 99-154774.SDR SWAA980288Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CRACKED AT BS 947 LBL 53 WL 208, BS 947 RBL 4.5 WL 208, BS 986.5 LBL 39.5 WL 208, BS 967 LBL 43 WL 207, BS 964 LBL 42 WL 207, BS 294 LBL 39 TO 59 WL 207, BS 307 RBL 12 WL 208. REPAIRED PER BOEING SRM.SDR SWAA980282Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM CORROSION AT BS 727 TO 947 LBL 3 WL 159, BS 727 TO 947 RBL 3 WL 159, BS 727 TO 947 RBL 8 WL 159. REPAIRED PER BOEING SRM.SDR TWAA9807314Floorbeam · wornMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CABIN FLOORBEAM WITH WEAR AREA AT STATION 237, LBL 4 INCHES. REPAIRED FLOORBEAM PER SRM 53-05 FIG 30. (M)SDR EIAA980153Floorbeam · crackedMZJ - DURING 'C4' CHECK INSPECTION, FLOORBEAM CRACKED UPPER CHORD AT STATION 500. REPAIRED FLOORBEAM UPPER CHORD FROM RBL 37 TO RBL 55 AT BS 500 IAW SRM 53-10-07 FIG 8. (M)SDR EIAA980146Floor Beam · crackedMZJ - DURING 'C4' CHECK INSPECTION, FLOOR BEAM AT STA 500 RLB 46 UPPER CHORD CRACKED. REPAIRED FLOOR BEAM UPPER CHORD IAW SRM 53-10-07 FIG 8. (X)SDR UPS98826157Floorbeam · corrodedINSPECTION TYPE-C, STA 320 AT RBL 50 THE LOWER CHANNEL OF THE FLOORBEAM IS CORRODED BEYOND LIMITS. REPAIRED AREA IAW 8110-3 APPROVED DHC SK 813-472.SDR P5CA9800568Floorbeam · corrosionLEVEL 1 CORROSION MAIN DECK FLOORBEAM AT STA 980 RBL 70. REPAIRED PER 51-40-04 FIG 1.SDR CALA9800413Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND NUT PLATE HOLE AT BS 947 BETWEEN RBL 12 AND LBL 12. THE FLOORBEAM WAS REPAIRED IAW SRM 51-00-51.SDR ABXA9800199Floorbeam · corrodedDURING C-CHECK, FOUND EXFOLIATION CORROSION BETWEEN ANGLE AND FLOORBEAM LOWER FLANGE ON BEAM AT STATION 965 RBL 8. REPAIRED FLOORBEAM IAW ABX REA D953-22983-MR.SDR AALA980487Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM AT FRAME 58 UNDER NR 3 AND NR 4 ROLLER TRAYS. SPLICE IN NEW SECTION OF FLOORBEAM PER SRM 53-10-15-2. (M)SDR CALA9800404Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, RBL 5 TO LBL 40. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51, FIGURE 205.SDR DHL9872671DFloorbeam · corrodedAT D CHECK, FUSELAGE INT UPPER LOBE STA 312 CORROSION FLOORBEAM BL 4L TO 45L. CUT OUT DAMAGED AREA. INSTALLED REPAIR PER SRM 51-40-4 12 LONG, N/R 3778.SDR CALA9800403Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312 FROM LBL 20 TO RBL 20. A REPAIR ANGLE WAS INSTALLED IAW SRM 53-10-51, PAGE 220-223.SDR CALA9800393Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 967 UPPER T-CAP, LBL24. REPAIRED IAW SRM 53-00-51, FIGURE 202.SDR CALA9800392Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BOTH SIDES OF SCREW HOLES TO EDGE OF T-CAP AT STA 986.5. REPAIRED IAW SRM 53-00-51.SDR RRXA98192Floorbeam · corrosionDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE ON FLOORBEAM AT STA 1702 AND BL 27 RIGHT. REMOVED DAMAGED SECTION, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW FAA APPROVED DER COTNEY ENGINEERING SKETCH E04-R12 AND RFTS 98-142. USDR P2EA98043Floorbeam · corrodedSJO - Q-CHECK, AFT CARGO COMPT BS 747, BETWEEN RBL 25 AND RBL 62 FLOORBEAM LOWER FLANGE HAS CORROSION AT UPPER SURFACE. REPAIRED PER SRM 53-10-09 FIG 7, CORROSION REMOVED PER SRM 51-10-06. (M)SDR VJ9800075Floorbeam · corrodedFLOOR BEAM AFT LAV FS 965, BL 22R, CORRODED. REMOVED SECTION FLOORBEAM FROM BL 0 TO BL 50R, FABRICATED AND SPLICED NEW SECTION IAW DC9 SRM 53-05, FIG 20A. TREATED AND PRIMED IAW DC9 SRM 51-10-3 AND 51-30-0.SDR USAA980111Floorbeam · crackedINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND .50 INCH CRACK BS 663 BL ZERO WL 205 FLOORBEAM WEB. INSTALLED DOUBLER, REPAIRED PER BAC DRAWING NR 65C34537. (X)SDR CALA9800369Floorbeam · corrodedINSPECTION FOUND FLOOR SUPPORT BEAM CORRODED AT L-1 DOOR, STA 442. THE CORRODED SECTION OF BEAM WAS REPLACED IAW GMM 10-900-01, PAGE 1.SDR CALA9800368Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 450 FROM CENTERLINE TO 24 RIGHT OF CENTERLINE. THE CORRODED SECTION OF FLOORBEAM WAS REPLACED IAW GMM 10-900-01, PAGE 1.SDR CALA9800352Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED INSIDE OF FORWARD BAGGAGE BIN BELOW RIGHT PALLET GUIDE RAIL AND BEAM WEB HAD A 3 INCH CRACK AT STA 601, LONGERON 43R. THE CORRODED SECTIONS OF BEAM WERE REMOVED, REPAIR SECTIONS WERE FABRICATED AND INSTALLED IAW ECRA 5310-0SDR MWEA98239Floorbeam · damagedTHE FLOORBEAM AT FS 237 LBL 45 TO 55 HAS AN IMPROPER REPAIR. REMOVED AND REPLACED REPAIR IAW SRM.SDR AALA980425Floorbeam · corrodedTUL - TOP OF FLOORBEAM IS CORRODED. CUT OUT CORRODED AREA, INSTALLED 2 INCH FILLER PLUG WITH 20.5 INCH DOUBLER STARTING AT 11 INCHES FROM RT SIDE OF FLOORBEAM PER SRM 53-05 FIG 20A. TST: 44,152 HOURS. CYCLES: 24,579. (X)SDR 9805622705Floorbeam · corrodedDURING H CHECK, FOUND CORROSION ON UPPER CHORD OF FLOORBEAM AT FS 1130, RBL 16-27, WL 208. REPAIRED PER EA 27-154488.SDR TSAA9753164Floorbeam · crackedDURING LAP JOINT INSPECTION, CRACK WAS FOUND ON FLOORBEAM BS 645, LBL 40. REMOVED ANGLE FABRICATED REPAIR ANGLE PER SRM 51-10-1, ALODINED PART PER SRM 51-30-5, PRIMED REPAIR ANGLE PER SRM 51-10-2. INSTALLED REPAIR ANGLE AND FASTENERS PER SRM 51-30-2. (M)SDR SIMA980571Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, MAINTENANCE REPORTED THE RT SIDE OF FLOORBEAM 7 WAS CORRODED. MAINTENANCE SPLICED IN A NEW SECTION OF FLOORBEAM 7 IAW ATR DRAWING NR 115631R0158...1112 ISSUE A). AIRCRAFT WAS RETURNED TO SERVICE. (X)SDR RAIA980229Floorbeam · corrodedSTL - DURING MAINTENANCE CHECK, FOUND CORROSION AT FLOOR BEAM 39. MAINTENANCE REPAIRED FLOORBEAM 39 PER ATR SRM. (M)SDR RAIA980226Floorbeam · corrodedSTL - DURING MAINTENANCE CHECK, FOUND CORROSION AT FLOORBEAM 36. MAINTENANCE REPLACED FLOORBEAM 36 PER ATR SRM. (M)SDR RAIA800230Frame · corrodedSTL - DURING MAINTENANCE CHECK, FOUND CORROSION AT FLOORBEAM 39 FRAME 39 RT SIDE. MAINTENANCE REPAIRED FLOOR FRAME 39 RIGHT SIDE PER ATR SRM. (M)SDR CKSA98079Floorbeam · corrodedDURING CPCP INSPECTION FOUND LEVEL 2 CORROSION. CORROSION ON FLOORBEAM UPPER CHORD AT STA 1660 LBL 15. REMOVED CORROSION ON FLOORBEAM UPPER CHORD AT BS 1660 LBL 15 IAW B747 SRM 51-10-01. FOUND OUT OF LIMITS IAW B747 SRM 53-10-01. CUT OUT DAMAGED AREA IAW BSDR CKSA98070Floorbeam · corrodedDURING CPCP INSPECTION FOUND LEVEL 2 CORROSION, BETWEEN BS 580 AND BS 760 AT FLOOR CENTER AREA, FLOORBEAM PLUS TWO FLOOR AUXILIARY CHANNEL SUPPORTS PLUS WATER CONNECTOR FITTINGS AND FRAME SUPPORTS CORRODED. REMOVED CORROSION ON FLOORBEAM FS 660 AND FOUND TO BSDR CKSA98067Floorbeam · crackedDURING CPCP INSPECTION FOUND LEVEL 2 CORROSION, FLOORBEAM WEB CRACKED AT BS 1394 RBL 125. REMOVED AND REPLACED CRACKED WEB IAW B747 SRM 51-10-01 AND 51-30-02. CORROSION TASK CARD NUMBER C53-210-06. NON-ROUTINE TASK CARD NUMBER 12863.SDR CALA9800329Floorbeam · corrodedINSPECTION FOUND UPPER CAP OF FLOORBEAM IN AFT BIN CORRODED IN SPOTS FROM LEFT TO RIGHT END AROUND SCREW HOLES AND TIE DOWN TRACK MOUNT SCREWS AT BOTTOM, STA 1821. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 51-31-01.SDR CALA9800316Floorbeam · corrodedINSPECTION FOUND CORROSION ON UPPER CAP OF FLOORBEAM IN C-2 CARGO COMPARTMENT AT STA 1701, RBL 37. THE CORROSION WAS REMOVED IAW SRM 51-21-01. DOUBLERS AND FILLER ANGLE WERE FABRICATED AND INSTALLED IAW SRM 53-60-01.SDR USAA980092Floorbeam · crackedINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND CRACK 3 INCHES STATION 664 BL 0 WL 207.5 TO WL 204 FLOORBEAM WEB. REMOVED DAMAGED AREA INSTALLED WEB REPAIR, REPAIRED PER BOEING DRAWING 65-C34537. (M)
Back to JASC 5315