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 AWXA9800044Floorbeam · corrodedDURING SCHEDULED C-12 INSPECTION, FOUND CORROSION ON FLOORBEAM 294.5 TOP CHORD LBL 25 TO RBL 53, WL 208. REPAIRED UPPER CHORD OF FLOOR BEAM FROM LBL 60 TO RBL 60, BS 294.5, WL 208 PER SRM 53-10-51.SDR 98ZZZM842Floorbeam · corrodedSAW - DURING 4C CHECK INSPECTION, MAINTENANCE REPORTED FLOORBEAM 39 HAS A HOLE AND CORROSION. REPAIRED FLOORBEAM 39 IAW ATR 72 SRM 53-00-00 FIG 429 AND ASA EO 72-53-0031. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM840Floorbeam · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED FLOORBEAM 39 HAD HOLE AND CORROSION. BLENDED EDGE DAMAGE IAW SRM 51-10-00 AND HOLE IAW EO 72-53-003 SRM 53-00-00 FIG 429. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98FDEA00065Floorbeam · corrodedNR 0682 72 C 237-02 BS 1070, RBL 60 TO LBL 24 LOWER FORWARD FLANGE CORRODED. REMOVED CORRODED AREA OF FLOORBEAM FLANGE AND REPAIRED WITH FLOORBEAM REPAIR PER SRM 53-10-8.SDR UPS98225579Floorbeam · corrodedINSPECTION TYPE-D, CORROSION IN FLOORBEAM UPPER CHORD AT BS 312 LBL 46 AT EXISTING BLENDOUT. AREA REPAIRED IAW SRM 53-10-8.SDR UPS98225578Floorbeam · corrodedINSPECTION TYPE-D, SEVERAL AREAS OF CORROSION ON UPPER CHORD OF FLOORBEAM, BS 344 BL 0 TO LBL 50. ALSO, EXISTING SPLICE FROM LBL 54 TO RBL 16. NEW UPPER CHORD OF BS 344 FLOORBEAM REPLACED IAW SRM 51-30-02 AND DRAWING 65-16316.SDR ABXA9800031Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM LOWER FLANGE CORRODED AT STA 937, BL 0.0. REPAIRED FLOORBEAM IAW ABX REA D53-22192MR.SDR CALA9800086Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND SCREW HOLES AT STA 947, LBL 6. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51.SDR USAA980015Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND CORROSION AT TOP OF THE FLOORBEAM AND SCREW HOLES .5 INCH BY .5 INCH STATION 986.5. CORROSION TASK NR C 53-107-02. REPLACED T-CAP AT FLOORBEAM 986.5 PER REPAIR DOCUMENT SRM 53-10-05. (M)SDR USAA980014Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND CORROSION AT THE FASTENER STATION 328 FLOORBEAM RBBL 12 ON FRAME. CORROSION TASK NR C 53-107-02. INSTALLED REPLACEMENT T-CAP SPLICE PER TYPICAL REPAIR DOCUMENT 53-10-03. (M)SDR USAA980012Floorbeam · corrosionCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND CORROSION AT UPPER SURFACE AND SCREW HOLES AT FLOORBEAM STATION 947.5. CORROSION TASK NR C 53-107-02. INSTALLED REPAIR STRAP PER REPAIR DOCUMENT NR SRM 53-00-51 FIGURE 203. (M)SDR USAA980011Floorbeam · corrosionCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND CORROSION ON TOP OF FLOORBEAM AT THE SCREW HOLES AT STATION 967 FLOORBEAM. CORROSION TASK NR C-53-107-02. BURNISHED AND TREATED AREA OF MINOR CORROSION. REPLACED T-CAP WHERE NECESSARY PER REPAIR DOCUMENT AND SSDR CALA9800085Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, BBL 0 TO RBL 30. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR CALA9800084Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, LBL 10 TO RBL 30. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR CALA9800081Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT CLIPNUTS, STA 380, RBL 24 TO RBL 62. TWO L-ANGLES WERE FABRICATED AND INSTALLED IAW SRM 51-10-2 AND 53-30-8 FIGURE 8.SDR CALA9800080Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT CLIPNUT ON UPPER FORWARD FLANGE LOWER SURFACE AT STA 328, LBL 48. THE FLOORBEAM WAS REMOVED, REPAIRED, AND REINSTALLED IAW SRM 53-10-8 AND 53-20-11.SDR ABXA9800017Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM CORRODED AT STA 408 ABOVE THE FWD LOWER CARGO DOOR. REPAIRED FLOORBEAM IAW ABX REA D953-22195 MR.SDR AALA980168Floorbeam · corrodedTUL - LOWER SIDE OF UPPER FLANGE HAS CORROSION AROUND FASTENER HOLE. FLOORBEAM STA 480, BL ZERO. INSTALLED STRAP REPAIR ON FLOORBEAM PER AARD 52-10-7-2. TST: 56,192 HOURS. CYCLES: 34,665. (X)SDR AALA980150Floorbeam · corrodedTUL - FLOORBEAM UPPER CHORD CORRODED FROM LBL 10 TO LBL 14. REMOVED CORROSION PER SRM 51-10-06. CUT AND REMOVED DAMAGED SECTION OF FLOORBEAM. ALODINED AND PRIMED, INSTALLED DOUBLER PER SRM 53-10-8. FIGURES 1-4. TST: 56,187 HOURS. CYCLES: 34,681. (X)SDR AALA980147Floorbeam · corrodedTUL - CORROSION ON FLOORBEAM AT STA 380 FROM RBL 45 TO RBL 65. REMOVED CORRODED SECTION AND INSTALLED NEW PART AND DOUBLER PER SRM 53-10-8. TST: 56,192 HOURS. CYCLES: 34,665. (X)SDR AALA980145Floorbeam · corrodedTUL - CORROSION ON TOP OF FLOORBEAM LBL 42 - RBL 25 STA 344. REMOVED AND REPLACED UPPER 'T' CAP OF FLOORBEAM STA 344 LBL 32 - RBL 60. TST: 56,192 HOURS. CYCLES: 34,665. (X)SDR AALA980144Floorbeam · corrodedTUL - CORROSION ON FLOOR BEAM STA 380 FROM RBL 12 TO RBL 24. REMOVED CORRODED SECTION, INSTALLED NEW PART AND DOUBLER PER SRM 53-10-8. TST: 56,192 HOURS. CYCLES: 34,665. X)SDR AALA980143Floorbeam · corrodedTUL - CORROSION ON FLOORBEAM FROM RBL 24 TO RBL 45 AT STA 380. REMOVED CORRODED SECTION, INSTALLED NEW PART AND DOUBLER PER SRM 53-10-8. TST: 56,192 HOURS. CYCLES: 34,665. (X)SDR AALA980142Floorbeam · corrodedTUL - CORROSION ON TOP AND BOTTOM OF FLOORBEAM AND CRACK IN FLOORBEAM STA 344, LBL 36 APPROXIMATELY. REMOVED AND REPLACED FLOORBEAM CAP AT STA 344 FROM LBL 34 THROUGH RBL 67 PER ESO 11697 DATED 12-15-97. TST: 56,192 HOURS. CYCLES: 34,665. (X)SDR AWXA9800046Floorbeam · corrodedDURING SCHEDULED C-12 INSPECTION, FOUND CORROSION AROUND NUT-PLATE HOLE STA 344, WL 208, LBL 10 ON FLOORBEAM. REMOVED DAMAGED PORTION OF TOP CHORD FROM LBL 8.5 TO LBL 11, WL 208, STA 344 AND REPAIRED BEAM PER SRM 53-10-51, PAGES 224 - 228.SDR 98FDEA00031Floorbeam · gougedUPON REMOVAL OF RADIUS FILLER, FOUND DEEP GOUGE AT BS 880, LBL 15, WL 201.5. *S/D* BLENDED OUT GOUGE, CRACK AND CORROSION AT BS 880, LBL 15, WL 201.5 ORIGINAL THICKNESS WAS .1, MATERIAL REMOVED WAS .045. BLENDOUT AREA IS .3 X .2, FOUND TO BE OUT OF LIMITS PSDR UPS98225468Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION (C53-224-01.05-02) ON TOP OF FLOORBEAM 950 RBL 25 TO 65. CORROSION REWORK OUT OF LIMITS IAW SRM 53-10-1. REPAIRED 950 FLOORBEAM RBL 25 TO 65 IAW TRAMCO/BFG EWO 98-2012 (UPS FILE 727-53-1983).SDR AALA980109Floor Beam · corrodedTUL - CORROSION ON TOP OF FLOOR BEAM STA 380 RBL 5 - RBL 25. REMOVED CORROSION PER SRM 51-10-6. REPAIRED PER SRM 53-10-8, PAGES 9-A AND 9-B. TST: 54,792 HOURS. CYCLES: 33,779. (X)SDR AALA980108Floor Beam · corrodedTUL - CORROSION ON TOP SIDE OF FLOOR BEAM STA 380 RBL 27 - RBL 65. REMOVED CORROSION PER SRM 51-10-6. REPAIRED DAMAGED AREA ON FLOOR BEAM PER SRM 53-10-8, PAGES 9-A AND 9-B. TST: 54,792 HOURS. CYCLES: 33,779. (X)SDR UPS98225466Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION AT BS 380 RBL 45 TO 63 WL 208 ON UPPER SURFACE OF FLOORBEAM AND BOTTOM SURFACE AT FASTENER HOLES (C53-224-01.05-01). CORROSION REMOVED IAW SRM 51-10-6 OUT OF LIMITS IAW SRM 53-10-1. REPAIRED FLOORBEAM IAW SRM 53-10-8.SDR UPS98225455Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION ON TOP OF FLOORBEAM BS 328 RBL 12 TO 16 WL 208 TASK CARD NR C53-224-03-1B. REPLACED FLOORBEAM DAMAGED SECTION PER SRM 53-10-1 AND 53-10-8.SDR UPS98225451Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION FLOORBEAM BS 420, RBL 45 TO 60, WL 208 OF LOWER SIDE AT UPPER FLANGE. CUT OUT DAMAGED SECTION OF FLANGE AND ACCOMPLISHED REPAIR IAW SRM 53-10-8.SDR 98FDEA00027Floorbeam · corrodedNR 0429 007, WHILE WORKING NR0408, FOUND CORROSION ON FLOORBEAM BS 344, RBL 17 OUT OF LIMITS AND DOUBLE HOLE DRILLED AT RBL 38, WL 208. REMOVED AND REPLACED BS 344 BEAM UPPER CHORD LBL 17 TO RBL 65 PER FED-EX DRAWING SR 27-53-007.SDR UPS98225403Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION AFT CARGO BAY ON FLOORBEAM, FWD LOWER FLANGE UNDER NUT PLATES BS 1070, BL 0 TO LBL 10 WL 200. REMOVED DAMAGED SECTION AND REPAIRED LOWER FLANGE IAW SRM 53-10-8.SDR 98FDEA00022Floorbeam · gougedFLOORBEAM UPPER CHORD FWD SIDE LWR SURFACE GOUGED BS 880 RBL 55 WL 208. BLENDED OUT GOUGE, FABRICATED REPAIR STRAP FROM .071 7075-T6. INSTALLED STRAP PER AMERICAN AIRLINES REPAIR 53-10-07-2 FIG 1 3/20/96.SDR UPS98225462Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION (C53-224-01.05-01) AT BS 480 LBL 45 RBL 63 WL 208 ON UPPER SURFACE OF FLOORBEAM AS MARKED. CORROSION FOUND OUT OF LIMITS PER SRM 53-10-1. FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53-10-8.SDR UPS98225461Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION (C53-224-01.05-01) ON TOP CHORD OF FLOORBEAM AT BS 620 RBL 10 WL 208. CORROSION ON CHORD FOUND TO BE OUT OF LIMITS. FABRICATED REPAIR PARTS PER SRM 53-10-8.SDR UPS98225397Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION AFT CARGO BAY ON FLOORBEAM, FWD LOWER FLANGE AT NUT PLATE BS 950F, LBL 12, WL 200. REMOVED DAMAGED SECTION AND INSTALLED DOUBLER AND TRIPLER ANGLE AND FILLER IAW SRM 53-10-8.SDR 98ZZZX2745Floorbeam · crackedATW - MLG BAY PRESSURE DIAPHRAM ROOF HAS A FLOORBEAM, (NR 19), AT FR 29 RT SIDE UNDER OUTBOARD SEAT RAIL IN CABIN THAT HAS A SMALL CRACK DEVELOPING AROUND A FASTENER HEAD. REPAIRED RT BEAM NR 19 AT FR 29 IAW BAE DRAWING HC536H92 11 AND BAE FAX DJR/RJ0207-97.SDR C2XA98IA006Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND FLOOR SUPPORT BEAM CORRODED AT FRAME 39. MAINTENANCE REMOVED THE DAMAGED AREAS OF THE BEAM AND INSTALLED TWO REPAIR SECTIONS ON LEFT SIDE IAW ATR 42 SRM 51-21-42/EC5310-01037. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERSDR AALA980082Floor Beam · corrodedTUL - APPROXIMATELY ONE-HALF DIAMETER OF DEEP CORROSION ON TOP OF FLOOR BEAM STA 1130 RBL 2411. REPAIRED AFFECTED AREA WITH STRAP DOUBLER PER ESO 11697 DATED 12-12-97. TST: 67,236 HOURS. CYCLES: 44,034. (X)SDR AALA980083Floorbeam · corrodedTUL - FOUND STATION 328, 52LBL FLOORBEAM CORROSION. INSTALLED DOUBLER ON FLOORBEAM PER SRM 53-10-08 PAGE 49-53. (M)SDR UPS98825560Floorbeam · corrodedINSPECTION TYPE-D, FLOORBEAM FS 960 LBL 60 FWD UPPER FLANGE EXFOLIATED. REPAIRED IAW DHC SK-852-159.SDR UPS98825533Floorbeam · corrodedINSPECTION TYPE-D, FLOORBEAM FS 702 RBL 40 UPPER AFT FLANGE EXFOLIATED. REPAIRED IAW DHC SK 852-198.SDR 98ZZZX2740Floorbeam · corrodedATW - FLOORBEAMS AND SUPPORT STRUCTURE FRAMES 41-44 HAS SEVERAL SPOTS OF LIGHT SURFACE CORROSION ON TOP OF GUSSET PLATES AND INTERCOSTALS. ALL SPOTS ARE MARKED WITH BLACK MARKER. CLEANED AND REMOVED SURFACE CORROSION. TREATED, PRIMED AND PAINTED AFT VEST FLSDR AWXA9800018Floorbeam · corrodedDURING SCHEDULED C-8 INSPECTION, FOUND CORROSION ON TOP OF FLOORBEAM BS 345, BL 0, LBL 13. REMOVED, FABRICATED TOP CHORD OF FLOORBEAM FROM RBL 19 TO LBL 52, BS 345, WL 208 PER SRM 53-00-51.SDR 9802446614Floorbeam · crackedDURING M CHECK, FOUND CRACK IN FLOORBEAM WEB AT FS 460, RBL 80. REPAIRED PER EA 66-153168.SDR MZZA98014Floorbeam · corrosionKUL - FLOORBEAM AT STATION 328 AT LBL 30 HAS SURFACE CORROSION. REMOVED CORROSION IAW SRM 51-10-6. FOUND BEYOND LIMIT IAW ECRA 5310-03651. CARRY OUT REPAIR IAW SRM 53-10-8. (M)SDR ASOA98001Floorbeam · crackedDURING SCHEDULED MAINTENANCE, FOUND CRACKED FLOORBEAM AT FRAME 26. INSPECTED FLOORBEAM IAW AI (R) FAX QS/ET603.4275/97, DS/ET603.4237/97 AND EO72-53-0026, SPECIFICATIONS FOR INSPECTION AT C-CHECK AND REINSPECTION EVERY 750 FLIGHTS. (M)SDR UPS98225661Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION (C53-111-01.00-03) AFT CARGO BAY ON FLOORBEAM, FWD LOWER UNDER NUT PLATES BS 1130, LBL 6 TO LBL 25, WL 200. CORROSION FOUND OUT OF LIMITS PER SRM 53-10-1. REPAIR BY ADDITION OF REPAIR ANGLES PER BOEING TELEX TCO-PAN-98-07175RR A
Back to JASC 5315