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 USAA2009102292851Floorbeam · corrodedSAL - Q2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON UPPER FLANGE OF FLOORBEAM EXISTING REPAIR AT BS 312 BETWEEN LBL 15 TO RBL 15. REPAIRED UPPER FLANGE OF FLOORBEAM AT BS 312 BETWEEN LBL 15 TO RBL 15 IAW B737 SRM 53-10-51.SDR USAA2009102192839Floorbeam · corrodedSAL - Q2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 967 BETWEEN RBL 49 TO LBL 26.5. REPAIRED FLOORBEAM AT BS 967 BETWEEN RBL 49 TO LBL 26.5 IAW B737 SRM 53-00-51.SDR USAA2009101992812Floorbeam · corrodedSAL - Q2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION FLOORBEAM UPPER CHORD AT BS 328 BETWEEN LBL 15 TO RBL 45.5. REPAIRED FLOORBEAM UPPER CHORD AT BS 328 BETWEEN LBL 15 TO RBL 45.5 IAW B737 SRM 53-10-51 REPAIR 5.SDR USAA2009101292752Floorbeam · corrodedSAL - Q2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 344 BETWEEN LBL 24.7 TO RBL 10. REPAIRED FLOORBEAM AT BS 344 BETWEEN LBL 24.7 TO RBL 10 IAW B737 SRM 53-10-51 REPAIR 5.SDR SWAA096031Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM WEB CRACKED BETWEEN BS 705 TO BS 715, LBL 24.5. REPAIRED BEAM PER AEO.SDR USAA2009102192831Floorbeam · corrodedSAL - Q2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM UPPER FLANGE AT BS 986.5 BETWEEN LBL 47 TO RBL 47. REPAIRED FLOORBEAM UPPER FLANGE AT BS 986.5 BETWEEN LBL 47 TO RBL 47 IAW TYPICAL REPAIR 53-10-05B.SDR UALA2009092202989Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED ON UPPER FLANGE BS 287, LBL 20 TO RBL 15. MAJOR REPAIR ACCOMPLISHED. CORROSION FOUND TO BE OUT OF LIMITS. DAMAGED SECTION OF FLOORBEAM REMOVED BETWEEN LBL 32 TO RBL 88. FABRICATED & INSTALLED A REPAIR T-ANGLE, SPLICE PLATE, ANSDR SWAA095988Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 947.5, BETWEEN RBL 5 TO RBL 20. REPAIRED BEAM PER SRM.SDR SWAA095987Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 312, RBL 51. REPAIRED BEAM PER SRM.SDR SWAA096011Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO BAY FLOORBEAM CORRODED AT BS 772, RBL 3. REPAIRED BEAM PER AAR EA.SDR SWAA096006Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BS 692, RBL 24.5. REPAIRED BEAM PER SRM.SDR SWAA096005Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 707 TO BS 714, BBL 0.07. REPAIRED WEB PER SRM.SDR SWAA095966Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND CENTER BOX WING FLOORBEAM LOWER CHORD CRACKED AT BS 663, RBL 24.8. REPAIRED BEAM PER ER.SDR SWAA095965Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 669, LBL 24.5. REPAIRED BEAM PER BAC DWG.SDR FDEA200909213342Floorbeam · corrodedMAIN DECK FLOORBEAM AT BS 377, LBL 3-20, UPPER CHORD HAS AREAS OF CORROSION. REMOVED CORROSION AT BS 377, LBL 3-20, IAW SRM 53-00-51. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DETAIL 3; ORIGINAL MATL- .125 INCH, AFTER REWORK- .090 INCH. REPAIR ACCSDR IPXA09557531Floorbeam · corrodedINSPECTION TYPE:C-2 MAIN CABIN, 1100 FLOORBEAM UPPER T-CHORD, LBL 65 TO RBL 65 IS CORRODED IN NUMEROUS AREAS. REPAIR PER ATS ER 09-4596.SDR IPXA09557530Floorbeam · corrodedINSPECTION TYPE:C-2 MAIN CABIN, 1200 FLOORBEAM UPPER T-CHORD, LBL 10 IS CORRODED. REPAIRED PER ATS ER 09-4583.SDR IPXA09557529Floorbeam · corrodedINSPECTION TYPE:C-2 MAIN CABIN, 1200 FLOORBEAM UPPER CHORD, RBL 45 - RBL 65 HAS CORROSION ON UPPER AND LOWER SURFACE. REPAIRED PER ATS ER 09-4538.SDR IPXA09657443Fitting · crackedINSPECTION TYPE:C MEC COMPT STA 246 FLOORBEAM CLIP AT RBL 10 FOUND CRACK. CRACK LENGTH 1.5 INCH. MEC COMPT BS 246 FLOORBEAM AT RBL 10 ATTACHED CLIP REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 45.SDR IPXA09657425Angle · crackedINSPECTION TYPE:C MEC COMPT STA 246 FLOORBEAM ANGLE AT LBL 25 FOUND CRACKED. CRACK LENGTH 0.5 INCH. MEC COMPT BS 246 FLOORBEAM AT LBL 25 ATTACHED ANGLE REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 45.SDR IPXA09657424Fitting · crackedINSPECTION TYPE:C MEC COMPT STA 246 FLOORBEAM CLIP AT LBL 50 FOUND CRACKED. CRACK LENGTH 1 INCH. MEC COMPT BS 246 FLOORBEAM AT LBL 50 ATT CLIP REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 45.SDR SWAA095904Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 270, BETWEEN LBL 10 TO RBL 10. REPAIRED BEAM PER SWA EA.SDR A6WA200940642Floorbeam · crackedFLOORBEAM IS CRACKED IN THE LOWER RADIUS, LBL 9.0, W/L 68.00. CRACK LENGTH IS .500" CUT/OUT OF FLOORBEAM, FABRICATION OF PIECES, NDT ON CUT/OUT AND FILLER, WET INSTALL, ALL THESE ABOVE IAW REO 601R-53-11-171, REV D. (K)SDR A6WA200940640Floorbeam · crackedFLOORBEAM IS CRACKED IN THE LWR RADIUS AT FS 280.00, W/L 68.00, CRACK LENGTH IS .500" CUT-OUT OF FLOORBEAM, FABRICATION OF PIECES, NDT FOR CUT/OUT AND FILLER, WET INSTALL. ALL THESE ABOVE IAW REO 601R-53-11-171, REV D. (K)SDR A6WA200940605Fitting · crackedCRACK FOUND ON FLOORBEAM FITTING FS 461, RBL 9.00 OTBD. FLOORBEAM FITTING AT FS 461.00, RBL 9.00 OTBD REPLACED IAW SRM 51-42-21. (K)SDR FDEA200909163309Floorbeam · corrodedSTA 365 FLOORBEAM RBL 10 CORRODED UPPER SURFACE. REMOVED CORROSION IAW SRM 53-00-51. ORIGINAL MATERIAL .125 MATERIAL REMOVED .025. AFTER REPAIR .100 INCH. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DETAIL III. REMOVED DAMAGED AREA AND PREVIOUS RSDR ASOA200901028Floorbeam · corrodedCOCKPIT FLOORBEAM IS CORRODED AND REQUIRES REPLACEMENT. REMOVED RT & LT FS 280 DIAGONAL BRACKETS PER SRM 51-42-21-001-001-A01 & 51-42-22-001-001-A01. NO DEFECTS NOTED. REMOVED DAMAGED COCKPIT FLOORBEAM PER SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01 & 5SDR ASOA200901008Floorbeam · crackedFLOOR ANGLE UNDER CARGO DOOR SILL AT FS589.00 AND LBL45 IS CRACKED (ANGLE ATTACHES FRAME TO SKIN). REMOVED AND REPLACED FLOOR ANGLE IAW SRM 51-40-11 & 51-42-21.SDR ASOA200901006Floorbeam · corrodedFLOOR TRANSVERSE BEAM UPPER ANGLES BETWEEN RBL9 AND LBL9AT FS 589.00 ARE CORRODEDSDR UALA2009091502904Floorbeam · damagedMAIN CABIN FLOORBEAM CORRODED BS 1520, LB L30. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF FLOORBEAM AT BS 1518, LBL 26 TO LBL 31. FABRICATED & INSTALLED A REPAIR SECTION OF T-CAP AND SPLICE ANGLES.SDR UALA2009091502900Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED ON UPPER FLANGE BS 287, RBL 88. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF FLOORBEAM BETWEEN LBL 32 TO RBL 88. FABRICATED & INSTALLED A REPAIR T-ANGLE, SPLICE PLATE AND SPLICE ANGLES.SDR ASOA200901004Floorbeam · corrodedCORROSION ON ASD CUTOUT THRESHOLD AND FLOORBEAM IN THE AFT LWR CORNER OF CUTOUT. REPAIRED SURFACE CORROSION IAW SRM 51-42-00.SDR GTIA0900022Floorbeam · corrodedFLOORBEAM AT Y160 BETWEEN FR68-FR70 / REMOVED AND REPLACED FLOORBEAM.SDR USAA2009092592634Floorbeam · corrodedLEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66+5 INCHES TO FR67+16 INCHES, Y1195. REPLACED FLOORBEAM BETWEEN FR66+5 INCHES TO FR67+16 INCHES, Y1195 IAW SRM 51-72-11. (K)SDR USAA2009092292593Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR67 + 16 INCHES & FR69 + 4 INCHES, Y1165. REPLACED FLOORBEAM BETWEEN FR67 + 16 INCHES & FR69 + 4 INCHES, Y1165 IAW A320 SRM 51-72-11 & A320 DRAWING 17053472000.SDR USAA2009092292591Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 +5 INCHES & FR70, Y765. REPLACED FLOORBEAM BETWEEN FR66 +5 INCHES & FR70, Y765 IAW A320 SRM 51-72-11.SDR USAA2009092192566Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM RAIL BETWEEN FR64 TO FR66 +5 INCHES, BL 765. REPLACED FLOORBEAM RAIL BETWEEN FR64 TO FR66 +5 INCHES, BL 76 IAW A320 SRM 51-72-11.SDR FDEA200909103284Floorbeam · crackedMAIN DECK BS 1014, LBL 24 TO LBL 45 FLOOR SUPPORT SHIM CRACKED. CRACKED COVER PLATE AT BS 1014 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR GMM 6-2-100 CRITERIA.SDR FDEA200909103283Floorbeam · crackedMAIN DECK BS 900, RBL 24 TO RBL 45 FLOOR SUPPORT SHIM CRACKED. CRACKED COVER PLATE AT BS 900 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200909103282Floorbeam · crackedMAIN DECK BS 1060, LBL 24 TO LBL 45 FLOOR SUPPORT SHIM CRACKED. CRACKED COVER PLATE AT BS 1060 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200909103281Floorbeam · crackedMAIN DECK BS 1014, RBL 24 TO RBL 45 FLOOR SUPPORT SHIM CRACKED. CRACKED SHIM PLATE AT BS 1014 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200909103280Shim · crackedMAIN DECK BS 1054 RBL 24 TO RBL 45 FLOORBEAM SHIM CRACKED. REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR ASOA200901093Floorbeam · crackedIN REFERENCE TO TASK CARD AWL2 53-41-201. CAP ANGLE CRACKED IN RADIUS AT LBL 18.00 AT FS 559.00SDR SWAA095815Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND CENTER WING BOX FLOORBEAM CHORD CRACKED AT BS 663, LBL 24.8. REPAIRED BEAM PER ER.SDR SWAA095809Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED BEAM PER SWA EA.SDR SWAA095807Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 6. REPAIRED BEAM PER SWA EA.SDR SWAA095806Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 3. REPAIRED BEAM PER SWA EA.SDR SWAA095781Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, LBL 5. REPAIRED BEAM PER SRM.SDR FDEA200909093276Floorbeam · corrodedMAIN CABIN BS 334 LBL 20 FLOORBEAM CORRODED. CABIN BS 334, LBL 20 FLOOR MOUNT FITTING REMOVED AND REPLACED IAW SRM 51-40-02 REV. 97. THIS REPAIR IS CLASSIFIED AS MINOR GMM 6-2-100 CRITERIA.SDR A6WA200940592Floorbeam · crackedFLOORBEAM LWR FLANGE CRACKED AT FS 280, RBL 9, CRACK LENGTH 1.20". REPAIR PERFORMED IAW REO 601R-53-11-171, REV D. ANGLE FILLER FABRICATED IAW REO 601R-53-11-171, REV D. (K)
Back to JASC 5315