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 F3LA96036Floorbeam · corrodedPAE - FOUND CORROSION ON UNDERSIDE OF CARGO FLOORBEAM BS 500, RBL 18, WL 156. REMOVED CORROSION ON UNDERSIDE OF FLOORBEAM AND REPAIRED IAW SRM 53-10-1, 51-40-3 REF WORK ORDER FUSELAGE 262. (M)SDR USAA960667Floor Beam · corrosionCLT - INSPECTION VISUALLY FOUND LEVEL 2 CORROSION MEASURING 11 INCHES TOTAL AREA AT FLOOR BEAM T-CAP, STATION 947.5 - LBL 9 TO RBL 33. CORROSION TASK NR C53-107-02, CORROSION LEVEL 2. CORRODED SECTION REMOVED. REPAIRED ANGLES INSTALLED AS PER USAIR EA NR 58SDR MWEA96604Floor Beam · corrodedDURING D-CHECK, FOUND FLOOR BEAM AT STA 801 HAS SEVERAL AREAS OF EXFOLIATION CORROSION ON UPPER FLANGE UNDER RT LAV. MAINTENANCE INSTALLED DOUBLER REPAIR IAW SRM 53-05 FIG 20A.SDR MWEA96582Floor Beam · corrodedDURING D-CHECK, FOUND FLOOR BEAM AT STA 801 HAS SEVERAL AREAS OF EXFOLIATION CORROSION AROUND NUTPLATES ON UPPER ANGLE OF FLOOR BEAM. FABRICATED AND INSTALLED REPAIR IAW SRM 53-05, FIG 20M.SDR 9622235526Floorbeam · corrodedDURING P-CHECK, FOUND CORROSION ON THE BS 1661 FLOORBEAM UPPER CHORD ALONG THE ENTIRE LENGTH. REPAIRED CHORD PER EA 55-110373.SDR 9622229852Floorbeam · corrodedDURING H-CHECK, FOUND CORROSION IN THE FS 1136 FLOORBEAM CAP AT THE AIRCRAFT CENTER LINE. REPAIRED FLOORBEAM CAP (P/N 9912243-55) PER EA 98-111715.SDR 96FDEA01594Floorbeam · corrodedEXFOLIATION CORROSION ON FLOORBEAM AT FS 344 FROM RBL 14 TO LBL 35. CUT AND SPLICED IN NEW SECTION OF UPPER FLOORBEAM CAP AT FS 344 FROM 14 RBL TO 70 LBL IAW SRM 53-10-8 FIG 9.SDR AWXA960626Floor Beam · corrodedPAE - FLT 7837 - DURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOOR BEAM STATION 987, LBL 15, RBL 3 AND RBL 30-35. REMOVED AND REPLACED UPPER CHORD OF FLOOR BEAM FROM LBL 55 TO RBL 55, BS 987, WL 208, PER SRM 51-30-2 AND ER 2-53-15-36, TCO-PAN-96-141RSDR 97ZZZX1608Floor Beam · corrodedDURING C-CHECK INSPECTION, A CRACK WAS NOTED IN FLOOR BEAM UPPER CHORD AT FS 890, BL ZERO.SDR 97ZZZX1530Floor Beam · crackedDURING C-CHECK INSPECTION, A CRACK WAS NOTED IN CABIN FLOOR BEAM STA 718 AT RBL 8 TO RBL 12.SDR 97ZZZX1444Floor Beam · corrodedDURING C-10 INSPECTION, CORROSION WAS NOTED ON UPPER SURFACE OF FLOOR BEAM AT FS 1130 AT RBL 24.SDR SWAA961071Floor Beam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 312, 328, 270, AND 294. REPAIRED PER BOEING SRM.SDR AWXA960620Floor Beam · corrodedPAE - FLT 7837 - DURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOOR BEAM BS 1016, LBL 26. REMOVED CORRODED FLOOR BEAM, FABRICATED REPAIR PARTS, AND INSTALLED PER E.R. 2-53-15-50, TCO-PAN-96-1408RR-8110-3. (X)SDR 97ZZZX1607Floor Beam · corrodedDURING C-CHECK INSPECTION, CORROSION WAS NOTED ON UPPER CHORD OF CABIN FLOOR BEAM FS 344.SDR 97ZZZX1467Floor Beam · corrodedDURING C-10 INSPECTION, CORROSION WAS NOTED ON LOWER FLOOR BEAM CHORD AT FS 1166 AT BL ZERO.SDR 96FDEA01570Floorbeam · corrodedMAIN CARGO CORROSION ON FLOORBEAM AT STA 1110 FROM 10 TO 24 LBL. REMOVED CORROSION PER SRM 51-10-6. ALL WITHIN TOLERANCE PER SRM 53-10-1 EXCEPT FOR AREA AT LBL 20 CENTER OF F/B WHICH IS OUT OF TOLERANCE. FABRICATED DOUBLER PER AARD 53-10-07-2 PER AARD 53-1SDR AWXA960623Floor Beam · corrodedPAE - FLT 7837 - DURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOOR BEAM 967, RBL 15-55, WL 208. REPAIRED PER SRM 53-10-9 BY FABRICATING AND INSTALLING UPPER CHORD. (M)SDR 96FDEA01566Floor Beam · corrodedNR0438 AND 016, CORROSION (C53-111-01, -3) IN THE AFT CARGO BAY AT BS 1130 LBL 11 TO 13 WL 199 ON FLOORBEAM AT NUTPLATE HOLES. *S/D* CORROSION FOUND TO BE OUT OF LIMITS. REMOVED DAMGE, FABRICATED REPAIR FILLERS AND ANGLES, INSTALLED IAW FEDEX EA 7-5310-311SDR UPS96221297Floorbeam · corrodedINSPECTION TYPE-D, CORROSION UNDER ANCHOR NUT ON FLOORBEAM AT BS 560, LBL 35. REPAIRED FLOORBEAM.SDR UPS96221277Floorbeam · corrodedINSPECTION TYPE-D, CORROSION UNDER ANCHOR NUT ON FLOORBEAM AT BS 560, LBL 55. FLOORBEAM REPAIRED SRS EO 96-33-015.SDR AALA961471Floor Beam · corrodedAFW - FOUND FLOOR BEAM AT STATION 377 LBL 48 HAD CORROSION REMOVED BEYOND SRM LIMITS. REPAIRED PER MRB 757-962. (M)SDR AALA961468Floor Beam · corrodedAFW - FOUND FLOOR BEAM STATION 1640 RBL 30 HAD CORROSION REMOVED BEYOND SRM LIMITS. REPAIRED PER MRB 757-958. (M)SDR 96FDEA01563Floor Beam · corrosionNR0594 AND 015, CORROSION (C53-224-01, -3) AT BS 1110 RBL 43 WL 207 EMITTING FROM UNDER SIDE OF TOP FLANGE OF FLOOR BEAM AT FASTENER HOLE. *S/D* REPAIRED CORROSION DAMAGE ON FLOOR BEAM AT BS 1110 RBL 43 WL 207 PER FEDEX SRM 53-10-8 FIG 8.SDR EIAA970071Floorbeam · corrodedSAT - DURING B-CHECK INSPECTION, FOUND FLOORBEAM AT STATION 480, LBL 24 TO LBL 29 CORRODED AT PREVIOUS REPAIR. REMOVED DAMAGED SECTION OF FLOORBEAM FROM BL 0 TO LBL 72. FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53-10-07, FIG 12. (M)SDR EIAA9644Floor Beam · crackedSAT - FLOOR BEAM AT STATION 480, LBL 24, THROUGH LBL 29 CORRODED. REMOVED DAMAGED FLOOR BEAM FROM BL 0 TO LBL 72. FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53-10-07, FIG 12. (M)SDR EIAA9643Floor Beam · crackedSAT - FLOOR BEAM AT STATION 460, LBL 11 THROUGH 24 CRACKED. REMOVED DAMAGED SECTION OF FLOOR BEAM FROM RBL 48 TO LBL 48. FABRICATED AND INSTALLED REPAIR PARTS PER SRM 53-10-07, FIG 12. (M)SDR 97ZZZX1419Floor Beam · corrodedDURING C-10 INSPECTION, CORROSION WAS NOTED ON FLOOR BEAM UPPER CORD, FS 400, WL 208.SDR 9621956310Floor Beam · corrodedDURING P-CHECK, FOUND CORROSION ON THE BS 480 MAIN DECK FLOOR BEAM UPPER CHORD AT RBL 64. REPAIRED CHORD PER EA 63-106424.SDR 9621946310Floor Beam · corrodedDURING P-CHECK, FOUND CORROSION ON THE BS 520 MAIN DECK FLOOR BEAM UPPER CHORD FROM RBL 46 TO 64. REPAIRED CHORD PER EA 63-110096.SDR USAA960639Floor Beam · corrosionCLT - INSPECTION VISUALLY FOUND LEVEL 2 CORROSION AT CLIP NUT HOLES, LOCATED AT FLOOR BEAM FULL SPAN, BS 986.5. REPLACED UPPER FLANGE AS PER USAIR EA NR 58809. CORROSION TASK NR C-53-107-02, CORROSION LEVEL 2. (M)SDR F3LA96029Floor Beam · crackedDURING SERVICE CHECK, INSPECTION REPORTED A 1.25 INCH CRACK IN THE CABIN FLOOR BEAM WEB AT STATION 663, BBL 0. REPAIRED PER BOEING SERVICE BULLETIN 737-57-121D, FIG 4 AND BOEING TELEX M-7272-96-4639. (M)SDR DHL9672267CFloor Beam · corrodedAT C-CHECK, FWD CARGO COMPT, LOWER FLANGE OF FLOOR BEAM HAS EXFOLIATED CORROSION AT BS 560, RBL 54. INSTALLED REPAIR PER SRM 53-10-8, 14 BY 2.SDR SWAA961036Floorbeam Web · corrodedDURING SCHEDULED D-CHECK, FOUND WEB CORRODED AT BS 1019 RBL 5 AND AT BS 1030 RBL 10 WL 208. REPLACED PER BOEING SRM.SDR SWAA961035Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER FLANGE CORROSION AT BS 986.5 RBL 37 LBL 5 WL 208. REPAIRED PER BOEING SRM.SDR SWAA961034Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 394.5, LBL 10 TO 12, WL 208 AND RBL 37 TO 50. REPAIRED PER BOEING SRM.SDR DU4R9600042Floor Beam · corrodedDURING SCHEDULED INSPECTION AT AERO CORP IN LAKE CITY, FL, FOUND BS 980.0 RBL 28 WL 208.0 AT CARGO PIT FLOOR BEAM SUPPORT CORRODED.SDR 96FDEA01557Floorbeam · corrodedNR0440 AND 012, CORROSION (C53-111-01,-3) IN AFT CARGO BAY AT BS1050 LBL TO RBL 20 WL 199 ON FLOOR BEAM AT NUTPLATE HOLES. *S/D* REMOVED CORRODED SECTION OF BS 1050 FLOORBEAM FROM LBL TO RBL 25 LOWER FLANGE. REPAIRED LOWER FLANGE PER FEDEX SRM 53-10-8 FIG 3SDR AALA961448Floor Beam · corrodedAFW - FOUND FLOOR BEAM AT 1640 HAS CORROSION. PER MRB 757-966. (M)SDR 96FDEA01552Floorbeam · corrosionNR0434 AND 009, CORROSION (C53-224-01, -1, -100) AT STA 620 RBL 3 WL 208 ON FRAME FILLER. *S/D* REPAIRED FLOORBEAM AT BS 620 WL 208 RBL 35 TO LBL 24 IAW FEDEX SRM 53-10-8 FIG 3.SDR USAA960658Floor Beam · crackedINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND FOUR .75 INCH CRACKS, LBL 25 INCHES LONG FLOOR BEAM WEB STATION 707 TO 712, WL 203.5. INSTALLED DOUBLER, REPAIRED PER SRM 51-40-2. (M)SDR USAA960657Floor Beam · crackedINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND FOUR .5 INCH CRACKS BL 0 INCH LONG FLOOR BEAM WEB STATION 707 TO STATION 712, WL 203.5. INSTALLED REPAIR WEB, REPAIRED PER SRM 51-40-2. (M)SDR USAA960650Floor Beam · crackedINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND .5 INCH CRACKS IN FOUR PLACES, RBL 25 INCHES LONG, FLOOR BEAM WEB STATION 707 TO 712, WL 203.5. INSTALLED WEB REPAIR, REPAIRED PER SRM 51-40-2. (M)SDR USAA960642Floor Beam · crackedINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND 1.25 INCH CRACK BS 675 WL 202.5 LONGITUDINAL FLOOR BEAM LOWER CHORD. INSTALLED REINFORCING ANGLE/SPLICE, REPAIRED PER EA 41578. (M)SDR USAA960641Floor Beam · crackedINT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND 1.5 INCH CRACK RBL 45 LONG FLOOR BEAM LOWER CHORD STATION 695 WL 202.5. INSTALLED REPAIR ANGLE, REPAIRED PER EA 41557. (M)SDR USAA960638Floor Beam · corrosionCLT - INSPECTION VISUALLY FOUND A 1 INCH BY .5 INCH LEVEL 2 CORRODED AREA, LOCATED AT FLOOR BEAM STATION NR 344 LBL 22. INSTALLED REPAIR ANGLES PER USAIR TYPICAL REPAIR 53-10-01A. CORROSION TASK NR C53-107-02, CORROSION LEVEL 2. (M)SDR USAA960635Floor Beam · corrosionCLT - INSPECTION VISUALLY FOUND .5 INCH BY .5 INCH LEVEL 2 CORRODED AREA AT CLIP NUT HOLES LOCATED AT FLOOR BEAM STATION NR 986.5, LBBL 45 - RBBL 45. INSTALLED REPLACEMENT T-CAP AND SPLICE ANGLES PER USAIR EA NR 58809. CORROSION TASK NR C53-107-02, CORROSIONSDR USAA960634Floor Beam · corrosionCLT - INSPECTION VISUALLY FOUND A .5 INCH BY 4 INCH LEVEL 2 CORRODED AREA, LOCATED AT FLOOR BEAM STATION NR 312, LBL 26. INSTALLED REPAIR ANGLES AS PER USAIR TYPICAL REPAIR 53-10-03. CORROSION TASK NR C53-107-02, CORRROSION LEVEL 2. (M)SDR SWAA961022Floor Beam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 344. REPLACED T-CAP PER BOEING SRM,SDR SWAA961021Floor Beam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 294. REPLACED T-CAP PER BOEING SRM,SDR SWAA961020Floor Beam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOORBEAM CORROSION AT BS 344, LBL 49, 43, 35, 33, 29, 28 AROUND NUTPLATE HOLE. REPLACED T-CAP PER BOEING SRM,
Back to JASC 5315