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 SWAA970756Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 986, AT LBL 44. REPAIRED PER BOEING SRM.SDR SIMA972337Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE DISCOVERED FLOORBEAMS AT FRAME 36 AND 38 CORRODED OUT OF LIMITS IAW SRM 53-61-00. MAINTENANCE REMOVED AND REPLACED FLOORBEAMS IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR ABXA9701419Floorbeam · crackedDURING D-CHECK, FOUND FLOORBEAM CRACKED AT FS 237 AND LBL 7. *S/D* REPAIRED IAW ABX REA D953-20604 MR.SDR ABXA9701411Floorbeam · corrodedDURING C-CHECK, FOUND THE UPPER CARGO COMPARTMENT FLOORBEAM AT FS 579 AND LBL 44 TO 50 CORRODED BEYOND LIMITS. REPAIRED FLOORBEAM IAW ABX REA D953-20570-MR.SDR 97ZZZM956Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE DISCOVERED FLOORBEAMS AT FRAME 36 AND 38 CORRODED OUT OF LIMITS IAW SRM 53-61-00. MAINTENANCE REMOVED AND REPLACED FLOORBEAMS IAW SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. REFERENCE SIMA972337.SDR UPS97824451Floorbeam · crackedINSPECTION TYPE:D N/R/C 620816 WRITTEN TO REMOVE FLOOR PANELS FROM FS 980 TO 1540 FOR ADDITIONAL INSPECTION OF FLOORBEAMS, DUE TO EXCESSIVE CORROSION IN AREA. FLOORBEAM CORRODED AND CRACKED FS 1500 LBL 48. REPAIRED FLOORBEAM IAW DHC SK-809-900.SDR UPS97824342Floorbeam · corrosionINSPECTION TYPE-D, FS 1180 LBL 24 FLOORBEAM CORROSION BEYOND LIMITS. REPAIRED IAW DHC SK-809-891.SDR COMA9710387Floorbeam · corrodedDURING 4C INSEPCTION TASK 5320-151/152-01I, FOUND RIGHT HAND FLOORBEAM AT FRAME 33 TO BE CORRODED. REMOVED CORRODED FLOORBEAM AND INSTALLED SERV PART IAW EMB 120 SRM CHAPTER 51.SDR DL72S971646Floorbeam · corrodedCABIN FLOORBEAM CORRODED STA 400 RBL 30 AT NUTCLIP HOLE. REPAIRED FLOORBEAM PER MM 53-20-11 PG 802.SDR DL72S971671Floorbeam · corrodedCORROSION ON FLOORBEAM STA 344 FROM LBL 47 TO LBL 62. REPAIRED PER SRM 53-10-8 FIG 11.SDR DL72S971670Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM STA 344 FROM LBL 30 TO LBL 45. REPAIRED PER SRM 53010-8 FIG 19.SDR DL72S971669Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM STA 344 FROM LBL3 TO LBL27. REPAIRED PER SRM53-10-8 FIG 11.SDR TWAA9795002Floorbeam · crackedSTL - REPAIRED 3 INCH CRACK IN FLOORBEAM AT STATION 237 BY PULLEY BRACKET. (M)SDR RAAA97E4015Seat Track · corrodedDURING ACCESS FOR AD 80-12-01 INSPECTION, FOUND LBL 26 SEAT TRACK CORRODED FS 236 TO 364. REPLACED SEAT TRACK PER SRM 51-2-1 PG 2 PARA 2 M-54 NR 53.SDR USAA970260Floorbeam · corrosionCLT - DURING Q-6 CHECK VISUAL INSPECTION FOUND A 42 INCH BY 1.5 INCH CORROSION ON FLOORBEAM AT STATION 967 LBL 4 AND LBL 46. CORROSION TASK NR C53-107-02. SPLICED IN NEW T-CAP FROM LBL 4 TO LBL 46 STATION 967 AS PER SRM 53-00-51. (M)SDR USAA970259Floorbeam · corrosionCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY .5 INCH CORROSION ON FLOORBEAM AT STATION 986.5 LBL 27 AND LBL 30. CORROSION TASK NR C53-107-02. INSTALLED DOUBLERS PER REPAIR DOCUMENT T/R 53-10-05. (M)SDR USAA970248Floorbeam · corrosionCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND .5 INCH DIAMETER AREAS OF CORROSION AT STATION 312 LBL 6 TO LBL 50 FLOORBEAM. CORROSION TASK NR C-53-107-02. INSTALLED NEW T-CAP REPAIR ANGLES AND STRAPS PER REPAIR DOCUMENT TRM 53-10-03. (M)SDR SWAA970723Angle · corrodedDURING SCHEDULED D CHECK, FOUND FLOOR TO SIDEWALL SUPPORT ANGLE CORRODED AT BS 947, RBL 21-LBL21. REPLACED PER BOEING SRMSDR SWAA970715Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORROSION AT BS 986.5, LBL 25, BL 0 RBL 5, 9, 31.5 AND 35.5, AND 39.5, AT BS 727-947, RBL 25, AND LBL 8, 25, AND 12. REPAIRED PER BOEING SRM.SDR UPS97824138Floorbeam · crackedINSPECTION TYPE-C, FS 55 LBL 25 TO 33 FLOORBEAM HAS NUMEROUS HOLES BROKEN OUT ON EDGE OF FLOORBEAM. REPAIRED IAW DHC-SK-868-115.SDR COMA9710370Floorbeam · corrodedDURING 4C INSPECTION TASK 5320-151-01I, REVEALED RIGHT FLOORBEAM AT FRAME 33 TO BE HEAVILY CORRODED. REMOVED CORRODED PART AND INSTALLED SERVICEABLE PART USING EMB SRM STANDARD PRACTICES CHAPTER 51 FOR LIKE TO LIKE PART REPLACEMENT.SDR ABXA9701401Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM CORRODED STA 965 LBL 30. REPAIRED IAW DC-9 SRM 53-05.SDR ZZDA5316697Floor Beam · corrodedDURING C-CHECK, FOUND FLOOR BEAM UPPER CHORD CORRODED AT BS 967 LBL 28. FABRICATED FLOOR BEAM CAP FROM 1505-100617-7075 T3 16 INCHES BY 2 INCHES IAW B 737 SRM 53-10-9. FABRICATED ANGLE REPAIR FROM 7075.0 .071 INCH 22.50 INCHES BY 1.50 INCHES BY 1 INCH. FABRSDR UPS97824141Floorbeam · corrodedINSPECTION TYPE-C, AFT ACCESSORY COMPT FS 1660 FLOORBEAM RBL 44 IS CORRODDED BEYOND LIMITS. REPAIRED IAW DHC SK-868-794.SDR SWIA97982Floorbeam · corrodedFORWARD CENTER OMEGA FLOORBEAM CORRODED PAST SERVICEABLE LIMIT. INSTALLED NEW FORWARD CENTER OMEGA FLOORBEAM, SRM 51-00-00.SDR SWIA97979Floorbeam · corrodedLEFT OMEGA BEAM IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED LEFT OMEGA BEAM FROM COCKPIT TO FS 6467.6 IAW SRM 51-40-02.SDR 9716286729Floorbeam · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON FLOORBEAM AT FS 640, LBL 83. REPAIRED PER EA 67-151495.SDR SWAA970721Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 0-35. REPAIRED PER BOEING SRM.SDR SWAA970684Floor Beam · corrodedDURING D CHECK, FOUND FLOORBEAM CORROSION AT BS 360, RBL 25-58, WL 208. REPAIRED PER T1-A53-014.SDR SWAA970683Floor Beam · corrodedDURING D CHECK, FOUND FLOORBEAM CORROSION AT BS 294.5, LBL 2-12 AND RBL 20, WL 208. REPLACED SECTION AND SPLICE ANGLES PER BOEING SRM.SDR 97FDEA00541Floorbeam · corrodedNR 0107 001 STA-PAE - CORROSION ON BS 328 FLOORBEAM UPPER FLANGE LBL 47, WL 208. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED IAW FED-EX SRM 53-10-1, 53-10-8, 51-10-2, 51-30-2.SDR 97FDEA00507Floorbeam · corrodedNR 0107 001 STA-PAE - CORROSION ON BS 328 FLOORBEAM UPPER FLANGE, LBL 47, WL 208. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED IAW FED-EX SRM 53-10-1, 53-10-8, 51-10-2, 51-30-2.SDR ZZDA5316797Floor Beam · corrodedDURING C-CHECK, FOUND FLOOR BEAM UPPER CAP CORRODED AT BS 344 LBL 60 OUT OF LIMITS. FABRICATED CHORD FROM 7075 T6 2 INCHES BY 30.75 INCHES BY 1.25 INCHES. FABRICATED WEB SPLICE FROM 7075 T6 .032 INCH 4 INCHES BY 7.2 INCHES. FABRICATED 2 WEBS FROM 7075 T6 .0SDR UPS97824337Floorbeam · corrodedINSPECTION TYPE-D, FS 640 AT RBL 35 CABIN FLOORBEAM CORRODED BEYOND LIMITS. REPAIRED IAW DHC SK 809-358.SDR EISA97169Floor Beam · crackedDURING B-SERVICE AND THE ACCOMPLISHMENT OF CPCP CARD NR 53-113-01, FOUND CRACK IN FLOOR SUPPORT AT FS 600 - FS 620, STR 27R, FORWARD CARGO PIT AREA. FABRICATED AND INSTALLED REPAIR DOUBLER PER SRM 53-10-8. TT: 73,279:23 HOURS. TC: 55,830. (X)SDR EISA97168Floor Beam · corrodedDURING B-SERVICE AND THE ACCOMPLISHMENT OF CPCP CARD C53-111-01 PJ2 FOUND FORWARD CARGO BIN FLOOR STRUCTURE EXFOLIATED AT FS 680, STR 26L. REMOVED DAMAGED MATERIAL. FABRICATED AND INSTALLED REPAIR DOUBLER PER SRM 51-40-2. TT: 73,279:23 HOURS. TC: 55,830.SDR UPS97824113Floorbeam · corrosionINSPECTION TYPE:D CORROSION ON FLOORBEAM AT F/S 460 RBL 24-26 WENT OUT OF LIMITS. REPAIRED IAW DHC SK 809-479.SDR SIMA972171Floorbeam · corrodedSAW - DURING CPCP-4 TASK CARD ZL-261-GVI-10000-001 MAINTENANCE DISCOVERED FLOORBEAM 39 WAS CORRODED OUT OF LIMITS. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IAW SRM 51-29-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR AWXA9700543Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION IN SEVERAL PLACES ALONG FLOORBEAM AT BS 344, LBL 20 TO LBL 40, WL 208. REPAIRED UPPER CHORD FROM RBL 13.9 TO LBL 67, BS 344, WL 208 PER SRM 53-10-51 AND 51-40-2.SDR USAA970247Floorbeam · corrosionCLT - DURING C-4 CHECK VISUAL INSPECTION, FOUND CORROSION 'T' CAP AT NUTPLATE HOLES FWD AND AFT FLANGES LBL 9 TO RBL 52 STATION 365.25 FLOORBEAM. INSTALLED 'T' CAP SECTION REPAIR LBL 9 TO RBL 52 STATION 365.25 PER REPAIR DOCUMENT SRM 53-00-51. (M)SDR RAIA970820Frame · corrosionSTL - DURING MAINTENANCE CHECK, FLOOR FRAME 39 WAS FOUND TO HAVE CORROSION. MAINTENANCE REPAIRED FLOOR FRAME 39 PER ATR SRM. (M)SDR AALA971402Floorbeam · corrodedTUL - FLOORBEAM CORRODED AT FROM C69 IN RIGHT TOP CORNER. REPLACED SECTION OF FLOORBEAM PER SRM 53-10-15. (M)SDR C2XA97IA251Floorbeam · crackedIAH - DURING C-CHECK INSPECTION, THE FLOOR SUPPORT BEAM AT FRAME 13 RIGHT, WAS FOUND CRACKED. MAINTENANCE REPAIRED THE AFFECTED SUPPORT USING A DOUBLER REPAIR IAW EMB-120 SRM 51-10-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. AIRCRAFT TT: 17,071.SDR C2XA97IA250Floorbeam · crackedIAH - DURING C-CHECK INSPECTION, THE FLOOR SUPPORT BEAMS AT FRAME 13 LEFT WERE FOUND CRACKED. MAINTENANCE REPAIRED THE AFFECTED SUPPORT USING A DOUBLER REPAIR IAW EMB-120 SRM 51-10-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. AIRCRAFT TT: 17,071.SDR AWXA9700443Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON BS 294.5 FLOORBEAM, LBL 8 TO RBL 52, WL 208. REMOVED TOP CHORD FROM RBL 52 TO LBL 18 AND REPAIRED PER SRM 53-10-51.SDR 97FDEA00544Floorbeam · corrodedNR 0381 72C237-02 - CORROSION AT TOP OF UPPER LOBE FLOORBEAM STA 1070, RBL 55. REMOVED CORROSION PER SRM 51-10-6. INSTALLED FLOORBEAM REPAIR PER AARD 53-10-07-2 FIG 2.SDR UPS97824123Floorbeam · corrodedINSPECTION TYPE:D FLOORBEAM F/S 260 RBL 27 CORROSION REMOVAL OUT OF LIMITS ON FWD FLANGE. REPAIRED IAW DHC SK 809-788.SDR ABXA9701334Floorbeam · corrodedDURING C-CHECK, FOUND THE FLOORBEAM CAP AT FS 160 SEVERELY CORRODED ON THE RT SIDE OF THE BEAM. *S/D* REPAIRED FLOORBEAM IAW ABX REA D953-20339-MR.SDR 9716586729Floorbeam · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON FLOORBEAM FS 1268 TO 1335, RBL 31 TO 34. REPAIRED PER EA 67-151376.SDR ZZDA5314897Floor Beam · corrodedDURING C-CHECK INSPECTION, FOUND AFT CABIN FLOOR BEAM CORRODED TOP CHORD BS 1006 LBL 3 - RBL 3 OUT OF LIMITS IAW B 737 SRM 53-10-1. FABRICATED FLOOR BEAM FROM BAC 1505-100617 29.750 INCHES BY 2.25 INCHES IAW B 737 SRM 53-10-9. INSTALLED IAW B 737 SRM 53-10-9
Back to JASC 5315