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 FDEA200910083510Floorbeam · corrodedSTA 740 RBL 60 UPPER CAP CORRODED (FLOORBEAM ). AT BS 740 B/T RBL 30 TO RBL 63 , FLOORBEAM REPAIR WAS ACCOMPLISHED DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION ON MAE. W/C 118350441BZR03, AND MAE EA NR 757-5335-16-F2280 REV B DATED 09/11/2009, NON-ROUTINE ISDR IPXA09557744Floorbeam · corrodedINSPECTION TYPE:C2 FLOORBEAM CORRODED OUT OF LIMITS BS 1200, LBL45 TO LBL 65. REPAIRED PER ATS EO NR 09-4920.SDR A6WA200940688Floorbeam · crackedFLOORBEAM FITTING CRACKED AT FS 461.5, RBL 9.0, OTBD SIDE FLOORBEAM FITTING AT FS 461.5, RBL 9.0 OTBD SIDE REPLACED IAW SRM 51-42-06 AND SRM 51-42-21. (K)SDR SWAA096391Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709, LBL 25. REPAIRED WEB PER ER.SDR SWAA096365AFloorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709, LBL 25. REPAIRED WEB PER ER.SDR IPXA09557743Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION ON FLOORBEAM BS 1100, LBL 55 TO RBL 55. REPAIRED PER ATS EO NR 09-4921.SDR IPXA09557742Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION ON FLOORBEAM BS 1200, RBL55 TO LBL 55. REPAIRED PER ATS EO 09-4920.SDR IPXA09657613Stiffener · crackedINSPECTION TYPE:C MEC COMPT STA 246 FLOORBEAM STIFFENER FOUND CRACK AT LBL 50, CRACK .375 INCH LENGTH. MEC COMPT STA 246 FLOORBEAM AT LBL 50 STIFFENER REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 45.SDR IPXA09657611Stiffener · crackedINSPECTION TYPE:C MEC COMPT STA 246 FLOORBEAM STIFFENER FOUND CRACK AT LBL 25, CRACK .5 INCH LENGTH. MEC COMPT STA 246 FLOORBEAM AT LBL 25 STIFFENER REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 45.SDR AALA20091008TUL04Support · crackedFLOORBEAM SUPPORT IS CRACKED AT LOWER OUTBOARD SIDE OF STATION 927 BELOW SEAT TRACK NUMBER TWO. INSTALLED FLOORBEAM SUPPORT AT STATION 927 BELOW SEAT TRACK NUMBER TWO.SDR TIPR20090024Floorbeam · corrodedFS 947.50 FLOORBEAM UPPER TEE RBL 70.53 TO LBL 70.53. REPAIRED IAW REO-G12924 REV B DATE 09/23/2009.SDR FDEA200910023459Floorbeam · crackedCTR CARGO COMPT, STA 1701 X= 34, Z=-100, FLOORBEAM LWR FLANGE WITH 1EA CRACK 3" LONG AND 1EA CRACK 1" LONG. REPAIRED AREA IAW SRM 53-60-01 FIG 3 VOL I.SDR FDEA200910023458Floorbeam · crackedCTR CARGO COMP STA 1701, X=-34, Z=-100, LWR FLOORBEAM FLANGE WITH 1EA CRACK 7,5 " LONG REPAIRED AREA IAW SRM 53-60-01 FIG 3, VOL I.SDR SWAA096296Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER EA.SDR SWAA096275Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 665.5, LBL 24.5. REPAIRED BEAM PER AEM.SDR CALA2009100500586Floorbeam · gougedGOUGE IN FLOORBEAM AT STA 328 APPROX RBL 31 (MARKED). INSTALLED REPAIR AT FLOORBEAM STA 328 RBL 31 PER EC/RA 5310-05023.SDR USAA2009092892637Floorbeam · corrodedCLT - Q5 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT BS 988 BETWEEN RBL 42 TO LBL 42. REPLACED FLOORBEAM AT BS 988 BETWEEN RBL 42 TO LBL 42 IAW TYPICAL REPAIR 53-60-01 REV A.SDR SWAA096211Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 312, RBL 24. REPAIRED BEAM PER SRM.SDR SWAA096210Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 294.5, LBL 50. REPAIRED BEAM PER SRM.SDR SWAA096202Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM WEB LOWER CHORD CRACKED AT BS 663, RBL 24.5. REPAIRED CHORD PER AEM.SDR SWAA096185Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO PIT FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED BEAM PER EA.SDR SWAA096188Floorbeam · crackedDURING SCHEDULED MV2 CHECK, FOUND FLOORBEAM T-CAP CRACKED AT BS 312. REMOVED AND REPLACED T-CAP PER SRM.SDR SWAA096167Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO PIT FLOORBEAM CORRODED AT BS 772, RBL 14. REPAIRED BEAM PER AAR EA.SDR FDEA200909293424Floorbeam · corrodedMAIN DECK FLOOR SUPPORT BEAM CORRODED ON LWR SURFACE STA 1681.9, RBL 16, WL 208.10. REPAIR ON SUPPORT BEAM AT STA 1681.9 CARRIED OUT IAW EA F-5310-133424 (BLEND OUT REPAIR ON FLOORBEAM UPPER CHORD AT BS 1681 BL 16). REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-SDR SWAA096142Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 713, LBL 24.5. REPAIRED WEB PER AAR EA.SDR SWAA096137Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 706 TO BS 712, BBL .070. REPAIRED BEAM PER SRM.SDR SWAA096134Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CORRODED AT BS 734C, LBL 8. REPAIRED BEAM PER EA.SDR SWAA096133Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CORRODED AT BS 732D, LBL 8. REPAIRED BEAM PER EA.SDR SWAA096132Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CORRODED AT BS 732D, RBL 8. REPAIRED BEAM PER EA.SDR SWAA096130Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO BAY FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED BEAM PER AAR EA.SDR FDEA200909283402Floorbeam · corrodedCABIN: STA 1680, RBL 52.5 INCHES, FLOORBEAM UPPER TEE HAS CORROSION AT BOTTOM SURFACE. REPAIR CARRIED OUT IAW EA NR F-5310-131056. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR SWIA200923214Floorbeam · crackedFS280 FLOORBEAM TOP SURFACE CRACKED. (C CHECK)REPLACED BEAM PER REO.SDR SWAA096083Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND LONGITUDINAL FLOORBEAM CENTER WEB CRACKED BETWEEN BS 708 TO BS 712, LBL 0.07. REMOVED AND REPLACED WEB SECTION PER SI.SDR F3LA2009100100186Floorbeam · corrodedDURING C6 C-CHECK, INSP NOTED CORRODED FASTENER HOLES AT STATION -Y1292 AND FRAME 66. MX REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-42-11 AND 51-44-11.SDR SWAA096166Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO PIT FLOORBEAM CORRODED AT BS 772, LBL 12. REPAIRED BEAM PER SRM.SDR GTIA0900024Floorbeam · corrodedFLOORBEAM CORRODED AT FR69 AT Y254. REMOVED AND REPLACED FLOORBEAM.SDR ASOA200901051Floorbeam · corrodedFLOORBEAM STRUCTURE AT FS621.0 AND BETWEEN LBL9.00 AND LBL 27.00 HAS CORROSION IN AREA OF NUTPLATES. BLENDED CORRODED AREA IAW SRM 51-12-00. DAMAGED AREA WAS FOUND TO BE .007 DEEP WITHIN ALLOWABLE DAMAGED LIMITS IAW SRM 53-61-43 AND 53-00-00 RESTORED FINISH ANSDR AALA20090925AFW02Floorbeam · damagedIMPACT DAMAGE TO FLOORBEAM UPPER WEB AT STATION 246 LEFT BUTTLINE 9 TO LEFT BUTTLINE 13. REINFORCED FLOORBEAM UNDER ENGINEERING AUTHORITY 007533.SDR CALA2009092500567Floorbeam · corrodedCABIN FLOORBEAM AT STA 986.5, LBL 4.0 HAS CORROSION. REPAIRED CABIN FLOORBEAM REF SRM 53-00-51.SDR A6WA200940643Floorbeam · crackedINBD FLOORBEAM ANGLE AT FS 280.00, RBL 8, WL 72 IS CRACKED. INBD CLIP AT FS 280.00, RBL 8, WL 72 IS REPLACED IAW SRM 51-47-21. (K)SDR USAA2009102692879Floorbeam · corrodedCLT - Q5 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 312, LBL 1. REPAIRED FLOORBEAM T-CAP AT BS 312, LBL 1 IAW B737 SRM 53-10-10-51 REPAIR 6.SDR F3LA2009100100191Floorbeam · corrodedDURING C6 C-CHECK, INSP NOTED THE COUPLING ATTCH POINT AT L2, STATION Y1292 AND FRAME 68 HAS CORROSION. MX REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-42-11 AND DWG SD53472815 AND D53472780.SDR F3LA2009100100190Floorbeam · corrodedDURING C6 C-CHECK, INSP NOTED CORROSION AROUND THE NUT PLATES AT L2, STATION Y1292 BETWEEN FRAME 66 AND FRAME 68. MX REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-42-11 AND DWG SD53472815.SDR F3LA2009100100185Floorbeam · corrodedDURING C6 C-CHECK, INSP NOTED THE COUPLING ATTACH POINT AT STATION Y1292 AND FRAME 68 HAS CORROSION. MX REMOVED AND REPLACED THE FLOORBEAM IAW SRM 53-41-14, 51-42-11 AND 51-44-11.SDR ASOA200901038Floorbeam · corrodedLT FS280 FLOORBEAM HAS CORROSION AROUND NUTPLATE LOCATION AT APPROX LBL15.SDR ASAA0976686Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER SURFACE. REPAIRED FLOORBEAM.SDR A6WA200940646Floorbeam · crackedCRACK FOUND ON MACHINED FLOORBEAM FITTING AT FS 461.00, RBL 9.00 OTBD SIDE CRACK LENGTH IS .650" AT FS 461.00, RBL 9.00 OTBD SIDE, MACHINED FLOORBEAM FITTING REPLACED IAW SRM 51-42-21. (K)SDR ASAA0976677Floorbeam · corrodedBS 344 CORROSION ON FLOORBEAM. REMOVED DAMAGE FROM FLOORBEAM, FABRICATED REPAIR PARTS AND INSTALLED.SDR UALA2009092303001Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER CHORD HAS CORROSION AT BS 520 RBL 3 - RBL 4. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE, INSTALLED REPAIR.SDR FDEA200909233372Floorbeam · corrodedFWD CABIN, FLOORBEAM (BULKHEAD) AT BS 324, RBL 26-RBL 60, UPPER SURFACE HAS SEVERAL AREAS OF CORROSION. REMOVED CORROSION IAW SRM 51-10-02. ORIGINAL MATERIAL THICKNESS .125, AFTER REWORK .106 INCH, REMOVED .019 INCH; L=2 INCHES, W=2 INCHES, D=.019 INCH, FOUN
Back to JASC 5315