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 CALA0100928Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CAP CORRODED AT STA 947.5, LBL 6 TO RBL 6. THE FLOORBEAM UPPER CAP WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0100925Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON UPPER SURFACE AT STA 294, RBL 53. THE FLOORBEAM UPPER SURFACE WAS REPAIRED IAW SRM 53-10-51.SDR DL72S011678Floorbeam · corrodedFOUND DURING CORROSION MID VISIT INSP MV4. CORROSION ON UPPER SURFACE OF FLOORBEAM STA 344 OUTBOARD OF INBOARD SEAT TRACK. SPLICED IN NEW T-CAP SECTION PER SRM 53-10-8D FIG 802D FROM RBL 10 TO TERMINATION OF FLOORBEAM AT RBL 60.SDR SIMA200127709Floorbeam · corrodedABI - FOUND GALLEY FLOOR CENTER BEAM CORRODED AT FRAME 20. REPAIRED GALLEY FLOOR CENTER BEAM CORROSION AT FRAME 20 IAW EMB145 REPAIR STATEMENT GST 3215/01. (M)SDR SIMA200127711Floorbeam · corrodedFOUND FORWARD DIGITAL CORRODED. REPAIRED FORWARD DIGITAL IAW EMB145 SRM. (M)SDR SIMA200127603Floorbeam · corrodedABI - DURING A MBV INSPECTION, CORROSION WAS FOUND ON THE GALLEY FLOOR FORWARD DIGITAL. REMOVED CORROSION BY BLENDING OUT. PERFORMED NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED A REPAIR DOUBLER IAW EMB GST-3215/01 AND STANDARD SRM SDR SIMA200127602Floorbeam · corrodedDURING AN MBV INSPECTION, CORROSION WAS FOUND ON THE LEFT OMEGA FLOORBEAM AT FRAME 20. REMOVED CORROSION BY CUTOUT. FABRICATED A FILLER AND DOUBLER ANGLE. A PLATE AND TWO SHIMS IAW EMB145 (SRM 145/1142 CHAPTER 53 REV 14) 53-21-10, PG 204, FIG 201, SHEET 1 ASDR SIMA200127609Floorbeam · corrodedABI - THIS IS A LEVEL 3 FINDING ON A CORROSION REPAIR ITEM CARD NR 23803. LEFT OMEGA BEAM CORRODED AT FRAME 20. REPAIRED LEFT OMEGA BEAM AT FRAME 20 IAW EMB 145 SRM 53-21-10 FIG 201, PAGE 20. (M)SDR DHL2001801500Angle · cracked# 6 FLOOR PANEL REINFOCING ANGLE CRACKED 1 IN. FROM STA 1700.000 TO 1766.000STOP DRILLED CRACK PER SRM 53-2-0 FIG 1B.FABRICATED REINFOCING ANGLE (2024 T3 0.040) PER SRM 53-2-0 FIG 1 B.CLEAND TREATED AND PRIMED PER SRM 51-1-8B.INSTALLED REINFOCING ANGLE PER SRMSDR AWXA200100532Floorbeam · corrodedMCN - C18 CK -C- CORROSION FOUND ON FLOORBEAM UPPER FLANGE AT BS 294.5, RBL 45.5, BEYOND SRM LIMITS AFTER CORROSION CLEAN UP. MAINTENANCE REMOVED DAMAGED SECTION OF FLOORBEAM FROM RBL 32 TO RBL 66, FABRICATED REPAIR PARTS AND INSTALLED IAW B737 SRM 53-10-51, SDR AWXA200100529Floorbeam · corrodedMCN - C18 CK -C- CORROSION FOUND ON FLOORBEAM UPPER FLANGE AT BS 312, LBL 2 TO RBL 3, BEYOND SRM LIMITS. MAINTENANCE REMOVED FLOORBEAM UPPER FLANGE FROM LBL 18 TO RBL 22, FABRICATED REPLACEMENT PART AND INSTALLED IAW B737 SRM 53-10-51, FIG 205, PG 220 - 223.SDR AWXA200100527Floorbeam · corrodedMCN - C18 CK - C - CORROSION FOUND ON FLOORBEAM UPPER FLANGE AT BS 312, RBL 6 TO RBL 13, WL 208, BEYOND SRM LIMITS AFTER CORROSION CLEAN UP. MAINTENANCE REMOVED DAMAGED FLOORBEAM UPPER FLANGE FROM LBL 18 TO RBL 22, FABRICATED REPAIR FLOORBEAM UPPER FLANGE ANDSDR AWXA200100523Floorbeam · corrodedMCN - C18 CK - C - CORROSION FOUND ON FLOORBEAM UPPER FLANGE AT BS 294.5, RBL 32, BEYOND SRM LIMITS AFTER CORROSION CLEAN UP. MAINTENANCE REMOVED DAMAGED FLOORBEAM UPPER CHORD, FABRICATED AND INSTALLED FLOORBEAM UPPER CHORD IAW B737 SRM 53-10-51, FIG 205, PG SDR SWAA012735Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 334, BL 0.0 TO LBL 12.0. REPAIRED FLOORBEAM PER SRM.SDR 01FDEA00867Floorbeam · corrodedCORROSION (C53-224-01,1) ON FLOORBEAM BS 344, LBL 40 TO RBL 5, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8, 53-10-1, 51-30-2 & 51-10-6.SDR AWXA20010062Floorbeam · corrodedPHX - C8 CK - C - CORROSION FOUND ON FLOORBEAM UPPER CAP AT BS 365.25, RBL 18, BEYOND SRM LIMITS AFTER CORROSION REMOVAL. MAINTENANCE MADE STRAP REPAIR ON FLOORBEAM UPPER CAP IAW AWA ER 19-5310-01289-KB1.SDR SIMA200127601Floorbeam · corrodedABI - DURING AN MBV INSPECTION AIRCRAFT 647AE CORROSION WAS FOUND ON THE GALLEY FLOOR CENTER BEAM AT FRAME 20. REMOVED CORROSION BY BLENDING AND CUT OUT DAMAGED AREA. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTION INDICATED. FABRICATED A FILLER, SDR AWXA200100498Floorbeam · crackedYVR - C19 CK -LONGITUDINAL SEAT TRACK SUPPORT BEAM, LBL 24.5 CRACKED AT BOLT RELIEF HOLE, BS 679. MAINTENANCE MADE REPAIRS IAW AWA ER 15-5710-01269-JS1, REFERENCING BOEING S/B 737-57-1139, REV 4, FIG6.SDR SIMA200127607Floorbeam · corrodedABI - THIS IS LEVEL 2 FINDING ON A CORROSION REPAIR ITEM. FORWARD DIGITAL CENTER 2 INCH AFT OF COCKPIT WALL CORRODED. BLENDED, INSPECTED AND ACCEPTED AS IS IAW EMB GS 3196/01. (M)SDR SIMA200126922Floorbeam · corrodedABI - DURING MBV INSPECTION, FOUND FORWARD CENTER DIGITAL 2 INCH AFT OF COCKPIT WALL CORRODED. REPAIRED CENTER DIGITAL IAW EMB REPAIR STATEMENT GST 3196/01. (M)SDR SWAA012686Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 814, LBL 18 TO RBL 3. REPAIRED FLOORBEAM PER SWA RA 1-353-2668.SDR CALA0100901Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT STA 312, LBL 20 - RBL 20. THE FLOORBEAM CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR UPS01836912Floorbeam · corrodedINSPECTION TYPE:C2 FLOORBEAM AT STA 160 CORRODED. REPLACED SECTION OF FLOORBEAM & SPLICED.SDR 2001UALA02073Floorbeam · corrodedFLOORBEAM TOP CAP CORRODED STA 680, RBL 9 TO LBL 9. MAJOR REPAIR ACCOMPLISHED. SPLICED IN NEW TOP CAP.SDR UPS01836994Floorbeam · corrodedINSPECTION TYPE: C1, STA. -80 LOWER FLOORBEAM CAP IS CORRODED BEYOND LIMITS AT LBL. 44 REPAIRED FLOORBEAM I.A.W. 8110-3 APPROVED DH SK 867-840SDR C2XA01TY120Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE RAMP ANGLE BETWEEN FRAMES 19 AND 20. MAINTENANCE REMOVED AND REPLACED THE RAMP ANGLE IAW EMB-145 SRM 51-40-02, REPAIR WAS SATISFACTORY. AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR SWAA012587Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 21 & WL 208. REPAIRED FLOORBEAM PER SRM.SDR C2XA01IA360Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT HAND DIGITAL AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REPAIRED THE AFFECTED DIGITAL, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA20011812Floorbeam · corrodedTUL - FOUND SATION 1130 TOP OF FLOORBEAM BETWEEN LEFT SEAT TRACKS CORRODED. FABRICATED AND INSTALLED REPAIR STRAP PER ESO 11697 DATED 9-17-01. (M)SDR AALA20011865Floorbeam · corrodedTUL - FOUND LOWER FLANGE OF FLOORBEAM WORN STATION 389 RBL 1. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER PER AARD 53-20-00-21. (M)SDR SIMA200126007Floorbeam · corrodedABI - DURING MBV INSPECTION, CENTER FLOORBEAM BETWEEN FRAMES 24 AND 26 WAS FOUND TO BE CORRODED. REMOVED CORROSION IAW EMB 135 SRM 51-10-02. INSTALLED REPAIR DOUBLER ON CENTER FLOORBEAM IAW EMB 135 SERVICE LETTER GST 3143/01. (M)SDR SIMA200126014Floorbeam · corrodedABI - DURING MBV INSPECTION, FOUND CENTER OMEGA BEAM BETWEEN FRAMES 24 AND 25 CORRODED. FABRICATED REPAIR DOUBLER AND INSTALLED ON AIRCRAFT IAW EMB 135 REPAIR STATEMENT GST-2930/01 AND EMB 135 SRM. (M)SDR SIMA200126013Floorbeam · corrodedABI - DURING MBV INSPECTION, FOUND CORROSION ON THE LEFT FLOORBEAM AT FRAME 20. FABRICATED FILLER AND DOUBLER AND INSTALLED ON AIRCRAFT IAW EMB 135 SRM. (M)SDR SIMA200126011Floorbeam · corrodedDURING MBV, LEFT FLOORBEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 23 AND 24. REMOVED CORROSION IAW EMB 135 SRM. (M)SDR SIMA200126010Floorbeam · corrodedABI - DURING MBV RIGHT FLOORBEAM WAS TO BE CORRODED BETWEEN FRAMES 17 AND 18. REMOVED CORROSION IAW EMB 135 SRM 51-10-02. (M)SDR SIMA200126009Floorbeam · corrodedABI - DURING MBV, FOUND FORWARD DIGITAL TO BE CORRODED. REMOVED CORROSION AND FOUND TO BE ACCEPTABLE IAW EMB135 SERVICE LETTER GST 3128/01. (M)SDR 01FDEA00852Floorbeam · misdrilledN 783 FLOORBEAM LWR FLANGE HAS DRILL HOLE IN RADIUS BS 460, RBL 45, WL 208. R&R FLOORBEAM PER SR 27-53-034E & SRM 51-30-2.SDR 2001UALA02056Stiffener · crackedSTATION 246 RBL 40 FLOOR BEAM VERTICAL STIFFENER CRACKED SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHEDFABRICATED AND INSTALLED NEW STIFFENERNOTED CRACKING OF THE STIFFENER IS DUE TO THERMAL CONTRACTION THAT RESULTS IN HIGHER THAN EXPECTED IN-SERVICE LOADISDR 2001UALA02055Stiffener · crackedSTATION 246 RBL 38 FLOOR BEAM VERTICAL STIFFENER CRACKED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHEDFABRICATED AND INSTALLED NEW STIFFENER.NOTED CRACKING OF THE STIFFENER IS DUE TO THERMAL CONTRACTION THAT RESULTS IN HIGHER THAN EXPECTED IN-SERVICE LOASDR 01FDEA00838Floorbeam · corrodedCORROSION (C53-224-1-, 1) ON FLOORBEAM BS 620 LBL 25 TO 45, WL 208. REMOVED AND REPLACED CORROSION ON FLOORBEAM PER SRM 53-10-8.SDR 01FDEA00839Floorbeam · corrodedCORROSION (C53-024-02) ON FLOORBEAM TOP CHORD UPPER AND LOWER FLANGE BS 680, RBL 3 - 25, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8 FIG 3.SDR SWAA012565Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 30 TO RBL 60. REPAIRED FLOORBEAM PER SWA T1-553-005.SDR USAA011253Floorbeam · corrodedPIT- FOUND BEAM CAP CORRODED SEVERAL AREAS APPROXIMATELY 1 INCH, AT SCREW HOLES ON CENTER SECTION OF BS 312 FLOORBEAM. (M)SDR UPS01836935Floorbeam · corrodedINSPECTION TYPE:C2 FLOORBEAM IS CORRODED BEYOND LIMITS AT STA 1360 AT LBL 48. REPAIRED FLOORBEAM IAW 8110-3 APPROVED DH SK 852-652.SDR SWAA012572Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 294, RBL 40 TO RBL 46. REPAIRED FLOORBEAM PER SRM.SDR ASAA0110590Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 616-724, BUTTOCK LINE 0 CORRODED. REPAIRED PER SRM. (M)SDR SWAA012549Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED 1 INCH LONG AT BS 665, LBL 25. REPAIRED BEAM PER SWA RA 1-353-2650.SDR COMA0160729Angle · crackedLEFT SIDE INBOARD ANGLE AT F.S. 484.0 LBL 9 UNDER FLOOR PANEL 261CLF IS CRACKED.REPAIRED THE ANGLE AT FS 484.0 LBL9 I/A/W WVAC EO 601R-53-2711A.SDR COMA0160728Angle · crackedLEFT SIDE INBOARD ANGLE AT F.S. 484.0 LBL 27 UNDER FLOOR PANEL 261DLF IS CRACKED.REPAIRED THE ANGLE AT F.S. 484.0 LBL27 I/A/W WVAC EO 601R-53-2711A.SDR COMA0160727Angle · crackedRIGHT SIDE ELEVATER AND RUDDER PULLEY SUPPORT BRACKET AT F.S. 484.0 UNDER FLOOR PANEL 262DRF IS CRACKED.REPAIRED THE RIGHT SIDE ELEVATER AND RUDDER SUPPORT BRACKET AT F.S. 484.0 I/A/W WVAC EO 601R-53-2711A.
Back to JASC 5315