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 2004UALA00652Floorbeam · corrodedCABIN FLOORBEAM AT AFT GALLEY STA 1681 LBL 36 CORRODED AROUND SCREW HOLES. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE AND FABRICATED FLOORBEAM CAP AND INSTALLED.SDR 2004UALA00651Floorbeam · corrodedCABIN FLOORBEAM IS CORRODED AT STA 1640, RBL 62 TO CREASE BEAM. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE AND STRAP REPAIR.SDR SWAA041956Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 294.5, RBL 45, CORRODED. REPAIRED FLOORBEAM PER SRM.SDR AWXA200400773Floorbeam · corrodedDURING B-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 LT BETWEEN FR 67 AND FR 68. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 LT FROM FR 67 TO FR 68. FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW SRM 51-72-11, PG. 1-SDR C2XA04SH455Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR UPS04442827Floorbeam · crackedINSPECTION TYPE: C, RIGHT BS 340 WL 300 UPPER DECK FLOORBEAM FOUND 1 EACH FASTENER HOLE CRACKED AT FRAME WEB. RIGHT BS 340 UPPER DECK FLOORBEAM AREA FRAME WEB CRACK REPAIRED AS PER RS R53-12-35177 AND EO B747-5310-20786-A.SDR UPS04442826Floorbeam · crackedINSPECTION TYPE: C, LT BS 340 WL 300 UPPER DECK FLOORBEAM FOUND 1 FASTENER HOLE CRACKED AT FRAME WEB. LT BS 340 UPPER DECK FLOORBEAM AREA FRAME WEB CRACK REPAIRED AS PER RS R53-12-35177 AND EO B747-5310-20786-A.SDR DHL2004804524Floorbeam · crackedMAIN CARGO COMPT BEAM WEB CRACK 2.500, STA 960.000 RBL 59 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW DC8 SRM 53-7-3 PG 17-18, DC8 SRM 51-2-0 PG 78, DC8 SRM 51-2-1 (TR 51-130) JAN 26-04 FIG 1. REMOVED FASTENERS IAW DC8 SRM 51-1-20D PG 21. PERFORMED STOP HOLESDR SWIA200413625Floorbeam · crackedFS 280 RIGHT HAND FLOORBEAM RBL 9.0 O/B ATTACH ANGLE CRACKED. ITEM FOUND AT C-CHECK.SDR 0401166729Floorbeam · crackedDURING L-CHECK AND ARMAR FOUND CRACK IN FLOORBEAM WEB AT BS 380 BETWEEN S12L & S13L. REPAIRED PER EA 67-165144.SDR UPS04842892Floorbeam · crackedINSPECTION TYPE: C3, CABIN OVERWING AREA FS 960 FLOORBEAM CRACKED UNDER CUSP LOWER SIDE OF LIGHTENING HOLE RT. REMOVED DOUBLE SEAT TRACK & SPLICES. REMOVED WEB, GRILL & FASTENERS FROM FLOORBEAM. CUT OUT DAMAGED FLOORBEAM IAW DC8 REO GO9893 MAT ID FOR SPLICESDR 2004UALA00646Floorbeam · corrodedFLOORBEAM CAP AT BS 1681 RBL 45-60 CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED A REPAIR ANGLE SPLICE.SDR DL757040635Floorbeam · damagedFUSELAGE FLOORBEAM AT STA 324 AND RBL 63 TO LBL 10 UPPER WEB AND CAP SUFFERED TOOLING DAMAGE AND OVERSIZED FASTENER HOLES. REPAIR IAW ERA 091387-14.SDR SWAA041918Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 986.5, BL 0 TO RBL 18, CORRODED. REPAIRED FLOORBEAM SECTION PER SRM.SDR SWAA041903Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAMS AT BS 328 AND BS 344, RBL 10 TO RBL 59, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTIONS PER SRM.SDR M562004F00006Floorbeam · corrodedSURFACE CORROSION ON FLOORBEAM AT STA 348, 15 INCHES LT AND RT OF BL0. REMOVED CORROSION AND TREATED REPAIRED AREA. C1, C2, C3 INSP 8/4/04.SDR C2XA04SH420Buttstrap · corrodedSHV - DURING C-CHECK THE CENTER BUTTSTRAP AT FRAME 59-61 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH415Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM JUST FORWARD OF FRAME 61 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EC5320-01129. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA041887Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 375, RBL 65, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA041885Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 947, LBL 53, CRACKED. REMOVED AND REPLACED FLOORBEAM SECTION PER ER.SDR 04FDEA01920Floorbeam · crackedFWD CARGO PIT FLOORBEAM AT BS 652 IS CRACKED. CUT OUT DAMAGE, FABRICATED REPAIR PARTS LOCATED AND DRILLED IAW DC10 SRM 53-00-01 VOL 1. ALODINED AND PRIMED IAW DC10 SRM 51-21-01 VOL 2, INSTALLED REPAIR PARTS IAW DC10 SRM 53-00-01 VOL 1.SDR 04FDEA01930Floorbeam · crackedFLOORBEAM CRACKED UNDER CENTER ROLLER TRAY AT ATTACH POINT STATION 840 LBL 2. FABRICATED AND INSTALLED REPAIR COMPONENTS IAW DC10 SRM 53-00-01 VOL I, 53-00-01 VOL I, AND 51-21-01 VOL 2.SDR 04FDEA01931Floorbeam · crackedFORWARD CARGO PIT FLOORBEAM AT FUSELAGE STATION 652 IS CRACKED. FABRICATED AND INSTALLED REPAIR PARTS IAW DC10 SRM 53-12-01 VOL 3, 53-00-01 VOL I AND 51-21-01 VOL 2.SDR 04FDEA01933Floorbeam · crackedFORWARD CARGO PIT FLOORBEAM AT FUSELAGE STATION 775 IS CRACKED. REMOVED CENTER ROLLER TRAY FOR ACCESS. FABRICATED REPAIR FILLER ANGLE, REPAIR ANGLE AND CUT OUT DAMAGED AREA IAW DC10 SRM 53-00-01 VOL I. INSTALLED REPAIR PARTS AT STATION 775 FLOORBEAM IAW DC1SDR 151AW0002Floorbeam · crackedEXISTING DOUBLER AT RIGHT FWD SIDE OF BS 540 FLOORBEAM AT BL 0 CRACKED AND UNDERSIDE OF BS 540 LINK BEAM AT BL 0 CRACKED. REPLACED LINK BEAM AND LEFT AND RIGHT CHANNELS ON FLOORBEAM PER SRM 53-60-51 AND SRM 51-40-02.SDR C2XA04SH413Buttstrap · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM BUTTSTRAP WAS FOUND TO BE CORRODED FROM FRAME 24 TO 36. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH409Strap · corrodedSHV - DURING C-CHECK THE FORWARD DIGITAL WAS FOUND TO BE CORRODED FROM FRAME 17 TO 18. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10, STEP 4, FIG 203. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH408Strap · corrodedSHV - DURING C-CHECK THE FORWARD DIGITAL A FRAME 14 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10, STEP 4, FIG 203. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA041876Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 500C + 16, RBL 13.8, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR C2XA04SH406Buttstrap · corrodedSHV - DURING C-CHECK THE LEFT HAND OMEGA BEAM BUTTSTRAP WAS FOUND TO BE CORRODED FROM FRAME 24 TO FRAME 36. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH403Buttstrap · corrodedSHV - DURING C-CHECK THE RIGHT HAND OMEGA BEAM BUTTSTRAP WAS FOUND TO BE CORRODED AT FRAME 61 IN THE LAV. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2004UALA00630Floorbeam · corrodedCABIN FLOORBEAM CORRODED BEYOND LIMITS AT BS 1640, RBL 12R-14R. *S/D* MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM WITH ANGLE AND STRAP.SDR C2XA04SH417Floorbeam · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 19. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04TY106Floorbeam · corrodedDURING A SCHEDULED 3C INSPECTION THE LEFT INBD FLOOR SUPPORT WAS FOUND CORRODED AT BOTTOM OF RAMP IN GALLEY. MAINT CUT OUT DAMAGE AND FAB A NEW REPAIR FOR THE EFFECTED AREA AND INSTALL NEW REPAIR PART IAW EMB 135/145 SRM 53-21-10; 53-21-03 AND 51-40-06 ALSO CSDR C2XA04TY104Floorbeam · corrodedDURING A SCHEDULED 3C INSPECTION, CORROSION WAS FOUND ON THE RIGHT LAV FLOORBEAM TOP CAP IN SEVERAL PLACES. MAINT REMOVED AND REPLACED THE RIGHT TOP CAP IAW EMB 135/145 SRM 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE RELEASED UPON COMPLETION OF ALL WORK.SDR EIA2004095Floorbeam · damagedFLOORBEAM MAIN CABIN BS 1740 RBL 33-99 HAS 4 ELONGATED HOLES COMMON TO SEAT TRACK. REMOVE DAMAGED SECTION OF TEE CHORD BEAM BS 1740 RBL 33.99 & REPLACE WITH NEW SECTION PER B747 SRM 53-10-07 & 51-30-02SDR ASAA0410280Floorbeam · corrodedPAE - FOUND CORROSION ON LOWR CHORD FLOORBEAM. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED IAW EA5310-02377. (M)SDR SWIA200413624Floorbeam · crackedCARGO PIT FLOORBOARD SUPPORT ANGLE IS CRACKED; FS 621.00 RBL 40. ITEM FOUND AT C-CHECK.SDR C2XA04SH454Floorbeam · corrodedSHV - DURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 53-21-10, STEP 2, FIG 201, SHEET 1. THE AIRCRAFT WILL BE APPROVED FOR RETURN TO SERVICE UPON COMPLETSDR C2XA04SH434Floorbeam · corrodedSHV - DURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10, STEP 2, FIG 201 SHEET 2. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA041840Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 773, RBL 3 TO LBL 17, CORRODED. REPAIRED FLOORBEAM PER EA.SDR C2XA04SH400Floorbeam · corrodedSHV - DURING C-CHECK THE RIGHT HAND OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 19. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10 FIGURE 207. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR IXXA060278SFloorbeam · crackedDURING ROUTINE C CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT STATION Y1542, -X37 TO -X43. REPAIRED PER ALL APPLICABLE DATA.SDR CALA0400557Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 42. THE CORROSION WAS REMOVED AND A STRAP WAS INSTALLED IAW ECRA 5321-01196.SDR C2XA04TY101Floorbeam · corrodedDURING A SCHEDULED C-CHECK INSPECTION, CORROSION WAS FOUND THE FLOOR CROSSBEAM ANGLE AT FRAME 23. THE CROSSBEAM ASSEMBLY WAS REMOVED AND REPLACED IAW EMB SRM AND THE ACFT WAS SUBSEQUENTLY RELEASE FOLLOWING THE COMPLETION OF THE C- CHECK INSPECTION.SDR C2XA04SH428Buttstrap · corrodedSHV - DURING C-CHECK THE LEFT OMEGA BEAM BUTTSTRAP WAS FOUND TO BE CORRODED FROM FRAME 29-37. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH427Buttstrap · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM BUTTSTRAP WAS FOUND TO BE CORRODED FROM FRAME 29-37. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH4426Buttstrap · corrodedSHV - DURING C-CHECK THE CENTER OMEGA BEAM BUTTSTRAP WAS FOUND TO BE CORRODED FROM FRAME 39-45. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH425Buttstrap · corrodedSHV - DURING C-CHECK THE LEFT OMEGA BEAM BUTTSTRAP WAS FOUND TO BE CORRODED FROM FRAME 53-58. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA041819Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 947.5, LBL 53.52, CRACKED. REPAIRED FLOORBEAM CHORD PER ER.
Back to JASC 5315