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 UPS02437577Floorbeam · corrodedINSPECTION TYPE:C M/D - LBL 11 BS 2240 FLOORBEAM WEB CORRODED (NEAR LWR CHORD). FLOORBEAM WEB REPLACED AS PER SRM 51-10-01 PG 8.SDR 2002UALA00188Floorbeam · damagedAFT CAB, FLOORBEAM AT STATION 1640 BL 0, HAD EXCESSIVE MATERIAL REMOVED. MAJOR REPAIR ACCOMPLISHED. DOUBLE FLANGE REDUCED FASTENER REPAIR INSTALLED.SDR 2002UALA00187Floorbeam · damagedAFT CABIN FLOORBEAM CAP AT BODY STATION 1540, LBL 3, RBL 12, EXCESSIVE MATERIAL LOSS AFTER BLEND. MAJOR REPAIR ACCOMPLISHED. STRAP REPAIR INSTALLED.SDR F3LA200200029Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION ON TOP OF FLOORBEAM AT STA 294.5. REPLACED TOP CHORD OF FLOORBEAM AT STA 294.5, LBL 28 TO RBL 65, PER SRM 53-10-9, 51-30-2, 51-10-1, 53-10-2 AND SOPM 20-41-02.SDR SQ7A082002Web · corrodedYXD - During scheduled maintenance corrosion was found along BS1174 webs WL 208.1, RBL 23 to LBL 31 in aft cargo bay.SDR SIMA200204203Floorbeam · corrodedSAW - DURING MBV INSPECTION, MAINTENANCE FOUND CORROSION AROUND NUT PLATE HOLES ON FLOORBEAM 36. MAINTENANCE REPLACED FLOORBEAM 36 IAW ATR SRM 51-25-01 AND 51-15-03. (M)SDR UPS02437660Floorbeam · corrodedINSPECTION TYPE:C M/D - FLOOR SUPPORT FOUND CORROSION AT BS 2240 RBL 75-85 AFTER FLOOR PANEL REMOVED. FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 2.SDR SIMA200204205Floorbeam · corrodedSAW - DURING MBV INSPECTION MAINTENANCE, FOUND CORROSION AROUND NUT PLATE HOLES ON FLOORBEAM 38. MAINTENANCE REPLACED FLOORBEAM 38 IAW ATR SRM 51-25-01. (M)SDR SIMA200204204Floorbeam · corrodedMBV - DURING MBV INSPECTION MAINTENANCE, FOUND CORROSION AROUND NUT PLATE HOLES ON FLOORBEAM 40. MAINTENANCE REPLACED FLOORBEAM 40 IAW ATR SRM 51-25-01. (M)SDR AWXA200200116Tee Chord · crackedMCN - MAJOR REPAIR - "C" - DURING C-20 CHECK A 1.3" CRACK WAS FOUND ON INBOARD OF SEAT TRACK ON UPPER TEE CHORD OF LONGITUDINAL BEAM BS 727B, RBL 44, WL 208. MAINTENANCE TRIMMED OUT CRACKED AREA OF CHORD AND PERFORMED HFEC INSPECTION TO VERIFY NO CRACKS, REMOVSDR UPS02437586Floorbeam · corrodedINSPECTION TYPE:C M/D - BS 2240 RBL 75 - RBL 33 FLOORBEAM WEB FOUND CORRODED. FLOORBEAM REPLACED AS PER SRM 51-10-01 PG 8.SDR 2002UALA00169Floorbeam · corrodedTOP CAP OF FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR UPS02437628Floorbeam · corrodedINSPECTION TYPE:C AFT CARGO COMPT - RBL 31-42 BS 1660 FLOORBEAM UPPER CHORD CORRODED. FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-41-04 FIG 2.SDR 2002UALA00164Floorbeam · corrodedMAJOR BS 344-348 STRINGER 20R RBL 82-83 FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM.SDR 2002UALA00163Floorbeam · corrodedMAJOR BS 1197+88 LBL 40-45 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW T-CAP.SDR UPS02837614Floorbeam · crackedINSPECTION TYPE:C2 AFT ACCY COMPT STA 1660 FLOORBEAM WEB IS CRACKED I/B OF PREVIOUS REPAIR AT RBL 37.SDR SWAA020208Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 787 AND 847, RBL 8. REPAIRED FLOORBEAM PER SWA RA.SDR SQ7A062002Floorbeam · corrodedYXD - DURING SCHEDULED MAINTENANCE THE FLOORBEAM AT BS 1166, WL 208.1, & LBL 11 WAS FOUND CORRODED. REPAIRED PER SRM 53-10-8, FIG 8.SDR AWXA200200289Track · corrodedGYR - MAJOR REPAIR - DURING C-08 CHECK CORROSION WAS FOUND ON FLOOR SUPPORT AT BS 398, RBL 45.0. MAINTENANCE REMOVED DAMAGED SECTION OF FLOOR SUPPORT BETWEEN BS 363 AND BS 415, RBL 45, FABRICATED NEW SECTION OF FLOOR SUPPORT AND INSTALLED REPAIR IAW B757-200 SDR AWXA200200288Floorbeam · corrodedMAJOR REPAIR - DURING C-08 CHECK CORROSION WAS FOUND ON FLOORBEAM TEE CAP AT BS 345, BL 0 TO LBL 23.0. MAINTENANCE CLEANED CORROSION OFF FLOORBEAM AND FOUND MATERIAL REMAINING TO BE OUT OF LIMITS IAW B757-200 SRM 53-00-51. REMOVED DAMAGED SECTION OF FLOORBEASDR AWXA200200287Floorbeam · corrodedDURING C-08 CHECK CORROSION WAS FOUND ON TOP AND BOTTOM OF FLOORBEAM UPPER CHORD AT BS 365, BL 0 TO RBL 62.0. FABRICATED NEW SECTION OF UPPER CHORD AND INSTALLED NEW CHORD.SDR AWXA200200286Floorbeam · corrodedGYR - MAJOR REPAIR - DURING C-08 CHECK CORROSION WAS FOUND ON FLOOR SUPPORT BEAM AT BS 377, LBL 45 TO LBL 60. REMOVED DAMAGED SECTION OF FLOORBEAM, FABRICATED AND INSTALLED REPAIR IAW B757-200 SRM 53-10-51, AND SRM 51-21-1, FIG 203, PG 210.SDR UPS02437596Floorbeam · corrodedINSPECTION TYPE:C U/D - BS 340 LBL 10 - 20 FLOORBEAM SURFACE FOUND CORROSION.SDR 2002UALA00152Floorbeam · corrodedCABIN FLOORBEAM HAS CORROSION STATION 310 RBL 39 TO 41 UPPER T-CAP. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM WITH ANGLE INSTALLED ON AFT FLANGE.SDR 2002UALA00151Floorbeam · corrodedCABIN FLOORBEAM HAS CORROSION AT STATION 324 RBL 41-68. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM BY SPLICING IN T-CAP.SDR SQ7A142002Gusset · crackedYXD - During scheduled maintenance the gusset at the R/H Frame at BS 825.95 just below floor level was found cracked.SDR SQ7A112002Intercostal · crackedYXD - During scheduled maintenance the bulkhead intercostal at BS 1183, WL 265, & LBL 60 was found cracked.Replaced the intercostal per SRM 51-30-2.SDR C2XA02IA024Floorbeam · corrodedIAH- DURING C-CHECK INSPECTION IT WAS NOTED THAT HEAVE CORROSION ON THE LEFT HAND INBOARD FLOORBEAM AT FRAME 20 AT THE COMPOSITE FLOOR SUPPORT ATTACHMENT AREA. MAINTENANCE REPAIRED THE AREA, IAW EMB145 SRM 53-21-10, STEP NR 2 AND PAGE 204, FIGURE 201. THE ASDR UPS02437573Floorbeam · crackedINSPECTION TYPE:C M/D - BS 360 RBL 92 FLOORBEAM WEB CRACKED. BS 360 MOST RT O/B WEB REPAIRED AS PER SRM 53-10-07 FIG 11.SDR UPS02437572Floorbeam · corrodedINSPECTION TYPE:C M/D - BS 220 RBL 57 FLOORBEAM SURFACE CORRODED. FLOORBEAM UPPER CAP REPAIRED AS PER SRM 53-10-07 FIG 10.SDR 2002UALA00150Floorbeam · corrodedCABIN FLOORBEAM CORRODED AFT UPPER FLANGE UPPER AND LOWER SURFACES STATION 377 LBL 58. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE AND INSTALLED DOUBLER AND TRIPLER.SDR 2002UALA00148Floorbeam · corrodedBODY STATION 1197+110 LBL 40-45 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2002UALA00147Floorbeam · corrodedBODY STATION 1197+88 LBL 40-45 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR SIMA200206708Floorbeam · corrodedABI - DURING INSPECTION OF AIRCRAFT, FOUND CORROSION ON THE GALLEY CENTER FLOORBEAM AT FRAME 20. REMOVED CORROSION BY BLENDING OUT. FABRICATED AND INSTALLED A 'U' CHANNEL DOUBLER IAW EMB GST-0130A/02 ITEM 6, GST-0276/02 AND STANDARD SRM PRACTICES. (M)SDR EIA2002002Floorbeam · damagedMZJ - FOUND FLOORBEAM UPPER RETURN FLANGE AT STATION 571, RBL 25, WAS FOUND BROKEN. REMOVED DAMAGED PORTION OF FLOORBEAM AND REPAIRED PER SRM CHAPTER 51. (M)SDR SIMA200206702Floorbeam · corrodedDURING INSPECTION OF AIRCRAFT, FOUND CORROSION ON THE FORWARD DIGITAL. REMOVED CORROSION BY BLENDING OUT. FABRICATED A REPAIR DOUBLER IAW EMB GST-0149/02, ITEM 2 AND STANDARD SRM PRACTICES. (M)SDR SIMA200206707Floorbeam · corrodedABI - DURING INSPECTION OF AIRCRAFT, FOUND CORROSION ON THE GALLEY FLOORBEAM 3 INCH AFT OF FRAME 22. REMOVED CORROSION BY BLENDING OUT. FABRICATED AND INSTALLED U-CHANNEL DOUBLER IAW EMB GST-0130A/02 ITEM 6, AND STANDARD SRM PRACTICES. (M)SDR USAA020090Floorbeam · corrodedPIT - FOUND FLOORBEAM T-CAP CORRODED 50 INCHES BY 3 INCHES, FS 344 UPPER CHORD RBL 6 INCHES - LBLS 6 T-CAP. CORROSION LEVEL 1. REMOVED AND REPLACED T-CAP. (M)SDR RAIA00202063Floorbeam · corrodedMX-STL- DURING 8000 HOUR INSPECTION FOUND CORROSION ON CENTER FUSELAGE OMEGA BEAM AT FRAME 20. REPAIRED OMEGA CENTER BEAM.SDR AWXA200200114Web · crackedMCN - MAJOR REPAIR - "C" - DURING C-20 CHECK A 1/4" CRACK WAS FOUND ON FLOOR BEAM WEB BS 714, RBL 25. MAINTENANCE TRIMMED OUT DAMAGED SECTION OF FLOOR BEAM AT BS 714, RBL 25, FABRICATED A REPAIR DOUBLER AND FILLER, AND INSTALLED REPAIRS IAW AWA ER 15-5702-0203SDR AWXA200200103Web · crackedMCN - MAJOR REPAIR - "C" - DURING C-20 CHECK A CRACK WAS FOUND ON FLOOR BEAM WEB AT BS 714, RBL 25. MAINTENANCE REMOVED DAMAGED AREA OF WEB AT BS 714, RBL 25, FABRICATED REPAIR DOUBLER AND FILLER, AND INSTALLED REPAIR PARTS IAW AWA ER 15-5702-02033-GF1.SDR SIMA200206507Floorbeam · corrodedABI - DURING AN MBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON THE LEFT OMEGA BEAM AT FRAME 20. FABRICATED A DOUBLER, FILLER, PLATE, AND TWO SHIMS. WORK DONE IAW EMB 145 SRM 145/1172 REV 16, 53-21-10 AND STANDARD SRM PRACTICES. (M)SDR ASOA02046Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, FOUND CORROSION ON THE CENTER OMEGA BEAM BETWEEN FRAME STATION 5518-5533. MX REPAIRED THE CORRODED OMEGA BEAM IAW ASA EO120-53-0173. (M)SDR USAA020092Floorbeam · corrodedPIT - FOUND FLOORBEAM SURFACE CORROSION 1 INCH BY 1 INCH AREA, FS 927 AT ATTACH POINTS FOR FLOORBOARDS. CORROSION LEVEL 1, TASK NR C53-107-02. REMOVED LEVEL 1 CORROSION PER SRM 53-0-51. (M)SDR 2002UALA00130Floorbeam · corrodedCABIN FLOORBEAM STATION 365 RBL 39 CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLE AND TOP STRAP ON FLOORBEAM.SDR 2002UALA00113Floorbeam · crackedTHE BODY STATION 246 FLOORBEAM MID CHORD IS CRACKED IN -T- FLANGE RADIUS LBL 7.88. MAJOR REPAIR ACCOMPLISHED.SDR 2002UALA00071Floorbeam · crackedSTATION 246 FLOORBEAM CHORD CRACKED. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR.SDR ASOA02029Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, CORROSION WAS FOUND ON THE UPPER FLANGE OF THE FLOORBEAM AT FRAMES 39 AND 40, LEFT TO RIGHT. MAINTENANCE REPAIRED THE CORROSION IAW ASA EO 72-53-0126. (M)SDR 02FDEA00055Floorbeam · damagedFLOORBEAM HAS MECHANICAL DAMAGE, AT STA 1090 RBL 67 WL 208. R&R FLOORBEAM PER SRM 53-10-8 & 53-10-1.SDR 2002UALA00120Seat Track · corrodedMID CABIN STATION 620 INBOARD RIGHT HAND SEAT TRACK HAS EXCESSIVE MATERIAL LOSS AT FLOOR BOARD HOLE RBL 23.5. MAJOR REPAIR ACCOMPLISHEDINSTALLED REPAIR ANGLE AND STRAP.
Back to JASC 5315