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 SWAA097892Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM T-CAP CORRODED AT BS 986.5, BETWEEN RBL 52.5 TO LBL 52.5. REMOVED AND REPLACED T-CAP PER SRM.SDR AALA20091218AFW04Floorbeam · corrodedFLOORBEAM AT STATION 347 HAS CORROSION REMOVAL ON HORIZONTAL FLANGE. REPAIRED UNDER ENGINEERING AUTHORITY B767 008460.SDR AALA20091218AFW03Floorbeam · corrodedFLOORBEAM AT STATION 325 HAS CORROSION REMOVAL ON HORIZONTAL FLANGE. REPAIRED UNDER ENGINEERING AUTHORITY B767 008461.SDR AALA20091218TUL09Floorbeam · crackedFLOORBEAM AT STATION 700 IS CRACKED. REPAIRED UNDER SRM 53-00-51-2R3.SDR AALA20091218TUL10Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM AT STATION 986 LEFT BUTTLINE 28 TO LEFT BUTTLINE 30. REPAIRED UNDER SRM 51-00-51-2R.SDR UALA2009121803921Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER CHORD HAS CORROSION, BS 900, LBL 20 - LBL 40. MAJOR REPAIR ACCOMPLISHED: INSTALLED REPAIR.SDR FDEA200912184485Floorbeam · corrodedCABIN FLOORBEAM STA 365 FROM BL 0- RBL 60 UPPER TEE HAS CORROSION AROUND HOLES. REMOVED CORROSION & FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DETAIL 3. FABRICATED UPPER TEE, RECEIVED -2 AND -3 ANGLES. RECEIVED -4 AND -5 STRAPS. LOCATED, DRILLED RSDR SWIA200923326Floorbeam · crackedFS 280 FLOORBEAM CRACKED ON LEFT AND RIGHT SIDES. (C CHECK) REPLACED BEAM PER REO.SDR F3LA2009122200261Floorbeam · corrodedDURING C3 C-CHECK INSP NOTED A HOLE IN FLOORBEAM Y1292 JUST AFT OF LAVATORY D FROM FRAME 64 TO FRAME 66 AND WAS ALSO CORRODED. MX REMOVED AND REPLACED FLOORBEAM Y1292 IAW SRM 51-42-11 AND SRM 51-44-11.SDR ASOA200901426Floorbeam · corrodedFLOORBEAM AT FS 349, RBL 43 HAS CORROSION .040 DEEP.SDR SWIA200923849Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C CHECK) REPLACED BEAM PER SRM AND REO.SDR AALA20091218TUL03Floorbeam · corrodedFLOORBEAM TOP CAP CORRODED FORWARD FLANGE AT STATION 986 RBL 34. INSTALLED REPAIR PER SRM 53-00-51-2R.SDR AALA20091218TUL02Floorbeam · corrodedFLOORBEAM CAP TOP CORRODED AFT FLANGE STATION 986 RIGHT BUTTLINE 17. INSTALLED REPAIR PER SRM 53-00-51-2R.SDR USAA2009123193459Stiffener · crackedBFM - MAJOR REPAIR - C4 CHECK - CRACKED STIFFENER ON FLOORBEAM AT BS 246, RBL 20. REPLACED STIFFENER ON FLOORBEAM AT BS 246, RBL 20 IAW B767 AMM 51-21-10-07.SDR SWAA097770Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 457, STR 16L. REPAIRED BEAM PER EA.SDR UALA2009121503864Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AT STA 365. 25 BETWEEN RBL 58 TO RBL 20. MAJOR REPAIR ACCOMPLISHED: DAMAGED FLOORBEAM. REINSTALL ADJ INTERCOSTAL AND FASTENERS.SDR UALA2009121503863Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AT STA 324 FROM RBL 42 TO RBL 66, UPPER T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED: REPLACED DAMAGED FLOORBEAM. REINSTALLED ADJ INTERCOSTAL AND FASTENERS.SDR UALA2009121503862Floorbeam · corrodedAFT GALLEY AREA, FLOORBEAM UPPER T-CAP HAS EXFOLIATION CORROSION AROUND FASTENER HOLES, TOP SURFACE IN SEVERAL AREAS, BS 1640.0, BL 0 TOP RBL 60. MAJOR REPAIR ACCOMPLISHED: REPLACED DAMAGED SECTION OF FLOORBEAM. REINSTALLED ADJ INTERCOSTALS AND FASTNENERS.SDR A6WA201040058Floorbeam · crackedFS 280, FLOOR SUPPORT UPPER CAP CRACKED AT RBL 10.0 AND LBL 10.0. REPAIRED IAW REO 601R-53-11-136.SDR USAA2010010590022Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR12 TO FR24, Y765. REPLACED FLOORBEAM BETWEEN FR12 TO FR24, Y765 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53112812.SDR RYNA200912180028Floorbeam · corrodedDURING INSPECTION OF FLOORBEAMS AT STA 377 CORROSION WAS FOUND AT LBL 3.25 TO LT END OF FLOORBEAM. REVIEW OF FINDINGS FOUND DAMAGE OUTSIDE NORMAL SRM LIMITS. PERFORMED PERMANENT REPAIRS PER RYAN EO RN757-53-09 AND COTNEY AEROSPACE ENGINEERING EA EAA168-1. CSDR RYNA2009Floorbeam · corrodedDURING INSPECTION OF FLOORBEAMS AT STA 365 CORROSION WAS FOUND AT RBL 3.25 TO RBL 10.25. REVIEW OF FINDINGS FOUND DAMAGE OUTSIDE NORMAL SRM LIMITS. PERFORMED PERMANENT REPAIRS PER RYAN EO RN757-53-09 AND COTNEY AEROSPACE ENGINEERING EA EAA168-1. CUT AND REMSDR RYNA200912180026Floorbeam · corrodedDURING INSPECTION OF FLOORBEAMS AT STA 345 CORROSION WAS FOUND AT LBL 53.00 TO RBL 4.25. REVIEW OF FINDINGS FOUND DAMAGE OUTSIDE NORMAL SRM LIMITS. PERFORMED PERMANENT REPAIRS PER RYAN EO RN757-53-09 AND COTNEY AEROSPACE ENGINEERING EA EAA168-1. CUT AND REMSDR QXEA2009121401037Floorbeam · corrodedC5 CHECK - CORROSION FOUND ON LT AND RT SIDE FS 280.00 BEAM. DRILLED OUT RT AND LT 280 BEAM FASTENERS IAW SRM 51-42-06-001-001-A01. PREPARED NEW BEAM IAW REO 670-53-11-047 AND SRM 51-40-11-001-001-A01. PERFORMED LPI IAW NDTM 51-20-08. INSTALLED LT AND RT 2SDR 2010FA0000146Floorbeam · corrodedFLOORBOARD PROFILE AT FRAME AT STA X 5418 RY .479 HAS CORROSION AROUND NUTPLATE. R & R BEAM IAW SRM.SDR FDEA200912114413Floorbeam · crackedAFT PIT CROSSBEAM IS CRACKED JUST BELOW THE SEAT ADAPTER FITTING AT FRAME 60; RBL 48. REMOVED CRACKED SECTION OF CROSSBEAM IAW SRM 53-10-15, FIG 204 AND SRM 51-40-21, PARA 7. INSTALLED REPAIR PARTS IAW SRM 53-10-15, FIG 207, SHEET 18, PGS 291 / 292 AND SRM 5SDR AALA20100108TUL15Floorbeam · damagedCORROSION ON TOP OF FLOORBEAM STATION 294.5 RIGHT BUTTLINE 28-34. REMOVED CORROSION PER SRM 51-10-02. DETERMINED TO BE WITHIN MANUAL LIMITS PER AARD 53-00-00-8. REPLACED UPPER T-CAP.SDR ASOA200901451Floorbeam · corrodedCARGO BAY FLOORBEAM CAP AT LBL27 BETWEEN FS 574.00 AND FS 621.00 HAS MINOR CORROSION AROUND OTBD NUTPLATES.SDR USAA2009121593345Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 CORROSION ON MAIN CABIN FLOORBEAM T-CHORD AT BS 325, WL 200 BETWEEN RBL 23 TO RBL 54. REPAIRED MAIN CABIN FLOORBEAM T-CHORD AT BS 325, WL 200 BETWEEN RBL 23 TO RBL 54 IAW B767 SRM 53-00-51 REPAIR 1.SDR SWAA097667Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM ANGLE CRACKED AT BS 727B, RBL 45.5. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA097666Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM ANGLE CRACKED AT BS 727B, LBL 45.5. REMOVED AND REPLACED ANGLE PER SRM.SDR FDEA200912074372Floorbeam · corrodedCABIN - CORROSION ON FLOORBEAM AT STA 300, RBL 26-30. CORRODED FLOOR PANEL SUPPORT AT STA 300, RBL 26 TO RBL 30, R & R IAW SRM 51-40-02 REV 99. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100.SDR F3LA2009120800249Floorbeam · corrodedREF NON ROUTINE C075817. DURING DEN C4/S1 C-CHECK, INSP NOTED CORROSION ON THE FLOORBEAM AT -Y1292 AND FRAME 20. MX REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-42-11.SDR CALA2009120800698Floorbeam · corrodedCABIN FLOORBEAM STA 1640 RBL 6 TO LBL 6 HAS HEAVY CORROSION. CORRODED AREA WAS FOUND TO BE BEYOND ALLOWABLE LIMITS. REMOVED DAMAGED AREA ON FLOORBEAM, FABRICATED AND INSTALLED REPAIR SECTION OF UPPER CHORD AND ALL REQUIRED ATTACH PARTS PER SRM 53-00-51 REPAISDR ASOA200901346Floorbeam · crackedRT FS 621.0 FLOORBEAM CRACKED. REPAIRED RT FS621.0 FLOOR ANGLE IAW SRM.SDR ASOA200901345Floorbeam · corrodedCORROSION DAMAGE ON FLOORBEAM FS 589.0 BETWEEN LBL 9.0 AND RBL9.0 (MARKED).SDR ASOA200901344Floorbeam · crackedLEFT FS 621.0 FLOORBEAM CRACKED. REMOVED AND REPLACED REPAIR ANGLE AT LTS FS 621.0 IAW SRM 51-42-06, 51-42-20, 51-23-00 AND 51-21-16.SDR SWAA097597Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM CORRODED AT BS 772, RBL 2. REPAIRED BEAM PER EA.SDR UHLA2009120200120Floorbeam · corrodedLEVEL 2 CORROSION ON RT FLOORBEAM AT FR 88R. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-41-01 AND 51-43-01.SDR KPVA 200911Doubler · crackedPREVIOUS REPAIR DOUBLER ON FLOORBEAM P/N 85310380 CRACKED. PREVIOUS REPAIR ACCOMPLISHED ON MARCH 14, 2001. TAT 16,295.9 TCY 26,203. DONE IAW RD 8-53-1416. NEW REPAIR DOUBLER, ANGLE AND PACKER FABRICATED AND INSTALLED IAW RD 8-53-2376.SDR SWAA097584Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CRACKED AT BS 708, BBL 0.07. REPAIRED BEAM PER SI.SDR UHLA2009120100118Floorbeam · corrodedFLOORBEAM AT FRAME 17 TOP SURFACE HAS LEVEL 2 CORROSION I/B OF LEFT I/B SEAT TRACK. REPAIRED FLOORBEAM AT FR 17 IAW EMB ETD 2009-170/09795.SDR USAA2009120493302Angle · crackedBFM - C4 - MAJOR REPAIR - CRACK ON CABIN FLOORBEAM UPPER CHORD ANGLE AT BS 246, LBL 40. REPAIRED CABIN FLOORBEAM UPPER CHORD ANGLE AT BS 246, LBL 40 IAW B767 SRM 53-10-51 REPAIR 2.SDR SWAA097563Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, LBL 7. REPAIRED BEAM PER EA.SDR SWAA097561Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM CORRODED AT BS 772, RBL 13. REPAIRED BEAM PER EA.SDR A6WA201040020Floorbeam · crackedAFT ANGLE AT CROSSBEAM FS 280.00, LBL 14, WL 71, IS CRACKED. AFT ANGLE AT CROSSBEAM FS 280, LBL 5-14, WL 71, REPAIRED IAW REO 601R-53-11-138 NC.SDR FDEA200911304254Floorbeam · corrodedMAIN CARGO DECK FLOORBEAM STA 377.7 AT LBL 25 BOTH FWD AND AFT FASTNER HOLES AT LOWER SURFACE HAVE CORROSION. REMOVED CORROSION FROM UPPER TEE, MAT. REMOVED .016 FROM 0125. FOUND TEE OUT OF LIMITS IAW SRM 53-00-51 FIG 101 DETAIL 4, REMOVED PREVIOUS REPAIR SDR FDEA200911304237Floorbeam · corrodedFWD CARGO BS 690 RBL 12 TO RBL 16 FLOOR SUPPORT BRACKET CORRODED. CORRODED BRACKET AT BS 690 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911304224Floorbeam · corrodedFWD CARGO BS 740, RBL 10 TO RBL 16 FLOORBEAM ANGLE CORRODED. CORRODED SUPPORT ANGLE AT BS 740, RBL 10 TO RBL 16 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911304222Floorbeam · corrodedFWD CARGO BS 740, LBL 10 TO LBL 16 FLOORBEAM ANGLE CORRODED. CORRODED SUPPORT ANGLES ( 2 EA) AT BS 740 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.
Back to JASC 5315