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 2001UALA01128Floorbeam · corrodedFLOORBEAM CORRODED STA 365, BL 0 TO RBL 64. MAJOR REPAIR ACCOMPLISHED. REPLACED UPPER T-CAP.SDR CALA0100602Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, BL 0 TO LBL 59. THE FLOORBEAM WAS REMOVED AND A NEW FLOORBEAM WAS INSTALLED IAW SRM 53-10-51.SDR USAA010825Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 32 INCH AREA, Z-ANGLE AFT FORWARD ENTRANCE FROM FLOORBEAM. (M)SDR USAA010816Floorbeam · corrodedPIT - FOUND T-CAP CORRODED 2 INCH BY 62 INCH AREA, BEAM 328 BETWEEN B10 AND RBL 62. SPLICED IN SECTION OF UPPER CHORD, TREATED, PRIMED, SEALED PER SRM 53-10-51. (M)SDR USAA010815Floorbeam · corrodedPIT - FOUND BEAM T-CAP CORRODED 2 INCH BY 29 INCH AREA, BEAM 312 BETWEEN LBL 10 AND RBL 19. CORROSION LEVEL 1, TASK NR C53-107-02. REPLACED SECTION OF T-CAP, TREATED AND PRIMED PER SRM 53-10-51, 51-40-02. (M)SDR USAA010823Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 2 INCHES, CLIP NUT ON FLOORBEAM 328 LEFT. CORROSION LEVEL 1. SPLICED IN SECTION OF UPPER CHORD, TREATED, PRIMED, SEALED PER SRM 53-10-51, 51-40-02. (M)SDR USAA010827Floorbeam · corrodedPIT - FOUND 6 INCHES OF CORROSION AT FLOORBEAM 328 LT OUTBOARD OF LBL 45. CORROSION LEVEL 1. SPLICED IN SECTION OF UPPER CHORD, TREATED, PRIMED, SEALED PER SRM 53-10-51, 51-40-02. (M)SDR 2001UALA01138Floorbeam · damagedCABIN FLOORBEAM WEB HAS EXCESSIVE MATERIAL LOSS AT BS 1016, LBL 28. ACCOMPLISHED REINFORCEMENT REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA01130Floorbeam · crackedFLOORBEAM CRACKED AT BS 660. ACCOMPLISHED STRAP AND ANGLE REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR CALA0100590Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, LBL 49. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-10-51.SDR SWAA011841Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CENTER LONGITUDINAL FLOORBEAM CRACKED AT BS 660 & BS 663. REPAIRED FLOORBEAM PER SRM.SDR SWAA011836Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 39 & WL 208. REPAIRED FLOORBEAM PER SRM & SWA RA.SDR 2001UALA01142Floorbeam · corrodedBS 1241 LBL 47 T-CAP CORRODED. *S/D* FABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH BAC DWG 146T1208 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01103Floorbeam · corrodedFLOORBEAM CAP CORRODED. STA 1640, LBL 6 AND RBL 62. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE SPLICE.SDR SWAA011795Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 295, LBL 6. REPAIRED FLOORBEAM PER SRM.SDR SWAA011794Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED UNDER FLOOR SUPPORT AT BS 859, RBL 8.0. REPAIRED FLOORBEAM PER SWA RA.SDR COOSDR010037Floorbeam · corrodedPAX CABIN, STA 947 FLOOR BEAM UPPER FLANGE CORRODED AT LBL 50.SDR 2001F00128Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED FLOORBEAMS 36, 38, 39 AND 40 CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED FLOORBEAMS IAW ATR 72 SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. REFSIMA200117108. (M)SDR 2001F00127Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED FLOORBEAMS 36, 38, 39 AND 40 CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED FLOORBEAMS IAW ATR 72 SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA200117108. (M)SDR SIMA200117108Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED FLOORBEAMS 36, 38, 39 AND 40 CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED FLOORBEAMS IAW ATR 72 SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 2001F00125Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED FLOORBEAMS 36, 38, 39 AND 40 CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED FLOORBEAMS IAW ATR 72 SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. REFSIMA200117108. (M)SDR SIMA200117105Floorbeam · corrodedABI - FOUND DURING MBV INSPECTION OF THE AIRCRAFT, THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND TO BE BELOW SRM LIMITS AFTER REMOVAL OF CORROSION. REPAIRED CORRODED AREA, WORK DONE IAW EMB145 SRM 1142 REV 12, 53-21-10 PARA 2 PAGE 201, 202 AND FIG 201 SHEET 1. (SDR ABXA010377Floorbeam · corrodedFLOORBEAM AT STA 965, LEFT BUTT LINE 45 WAS CORRODED ON AFT SIDE THROUGH LIGHTENING HOLE. REPAIRED FLOORBEAM IAW REA D953-41486MR.SDR ABXA010378Floorbeam · corrodedFORWARD SIDE OF FLOORBEAM WEB EXFOLIATED AT FS 389, AT APPROXIMATELY LEFT BUTT LINE 48. REPAIRED FLOORBEAM AT FS 389, LEFT BUTT LINE 48 IAW REA D953-41479. MATERIAL REMOVED WAS APPROXIMATELY 1 - 2 INCHES.SDR AWXA0001884Floorbeam · corrodedMAIN CABIN BS 986.5 BL 0 TO LBL 20, FLOORBEAM HAS SEVERAL AREAS OF CORROSION. REMOVED AND REPLACED UPPER T-CHORD IAW B737-300 SRM 53-00-51 PG 207-211.SDR 2001UALA01089Floorbeam · corrodedBS 368 LBL 33 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07 AND 51-40-02.SDR SWAA011787Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 727D+6, LBL 12 TO RBL 2.5. REPAIRED PER SWA RA.SDR SWAA011770Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 794, LBL 2.5. REPAIRED FLOORBEAM PER SRM.SDR HN6R0000244Floorbeam · corrodedCORROSION ON FLOOR BEAM AT BS 294.5, RBL45, WL208. CAUSE UNKNOWN. REMOVED DAMAGE FABRICATED REPAIR PART AND INSTALLED.SDR ABXA010369Floorbeam · corrodedFLOORBEAM LOWER FORWARD ANGLE CORRODED AT FS 965 LT, LBL 22-44. REPAIRED AREA IAW REA D953-41486MR.SDR 2001UALA01049Support · corrodedFLOOR SUPPORT CORRODED. MAJOR REPAIR ACCOMPLISHED.INSTALLED NEW J-ANGLE AND STRAP.SDR AWXA0001879Floorbeam · corrodedMAIN CABIN BS 967 LBL 27 TO LBL 49 FLOORBEAM UPPER CHORD HAS CORROSION UPPER AND LOWER SURFACE. REMOVED AND REPLACED FLOORBEAM UPPER CHORD IAW B737 SRM 51-40-05 PG 6-10.SDR AWXA0001878Floorbeam · corrodedBS 967 RBL 4 TO RBL 18 FLOORBEAM UPPER CHORD HAS CORROSION IN SEVERAL AREAS. REMOVED AND REPLACED FLOORBEAM UPPER CHORD IAW B737-300 SRM 51-40-05 PG 6-10.SDR EISA20010100Floorbeam · corrodedAFT PIT-CABIN FLOORBEAM BS 1110 RBL 22 AFT SIDE EXFOLIATED AT NUT CLIP. CUT OUT CORRODED SECTION OF THE UPPER FLANGE OF FLOORBEAM, FABRICATED AND INSTALLED FILLER AND DOUBLER REPAIRS IAW B727 SRM 53-10-8 FIG 1.SDR 2001UALA01045Floorbeam · corrodedCABIN FLOOR SUPPORT CORRODED. STA 297, RBL 40-42. MAJOR REPAIR ACCOMPLISHED. REPLACED L-ANGLE.SDR SWAA011775Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CENTER LONGITUDINAL FLOORBEAM CRACKED AT BS 663. REPAIRED FLOORBEAM PER SRM.SDR SWAA011765Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 773, RBL 7.5 TO LBL 2.5. REPAIRED FLOORBEAM PER SWA RA.SDR SWAA011763Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 500C, LBL 18 TO RBL 13. REPAIRED FLOORBEAM PER SRM.SDR SWAA011762Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 9 TO RBL 8. REPAIRED FLOORBEAM PER SWA TI.SDR SWAA011752Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAMS CORRODED AT BS 294, RBL 16 WL 208. REPAIRED FLOORBEAMS PER SRM.SDR SWAA011750Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 737.5, LBL 12 & WL 157. REPAIRED FLOORBEAM PER SRM.SDR AWXA0001882Floorbeam · corrodedMAIN CABIN, BS 947, LBL 24 TO RBL 8 FLOORBEAM UPPER CHORD, CORROSION ON UPPER AND LOWER SURFACE. CORROSION OUT OF LIMITS. REMOVED AND REPLACED UPPER T-CHORD IAW B737 SRM 53-00-51 PG 208-211 FIG 202.SDR AWXA0001881Floorbeam · corrodedMAIN CABIN BS 986.5 BL 0 TO RBL 45 FLOORBEAM HAS SEVERAL AREAS OF CORROSION. CORROSION OUT OF LIMITS UPPER CHORD REPLACED IAW B737 SRM 53-00-51 PG 207-211.SDR CALA0100551Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 48. THE TOP CAP OF FLOORBEAM WAS REPLACED IAW ECRA 5310-03851.SDR EISA20010099Floorbeam · crackedFLOORBEAM IS CRACKED IN THE RT MID CABIN AT BS 848, UNDER THE O/B, RT SEAT TRACK APPROX 10 INCHES LONG IN LENGTH. REMOVED CRACKED SECTION. FABRICATED AND INSTALLED A NEW WEB, WEB SPLICE AND T-CAP REPAIRS IAW B727 SRM 51-40-2 FIG 1 & 51-30-2.SDR 2001UALA01044Floorbeam · corrodedCABIN FLOORBEAM UPPER SURFACE CORRODED. STA 324, RBL 58 MAJOR REPAIR ACCOMPLISHED. INSTALLED FREEZE PLUB AND INSTALLED T-ANGLE REPAIR.SDR 2001UALA01074Floorbeam · corrodedAFT CARGO PIT BS 1175 UNDER T-CAP FROM LBL 30-RBL 45, BOTH SIDES OF WEB CORRODED UNDER NUT PLATES. MAJOR REPAIR ACCOMPLISHED. REPLACED T-CAP PER SRM 53-00-51, BAC DRAWING 146T1060 AND INSTALLED PER SRM 51-40-2.SDR 2001UALA01067Floorbeam · corrodedFWD PIT STA 544, LBL 20, T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. REPAIRED T-CAP PER SRM 53-30-07, FIG 1.SDR 2001UALA01066Floorbeam · corrodedAFT CARGO PIT BS 1175 UNDER T-CAP FROM LBL 30 TO RBL 45, BOTH SIDES OF BS 1175 WEB CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED T-CAP PER SRM 53-00-51 AND 51-40-02 AND BAC DRAWING 146T1060.SDR 2001UALA01043Floorbeam · corrodedCABIN FLOORBEAM CORRODED STA 345 - 365, BL 0. MAJOR REPAIR ACCOMPLISHED. REPLACED FLOORBEAM SUPPORT.
Back to JASC 5315