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 RRXA000343Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION OF FLOORBEAM AT FS 1620 LONGERON 26L. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED FILLER AND DOUBLER IAW DC-8 SRM 51-1-21 AND DC-8 SRM 51-1-2SDR GAIA0068Floorbeam · crackedDURING C-CHECK AT TIMCO/OSC THE FOLLOWING DISCREPANCY WAS FOUND AT STATION 294.5, THE FLOORBEAM WEB WAS FOUND TO BE CRACKED AT LBL 54.5. CUT OUT DAMAGED PART OF WEB AND FABRICATED WEB AND DOUBLER. INSTALLED IAW SRM 51-40-2. THE AIRCRAFT WAS RETURNED TO SERVSDR GAIA0069Floorbeam · crackedDURING C-CHECK AT TIMCO/OSC THE FOLLOWING DISCREPANCY WAS FOUND AT STATION 948, THE CREASE BEAM WEB WAS FOUND TO BE CRACKED AT LBL 66. REMOVED AND REPLACED WEB IAW SRM 51-20-1 AND 51-30-2. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA0071Floorbeam · crackedDURING C-CHECK AT TIMCO/OSC THE FOLLOWING DISCREPANCY WAS FOUND AT STATION 848, IT WAS FOUND THAT THE ANGLED STIFFENER AND FLOORBEAM WEB WAS CRACKED THROUGH AT RBL 45. REPAIRED WEB AND REPLACED ANGLE IAW SRM 51-40-2 AND 51-30-2. THE AIRCRAFT WAS RETURNED TO SDR GAIA0076Floorbeam · corrodedDURING C-CHECK AT TIMCO/OSC THE FOLLOWING DISCREPANCY WAS FOUND AT STATION 1070, CORROSION WAS FOUND ON THE FLOORBEAM UPPER CHORD REPAIR AT LBL 6. REPAIRED FLOORBEAM UPPER CAP IAW SRM 53-10-8. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA0055Floorbeam · crackedDURNG C-CHECK AT TIMCO/OSC, THE FOLLOWING DISCREPANCY WAS FOUND AT STATION 826, THE WEB IN A FLOORBEAM HAS A CRACK AT THE THROUGH HOLE FOR THE ELECTRICAL CONDUIT, RIGHT SIDE. REPAIRED PART IAW TIMCO REO 500041. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA0057Floorbeam · corrodedDURING C-CHECK AT TIMCO/OSC, THE FOLLOWING DISCREPANCY WAS FOUND AT STATION 1110, THE FLOORBEAM HAS AREAS OF CORROSION AT SCREW HOLES AT LBL 11, LBL 17 AND LBL 20. REPAIRED FLOORBEAM IAW SRM 53-10-0, FIGURE 3. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA0058Floorbeam · corrodedDURING C-CHECK AT TIMCO/OSC, THE FOLLOWING DISCREPANCY AS FOUND AT STATION 1050, THE FLOORBEAM LOWER CHORD WAS FOUND TO BE CORRODED AT RBL 20 TO RBL 45. REPAIRED LOWER CHORD IAW SRM 53-10-8. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA0060Floorbeam · corrodedDURNG C-CHECK AT TIMCO/OSC, THE FOLLOWING DISCREPANCY WAS FOUND. AT STATION 1050, THE FLOORBEAM LOWER CHORD AND STABILIZATION STRAP WAS FOUND CORRODED AT RBL 26. CLEANED CORROSION ON LOWER CHORD AND WAS FOUND TO BE WITHIN LIMITS. FABRICATED A NEW STABILIZATSDR GAIA0063Floorbeam · corrodedDURING C-CHECK AT TIMCO/OSC, THE FOLLOWING DISCREPANCY WAS FOUND. AT STATION 1130, THE FLOORBEAM CAP AT LBL 30 HAS CORROSION AT SCREW HOLES. INSTALLED REPAIR IAW TIMCO DRAWING TIO-B727-00005, DATED 1-17-2000. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR USAA000301Floorbeam · corrodedPIT - FOUND CORROSION, 1 INCH BY 20 INCHES, FLOORBEAM UPPER CHORD, STATION 1309. CUT OUT CORRODED SECTION. INSTALLED NEW AND SPLICED PER EA 54092. CORROSION LEVEL 1. (M)SDR RRXA000944Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES TO THE TOP OF FLOORBEAM IN THE FWD. UPPER CARGO COMPT. AT STA 360, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLESSDR RRXA000506Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO FLOORBEAM AT STA 1660 AND BL 44 LEFT. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW FAA DER APPROVED ENGINEERING SKETCH 83SDR RRXA000352Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORRSION AT FLOORBEAM UNDER SIDE ANGLE STA 1240. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED SHIMS AND ANGLE IAW DC-8 SRM 51-1-21 AND DER APPROVED EO 0SDR RRXA000351Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION AT FLOORBEAM UNDER SIDE ANGLE STA 1280. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER AND SHIMS IAW DC-8 SRM 51-1-20A AND DER APPROVED SDR SWAA000241Floorbeam · crackedDURING SCHEDULED TRANSITION CHECK, FOUND FLOORBEAM CRACKED, BS 520, RBL 45.4. REPAIRED BEAM PER ER NR 99-6481.SDR 2000ZZZX331Floorbeam · chafedAFT CARGO PIT STA 917 BL ZERO FLOORBEAM CHAFED. REPAIRED PER ECRA NR 941-53-094-2.SDR RRXA002183Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE CABIN INT FLOOR LEVEL AROUND CLIP NUT HOLES AT STA 1000 AND RBL 25 THROUGH 44, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED AND INSTALLED NEW CAPSDR RRXA000342Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION UNDER NUT PLATE UPER CARGO COMPARTMENT FS 717 XCW 32/5 LT. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR ANGLE IAW DC-8 SRM 51-1-21 & DESDR RRXA000338Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION ON FLOORBEAM STA 67, 40 INCHES RT OF CENTER FLIGHT COMPARTMENT. DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR CHANNEL AND SHIMS IAW DER SDR AWXA0000063Floorbeam · corrodedC-CHECK, CORROSION LEVEL 1. FWD CABIN FS 312, LBL 24 TO RBL 28 FLOORBEAM UPPER T WEB CORRODED. REMOVED CORRODED T CAP IAW 737 SRM 51-30-2, FABRICATED REPLACEMENT PARTS IAW 737 SRM 53-10-2 FRM (BAC 1505-100617-7075-T6 QQA 200/11 R696033 AND BHC 506-43-70T7 AMSDR QXEA0000521Floorbeam · gougedPDX - FLOORBEAM AT FRAME 15635 HAS A GOUGE ON LOWER SURFACE JUST OUTBORD OF LEFT INBOARD SEAT TRACK. REPAIRED IAW HORIZON AIR EA 4-53-993.SDR CALA0000136Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT AFT LAV, STA 986.5. THE FLOORBEAM UPPER CHORD WAS REPLACED IAW ECRA 5310-03851.SDR USAA000154Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 6 PLACES 1 INCH EACH, AT STATION 986.5, RBL 5 TO 45 FLOOR LEVEL. INSTALLED REPAIR ANGLE PER TR 53-60-01 REV A. CORROSION LEVEL 2, TASK NR C53-202-01. (M)SDR P2EA00037Floorbeam · corrodedSJO - DURING Q-CHECK, CORROSION ON VERTICAL STIFFENER (FLOORBEAM) AT BS 286.5 LBL 18 FROM WL 154 TO WL 194. FABRICATED VERTICAL STIFFENER IAW COOPESA EO NR COO-3-53-074-00 AND SRM 51-10-0 PAGE 5. REMOVED AND REPLACED VERTICAL STIFFENER IAW SRM 51-30-2. (M)SDR CALA0000135Floorbeam · corrodedINSPECTION FOUND AFT CARGO FLOOR PANEL SUPPORT CORRODED AT FS 1155, LBL 16 TO RBL 8. THE SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-4, 51-30-2, AND 51-30-5.SDR RRXA000956Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD UPPER CARGO COMPT. TOP OF FLOORBEAM AT STA 400, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED ALL DISCREPANT HOLES, FSDR RRXA000955Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE FWD. UPPER CARGO COMPT. TOP OF FLOORBEAM AT STA 640, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED EXISTING HOLES, FABRICATESDR RRXA000949Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND NUMEROUS DRILLED HOLES IN THE FWD. CARGO COMPT TOP OF FLOOR BEAM AS STA 270, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUSDR RRXA000943Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES TO THE TOP FLOORBEAM AT FWD. UPPER CARGO COMPT. STA 380, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM. PLUGGED ALL DISCREPANT HOLES, FABRICATEDSDR USAA000137Floorbeam · corrodedCLT - Q-1, BS 1016 LT LENGTH OF FLOORBEAM HAS CORROSION LEVEL 1. REPLACED WEB, T-CAP PER TR 53-60-02 AND SRM 51-40-02. (M)SDR AWXA0000058Floorbeam · corrodedC-CHECK, CORROSION LEVEL 1 FWD CABIN STA 294.5 BL 0 TO RBL 45 FLOORBEAM UPPER T CAP HAD CORROSION. REMOVED CORRODED T CAP IAW 51-30-2, FABRICATED CAP IAW 737 SRM 53-10-9 FRM (AND 10136-2401,7075T6, R73083), TREATED AND PRIMED IAW 737 SRM 51-10-2, INSTALLED RESDR AWXA0000054Floorbeam · corrodedC-CHECK CORROSION LEVEL 1, FWD CABIN FS 328, BL 0 TO RBL 53 FLOORBEAM T-CAP CORRODED. REMOVED DAMAGED T CHORD IAW 737 SRM 51-40-02, FABRICATED NEW PART FRM (BAC 1505-100617A 7075T6 / R696033) 737 SRM 51-40-2, ALODINED AND PRIMED PART IAW 737 SRM 51-40-2, INSSDR EIAA2000077Floorbeam · crackedHAECO-HKG - M/D BS 1220 RBL 115 FLOORBEAM WEB CRACKED. FLOORBEAM WEB REPAIRED PER SRM 51-40-02 FIG 1. (X)SDR EIAA2000076Floorbeam · crackedHAECO-HKG - C1 CHECK - M/D BS 1220 LBL 115 BELOW FLOORBEAM WEB CRACKED. FLOORBEAM REPAIRED PER SRM 51-40-02 FIG 1. (X)SDR EIAA2000073Floorbeam · crackedHAECO-HKG - C1 CHECK, M/D BS 460 STR 13R FLOORBEAM WEB CRACKED. REPAIRED FROM RBL 76 TO RBL 115 PER SRM 53-10-07. (X)SDR TWAA0003901Floorbeam · crackedDURING CHECK-C MAINT, FLOOR MEMBRANE WAS CRACKED AT STA 1293, JUST INBD OF LONGERON 18R. REPAIRED MEMBRANE PER SRM 53-05, FIG 96.SDR USAA000127Floorbeam · crackedCLT - Q-1, STATION 707, LBL 25, WL 202.5 FLOORBEAM WEB HAS A 1.5 INCH CRACK. REPLACED PARTS PER SRM 51-40-2. (M)SDR TWAA0002206Floorbeam · corrodedDURING MSG24 MAINTENANCE, FOUND CORROSION ON CABIN FLOOR SUPPORT AT STA 150-200, RBL6. REMOVED CORROSION PER SRM 51-10-3.. REPLACED WITH NEW PART PER SRM 51-10 PG 1 PAR C, SRM 6-70-02. INSTALLED FASTNERS PER SRM 51-30-PG1 PART NUMBER 07-91.SDR TWAA0002205Floorbeam · corrodedDURING MSG24 MAINTENANCE CORROSION WAS FOUND AT CABIN FLOOR SUPPORT STATION 160 RBL 6 AND RBL5. REMOVED CORROSION PER SRM 51-10-3. REPLACED WITH NEW PART PER SRM 51-01 P71 PAR C AND SRM 6-70-01. INSTALLED FASTNERS PER SRM 51-30-2 PG9, PART NUMBER 07-91.SDR DHL200071780DFloorbeam · corrodedAT D-CK, FWD CARGO COMPT FLOOR SUPPORT ANGLE CORRODED AT BS 700 LBL 20. CUTOUT DAMAGED AREA PER B727 SRM 51-40-4. INSTALLED REPAIR PER B727 SRM 51-40-3 FIG 1 AND 51-30-2. REF: N/R 3781.SDR RRXA002954Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE FLOORBEAM BETWEEN STA 320 - 340 AT X-40 AND Z-50, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW DC-8 SRM 53-2-0. (CORSDR UPS00831675Floorbeam · corrodedINSPECTION TYPE:C123 STA 1540 RBL 34 FLOORBEAM AFT FACE WEB AREA CORRODED BEYOND LIMITS. REPAIRED IAW 8110-3 DH SK 707-471.SDR AWXA0000049Floorbeam · corrodedC-CHECK CORROSION LEVEL 1, FLOORBEAM AT STA 328 RBL 25 IS CORRODED BEYOND LIMITS. CUT OUT DAMAGED AREA IAW 737SRM 53-30-51, FABRICATED REPAIR PARTS FROM (7075T6 .071 R672214 QQA 250/135, 7075T6 .100 QQA 250/13 R684229 AND 7075T .080 QQA 250/13E R692255). ISDR AWXA0000048Floorbeam · corrodedC-CHECK CORROSION LEVEL 1, FLOORBEAM AT BS 294.5 LBL 10, CORROSION OUT OF LIMITS. REMOVED DAMAGED SECTION OF T CHORD IAW 737 SRM 53-10-51. FABRICATED REPAIR PARTS IAW 737 SRM 53-10-17 FRM (T BAC 505-101303 7075T6 R678532, AND BAC1490 2865 7075 T6 .071 R6722SDR RRXA001526Floorbeam · crackedDURING A MAINTENANCE VISIT, FOUND A CRACK TO THE FLOORBEAM IN THE UPPER CARGO COMPT FS 360 AND XCW 64L, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED ANGLES FROM 7075-T6 AND INSTALLED IAW EOSDR RRXA001523Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE CABIN FLOORBEAM AT STA 759 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLER FROM SDR RRXA001521Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE CABIN FLOORBEAM AT STA 798 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLER FROM SDR RAIA0001041Floorbeam · corrodedMX- DURING INSPECTION FOUND CORROSION ON FLOORBEAM AT FRAME 41. MAINTENANCE REPAIRED FLOORBEAM AT FRAME 41 IAW ATR42 SRM.SDR RAIA0001036Floorbeam · corrodedMX- DURING INSPECTION FOUND CORROSION AT FRAME 36 FLOORBEAM. MAINTENANCE REPLACED FLOORBEAM AT FRAME 36 IAW ATR42 SRM.
Back to JASC 5315