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 UPS99229283Floorbeam · corrodedINSPECTION TYPE:SI CORROSION ON FLOORBEAM BS 312, LBL 3.5, WL 208. REMOVED AND REPLACED UPPER CHORD SEGMENT PER SRM 53-10-8 FIG 9.SDR LR7A99129Floorbeam · corrodedDURING C CHECK/BRIDGING INSPECTION PER HC05297, FOUND CARGO LOWER STRUCTURE FS 597 UPPER BEAM CAP CORRODED AT RBL 40. REPLACED CAP IAW SMP 583 53-40. NR 924.SDR LR7A99128Floorbeam · corrodedDURING C CHECK/BRIDGING INSPECTION PER HC05297, FOUND CARGO COMPARTMENT FLOOR FS 657 UPPER BEAM CAP CORRODED AT RLB 20. REPAIRED BEAM CAP IAW MPP L100 404-99-019. NR 921SDR C2XA99IA219Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND THE CENTER FLOORBEAM CORRODED AT FRAME 20 UNDER COMPOSITE FLOOR PANEL SUPPORT. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF FLOORBEAM IAW EMB145 SRM 51-40-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVISDR C2XA99IA217Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND LEFT FLOORBEAM CORRODED AT FRAME 20 UNDER COMPOSITE FLOOR PANEL SUPPORT. MAINTENANCE REMOVED THE CORROSION, AND INSTALLED A REPAIR DOUBLER ON THE FLOORBEAM IAW CONTINENTAL EXPRESS ENGINEERING CHANGE/REPAIR AUTHORIZATION SDR SWAA990682Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM UPPER CHORD, BS 328, LBL 28. REPAIRED BEAM PER SWA RA NR 1-353-2049.SDR 9901946719Floorbeam · crackedDURING M CHECK, FOUND CRACK IN UPPER DECK FLOORBEAM UPPER CHORD FS 400. PERMANENT REPAIR WAS MADE PER EA 67-155225.SDR UPS99229222Floorbeam · corrodedINSPECTION TYPE:S,I WHILE WORKING CARD 888501 DISCOVERED CORROSION ON FLOORBEAM BS 344 RBL 16-25 WL 208. REPAIR FLOORBEAM PER SRM 51-30-2 SRM 53-10-08.SDR 99FDEA00139Floorbeam · corrodedWHILE WORKING ON 72C201-01 DISCOVERED CORROSION ON FLOORBEAM BS 1050, RBL 20, WL 200. ** S/D ** REPAIRED FLOORBEAM PER FEDEX EA 7-5310-43772A.SDR SWAA990667Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 986 WL 208 ON PREVIOUS REPAIR. REPAIRED BEAM PER ER 99-0269.SDR SIMA990976Floorbeam · dentedSAW - DURING CPCP-2 INSPECTION, FOUND FLOORBEAM 36 WITH AN OVERSIZED HI-LOCK HOLE. SPLICED IN NEW SECTION OF FLOORBEAM 2 INCH BY 7 INCH BY .067 DEEP DENT IN THE LEFT SIDE OF THE FUSELAGE SKIN BETWEEN FRAMES 12 AND 13 AND STRINGERS 9 AND 13. MAINTENANCE REPAISDR P2EA99157Floorbeam · corrodedSJO - DURING C-CHECK, IN THE PASSENGER CABIN, BS 360, RBL 13, THE FLOORBEAM UPPER CHORD WAS FOUND WITH CORROSION. REPAIRED FLOORBEAM UPPER CHORD AT BS 360 BETWEEN RBL 5 AND RBL 21 DUE TO CORROSION PER SRM 53-10-9 FIGURE 1. (M)SDR P2EA99156Floorbeam · corrodedSJO - DURING C-CHECK, IN THE PASSENGER CABIN, BS 344, BETWEEN LBL 60 AND RBL 60 FLOORBEAM UPPER CHORD WAS FOUND WITH CORROSION. REPAIRED FLOORBEAM UPPER CHORD AT BS 344, BETWEEN LBL 65 AND RBL 65 DUE TO CORROSION PER SRM 53-10-9 FIGURE 5. (M)SDR MWEA99179Floorbeam · misdrilledFLOORBEAM AT FS 313 RBL 6 TO RBL 20 HAS MISDRILLED HOLES IN RADIUS OF BEAM. FABRICATED FLANGE REPAIR.SDR CALA9900365Floorbeam Web · crackedINSPECTION FOUND A 3 INCH CRACK IN FLOORBEAM WEB AT FS 294, RBL 48. THE CRACK WAS STOP DRILLED AND A DOUBLER WAS INSTALLED IAW SRM 51-40-2 FIGURE 1, SHEET 6.SDR AU990415Floorbeam · cracked(AUS) CRACKS FOUND IN FLOOR BEAM AT FRAME 18 LOCATED ON THE RIGHT SIDE JUST BELOW THE FLOOR LINE.SDR P2EA99177Floorbeam · corrodedSJO - DURING C-CHECK, IN PASSENGER CABIN AFT LAVATORY AREA, BS 947, BETWEEN RBL 54 INCH AND LBL 54 INCH, FLOORBEAM WAS FOUND WITH CORROSION. REPAIRED FLOORBEAM UPPER CHORD AT BS 947, BETWEEN LBL 59 AND RBL 59 PER COOPESA EO COO-3-53-222-99, DATED APR 8, 1999.SDR DHL9970105DFloorbeam · corrodedAT D-CHECK, FUSE FLOORBEAM CORRODED AT STA 380 BL 49L. CUT OUT FLOORBEAM TO LBL 49. CUT FLOORBEAM CAP OUT FROM LBL 12 TO O/B END. FABRICATED NEW FLOORBEAM TOP CAP WITH SPLICED DOUBLERS PER SRM 53-10-8, 59.5 LONG.SDR AWXA9900135Floorbeam · corrodedFWD CABIN FLOORBEAM AT Y189 RT UPPER FLANGE CORRODED BEYOND SRM LIMITS FRAME 21 TO FRAME 22. FLOORBEAM REMOVED, FABRICATED NEW DUMMY RAIL PER DWG D53112836, SPLICED NEW DUMMY RAIL TO EXISTING STRUCTURE PER SRM 53-11-14. SURROUNDING STRUCTURE TREATED AND PRIMSDR AWXA9900134Floorbeam · corrodedFWD CABIN FLOORBEAM AT Y254 RT SURFACE CORRODED BEYOND SRM LIMITS FRAME 12 TO FRAME 16. FLOORBEAM REMOVED, FABRICATED NEW FLOORBEAM AS PER DWG D53112836, SPLICED NEW FLOORBEAM TO EXISTING STRUCTURE AS PER SRM 53-11-14. SURROUNDING STRUCTURE TREATED AND PRIMESDR P2EA99171Floorbeam · corrodedSJO - DURING C-CHECK, IN THE PASSENGER CABIN, AFT LAVATORY AREA, BS 987, BETWEEN RBL 47 INCH AND LBL 47 INCH, FLOORBEAM WAS FOUND CORRODED. REPAIRED UPPER CHORD OF FLOORBEAM, BS 987, BETWEEN LBL 51.250 AND RBL 51.250 PER COOPESA EO COO-3-53-223-99, DATED APR SDR P2EA99169Floorbeam · corrodedSJO - DURING C-CHECK, IN THE PASSENGER CABIN, AFT LAVATORY AREA, BS 1016, BETWEEN RBL 38 INCH AND LBL 38 INCH, FLOORBEAM WAS FOUND CORRODED. REPAIRED FLOORBEAM UPPER CHORD AT BS 1016, BETWEEN LBL 41 INCH AND RBL 41 INCH PER COOPESA EO COO-3-53-224-99, DATED ASDR P2EA99162unknownSJO - DURING C-CHECK, IN THE PASSENGER CABIN, AFT LAVATORY AREA, BS 967, BETWEEN RBL 54 AND LBL 54, FLOORBEAM WAS FOUND CORRODED. REPAIRED FLOORBEAM UPPER CHORD BS 967, BETWEEN LBL 12 AND RBL 12 PER SRM 53-10-9 FIGURE 7. CORROSION REMOVED, TREATED, AND WITHISDR QXEA9900958Floorbeam · damagedPDX - MAIN CABIN FLOORBEAM STRUCTURE IS DISTORTED BETWEEN FRAME 16660 AND 16060. REPAIRED IAW HORIZON AIR EA 4-53-713.SDR USAA990277Floorbeam · corrodedCLT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND A .5 INCH BY .5 INCH AREA OF CORROSION AROUND NUT PLATES BS 986 LBL 44 - RBL 30 'T' CAP OF FLOORBEAM. CORROSION TASK NR C53-107-02. REPAIRED PER TR 53-60-01. (M)SDR USAA990225Floorbeam · corrodedCLT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND A .5 INCH BY .5 INCH AREA OF CORROSION AT NUT PLATE HOLES BS 947 LBL 24 - RBL 24 FLOORBEAM, CORROSION TASK NR C53-107-02. INSTALLED REPAIR 'T' SECTION AND REPAIR ANGLE PER SRM 53-00-51. (M)SDR SWAA990631Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FLOORBEAM TOP FLANGE BS 947, LBL 53. REPAIRED PER SRM.SDR SWAA990627Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT 4 FLOORBEAM SECTIONS BS 727E, BS 767, BS 845 AT RBL 8 AND BS 727D, RBL 14. REPAIRED BEAMS PER SRM.SDR SWAA990625Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED PER SRM.SDR SWAA990624Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 45. REPAIRED PER SRM.SDR SWAA990622Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM BS 1006, LBL 13-15. REPAIRED BEAM PER SRM.SDR RRXA991226Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSEALAGE, CABIN FLOOR PLANK AT STA 1460 AND BL 6 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 51-1-8 PGS 16 ANDSDR RRXA991224Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1500 AND STA 1520 AT BL 36 LEF. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 5SDR CALA9900349Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5. A REPAIR WAS INSTALLED IAW ECRA 5310-03836.SDR USAA990281Floorbeam · corrodedCLT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND A AREA OF CORROSION AT BS 344, LBL 50 TO RBL 10 CLIPNUT HOLES FLOORBEAM 'T' CAP. CORROSION TASK NR C53-107-02. FABRICATED 'T' CAP REPAIR PER SRM 53-10-51. (M)SDR USAA990278Floorbeam · corrosionCLT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND A 3 INCH BY 1 INCH AREA OF CORROSION AT STATION 360 UPPER 'T' CAP FLOORBEAM, CORROSION TASK NR C53-107-02. REPLACED 'T' CAP ON FLOORBEAM PER SRM 53-00-51. (M)SDR USAA990239Floorbeam · corrodedCLT - DURING C-2 CHECK VISUAL INSPECTION, FOUND CORROSION TOP SURFACE FLOORBEAM STATION 1681.8, CORROSION TASK NR C53-251-03/C53-252-03. REPLACED FLOORBEAM PER SRM 51-10-00. (M)SDR USAA990233Floorbeam · corrodedCLT - DURING C-2 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM TOP SURFACE STATION 1640 ENTIRE LENGTH. CORROSION TASK NR C53-251-03 AND C53-252-03. REPLACED WITH NEW FABRICATED T-CAP PER TR 53-15-01 AND EA 63981. (M)SDR USAA990229Floorbeam · corrodedCLT - DURING C-2 CHECK VISUAL INSPECTION, FOUND CORROSION AT STATION 324 RBL 46 TO RBL 62 FLOORBEAM. REPLACED FLOORBEAM PER EA 63950. (M)SDR USAA990227Floorbeam · corrodedDURING C-2 CHECK VISUAL INSPECTION, FOUND CORROSION TOP OF FLOORBEAM STA 365 LBL 62 TO RBL 62. REPAIRED T-CAP PER SRM 53-00-51. (X)SDR USAA990218Floorbeam · corrodedCLT - DURING C-2 CHECK VISUAL INSPECTION, FOUND CORROSION STATION 345 TOP OF FLOORBEAM. INSTALLED 'T' CAP PER SRM 53-00-51, EA 63948A AND TR 53-15-01. (M)SDR USAA990184Floorbeam · corrodedCLT - DURING C-2 CHECK VISUAL INSPECTION, FOUND CORROSION UPPER SURFACE FLOORBEAM AT STATION 1681.8 FROM RBL 17 TO LBL 17, CORROSION TASK NR C53-251-03/C53-252-03. REPLACED PER SRM 51-10-00. (M)SDR USAA990183Floorbeam · corrodedDURING C-CHECK VISUAL INSPECTION, FOUND CORROSION UPPER SURFACE FLOORBEAM AT STA 1661 FROM RBL 17 TO LBL 17. CORROSION TASK NR C53-251-03/C53-252-03. BLENDED CORROSION PER SRM 53-00-51. (X)SDR USAA990181Floorbeam · corrodedDURING C-2 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 60 INCH CORRODED AREA AT BS 377.7 FLOORBEAM UPPER CHORD LBBL 30 - RBL 30. REPLACED T-CAP PER TR 53-15-01. (X)SDR ASAA9940076Floorbeam · corrodedPHX - DURING SI CHECK, FOUND THE FLOORBEAM AT STATION 294.5, BL 0 - RBL 5 UPPER CAP CORRODED. REPAIRED PER EA 53-10-08. (M)SDR ASAA9940075Floorbeam · corrodedPHX - DURING SI CHECK, FOUND THE FLOORBEAM UPPER HORIZONTAL CAP CORRODED AT STAITON 967, LBL 18. REPAIRED PER SRM 53-00-51. (M)SDR ASAA9940074Floorbeam · corrodedPHX - DURING SI CHECK, FOUND THE FLOORBEAM UPPER HORIZONTAL CAP, TO SURFACE, CORRODED AT STATION 312 LBL 2 - RLB 7. REPAIRED PER SRM 53-10-51 AND DRAWING 65C33941. (M)SDR SWAA990607Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAMS, BS 727E LBL3, BS 767, LBL8, BS 807, LBL18, AND BS 827, LBL 18. REPAIRED BEAMS PER SWA REPAIR AUTH 1-A53-2021.SDR RAAA99B2025Floorbeam · corrodedDURING SCHEDULED C-CHECK, FOUND BS 344 FLOORBEAM FORWARD FLANGE CORRODED AT RBL 44 THRU 64. REPLACED BEAM UPPER CHORD BETWEEN RBL 68 AND LBL 33 IAW SRM 53-10-8 FIG 9 M54 NR 368.SDR ASAA9940082Floorbeam · corrodedPHX - DURING SI CHECK, FOUND THE UPPER HORIZONTAL CAP OF THE FLOORBEAM AT STATION 947.5 CORRODED FROM RBL 13 TO LBL 13. REPAIRED PER EA 5310-01665. (M)
Back to JASC 5315