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 TRAX200800655Floorbeam · crackedRT SIDE FS 464 FLOOR SUPPORT INTERCOSTAL HAS A CRACKED FLANGE ON THE I/B SIDE OF RBL 36 AND A CRACKED ATTACH ANGLE ON THE O/B SIDE OF RBL 27. DISCONNECTED MOUNT BOLTS ON CABLE GUIDE IAW 51-41-04. REPAIRED RT SIDE FS 484 INTERCOSTAL I/B OF RBL 36 AND O/B SIDESDR UIEA200800214Floorbeam · crackedMAIN DECK FLOORBEAM WEB FOUND CRACKED AT STA 1200 LBL 120. MAIN DECK FLOOR WEB CRACKED AREA REPAIRED PER EO 4753B154.SDR UIEA200800213Floorbeam · crackedMAIN DECK FLOORBEAM WEB FOUND CRACKED AT STA 1180 LBL 120. MAIN DECK FLOOR WEB CRACKED AREA REPAIRED PER EO 4753B153.SDR UIEA200800211Floorbeam · crackedMAIN DECK FLOORBEAM WEB FOUND CRACKED AT STA 1180 RBL 123. MAIN DECK FLOOR WEB CRACKED AREA REPAIRED PER EO 4753B153.SDR SWAA082719Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 15. REPAIRED FLOORBEAM PER SRM.SDR USAA920081126Support · crackedCLT - MAJOR REPAIR - Q6 CHECK - CRACKED FLOORBEAM SUPPORT, BS 540, BL 0 - RBL 24. REPLACED CRACKED FLOORBEAM SUPPORT, BS 540, BL 0 - RBL 24 IAW BOEING SRM 51-10-20 & 51-00-00.SDR 08FDEA01872Floorbeam · crackedMAIN CABIN FLOORBEAM AT FR 32 HAS .250 IN CRACK BETWEEN SEAT TRACKS NR 4 LT AND NR 5 LT REMOVED CRACK AND INSTALLED FLOORBEAM REPAIR ON FLOORBEAM FR 32, BETWEEN SEAT TRACKS NR 4 LT AND NR 5 LT IAW A300-600 SRM 53-10-15, FIG 212.SDR 08FDEA01871Floorbeam · crackedMAIN CABIN FLOORBEAM AT FR 31 HAS .250 IN CRACK, BETWEEN SEAT TRACKS NR 4 LT AND NR 5 LT REMOVED CRACK AND INSTALLED FLOORBEAM REPAIR ON FLOORBEAM FR 31, BETWEEN SEAT TRACKS NR 4 LT AND NR 5 LT IAW A300-600 SRM 53-10-15, FIG 212.SDR DL76L080825Floorbeam · corrodedCORROSION ON FLOORBEAM BS 720 RBL 26 UPPER CHORD. REPAIRED FLOORBEAM PER SRM 53-00-01 FIG 201.SDR USAA920081139Floorbeam · crackedCLT - MAJOR REPAIR - Q6 CHECK - NR O3C10753638/1, CRACKED FLOORBEAM SUPPORT STRUCTURE, BS 540, BL 0 - LBL 24. REPAIRED CRACKED FLOORBEAM SUPPORT STRUCTURE, BS 540, BL 0 - LBL 24 IAW BOEING SRM 51-10-20 AND 51-00-00.SDR 2008UALA02812Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM 205. MAJOR REPAIR ACCOMPLISHED: REPLACED BEAM.SDR 2008UALA02811Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM 200. MAJOR REPAIR ACCOMPLISHED: REPLACED BEAM.SDR 2008UALA02838Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM ITEM 235. MAJOR REPAIR ACCOMPLISHED, REPLACED FLOORBEAM 235.SDR 2008UALA02814Floorbeam · corrodedFOUND CORROSION ON FLOOR BEAM NR 215.
SDR 08FDEA01867Floorbeam · corrodedBS 1148 FLOORBEAM UPPER T-CAP, AFT FLANGE LWR SURFACE IS CORRODED, RBL 43 BLENDED CORROSION, ROTO- PEENED BLENDED AREA, ALODINED AND PRIMED AND APPLIED BMS 3-23, REF EA 7-5310-118266. ORIGINAL THICKNESS OF .130 INCH, .109 INCH REMAINING AT DEEPEST AREA. THISDR 2008UALA02798Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM NR 165. MAJOR REPAIR ACCOMPLISHED: REPLACED BEAM.SDR 2008UALA02797Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM NR 250.
SDR 2008UALA02793Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM NR 255.SDR 08FDEA01853Floorbeam · corrodedMAIN DECK CARGO FLOORBEAM FR 60 BETWEEN SEAT TRACKS NR 2 RT AND NR 3 RT HAS CORROSION ON CLS ADAPTER REMOVED LEVEL 1 CORROSION, REPAIRED BENT FLOORBEAM AND REPLACED CLS ADAPTER AT FR 60 BETWEEN SEAT TRACK NR 2 RT AND NR 3 RT IAW A300-600 SRM 53-10-15, FIG 205.SDR TRAX200800634Floorbeam · crackedAFT FLOOR SUPPORT ANGLE CRACKED AT STA 280 BULKHEAD LBL9. JOB COMPLETE, REPAIRED AFT FLOOR SUPPORT ANGLE AT STA 280 BULKHEAD LBL 9 IAW REO 601R-53-11-138.SDR TRAX200800633Floorbeam · crackedLT OTBD FLOORBEAM ANGLE CRACKED AT STA 280 BULKHEAD. REMOVED LT OTBD FLOORBEAM ANGLE AT STA 280 ALL WORK DONE IAW SRM 51-42-21. INSTALLED LT OTBD FLOORBEAM ANGLE AT STA 280 ALL WORK DONE IAW SRM 51-42-21.SDR TRAX200800627Floorbeam · corroded280 SUPPORT BEAM CORRODED. REMOVED AND REPLACED STA 280 SUPPORT BEAM PN CC670-34175-7 AS PER SRM 51-42-21, 51-42-06. REO 670-53-11-047, AND SB 670BA-53-026.SDR USAA920081195Floorbeam · corrodedCLT - MAJOR REPAIR - Q6 CHECK - LEVEL 2 CORROSION ON CABIN FLOORBEAM, BS 312, LBL 62 - RBL 24. REPAIRED CABIN FLOORBEAM, BS 312, LBL 62 - RBL 24 IAW B737 SRM 53-10-51, FIGURE 201. (S)SDR 2008UALA02776Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED STA 324, RBL 40 TO RBL 54. ACCOMPLISHED MAJOR REPAIR AT GSO. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW MM 53-00-98 RPR XXV FIG 824.SDR CALA0800453Floorbeam · corrodedFLOORBEAM 986.5 LBL 43 HAS CORROSION. BURNISHED CORROSION AND INSTALLED STRAP REPAIR PER SRM 53-00-51, FIG 201.SDR USAA920081105Floorbeam · corrodedMIA - MAJOR REPAIR - C4 CHECK - CORROSION ON CABIN FLOORBEAM, BS 1518, LBL 6 - RBL 6. REPAIRED CABIN FLOORBEAM, BS 1518, LBL 6 - RBL 6 IAW B767 SRM 53-00-51 REPAIR 1.SDR LR7A08056Floorbeam · corrodedDURING SCHEDULED C-8 CHECK, FOUND COCKPIT FLOORBEAM EXFOLIATION CORROSION AT FS 196, WL196, RBL30. REPAIR ACCOMPLISHED BY FABRICATING AND REPLACING SPLICE CAP IAW SMP583 FIG 51-60 AND 51-70 AND DWG 393863-1.SDR LR7A08055Floorbeam · corrodedDURING SCHEDULED C-8 CHECK, FOUND COCKPIT FLOORBEAM EXFOLIATION CORROSION AT FS 196-216, WL196, LBL30. REPAIR ACCOMPLISHED BY CUTTING OUT CORROSION AREA AND SPLICED IAW SMP583 FIG 51-140-22.SDR UIEA200800191Floorbeam · crackedFWD CARGO STA 640 LBL 20 FLOORBEAM UPPER CHORD FOUND CRACKED. FWD CARGO STA 640 LBL 20 FLOORBEAM UPPER CHORD CRACKED AREA REPAIRED AS PER SRM 51-40-04.SDR SWAA082625Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CHORD CORRODED AT BS 344, LBL 29 TO RBL 2. REMOVED AND REPLACED CHORD PER SRM.SDR 08FDEA01837Floorbeam · crackedMAIN DECK FLOOR FR 67 BETWEEN SEAT TRACKS NR 4 LT AND NR 5 LT HAS .125 IN CRACK REMOVED CRACK ON FR 67 AFT FACE STIFFENER BETWEEN SEAT TRACKS NR 4 LT AND NR 5LT AND INSTALLED CROSSBEAM REPAIR IAW A300-600 SRM 53-10-15, FIG 212.SDR DU4R2008205Floorbeam · corrodedS/O 245007 OPS NR 25025 - CORROSION BS 328 BL 10R FLOOR SUPPORT BEAM.SDR DU4R2008204Floorbeam · corrodedS/O 245007 OPS NR25007, CORROSION ON UPPER SURFACE OF CABIN STRUCTURE BS 986.5 LBL 32 TO RBL 32 ON UPPER SURFACE OF TEE CAP, NUMEROUS AREAS AROUND FLOORBOARD ATTACH HOLES (AFT MAIN CABIN WET AREA).SDR SWAA082580Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CHORD CORRODED AT BS 986.5, RBL 48 TO LBL 48. REPAIRED CHORD PER SWA EA.SDR TRAX200800620Floorbeam · crackedFS 280 FLOOR SUPPORT STRUCTURE IS CRACKED O/B OF LBL 9 AT MLG MANUAL RELEASE PULLEY BRACKET. CUT AWAY CRACKED SECTION OF FLOOR ANGLE IAW REO 601R-53-11-138. COMPLIED WITH REO 601R-53-11-138. PERFORMED LPI OF FS 280 ANGLE LBL 9 REPAIR IAW NDTM 51-20-08. NO INSDR TRAX200800619Floorbeam · crackedFS 280 CLIP ON I/B SIDE OF RBL 9 IS CRACKED. REMOVED DAMAGED/CRACKED CLIP. INSTALLED NEW CLIP P/N 601R31113-58 IAW SRM 51-42-21.SDR UIEA200800197Floorbeam · crackedCOCKPIT STA 330 RBL 65 FLOORBEAM UPPER CHORD CRACKED. REPAIRED FLOORBEAM CHORD AS PER SRM 51-40-04 FIG 2.SDR DU4R2008203Floorbeam · corrodedS/O 312001 N/R 28019, CORROSION AT CABIN FLOORBEAM UPPER CHORD UPPER SURFACE BS 360 LBL 15 TO RBL 15 W/L 201.SDR AALA200801310Floorbeam · corrodedAFT CARGO FLOOR BEAM J CHANNEL INNER CHORD AT STATION 1285 HAS CORROSION REMOVAL ON UPPER HORIZONTAL FLANGE. MATERIAL REMAINING IS BEYOND SRM LIMITS. REPAIRED IN ACCORDANCE WITH MRD 767 3196. CHORD SHOULD BE REPLACED BY THE NEXT C CHECK FOLLOWING 05 09 2008SDR A6WA200840408Floorbeam · crackedRT FS 280 RBL 8 & 10 ANGLE ON BEAM FOUND CRACKED. RT FS 280 RBL 8 & 10 ANGLE ON BEAM REPLACED IAW SRM 51-42-21.SDR UIEA200800199Floorbeam · corrodedMAIN DECK STA 980 RBL 45 TO RBL 55 FLOORBEAM UPPER CHORD FOUND WITH LEVEL 1 CORROSION. CORROSION REMOVED PER SRM 53-10-01, 51-10-01, 51-10-02.SDR ASAA0843135Floorbeam · corrodedFLOORBEAM UPPER FLANGE IS CORRODED. REPLACED BEAM PER EA 5310 02800.SDR CALA0800428Floorbeam · corrodedCABIN - BS 303 LBL 32 - 55 FLOOR SUPPORT FOUND CORRODED. BS 303 LBL 9 - 65 FLOORBEAM UPPER FLANGE REPAIRED PER SRM 53-00-51, REPAIR FIG 201.SDR SWIA200819804Floorbeam · crackedFS 280 COCKPIT FLOOR SUPPORT IS CRACKED AT LBL 9. (FOUND AT C-CHECK) REPLACED COCKPIT FLOOR SUPPORT IAW SB 670BA-53-026 & SRM 51-42-06-001-001-A01 & 51-23-00-001-001-A01.
SDR SWIA200819803Floorbeam · crackedFS 280 FLOORBEAM AT LBL 10 IS CRACKED. (FOUND AT C-CHECK) REPLACED FLOORBEAM IAW SRM 51-42-06-001-001-A01 AND SB 670BA-53-026 REV B, AND SB670-53-11-047, REV D.
SDR ASAA0843121Floorbeam · corrodedFLOORBEAM UPPER FLANGE IS CORRODED. REPAIRED PER EA 5310 02800.SDR ASAA0843113Floorbeam · corrodedFLOORBEAM UPPER FLANGE CORRODED. REPLACED BEAM PER EA 5310 02800.SDR DHL2008807531Floorbeam · damagedMAIN CARGO COMPT FLOORBEAM HAS A MISDRILLED HOLE, STA 980.000 RBL 32 1/4 INCHES (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 045-29-08, EVA D853-00070 REV IR DATED 05-01-08, DWG AF56-53-101 REV IR DATED 04-28-08. REMOVED FASTENERS IAW SRMSDR USAA920081050Floorbeam · corrodedSAL - MAJOR REPAIR - C4 CHECK - CORROSION ON CABIN FLOORBEAM BS 3158 / FR 65, +Y920. REPLACED CABIN BEAM, BS 3101 / FR 65 - BS 3207 / FR 67, +Y920 IAW A320 SRM 51-72-11.SDR 08FDEA01777Floorbeam · corrodedCROSSBEAM AT FRAME 52 BETWEEN RBL 20 - RBL 40 IS CORRODED. REMOVED AND REPLACED THE CROSSBEAM IAW A300 SRM 51-40-21, PARA 5.
Back to JASC 5315