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 9810196638Floorbeam · corrodedDURING PERIODIC CHECK, CORROSION WAS FOUND ON THE UPPER CHORD OF THE LONGITUDINAL FLOOR BEAMS FROM FS 1299-1317, RBL 11 AND 33. REPAIRED PER EA 66-158693.SDR CALA9801847Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT BS 1166, RBL 50 TO RBL 66. THE CORROSION WAS REMOVED AND A REPAIR STRAP WAS INSTALLED IAW SRM 51-30-5, 51-10-2, 51-30-2, AND ECRA 5321-01029.SDR AALA984189Floorbeam · corrodedAFW - FLOORBEAM AT STATION 347 HAS CORROSION REMOVAL ON UPPER SURFACE. FABRICATED REPAIR STRAPS FROM .063-7-75-T6. INSTALLED REPAIR STRAPS, WET WITH BMS5-95. SEALANT USE BACB30NW6, FASTENERS OR EQUIVALENT. (M)SDR AALA984188Floorbeam · corrodedAFW - FLOORBEAM AT STATION 347, RBL 11 HAD CORROSION BLENDED ON TOP SURFACE. FLOORBEAM AT STATION 347, RBL NR 11 HAD CORROSION BLENDED ON TOP SURFACE BEYOND SRM LIMITS. (M)SDR AALA984187Floorbeam · corrodedAFW - FLOORBEAM AT STATION RBL 78 AND 75 HAD CORROSION BLENDED ON TOP SURFACE BEYOND SRM LIMITS. FABRICATED EXTENDED REPAIR STRAP FROM .063-7075-T6. INSTALL REPAIR STRAP WET WITH BMS 5-95 USE BACB3DW6 FASTENERS OR EQUIVALENT. (M)SDR 9810211160Floorbeam · crackedDURING M-CHECK, FOUND CRACK AT THE AFT CARGO FLOORBEAM UPPER CHORD UNDER THE LEFT SEAT TRACK AT FS 1821. REPAIRED PER EA 11-161103.SDR SWAA982175Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED CARGO FLOORBEAM AROUND NUTPLATE LOCATIONS AT BS 727-947, LBL 8, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR CALA9801822Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1130, RBL 26 TO RBL 34 AND LBL 62. THE FLOORBEAM AREAS WERE REPAIRED IAW ECRA 5321-01028 AND ECRA 5321-01027.SDR USAA980391Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A .5 INCH BY .5 INCH AREA OF CORROSION STATION 1006 LBL 2 BEAM INST PASS FLOOR. CORROSION TASK NR C53-107-02. INSTALLED REPAIR ANGLES PER SRM 53-30-51. (M)SDR USAA980388Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A .5 INCH BY .5 INCH BY 14 INCH AREA OF CORROSION STATION 328 LBL 51 TO RBL 65 FLOORBEAM UPPER CHORD. CORROSION TASK NR C63-107-02. SPLICED IN NEW T-CAP SECTION PER SRM 53-10-51. (M)SDR USAA980387Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND .5 INCH BY .5 INCH BY 50 INCH AREA OF CORROSION STATION 344 BLO TO LBL 50 FLOORBEAM UPPER CHORD. CORROSION TASK NR C53-107-02. SPLICED IN NEW T-CAP SECTION PER SRM 53-10-51. (M)SDR USAA980386Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A .5 INCH BY .5 INCH BY 72 INCH AREA OF CORROSION CLIPNUT HOLES STATION 312 LBL 36 TO RBL 36 FLOORBEAM UPPER CHORD. CORROSION TASK NR C53-107-02. SPLICED IN NEW T-CAP SECTION PER SRM 53-10-51. (M)SDR USAA980385Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND A .5 INCH BY .5 INCH BY 10 INCH AREA OF CORROSION STATION 967 LBL 5 TO RBL 5 FLOORBEAM. CORROSION TASK NR C53-107-02. INSTALLED REPAIR ANGLES PER SRM 53-30-51. (M)SDR SWAA982149Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED CARGO FLOORBEAM AROUND NUTPLATE AT BS 727-947, RBL 8, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982148Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED CARGO FLOORBEAM AROUND NUTPLATE AT BS 727-947, RBL 3, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982147Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED CARGO FLOORBEAM AROUND NUTPLATE AT BS 727-947, LBL 3, WL 159. REMOVED AND RELACED PER BOEING SRM.SDR SWAA982145Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED ON CARGO FLOORBEAM AROUND NUTPLATE LOCATIONS AT BS 727-947, LBL 12.5, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982139Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED PRESSURE DECK (FLOORBEAM) AT BS 663, RBL 41.0. REPAIRED PER BOEING SRM.SDR ABXA9800831Floorbeam · crackedILN - DURING C-CHECK, FOUND UPPER SURFACE OF FLOORBEAM STA 965 RBL 8.0 TO RBL 21 CORRODED. REPAIRED IAW DC9 SRM 51-10-32 AND DWG K05019. ACFT TT: 49,258 HOURS. AIRCRAFT TOTAL CYCLES: 39,935. (X)SDR CALA9801785Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1065, STRINGER 28R. THE CORROSION WAS REMOVED AND FILLER AND DOUBLER WERE INSTALLED IAW SRM 51-40-3 AND 51-10-6.SDR CALA9801779Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND MOUNT HOLES AT STA 400, RBL 30. THE CORRODED AREA WAS CUT OUT IAW SRM 53-10-8. A REPAIR WAS INSTALLED IAW SRM 51-10-2 AND 53-10-8.SDR 98FDEA00613Floorbeam · corrodedAFT CARGO FLOORBEAM BS 1050, LWR CHORD HAS CORROSION FROM RBL 24- RBL 43. INSTALLED FLOORBEAM REPAIR LWR CHORD PER SRM 53-10-8 PG 11-17.SDR 98FDEA00602Floorbeam · corrodedUPPER LOBE HEAVY CORROSION ON UPPER SURFACE OF LWR FLANGE OF FLOORBEAM BS 1050, RBL 39. INSTALLED FLOORBEAM LWR CHORD REPAIR PER SRM 53-10 8 PG 11-17.SDR UPS98827931Floorbeam · gougedINSPECTION TYPE:C2 FWD LWR CARGO STA 160 RBL 50 FLOORBEAM HAS GOUGE AROUND THE HI-LOK REPAIRED IAW REO5465.SDR CALA9801770Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, RBL 65 TO LBL 65. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 51-30-2, 53-10-2, 53-10-8, FIGURE 9, AND MM 51-20-12.SDR UPS98827933Floorbeam · corrodedINSPECTION TYPE:C2 STA 902 X.64 FLOORBEAM CORRODED. REMOVED 2 CORRODED ANGLES, DRILLED AND INSTALLED REPLACEMENT ANGLES IAW REO 05483, DC8 SRM 51-1-20D, 51-1-8.SDR SWAA982103Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND FLOORBEAM STIFFENER ANGLE CRACKED AT BS 328, RBL 32, WL 200. REPAIRED PER BOEING SRM.SDR 98FDEA00601Floorbeam · misdrilledUPPER LOBE FLOORBEAM BS 1070, RBL 625 HAS DOUBLE DRILL HOLE IN FLOORBEAM. CUT OUT AREA OF DAMAGE AND REPAIR PER AARD 53-10-07.SDR CALA9801717Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 380, RBL 44 TO RBL 60. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A NEW SECTION OF FLOORBEAM AND SPLICE ANGLES WERE INSTALLED IAW SRM 53-10-8, FIGURE 9, 51-20-4, AND 51-10-2.SDR VJ9800551Floorbeam · corrodedAFT RT LAV FLOORBEAM AT FS 996 CORRODED FROM FUSELAGE TO LAV ENTRANCE. REMOVED RT CABLE RUN AND RT O/B PULLEY TOWER. CUT OUT CORRODED SECTION, TREATED AREA, FABRICATED AND INSTALLED FLOORBEAM SPLICE, FLOORBEAM WEB, ATTACH ANGLE, ANGLES AND ATTACH ANGLE BRACKSDR SWAA982085Floorbeam · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED BS 344 FLOORBEAM LBL 32 TO RBL 10, WL 208. REPAIRED PER BOEING SRM.SDR AALA981858Floorbeam · corrodedTUL - TOP SURFACE OF FLOORBEAM CORRODED AT STATION 312 RBL 44 INCHES. CUT OUT CORROSION, TREATED AND PRIMED AREA. INSTALLED DOUBLER REPAIR PER SRM 53-10-8 PAGE 49-53. (M)SDR DL767981886Floorbeam · corrodedCORROSION WAS FOUND ON THE UPPER CAP OF THE RBL 33 LONGITUDINAL OVERWING FLOORBEAM BETWEEN FS 835 AND 910. A SECTION OF UPPER CAP WILL BE REPLACED WITH A SPLICE REPAIR ON EACH END OF THE REPLACEMENT SECTION. REPAIRED PER ERA 332139-14.SDR CALA9801679Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, LBL 22.5 TO 24.5. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-10-8 AND 51-30-2.SDR CALA9801674Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT TOP FLANGE SCREW HOLE FS 1050, RBL 35. THE CORRODED AREA WAS REMOVED AND A NEW SECTION OF FLOORBEAM WAS INSTALLED IAW SRM 51-10-1, 51-10-2, AND 53-10-5, FIGURE 7.SDR 98FDEA00562Floorbeam · corrodedNR 0380, UPPER LUBE CORROSION FLOORBEAM BS 620, BL O TO RBL 25. REPAIRED FLOORBEAM PER SRM 53-10-8.SDR 98FDEA00561Floorbeam · corrodedNR 1120, OVERSIZED HOLES NOT IN USE IN FLOORBEAM AT BS 580 BLO. INSTALLED REPAIR PER AARD 53-10-07-2 PG 1,2,3 AND FIG 1.SDR 98FDEA00560Floorbeam · damagedNR 1119 - DAMAGE TO FLOORBEAM OVERSIZED HOLES NOT IN USE AT BS 560 BLO. INSTALLED REPAIR PER AARD 53-10-07-2 PG 1,2,3 AND FIG 1.SDR 98FDEA00559Floorbeam · corrodedNR 0936 - UPPER LOBE, FLOORBEAM BS 680 CORROSION ON UPPER FLANGE LBL 10- RBL 6. CORROSION REMOVAL OUT OF LIMITS AT LBL 5 FWD SIDE OF FLANGE. INSTALLED ANGLE DOUBLER PER AARD 53-10-07-2.SDR 98FDEA00558Floorbeam · corrodedNR 0811 - CORROSION ON FLOORBEAM LWR FLANGE SEEN FROM LWR AFT CARGO BS 1010, RBL 45 TO LBL 45. CUT OUT CORROSION REMOVED BEYOND LIMITS AT LBL 12 AND LBL 20 TO LBL 45. INSTALLED DOUBLER REPAIR PER SRM 53-10-8 PG 44 THROUGH PG 48.SDR USAA980405Floorbeam · corrodedCLT - DURING C-4 CHECK VISUAL INSPECTION, FOUND CORROSION AT SCREW HOLES TOP OF T-CAP STATION 1640 LBL 64 TO RBL 64 FLOORBEAM. REMOVED CORRODED T-CAP AND INSTALLED REPLACEMENT T-CAP AND REPAIR ANGLES PER TR 53-15-01. (M)SDR SIMA982511Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS 36, 38, AND 39. AIRCRAFT RETURNED TO SERVICE. (M)SDR CALA9801649Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 360, RBL 24.75. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-10-08 AND 51-30-02.SDR C2XA98IA353Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT BEAM WAS FOUND CORRODED AROUND A NUTPLATE AT AT FRAME 39. MAINTENANCE PERFORMED A DOUBLER REPAIR IAW ATR42 SRM 51-70-00, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. TOTAL HOURS: 23,206.6 HOURS. TOTAL CYCLSDR C2XA98IA345Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND RIGHT OUTBOARD FLOORBEAM CORRODED FROM FRAMES 44 TO 47. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM IAW EMB-120 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. TT: 12,919.5 HOURS. TC: 23,160. (X)SDR C2XA98IA344Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND RIGHT OUTBOARD FLOORBEAM CORRODED FROM FRAMES 38 TO 44. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM IAW EMB-120 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERIVCE. TT: 12,919.5 HOURS. TC: 23,160. (X)SDR 98ZZZM722Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS 36, 38, AND 39. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM721Floorbeam · corrodedSAW - DURING CPCP-8 INSPECTION, FOUND FLOORBEAM 36, 38, AND 39 CORRODED. REMOVED AND REPLACED FLOORBEAMS 36, 38, AND 39. AIRCRAFT RETURNED TO SERVICE. (M)SDR VJ9800483Floorbeam · corrodedCORROSION FOUND SCATTERED THOUGHOUT FWD HORIZONTAL STAB FLANGE OF BS 1016 FLOORBEAM UPPER CAP, LBL 37 RBL 37. REMOVED CORROSION FROM BS 1016 FLOORBEAM UPPER CAP LBL 37, RBL 37, MAT BL 0 TO RBL 37 IS .002 WITHIN LIMITS IAW SRM 51-10-6 AND 53-10-1. TREATED ANDSDR SWAA982049Floorbeam · gougedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD, UPPER SURFACE FWD EDGE GOUGED AT BS 986.5, WL 208, LBL 49. REPAIRED PER BOEING SRM.
Back to JASC 5315