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 SWIA200717966Floorbeam · crackedCRACK AT LOWER FLOORBEAM ST280 RBL10. (DISCOVERED DURING C-CHECK INSPECTION) INSTALLED REPAIR ANGLE, FILLER & NEW CLIP AT STA 280, RBL10.0 IAW CRJ200 REO 601R-53-11-171 REV C REPAIR SCHEME A.SDR SWIA200717965Floorbeam · crackedCRACK AT LOWER FLOORBEAM ST280 LT BL10. (DISCOVERED DURING C-CHECK INSPECTION) INSTALLED REPAIR ANGLE, CLIPS AND FILLERS AT STA 280, LBL10.0 IAW CRJ200 REO 601R-53-11-171, REV C, REPAIR SCHEME A.SDR 2007UALA00360Floorbeam · corrodedAFT CABIN FLOORBEAM AT BS 947.5 CAP CORRODED LBL 21 - RBL 7. MAJOR REPAIR. REMOVED DAMAGE. FABRICATED AND INSTALLED T-CAP, SPLICE ANGLE STRAPS AND CLIPS PER MM 53-10-95 REPAIR XIX PAGE 803 AND 817.SDR SWAA070679Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 19 TO RBL 57. REPAIRED FLOORBEAM PER SWA EA.SDR 2007UALA00346Floorbeam · corrodedAFT CABIN FLOORBEAM UPPER CHORD CORRODED AROUND FASTENER HOLE BS 1006 LBL 10, WL 208. MAJOR REPAIR, REMOVED DAMAGE. ACCOMPLISHED NESTED ANGLE AND FILLER REPAIR PER MM 53-10-95.SDR SWAA070649Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, RBL 30 TO RBL 35. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA070659Web · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 339 TO BS 353, LBL 60. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR CALA0700055Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 50 TO RBL 50. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01443.SDR 2007UALA00329Strap · crackedLEFT NOSE TUNNEL BS 365, LBL 24, CABIN FLOORBEAM STRAP CRACKED 2 PLACES, JUST FWD OF PRIOR REPAIR. FABRICATED AND INSTALLED REPAIR DOUBLER-STRAP USING UA SPECIFICATION AND BACO DWG.SDR SWAA070613Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 39. REPAIRED FLOORBEAM PER SRM.SDR 07FDEA00337Floorbeam · corrodedFLT DECK FLOORBEAM AT BS 277 HAS SEVERAL AREAS OF CORROSION ON UPPER SURFACE BETWEEN RBL 13 AND LBL 13. REMOVED CORROSION REF SRM 51-10-1 PG 5, MAT LOSS =.007'' HFEC, ROTO PEENED, TREATED, PRIMED, REF EA NR 7-5310-107610 AND AAR EA NR I070063.SDR 07FDEA00336Floorbeam · gougedFLT DECK FLOORBEAM AT BS 277 UPPER SURFACE OF UPPER CHORD GOUGED AT LBL 14.5 BLEND DAMAGE, ORIGINAL THICKNESS .090'' AMOUNT REMAINING 0.075'' HFEC IAW EA# I070063, ROTO PEENED, TREATED, PRIMED, REF FED EX EA NR 7-5310-107610.SDR SWIA200717952Floorbeam · crackedFS 280 BEAM HAS CRACK AT RT BL9, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED DOUBLER, FILLER AND CLIP PER REO 601R-53-11-171 REV (C).SDR WRLA2007Floorbeam · corrodedDURING 2C+12A+150M CHECK, EGAT MECHANIC FOUND M/D CARGO FLOORBEAM CORRODED AT STA Y=1321,X= -8 TO -25 AREA. FABRICATED THE NEW PARTS IAW E1 NR W2007P53B-056 REV. 00 AND APPROVED DOCUMENT MFG CONTROL NR PO209366. INSTALLED THE NEW FABRICATED PARTS IAW MD-11F SSDR AWXA200700141Floorbeam · corrodedSAL - CORROSION ON MAIN CABIN FLOORBEAM, +Y1292, FR65+19". REPLACED MAIN CABIN FLOORBEAM, +Y1292, FR 64 - FR 66 IAW A319 SRM 51-72-11.SDR 07FDEA00298Floorbeam · corrodedFOUND MAIN DECK FLOORBEAM UPPER FLANGE IS CORRODED BS 620 LBL 4-20, WL 208. INSTALLED REPAIR ON MAIN DECK FLOORBEAM UPPER CHORD AT STA 620, LBL 4 THRU 20, WL 208 REF B727 SRM 53-10-8 PG 18-23 AND DWG 53FX1547. CLASSIFIED AS A MAJOR REPAIR.SDR AWXA200700248Strap · crackedMCN - FOUND CRACKED FLOORBEAM STABILIZER STRAP, BS 312, LBL 8. REPAIRED FLOORBEAM STABILIZER STRAP, BS 312, LBL 8 IAW B737-300 SRM 53-10-51-2R4.SDR AWXA200700247Strap · crackedMCN - FOUND CRACKED FLOORBEAM STABILIZER STRAP, BS 312, RBL 4. REPAIRED FLOORBEAM STABILIZER STRAP, BS 312, RBL 4 IAW B737-300 SRM 53-10-51-2R4.SDR AWXA200700219Strap · crackedMCN - FOUND FLOORBEAM SUPPORT STRAP CRACKED, BS 312, RBL 34L, WL 200. REPAIRED FLOORBEAM SUPPORT STRAP CRACKED, BS 312, RBL 34L, WL 200 IAW B737-300 SRM 53-10-51.SDR DHL2007802533Floorbeam · crackedAFT ACCY COMPT FLOORBEAM SHOWS CRACK 5" AT STA 1700.000 BL 0 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 01-30-07, DWG NR AC62-53-102, REV IR DATE 01-15-07. REMOVED FASTENERS IAW SRM 51-1-21, SRM 51-3-0. CUT OUT DAMAGED SECTION IAW DWG SDR AWXA200700188Stiffener · crackedMCN - FOUND CRACKED FLOORBEAM STIFFENER, BS 328, LBL 51, WL 208. REPLACED FLOORBEAM STIFFENER, BS 328, LBL 51, WL 208 IAW B737-300 SRM 51-40-02.SDR KCSA071060Vertical Support · corrodedAFT BILGE FLOORBEAM VERTICAL SUPPORT IS CORRODED AT STA 1920, LBL 63.SDR AWXA200700315Stiffener · crackedMCN - FOUND CRACKED CABIN FLOORBEAM VERTICLE STIFFENER ANGLE, BS 1006, LBL 39, WL 208. REPLACED CABIN FLOORBEAM VERTICLE STIFFENER ANGLE, BS 1006, LBL 39, WL 208 IAW B737-300 SRM 51-40-02.SDR SWAA070549Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, LBL 26 TO LBL 54. REPAIRED FLOORBEAM PER SRM.SDR SIMA200703309Floorbeam · corrodedFOUND UPPER FLOORBEAM AT FRAME 22 BETWEEN SERVICE DOOR AFT SILL AND CENTER HAT BEAM CORRODED. REMOVED AND REPLACED FLOORBEAM IAW EMB SRM 51-40-02. RETURNED AIRCRAFT TO SERVICE.SDR UPS07M49511Floorbeam · corrodedINSPECTION TYPE:C FWD CARGO COMPT ALONG STA 6-0, FROM LBL 0 TO LBL 27, FLOORBEAM SUPPORT CORRODED. CORROSION FLOORBEAM SUPPORT REMOVED PER SRM 51-3501 V2 R38. NEW FLOORBEAM SUPPORT & FASTENERS HOLE PICKED UP PER SRM 51-31-01 V2 R38. NEW SUPPORT REPROTECTED SDR SWIA200717941Floorbeam · crackedFS 280 LBL9-13 CRACKS BOTH FLOORBEAM SUPPORT ATTACH CLIPS AND 280 BEAM UPPER AND LOWER, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS AT FS280 LBL9-13 UPPER/LOWER BEAM REPAIR PER REO 601R 53-11-138 AND REO 601R 53-11-171.SDR TRAX200700145Floorbeam · corrodedFWD FLOOR SUPPORT ANGLE AT STA BETWEEN LBL 9 AND RBL 9 HAS SURFACE CORROSION.SDR UIEA200700050Floorbeam · crackedM/DECK STA 260 RBL90 FLOORBEAM UPPER CHORD FOUND CRACKED. REPAIRED ACCOMPLISHEED AS PER BOEING SR ID NR 1-273725179 AND FAA FORM 8100-9.SDR UIEA200700052Floorbeam · crackedBS 400 RT UPPER DECK FLOORBEAM UPPER CHORD FOUND HOLES AND CRACKED. REPAIRED ACCOMPLISHED AS PER BOEING SR ID NR 1-271227292 AND FAA FORM 8100-9.SDR SWAA070488Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 43. REPAIRED FLOORBEAM PER SRM.SDR SWAA070495Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 45 TO LBL 27. REPAIRED FLOORBEAM PER SRM.SDR SWAA070519Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, RBL 28 TO RBL 42. REPAIRED FLOORBEAM PER SRM.SDR SWAA070487Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, RBL 5. REPAIRED FLOORBEAM PER SRM.SDR SWAA070489Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, LBL 5 AND LBL 11. REPAIRED FLOORBEAM PER SRM.SDR SWAA070490Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 927, LBL 5 AND LBL 11. REPAIRED FLOORBEAM PER SRM.SDR SWAA070516Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 664.5, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR 07FDEA00228Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER FLANGE IS CORRODED BS 380, RBL 35, WL208. REMOVED, BLENDED CORROSION, FROM BS380, RBL 35. ROTO PEENED AREA, TREATED AND PRIMED AREA. REF EA NR 5310-106966 AND EA NR-7-5310-106966 REV A.SDR 07FDEA00227Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER FLANGE IS CORRODED, BS 380, RBL 48-55, WL208. BLENDED CORROSION AREA, ROTO PEENED, TREATED AND PRIMED. REF EA NR 7-5310-106966, AND 7-5310-106966 REV A.SDR 07FDEA00226Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER FLANGE IS CORRODED BS 380, LBL 28-31 WL208 BLENDED CORROSION AT STA 380 LBL 28-31. ROTO PEENED, TREATED AND PRIMED AREA. REF EA NR 7-5310-106966, AND EA NR 7-5310-106966 REV A.SDR 07FDEA00220Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER FLANGE IS CORRODED BS 400, RBL 33, WL 208. BLENDED CORRODED AREA, WITHIN LIMITS REF SRM 53-10-1, PG 22. ROTO PEENED AREA, TREATED AND PRIMED AREA, REFERENCE WRI NR 53108449, EA NR 7-5310-106967 CLASSIFIED AS MAJOR.SDR 07FDEA00219Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER FLANGE IS CORRODED BS 360, LBL 8, WL 208. BLENDED CORROSION AT STA 360, LBL 8. ROTO PEENED, TREATED AND PRIMED AREA. REF WRI NR 53108448, EA 7-7310-106965. CLASSIFIED AS MAJOR REPAIR.SDR 07FDEA00218Floorbeam · unknownFWD CARGO COMPT AT STA 939 X= 38 EXISTING ANGLE REPAIR IN FLOORBEAM. REMOVED CHANNEL AS REQUIRED IAW SRM 51-30-00 VOL 2, CUTTED FLOORBEAM AT X= 22. INSTALLED REPAIR IAW SRM 53-60-01 FIG 3 VOL 1. REINSTALLED CHANNEL IAW SRM 51-30-00 VOL 2. FABRICATED PARTS SDR 07FDEA00210Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER FLANGE IS CORRODED AT BS 480, LBL 10, WL 208. BLENDED OUT CORRODED AREA, ROTO PEENED AREA, WITHIN ALLOWABLE LIMITS REF SRM 51-10-02. TREATED, PRIMED, REF WRI NR 53108450, EA 7-5310-106968, WRI 53108465, EA 7-5310-106968. CLASSIFIEDSDR 07FDEA00209Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER FLANGE IS CORRODED BS 480, LBL 38, WL 208. BLENDED CORROSION AT STA 480, LBL 38, ROTO PEENED, TREATED AND PRIMED AREA REF WRI NR 53108450, EA NR 7-5310-106968, WRI NR 53108465, EA NR 7-5310-106968 REV A. CLASSIFIED AS A MAJOR REPASDR 07FDEA00208Floorbeam · corrodedMAIN DECK FLOORBEAM LOWER FLANGE IS CORRODED AT BS 312, RBL 44, WL 200 AT STANDOFF. REMOVED CORROSION REF SRM 51-10-06, MADE REPAIR ANGLES DRILLED UP AND INSTALLED REPAIR REF SRM 53-10-8 PG 39 - 43. CLASSIFIED AS A MAJOR REPAIR.SDR UIEA200700040Floorbeam · crackedUPPER DECK FLOOR BEAM UPPER CHORD LT STA 380 FOUND CRACKED. REPAIRED ACCOMPLISHED AS PER BOEING SR ID NR 1-271217089 AND FAA FORM 8110-9.SDR SIMA200703204Floorbeam · corrodedFOUND LEFT OMEGA BEAM CORRODED AT FRAME 20. PERFORMED CUTOUT OF DAMAGE. FABRICATED AND INSTALLED DOUBLER IAW EMB SRM 53-00-10 AND 51-40-02. RESTORED PROTECTIVE FINISH AND RETURNED AIRCRAFT TO SERVICE.SDR SWAA070481Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 294, RBL 27, WL 208. REPAIRED FLOORBEAM PER SRM.SDR 07FDEA00200Floorbeam · damagedFLOORBEAM HAS OPEN HOLES AT BS 420 ACCOMPLISHED EA NR 7-5330-106980 PART 1, TO COMPLETE WO NR 35039/N01471. INSTALLED RIVETS IN ALL OPEN HOLES, PER SRM 51-30-2.
Back to JASC 5315