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 2008UALA05957Floorbeam · corrodedBEAM 175 CORRODED. BEAM OUT & BRACKETS INSTALLED ON NEW ONE. INSTALLED BEAM AND FASTENERS WITH SEALANT. INSPECTED BEAM 175 INSTALLATION AND FOUND SERVICEABLE.SDR CALA0800941Floorbeam · corrodedCABIN FLOOR SUPPORT FOUND CORRODED AT BODY STATION 325 BETWEEN LBL 21-58. FLOOR SUPPORT BEAM BODY STATION 325 LBL 14 - 63 REPAIRED PER SRM 53-00-51 REPAIR 1 FIG 201, HFEC FOUND NO CRACK.SDR SWIA200820557Floorbeam · crackedDURING C-CHECK, FS 280 LBL9 FLOORBEAM CRACKED. REPAIRED PER REO.SDR SWIA200820556Floorbeam · crackedC-CHECK, FS 280 RBL9 CLIPS CRACKED. REPAIRED PER REO.SDR SWIA200820555Floorbeam · crackedDURING C-CHECK, FS 280 LBL9 OUTBOARD WEB CRACKED. REPAIRED PER REO.SDR UPS08553612Floorbeam · corrodedINSPECTION TYPE:C2 FLOORBEAM AT BS 1200 BL 0 TO LBL 65 WL 208 IS CORRODED AT NUT PLATES. FLAP PEENED, ALODINED, PRIMED, APPLIED SEALANT IAW ATS ER 08-3101.SDR UPS08553611Floorbeam · corrodedINSPECTION TYPE:C2 FLOORBEAM AT BS 1100 BL 0 - LBL 65 WL 208 IS CORRODED AT NUT PLATE HOLES. REPAIRED PER ATS ER 08-3103 DATED 14OCT08.SDR UPS08553516Floorbeam · corrodedINSPECTION TYPE:C2 FLOOR PANEL SUPPORT PLATE IS CORRODED AT BS 1020 LBL 50 WL 208. FABRICATED NEW SUPPORT PLATE & INSTALLED.SDR SWAA085365Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CRACKED AT BS 312, RBL 42. REMOVED AND REPLACED BEAM PER SRM.SDR DL757081274Floorbeam · corrodedUPON DAMAGE REMOVAL OF MAIN CABIN DECK PLATE, FOUND STA 1680 FLOORBEAM CORRODED IN NUMEROUS LOCATION. BLENDED CORROSION IAW 757 SRM 51-10-02. CORROSION FOUND OUT OF LIMITS. REPLACEMENT FLOORBEAM CAP INSTALLED IAW SRM 51-40-02 AND ERA 470312-14.SDR SWAA085324Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND MAIN CABIN FLOORBEAM CRACKED AT BS 663 BL 0. REPAIRED BEAM PER DHN EA.SDR SWAA085304Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM T-CAP CORRODED AT BS 947.5, RBL 2 TO LBL 4. REMOVED AND REPLACED BEAM PER SRM.SDR CALA0800934Stiffener · crackedE&E COMPARTMENT LEFT STATION 246 CABIN FLOORBEAM LBL 25 VERTICAL STIFFENER FOUND CRACKED. E&E COMPARTMENT LEFT STATION 246 CABIN FLOORBEAM LBL 25 VERTICAL STIFFENER REPLACED PER SRM 51-10-02 AND FASTENERS INSTALLED PER SRM 51-40-02.SDR CALA0800933Floorbeam · crackedE&E COMPARTMENT STATION 246 LBL 40 CABIN FLOOR MID CHORD FOUND CRACKED. E&E COMPARTMENT STATION 246 LBL 40 CABIN FLOOR MID CHORD REPAIRED PER SRM 53-10-51, REPAIR 2 FIG 201 AND ECRA 5310-04844.SDR CALA0800932Stiffener · crackedE&E COMPARTMENT LEFT STATION 246 CABIN FLOORBEAM LBL 40 VERTICAL STIFFENER FOUND CRACKED. E&E COMPARTMENT LEFT STATION 246 CABIN FLOORBEAM LBL 40 VERTICAL STIFFENER REPAIRED PER ECRA 5310-04844.SDR SWAA085268Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 667, LBL 24.8. REPAIRED BEAM PER SWA EA.SDR SWIA200820551Floorbeam · crackedC-CHECK, FS 280 LBL9 LOWER FLOOR SUPPORT CRACKED. REPAIRED PER REO.SDR SWIA200820550Floorbeam · crackedC-CHECK, FS 280 RBL9 UPPER FLOOR SUPPORT ANGLE CRACKED. REPAIRED PER REO.SDR TRAX200801255Floorbeam · corrodedFWD FLOOR SUPPORT ANGLE AT FS 280 CORRODED.SDR TRAX200801249Floorbeam · corrodedL/H 280 FLOOR SUPPORT BEAM CORRODED.SDR TRAX200801250Floorbeam · corrodedR/H FS 280 FLOOR SUPPORT BEAM CORRODED.SDR UPS08553609Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION FOUND ALONG UPPER SURFACE OF FLOORBEAM AT FASTENER HOLES BS 1200 RBL 48 TO RBL 51. FLAP PEENED, ALODINE, PRIME, APPLIED SEALANT IAW ATS ER 08-3101.SDR UPS08553607Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION FOUND ALONG UPPER SURFACE OF FLOORBEAM AT FASTENER HOLES BS 1200 RBL 15 INSTALLED NESTED ANGLES REPAIR IAW ATS ER 08-3101.SDR UPS08553517Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION FOUND ALONG UPPER SURFACE OF FLOORBOARD SUPPORT AT FASTENER HOLES BS 1054 RBL 242 WL 208. REMOVED AND REPLACED PER SRM 51-40-02.SDR SWAA085269Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 673, LBL 24.8. REPAIRED BEAM PER SWA EA.SDR USAA920081813Floorbeam · corrodedSAL - C7 - MAJOR REPAIR, CORROSION ON FLOORBEAM HARD POINT AT FLOOR STRUCTURE IN PAX CABIN LOCATED -Y1292 FR 64 TO FR 66+1. REPLACED FLOORBEAM IN PAX CABIN LOCATED -Y1292 FR 64 TO FR 66+1 IAW A320 SRM 51-72-11.SDR USAA920081841Floorbeam · corrodedSAL - C7 - MAJOR REPAIR, CORROSION ON FLOORBEAM HARD POINT AT FR64+7 TO FR66, Y765. REPLACED FLOORBEAM AT FR64+7 TO FR66, Y765 IAW A320 SRM 51-72-11.SDR UPS08553402Floorbeam · corrodedINSPECTION TYPE:C2 MCB LBL 45 - LBL 65, BS 1200, FLOORBEAM UPPER SURFACE HAS CORROSION AT FASTENER HOLES. REMOVED CORROSION AND REPAIRED FLOORBEAM PER ATS ER 08-3012 AND UPS EO B757-5310-30666-A.SDR AALA200802500Floorbeam · corrodedCORROSION ON FLOORBEAM AT CLIP NUT HOLE BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802499Floorbeam · corrodedTUL CORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802498Floorbeam · corrodedTUL CORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802497Floorbeam · corrodedTUL CORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802496Floorbeam · corrodedTUL CORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802495Floorbeam · corrodedTUL CORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802494Floorbeam · corrodedCORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR AALA200802493Floorbeam · corrodedCORROSION ON UPPER SURFACE OF FLOORBEAM BEYOND LIMITS. REPAIRED PER ESO 61000 DATED 22 SEP 08.SDR F3LA200800635Floorbeam · corrodedDURING C4/S1 C-CHECK, INSPECTION NOTED CORROSION ON PASSENGER CABIN FLOORBEAM Y1732 AT FRAME 66. MX REPAIRED FLOORBEAM Y1732 AT FRAME 66 IAW THE REQUIREMENTS OF A319 SRM 53-41-14, FIGURE 201. UPON COMPLETION OF THE REPAIR, IT WAS INSPECTED AND FOUND ACCEPTABSDR UPS08653453Stiffener · crackedINSPECTION TYPE:N/A CABIN STA 240 LBL 25 FLOORBEAM ATT STIFFENER CRACKED. CRACK LENGTH 1 INCH. DEFECTIVE STIFFENER REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02.SDR UPS08653452Stiffener · crackedINSPECTION TYPE:N/A CABIN STA 246 RBL 10 FLOORBEAM ATT STIFFENER CRACKED. CRACK LENGTH 1 INCH. DEFECTIVE STIFFENER REPLACED IAW SRM 51-10-02 AND INSTALLED IAW SRM 51-40-02.SDR UPS08653451Stiffener · crackedINSPECTION TYPE:N/A CABIN STA 246 LBL 50 FLOORBEAM ATT STIFFENER CRACKED. CRACK LENGTH 1 INCH. DEFECTIVE STIFFENER REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02.SDR UPS08553399Floorbeam · corrodedINSPECTION TYPE:C2 MCB LBL 0 - LBL 25, BS 1200, FLOORBEAM UPPER SURFACE HAS CORROSION AT NUMEROUS FASTENER HOLES. BEGAN DAMAGE REMOVAL PER ATS ER 08-3012, FOUND ADDITIONAL AREAS OF CORROSION AND TRANSFERRED WORK TO CUST CARD NR 779379.SDR 08FDEA04059Floorbeam · corrodedCABIN FLOORBEAM STA 1640 LBL 58 HAS CORROSION. REMOVE CORROSION IAW SRM 51-40-02 CHECK LIMITS FOUND TO BE OUT OF LIMITS IAW SRD 53-00-51. REMOVED DAMAGED FLOORBEAM IAW SRM 53-00-01, RECEIVED EXTRUSION BAC1505-100 703 BATCH NR 0001493411ON MAE T8-54170, LOCATSDR 08FDEA04056Floorbeam · corrodedMAIN CABIN FLOORBEAM BS 1681.8 UPPER T-CHORD LOWER SURFACE LBL58.22-RBL58.22 CORRODED. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51, FAB NEW T-CHORD ON TRAVELER NR T8-756288, T8-756289, T8-756213. INSTALLED FABRICATED PARTS IAW 51-40-02.SDR 08FDEA04055Floorbeam · gougedCABIN FLOORBEAM FS 324 RBL 32 GOUGED. REMOVED GOUGE ON FLOORBEAM. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51 FIG 101 SHEET 3 DETAIL 3. REMOVED FLOORBEAM, AND FLOOR SUPPORT FOR ACCESS FAB NEW T- CHORD AND INSTALLED IAW 51-40-02.SDR F3LA200800629Floorbeam · corrodedDURING C4/S1 C-CHECK, INSPECTION NOTED CORROSION ON PASSENGER CABIN FLOORBEAM Y765 AT FRAME 67+10 INCHES. MX REMOVED AND REPLACED FLOORBEAM AT FRAME 67 IAW THE REQUIREMENTS OF A319 SRM 51-72-11, PAGE 1 AND 2. UPON COMPLETION OF THE REPAIR, IT WAS INSPECTED ASDR KCSA081490Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER CHORD CORRODED AT BS 640, LBL 103.SDR DL757081231Floorbeam · corrodedDURING CURRENT HMV, CORROSION WAS FOUND ON THE 1681 FLOORBEAM, ON THE UPPER CHORD (UPPER AND LOWER SURFACE). DUE TO THIS, THE UPPER CAP WAS CUT OUT AND REMOVED PER BOEING INSTRUCTIONS, AND A REPLACEMENT UPPER CAP INSTALLED AS DOCUMENTED IN ER/A 470312-14 (CATSDR AALA200802608Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM AT STATION 986.5 AT RIGHT BUTTLINE 29.5. REMOVED CORROSION AND REPAIRED PER SRM 53-70-51 AND 53-00-51 2R.SDR AALA200802607Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM AT STATION 986.5 AT RIGHT BUTTLINE 23. REMOVED CORROSION AND REPAIRED IN ACCORDANCE WITH SRM 53-70-51 AND 53-00-51 2R.SDR AALA200802606Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM AT STATION 986.5 AT RIGHT BUTTLINE 17. REMOVED CORROSION AND REPAIRED IN ACCORDANCE WITH SRM 53 70 51 AND 53 00 51 2R.
Back to JASC 5315