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 W8PA971565Floorbeam · corrodedPAE- CORROSION AROUND NUT PLATE HOLES ON FLOORBEAM, UPPER CHORD, BS 294.5, WL 208, RBL 7.5, 20, 31.5, 32, 38.5 AND 44. REMOVED CORROSION, OUT OF LIMITS, CUT OF DAMAGE, FAB AND INSTALLED REPAIR PARTS.SDR W8PA971560Floorbeam · corroredPAE- CORROSION ON FLOORBEAM BS 986.5, LBL 45, RBL 37 WL 208. REMOVED ALL CORROSION, OUT OF LIMITS, CUT OF UPPER CHORD, FABRICATED NEW CHORD AND SPLICE ANGLES AND INSTALLED.SDR W8PA971556Floorbeam · corroredPAE- CORROSION ON FLOORBEAM AT BS 344, LBL 36, LBL 1, WL 208. REMOVED CORROSION, OUT OF LIMITS, REPAIRED BEAM.SDR W8PA971533Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM BS 967, LBL 42 - RBL 42. REMOVED ALL CORROSION, FOUND TO BE OUT OF LIMITS. REPAIRED FLOORBEAM.SDR CALA9701335Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1016, LBL 10 TO LBL 30. REPAIRED FLOORBEAM IAW SRM 53-00-51.SDR CALA9701334Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1006, LBL 14 TO LBL 20. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51.SDR AALA971712Floorbeam · corrodedTUL - FOUND CORROSION ON TOP OF FLOORBEAM STATION 380 RBL 33-38. INSTALLED DOUBLER AND FILLER PER SRM 53-10-8 PAGES C-D AT STATION 380 RBL 33-38. (M)SDR ZZDA5321597Floorbeam · corrodedDURING C-CHECK AT AERO CORP, AFT LAVATORY FLOOR BEAM UPPER CHORD BS 1006 HAS CORROSION AT LBL 9. FABRICATED DOUBLER FROM 7075 T6 .071 INCH 10.50 INCHES, 1.0625 INCH, AND 10.0625 INCHES BY 1.0625 INCHES. FABRICATED FILLER FROM BAC 1505-100817, 44 INCHES BY 3 SDR CALA9701333Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 967, RBL 40 TO LBL 40. THE UPPER T-CHORD SECTION WAS REMOVED AND REPAIR WAS INSTALLED IAW ECRA 5310-03570 AND 5310-03450.SDR CALA9701330Floorbeam · corrodedINSPECTION FOUND CORROSION ON FLOORBEAM UPPER CHORD AT STA 986, LBL 24 TO RBL 24. THE FLOORBEAM UPPER CHORD WAS REPLACED IAW SRM 53-00-51.SDR AALA971740Floor Beam · corrodedAFW - FOUND AND BLENDED OUT CORROSION ON THE UPPER SURFACE OF THE MAIN CABIN FLOOR BEAM IN VARIOUS LOCATIONS. THE BLEND-OUTS EXCEED SRM MAXIMUM LIMITS. AT EACH AREA THE FOLLOWING WAS ACCOMPLISHED: ALODINED BLEND-OUTS. FABRICATED AND INSTALLED REPAIR STRAPSSDR AALA971739Floor Beam · corrodedAFW - FOUND AND BLENDED OUT CORROSION ON THE UPPER SURFACE OF THE MAIN CABIN FLOOR BEAM. THE BLEND-OUT EXCEEDED SRM MAXIMUM LIMITS. ALODINED BLEND-OUT. FABRICATED AND INSTALLED STRAP USING .050 INCH 1/2 HARD 301 STAINLESS STEEL. PRIMED AND FILLED BLEND-OUTSDR 9717315522Floorbeam · corrodedDURING TRANSITION CHECK, FOUND CORROSION ON TOP OF FLOORBEAM AT SEVERAL LOCATIONS FROM LBL 54 TO RBL 24, FS 1680. REPAIRED PER EA 55-151991.SDR CALA9701329Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 312, LBL 8 TO RBL 24. THE CORRODED AREA WAS REMOVED, A NEW SECTION OF BEAM WAS FABRICATED AND INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR CALA9701328Floorbeam · corrodedINSPECTION FOUND CORROSION ON FLOORBEAM AT STA 947, RBL 4. THE FLOORBEAM UPPER CHORD WAS REPLACED IAW SRM 53-00-51.SDR SWAA970807Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, 360, 312, 986 AND 1016. REPAIRED PER BOEING SRM.SDR EISA97184Floor Beam · corrodedDURING ACCOMPLISHMENT OF STC SA-1798-SO, CARGO MOD, FOUND CORROSION ON FLOOR BEAM CAP, FS 1030. REMOVED DAMAGED SECTION, FABRICATED AND INSTALLED REPAIR PER SRM 51-30-02. TT, 55,940:30 HOURS. TC: 32,713. (X)SDR 97FDEA00618Floorbeam · corrodedNR 0822 028 CORROSION (C53-224-06) ON UPPER SURFACE OF TOP CHORD OF FLOORBEAM BS 328, LBL 29-32, WL 208. REPAIRED TOP CHORD OF FLOORBEAM BS 328 FROM LBL 9 TO LBL 63, WL 208 IAW FED-EX SRM 53-10-8.SDR 97FDEA00601Floorbeam · corrodedNR 0840 020 STA-PAE - WHILE WORKING NR0374 FOUND DOUBLE HOLES IN UPPER SIDE OF BS 1130 CHORD, BS 1130, RBL 32 AND 37, LBL 33 AND 38, WL 208 ALSO CORROSION AND CRACK INDICATION AT LBL 33. REPAIRED UPPER CHORD OF 1130 BEAM IAW FED-EX EA 7-5310-36165 AND EA 7-5SDR UPS97424443Floorbeam · corrosionINSPECTION TYPE-C, MAIN DECK FLOOR STRUCTURE: FOUND CORROSION AT FLOORBEAM WEB AT BS 460 LBL 22 LOWER SIDE. REMOVED CORROSION AT MAIN DECK FLOOR STRUCTURE AT FLOORBEAM WEB BS 460 LBL 22 ACC SRM 51-10-01. OUT OFF LIMITS ACC SRM 53-10-01. REPAIRED ACC SRM 53-1SDR CALA9701254Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 328, RBL 7 TO 63. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR AWXA9700542Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM AT BS 294.5, RBL 10 TO LBL 11, WL 208. REPAIRED PER SRM 51-70-11 AND 51-40-2, 53-10-51, RBL 331 TO LBL 16.SDR ZZDA5322997Floor Beam · corrodedDURING C-CHECK AT AERO CORP, FOUND PASSENGER CABIN FLOOR BEAM LONGITUDINAL SUPPORT AT LBL 12 HAS CORROSION AT BS 310. REMOVED FLOOR SUPPORT AT LBL 12 IAW B 737 51-30-2 AND FABRICATED NEW FLOOR SUPPORT FROM 60-8004 15 INCHES BY 2 INCHES IAW B 737 SRM 51-30-2. SDR ZZDA5322897Floor Beam · corrodedDURING C-CHECK AT AERO CORP, FOUND PASSENGER CABIN FLOOR BEAM BS 328 HAS CORROSION ON UPPER CHORD FROM RBL 48 TO LBL 12, FOUND TO BE BEYOND LIMITS. REMOVED CORROSION ON FLOOR BEAM PER 737 SRM 51-20-6. REMOVED OVER 20 PERCENT MATERIAL LOSS, OUT OF LIMITS PER SDR ZZDA5322797Floor Beam · corrodedPASSENGER CABIN FLOOR BEAM BS 294 HAS CORROSION ON UPPER CHORD FROM RBL 12 TO RBL 50. REMOVED CORROSION FROM THE UPPER CHORD FLOOR BEAM IAW B737 SRM 51-10-1. MATERIAL LOSS MORE THAN 50 PERCENT OUT OF LIMITS IAW SRM 53-10-1. FABRICATED NEW UPPER CHORD AND 10SDR ZZDA5321797Floor Beam · corrodedDURING C-CHECK AT AERO CORP, FOUND PASSENGER CABIN FLOOR BEAM LONGITUDINAL SUPPORT AT LBL 12 HAS CORROSION AT BS 310. REMOVED FLOOR BEAM AT LBL 12 IAW B 737 SRM 51-30-2. FABRICATED NEW FLOOR SUPPORT IAW B 737 SRM 53-40-4. TREATED AND PRIMED IAW B 737 SRM 51SDR UPS97824423Floorbeam · crackedINSPECTION TYPE-C, FLOORBEAM UPPER FLANGE CRACKED FS 1680 LBL 48. REPAIRED IAW DHC SK 701-043.SDR UPS97824422Floorbeam · corrodedINSPECTION TYPE-C, MODERATE CORROSION ON FLOORBEAM FS 1660 LBL 48. REPAIRED IAW DHC SK 701-044.SDR SWAA970824Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 294, LBL 53. REPLACED PER BOEING SRM.SDR 97FDEA00608Floorbeam · corrodedCORROSION (C53-224-02) ON TOP CHORD OF FLOORBEAM BS 480, RBL 8, WL 208. *S/D* REMOVED CORROSION ON TOP CHORD OF FLOORBEAM AT BS 480, RBL 8, WL 208 AND REPAIRED PER FED-EX SRM 53-10-8, SRM 53-10-1.SDR TSAA53215Floorbeam · corrodedDURING HEAVY MAINTENANCE VISIT, FOUND CORROSION ON FLOORBEAM UPPER CHORD AT BS 294 BL '0', BS 294 BL 6L, BS 294 BL 18L AND BS 294 BL 36L. REPAIRED PER ECO2096R3. AIRCRAFT RETURNED TO SERVICE. (M)SDR ZZDA5327597Floor Beam · corrodedDURING C-CHECK AT AERO CORP, RIGHT HAND FLOOR BEAM 967, BL ZERO, TO FUSELAGE SKIN FOUND CORRODED. FABRICATED 2 SUPPORT ANGLES FROM 7075 0 .070 INCH 18 INCHES AND 16 INCHES. FABRICATED 2 SUPPORT ANGLES FROM 7075 0 .080 INCH 18 INCHES AND 16 INCHES IAW 53-10-9SDR ZZDA5322697Floor Beam · corrodedDURING C-CHECK AT AERO CORP, FOUND INTERIOR FUSELAGE, RT SIDE FLOOR BEAM, BS 947, BL ZERO TO FUSELAGE SKIN CORRODED. FOUND TO BE BEYOND LIMITS. REMOVED CORROSION IAW SRM 51-30-2, MATERIAL LOSS BEYOND LIMITS IAW B 737 SRM 53-10-1. CUT OUT SECTION OF UPPER CHSDR ZZDA5322597Floor Beam · corrodedDURING CHECK AT AERO CORP, FOUND BS 1016, BL ZERO TO FUSELAGE FLOOR BEAM CORRODED. CUT OUT CORRODED AREA AND FABRICATED THE REPAIR. INSTALLED REPAIR. BLENDED CORROSION, MATERIAL LOSS BEYOND LIMITS IAW B 737 53-10-1. CUT OUT AREA BEYOND LIMITS AND INSTALLEDSDR DL76S971745Floorbeam · crackedTHE FS 246 FLOORBEAM WEB WAS FOUND WITH A 3.25 CRACK AT RBL 20. REPAIRED PER DAL ER/A.SDR AALA971637Floor Beam · corrodedTUL - FLOOR BEAM, STA 1130, HAS LIGHT CORROSION AROUND NUTPLATES, STA 1130, LBL 19 AND LBL 21. BLENDED OUT LIGHT CORROSION, BEYOND BLEND-OUT LIMITS THEN REPAIRED FLOOR BEAM PER ESO 11697 DATED 8-8-97. TST: 67,059. CYCLES, 43,852. (X)SDR 97FDEA00589Floorbeam · corrodedCORROSION (C53-111-01(3)) ON LOWER CHORD OF FLOORBEAM AT BS 1130, RBL 26 TO 39, WL 200. *S/D* REPAIRED FLOORBEAM LOWER CHORD IAW FEDEX EA NR 7-5310-36166A.SDR ZZDA5327497Floor Beam · corrodedDURING C-CHECK AT AERO CORP, FLOOR BEAM CHORD FS 312 QL 208.1 LBL 20 TO RBL 20 IS EXFOLIATED. FABRICATED FLOOR BEAM FROM 7075T6 56 INCHES BY 2 INCHES. FABRICATED ANGLE SPLICES FROM 7075 0 .063 INCH, HEAT TREATED TO 7075 T6 8.50 INCHES BY 2 INCHES, 12 INCHES SDR ZZDA5327297Floor Beam · corrodedDURING C-CHECK AT AERO CORP, FOUND FLOOR BEAM UPPER CHORD FS 344 WL 208.1 LBL 20 IS EXFOLIATED. FABARICATED T-ANGLE FROM AND10136-2401 50 INCHES BY 2.50 INCHES IAW B 737 SRM 53-10-9. FABRICATED SPLICE ANGLES FROM 7075 0 .083 INCH (8) 7 INCHES BY 2 INCHES ANDSDR UPS97824420Floorbeam · corrodedINSPECTION TYPE-C, FS 59 FLOORBEAM TOP FLANGE LWR SURFACE HAS SEVERE CORROSION AT RBL 36. REPAIRED IAW DHC SK 701-539.SDR SIMA972382Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE DISCOVERED FLOORBEAM AT FRAME NR 38 CORRODED OUT OF LIMITS. MAINTENANCE REMOVED AND INSTALLED NEW FLOORBEAM IAW SRM 51-25-02 AND 51-25-03. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR DHL9772720CFloorbeam · corrodedAT C-CHECK, STA 328 FLOORBEAM UPPER CHORD TO FLOOR PANEL BLEEDING CORROSION FROM APPROX RBL 12 TO LBL 12. CUT OUT DAMAGED AREA, INSTALLED ANGLES, REPAIR PER BOEING SRM 53-1-8. ANGLE 15 BY 1 BY 1.25, 13 BY 1 BY 1 AND FILLER 1.75 BY 1.SDR 97FDEA00621Floorbeam · corrodedHEAVY EXFOLIATION CORROSION ON 360 FLOORBEAM AT LBL 4 TO RBL 2. CUTOUT DAMAGED AREA AND INSTALLED DOUBLER PER SRM 53-10-8 PG 18.SDR 97FDEA00581Floorbeam · corrodedNR 0229 017 CORROSION (C53-111-01-02) ON FLOORBEAM BS 600, WL 200, LBL 20 TO RBL 25. REPAIRED FLOORBEAM AT BS 600, WL 200, LBL 20 TO RBL 25 IAW FED-EX EA NR 7-5310-35035 REV A.SDR ZZDA5324197Floor Beam · corrodedDURING C-CHECK AT AERO CORP, FOUND HOLE CORRODED IN FLOOR BEAM/FRAME AT STA 986.5 AFT SIDE 24 INCHES OF CENTER LINE. REMOVED FLOOR BOARDS FOR ACCESS, MECHANIC REMOVED THE CORROSION FROM FLOOR BEAM IAW B 737 SRM 51-10-6. MATERIAL LOSS OF .079 INCH, OUT OF LIMSDR 97FDEA00579Floorbeam · corrodedCORROSION (C53-224-06) ON NOT CLIP AND DOUBLER UNDER AFT SIDE OF UPPER FLOORBEAM CHORD AT BS 740, RBL 49 AND ON PREVIOUS BLEND OUT UNDER FWD SIDE OF UPPER CHORD AT RBL 47. *S/D* REMOVED OUT OF LIMITS AREAS ON NUTCLIPS AND DOUBLER UNDER AFT SIDE OF UPPER FLOOSDR USAA970265Floorbeam · corrosionCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 1 INCH AREA OF CORROSION AT 986.5 B/O, RBL 50 FLOORBEAM. CORROSION CARD NR C-53-107-02. INSTALLED NEW T-CAP, REPAIRED ANGLES AND STRAPS PER REPAIR DOCUMENT TRM 53-10-05. (M)SDR RRXA97240Floorbeam · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO FLOORBEAM AT, STA 920 RT. *S/D* REMOVED CORROSION DAMAGE FROM FLOORBEAM, FABRICATED AND INSTALLED REPAIR ANGLES IAW FAA APPROVED COTNEY ENGINEERING SKETCH D02-R04 AND DC-8 SRM 51-1-8, 51-1-20D AND 51-1-21SDR SWAA970760Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 344, LBL 42, WL 42. REPAIRED PER BOEING SRM.SDR SWAA970758Floor Web · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR WEB BODY AT BS 1030 CORRODED. REPLACED PER BOEING SRM.
Back to JASC 5315