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 CALA0300225Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 284 RBL 42 BELOW SEAT TRACK. REMOVED DAMAGED SECTION. FABRICATED NEW FLOORBEAM, TREATED, PRIMED AND INSTALLED PER SRM 53-10-51 FIG 205.SDR CALA0300223Floorbeam · corrodedTHREE FASTENERS CORRODED IN FLOORBEAM. REPLACED UPPER STRUCTUREAS REQUIRED IN SRM 53-10-51.SDR CALA0300219Floorbeam · corrodedI-BEAM AT STATION 986.5 AFT GALLEY HAS CORROSION THROUGHOUT ENTIRE LENGTH MARKER (8 INCHES). REMOVED CORROSION, REPAIRED FLOORBEAM PER SRM 53-30-51.SDR 03FDEA00596Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE B/S 344, LBL 25-45, WL 208. REMOVED CORROSION ON SEAT TRACK FLANGE BS 460, LBL 25, WL 208. FOUND TO BE OUT OF LIMITS PER SRM 53-10-01. REMOVED & REPLACED SEAT TRACK BS 344 TO 480, LBL 25, WL 208 PER SRM 51-30-02, 53-SDR TSAA0353111Floorbeam · corrodedFOUND CORROSION ON UPPER FLOORBEAM AT BS 344 BLENDED OUT 1 INCH BY 1 INCH AREA IN TWO PLACES. CUTOUT DAMAGED AREA. FABRICATED NEW FLOORBEAM SECTION PER TABLE II, DETAIL I. ALODINE, PRIMED, AND INSTALLED REPAIR PARTS WET MAKING A FAYING SURFACE SEAL. REPAIR COSDR SIMA200311805Floorbeam · corrodedDURING AN IMBV INSPECTION, THE LT FLOORBEAM AT FRAME 25 WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT THE DAMAGED SECTION ON THE LEFT FLOORBEAM. CLEANED, AND TREATED THE REPAIR AREA. FABRICATED AN EXTERNAL ANGLE, FILLER AND TWO SHIMS. REPAIR DONE IAW ESDR AWXA200300456Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-17 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOOR SUPPORT BEAM BS 1006-1016, LBL 10. MAINTENANCE REMOVED FLOOR SUPPORT BEAM BS 1006-1016, LBL 10 AND UPON FURTHER EVALUATION DISCOVERED FILLER WAS CORRODED BEYOND LIMITS; FABRICATEDSDR 03FDEA00580Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE BS 620, RBL 25 TO LBL 45, WL 208. CORROSION ON FLOORBEAM UPPER FLANGE BS 620, RBL 25. FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED AND REPAIR FLOORBEAM UPPER FLANGE AT BS 620, RBL 25 IAW SRM 53- 10-8.SDR 03FDEA00581Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE BS 328, LBL 33 TO LBL 23, WL 208.SDR CALA0300212Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1016 FROM RBL 10 TO LBL 35. THE CORRODED AREA WAS REMOVED AND A REPAIR WAS PERFORMED IAW SRM 53-00-51, FIGURE 202.SDR C2XA03SH115Floorbeam · corrodedSHV-DURING C-CHECK THE CENTER FLOORBEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 202 SHEET 1. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH114Floorbeam · corrodedSHV-DURING C-CHECK THE LT FLOORBEAM BETWEEN FRAMES 20 AND 21 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 51-30-01. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH113Floorbeam · corrodedSHV-DURING C-CHECK THE LEFT HAND FLOORBEAM BETWEEN FRAMES 24 AND 25 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 202 SHEET 1. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWIA200312060Floorbeam · crackedFS 280 PILOT'S BULKHEAD LBL 90 AFT FLOOR ANGLE CRACKED. DISCOVERED DURING C-CHECK. REPAIRED DAMAGED AREA IAW CRJ REO 601R-53-11-138 NC.SDR SWAA030887Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 996.5, LBL 21. REPAIRED FLOOR BEAM PER SWA EA.SDR C2XA03SH112Floorbeam · corrodedSHV-DURING C-CHECK THE CENTER FLOORBEAM ANGLE AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED ANGLE IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA03SH109Floorbeam · corrodedSHV-DURING C-CHECK THE CENTER FLOORBEAM BETWEEN FRAMES 18 AND 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA03173Floorbeam · corrodedDURING A C-CHECK IN MCN, THE CARGO COMPARTMENT FLOORBEAM AT LBL 27 AND FS 589 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE CARGO COMPARTMENT FLOORBEAM AT LBL 27 AND FS 589 IAW SRM 51-00 AND SRM 53-00. (M)SDR ASOA03170Floorbeam · corrodedDURING A C-CHECK IN MCN, THE LT AND RT 9 AND 27 FLOORBEAMS BETWEEN FS 280 AND FS 379 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE LEFT AND RIGHT 9 AND 27 FLOORBEAMS BETWEEN FS 280 AND FS 379 IAW ASA EO 600-53-0052. (M)SDR HOC2003F00006Floorbeam · corrodedDURING A (C) CHECK CORROSION WAS NOTED ON CABIN FLOORBEAM, STA 1110, BL-0.SDR SIMA200311311Floorbeam · corrodedDURING AN IMBV INSPECTION A PREVIOUS REPAIR ON THE LEFT FLOORBEAM AT FRAME 20 WAS FOUND CORRODED. REMOVED THE PREVIOUS REPAIR AND CLEANED THE AREA. FABRICATED AN EXTERNAL ANGLE, FILLER, PLATE AND TWO SHIMS. REPAIR DONE IAW EMB SRM, SRM EMB-145/1142 REV 21, SDR SIMA200311312Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, THE GALLEY FORWARD FLOORBEAM WAS FOUND TO BE CORRODED BELOW SRM LIMITS. CUT OUT THE DAMAGED SECTION OF THE FORWARD FLOORBEAM. FABRICATED A REPAIR STRAP, SHIM AND TWO DOUBLERS. REPAIR DONE IAW EMB SRM, SRM 145/1142 REV 21 CHASDR SWIA200312024Floorbeam · crackedFS 621.0 LBL 42 LEFT FLOORBEAM ANGLE CRACKED. FOUND DURING C-CHECK INSPECTION. REPAIRED DAMAGED AREA IAW CRJ REO 601R-53-61-117.SDR SWAA030886Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAMS CORRODED AT RBL 8, BS 813, BS 827, BS 825, BS 845 & BS 847. REPAIRED FLOOR BEAMS PER SWA EA.SDR CALA0300200Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AROUND NUT PLATE HOLE AT STA 344, LBL 35. REPAIRED ONE FLANGE OF THE FLOORBEAM UPPER CHORD IAW SRM 53-10-51, FIGURE 206, SHEET 4.SDR DHL2003741546Floorbeam · crackedDURING C-CHECK DISCREPANCY AS FOLLOWS, FLOORBEAM AT BS 1070 LWR FLANGE FWD SIDE AT APPROXIMATELY LBL 14.0 CORRODED. DAMAGE FOUND OUT OF LIMITS IAW B-727 SRM 53-10-1 FIG 2. CUT OUT DAMAGED AREA DIMENSIONS 2 X 4 INCHES ON LWR FLANGES IAW B-727 SRM 53-10-8 FIG SDR SWAA030852Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAMS CORRODED AT BS 727D + 5, RBL 3 & BS 727B + 3, LBL 3. REPAIRED FLOORBEAMS PER SWA EA.SDR 03FDEA00456Floorbeam · corrodedCORROSION ON FLOORBEAM STA 1130 BETWEEN LBL 45 TO RBL 45 WL 200.SDR C2XA03TY048Floorbeam · corrodedTYS, DURING A SCHEDULED INSPECTION THE FORWARD DIGITAL PLATE WAS FOUND CORRODED AFT OF THE COCKPIT STEP IN THE GALLEY. MAINTENANCE REMOVED AND REPLACED THE CENTER FORWARD DIGITAL IAW EMB-145 SRM 53-21-10, 51-40-02, 51-21-04/05 AND 06. THE REPAIR WAS SATISFACSDR ABXA030165Floorbeam · corrodedFLOORBEAM WAS EXFOLIATED AT FS 408 DIRECTLY ABOVE FORWARD LOWER CARGO DOOR CUTOUT AND OUTBOARD OF RIGHT BUTT LINE 54. REPAIRED AREA IAW REA D953-47171 AND DC-9 SRM.SDR AWXA200300524Floorbeam · crackedMCN - MAJOR REPAIR - DURING C-17 CHECK 5 EACH CRACKS WERE FOUND ON FLOORBEAM SHEAR WEB BS 927 TO BS 947, BL 0. MAINTENANCE REMOVED CRACKED FLOORBEAM SHEAR WEB FROM BS 927 TO BS 947, AND ATTACH ANGLE; FABRICATED AND NEW REPLACEMENT SHEAR WEB PER DWG 69-36656-5SDR UPS03240671Floorbeam · corrodedINSPECTION TYPE: C&SI, CORROSION UNDER ANCHOR CLIP ON LWR SIDE OF FLOORBEAM TOP STRUCTURE BS 344 LBL 12 APPROX. REPAIR CARRIED OUT IAW SRM 53-10-8 FIG 7SDR AWXA200300515Floorbeam · crackedYVR - MAJOR REPAIR - DURING C-15 CHECK A 3 INCH CRACK WAS FOUND ON VERTICAL FLOORBEAM WEB AT LT OUTBOARD SIDE BS 695, LBL 57. MAINTENANCE REMOVED DAMAGED SECTION OF VERTICAL FLOORBEAM WEB AT LT OUTBOARD SIDE BS 695, LBL 57; FABRICATED A NEW REPLACEMENT SECTIOSDR UPS03440627Floorbeam · corrodedINSPECTION TYPE: C, U/D - FLOORBEAM UPPER STRUCTURE FOUND CORROSION AT BS 340 BL 0 - LBL 40 FLOORBEAM UPPER STRUCTURE REPAIRED AS PER SRM 53-10-07 FIG.23 CORROSION BLEND OUT SIZE 0.038 X 1 X 3 INCHES.SDR AWXA200300457Floorbeam · corrodedYVR - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON FLOORBEAM UPPER CAP AT BS 1016, LBL 27.75. MAINTENANCE BLENDED OUT CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS. REMOVED DAMAGED SECTION OF FLOORBEAM UPPER CAP AT BS 1016, LBL 27.75; FABRICATEDSDR AWXA200300443Floorbeam · corrodedYVR - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON UPPER CAP OF FLOORBEAM AT BS 294.5, RBL 20. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED TO ACCESS DAMAGED AREA SEAT TRACKS BS 294.5, RBL 45, BS 274.5, RBL 45, SDR 2003UALA00378Floorbeam · damagedCABIN FLOORBEAM STA 947 UPPER CAP HAS FREEZE PLUG DRILLED INTO EDGE AT APPROXIMATE LBL 20. REMOVED, MANUFACTURED AND INSTALLED UPPER "T" CAP.SDR 2003UALA00377Floorbeam · corrodedCABIN STATION 942 FLOORBEAM CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED FLOORBEAM CAP.SDR UPS03440541Floorbeam · corrodedINSPECTION TYPE: C, FLOORBEAM UPPER STRUCTURE CORROSION. FLOORBEAM REPAIRED PER SRM 51-40-04 FIG 3. CORROSION BLEND OUT 0.060 X 2 X 2 INCHES. EXCEED SRM LIMIT.SDR UPS03440498Floorbeam · corrodedINSPECTION TYPE:N/A M/D - BS 760 LBL 40 FLOORBEAM UPPER SURFACE FOUND CORRODED. FLOORBEAM REPAIRED PER SRM 51-40-04 FIG 3. CORROSION BLEND OUT 0.060 X 2 X 2 INCHES, EXCEED SRM LIMIT.SDR CALA0300193Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1016, LBL 27. THE UPPER T-CAP ON FLOORBEAM WAS REPLACED IAW ECRA 5310-03851.SDR UPS03440512Floorbeam · corrodedINSPECTION TYPE: C, FLOORBEAM UPPER STRUCTURE FOUND CORRODED. FLOORBEAM REPAIRED PER SRM 51-40-04 FIG 3. CORROSION BLEND OUT 0.050 X 1 X 1 INCHES. EXCEED SRM LIMIT.SDR ASOA03159Floorbeam · corrodedDURING A C-CHECK IN MCN, THE LEFT AND RIGHT FLOORBEAMS AT BL 27 IN THE SERVICE DOOR AREA WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE LEFT AND RIGHT FLOORBEAMS (P/N'S 601R53-037K1A AND 601R53-037K4A) AT BL 27 IN THE SERVISDR ASOA03158Floorbeam · corrodedDURING A C-CHECK IN MCN, THE LEFT AND RIGHT FLOORBEAMS AT BL 9 IN THE SERVICE DOOR AREA WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE LEFT AND RIGHT FLOORBEAMS (P/N'S 601R53-037K2A AND 601R53-037K3A) AT BL 9 IN THE SERVICESDR PCA0300832Floorbeam · corrodedFLOORBEAM TOP CHORD LWR SURFACE AT BS 2240 LBL 40 CORROSION. REPAIRED PER SRM 53-10 FIG 12.SDR CH1A200395026Floorbeam · corrodedSURFACE CORROSION FOUND ON FLOORBEAM BETWEEN LBL 45 TO LBL 62 AT BS 1035SDR CH1A200395022Floorbeam · corrodedFLOORBEAM AT BS420 CORRODED BETWEEN RBL 12 & RBL 22.SDR CH1A200395021Floorbeam · corrodedFLOORBEAM STABILIZER STRAP AT BS 358 LBL 23 IS CRACKED.SDR CH1A200395025Floorbeam · corrodedCORROSION FOUND ON BS 1030 FLOORBEAM UPPER STRUCTURE AROUND FASTENER HOLES LBL 24 & RBL 24.SDR CH1A200395024Floorbeam · corrodedFLOORBEAM AT BS 344 BETWEEN RBL 22 & RBL 62 HAS CORROSION IN NUMEROUS PLACES.
Back to JASC 5315