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 ASAA0410471Floorbeam · corrodedOKC - FLOORBEAM CORRODED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR CHORD SECTION AND REPAIR ANGLES IAW SRM.SDR ASAA0410468Floorbeam · corrodedOKC- FLOORBEAM HAS CORROSION ON FORWARD FLANGE. REMOVED DAMAGE, FLAP PEENED, FABRICATED AND INSTALLED REPAIR STRAP SECTION IAW EA.SDR SWAA043215Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH FLOORBEAM WEBS CRACKED AT BS 243, RBL 14 AND LT BS 188 TO LT BS 196. REMOVED AND REPLACED FLOOR WEB SECTIONS PER SRM.SDR ASAA0410466Floorbeam · corrodedOKC - STA 328 FLOORBEAM CORRODED AT RBL 11. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLER AND ANGLES IAW SRM.SDR QXEA200400747Floorbeam · crackedPDX - FLOOR SUPPORT BEAM AT X280 IS CRACKED AT BOTH LEFT HAND AND RIGHT HAND SIDES OF COCKPIT ENTRANCE. REPAIRED IAW REO 670-51-11-045.SDR C2XA04SH545Floorbeam · corrodedDURING C-CHECK BAGGAGE DOOR LOWER BEAM FOUND CORRODED. REPLACED THE LOWER BEAM IAW 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR 72300149Floorbeam · corrodedTWO 1 X 1 INCH AREAS OF CORROSION ON FLOORBEAM CHORD.SDR ASOA04926Floorbeam · corrodedDURING C-CHECK INSPECTION, THE UPPER FLANGE OF FLOORBEAM 41 BETWEEN STRINGERS 17R AND 21R WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CORODED FLOORBEAM IAW SRM 51-25-01.SDR ASOA04925Floorbeam · corrodedDURING C-CHECK INSPECTION, CORROSION BEYOND LIMITS WAS FOUND ON FLOORBEAM 39 IN SEVERAL PLACES. MAINTENANCE REMOVED AND REPLACED THE CORRODED FLOORBEAM IAW SRM 51-25-01.SDR ASOA04921Floorbeam · corrodedDURING C-CHECK INSPECTION, THE TOP FLANGES OF FLOORBEAMS 38 AND 40 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CORRODED FLOORBEAM TOP FLANGES IAW 51-25-01.SDR ASOA04918Floorbeam · corrodedDURING A C-CHECK INSPECTION, CORROSION BEYOND LIMITS WAS FOUND ON A FLOORBEAM 36. MAINTENANCE REMOVED AND REPLACED THE CORRODED FLOORBEAM IAW SRM 51-25-01.SDR C2XA04SH546Floorbeam · corrodedDURING C-CHECK THE CARGO DOOR CUTOUT LOWER FLOORBEAM WAS FOUND TO BE CORRODED. REPLACE THE BEAM IAW 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR SWAA043188Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM LOWER CHORD AT BS 616, LBL 64, CRACKED. REPAIRED FLOORBEAM CHORD PER ER.SDR SWAA043185Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 967, RBL 17, RBL 27, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA043181Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM WEB AT BS 664, BL 0, CRACKED. REMOVED AND REPLACED FLOORBEAM WEB SECTION PER EA AND SB.SDR SIMA200431006Floorbeam · corrodedDURING AN IMBV INSPECTION THE FORWARD DIGITAL CENTER SECTION WAS FOUND CORRODED. PERFORMED A CUT OUT OF THE DAMAGED AREA. FABRICATED 2 REPAIR DOUBLER AND SHIMS. REPAIR DONE IAW SRM. (SW21200501161)SDR SWIA200414221Floorbeam · corrodedINTERCOSTAL FLOORBEAM JUST AFT OF FRAME 15 FROM Y479.00L TO EDGE OF DOOR IS CORRODED. FLOORBEAM REPLACED IAW SRM 51-40-02 & 51-22-00.SDR UPS04443475Floorbeam · crackedINSPECTION TYPE:C, U/D BS 330 RBL 61 FLOORBEAM UPPER CHORD FOUND CRACKED AS MARKED. U/D - BS 330 RBL 58 TO MOST O/B FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 2.SDR CALA0400693Floorbeam · corrodedINSPECTION FOUND UPPER AND LOWER SURFACES OF FLOORBEAM UPPER CAP CORRODED AT STA 344, RBL 10-LBL 20. THE FLOORBEAM CHORD WAS REPAIRED IAW SRM 53-10-51, FIGURE 205.SDR USAA040965Floorbeam · corrodedBFM - S1 - FLOORBEAM- 2 INCHES X 1.5 INCHES X .04 INCH AREA; CORROSION; LEVEL 2; TASK NR JA-260-53500-012, Y1292, BTW C68 AND C69 MAIN CABIN FLOOR. REMOVED AND REPLACED FLOOR BEAM IAW SRM 53-00-14, SRM 51-42-11.SDR USAA040960Floorbeam · corrodedBFM - S1 - BEAM, 18 INCHES X 2 INCHES X .03 INCH AREA, CORROSION; LEVEL 2; TSK NR JA 260-53500-004, MAINT CABIN FLOOR Y1292 BET C66 AND C68. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR SIMA200431002Floorbeam · corrodedDURING AN IMBV INSPECTION THE GALLEY FLOOR AREA FORWARD DIGITAL WAS FOUND CORRODED. REMOVED THE EXISTING FORWARD DIGITAL. INSTALLED NEW DIGITAL. REPAIR DONE IAW SRM.SDR MALA040791Floorbeam · corrodedDURING C-CHECK INSPECTION, MAINTENANCE FOUND CORROSION ON FLOORBEAM AT FRAME 18. REPAIRED IAW EO A53026. AIRCRAFT RETURNED TO SERVICE 11/08/04.SDR UPS04843523Floorbeam · corrodedFLOORBEAM AT STA 55 RBL40 CORRODED BEYOND LIMITS. CUT OUT CORRODED AREA, NDT VERIFIED REF NDT SPM06-10-01.001 FABRICATED 2 FILLERS FROM 7075T6-.071. REPAIR ANGLE FROM AND 10136-2403, SPACER FROM 2024T3-.032. INSTALLED ALL REPAIR PARTS REF SRM 53-2-0 FIG1 F,SDR SWIA200414055Floorbeam · crackedFS 280 RIGHT FLOORBEAM RBL 9.0 INBOARD AND OUTBOARD ANGLES CRACKED. ITEM FOUND AT C-CHECK INSPECTION. INBOARD AND OUTBOARD ANGLES REMOVED IAW CRJ SRM 51-40-11, ANGLES REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-23-00, 51-21-11.SDR SWIA200414054Floorbeam · crackedFS 280 LT FLOORBEAM LBL 9.0 INBOARD AND OUTBOARD ANGLES CRACKED. ITEM FOUND AT C-CHECK INSPECTION. ANGLES REPLACED IAW CRJ SRM 51-40-11, 51-42-00, 51-42-21, 51-23-00, 51-21-11.SDR ASA0440225Floorbeam · damagedOVERSIZED HOLES IN LOWER FLANGE OF FLOORBEAM. REPAIRED FLOORBEAM.SDR ASA0440195Floorbeam · corrodedCORROSION ON FLOORBEAM. REMOVED CORRODED UPPER CHORD, FABRICATED REPAIR PARTS AND INSTALLED.SDR UPS04443443Floorbeam · crackedINSPECTION TYPE: C, U/D BS 330, BET STR 13-14R, APPROX RBL 70-75 FLOORBEAM WEB FOUND CRACK. U/D FLOORBEAM WEB REPAIRED AS PER SRM 53-10-07 FIG 11.SDR USAA040961Floorbeam · corrodedBFM - S1 - BEAM, 3 INCHES X 2 INCHES X .030 INCH AREA, CORROSION; LEVEL 2; TASK NR JA-260-53500; MAIN DECK FLOOR RAIL, FRAME 68, -Y765. REMOVED AND REPLACED FLOORBEAM IAW SRM 53-00-14, 51-42-11.SDR ASAA0410458Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM LOWER FLANGE, LOWER SURFACE. REPAIRED WITH DOUBLER.SDR ASAA0410455Floorbeam · corrodedOKC- FLOORBEAM HAS CORROSION ON UPPER AND LOWER SURFACES OF TOP FLANGE. REMOVED DAMAGE, FABRICATED, AND INSTALLED REPAIR FILLER SHIM, AND REPAIR ANGLES IAW SRM.SDR ASAA0410454Floorbeam · corrodedOKC - FLOORBEAM CORRODED. REMOVED DAMAGE, FABRICATED, AND INSTALLED REPAIR FILLER SECTION, SUPPORT ANGLES, AND REPAIR STRAPS IAW SRM.SDR 2004UALA00990Floorbeam · corrodedAFT MAIN CABIN FLOORBEAM CORRODED BS 1640 JUST FWD OF R-2 DOOR LOWER SILL. MAJOR REPAIR ACCOMPLISHED. TYPICAL CORROSION DAMAGE. FABRICATED & INSTALLED T-CAP SPLICE SECTION AND REPAIR ANGLES.SDR A6WA200440170Floorbeam · crackedFS 280 UNDER FLOORBEAM AT RBL 12 AND WL 69 LOWER FLANGE IS CRACKED. CUT AWAY DAMAGED SECTION OF FLOOR ANGLE, PERFORMED LPI TO ENSURE NO CRACKS EXIST. FABRICATED REPAIR ANGLE AND FILLER FROM S-6744-3 AND S6744-13 AND INSTALLED WET USING SOLID RIVETS AND LOCK SDR A6WA200440171Floorbeam · crackedFS280 UNDER FLOORBEAM AT LBL 12 AND WL 69 LOWER FLANGE IS CRACKED. CUT AWAY DAMAGED SECTION OF FLOOR ANGLE, PERFORMED LPI TO ENSURE NO CRACKS EXIST. FAB REPAIR ANGLE AND FILLER FROM S-6144-3, S-6144-13 AND INSTALLED WET USING SOLID RIVETS AND LOCK FASTENERS.SDR UPS04443489Floorbeam · crackedINSPECTION TYPE:C RIGHT BS 360 UPPER DECK FLOORBEAM ONE FASTENER HOLE CRACK FOUND AT FRAME WEB BS 360, WL 280 TO 320. BS 360 RT FRAME WEB CRACKED AREA REPAIRED PER HX RS R53-15-35211 BY CRACKED FRAME WEB DOUBLER REPLACED & FRAME WEB REINFORCEMENT PER THE HX RSDR UPS04443484Floorbeam · crackedINSPECTION TYPE: C, LT BS 360 UPPER DECK FLOORBEAM ONE EA FASTENER HOLE CRACK REVEALED AT FLOORBEAM WEB AND FRAME WEB DOUBLER LAYER FOR DETAILS BS 360, WL 280 TO 320. LEFT BS 360 FLOORBEAM WEB & FRAME WEB CRACK REPAIRED AND FLOORBEAM WEB SECTIONAL REPLACED PESDR UPS04443480Floorbeam · crackedINSPECTION TYPE: C, RIGHT BS 340 UPPER DECK FLOORBEAM, ONE HOLE CRACK FOUND AT FRAME WEB. ONE HOLE CRACK FOUND AT FLOORBEAM WEB BS 340 WL 280 TO 320. RIGHT BS 340 UPPER DECK FLOORBEAM WEB & FRAME WEB REPAIRED AS PER HX RS R53-15-35211 AND UPS EO B747-5310-21SDR UPS04443460Floorbeam · crackedINSPECTION TYPE:C, LT BS 340 WL 280-320 UPPER DECK FLOORBEAM ONE EA FASTENER HOLE CRACK REVEALED AT FLOORBEAM UPPER CHORD AND STRAP LAYER. FLOORBEAM REPAIRED AS PER SRM 53-10-07 FIG 23 PLUS SB 747-53A2459 REV 1 PART 3 MODIFICATION.SDR 2004UALA00993Floorbeam · corrodedAFT MAIN CABIN FLOORBEAM CORRODED, BS 1660 MID-SECTION DOOR R-4, LOWER SILL. INSTALLED T-CAP SPLICE AND ANGLE REPAIR.SDR ASAA0410453Floorbeam · corrodedOKC - RT SIDE STA 948 FORWARD FLOORBOARD STRIP ANGLE RBL 44 FASTENER HOLES AND LOWER SIDE FLOORBEAM HAS CORROSION. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR STRAP, FILLER AND WASHERS IAW EA.SDR SWAA043133Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM FWD FLANGE AT BS 946, LBL 54, CRACKED. REPAIRED FLOORBEAM PER EA.SDR CV2XA04SH533Floor Support · corrodedDURING C-CHECK, THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED. REMOVED THE DAMAGED AREA AND INSTALLED A DOUBLER REPAIR IAW 53-21-10 AND EC 5320-01168. AIRCRAFT RETURNED TO SERVICE.SDR ASA0440191Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE. REMOVED UPPER FLANGE OF FLOORBEAM, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0410451Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM LWR CHORD. REPAIRED FLOORBEAM LWR CHORD IAW EA.SDR ASAA0410452Floorbeam · corrodedOKC - CORROSION ON FLOORBEAM TOP FLANGE. REMOVED CORROSION, OUT OF LIMITS IAW SRM. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PARTS IAW SRM.SDR USAA040770Floorbeam · corrodedCLT, C-4, FLOORBEAM, SEVERAL .5 INCH AREAS, CORROSION LEVEL 2, STA 365, BL0 TO RBL12. INSTALLED TEE CAP REPAIR IAW SRM 53-00-51.SDR USAA040769Floorbeam · corrodedFLOORBEAM, 6 INCHES BY 2 INCHES, CORROSION LEVEL 2, STA 310, RBL 42. REPAIRED FLOORBEAM SECTION IAW EA 95898.SDR ASOA04837Floorbeam · crackedDURING A C-CHECK, THE FLOOR SUPPORT BEAMS AT FS 621 ON THE LT AND RT SIDES WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE FLOOR SUPPORT BEAMS AT FS 621 ON THE LT AND RT SIDES IAW EO 600-53-0105.
Back to JASC 5315