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 AWXA200501370Floorbeam · corrodedDURING C18 CHECK DISCOVERED CORROSION ON CHORD LOCATED AT BS 328, WL 208 AND FROM BL 27R TO BL 56R. MAINTENANCE REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-10-51-1A1 FIG 101. REMOVED DAMAGED SECTION OF CHORD IAW BOEING 737-300 SSDR EIA2005206Floorbeam · damagedFOUND LT BS 340 FLOORBEAM UPPER CHORD 1 EACH HOLE COMMON TO FRAME INNER CHORD FOUND CRACKED AT FLOORBEAM UPPER CHORD, RUNNING UP AND DOWN. REPAIRED DEFECTIVE FLOORBEAM UPPER CHORD PER SRM 53-10-07, FIG 23.SDR EIA2005173Floorbeam · crackedBS 360 RBL 3 FLOORBEAM SCREW HOLE AREA FOUND CRACKED. DEFECTIVE FLOORBEAM UPPER CHORD REPAIRED PER SB 747 53A2452 FIG 13 (HORIZONTAL AFT FLANGE RBL 3).SDR SWAA053110Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 775, LBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053109Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 775, LBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR CALA0500398Floorbeam · corrodedINSPECTION FOUND THE RT SIDE OF UPPER CHORD OF FLOORBEAM CORRODED AT STA 1016, RBL 16 TO RBL 35. THE FLOORBEAM WAS REPAIRED BY SPLICING IN A NEW SECTION OF UPPER CHORD IAW ECRA 5321-01299.SDR ASOA05903Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FS 36, BETWEEN LBL 30 TO RBL 30, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FS 36, BETWEEN LBL 30 TO RBL 36 IAW ASA EO 72-53-0170. (M)SDR ASOA05904Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM AT FS 38, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FS 38 IAW ASA EO 72-53-0171. (M)SDR ASOA05906Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM, AT FS 39, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM, AT FS 39, IAW ASA EO 72-53-0172. (M)SDR ASOA05907Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAM, AT FS 40, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FS 40, IAW ASA EO 72-53-0173. (M)SDR ASOA05908Floorbeam · corrodedDURING A C-CHECK IN YUL, FLOORBEAM AT FS 41, BETWEEN BL 0 TO RBL 26, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FS 41, BETWEEN BL 0 TO RBL 26, IAW ASA EO 72-53-0184. (M)SDR COMA0570110Floorbeam · corrodedFS 280 TRANSVERSE BEAM CORRODED BETWEEN LBL 36 TO RBL 36. REPAIRED IAW BOMBARDIER REO 670-53-11-047 REV C.SDR 05FDEA03222Floorbeam · crackedFWD CARGO COMPT FOUND ON FLOORBEAM AT STA 979 X=-97 RT SIDE CRACK LONG 1/2 INCH. CUT DAMAGED PORTION BEAM. REPLACED SECTION IAW SRM 51-35-01 PAGE 1-13 VOL II. REPLACED BRACKET ADA0144-27 AND REPAIRED IAW 53-00-01 FIG 9 SHEET 8.SDR DHL2005742518Floorbeam · corrodedAFT PIT CEILING, CABIN FLOORBEAM BS 1120 UPPER SURFACE HAS CORROSION AT RBL 44. REMOVED CORROSION IAW B727 SRM 51-10-6, UT INSPECTED. CUT OUT CORROSION, FABRICATED AND INSTALLED FLOORBEAM REPAIR 9-3/4" BY 2.9" BY .300" FROM 7075-T6 .050 AND 8.0" BY 2.0" BY 1SDR DHL2005742521Floorbeam · corrodedAFT PIT CEILING, CABIN FLOORBEAM STA 1130 UPPER SURFACE HAS CORROSION AT LBL 60. REMOVED FLOOR PANEL AT BS 1130. CUT OUT CORRODED AREA ON FLOORBEAM UPPER STA 1130 LBL 60. FABRICATED AND INSTALLED REPAIR 10.0" BY 2.0" BY 1.0" BY .30" FROM 7075-T6 .050, AND SSDR PIDA20050169Floorbeam · crackedCRACK IN RADIUS OF RBL 24 FLOORBEAM AT BS 520. REPAIRED PER SB 737-53-1120.SDR PIDA20050168Floorbeam · crackedCRACK IN RADIUS OF RBL 45.50 FLOORBEAM AT BS 520. REPAIRED PER SB 737-53-1120.SDR PIDA20050167Floorbeam · crackedCRACK IN RADIUS OF LBL 45.50 FLOORBEAM AT BS 520. REPAIRED PER SB 737-53-1120.SDR SWAA053032Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 328, LBL 39. REPAIRED FLOORBEAM PER SRM.SDR UPS05845690Floorbeam · crackedFOUND FLOORBEAM CRACKED 2" LONG AT FS 940 RBL 60 UPPER FLANGE AREA. CUT OUT DAMAGED AREA OF FLOORBEAM AT STA 940, RBL 60 IAW SRM TR# 53-152, FABRICATED AND INSTALLED REPAIR ANGLE AND FILLER IAW SRM TR# 51-1-21 FIG 1AND SRM 51-1-20D AT STA 940 RBL60.SDR SIMA200528303Floorbeam · corrodedTHE GALLEY FORWARD DIGITAL WAS FOUND TO BE CORRODED. PERFORMED A CUT OUT OF THE FORWARD DIGITAL TO REMOVE THE CORROSION. FABRICATED A FILLER AND DOUBLER. REPAIR DONE IAW SRM. (SW21200600333) (K)SDR DHL2005742517Floorbeam · corrodedAFT PIT CEILING, CABIN FLOORBEAM BS 1070 LOWER SURFACE HAS CORROSION AT LBL 14. REMOVED CORROSION IAW SRM 53-10-8. CORROSION REMOVAL INTO TANGENT OF RADIUS. FABRICATED AND INSTALLED REPAIR STRAP 13.3 INCHES FROM 7075-T6 .100 AND TEE FILLER FROM BAC1505-100797SDR AWXA200501229Floorbeam · crackedDURING C18 CHECK DISCOVERED CRACK, .25 INCHES IN LENGTH, ON FLOORBEAM AT BS 727B AND BL 45L. MAINTENANCE TRIMMED OUT CRACK AT BS 727B AND BL 45L IAW AMERICA WEST AIRLINES ENGINEERING REQUEST NR 03-5702-05284-SS2. FABRICATED FILLER, REPAIR STRAPS AND SHIMS IASDR UPS05845606Floorbeam · corrodedINSPECTION TYPE:C2 FLOORBEAM HEAVY CORROSION STA 940 LBL 60 UNDER THE SEAT TRACK. CUT OUT DAMAGED AREA OF FLOORBEAM IAW SRM 53-2-0 AND TEMP REV 53-152, FABRICATED AND INSTALLED REPAIR ANGLE AT STA 940 LBL 60 IAW SRM 53-2-0 TEMP REV 53-152, AND SRM 51-1-20D.SDR DHL2005742509Floorbeam · corrodedAFT PIT CEILING, CABIN FLOORBEAM BS 1070 LOWER SURFACE HAS CORROSION AT RBL 16. REMOVED CORRODED FLOORBEAM STA 1070 RBL 16 IAW B727 SRM 53-10-8. FABRICATED 2 EACH ANGLES 18 X .9 X .8 INCHES AND 12 X .8 X 1.2 INCHES FROM BAC 1490-2888 AND 1 EACH FILLER FROM 7SDR USAA051168Floorbeam · corrodedFOUND FLOORBEAM UPPER T-CAP AT CLIPNUT HOLE AT BL 0 AND STA 294 CORRODED. INSTALLED REPAIR T CAP IAW SRM 53-10-51 FIG 201, SHEETS 1-4, DEFECT SIZE: 1".SDR SWAA053019Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM UPPER CHORD CORRODED AT BS 312, BETWEEN LBL 12 TO RBL 12. REPAIRED FLOORBEAM PER SRM.SDR CALA0500326Floorbeam · corrodedINSPECTION FOUND SEVERAL NUT CLIP HOLES ON FLOORBEAM CORRODED AT STA 986.5, LBL 43-LBL 45. REPAIRED IAW ECRA 5321-01297.SDR 05FDEA03183Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER SURFACE STA 560 LBL 24-62. REMOVED, FABRICATED, AND REPLACED T-CAP, WEB AND STIFFENER IAW B727 SRM 53-10-8 FIG 3, 51-10-2 AND 51-30-2.SDR 05FDEA03182Floorbeam · corrodedUPPER CHORD FLOORBEAM AT FS 344 LBL 22.5 TO RBL 22.5 CORRODED. REMOVED, FABRICATED AND INSTALLED CHORD AND HAT-CHANNEL IAW FED-EX DRAWING SR-27-53-007 AND B727 SRM 51-30-2.SDR PIDA20050177Floorbeam · corrodedBS 967 FLOORBEAM HAS CORROSION FROM LBL 42 TO LBL 48. REPLACED DAMAGED SECTION OF FLOORBEAM PER EA 53-268.SDR PIDA20050156Floorbeam · crackedFLOORBEAM AT BS 520 IS CRACKED AT LBL24. REPAIRED FLOORBEAM PER 737 SB 53-1120.SDR 05FDEA03181Floorbeam · corrodedCORROSION ON FLOORBEAM AT STA. 344 FROM BL 12 L TO BL 12 R. REMOVED CORROSION FROM FLOOORBEAM UPPER CAP IAW FED-EX SRM 53-10- 1. REMOVED, FABRICATED AND INSTALLED SPLICES AND FLOORBEAM IAW SRDM SR27-53-007, B727 SRM 51-10-2,51-30-2.SDR USAA051154Floorbeam · corrodedFOUND FLOORBEAM CORRODED, STA 967 RBL 31. REMOVED DAMAGE AND INSTALLED NEW SPLICE DOUBLER AND CAP ON FLOORBEAM IAW TYPICAL REPAIR 53-10-05B, DEFECT SIZE: 1" BY 6".SDR ASAA0510334Floorbeam · corrodedYXX - UPPER CHORD OF BS 344 FLOORBEAM CORRODED FROM RBL 5-10, UNDER FASTENER HEADS AND ON SURFACE. REPLACED WITH REPAIR PARTS IAW B737-200 SRM 53-10-9. (M)SDR ASAA0510333Floorbeam · corrodedYXX - FOUND EXFOLIATING CORROSION FOUND ON UPPER CHORD OF FLOORBEAM. REPLACED WITH REPAIR PARTS IAW B737-200 SRM 53-10-9. (M)SDR SWAA053015Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, BL 0, WL 208. REPAIRED FLOORBEAM PER SWA EA.SDR CALA0500322Floorbeam · corrodedINSPECTION FOUND MAIN DECK FLOORBEAM CORRODED AT STA 344, LBL 16 TO RBL 9. THE SECTION OF FLOORBEAM WAS REPLACED IAW SRM 53-10-51.SDR 05FDEA03158Floorbeam · corrodedFLOORBEAM AT STATION 344 BL.0 CORRODED. RERAIRED FLOORBEAM IAW FED EX DWG SR 27-53-007.SDR CALA0500323Floorbeam · corrodedINSPECTION FOUND MAIN DECK FLOORBEAM CORRODED AT STA 328, RBL 42 TO LBL 35. THE FLOORBEAM SECTION WAS REMOVED AND REPLACED IAW SRM 51-10-02 AND 51-40-02.SDR 05FDEA03146Floorbeam · corrodedCORRODED FLOORBEAM FS 620 FROM LBL 24 - LBL 45 THREE HEAVY AREAS. REMOVED, FABRICATED, ALODINED, PRIMED, HEAT TREATED, CAD PLATED AND INSTALLED FLOORBEAM REPAIR AT STA 620 FROM LBL24-45 ALL IAW FX DWG SR27-53-034E REPAIR NR 4 B727SRM 51-10-2,BAC5619H AND ASDR 05FDEA03144Floorbeam · corrodedCORROSION AT BS 950 LBL 48-53 WL 207 AT UNDERSIDE OF FLOORBEAM . ALL WORK ACCOMPLISHED IAW FED EX EA 7-5310-91391.SDR 05FDEA03143Floorbeam · corrodedCORROSION AT FLOORBEAM BS 950 RBL 48-54 WL 208 AT NUT PLATE HOLES. REPAIRED FLOORBEAM PER FED EX EA 7-5310-91395.SDR 05FDEA03142Floorbeam · corrodedREMOVAL OF BL 0 TENSION STRAP ON FED EX CARD, FOUND CORROSION ON LWR FLANGE OF FLOORBEAM AT B/S 1148, WL 200 BL 0. REPAIRED FLOORBEAM AT B.S. 1148, BL0, WL 200 PER SRM 53-10-8.SDR SWAA052954Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 328, LBL 27, WL 208. REPAIRED FLOORBEAM PER SRM.SDR SWAA052951Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 294, RBL 25, WL 208. REPAIRED FLOORBEAM PER SRM.SDR SWAA052950Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 328, BETWEEN RBL 45 TO RBL 52, WL 208. REPAIRED FLOORBEAM PER SRM.SDR ASAA0540512Floorbeam · puncturedOKC - FOUND FLOORBEAM BS 947 CORRODED AROUND FASTENER HOLES AT LBL 45, RBL 45. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PIECES IAW ASA EO 5310-02500. (M)SDR ASAA0540514Floorbeam · corrodedOKC - FOUND FLOORBEAM STATION 986.5 CORRODED ON UPPER CHORD. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PIECES IAW ASA EA 5310-02498. (M)SDR SWAA052937Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986, BETWEEN LBL 65 TO RBL 65, WL 208. REPAIRED FLOORBEAM PER SRM.
Back to JASC 5315