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 USAA990876Floorbeam · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND A .25 INCH BY .25 INCH AREA OF CORROSION STATIO N1006, LBL 26 FLOORBEAM. CORROSION LEVEL 1. INSTALLED REPAIR STRAP PER EA 65360 AND SRM 53-00-51 FIG 203. (M)SDR USAA990875Floorbeam · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 1 INCH AREA OF CORROSION LBL 21, 28, 35, 42 AND 45, BS 344, WL 208.1 FLOORBEAM. CORROSION LEVEL 1. INSTALLED NEW SECTION OF T-CAP WITH REPAIR ANGLES PER SRM 53-10-51. (M)SDR CALA9901126Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 927, RT O/B SEAT TRACK. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-60-51.SDR AALA991349Floorbeam · corrodedTUL - FOUND CORROSION ON TOP OF FLOORBEAM AT 1127L, STATION 5300 TO 5800. REMOVED CORROSION AND INSTALLED T-ANGLE REPLACEMENT PER SRM 53-12-10-1. (M)SDR 20000515AP015Floorbeam · corrodedFOUND CABIN FLOORBEAM AT STATION 1110 RBL 18 THROUGH LBL 18 HAS CORROSION AT UPPER AND LOWER SURFACE. REMOVED CORROSION AT FLOORBEAM BETWEEN LBL 18 THROUGH RBL 16. REPAIRED FLOORBEAM AT RBL 17 IAW SRM 53-10-8 FIG 3. (M)SDR SCNA99600Floorbeam · crackedDURING A HEAVY MAINTENANCE CHECK, A FLOORBEAM WAS FOUND CRACKED AT RBL 55 FS 760.95. FABRICATED, TREATED AND INSTALLED A REPAIR DOUBLER IAW B727 SRM 51402 AND 51201, 51302.SDR AT9900636Floorbeam · corrodedSCHEDULED INSPECTION AT TIMCO LAKE CITY, FL, FOUND FLOORBEAM LOWER ANGLE AT BS 965 LBL 42 TO RBL 42 CORRODED. FABRICATED FLOORBEAM REPAIR DOUBLERS, TREATED, PRIMED, REINSTALLED CABLE PULLEY TOWERS, AND RIGGED HORIZONTAL STABILIZER CABLES IAW DC9 MM 27-40-0 PGSDR 2000ZZZX360Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND THE FOLLOWING: CORROSION DAMAGE FLOORBEAM AT STA BS 920 APPROXIMATELY LBL 45. REPAIRED CORROSION DAMAGE IAW FINE AIRLINES EA NR G5310-06:00, SEMAN EO NR 9908202.SDR 2000ZZZX351Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND THE FOLLOWING: CORROSION DAMAGE FLOORBEAM AT STA FS 1680. REPAIRED CORROSION DAMAGE IAW WITH FINE AIRLINES EA NR G5310-05:00, SEMAN EO 9908241.SDR 2000ZZZM238Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND THE FOLLOWING, MAIN CARGO COMPARTMENT RIGHT FLOORBEAM WEB CORRODED AT RBL 35 TO RBL 50, STATION 1640. REPAIRED CORROSION DAMAGE IAW FINE AIR EA NR G5310-04:00, SEMAN EO 9908201. (M)SDR RRXA991635Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, FLOORBEAM AT STA 1727 AT FRAME R/S. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED FLOORBEAM IAW FAA DER ENGINEERING SKETCH NR SK-087-316SDR RRXA991435Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, FLOOR BEAM AT STA Y1727 AT FRAME. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED FLOORBEAM SECTION IAW FAA APPROVED ENGINEERING SKETCH NRSDR CALA9901121Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 377, RBL 59-61.5. THE FLOORBEAM UPPER CHORD WAS REPAIRED IAW SRM 53-10-51 AND ECRA 5321-01060.SDR 9904201162Beam · crackedDURING M CHECK, FOUND CRACK ON FLOORBEAM AT FS 879, RBL 30. REPAIRED PER EA 11-167477.SDR CALA9901113Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT FASTENER HOLE LOCATIONS, STA 328. A NEW UPPER CHORD WAS INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR AWXA9900293Floorbeam · crackedC-CHECK, MAIN CABIN FLOORBEAM FS 578 RBL 65 CRACKED WEB AT WL 207. REMOVED, FABRICATED AND REPAIRED PER ER 2-53-15-86A.SDR AWXA9900286Floorbeam · crackedC-CHECK, CABIN FLOORBEAM RBL 27, STA 685 DOUBLER REPAIR IS CRACKED AT UPPER RADIUS. REMOVED, FABRICATED REPLACEMENT PART, AND INSTALLED IAW SRM 51-30-2.SDR CALA9901104Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 967 ABOUT 20 INCHES FROM CENTERLINE TO BOTH LT AND RT SIDES. THE CORRODED SECTION OF FLOORBEAM WAS REPLACED IAW ECRA 5310-03909.SDR USAA990852Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND CORROSION 60 INCHES BY 2 INCHES AT STATION 344 FLOORBEAM LBL 45 - RBL 15. CORROSION LEVEL 1. CORROSION TASK NR C 53-107-01. INSTALLED NEW SECTION OF UPPER CHORD WITH REPAIR DOUBLER PER SRM 51-70-12 AND EA 6523SDR USAA990844Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A AREA OF CORROSION BS 1016, BBL 0, LBL 12, WL 208 FLOORBEAM. CORROSION LEVEL 1. INSTALLED COMPLETE T-CAP PER SRM 53-10-05 AND EA 65232. (M)SDR USAA990833Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 2 INCH BY 2 INCH AREA OF CORROSION AT STATION 360, RBL 12 FLOORBEAM. CORROSION LEVEL 1. REPAIRED ANGLES PER SRM 53-00-51. (M)SDR USAA990830Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 24 INCH BY 24 INCH AREA OF CORROSION STATION 312, LBL 12, RBL 12 FLOORBEAM. CORROSION LEVEL 1. INSTALLED NEW T-CAP PER SRM 53-10-51. (M)SDR USAA990829Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTINO, FOUND A ..5 INCH BY .5 INCH AREA OF CORROSION STATION 1016, BL 0 TO LBL 12 FLOORBEAM. CORROSION LEVEL 1. CORROSION TASK NR C53-107-02. INSTALLED NEW T-CAP PER EA 65232. (M)SDR CALA9901101Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT FASTENER HOLE, STA 312. A NEW FLOORBEAM UPPER CHORD WAS INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR CALA9901099Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1130, RBL 0 TO WALL. THE CORRODED AREA WAS CUT OUT AND A REPAIR WAS INSTALLED IAW ECRA 5310-03893.SDR SWAA991434Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON BS 727D FLOORBEAM UPPER FLANGE, LBL 17- RBL 3. REPAIRED BEAM PER SWA RA NR 1-A53-2021.SDR CALA9901097Floorbeam · corrodedINSPECTION FOUND RT AND LT AFT LAV FLOORBEAM CORRODED ON NUT PLATE HOLES AT STA 1016, RBL 0 TO RBL 50 AND LBL 0 TO LBL 40. REPAIRED IAW ECRA 5310-03906.SDR CALA9901096Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 985.5 FROM LBL 18 TO R-2 DOOR JAMB. REPAIRED IAW ECRA 5310-03906.SDR AALA991303Floorbeam · brokenTUL - FOUND FLOORBEAM LOWER FLANGE BROKEN COMPLETELY THROUGH THE WIRE BUNDLE STANDOFF SCREW HOLE. INSTALLED ANGLE, EQUAL LEG THICKNESS STAINLESS REPAIR PER SRM 51-40-4 PAGE 5. (M)SDR 99ZZZX4538Stringers · crackedDURING A SCHEDULED INSPECTION, MOVEMENT OF THE FLOOR WAS OBSERVED WHEN THE RUDDER PEDALS WERE MOVED FORE AND AFT BY HAND. THIS WAS FOUND ON BOTH SIDES. THE PEDALS AND TORQUE TUBES WERE REMOVED AND THE FLOOR REMOVED IN THE LOCAL AREA. ONCE THE FLOOR WAS REMOVESDR 99ZZZX4537Stringers · crackedDURING A SCHEDULED INSPECTION, MOVEMENT OF THE FLOOR WAS OBSERVED WHEN THE RUDDER PEDALS WERE MOVED FORE AND AFT BY HAND. THIS WAS FOUND ON BOTH SIDES. THE PEDALS AND TORQUE TUBES WERE REMOVED AND THE FLOOR REMOVED IN THE LOCAL AREA. ONCE THE FLOOR WAS REMOVESDR 2000ZZZX464Floorbeam · corrodedDURING B-CHECK INSPECTION, FOUND THE FOLLOWING: FLOORBEAM CORROSION DAMAGE UPPER FLANGE AT STA FS 1380 RBL 38. REPAIRED CORROSION DAMAGE IAW FINE AIRLINES EA G5310-02:00. (X)SDR 2000ZZZX461Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND THE FOLLOWING: FLOORBEAM CORROSION DAMAGE STA FS 1480. REPAIRED CORROSION DAMAGE IAW FINE AIRLINES EA G5310-03:00. (X)SDR 2000ZZZX460Floorbeam · corrodedDURING B-CHECK INSPECTION, FOUND THE FOLLOWING: FLOORBEAM CORROSION DAMAGE STA FS 1480. REPAIRED CORROSION DAMAGE IAW FINE AIRLINES EA G5310-01:00. (X)SDR UPS99231045Floorbeam · corrodedINSPECTION TYPE:SI, CORROSION ON BS 870 FLOORBEAM TOP SURFACE RBL 20 TO RBL 50 WL 208. REPAIRED BS 870 FLOORBEAM IAW SB B727-53-0116 AND DRW NR 65C23231 SHEET 1 (REF NRC 997381).SDR UPS99230602Floorbeam · corrodedINSPECTION TYPE:SI CORROSION (C53-224-01.05-03) ON BS 1090 FLOORBEAM ON TOP AND BOTTOM OF UPPER CHORD, LBL 48-LBL55, WL 208. REMOVED UPPER CHORD OF FLOORBEAM FABRICATED REPAIR PART, DRILLED UP, ALODINED, PRIMED, SEALED AND INSTALLED IAW SRM 53-10-8, 53-10-01,SDR SWAA991420Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 1016 FLOORBEAM CORRODED, LBL 28.5-33.5. REPAIRED BEAM PER ER NR 99-5770.SDR AWXA9900270Floorbeam · corrodedC-CHECK, CORROSION AT FS 328 RBL 28.5 AT FASTENER LOCATION FWD FLANGE WENT OUT OF LIMITS ON NR 5240823. REMOVED DAMAGED SECTION, FABRICATED REPAIR PARTS, ALODINED, PRIMED AND INSTALLED PER 53-00-51. MATERIAL 7075T6 .090 R609283, 7075T6 .080 R613726.SDR UPS99231046Floorbeam · corrodedINSPECTION TYPE:SI, CORROSION (C53-224-01.00-01) ON FLOORBEAM BS 680 RBL 20 AND LBL 33-54, WL 208. REMOVED AND REPLACED UPPER CHORD OF FLOORBEAM BS 680 LBL 65 TO RBL 65, WORK DONE IAW SRM'S 53-10-1, 51-30-2, 53-10-8 AND MM 51-20-151.SDR UPS99231020Floorbeam · corrodedINSPECTION TYPE:SI, FLOORBEAM IS EXFOLIATED BS 740, LBL 37, WL 208 AND CORROSION AT PREVIOUS REPAIR ANGLE BS 740, LBL 8-22, WL 208 (C53-224-01.05-01). REPAIRED CORRODED FLOORBEAM IAW SRM 53-10-04, 51-30-02.SDR UPS99230974Floorbeam · corrodedINSPECTION TYPE: SI, CORROSION ON FLOORBEAM AT NUTPLATE BS 720 LBL 57 WL 208. REMOVED DAMAGED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53-10-8.SDR UPS99230885Floorbeam · corrodedINSPECTION TYPE:SI, CORROSION (C53-224-01.05-01) ON FLOORBEAM LOWER SURFACE AROUND FASTENER HOLES AT SEAT TRACK ATTACH POINT BS 520, WL 208, LBL 25. REPAIRED CORRODED FLOORBEAM IAW SRM 53-10-08.SDR UPS99230883Floorbeam · corrodedINSPECTION TYPE:SI, CORROSION (C53-224-01.05-01) ON FLOORBEAM LOWER SURFACE AROUND FASTENER HOLES BS 600 WL 208 RBL 50. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53-10-8, FIG 5, 53-10-8 PG 33, 51-10-2 PG 33.SDR UPS99230809Floorbeam · corrodedINSPECTION TYPE:SI, CORROSION ON FLOORBEAM LOWER SURFACE HOLE BS 560, WL 208, LBL 5. REPAIRED CORRODED FLOORBEAM IAW SRM 53-10-08.SDR C2XA99IA447Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED FROM FRAME 15 TO FRAME 18. MAINTENANCE PERFORMED A DOUBLER REPAIR IAW EMBRAER145 FAX SST=1287/99, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR SWAA991414Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM LOWER SURFACE, BS 794, RBL 64. REPAIRED BEAM PER SRM.SDR UPS99230975Floorbeam · corrodedINSPECTION TYPE: SI, CORROSION ON STA 970, LBL 57, WL 208 ON FLOORBEAM UNDER NUTPLATE. REMOVED DAMAGE, FABRICATE REPAIR AND INSTALLED PER SRM 53-10-8, FIG 5, 51-30-2.SDR UPS99230826Floorbeam · corrodedINSPECTION TYPE:SI CORROSION ON BS 950 FLOORBEAM UPPER CHORD, LOWER SURFACE AT LBL 16. CUT OUT DAMAGED FLOORBEAM, FABRICATED REPLACEMENT BEAM AND STRAPS PER ERO 99-6047A ***CPCP***SDR UPS99230825Floorbeam · corrodedINSPECTION TYPE:SI CORROSION ON BS 950 FLOORBEAM UPPER CHORD, LOWER SURFACE (FWD) AND UPPER SURFACE (AFT) CUT OUT DAMAGED FLOORBEAM, FABRICATED REPLACEMENT BEAM AND STRAPS PER ERO 99-6047A.SDR SWAA991405Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 328, RBL 0-49 CABIN FLOORBEAM CORRODED ON UPPER FLANGE. REPAIRED BEAM PER SRM.
Back to JASC 5315