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 CALA9700870Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 400, RBL 30. THE CORRODED AREA WAS CUT OUT, A NEW SECTION WAS FABRICATED AND INSTALLED IAW SRM 53-10-8.SDR CALA9700781Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344 LBL 31.6 TO L-1 DOOR AND RBL 30 TO LBL 10. THE CORRODED AREAS WERE REMOVED, REPAIRS WERE INSTALLED IAW SRM 53-10-51 AND ECRA 5310-03480.SDR CALA9700780Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 294.5, RBL 0. A NEW FLOORBEAM SECTION WAS INSTALLED IAW SRM 53-10-51.SDR AALA970899Floorbeam · corrodedAFW - CABIN FLOORBEAM AT STATION 1640 CORRODED AT UPPER CHORD. BLENDED, ALODINED, FABRICATED REPAIR STRAP, PRIMED, FILLED BLENDED AREAS. INSTALLED REPAIR STRAP WET WITH HI-LOK. (M)SDR 97ZZZX2539Floor Beam · corrodedFLOOR BEAM STA 342 APPROXIMATELY RBL 12 CORRODED. INSTALLED REPAIR IAW 727 SRM 53-10-8 FIG 9.SDR 97ZZZX2527Floor Beam · corrodedCORROSION FLOOR BEAM AT FLOOR BOARD SUPPORT FS 1030 AND S29R. FABBED AND INSTALLED NEW BEAM SECTION IAW 727 SRM 51-40-3 AND SRM 51-30-2.SDR 97ZZZX2524Floor Beam · corrodedCORROSION ON FLOOR BEAM FS 1166 AND RBL 9 REMOVED AND REPLACED BEAM SECTION IAW 727 SRM 53-10-5 FIG 6 AND SRM 51-30-2.SDR 97ZZZX2521Floor Beam · corrodedFWD PIT CORROSION UNDER NUTPLATES ON FLOOR BEAM AT FS 540 RBL 8. REPAIRED IAW BAC 727 SRM 53-10-5 AND SRM 51-30-2.SDR 97ZZZX2517Floor Beam · corrodedCORROSION ON FLOOR BEAM FS 1166 AND RBL 15. FABBED AND INSTALLED REPAIR PARTS IAW 727 SRM'S 51-30-2, 53-10-5 FIG 6.SDR 97ZZZX2492Floor Beam · corrodedCORROSION ON FLOOR BEAM FS 1166 RBL 12. REPLACED FLOOR BEAM SECTION IAW SRM 51-30-2 AND SRM 53-10-5 FIG 6.SDR 97ZZZX2490Floor Beam · corrodedCORROSION ON FLOOR BEAM FS 1166 AND LBL 6. REMOVED AND REPLACED DAMAGED SECTION FS 1166 - IAW 727 SRM 53-10-5 FIG 6 AND SRM 51-30-2.SDR 97ZZZX2489Floor Beam · corrodedCORROSION ON FLOOR BEAM FS 1166 AND LBL 3. REMOVED AND REPLACED DAMAGED SECTION IAW 727 SRM 53-10-5 FIG 6 AND SRM 51-30-2.SDR UPS97223126Floorbeam · corrosionINSPECTION TYPE:D, CORROSION ON TOP CHORD OF FLOORBEAM AT BS 480 BETWEEN LBL 18 AND LBL 22. CORROSION REMOVED FROM UPPER SURFACE OF FLOORBEAM TO CHORD BETWEEN LBL 17.75 TO 21.75, PER SRM 51-00-10.SDR AWXA9700293Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND SEVERAL AREAS OF CORROSION ON FLOORBEAM BS 294, BL 0 TO RBL 55, WL 208. REMOVED, FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53-10-9.SDR 9714376641Floorbeam · corrodedDURING M CHECK AND PRIOR TO SERVICE, FOUND CORROSION ON FLOORBEAM IN RIGHT WHEEL WELL FS 1265, RBL 30 - 90. REPAIRED PER EA 66-150122.SDR USAA970204Floorbeam · corrosionCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND 4 SQUARE INCHES OF CORROSION ON THE UPPER SURFACE STATION 967 RBL 18 FLOORBEAM. CORROSION LEVEL 2, CORROSION TASK CARD NR C-53-107-02. INSTALLED UPPER 'T' CAP REPAIR PER TYPICAL REPAIR DOCUMENT 53-10-05. (M)SDR USAA970194Floorbeam · corrosionCLT - DURING Q-5 CHECK VISUAL, FOUND CORROSION AROUND CLIP NUT HOLES ON FLOORBEAM AT BS 947.5 RBBL 5. CORROSION LEVEL 2, CORROSION TASK CARD NR C-53-107-02. INSTALLED REPAIR PARTS AFTER REMOVAL OF CORROSION PER TYPICAL REPAIR NR 53-10-01A. (M)SDR USAA970193Floorbeam · corrosionCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND CORROSION AROUND CLIP NUT HOLES ON FLOORBEAM STATION 312 NUMEROUS R/L CORROSION LEVEL 2 CORROSION TASK CARD NR C-53-107-02. INSTALLED REPAIR STRAP TO UPPER CHORD. REPAIRED PE TYPE REPAIR NR 53-10-01A. (M)SDR SWAA970441Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAMS CORRODED AT BS 294, LBL 8 TO 11, AT BS 344, BL 0, LBL 10, 14, 21, 42 AND 49, AND AT BS 312, LBL 8, 9, AND 10. REPLACED T-CAPS PER BOEING SRM.SDR DHL9770146CFloorbeam · crackedDURING C-CHECK, FLOORBEAM AT BS 680 HAS CORROSION/CRACK ON UNDERSIDE OF UPPER AFT FLANGE RBL 33. CUT OUT CRACKED/CORRODED AREA AS PER SRM 51-10-1 AT FLOORBEAM, BS 680 RBL 33 UPPER CAP 2.5 PER SRM 53-10-8 FIG 5. INSTALLED FLOORBEAM UPPER CHORD REPAIR AS PER SSDR AU970568Beam · cracked(AUS) UPPER DECK FLOOR BEAM AT BS 330 CRACKED ON LH AND RH SIDES - LH SIDE CRACK LENGTH 41.2MM (1.625IN) - CRACK LENGTH RH SIDE 76.2MM(3IN) - FLOOR BEAM HAD NOT BEEN MODIFIED IAW ENGINEERING ORDER15672 - AREA IS PART OF SECTION 41SDR 9714436716Floorbeam · crackedDURING ARMAR, FOUND CRACK IN UPPER DECK LEFT FLOORBEAM WEB FS 380. REPAIRED PER EA 67-150379.SDR 9714426716Floorbeam · crackedDURING ARMAR, FOUND CRACK IN FLOORBEAM WEB FS 380, STR 13R. REPAIRED PER EA 67-150380.SDR 9714416716Floorbeam · crackedDURING ARMAR, FOUND CRACK IN FLOORBEAM CHORD FS 380, STR 13R. REPAIRED PER EA 67-150380.SDR DL73K970902Floorbeam · corrodedAT MIDVISIT, THE FLOORBEAM T-CAP WAS FOUND TO BE CORRODED SEVERAL PLACES, LBL 7 TO RBL O/B END. THE CORROSION WAS REMOVED PER SRM 51-10-6, ALL OUT OF LIMITS EXCEPT RBL 48. DAMAGED SECTION REMOVED AND REPAIR PARTS AND REPLACED T-CAP, DRILLED AND INSTALLED PERSDR AALA970870Floor Beam · corrodedAFW - FLOOR BEAM AT STA 1640 HAS SEVERAL AREAS OF CORROSION BLENDED BEYOND SRM LIMITS. REF E 58 NR'S 1697035, 1697033, 1697032, 1697036, AND 1697034. TST: 15,561.43 HOURS. CYCLES: 5,712. (X)SDR DHL9770127CFloorbeam · corrodedDURING C-CHECK, UPPER FLANGE OF FLOORBEAM AT BS 344 HAS CORROSION ON UPPER AND LOWER SURFACE AROUND FASTENER HOLES FROM LBL 65 TO RBL 20. REPLACED T-CAP OF FLOORBEAM BS 344 FROM LBL 65 TO RBL 65 PER SRM 51-30-2, N/R3618.SDR DHL9770125CFloorbeam · corrodedDURING C-CHECK, CORROSION ON UPPER SURFACE OF FLOORBEAM AT BS 344, LBL 45 TO 60. REPLACED T-CAP OF FLOORBEAM BS 344 FROM LBL 65 TO RBL 65 PER SRM 51-30-2, N/R 3616.SDR USAA970180Floorbeam · corrodedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND 1 INCH DIAMETER AREAS OF CORROSION STATION 986.5 FLOORBEAM UPPER CHORD RBL 45 TO LBL 45, WL 208. SPLICED IN NEW BEAM SECTION PER TR 53-60-01. CORROSION TASK NR C53-107-02, CORROSION LEVEL 2. (M)SDR USAA970179Floorbeam · corrodedINT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND 1 INCH DIAMETER AREAS OF CORROSION STATION 947 FLOORBEAM UPPER CHORD RBL 14 TO LBL 12, WL 208. SPLICED IN NEW SECTION PER TR 53-60-02, CORROSION TASK NR C53-107-02, CORROSION LEVEL 2. (M)SDR UPS97422814Floorbeam · crackedINSPECTION TYPE-N/A, LWR AFT CARGO BIN FLOORBEAM CRACKED AND ROLLER TRACK DAMAGED AT STA 1780 APPROX 3 LT OF CENTER BEAM. *S/D* REPAIRED FLOORBEAM IAW SRM 51-40-04. THIS CLEARS D129874.SDR DHL9770124CFloorbeam · corrodedDURING C-CHECK, UPPER FLANGE OF FLOORBEAM HAS CORROSION, TOP AND BOTTOM AT BS 312 LBL TO 5. CUT OUT DAMAGED AREA AT TOP OF FLOORBEAM, BS 312 LBL 6 TO RBL 6 APPROX 11.75. INSTALLED REPAIR AT UPPER CHORD PER SRM 53-10-8 FIG 7. REPAIR SIZE 22 IN LENGTH, N/R 3SDR CALA9700746Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT L-1 DOOR, STA 395 TO 433. THE FLOORBEAM WAS REPLACED IAW SRM 53-27-00.SDR C2XA97IA151Floor Beam · corrodedIAH - DURING C-CHECK INSPECTION, THE FLOOR BEAM AT FRAME 40 WAS FOUND CORRODED. MAINTENANCE REPAIRED THE AFFECTED PORTION OF FLOOR BEAM IAW CONTINENTAL EXPRESS ENGINEERING CHANGE/REPAIR AUTHORIZATION EC5310-01037, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SSDR RRXA97140Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND MISDRILLED HOLE IN FLOORBEAM, AT Y=1460 AND X=-47.5. FABRICATED AND INSTALLED REPAIR IAW DER APPROVED COTNEY ENGINEERING SKETCH C44-R34, AND DC-8 SRM 51-1-20D.SDR DHL9770139CFloorbeam · corrodedDURING C-CHECK, CORROSION AT FLOORBEAM UNDERSIDE AT FASTENER HOLES, BS 1110 BETWEEN RBL 22 AND RBL 42. CUT OUT DAMAGED AREA AT RBL 36.5 TO 38.25 PER SRM 53-10-8, 1.5 BY 1. REMOVED SURFACE CORROSION RBL 22 TO 42 PER SRM 51-10-6. LESS THAN .003 MATERIAL REMOVESDR DHL9770129CFloorbeam · crackedDURING C-CHECK, UPPER FLANGE OF FLOORBEAM HAS TWO CRACKS ON UNDERSIDE OF AFT UPPER FLANGE BS 420 LBL 10 TO RBL 14. CUT OUT CRACKED AREAS FROM LBL 10 TO RBL 14 PER SRM 51-10-1. INSTALLED REPAIR DOUBLER PER SRM 53-10-8, N/R3624.SDR AALA970876Floor Beam · corrodedAFW - FLOOR BEAM AT STA 365 HAS CORROSION REMOVAL ON UPPER SURFACE. MATERIAL REMAINING IS BEYOND SRMS LIMITS. REF E 58 NR 1697052. TST: 15,561.43 HOURS. CYCLES: 5,712. (X)SDR AALA970875Floor Beam · corrodedAFW - FLOOR BEAM AT STA 377 HAS CORROSION REMOVAL ON UPPER SURFACE. MATERIAL REMAINING IS BEYOND SRM LIMITS. REF E 58 NR'S 1697054 AND 1697062. TST: 15,561.43 HOURS. CYCLES: 5,712. (X)SDR AALA970874Floor Beam · corrodedAFW - FLOOR BEAM AT STA 324 HAS CORROSION REMOVAL ON UPPER SURFACE MATERIAL REMAINING IS BEYOND SRM LIMITS. REF E 58 NR'S 1697049 AND 1697047. TST: 15,561.43 HOURS. CYCLES: 5,712. (X)SDR AWXA9700295Floorbeam · coroddedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD STA 312, RBL 10, WL 208. REPAIRED FLOORBEAM IAW SRM 53-10-51.SDR AWXA9700294Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD STA 328, RBL 15 TO 50, WL 208. REMOVED UPPER CHORD, FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-10-5, 53-10-51 FROM LBL 29 TO RBL 65.SDR UPS97823113Floorbeam · corrodedINSPECTION TYPE:D, F/S 1580 RBL 52-0 FLOORBEAM FWD TAB WAS CORRODED BEYOND LIMITS (REF N/R 535310). REPAIRED IAW DHC SK-894-310A (REF UPS ENRG FILE NR DC8-53-1814).SDR SCNA97097Floorbeam · corrodedDURING HEAVY MAINTENANCE VISIT, FOUND CORROSION ON UNDERSIDE OF FLOORBEAM AT BS 1110, LBL 11, WL 208. FABRICATED REPAIR ANGLE AND INSTALLED IAW B727 SRM 51-10-6, 53-10-8, 51-30-2 AND B727 MAINTENANCE MANUAL 51-20-11.SDR RRXA97141Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND MISDRILLED HOLE IN FLOORBEAM, AT Y=1420 AND X=+18. FABRICATED AND INSTALLED REPAIR ANGLE IAW DER COTNEY ENGINEERING SKETCH C44-R46. TREATED AREA IAW DC-8 SRM 51-1-8.SDR DL73E970834Floorbeam · crackedSTA 520 HAS DAMAGE ON THE FLOORBEAM, 1.5 CRACK ON BOTH THE LEFT INBD AND RT INBD SEAT TRACK LOCATION. BOTH THE CRACKS ARE IN THE RADIUS AND EXTEND INBD AND OUTBD. THIS IS A GROUP 3 A/C PER S/B 737-53-1120, REV 1. INSPECT FOR CRACKS, REPAIR SIMILAR TO S/B 73SDR DHL9770156CFloorbeam · corrrodedAT C-CHECK, UPPER SURFACE OF FLOORBEAM HAS CORROSION AT FS 328, LBL 30. CUT OUT DAMAGED SECTION OF T-ANGLE. INSTALLED ANGLE PER SRM 51-40-4 PER SRM 51-40-4. ANGLE 5 LONG, STRAPS 16 LONG.SDR DHL9770155CFloorbeam · corrodedAT C-CHECK, UPPER FLANGE OF FLOORBEAM HAS 2 CRACKS ON FWD SIDE, UNDER SIDE AT FS 480 LBL 15 AND LBL 31. CUT OUT DAMAGED AREA, INSTALLED REPAIR PER SRM 53-10-8 FROM LBL 14 TO LBL 35. T-ANGLE 21 LONG, SUPPORT ANGLE 31 BY 2.5 BY 1, RADIUS FILLER 31 BY 2.5 BY 1SDR W8PA970587Floorbeam · corrodedFOUND CORROSION ON TOP FLANGE OF FLOORBEAM AT BS 1006, RBL 10, WL 208. REMOVED CORROSION FOUND OUT OF LIMITS, CUT OUT DAMAGE, FABRICATED AND INSTALLED REPAIR PER SRM 53-60-51, 53-30-51. (M)SDR W8PA970567Floorbeam · corrodedFOUND CORROSION ON TOP FLANGE OF FLOORBEAM AT BS 1006, RBL 10, WL 208. REMOVED CORROSION FOUND OUT OF LIMITS, CUT OUT DAMAGE, FABRICATED AND INSTALLED REPAIR PER SRM 53-60-51, 53-30-51. (M)
Back to JASC 5315