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 P2EA00225Floorbeam · crackedSJO - DURING C-CHECK, LEFT AIR CONDITIONING BAY, WING CENTER SECTIN RBL 40.875 BETWEEN BS 573 AND BS 576 LOWER BEAM WEB WITH A CRACK, 2.5 INCHES LONG BY .001 INCH WIDE. REPAIRED LOWER FUSELAGE BEAM WEB AT WING CENER SECTION PER COOPESA EO COO-3-53-470-00 DATESDR P2EA00224Floorbeam · corrodedSJO - DURING C-CHECK, RIGHT AIR CONDITIONING BAY, WING CENTER SECTION RBL 40.875 BETWEEN BS 571 AND BS 584 LOWER BEAM WEB WITH A CRACK 2 INCHES LONG BY .002 INCHES WIDE. REPAIRED LOWER FUSELAGE BEAM WEB AT WING CENTER SECTION PER COOPESA EO COO-3-53-467-00 DASDR RRXA002860Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE FLOORBEAM AT FS 920 AND LBL 48 - 53, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED REPAIR AND INSTALLED IAW DALFORT AEROSPACE LP XEA X8-53-880 REVSDR RRXA002850Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE FLOORBEAM ON THE FWD AND AFT FLANGES AT FS 940 AND RBL 53, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED REPAIR AND INSTALLED IAW DALFORT AEROSPACSDR DHL200070932CFloorbeam · corrodedCORROSION ON AFT SIDE OF FLOORBEAM AT STA 1130. REMOVED SUB FLOOR AT RT SIDE FROM STA 1130 TO 1160 RBL 25 TO RBL 62 AS PER SRM 51-30-2. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS PER SRM 51-10-6. SANDED OUT LOOSE PAINT AND CLEANED RT AFT LAV AREA FLOORSDR SCNA00344Floorbeam · corrodedDURING HEAVY MAINTENANCE CHECK, CORROSION WAS FOUND OUT OF LIMITS ON THE AFT SIDE OF THE UPPER CHORD ON FLOORBEAM DOUBLER LOCATED AT RT STA 380 RBL 48 TO 60. REMOVED CORROSION IAW B727 SRM 511006. FABRICATED 1 T-CAP FROM BAC 1505100617, 1 ANGLE FROM BAC 1490SDR DHL200070931CFloorbeam · corrodedFWD RT CORNER OF FLOORBEAM AT STA 1130 CORRODED. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS PER SRM 51-10-6. TREATED AND PRIMED AREA PER SRM 51-6-2. FABRICATED ANGLE REPAIR PER SRM 51-10-6. INSTALLED REPAIR PER AVITAS EO AVHM-140RO-1.SDR QXEA0001979Seat Track · corrodedYXX- RIGHT HAND INBOARD SEAT TRACK HAS CORROSION FROM X182 - X300. REPAIRED IAW DHC-8 RD8-53-3074, RD8-53-1339, AND SRM 51-20-00, PAGE 5, SRM 51-20-16.SDR CALA0001024Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FS 1338, LBL 20 TO LBL 50 AND AT FS 1322, LBL 20 TO LT SIDE WALL. THE CORRODED AREAS WERE CUT OUT AND BLENDED IAW SRM 53-05, FIGURE 20A. REPAIR ANGLES WERE INSTALLED AT EACH LOCATION IAW SRM 51-10-04, 51-10-03, 51-30-05SDR AWXA0000449Floorbeam · crackedFWD SIDE OF T CAP OF FLOORBEAM CRACKED AT STA 520 LBL 24. REMOVED DAMAGED T CAP, FABRICATED REPLACEMENT PARTS IAW 737 SRM 53-00-51 FIG 201, INSTALLED REPLACEMENT T CAP IAW 737 SRM 53-00-5, TREATED, PRIMED, AND TOPCOATED IAW SRM 51-20-01.SDR 0002439938Floorbeam · corrodedCORROSION ON FLOORBOARD AT STA 160 ABOUT 10 INCHES I/B OF RT SIDE. FABRICATED REPAIR PER EA 99-172574 L/P 1462596.SDR USAA000977Floorbeam · corrodedCLT - FOUND BEAM CORRODED 1 INCH BY 1 INCH, 6 AREAS, STATION 947 FLOORBOARD HOLES. REPAIRED BEAM PER SRM 53-10-9. CORROSION LEVEL 1. REPAIRED BEAM PER SRM 53-10-9. (M)SDR USAA000976Floorbeam · corrodedCLT - FOUND CORRODED FLOORBEAM 1 INCH BY 1 INCH 24 AREAS, STATION 986. INSTALLED NEW T-CAP PER TR 53-60-01. CORROSION LEVEL 1. (M)SDR DL73K001282Floorbeam · crackedTHE BL .07 FLOORBEAM WAS FOUND CRACKED IN THE WEB BETWEEN FS 700 AND FS 717. ERA 334520-14 REPAIRED THE DAMAGE SIMILIARLY TO S/B 737-57-1210 AT HMV.SDR DL73K001281Floorbeam · crackedTHE UPPER CAP AND WEB OF THE LBL 24 FLOOR BEAM WAS FOUND CRACKED BETWEEN STATIONS 670 AND 678. THE UPPER CAP WAS SPLICED AND THE WEB WAS REPAIRED PER ERA 334555-14 AT HMV.SDR DL73K001280Floorbeam · crackedTHE FUSELAGE WING CENTER SECTION FLOOR BEAM AT RBL 12 WAS CRACKED IN THE WEB AND UPPER CAP. THE UPPER CAP WAS CUT AND SPLICED TO REMOVE THE DAMAGE AND THE WEB WAS REPAIRED PER ERA 334535-14. THE DAMAGE WAS FOUND AT HMV.SDR AWXA0000444Floorbeam · corrodedUPPER SURFACE OF FLOORBEAM CORRODED AT STA 312 RBL 12. REMOVED AND REPLACED FLOORBEAM IAW B737 SRM 53-10-51 FIG 205.SDR AWXA0000443Floorbeam · corrodedFLOORBEAM CORRODED AT STA 328 RBL 10 TO RBL 43. REMOVED AND REPLACED UPPER CHORD IAW B737 SRM 53-10-50 FIG 205.SDR USAA000957Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED .50 INCH, BS 520 FLOORBEAM T-CAP RBL 44. INSTALLED KIT PER EA 67536 AND DWG 65C34688. (M)SDR USAA000956Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1 INCH, BS 520, LBL 44 FLOORBEAM T-CAP. INSTALLED DOUBLER AND REPAIRED FLOORBEAM PER EA 67536. (M)SDR USAA000955Floorbeam · crackedCLT - FOUND FLOORBEAM WITH CRACKS .375 INCH, BS 663, WL 208 UPPER T-CAP AND WEB BBL 0. INSTALLED KIT PER TR 57-10-04. (M)SDR USAA000954Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 2 INCHES, BS 986.5, LBL 38. INSTALLED NEW FLOOR SUPPORT PER SRM 51-10-1. (M)SDR ASAA0010080Floorbeam · corrodedPAE - DURING SCHEDULED D-CHECK, FOUND CORROSION ON THE FLOORBEAM BS 520, WL 208, RBL 45 TO 65. REPAIRED PER EA 5310-01837. (M)SDR ASAA0010083Floorbeam · misdrilledPAE - DURING SCHEDULED D-CHECK, BS 727B FLOORBEAM LOWER CHORD REPAIR REQUIRED DUE TO DOUBLER HOLE FROM PREVIOUS REPAIR. REPAIRED PER EA 5310-01836. (M)SDR ASAA0010084Floorbeam · corrodedPAE - DURING SCHEDULED D-CHECK, BS 500A FLOORBEAM UPPER AFT FLANGE CORRODED AT RBL 9.5, WL 208. REPAIRED PER EA 5310-01832. (M)SDR USAA000952Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH, STATION 1016, LBL 9.5 INCH, FORWARD FLANGE. REMOVED AND INSTALLED REPAIR PER SRM 53-10-09. CORROSION LEVEL 1. (M)SDR USAA000898Floorbeam · corrodedCLT - FOUND T-CAP CORRODED 2 INCHES, BS 294.5 AT BL 0. FABRICATED REPAIR PER TR 53-10-04B. (M)SDR USAA000950Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 3 INCHES BY 3 INCHES AND 2 INCHES BY 2 INCHES, BS 986.5 4 INCHES, RBL AND 4 INCHES THROUGH 12 INCHES LBL. FABRICATED NEW T-CAP AND ANGLE DOUBLER PER TR 53-60-01. (M)SDR USAA000939Floorbeam · crackedCLT - FOUND 2 CRACKS IN FLOORBEAM .100 INCH, BS 663, WL 208 UPPER T-CAP. INSTALLED REPAIR PER TR 57-10-04. (M)SDR USAA000938Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED .250 INCH, STATION 520, RBL 45 UPPER CHORD RADIUS. INSTALLED REPAIR PER EA 67455. (M)SDR USAA000937Floorbeam · crackedCLT - FOUND BEAM CRACKED 3 INCHES, BS 520, RBL 24, WL 208. INSTALLED REPAIR ANGLE PER EA 67455. (M)SDR USAA000936Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED, BS 520, LBL 45 UPPER CHORD AFT RADIUS. INSTALLED DOUBLER PER EA 67455. (M)SDR USAA000935Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED .500 INCH, BS 520, LBL 24 UPPER CHORD AFT RADIUS. REPAIRED PER EA 67455. (M)SDR SWAA001204Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND BS 1016 FLOORBEAM UPPER SURFACE CORRODED, RBL 17.5 TO RBL 35. REPAIRED BEAM PER SRM.SDR 0002476718Floorbeam · corrodedDURING M CHECK, FOUND CORROSION ON FLOORBEAM AT BS 1840 BL 0. REPAIRED PER EA 67-177822.SDR QXEA0001833Floorbeam · corrodedPDX- CENTER FLOORBEAM CORROSION ON TOP SURFACE LOCATED ABOVE FRAME 4610 INBOARD OF PASSENGER DOOR. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 8.SDR 0002486718Floorbeam · corrodedDURING M CHECK, FOUND CORROSION ON HORIZONTAL FLANGE OF LONGITUDINAL FLOORBEAM AT BS 1140 LBL 50. REPAIRED PER EA 67-177827.SDR COMA0010236Floorbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 5310-121/122-O1I, THE CABIN FLOOR SUPPORT CENTER CROSSBEAM AT FRAME 12 WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010235Floorbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 141-01Z, THE LEFT HAND CABIN FLOOR SUPPORT CROSSBEAM AT FRAME 20 WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB120 STRUCTURAL REPAIR MANUAL STANDARED PRACTICES.SDR COMA0010234Floorbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 142-01Z, THE RIGHT HAND FLOOR SUPPORT CROSSBEAM AT FRAME 20 WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010233Floorbeam · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 132-01Z, THE RIGHT HAND CABIN FLOOR SUPPORT CROSSBEAM AT FRAME 16 WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR CALA0000994Floorbeam · corrodedINSPECTION FOUND FLOORBEAM WEB AND FITTINGS CORRODED IN E/E COMPARTMENT AT LT SIDE, STA 160. THE CORRODED AREA WAS CUT OUT AND A REPAIR WAS INSTALLED IAW ECRA 5310-04025.SDR 0002691238Floorbeam · crackedDURING H CHECK, FOUND A 2.20 INCH CRACK IN THE UPPER FILLET RADIUS OF THE FLOORBEAM WEB AT FS 939 LBL 3. REPAIRED PER EA 12-170463.SDR 00FDEA00409Floorbeam · corrodedCORROSION BS 480 FLOORBEAM UPPER CHORD AROUND NUTPLATE HOLES AT RBL 11 & LBL 28, LOWER SURFACE OF CHORD, WL 208. R&R PER FEDEX SRM 51-10-6, 53-10-1.SDR C2XA00IA171Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FLOORBEAM AT FRAME 60 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW EMB145 SRM 51-40-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR AT0000463Floorbeam · corrodedAFT LAV FLOORBEAM AT BS 996 LONGERON 18 - 19R CORRODED. REMOVED FLOORBEAM AND CORRODED WEB. INSTALLED NEW WEB AND DOUBLER IAW DC9 SRM 51-05 FIG 72, 51-10-04, 51-10-03, AND 53-05 FIG 2.SDR F3LA00128Floorbeam · corrodedDEN - DURINGC-7 CHECK INSPECTION REPORTED, CORROSION ON TOP OF FLOORBEAM FRAME, BS 328 RBL 12. MAINTENANCE INSTALLED INTERCOSTAL, HI-LOCKS, ANGLE, BRACKETS AND FLOORCAP PER SRM 51-40-3. (M)SDR F3LA00138Floorbeam · damagedDEN - FOUND DURING C-7 CHECK INSPECTION, REPORTED AFT FLOOR FRAME IN AFT CARGO COMPARTMENT DAMAGED, BS 947. MAINTENANCE REMOVED DAMAGED AREA AND REPAIRED PER SRM 51-10-01, 51-10-02 AND 53-10-01. (M)SDR AALA20001042Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM AT STATION 380 BETWEEN RBL 23 AND RBL 63. INSTALLED DOUBLER ON FLOORBEAM PER SRM 53-10-08 PAGE 9B. (M)SDR CALA0000937Floorbeam · corrodedINSPECTION FOUND MID CARGO DOOR CUTOUT FLOORBEAM CORRODED AT FS 636 - 712, LONGERON 27R. THE BEAM WAS REMOVED AND REPLACED IAW SRM 51-30-02 AND 51-30-05. FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-30-02.
Back to JASC 5315