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 AWXA200600971Floorbeam · corrodedNR 5910888 - DURING BC-4 CHECK, DISCOVERED LEVEL 2 GALVANIC CORROSION ON FLOOR BEAM LOCATED IN PAX CABIN AT FR 66 - Y1292. MAINTENANCE REPLACED FLOOR BEAM FROM FR 64 TO FR 66 - Y1292 IAW SRM A319-51-72-11.SDR AWXA200600969Floorbeam · corrodedNR 5910964 - DURING BC-4 CHECK, DISCOVERED LEVEL 2 GALVANIC CORROSION ON FLOOR BEAM AT CABIN FLOOR STRUCTURE FR 20 - Y275. MAINTENANCE REPAIRED FLOOR BEAM FROM FR 17+120 INCH TO FR18+5 INCH - Y275 IAW SRM A319 53-11-14.SDR AWXA200600884Floorbeam · corrodedSAL - DURING BC4 CHECK, DISCOVERED CORROSION ON FLOORBEAM AT CABIN FLOOR STRUCTURE FROM FS 15+8IN TO FS 16 Y765. SEAT TRACK WAS REPLACED BETWEEN FS 12 TO FS 24 Y765 IAW SRM A319 51-72-11.SDR SWAA061806Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 30 TO RBL 35. REPAIRED FLOORBEAM PER SRM.SDR 06FDEA2008Floorbeam · corrodedAFT PIT FLOORBEAM STA1887 UPPER AND LOWER SURFACE CORRODED FROM LONGERON 42L TO 42R. FAB ANGLE IAW DC-10-10 SRM 53-16-01 PAGE 26D FIG 6, PAGE 26E VOL III. FAB REPAIR CHANNEL IAW DC10-10 SRM 53-30-00 PAGE 13-16 VOL I ALODINE AND PRIME IAW DC10-10 SRM 51-21-01SDR CA060523011Floorbeam · corrodedFOUND FWD CABIN AREA FLOORBEAM AT 328 BRL 41 CORRODED.SDR CA060523010Floorbeam · corrodedFOUND FLOORBEAM AT BS 986 CORRODED AT CLIPNUT HOLES BETWEEN RBL 47 AND RBL 18.SDR 06FDEA1999Floorbeam · misrepairedIMPROPER REPAIR ON FLOORBEAM AT BS 400, RBL 18 WL 208. REPAIRED FLOORBEAM PER SRM 53-10-8.SDR SWAA061763Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, RBL 1 TO LBL 10. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR CALA0600187Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 325, LBL 31-58. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, REPAIR 1, FIGURE 201.SDR CALA0600186Floorbeam · corrodedINSPECTION FOUND AFT CABIN FLOORBEAM CORRODED AT CLIP NUT HOLES AT BS 986 BETWEEN RBL 18 AND RBL 47. THE CORROSION WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-70-51 AND 53-00-51, FIGURE 203.SDR CALA0600185Floorbeam · corrodedINSPECTION FOUND FORWARD CABIN FLOORBEAM CORRODED AT BS 328, RBL 41. THE FLOORBEAM WAS REPAIRED IAW SRM 51-70-12, REPAIR 2.SDR ASAA0640625Floorbeam · gougedFOUND FLOORBEAM GOUGED. REPAIRED FLOORBEAM PER EA 5310 02628.SDR ASAA0640620Floorbeam · gougedFOUND FLOORBEAM GOUGED. REPAIRED FLOORBEAM IAW EA 531 02628.SDR ASAA0640619Floorbeam · gougedFOUND FLOORBEAM GOUGED. REPAIRED FLOORBEAM PER EA 5310 02628.SDR USAA060719Floorbeam · corrodedBS 370 RBL 13 CORRODED. REPLACED T-CAP SECTION, DEFECT SIZE: 6 X 2 INCHES.SDR C1HA200683008Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AT BS 1030, LBL 45. REPAIRED FLOORBEAM AT BS 1030, LBL 45 IAW B727 SRM 53-10-8 FIG 3.SDR C1HA200683005Floorbeam · corrodedCABIN FLOORBEAM AT BS 1110, LBL 20 HAS CORROSION ON TOP FLANGE. REPAIRED FLOORBEAM AT BS 1110 LBL 20 IAW B727 SRM 53-10-8 FIG 3.SDR SWAA061748Floorbeam · crackedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 35 TO LBL 54. REPAIRED FLOORBEAM PER ER.SDR SWAA061734Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 24. REPAIRED FLOORBEAM PER SRM.SDR QXEA200602340Floorbeam · corrodedYYC: FUSELAGE INTERIOR UNDERFLOOR, VERTICAL FLOOR SUPPORT CHANNEL, STR 31S TIE FITTING AND KEEL STRAP ASSY AT STA X19 HAS CORROSION. MAINTENANCE REPAIRED IAW Q400 SRM 51-21-00-350-801, SRM 51-25-10-370-801 AND SRM 51-25-15-370-801.SDR QXEA200602337Floorbeam · corrodedYYC: FUSELAGE INTERIOR UNDERFLOOR, TRANZ FLOORBEAM AT STA X1.0 BETWEEN RBL 9.0 RT OUTBOARD END, ASSY HAS MANY AREAS OF CORROSION. MAINTENANCE REPAIRED IAW Q400 SRM 51-21-00-350-801, SRM 51-25-10-370-801 AND SRM 51-25-15-370-801.SDR CALA0600173Floorbeam · corrodedINSPECTION FOUND AFT CABIN FLOORBEAM CORRODED I/B OF LT Z-ANGLE AT STA 986.5, LBL 26-52. THE CORRODED SECTION OF FLOORBEAM WAS REPLACED IAW ECRA 5310-03851.SDR CALA0600170Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT SEVERAL SPOTS AT STA 986.5 FROM LBL 38 TO RBL 43. REPAIRED IAW ECRA 5321-01358.SDR 06FDEA1973Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT BS 680, RBL 49, WL 208. REPAIRED FLOORBEAM PER SRM 53-10-8.SDR CALA0600174Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 303, LBL 31. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, FIGURE 201, REPAIR 1.SDR QXEA200602296Floorbeam · corrodedYYC: FUSELAGE INTERIOR UNDERFLOOR TANZ BEAM AT STA X136, BL 0 SPLICE HAS CORROSION. MAINTENANCE REPAIRED IAW Q400 SRM 51-42-05-330-801, SRM 51-40-07-320-801, SRM 51-21-00-350-801, SRM 51-21-10-380-801, AND SRM 51-25-10-370-801.SDR SWAA061706Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986.5, AT LBL 5 TO LBL 43. REPAIRED FLOORBEAM PER SWA EA.SDR KCSA061167Floorbeam · damagedUPPER CAP OF FLOORBEAM DAMAGED IN FWD BILGE AT BS 560, LBL 12.SDR QXEA200602292Floorbeam · corrodedYYC: FUSELAGE INTERIOR UNDERFLOOR, TRANZ BEAM AT STA X71, SPLICE ASSY AT BL O MISSING 2 RIVETS. MAINTENACE REPAIRED IAW Q400 SRM 51-42-05-330-801 AND SRM 51-25-10-370-801.SDR SWAA061687Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 5 TO RBL 43, WL 207. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA061683Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA061682Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA061681Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR QXEA200602283Floorbeam · corrodedYYC: FUSELAGE INTERIOR UNDER FLOOR TRANZ FLOORBEAM AT STA X1.0 BL O SPLICE AREA IS CORRODED. MAINTENANCE REPAIRED IAW Q400 SRM 51-42-05-330-801, SRM 51-21-00-350-801, AND SRM 51-25-10-370-801.SDR A6WA200640197Floorbeam · crackedOUTBOARD CLIP AT FS 280, RBL 9, FLOORBEAM IS CRACKED IN RADIUS APPROX .5 INCHES. MAINTENANCE REMOVED & REPLACED FS 280 RBL 9 OUTBOARD CLIP IAW CRJ 20 SRM 51-42-21, 51-42-13, AND BSC STANDARD REPAIR 601R-53-0057A. (M)SDR A6WA200640196Floorbeam · damagedINBOARD CLIP AT FS 280, RBL 9, FLOORBEAM IS CRACKED IN RADIUS APPROX .5 INCH. MAINTENANCE REMOVED AND REPLACED FS 280 RBL 9 INBOARD CLIP IAW CRJ 200 SRM 51-42-21, 51-42-13 AND BSC STANDARD REPAIR 601R-53-0057A. (M)SDR USAA060703Floorbeam · corrodedSTA 967 LBL 12 THROUGH LBL 50 RBL 6 AND LBL 4 CORROSION. FLOORBEAM REPLACEMENT IAW 53-10-05-B LEVEL 1 C53-107-01/02, DEFECT SIZE: .25 INCH.SDR USAA060702Floorbeam · corrodedSTA 967 LBL 12 THROUGH LBL 50 RBL 6 AND LBL 4 CORROSION. FLOORBEAM REPLACEMENT IAW SRM 53-10-05B LEVEL 1 C53-107-01/02, DEFECT SIZE: .25 INCH.SDR USAA060699Floorbeam · crackedBS 344 LBL 45 CRACKED. REPLACED FLOORBEAM STRAP IAW SRM 51-10-02, DEFECT SIZE: .250 INCH.SDR A6WA200640189Floorbeam · crackedRIGHT FS 621 FLOORBEAM ANGLE HAS A 1 INCH CRACK ON OUTBOARD RADIUS. REPAIRED FLOORBEAM ANGLE AT RT FS 621 IAW BOMBARDIER REO 601R-53-61-117 REV C. (M)SDR A6WA200640188Floorbeam · crackedFOUND LEFT FS 621 FLOORBEAM ANGLE HAS 1 INCH CRACK IN OUTBOARD RADIUS. REPAIRED ANGLE AT LT FS 621 IAW BOMBARDIER REO 601R-53-61-117 REV C. (M)SDR F3LA200600034Floorboard · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM CORRODED AT FRAME 15, 6TH FLOORBEAM FROM RT CENTER OF FUSELAGE ON THE AFT END OF BEAM. BLENDED CORROSION AND PERFORMED HFEC PER SRM 51-75-12 AND EA A9-53R-11424.SDR DU4R2006448Floorbeam · corrodedFOUND CORROSION ON PAX CABIN FLOORBEAM STRUCTURE JUST FWD OF THE AFT CABIN PRESSURE BULKHEAD DOOR THRESHOLD FS 1352, BL 0 TO BL 11-L. REPAIRED BY FABRICATING AND INSTALLING DOUBLER REPAIR 33" X 5" AND ANGLE 23" X 46" FROM 7075-T6 .050" IAW DC-9/MD-80 SRM 53-0SDR SWIA200616782Floorbeam · corrodedFLOORBEAM SURFACE CORROSION AT ENTRANCE OF MAIN DOOR, DISCOVERED DURING C-CHECK INSPECTION. REMOVED AND REPLACED BUTT STRAP AT ENTRANCE OF MAIN DOOR IAW EMB 120 SRM 51-10-02 PG 3 SECT 3A, PN 12046963-001.SDR 2006UALA00940Repair · corrodedAFT FLOOR BEAM REPAIR FILLER CORRODED MARKED STA 947 LT BL 5 WL 208 CORRODED.SDR SWAA061628Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM CORRODED AT BS 772, RBL 2.5. REPAIRED FLOORBEAM PER SRM.SDR 06FDEA1904Floorbeam · corrodedELONGATED HOLE ON FLOORBEAM AT BS 440 LBL 19 WL 208. CUT OUT DAMAGE FLOORBEAM AT BS 440 LBL 11.5 - LBL 20.5 WL 208 AND INSTALLED REPAIR PER SRM 53-10-8.SDR 06FDEA1793Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM LWR FLANGE BS 1070 LBL 52 - RBL 52 WL 200. REPAIRED FLOORBEAM PER SRM 53-10-8.SDR UPS06446913Floorbeam · corrodedFLOORBEAM UPPER CHORD BS 480 LBL 33-63 CORRODED. CORROSION BLEND OUT 0.034" BY 1" BY 20" EXCEED SRM LIMIT. BS 480 BL0 TO LBL78 FLOORBEAM UPPER CHORD. REPAIRED AS PER SRM 53-10-07 FIG 10.
Back to JASC 5315