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 SWIA201025026Floorbeam · corrodedFS 280 FLOORBEAM CORRODED ON RIGHT SIDE. (C-CHECK) REPLACED FS 280 FLOORBEAM PER SRM.SDR FDEA201010144076Floorbeam · corrodedCORROSION TOP TEE CAP FLOORBEAM MAIN CABIN BS 720D LBL 25 - BL 0. CUTOUT DAMAGE TEE CAP FLOORBEAM DIM: 2" X 9.2" BS 720D LBL 2.8 TO LBL 12, FABRICATED TEE CAP FLOORBEAM FROM BAC 1505-100617-7075T6 DIM: 23.125" X 2" AND UPPER CHORD, SUPPORT ANGLES AND REINFORCESDR SWAA106305Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 668.75, LBL 24.8. REPAIRED CHORD PER EO.SDR SWAA106289Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 705 TO BS 715, BBL 0. REPAIRED WEB PER ER.SDR SWAA106284Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.8. REMOVED AND REPLACED BEAM PER SRM AND BAC DWG.SDR SWAA106274Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, BETWEEN LBL 5 TO LBL 26. REPAIRED BEAM PER EA.SDR SWAA106257Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BETWEEN LBL 7 TO LBL 45.5. REPAIRED BEAM PER SRM.SDR FDEA201010134049Floorbeam · corrodedAFT CARGO RT FLOOR PANEL SUPPORT AT APPROX STA 1841 SUPPORTING FWD EDGE OF FLOOR PANEL NR 187HF FOUND CORRODED. AFT CARGO RIGHT HAND FLOOR PANEL NUMBER 187HF STA 1841 X=-34 TO X=-90 SUPPORT REPAIRED AND INSTALLED AS PER SRM 53-00-01 FIG 8 VOL I REV 96. REPAISDR FDEA201010134040Floorbeam · corrodedMAIN CARGO COMPARTMENT FLOOR BEAM UPPER CHORD HAS CORROSION ENTIRE LENGTH BS 1660 CHECKED LIMITS STA 1660 FLOORBEAM AT LBL 55. TO RBL 59 L=6.0 W = 2.0 AND D = .038, FOUND TO BE OUT OF ALLOWABLE LIMITS IAW SRM 53-00-51, FIG.101, DETAIL 3 . REMOVED AND REPSDR FDEA201010134065Floorbeam · damagedAFT CARGO COMPARTMENT, UPPER DOOR CUTOUT AT FRAME 61 RT SIDE, HAS A DOUBLE DRILLED HOLE IN THE FLOORBEAM. THE HOLE IS FOR THE INSTALLATION OF THE UPPER PROFILE. REPAIRED IAW EA 6-5310-136713; "FUSELAGE - FRAME FITTING AT FRAME 61 AND STRINGER 26".SDR DALA1026329865Floorbeam · crackedDURING M-CHECK, FOUND CRACK IN MAIN CABIN FLOORBEAM SUPPORT FITTING AT BS 775 RBL 45. REPAIRED IAW SRM 53-13-3 & DWG 9910155.SDR DALA1026439865Floorbeam · damagedDURING M-CHECK FOUND 6 ELONGATED HOLES ON RT MAIN CABIN FLOORBEAM WEB AT BS 712. REPAIRED IAW DWG 9923410, SRM 51-30-5 & SRM 51-30-2 PAGE 205.SDR FDEA201010134041Floorbeam · corrodedMAIN CARGO COMPARTMENT FLOORBEAM UPPER CHORD HAS CORROSION ENTIRE LENGTH BS 1660 CHECKED LIMITS STA 1660 FLOORBEAM AT LBL 55 TO RBL 59. L=6.0 W = 2.0 AND D =.038, FOUND TO BE OUT OF ALLOWABLE LIMITS IAW SRM 53-00-51 . R & R STA 1660 FLOORBEAM IAW SRM 51-40-SDR GTIA1000110Floorbeam · corrodedFLOORBEAM Y240 FROM FRAME 68-70 HAS CORROSION. REMOVED FLOORBEAM Y240, FRAME 68-70 IAW SRM 51-72-11. INSTALLED FLOORBEAM Y240 IAW SRM 51-72-11. PRIMED AND PAINTED ATTACH POINTS OF NEW BEAM IAW SRM 51-75-12.SDR GTIA1000107Floorbeam · corrodedFLOORBEAM AT +Y765, FRAME 67-70 HAS CORROSION. REMOVED FLOORBEAM +Y765, FRAME 67-70 IAW SRM 51-72-11. INSTALLED NEW FLOORBEAM +Y765, FRAME 67-70 IAW SRM 51-72-11. PRIMED AND PAINTED ATTACH PINTS OF NEW BEAM IAW SRM 51-75-12.SDR ASOA201001733Floorbeam · corrodedFS 349.00 BETWEEN RBL 9.00 AND RBL 18.00 FLOORBEAM HAS 1EA BROKEN AND CORRODED SCREW. R & R NUTPLATE AND SCREW IAW SRM CH 51-42-15-001-001. (CLOSED)SDR USAA2010102792413Floorbeam · corrodedBFM - S2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON LONGERON FLOOR BEAM AT FR73, Y1456. REPLACED LONGERON FLOORBEAM AT FR73, Y1456 IAW A330 SRM 51-74-00, 53-41-14, 51-44-11 & 51-42-11.SDR ASOA201001557Shim · corrodedFS 333.00, RBL 9.00, FLOORBEAM SHIM INBD AND OTBD ATTACH POINTS CORRODED. (OPEN)SDR SWAA106223Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 5. REPAIRED BEAM PER SRM.SDR SWAA106221Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM UPPER T-CAP CORRODED AT BS 987, BETWEEN RBL 6 TO LBL 5. REPAIRED BEAM PER ER AND EA.SDR SWAA106220Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM UPPER T CAP CORRODED AT BS 987, RBL 39. REPAIRED BEAM PER ER AND EA.SDR SWAA106180Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 665, LBL 24.5. REPAIRED BEAM PER EO.SDR SWAA106179Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CRACKED AT BS 672, LBL 24.5. REPAIRED BEAM PER EO.SDR SWAA106165Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM LOWER CHORD CRACKED BETWEEN BS 717 TO BS 718, BL 0. REPAIRED BEAM PER ER AND EA.SDR SWAA106159Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, LBL 11. REPAIRED BEAM PER SRM.SDR SWAA106152Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM ANGLE CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER SRM.SDR SWAA106151Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM ANGLE CRACKED AT BS 727B, LBL 24.8. REPAIRED BEAM PER SRM.SDR SWAA106150Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM ANGLE CRACKED AT BS 727B, RBL 25. REPAIRED BEAM PER SRM.SDR SWAA106149Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM ANGLE CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER ER AND EA.SDR USAA2010112392646Floorbeam · corrodedCWF - C2 - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR78, Y450. REPLACED FLOORBEAM AT FR78, Y450 IAW A330 SRM 51-42-00.SDR ASOA201001731Floorbeam · corrodedLIGHT CORROSION ON THE FLOOR SUPPORT CHANNEL WHICH IS MOUNTED TO FS 280 FRAME BETWEEN STGR 26L AND 26R. R & R FLOORBOARD SUPPORT ANGLE AT FS280 BETWEEN STGR 26L AND 26RT PN CC670-34-256-3 IAW SRM 53-11-10-991-803 AND 51-42-06-001-001-A01 AND REAPPLIED A023 FISDR FDEA201010113992Floorbeam · corrodedCORROSION TOP TEE CAP FLOORBEAM BS 950 LBL 45 - 61 REMOVED DAMAGED UPPER TEE CAP FLOORBEAM BS 950 LBL 63 - RBL 63, FABRICATED NEW FLOORBEAM TEE CAP & INSTALLED NEW CAP IAW DWG NR 65-16338, SRM 51-30-2 & SRM 51-10-2.SDR ASOA201001541Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM 9L AROUND SEAT TRACK AND FLOOR PANEL NUTPLATE HOLES AT FS 479. BLENDED CORRODED AREA. COMPLIED WITH NDT STEP 2 OF REO 670-53-31-177, NO INDICATIONS NOTED. COMPLIED WITH STEPS 3-5 OF REO 670-53-31-177.SDR SIMA201028701Floorbeam · corrodedDURING MAINTENANCE BASE VISIT FOUND THE LEFT PORTION OF FRAME 280 BEAM TO BE CORRODED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE LEFT 280 BEAM IAW CRJ 700 SRM 51-42-06 AND 51-42-21 AND AE EO CR-53MR-134R1. THE AIRCRAFT WAS RETURNED TO SDR SWAA106105Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 662, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA106104Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER EA.SDR SWAA106084Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM WEB CRACKED BETWEEN BS 986 TO BS 1016, RBL 38.5. REMOVED AND REPLACED WEB PER BAC DWG.SDR SWAA106072Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 344, BETWEEN LBL 10 TO RBL 2. REPAIRED CHORD PER SRM.SDR AALA20101011TUL08Floorbeam · corrodedCORROSION ON TOP FORWARD LEG OF STATION 986.5 FLOORBEAM AT FASTENER HOLE LEFT BUTTLINE 29.5. INSTALLED REPAIR DOUBLER AND STRAP PER SRM 53-00-51-2R 1.SDR AALA20101011TUL06Floorbeam · corrodedCORROSION ON TOP FORWARD FACE OF 986.5 FLOORBEAM AT APPROXIMATELY RIGHT BUTTLINE 29. INSTALLED REPAIR DOUBLERS AND STRAP PER SRM 53-00-51-2R 1.SDR USAA2010102892426Coupling · corrodedSAL - S5 - MAJOR REPAIR - NR 6282214 - CORROSION ON INBOARD COUPLING OF FLOORBEAM AT FR67 + 16 INCHES, -Y1162. REPLACED INBOARD COUPLING OF FLOORBEAM AT FR67 + 16 INCHES, -Y1162 IAW A320 SRM 51-72-11.SDR USAA2010102592354Floorbeam · corrodedBFM - S2 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM 5 INCHES FORWARD OF FR76, -Y1447. REPLACED FLOORBEAM IAW A330 SRM 51-74-00, 53-41-14, 51-72-11 & 51-75-12.SDR FDEA201010104035Floorbeam · corrodedCORROSION TOP "T" CAP FLOORBEAM MAIN CABIN BS 720A LBL 25 - BL 0. CUTOUT DAMAGE AREA AT TOP "T" CAP FLOORBEAM BS 720A LBL 25 TO BL 0 (ON 720A DIM 1.85" X 0.90" LBL 5.5" TO 7.35") IAW SRM 53-10-8, FIG 8, FABRICATED 2 ANGLES FROM 7075O .090 HEAT TREAT TO T6 COSDR USAA2010110392501Floorbeam · corrodedSAL - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR64 TO FR67, -Y465. REPLACED FLOORBEAM BETWEEN FR64 TO FR67, -Y465 IAW A320 SRM 51-72-11.SDR USAA2010110392500Floorbeam · corrodedSAL - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR67 + 15 INCHES TO FR69, Y1162.5. REPLACED FLOORBEAM BETWEEN FR67 + 15 INCHES TO FR69, Y1162.5 IAW A320 SRM 51-72-11.SDR USAA2010110392499Floorbeam · corrodedSAL - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 + 11 INCHES TO FR67 + 15 INCHES, Y1292. REPLACED FLOORBEAM BETWEEN FR66 + 11 INCHES TO FR67 + 15 INCHES, Y1292 IAW A320 SRM 51-72-11.SDR USAA2010110392498Floorbeam · corrodedSAL - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 + 4 INCHES TO FR67 + 17 INCHES, -Y1292. REPLACED FLOORBEAM BETWEEN FR66 + 4 INCHES TO FR67 + 17 INCHES, -Y1292 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53472000.SDR USAA2010110392497Floorbeam · corrodedSAL - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR65 + 10.5 INCHES TO FR66 + 4 INCHES, Y1292. REPLACED FLOORBEAM BETWEEN FR65 + 10.5 INCHES TO FR66 + 4 INCHES, Y1292 IAW A320 SRM 51-72-11.SDR USAA2010110392496Floorbeam · corrodedSAL - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR67 + 16 INCHES TO FR69, -Y1162. REPLACED FLOORBEAM BETWEEN FR67 + 16 INCHES TO FR69, -Y1162 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53472000.SDR USAA2010110392495Floorbeam · corrodedSAL - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR65 + 10 INCHES TO FR65 + 20 INCHES, -Y1732. REPLACED FLOORBEAM BETWEEN FR65 + 10 INCHES TO FR65 + 20 INCHES, -Y1732 IAW A320 SRM 51-72-11.
Back to JASC 5315