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 AALA982045Floorbeam · corrodedTUL - FOUND CORROSION FLOORBEAM STATION 1050 LB 10 TO LB 55. REMOVED CORROSION, CUTOUT, BEYOND LIMITS, AREA AND INSTALLED REPAIR PER SRM 53-10-8 PAGE 9A AND 9B. (M)SDR AALA982044Floorbeam · corrodedFOUND CORROSION ON UNDERSIDE BS 1110 FLOORBEAM UPPER CHORD ADJ TO FASTENER COVERED BY GALLEY. INSTALLED FLOORBEAM REPAIR PER SRM 53-10-8 PAGE 9E. (M)SDR AALA982038Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM AT STATION 1070, BL 0 - LBL 22. REMOVED CORRODED UPPER PORTION OF FLOORBEAM AND INSTALLED FLOORBEAM REPAIR PER SRM 53-10-8. (M)SDR 98ZZZM874Floorbeam · corrodedSAW - DURING CPCP1 INSPECTION, FOUND FLOORBEAM 36 AND 38 CORRODED. REMOVED AND REPLACED BOTH FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR CALA9802026Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 320, LBL 20 TO 48. THE CORRODED SECTION OF FLOORBEAM WAS CUT OUT IAW SRM 53-10-8. REPAIR ANGLES WERE INSTALLED IAW SRM 53-10-8 AND 51-10-2 PAGE 12.SDR CALA9802021Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 1070, BL 0 TO RBL 52. THE CORRODED AREA WAS CUT OUT, A FLOORBEAM REPAIR WAS INSTALLED IAW SRM 53-10-8 PAGE 13.SDR AALA984184Floorbeam · corrodedAFW - FLOORBEAM AT STATINO 325 HAS CORROSION REMOVAL ON UPPER SURFACE. ALODINED AREA, FABRICATED STRAP FROM .050 301.5 HARD STAINLESS STEEL. ATTACHED STRAP USING BACB30NW6 HI-LOCKS. APPLIED TWO COATS PRIMER TO STRAP AND FLOORBEAM. (M)SDR SWAA982730Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORRODED FLOORBEAM AT BS 773, RBL 8. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982729Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORRODED FLOORBEAM AT BS 773, RBL 3. REMOVED AND REPLACED PER BOEING SRM.SDR 99ZZZM604Floorbeam · crackedFOUND CRACK IN FLOORBEAM AT FRAME NR 37 UNDER FLOOR PANEL 241DF IN CENTER ON FWD SIDE OF BEAM ABOUT 8 INCHES LONG AND 1 INCH FROM TOP OF BEAM. REMOVED CRACKED AREA OF FRAME 37 AND REPAIRED IAW BAE DRAWING NR HC538H9219 AND BAE FAX REF RJO778-98 DATED 11/2/98.SDR CALA9802007Floorbeam · crackedINSPECTION FOUND A 1 INCH CRACK IN FLOORBEAM AT STA 1275, RBL 104. REPAIRED IAW ECRA 5316-01000.SDR AALA984214Floorbeam · corrodedAFW - FLOORBEAMS AT LT AND RT BL 11 HAVE CORROSION REMOVAL ON UPPER SURFACE STATION 933. ROTO PEEN BLENDED AREA, ALODINE BEFORE PRIMER, APPLIED TWO COATS PRIMER. FILL BLENDS WITH BMS5-95. (M)SDR AALA982020Floorbeam · crackedTUL - FLOORBEAMS AT STATION 800 AND 810 CRACKED AT THE END LEFT SIDE. SPLICED IN NEW SECTION OF FRAME PER AARD 51-01-00-05 AND SRM 53-60-01 PAGE 7 VOL 1. (M)SDR 98ZZZX4301Floor Beam · corrodedDURING A C-CHECK, CORROSION NOTED ON FLOOR BEAM STA 1110 BL ZERO UPPER CHORD LOWER SURFACE.SDR 98ZZZX4287Floor Beam · corrodedDURING A C-CHECK, CORROSION NOTED ON FLOOR BEAM FS 400, RBL 3, APPROXIMATE.SDR USAA980524Floorbeam · corrodedCLT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND 11 CORRODED AREAS BS 986.5 LBL 18 TO RBL 43 WL 208.1 OF FLOORBEAM. CORROSION TASK NR C53-107-02. INSTALLED REPAIR T-CAP PER SRM 53-10-9 FIG 2. (M)SDR RRXA99973Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND FLOORBEAM, AT STA= 1700, UPPER HORIZ FLANGES HAS MISDRILLED HOLES ENTIRE LENGTH OF FLOORBEAM. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR AND INSTALLED IAW FAA ASDR RRXA99731Floorbeam · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO CABIN FLOORBEAM AT STA 1260 BL 40R. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED ANGLE REPAIR AND FILLER IAW DC-8 SRM 53-2-0, FIG 1B. (SDR SIMA983011Floorbeam · corrodedDURING CPCP1 INSPECTION, FOUND TOP OF FLOORBEAM 39 CORRODED. REPAIRED FLOORBEAM. AIRCRAFT RETURNED TO SERVICE. (M)SDR SCNA98742Floorbeam · corrodedDURING A HEAVY MAINT CHECK CORROSION WAS FOUND ON T-CAP OF FLOORBEAM AT STATION 1130 RBL 5 AFT CARGO PIT CEILING. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW B727 SRM 531001. REMOVED DAMAGED AREA IAW B727 SRM 513002. FABRICATED NEW PART FORM BAC14902831 IAWSDR SCNA98741Floorbeam · corrodedDURING A HEAVY MAINT CHECK, CORROSION WAS FOUND IN MAIN CABIN AREA, STATION 1110 O INCHES TO 20 INCHES LEFT OF BUTTLINE, FLOORBEAM 1110. REMOVED CORROSION IAW B727 SRM 511006. THE CORROSION WAS FOUND TO BE OUT OF LIMITS IAW B727 SRM 531001. TRIMMED DAMAGED SDR SCNA98740Floorbeam · corrodedDURING A HEAVY MAINT CHECK CORROSION WAS FOUND IN MAIN CABIN AREA, FLOORBEAM AT 1030, BUTTLANE 0. REMOVED CORROSION IAW B727 SRM 511006. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1. TRIMMED DAMAGED UPPER CHORD IAW SRM 531008. FABRICATED NESDR RRXA99732Floorbeam · corrosionDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO CABIN FLOORBEAM AT STA 1560 BL 16L. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR ANGLE AND FILLER IAW DC-8 SRM 53-2-0, FIG 1B. (SDR RAIA981023Floorbeam · corrodedSTL - FLOORBEAM NR 35 IS CORRODED ON TOP CAP AND BOTTOM OF TOP CAP. MAINTENANCE REPAIRED FLOORBEAM IAW ATR42 SRM. (M)SDR GAIA9897Floorbeam · crackedDURING ROUTINE HEAVY CHECK, INSPECTION FOUND A CRACK IN THE FLOORBEAM LOCATED AT BS 740 RBL 35 UPPER CHORD. THE CRACK WAS REPAIRED USING FLIGHT VEHICLES INC REPAIR SKETCH NUMBER 53-98522-2. THE AIRCRAFT WAS THEN RETURNED TO SERVICE. (M)SDR GAIA9896Floorbeam · crackedDURING ROUTINE HEAVY CHECK, INSPECTION FOUND A CRACK IN THE FLOORBEAM LOCATED AT BS 870 LBL 24.75. DURING REPAIR USING SRM REFERENCES MAINTENANCE MISSED DRILLED A HOLE IN WHICH REPAIR WAS OUTSIDE THE SCOPE OF THE SRM REPAIR. THE MISSED DRILLED HOLE WAS REPAISDR 98ZZZX4156Floorbeam · corrodedDURING C-CHECK, CORROSION WAS NOTED ON FLOORBOARD SUPPORT STA 1130 - STA 1148 - LBL 12.SDR 98FDEA00679Floorbeam · corrodedNR 924 CORROSION ON UPPER FLANGE OF FLOORBEAM 620 BL O TO LBL 25. CUT AND REMOVED DAMAGED PART OF FLOORBEAM AND INSTALLED UPPER CHORD REPAIR PER SRM 53-10-8 FIG 3.SDR 98FDEA00681Floorbeam · corrodedNR 136 UPPER LOBE BS 1130 HEAVY CORROSION UNDER UPPER AFT LIP OF FLOORBEAM AT RBL 55. REMOVED CORROSION, TREATED AND PRIMED AREA AND INSTALLED DOUBLER PER EA 7-5310-29681.SDR 98FDEA00676Floorbeam · corrodedNR 790 UPPER LOBE, CORROSION ON FLOORBEAM TOP SIDE OF UPPER FLANGE BS 1130, RBL 45 - RBL 65. REMOVED CORROSION, TREATED AND PRIMED AREA, INSTALLED DOUBLER PER EA 7-5310-29681.SDR USAA980548Floorbeam · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 1 INCH AREA OF CORROSION AROUND NUTPLATE STATION 328 LBL 36 RBL 66 FLOORBEAM UPPER SURFACE FORWARD ENTRY T-CAP. CORROSION TASK C53-107-02. REPLACED T-CAP PER SRM 53-10-51 PAGE 220. (M)SDR USAA980547Floorbeam · corrodedCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 1 INCH AREA OF CORROSION AROUND NUTPLATE STATION 344 FLOORBEAM UPPER SURFACE FORWARD ENTRY T-CAP. CORROSION TASK NR C53-107-01. REPLACED T-CAP PER EA 62544 AND TR 53-10-13. (M)SDR 99ZZZM410Floorbeam · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER, FOUND THE FLOORBEAM 38 CORRODED ON TOP SURFACE AND BOTTOM. INSTALLED FLOORBEAM 38 AS PER SRM 51-25-03. CAUSE OF DAMAGE, LAVATORY/GALLEY SPILLS. (M)SDR 99ZZZM409Floorbeam · corrodedDURING A CPCP 4 INSPECTION PERFORMED AT AMR EAGLE MAINTENANCE CENTER, FOUND THE FLOORBEAM 38 CORRODED ON TOP SURFACE AND BOTTOM. INSTALLED FLOORBEAM 38 AS PER SRM 51-25-03. CAUSE OF DAMAGE, LAVATORY/GALLEY SPILLS. (M)SDR F3LA98191Floorbeam · corrodedPHX - DURING C-CHECK INSPECTION REPORTED CORROSION ON UPPER CAP OF FLOORBEAM AT BS 986.5, RBL 40 TO LBL 40, MAIN CABIN FLOOR. MAINTENANCE REMOVED DAMAGED AREA, FABRICATED REPLACEMENT PARTS AND REPAIRED PER SRM 53-60-51, SRM 51-40-2, SRM 51-10-1 AND EA B737-53SDR F3LA98190Floorbeam · corrodedPHX - DURING C-CHECK INSPECTION REPORTED CORROSION ON FLOOR SUPPORT BETWEEN BS 279 AND BS 295 AT RBL 31, MAIN CABIN FLOOR. MAINTENANCE REMOVED DAMAGED AREA, FABRICATED REPLACEMENT PARTS AND REPAIRED PER SRM 51-40-02, SRM 51-10-01 AND EA B737-53-071. (M)SDR F3LA98189Floorbeam · corrodedPHX - DURING C-CHECK INSPECTION REPORTED CORROSION ON FLOOR SUPPORT BETWEEN BS 277 AND BS 295 AT RBL 10.85, MAIN CABIN FLOOR. MAINTENANCE REMOVED DAMAGED AREA, FABRICATED REPLACEMENT PARTS AND REPAIRED PER SRM 51-40-2 AND EA B737-53-071. (M)SDR F3LA98188Floorbeam · corrodedPHX - DURING C-CHECK INSPECTION REPORTED CORROSION ON FLOOR SUPPORT AT BS 320, LBL 11.10, MAIN CABIN FLOOR. MAINTENANCE REMOVED DAMAGED AREA, FABRICATED REPLACEMENT PARTS AND REPAIRED PER SRM 51-10-3, SRM 51-10-1 AND SRM 51-40-2. (M)SDR F3LA98187Floorbeam · corrodedPHX - DURING C-CHECK INSPECTION REPORTED CORROSION ON FLOOR SUPPORT AT BS 312 TO 328 LBL 11.10, MAIN CABIN FLOOR. MAINTENANCE REMOVED DAMAGED AREA, FABRICATED REPLACEMENT PARTS AND REPAIRED PER SRM 51-10-1, SRM 51-40-2 AND EA B737-53-071. (M)SDR F3LA98184Floorbeam · corrodedPHX - DURING C-CHECK, INSPECTION REPORTED CORROSION ON FLOOR SUPPORT AT BS 950, LBL 18 TO 50, MAIN CABIN FLOOR. MAINTENANCE REMOVED DAMAGED AREA, FABRICATED REPLACEMENT PARTS AND REPAIRED PER SRM 53-60-51, SRM 51-30-1 AND SRM 51-40-2. (M)SDR F3LA98183Floorbeam · corrodedPHX - DURING C-CHEC, INSPECTION REPORTED CORROSION ON UPPER SURFACE OF FLOOR SUPPORT BS 947 TO BS 927. MAINTENANCE REMOVED DAMAGED AREA, FABRICATED REPLACEMENT PARTS AND REPAIRED PER SRM 51-10-1, SRM 51-40-2 AND EA B737-53-069. (M)SDR F3LA98178Floorbeam · corrodedPHX - DURING C-CHECK INSPECTION REPORTED CORROSION ON FLOORBEAM 291.5, LBL 20 TO RBL 40 (MAIN CABIN FLOOR). MAINTENANCE REMOVED CORROSION AND DAMAGED UPPER CHORD, FABRICATED REPLACEMENT PARTS AND REPAIRED PER SRM 53-10-51 AND 51-40-2. (M)SDR F3LA98169Floorbeam · corrodedPHX - DURING C-CHECK INSPECTION, REPORTED CORROSION ON FLOORBEAM AT BS 312, LBL 30 TO LBL 5. MAINTENANCE REMOVED DAMAGED AREAS, FABRICATED REPLACEMENT PARTS AND REPAIRED PER SRM 53-10-51, SRM 51-40-2 AND SRM 53-10-5. (M)SDR EIAA980334Floorbeam · corrodedMZJ - DURING C4 CHECK, AFT CARGO FLOORBEAM UPPER FLANGE AT FS 980 LBL 48 HAS CORROSION AT A PREVIOUS REPAIR. REPAIRED PER SRM 53-05 AND ECRA 945-53-004-2. (M)SDR AALA981928Floorbeam · corrodedTUL - FLOORBEAM NR 5 HEAVY CORROSION. INSTALLED FLOORBEAM STRAP 53-12-10-1 PAGE NR 2 ITEM B. (M)SDR RRXA99007Floorbeam · corrodedDURING A MAINTENANCE VISIT, FOUND FLOORBEAM WITH CORROSION DAMAGE BEYOND LIMITS IAW DC-8 SRM AT STA 1745 AND BLL 26. REMOVED DAMAGED SECTION, TREATED AREA IAW DC-8 SRM. FABRICATED AND INSTALLED REPAIR STRAPS IAW FAA APPROVED TIMCO DER ENGINEERING SKETCH REO-SDR 98ZZZX4137Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED AFT PIT FLOORBEAM 1130 APPROXIMATELY LBL 15, UPPER CHORD LOWER SURFACE.SDR USAA980559Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND SEVERAL 1 INCH BY 1 INCH AREA OF CORROSION STATION 986.5 LBL 65 RBL 65 WL 208 FLOORBEAM INST. CORROSION TASK NC C53-107-02. SPLICED IN REPAIR 'T' CAP PER TR 53-60-01. (M)SDR USAA980557Floorbeam · corrodedCLT - DURING Q2 CHECK VISUAL INSPECTION, FOUND SEVERAL 1 INCH BY 1 INCH AREAS OF CORROSION STATION 967 BETWEEN LBL 20 AND RBL 30 WL 208 FLOORBEAM. CORROSION TASK NR C53-107-02. INSTALLED DOUBLER PER BOEING 737-400 SRM 53-30-51. (M)SDR USAA980556Floorbeam · corrodedCLT - DURING Q2 CHECK, VISUAL INSPECTION FOUND SEVERAL 1 INCH BY 1 INCH CORRODED AREAS AT STATION 947.5 BETWEEN LBL 20 AND RBL 20, WL 208. DEFECTIVE PART FLOORBEAM. CORROSION TASK NR C53-107-02. SPLICED IN REPAIR 'T' CAP PER T/R 53-60-02. (M)
Back to JASC 5315