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 08FDEA01772Floorbeam · crackedAFT CARGO COMPARTMENT HAS A .250 INCH CRACK ON FLOORBEAM AT FR 64 OUTBD OF SEAT TRACK NR 3 RT. REMOVED CRACK AND INSTALLED CROSSBEAM REPAIR AT FRAME 64 BETWEEN SEAT TRACKS NR 3 RT AND NR 4 IAW A300-600 SRM 53-10-15, FIG 21.SDR 08FDEA01771Floorbeam · crackedAFT CARGO COMPARTMENT FLOORBEAM HAS .500 INCH CRACK AT FRAME 64 BETWEEN SEAT TRACKS NR 4 RT AND NR 5 RT REMOVED CRACK AND INSTALLED CROSSBEAM REPAIR AT FRAME 64 BETWEEN SEAT TRACKS NR 4 RT AND NR 5 IAW A300-600 SRM 53-10-15, FIG 211.SDR TRAX200800601Floorbeam · crackedTRANSVERSE BEAM CRACKED AT FS 280.0 LBL 12.0 IN UPPER RADIUS JUST O/B OF EMER EXTENSION CABLE PULLEY BRACKET. REPAIRED FS 280 TRANSVERSE BEAM BETWEEN LBL 9.0 AND LBL 12.0 IAW REO 601R-53-11-138. (B)SDR USAA920081118Floorbeam · corrodedMCN - MAJOR REPAIR - C21 CHECK - CORROSION ON FLOORBEAM UPPER CHORD, BS 986, RBL 15 - RBL 45. REPAIRED FLOORBEAM UPPER CHORD, BS 986, RBL 15 - RBL 45 IAW USAIRWAYS EA 130026 AND TYPICAL REPAIR 53-15-01B.SDR UIEA200500168Floorbeam · crackedCOCKPIT STA 340 - 360 RIGHT SIDE OUTBOARD FLOORBEAM FOUND TO HAVE MINOR CRACK. WEB MINOR CRACK TRIMMED OFF PER SRM 51-10-01.SDR 2008UALA02637Floorbeam · corrodedFLOORBEAM JUST INBD OF AFT LT MED IS CORRODED. MAJOR REPAIR ACCOMPLISHED: REPLACED FLOORBEAM.SDR SWAA082464Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM TEE CAP CORRODED AT BS 986, RBL 38 TO LBL 44. REMOVED AND REPLACED TEE CAP PER SRM.SDR DU4R2008192Floorbeam · corrodedS/O 245007 OPS NR 25007 - STA 986.5 FLOORBEAM HAS CORROSION ON UPPER T-CAP SURFACE BL 32L TO BL 32R. CORROSION OUT OF LIMITS.SDR SWAA082429Floorbeam · crackedDURING SCHEDULED DAL CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 707, RBL 24.82. REPAIRED WEB PER SWA EA.SDR USAA920080998Floorbeam · corrodedBFM - MAJOR REPAIR - C2 CHECK - CORROSION ON CABIN FLOORBEAM, BS 365, RBL 5 - RBL 15, WL 208. REPAIRED CABIN FLOORBEAM, BS 365, RBL 5 - RBL 15, WL 208 IAW B757 SRM 53-00-51.SDR QXEA200800557Floorbeam · corrodedRFD C4 CHECK LT FS 280 BEAM CORRODED. REMOVED LT FS 280 BEAM IAW CRJ 700 SRM 51-42-06 AND 51-42-13. PERFORM LPI ON LT 280 CROSSBEAM IAW CRJ 700 NDTM 51-20-008 NO DEFECTS NOTED. LOCATED HOLES IN NEW BEAM AND INSTALLED BEAM IAW CRJ 700 SRM 51-40-11, 51-42-07,SDR SWIA200819801Floorbeam · corrodedLOWER FLOOR WEB AT FS280 IS CORRODED. (FOUND AT C-CHECK) REPLACED LOWER FLOOR WEB AT STA280 IAW SRM 51-42-21-001-001-A01 AND 51-42-13-0011-001-A01.
SDR SWIA200819800Floorbeam · corrodedCOCKPIT AFT FLOOR SUPPORT IS CORRODED. (FOUND AT C-CHECK) INSTALLED NEW FLOOR SUPPORT IAW SRM 51-42-06-001-001-A01.
SDR SWIA200819799Floorbeam · corrodedSTA280 LOWER CROSSBEAM IS CORRODED. (FOUND AT C-CHECK) COMPLIED WITH REPAIRS OF STA280 CROSSBEAM IAW SRM 51-42-06-001-001-A01.
SDR DU4R2008201Floorbeam · corrodedS/O 312001 N/R 24738 - CORROSION ON UPPER SURFACE OF FLOOR SUPPORT BEAM BS 328 RBL 16 - RBL 60.SDR DU4R2008200Floorbeam · corrodedS/O 312001 N/R 24703 - CORROSION ON TOP OF FLOORBOARD IN GOUGE BS 312 LBL 52 TO LBL 8, AND NUMEROUS PLACES AT RBL 0 TO RBL-54.SDR DU4R2008199Floorbeam · corrodedS/O 312001 N/R 24568, CORROSION ON UNDERSIDE OF T-CAP REPLACEMENT 986.5 AROUND ATTACH HOLES BL-29R TO BL-29L NUMEROUS HOLES.SDR USAA920080961Floorbeam · crackedCLT - MAJOR REPAIR - C20 CHECK - CRACKED CABIN FLOORBEAM UPPER CHORD, BS 380 - BS 400, BL 0. REPAIRED CABIN FLOORBEAM UPPER CHORD, BS 380 - BS 400, BL 0 IAW B737 SRM 53-30-51.SDR F3LA200800240Floorbeam · corrodedDURING C3 S1 C CHECK INSPECTION NOTED CORROSION ON AND AROUND FASTENERS ON BEAM INBOARD OF R2 DOOR BETWEEN FRAME 68 AND 70. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IN ACCORDANCE WITH THE REQUIREMENTS OF SRM 51-72-11 AND SRM 51-42-00. UPON COMPLETION OF THSDR F3LA200800236Floorbeam · corrodedDURING C3 S1 CHECK INSPECTION NOTED CORROSION ON AND AROUND NUT CLIPS ON FLOORBEAM JUST INSIDE OF THE L2 DOOR BETWEEN FRAMES 66 AND 68. MAINTENANCE REMOVED AND REPLACED BEAM JUST INSIDE OF L2 DOOR BETWEEN FRAMES 66 AND 68 IN ACCORDANCE WITH THE REQUIREMENTS OSDR F3LA200800235Floorbeam · corrodedDURING C3 S1 C CHECK INSPECTION NOTED AFT CARGO LATERAL FLOORBOARD PROFILE AT FRAME 59 BETWEEN STRINGER 38 LEFT AND 38 RIGHT HAS AREAS OF CORROSION AROUND NUT PLATE HOLES. MAINTENANCE REMOVED AND REPLACED PROFILE AT FRAME 59 BETWEEN STRINGER 38 LEFT AND 38 RISDR F3LA200800229Floorbeam · damagedDURING C3 S1 C CHECK INSPECTION NOTED LEFT AVIONICS COMPARTMENT FRAME C20 LATERAL BRACE IS FRETTING AT FRAME C20 MOUNT HOLE. MAINTENANCE REMOVED DAMAGED CROSSBEAM, DRILLED UP AND INSTALLED NEW CROSSBEAM AT FRAME C20 LEFT AVIONICS BAY IN ACCORDANCE WITH THE RESDR SWAA082377Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 667, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA082373Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 665, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA082374Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 670, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA082375Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 665, RBL 24.50. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA082376Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 663, LBL 24.75. REPAIRED FLOORBEAM PER SWA EA.SDR USAA920081096Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN BEAM, BS 2786 / FR 66, +Y510. REPAIRED CABIN BEAM, BS 2786 / FR 66, +Y510 IAW A320 SRM 51-72-11.SDR DHL2008807518Floorbeam · crackedFWD CARGO COMPT FLOOR SUPPORT CRACKED 1/2 INCH STA 180.000 L-31L. REMOVED FASTENERS IAW SRM 51-1-20D. PERFORMED STOP HOLE AND FABRICATED ANGLE DOUBLER (STEEL 301 1/2H 0.040") IAW SRM 53-2-0 PG 2E/2F. INSTALLED ANGLE DOUBLER IAW SRM 51-1-20D, SRM 51-3-1 PG 2SDR SWAA082345Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, BETWEEN LBL 17 AND RBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA082342Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 708, RBL 24.82. REPAIRED WEB PER SWA EA.SDR SWAA082343Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 709, RBL 24.82. REPAIRED WEB PER SWA EA.SDR 2008UALA02495Floorbeam · corrodedCABIN FLOORBEAM UPPER SURFACE CORRODED, BS 303, RBL 54. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED SECTION OF "T" CAP. INSTALLED "T" CAP AND ANGLE REPAIR.SDR SWAA082249Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM TEE CAP CRACKED AT BS 294.5, STR 17R. REMOVED AND REPLACED TEE CAP PER SRM.SDR CALA0800381Floorbeam · crackedM/D - BS 246 FLOORBEAM MID CHORD AT LBL 40 FOUND RADIUS AREA CRACKED APPROX 1 INCH LONG. M/D BS 246 FLOORBEAM MID CHORD AT LBL 40" REPAIRED PER ECRA 5310-04725 AND HFEC NO CRACK FOUND.SDR CALA0800379Floorbeam · corrodedBODY STATION 325, LBL 30 TO LBL 50 FLOOR SUPPORT FOUND CORRODED. BODY STATION 325 LBL 30 TO LBL 55 FLOOR SUPPORT REPAIRED IAW SRM 53-00-51, REPAIR 1 FIG 201.SDR CALA0800380Stiffener · crackedBODY STATION 246 FLOORBEAM VERTICAL STIFFENER CRACKED AT LBL 40". BODY STATION 246 FLOORBEAM VERTICAL STIFFENER REPAIRED PER ECRA 5310-04725.SDR GTIA0800064Floorbeam · corrodedFOUND FLOORBEAM CORROSION AT Y1292 BETWEEN FR66 AND FR68. REPLACED FLOORBEAM.SDR GTIA0800069Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT Y1292 BETWEEN FR66 AND FR68. REPLACED FLOORBEAM.SDR GTIA0800068Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT Y765 BETWEEN FR66 AND FR70. REPLACED FLOORBEAM.SDR GTIA0800067Floorbeam · corrodedFOUND CORROSION ON AFT FUSELAGE FLOORBEAM Y765 BETWEEN FR64 AND FR66. REPLACED FLOORBEAM.SDR GTIA0800065Floor Support · corrodedFOUND CORROSION AT FLOORBEAM Y765 FR66 TO FR70. REPLACED FLOORBEAM.SDR GTIA0800066Floorbeam · corrodedAFT FUSELAGE FLOORBEAM CORRODED AT Y254 BETWEEN FR66 AND FR68. REPLACED FLOORBEAM.SDR GTIA0800070Floorbeam · corrodedAFT FUSELAGE FLOORBEAM AT Y254 BETWEEN FR68 AND FR70. REPLACED FLOORBEAM.SDR 2008UALA02477Support Bracket · crackedRT SIDE NLG TUNNEL AREA BS 246 FLOORBEAM SUPPORT BRACKET CRACKED RBL 26. REMOVED AND REPLACED BRACKET.SDR 08FDEA01591Floorbeam · corrodedFLOORBEAM HAS CORROSION BS 1300, RBL 28, BELOW UPPER T-CAP FWD SIDE, AT FLOOR PANEL HOLE. REMOVED CORROSION ON FLOORBEAM IAW SRM 51-00-51. AFTER CORROSION REMOVAL FOUND FLOORBEAM TO BE OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DETAIL 3. REWORK DIMENSIONS ARESDR 2008UALA02420Floorbeam · corrodedAFT FLOORBEAM CORRODED AT FLOOR BOARD HOLES STA 986.5 RBL 20-32 UPPER AND LOWER SURFACE. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED FLOORBEAM UPPER TEE CAP SPLICE REPAIR.SDR SWAA082223Floorbeam · corrodedDURING SCHEDULED HC1 CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 293.5, RBL 5. REMOVED AND REPLACED UPPER CHORD PER SRM.SDR SWAA082207Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 701, BL 0. REPAIRED FLOORBEAM PER ER AND BOEING SB.SDR SWAA082206Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED FLOORBEAM PER ER AND BOEING SB.
Back to JASC 5315