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 ASOA201000559Crossbeam · corrodedFS 280 BETWEEN S17 RT & LT HAS CORROSION IN SEVERAL PLACES AND ON THE FWD ENDS OF THE LT & RT BEAMS CONTINUATION OF JOB 7106711 OP 207. KJ161732 4/5/10. INSTALLED LT + RT 280 CROSSBEAM IN REF IS670531100026 SB 670BA-53-026. (CLOSED)SDR YENA20100414061Frame · corrodedFLT 6428 JFK-BNA DURING HMV VISIT AT BNA FOUND FWD FUSELAGE FLOORBEAM HAS CORROSION AT APPROX FRAME 14 AND FRAME 19 ALONG LBL 12. REPAIRED IAW JB E10-175-01. STRUCTURAL CONDITION REPORT STATES ITEM WAS REPAIRED REF ETD2010-190/02525 REV B AND EA E10-175-01 RSDR DL75E101225Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CHORD TOP SURFACE AT STA 365, RBL 24 TO RBL 48. COMPLIED WITH ER/A 481845-14, REF NON ROUTINE CARD 168871.SDR IPXA10659431Floorbeam · crackedINSPECTION TYPE:C, MAIN DECK STA 246 FLOORBEAM ATTACH ANGLE FOUND CRACKED AT LBL 25". MAIN DECK STA 246 FLOORBEAM AT LBL 25" ATTACH ANGLE REPLACED IAW SRM 51-10-02 AND INSTALLED IAW SRM 51-40-02.SDR IPXA10659430Floorbeam · crackedINSPECTION TYPE:C, MAIN DECK STA 246 FLOORBEAM ATTACH CLIP FOUND CRACKED AT LBL 50" MAIN DECK STA 246 FLOORBEAM AT LBL50" ATT CLIP REPLACED IAW SRM 51-10-02 AND INSTALLED IAW SRM 51-40-02.SDR SWAA102111Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 771 TO 773, LBL 17. REPAIRED FLOORBEAM PER EA.SDR SWAA102110Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 771 TO 773, RBL 8. REPAIRED FLOORBEAM PER EA.SDR SWAA102109Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 727D+2 TO 727D+4, RBL 3. REPAIRED FLOORBEAM PER EA.SDR SWAA102065Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 729D TO BS 731D, LBL 3. REPAIRED BEAM PER EA.SDR SWAA102064Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 729D TO BS 731D, RBL 8. REPAIRED BEAM PER EA.SDR SWAA102063Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 729D TO BS 731D, LBL 13. REPAIRED BEAM PER EA.SDR SWAA102062Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 771 TO BS 773, LBL 3. REPAIRED BEAM PER EA.SDR SWAA102061Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 771 TO BS 773, RBL 3. REPAIRED BEAM PER EA.SDR SWAA102060Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 771 TO BS 773, LBL 8. REPAIRED BEAM PER EA.SDR SWAA102059Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 771 TO BS 773, LBL 13. REPAIRED BEAM PER EA.SDR SWAA102043Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER ER.SDR DL75E101253Floorbeam · corrodedMAIN CABIN FLOORBEAM PREVIOUS REPAIR CORRODED STA 1640, LBL 62 TO RBL 62. R & R PREVIOUS REPAIR, REF NON ROUTINE CARD 154872.SDR DALA107529859Floorbeam · crackedDURING L-CHECK FOUND CRACK AND SHEARED FASTENERS ON CARGO FLOORBEAM AT BS 1140 LBL54. REPAIRED IAW SRM 51-72-01.SDR V0XR201004090002Floorbeam · corrodedFLOOR SUPPORT ANGLE AT LY 479.0 TO RY 780.0 FR 18 IS CORRODED BEYOND LIMITS. R & R SUPPORT ANGLE. W/C 1136.SDR IPXA10559356Floorbeam · corrodedINSPECTION TYPE:C4 WHILE WORKING CUST CARD 849615 FOUND CORROSION ON FLOORBEAM LWR SURFACE AT NUT PLATE HOLE BS 1681 LBL 19-21, WL 208. REPAIR PER ATS ER 10-2302 UPS EO B757-5310-37439-A.SDR SWAA101993Floorbeam · corrodedDURING SCHEDULED 26Y CHECK, FOUND FLOORBEAM T-CAP CORRODED AT BS 986, RBL 42. REPAIRED BEAM PER ER.SDR FDEA201004081099Floorbeam · corrodedTOP OF FLOORBEAM HAS CORROSION AT STA 377, BL 0 TO LBL 22. FLOORBEAM AT STA 377, LBL 62 TO RBL 62 FABRICATED IAW DWG 141N5123, SHEET 1, REV 1, IAW GMM 7-0-1001 REV. 110. FLOORBEAM R & R IAW SRM 51-40-02 REV 99. THIS REPAIR CLASSIFIED AS MINOR IAW GMM 6-2-SDR FDEA201004081098Floorbeam · corrodedFUSELAGE INTERIOR CABIN AFT FLOORBEAM WITH CORROSION AT UPPER CHORD SURFACE AND SURROUNDING FASTENER HOLES AREA AT BS 1640, BETWEEN RBL 24.75 AND LBL 24.75. CORRODED FLOORBEAM R & R IAW SRM 51-40-02 REV 99. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100.SDR AALA20100407TUL15Floorbeam · crackedFLOORBEAM CRACKED STATION 700 LEFT BUTTLINE 24 TO LEFT BUTTLINE 45.5. INSTALLED DOUBLER PER AARD 53-30-51-2.SDR QXEA2010040900240Floorbeam · corrodedC CHECK- COCKPIT PANEL FLOOR SUPPORT ANGLE AT FS 280 SHOWS SIGNS OF CORROSION. BLENDED CORROSION, FOUND CORROSION OUT OF LIMITS IAW SRM5300-00-001-A01 PAGE 3. LOCATED FASTENER HOLE IN NEW ANGLE IAW SRM51-40-11-001-001-A01. INSTALLED NEW A IAW SRM 51-42-21-SDR QXEA2010040900239Floorbeam · corrodedC CHECK -LT AND RT SIDE OF 280 BEAM SHOWS SIGNS OF CORROSION. BLENDED CORROSION RT 280 BEAM IAW SRM 51-11-00-001-001-A01. FOUND BEAM TO BE CRACKED. REMOVED BEAM IAW SRM 51-42-06-001-001-A01 AND 51-42-13-001-001-A01. CUT NEW 280 BEAM. PERFORMED LPI ON CUTLISDR SWAA101954Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772 AT RBL 3. REPAIRED BEAM PER EA.SDR SWAA101953Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, BETWEEN RBL 26 TO RBL 38. REPAIRED BEAM PER SRM.SDR SIMA201009801Floorbeam · corrodedDURING MAINTENANCE BASE VISIT FOUND FRAME 280 FLOORBEAM TO BE CORRODED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 280 FLOORBEAM PER EO CR-53MR-134R1. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR ASAA1047685Floorbeam · corrodedAFT CABIN FLOORBEAM AT STA 947 LBL 6 IS CORRODED. REPAIRED FLOORBEAM.SDR USAA2010041390794Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM BETWEEN FR20 TO FR21, -Y765. REPLACED FLOORBEAM BETWEEN FR20 TO FR21, -Y765 IAW A319 SRM 51-40-00.SDR USAA2010040790729Floorbeam · crackedCLT - C1 - MAJOR REPAIR - CRACK ON FLOORBEAM AT BS 700, RBL 48. REPAIRED FLOORBEAM AT BS 700, RBL 48 IAW EA 101867.SDR CALA2010040700127Floorbeam · corrodedFLOORBEAM AT STA 328 FOUND CORROSION BETWEEN RBL 20 AND RBL 31. REPAIRED IAW ECRA 5321-01724.SDR USAA2010041390788Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOOR SUPPORT BEAM BETWEEN FR16 TO FR24, -Y1292. REPLACED FLOOR SUPPORT BEAM BETWEEN FR16 TO FR24, -Y1292 IAW A319 SRM 51-42-00.SDR DALA107213250Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOORBEAM INBD UPPER SPLICE AROUND 2 FASTENER HOLES AT Y1292, FR66. REPAIRED IAW SRM 51-42-11.SDR SWAA101856Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 8. REPAIRED BEAM PER EA.SDR SWAA101855Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 3. REPAIRED BEAM PER EA.SDR IPXA10559280Floorbeam · corrodedINSPECTION TYPE:C4, FOUND CORROSION ON FLOOR SUPPORT AT BS 1020 LBL 25 TO LBL 45. R & R SUPPORT IAW SRM 51-40-02SDR USAA2010041390787Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - NR # 26C26053005/006-2 - LEVEL 2 GALVANIC CORROSION ON TOP OF FLOOR BEAM BETWEEN FR66 TO FR69, Y1292. REPLACED FLOOR BEAM BETWEEN FR66 TO FR69, Y1292 IAW A319 SRM 51-42-00 & AIRBUS DRAWING # 18D53472816.SDR USAA2010041390786Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON TOP OF FLOORBEAM BETWEEN FR66 TO FR69, Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR69, Y1292 IAW A319 SRM 51-42-00 & AIRBUS DRAWING 18D53472816.SDR USAA2010041390785Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON TOP OF FLOORBEAM BETWEEN FR66 TO FR69, Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR69, Y1292 IAW A319 SRM 51-42-00& AIRBUS DRAWING 18D53472816.SDR SWAA101853Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, BETWEEN RBL 44 TO RBL 40. REPAIRED BEAM PER EA AND SRM.SDR SWAA101847Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES AT BS 986, BETWEEN RBL 36 TO RBL 8. REMOVED AND REPLACED FLOORBEAM UPPER T-CHORD PER SRM.SDR SWAA101846Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947.5, BETWEEN RBL 6 TO LBL 12. REPAIRED BEAM PER EA.SDR USAA2010041990805Stiffener · crackedMCN - C20 - MAJOR REPAIR - CRACKS ON VERTICAL STIFFENER ON AFT SIDE OF FLOORBEAM AT BS 329, LBL 47. REPLACED VERTICAL STIFFENER ON AFT SIDE OF FLOORBEAM AT BS 329, LBL 47 IAW B737 SRM 51-40-02.SDR IPXA10559354Floorbeam · corrodedINSPECTION TYPE:C4 WHILE WORKING CUSTOMER CARD 849334, FOUND CORROSION ON UPPER AND LOWER SURFACES OF FWD FLANGE OF UPPER CHORD, 1680 FLOORBEAM AT RBL 12.75. REPAIRED PER ATS ER 10-2302 UPS EO B757-5310-37439-A.SDR SWIA201024036Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C CHECK) REPLACED FLOORBEAM PER SRM.SDR DALA107089867Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOOR SUPPORT AT BS180 RBL 22-44. REPAIRED IAW SRM 51-10-4, 51-30-5, 51-20-0.SDR IPXA10559544Floorbeam · corrodedINSPECTION TYPE:C4, CORROSION ON BS 1360 FLOORBEAM LOWER FLANGE, RBL 26.5 TO 34, WL 201. REPAIRED IAW ER NR 10-2331 IPXA EO NR: B757-5310-37537-A.SDR IPXA10559508Floorbeam · corrodedINSPECTION TYPE:C4, CORROSION ON BS 1100 FLOORBEAM FROM LBL 1 TO 22 WL 208 REPAIRED IAW ER NR10-2335.
Back to JASC 5315