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 USAA980239Floorbeam · corrodedPIT - DURING Q-CHECK, FOUND .3750 INCH BY .50 INCH CORRODED AREA AT BEAM AT STA 3870, BL 1127R. BLENDED OUT CORROSION ON FLOOR BEAM TO SMOOTH CONTOUR, ALODINE NR 1200S PRIME AND TOP COAT REWORKED AREAS, SEALED TOP SURFACE BEAM WITH PR 1436G PER EA 49760. (X)SDR USAA980238Floorbeam · corrodedPIT - DURING Q-CHECK, FOUND SEVERAL .25 INCH BY .25 INCH CORRODED AREAS AT STA 3870 AND STA 4610 BL 1127L BEAM. BLENDED CORROSION TO SMOOTH CONTOUR. ALODINED AND PRIMED. SEALED TOP SURFACE WITH 1436G PER EA 49760. (X)SDR USAA980237Floorbeam · corrodedPIT - DURING Q-CHECK, FOUND 1 INCH BY .50 INCH CORRODED AREA AT BEAM AT STA 3870 FORWARD BEAM BL 1127L. BLENDED OUT CORROSION ON FLOORBEAM, INSTALLED L-ANGLE DOUBLER WET WITH PR 1436G USMS MS20426AD5 AND MS047AD5 FASTENERS PER EA 49771. (X)SDR SWAA981089Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM AT BS 987, RBL 35 AROUND FLOORBOARD SCREW HOLE, BS 987 FASTENER HOLE TOP FWD SIDE RBL 39 AND BS 987 FASTENER HOLE TOP FWD SIDE RBL 42.5. REPAIRED PER SWA RA 1-353-1830.SDR DL757981209Floorbeam · corrodedFLOORBEAM BS 1681.8 WAS FOUND WITH CORROSION DAMAGE ALONG ENTIRE LENGTH OF UPPER CAP. REPAIRED PER ERA 364763-14.SDR SWAA981080Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM HOLES AT BS 312, BL 0 AND BS 344, RBL 1. REPAIRED PER BOEING SRM.SDR AALA984134Floorbeam · corrodedAFW - FOUND AND BLENDED OUT CORROSION ON THE UPPER SURFACE OF THE UPPER CAP OF FLOORBEAM. THE BLENDOUT EXCEEDED SRM MAX ALLOWABLE LIMITS. ALODINED BLENDOUT. FABRICATED AND INSTALLED REPAIR STRAP USING .050 301.5 HARD STAINLESS STEEL. FILLED AND PRIMED AS RSDR TWAA9809207Floorbeam · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND FLOOR SUPPORT BEAM CORRODED AT RBL 7.5, FS 165 TO FS 200. REPLACED FLOOR SUPPORT PER SRM 51-01, PAGE 1 AND SRM 53-14-1 FIG 11. (M)SDR TWAA9809206Floorbeam · corrodedMCI - DURING OP16 MAINTENANCE CHECK, FOUND FLOOR SUPPORT BEAM LBL 7.5 CORRODED AT FS 160 TO 200. REPLACED FLOOR SUPPORT PER SRM 51-10, PAGE 1 AND SRM 53-14-1 FIG 11. (M)SDR CALA9800953Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 980, RBL 18. THE L-ANGLE, FILLER, AND SHIM WERE FABRICATED AND INSTALLED IAW SRM 53-05, FIGURE 4A.SDR CALA9800951Floorbeam · corrodedINSPECTION FOUND CORROSION AT FASTENER HOLES OF AFT LAV LT FLOORBEAM AT STA 1016 FROM CENTERLINE TO LBL 36. THE CORRODED AREA WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-00-51.SDR AALA981109Floorbeam · corrodedTUL - G5 GALLEY CENTER SUPPORT AND BEAM HAS SURFACE CORROSION. REMOVED CORROSION PER SRM 51-21-01, TREATED AND PRIMED PER SRM 51-21-01. (M)SDR TWAA9809209Floorbeam · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND FLOOR SUPPORT BEAM FS 200 CORRODED, LBL 15 IN TO RBL 46 IN. REPLACED FLOOR SUPPORT BEAM PER SRM 51-01, PAGE 1 ITEM C. (M)SDR DL72S981188Floorbeam · corrodedCORROSION FOUND ON STA 1110 FLOORBEAM O/B OF RT SEAT TRACK. REPAIRED PER SRM 53-20-11 PG 811B.SDR UPS98827091Floorbeam · corrodedINSPECTION TYPE:C/CK FLOORBEAM FUSELAGE STATION 1700, SEVERLY CORRODED BLO TO LBL 3. REMOVED DAMGED AREA FROM BEAM. FABRICATED INTERNAL DOUBLER, ANGLE, AND FILLER AND SHIMS IAW REO-04822. ALODINED AND PRIMED IAW DC8 SRM 51-1-8. INSTALLED REPAIR IAW DC8 SRSDR SWAA981016Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, LBL 12.5, WL 159 LBL 8, WL 159 AND LBL 3 WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981015Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, RBL 8, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981014Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, RBL 3, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980996Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOORBEAM AT BS 312, LBL 10 TO 12, RBL 10 TO 12, LBL 21. REPAIRED PER BOEING SRM.SDR SWAA980984Floorbeam · misdrilledDURING SERVICE CHECK, FOUND FLOORBEAM AT BS 947, LBL 4, WL 208 HAS FLOORBOARD FASTENER HOLE DRILLED INTO SPLICE REPAIR FASTENER. REPAIRED PER BOEING SRM.SDR SWAA980978Floorbeam · corrodedDURING SERVICE CHECK, FOUND CORRODED CARGO FLOORBEAM AROUND NUT PLATE AT BS 794, LBL 2.5 WL 158. REPAIRED PER BOEING SRM.SDR SWAA980977Floorbeam · corrodedDURING SERVICE CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 879, LBL 2.5, WL 166. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980960Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AT BS 986, LBL 4-43, WL 208 AROUND FASTENER HOLES UPPER AND LOWER SIDES. REMOVED AND REPLACED PER BOEING MM.SDR TWAA9809208Floorbeam · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM CAP AT STATION 256, LBL 20 TO RBL 20. FABRICATED NEW BEAM AND INSTALLED PER SRM 51-01, PAGE 1. (M)SDR C2XA98IA188Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND FLOORBEAM 39 CORRODED. MAINTENANCE REMOVED ALL CORROSION AND INSTALLED 4 DOUBLERS, IAW CONTINENTAL EXPRESS ENGINEERING CHANGE/REPAIR AUTHORIZATION (ECRA) EC5310-01037. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (SDR 98FDEA00384Floorbeam · corrodedNR 0914, UPPER LOBE BS 680, CORROSION ON FLOORBEAM RBL 2 - RBL 13. REMOVED CORROSION REPAIRED PER 53-10-07 IN SRM.SDR 98FDEA00383Floorbeam · corrodedNR 0866, UPPER LOBE, BS 620, LBL 63 - RBL 8, FLOORBEAM CORRODED. REMOVED CORROSION PERFORMED FLOORBEAM REPAIR FROM RBL 9- LBL 39, BS 620, PER SRM 53-10-8 FIG 3.SDR 98FDEA00367Floorbeam · damagedMAIN CARGO, PREVIOUS DAMAGE DOUBLER DRILLED HOLE IN FLOORBEAM BS 950F, RBL 3. REMOVED DAMAGE AND REPAIRED FLOORBEAM PER SRM 53-10-8 FIG 8.SDR UPS98827090Floorbeam · corrodedINSPECTION TYPE:C/CK FLOORBEAM AT STATION 1580 HAS CORROSION ON FWD LIP IN THE AREA OF LONGERON 22 AND 23 LEFT. REMOVED CORROSION FROM FLOORBEAM MAT REMOVED 50 PERCENT IAW DC8 SRM 53-2-0. FABRICATED FILLER AND 2 ANGLE DOUBLER REPAIR IAW REO 04839 ALODINED ASDR UPS98827053Floorbeam · crackedINSPECTION TYPE:C+S2 CABIN STA 760 X=23 FLOORBEAM FITTING ON AFT SIDE CRACKED. REMOVED AND REPLACED FITTING IAW DC8 SRM 51-1-20D.SDR UPS98827052Floorbeam · crackedINSPECTION TYPE:C+S2 CABIN STA 702 X=23 AT CABIN FLOORBEAM UPPER CHORD UNDER SEAT TRACK CRACKED. REMOVED AND REPLACED FITTING SUPPORT IAW DC8 SRM 51-1-20D.SDR RRXA98295Floorbeam · corrosionDURING A MAINTENANCE VISIT, FOUND FLOORBEAM WITH CORROSION DAMAGE BEYOND LIMITS IAW DC-8 SRM, AT STA 1700. REMOVED DAMAGED SECTION, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW FAA APPROVED TIMCO DER ENGINEERING SKETCH REO-04SDR AALA981108Floorbeam · corrodedTUL - C-5 GALLEY RT FORWARD AND AFT SUPPORTS AND BEAM HAS HEAVY CORROSION. FABRICATED AND INSTALLED A SECTION OF A FLOORBOARD GALLEY SUPPORT PER AARD 51-01-00-05 PAGE 1. (M)SDR AALA981068Floorbeam · corrodedTUL - CORROSION ON FLOORBEAM UPPER CAP STATION 1110 LBL 10 TO LBL 12. INSTALLED DOUBLER PER SRM 53-10-8. (M)SDR AALA981067Floorbeam · corrodedTUL - FOUND CORROSION ON UPPER AND LOWER SURFACE OF TOP FLANGE OF FLOORBEAM STATION 380 RBL 24 TO RBL 64. FABRICATED AND INSTALLED REPAIR PER SRM 53-10-8. (M)SDR AALA981059Floorbeam · corrodedTUL - FOUND CORROSION ON BOTH SIDES OF UPPER FLANGE OF FLOORBEAM STATION 345 RBL 44-64. BLENDED OUT CORROSION REPAIRED AND INSTALLED DOUBLER PER SRM 53-10-8 PAGE 9D. (M)SDR AALA981058Floorbeam · corrodedTUL - FOUND CORROSION TOP OF FLOORBEAM. INSTALLED DOUBLER AT FLOORBEAM STATION 400 RBL 12 PER SRM 53-10-8 9C-9E. ALSO, INSTALLED FLOOR SUPPORT AND BRACKET STATION 380-400 RBL 12. (M)SDR SWAA980940Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AROUND NUTPLATE AT BS 986 RBL 43, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980939Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AT BS 986 RBL 26-BL 0 WL 208 AROUND FASTENER HOLES UPPER AND LOWER SIDE. REMOVED AND REPLACED PER BOEING SRM.SDR USAA980266Floorbeam · corrodedCLT - DURING C-2 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM AT CLIP NUT HOLES STATION 1661 FROM BL 0 TO RBBL 55. CORROSION CARD NR C53-251-03. INSTALLED REPAIR 'T' CAP AND STRAPS. PARTIAL 'T' CAP REPLACED FROM LBL 25 TO LBL 64 ALSO INSTALLED REPLSDR USAA980231Floorbeam · corrodedCLT - DURING A C-2 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM AT CLIP NUT HOLES STA 1661 FROM BL ZERO TO LBBL 55.0. CORROSION TASK CARD NR C53-251-03. PARTIAL T-CAP REPLACEMENT FROM LBL 25 TO LBL 64. INSTALLED REPLACEMENT CHORD/REPAIR ANGLES PER SDR USAA980228Floorbeam · corrodedCLT - DURING A C-2 CHECK VISUAL INSPECTION, FOUND CORROSION ON THE UPPER FLANGE OF FLOORBEAM STA 1640 FROM BL ZERO TO RBL 57-0. CORROSION TASK NR C53-251-03. INSTALLED REPAIR T-CAP AND SPLICE PER REPAIR DOCUMENT T/R 53-15-01. (X)SDR AALA984133Floorbeam · corrodedAFW - FOUND AND BLENDED FIVE SMALL AREAS OF CORROSION ON THE UPPERS SURFACE OF THE LONGITUDINAL FLOORBEAM. THE BLENDOUTS EXCEED SRM MAX ALLOWABLE LIMITS. ROTOPEENED, TREATED, PRIMED AND FILLED BLEND AREAS. APPROVED FOR CONTINUED SERVICE WITH NOTED CONDITIONSDR SWAA980920Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED FLOORBEAM UNDER CARGO NET TIE DOWN LUG AT BS 747, RBL 14. REPAIRED PER BOEING SRM.SDR AALA984123Floorbeam · corrodedAFW - FLOORBEAM HAS CORROSION BEYOND SRM LIMITS. BLENDED AREA FLAT SO THE FASTENER WILL SEAT PROPERLY WHEN REINSTALLED AND REFINISHED AREA PER THE REF/D1 SRM SECTION. (M)SDR SWAA980918Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AROUND NUTPLATE HOLES AT BS 947, WL 208, RBL 5 TO LBL 43. REPAIRED PER BOEING SRM.SDR SWAA980917Floorbeam · drilledDURING SCHEDULED D CHECK, FOUND HOLE DRILLED IN RADIUS OF FLOORBEAM AT BS 1006, WL 208, RBL 30. REPAIRED PER BOEING SRM.SDR SWAA980916Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CRACKED FLOORBEAM STIFFENER AT BS 328, RBL 32, WL 200. REPAIRED PER BOEING SRM.SDR SWAA980915Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AT BS 294, RBL 39, 45 TO 52, WL 208 AND WL 207. REPAIRED PER BOEING SRM.SDR SQ7A98282Floorbeam · corrodedDURING A SCHEDULED INSPECTION AT LAKE CITY (AERO CORP) FLOOR BEAM AT STA 400 BL ZERO. UPPER CAP WAS FOUND CORRODED BEYOND LIMITS. N/R NR 128746. W/O 060H1-0134. (X)
Back to JASC 5315