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 P2EA00338Doubler · crackedSJO - DURING Q-CHECK, FOUND DOUBLER ON PREVIOUS REPAIR ON FLOORBEAM AT AILERON CONTROL QUADRANT AT BS 678 RBL 24.82 CRACKED. L = 1.00 INCH. W = 0.002 INCH. IDENTIFIED AS REPORTABLE ON 11-7-00. REPLACED DOUBLER ON PREVIOUS REPAIR FLOORBEAM AT AILERON CONTROSDR CALA0001538Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, RBL 53-LBL 53. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-10-51.SDR GAIA00668Floorbeam · corrodedDISCREPANCY: DURING HEAVY CHECK FOUND: FLOORBEAM STA 727 CORRODED ON UPPER CHORD UPPER SURFACE LBL30, LBL10 & RBL15 EXTENDING UNDER FLOOR SKIN. CORRECTIVE ACTION: CORROSION REMOVED WAS FOUND TO BE OUT OF LIMITS IAW BOEING 727 SRM 53-10-1. FABRICATED AND INSTSDR RAIA0010014Floorbeam · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION ON FLOORBEAM 39. MAINTENANCE REPLACED FLOORBEAM 39 IAW ATR 72 SRM.SDR RAIA0010013Floorbeam · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION ON FLOORBEAM 38. MAINTENANCE REPLACED FLOORBEAM 38 IAW ATR 72 SRM.SDR RAIA0010012Floorbeam · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION AT FLOORBEAM 37. MAINTENANCE REPLACED FLOORBEAM 37 IAW ATR 72 SRM.SDR RAIA0010011Floorbeam · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION AT FLOORBEAM 36. MAINTENANCE REPLACED FLOORBEAM 36 IAW ATR 72 SRM.SDR CALA0001547Floorbeam · corrodedINSPECTION FOUND T-CAP BEAM CORRODED AT STA 1640 FROM LBL 30 TO RBL 30. REPAIRED IAW SRM 53-00-51.SDR P2EA313Floorbeam · corrodedDURING Q CHECK FOUND THE PAX CABIN FLOORBEAM UPPER SURFACE AT BS 947 LBL 45 WITH CORROSION LEVEL 2. REPAIRED THE PAX CABIN FLOORBEAM UPPER SURFACE AT BS947 LBL45 IAW BOEING FAX COO-SJO-00-01194H DATED OCT 19, 2000 AND COOPESA EO COO-3-53-636-00 DATED OCT 20, SDR P2EA00313Floorbeam · corrodedDURING Q CHECK FOUND THE FAX CABIN FLOORBEAM UPPER SURFACE AT BS 947 LBL45 WITH CORROSION LEVEL 2. REPAIRED THE PAX CABIN FLOORBEAM UPPER SURFACE AT BS947 LBL 45 IAW BOEING FAX COO-SJO-00-01194H DATED OCT 19, 2000 AND COOPESA EA#COO-3-53-636-00 DATED OCT 20, SDR GAIA00644Floorbeam · crackedDISCREPANCY: DURING A ROUTINE MAINTENANCE CHECK, A FLOORBEAM WEB WAS DISCOVERED TO BE CRACKED AT BS 294.5, LBL 36. CORRECTIVE ACTION: ACCOMPLISHED BS 294.5, LBL 36, FLOOR BEAM WEB REPAIR IAW BOEING S/B 727-53-0112. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR AT0000468Floorbeam · corrodedFOUND FLOOR SUPPORT BEAM AT BS 1012 RBL 24 TO LBL 24 WAS CORRODED. MECHANICALLY REMOVED CORROSION, FOUND TO BE OUT OF LIMITS. REMOVED LEFT AND RIGHT BEAM AND LOWER DOOR JAMB. FABRICATED AND INSTALLED NEW JAMB, PANELS AND ANGLES IAW DC9 SRM 51-30-2, 53-01 FSDR AWXA0000714Floorbeam · corrodedC-CHECK CORROSION, HOLES CORRODED IN AFT CABIN FLOOR SUPPORT FRAME 66, Y165 RT. FABRICATED NEW BEAM AND INSTALLED IAW DWG D53472282.SDR AWXA0000713Floorbeam · corrodedC-CHECK CORROSION, HOLES CORRODED IN AFT CABIN FLOOR SUPPORT FRAME 66, Y512 LT. CORROSION REMOVED, FOUND BEYOND LIMITS, FABED AND INSTALLED NEW BEAM IAW DWG D53472094010.SDR RRXA003173Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE AND POPPED RIVETS AT BEAM LOWER CHORD/WEB AT STA 702 LBL 45 TO 52.5 & LBL 55.5 TO 61 Z AXIS -7 FWD AND AFT SIDE OF BEAM, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR CALA0001503Floorbeam · corrodedAFT CABIN FLOORBEAM AT FS 1322 CORRODED ON UPPER AND LOWER SURFACES. TRIMMED OUT DAMAGED AREA. FABRICATED AND INSTALLED REPAIR ANGLE PER SRM 53-05 FIG 2.SDR AALA20001682Floorbeam · corrodedTUL - FOUND SEVERAL AREAS OF CORROSION ON FLOORBEAM BL 600L STATION 4610-3845. REPAIRED PER SRM 51-70-01, MATERIAL USED 7075-T7. (M)SDR 00FDEA00704Floorbeam · corrodedDURING ROUTINE INSP, BS 1130 FLOORBEAM FOUND CORRODED BETWEEN NR 5 & 6 SEAT TRACKS. REPAIRED PER IAW DALFORT AERO, LP XEA X1-53-707 REV 1.SDR 00FDEA00703Floorbeam · corrodedDURING ROUTINE INSP, BS 1130 FLOORBEAM FOUND CORRODED BETWEEN NR 6 & 7. REPAIRED PER IAW DALFORT AERO, LP XEA X1-53-707 REV 1.SDR USAA001675Floorbeam · corrodedCLT - C-6, FLOORBEAM CORRODED, 34 INCHES, CORROSION LEVEL 1 C53-107-02, STA 344 BETWEEN STR 17L AND STR 17R. INSTALLED T-CAP AND SPLICE ANGLE PER SRM 53-10-51. (X)SDR USAA001672Floorbeam · corrodedCLT - Q-4, T-CAP/FLOORBEAM CORRODED, 2 INCHES BY 100 INCHES, CORROSION LEVEL 1, STA 328. REPLACED T-CAP PER SRM 53-10-52, FIG 205. (X)SDR USAA001670Floorbeam · corrodedCLT - Q-4, FLOORBEAM CORRODED, .50 INCH X 2 INCH, CORROSION LEVEL 1 C53-107-02, STA 294.5, BL ZERO TO RBL 52. SPLICED T-CAP PER SRM 53-10-51. (X)SDR USAA001669Floorbeam · corrodedCLT - Q-4, FLOORBEAM CORRODED, 2 INCH BY 1 INCH, STA 312, LBL 50 TO RBL 50. CORROSION LEVEL 1 C53-107-02. REPAIRED PER SRM 53-10-51. (X)SDR USAA001668Floorbeam · corrodedCLT - Q-4, FLOORBEAM CORRODED, 120 INCHES, CORROSION LEVEL 1, STA 986.5 T-CAP AREA. INSTALLED NEW T-CAP AND DOUBLER PER TR 53-60-01. (X)SDR USAA001667Floorbeam · corrodedCLT - Q-4, FLOORBEAM CORRODED, 120 INCHES, CORROSION LEVEL 1. STA 967 T-CAP AREA OF FLOORBEAM. INSTALLED NEW T-CAP AND DOUBLER PER TR 53-60-01. (X)SDR USAA001666Floorbeam · corrodedCLT - Q-4, FLOORBEAM CORRODED, 2 INCHES BY 2 INCHES, CORROSION LEVEL 1 AT FLOORBEAM STA 967, BL 31. INSTALLED NEW T-CAP AND DOUBLER PER TR 53-60-01. (X)SDR RRXA003178Floorbeam · crackedDURING A MAINTENANCE VISIT FOUND CORROSION EXFOLIATION TO THE FLOORBEAM AT STA 702 AND X+50, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR TWAA0015705Web · corrodedDURING OP 15 MAINT CHECK MEMBRANE AT STA 897 TO 965 ON RT SIDE HAD CORROSION BEYOND LIMITS AND CRACKED. REMOVED AND REPLACED MEMBRANE AT STA 897 TO 965 WITH NEW MEMBRANE FABRICATED IN METAL SHOP AND SENT TO PAINT SHOP FOR PAINT. INSTALLED RIVETS PER SRM 51-3SDR SWAA001927Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 947, RBL 54 - LBL 54. REPAIRED FLOORBEAM PER SWA T1-453-037.SDR AWXA0000709Floorbeam · corrodedC-CHECK CORROSION, T CAP CORRODED OUT OF LIMITS AFTER REWORK AT FS 967, RBL 20-50. REPAIRED T-CAP IAW 737 SRM 53-00-51, FABBED AND INSTALLED REPAIR STRAPS IAW 737 SRM 53-00-51.SDR AWXA0000706Floorbeam · corrodedC-CHECK CORROSION LEVEL 1. UPPER T CAP AT FS 1016, LBL 4, CORRODED BEYOND LIMITS. REMOVED DAMAGED AREA IAW 737 SRM 53-01-51 FIG 202, FABBED REPAIR PARTS IAW 737 SRM 53-10-51 FIG 202, AND INSTALLED REPAIR IAW 737 SRM 51-40-02.SDR AWXA0000701Floorbeam · corrodedC-CHECK CORROSION, STA 1006, RBL 18, REQUIRES REPLACEMENT DUE TO FLOORBEAM REPAIR. REMOVED AND REPLACED DAMAGED PART IAW 737 SRM 51-40-02, FAB''D REPAIR PART IAW 737 SRM 51-10-02 AND DWG 65-46812.SDR AWXA0000700Floorbeam · corrodedC-CHECK CORROSION, STA 1006 LBL 18 L ANGLE REQUIRES REPLACEMENT DUE TO FLOORBEAM REPAIR. REMOVED AND REPLACED DAMAGED PART IAW 737 SRM 51-40-02, FABBED REPAIR PART IAW 737 SRM 51-10-02 AND DWG 65-46812.SDR AWXA0000699Floorbeam · corrodedC-CHECK CORROSION, STA 1006 LBL 4 T ANGLE REQUIRES REPLACEMENT DUE TO FLOORBEAM REPAIR. REMOVED, FABBED, AND REPLACED WITH REPAIR PART IAW 737 SRM 51-10-02 AND DWG 65-48612.SDR AWXA0000698Floorbeam · corrodedC-CHECK CORROSION, STA 1006 RBL 4 T ANGLE REQUIRES REPLACEMENT DUE TO FLOORBEAM REPAIR. REMOVED, FAB''D, AND REPLACED WITH REPAIR PART IAW 737 SRM 51-10-02 AND DWG 65-46812.SDR AWXA0000691Floorbeam · corrodedC-CHECK, CORROSION LEVEL 1. FLOORBEAM CORRODED BEYOND LIMITS AT FS 1006 RBL 10, AFT LAV AREA. CUT OUT DAMAGED AREA, FABBD REPAIR PARTS, INSTALLED REPAIR PARTS IAW 737 SRM 53-00-51, TREATED AND PRIMED PARTS IAW 737 SRM 51-20-01.SDR GAIA00650Floorbeam · crackedDISCREPANCY: DURING HEAVY CEHCK FOUND: CABIN FLOORBEAM OVER PRESSURE DECK IS CRACKED AROUND 4 FASTENERS AT LOWER CHORD AND CRACKED AT FORWARD & AFT SIDES OF LOWER CHORD LOWER RADIUS AT BS910 FORM LBL2 TO RBL2. CORRECTIVE ACTION: REPAIRED IAW SB727-53-132 REV SDR GAIA00649Floorbeam · corrodedDISCREPANCY: DURING HEAVY CHECK FOUND: CORROSION ON BOTTOM OF BS1050 FLOORBEAM LOWER CHORD AT RBL53. CORRECTIVE ACTION: REMOVED CORROSION AT BOTTOM OF FLOOR BEAM BS1050 RBL53 LOWER CHORD AND FOUND TO BE OUT OF LIMITS AND REPAIRED IAW B727 SRM 53-10-3, 51-10-6SDR GAIA00648Floorbeam · corrodedDISCREPANCY: DURING SURV. INSP. FOUND: CORROSION ON UPPER CHORD OF FLOORBEAM BS 1070 WL208 RBL40. CORRECTIVE ACTION: REPAIRED UPPER CHORD IAW B727 SRM 53-10-8 FIG 3SDR USAA001648Floorbeam · crackedCLT - FOUND CHORD ANGLE CRACKED 1 INCH, AT FLOORBEAM CHORD BS 344, RBL 12. REPLACED ANGLE PER SRM 51-10-2. (M)SDR USAA001649Floorbeam · crackedCLT - FOUND FLOORBEAM CHORD CRACKED 1 INCH, AT SEAT TRACK BS 344, WL 208. REPLACED BEAM PER TR 53-10-13. (M)SDR USAA001654Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 2 INCHES, STATION 1006, LBL 39. CORROSION LEVEL 1 C53-107-02. INSTALLED STRAP PER EA 67980. (M)SDR SWAA001915Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOORBEAM AT BS 312, LBL 10 - RBL 10. REPAIRED FLOORBEAM PER SRM.SDR SWAA001914Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 54 - LBL 54, WL 208. REPAIRED FLOORBEAM PER SRM, T1-453-037 AND ESR034.SDR 00FDEA00695Floorbeam · corrodedCORROSION ON LWR CHORD OF FLOORBEAM BS 1070, RBL 2 - RBL 50, WL 200. *S/D* REMOVED AND REPLACED PER FEDEX SRM 53-10-1, 53-10-8.SDR TWAA0015413Floor Support · corrodedDURING CHECK-C MAINT FOUND A 12 INCH SECTION OF FLOOR SUPPORT CORRODED BETWEEN STA 148 AND 160, RBL 44. REMOVED CORROSION PER SPM 6-80-1 AND TREATED AREA PER SRM 51-10-3. REINSTALLED FLOOR SUPPORT WITH RIVETS PER SRM 51-30-2 AND HI-LOKS PER SRM 51-30-5.SDR TWAA0015412Floorbeam · corrodedDURING CHECK-C MAINT AT STA 160 TO 180, BETWEEN RBL 7 AND RBL 42, HAD FLOOR WEB CORRODED IN NUMEROUS LOCATIONS. REMOVED CORROSION PER SPM 6-80-1 AND TREATED AREA PER SRM 51-10-3. REINSTALLED RIVETS PER SRM 51-30-2.SDR P2EA00274Floorbeam · corrodedSJO - FOUND DURING C-CHECK, CORROSION ON FLOORBEAM LOWER CHORD AT BS 867, RBL 25 AND WL 202. REPAIRED FLOORBEAM LOWER CHORD AT BS 867 WL 202 BETWEEN RBL 16 AND RBL 36 IAW SRM 53-10-9 FIG 7. (M)SDR TWAA0015309Floorbeam · corrodedDURING OP 16 MAINT CHECK, AT STA 1109, TOP OF FLOORBEAM HAD CORROSION FROM STRINGER 33R TO 33L, TOP AND BOTTOM SIDES. REMOVED CORRODED BEAM CAP AND MADE NEW CAP PER BOEING PRINT AND DRAWING 146T1201. REPLACED PART PER SPM 6-70-01.SDR GAIA00657Floorbeam · crackedDISCREPANCY: DURING HEAVY CHECK FOUND: BS1030 FLOORBEAM UPPER CHORD AFT FLANGE CRACKED (APPROX 3 INCHES) AT RBL50. CORRECTIVE ACTION: REPAIRED UPPER CHORD IAW B727 SRM 53-10-8 CHECK OPP, SIDE FOR WORK PERFORMED
Back to JASC 5315