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 SWAA040208Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT BAGGAGE BIN FLOORBEAM CORRODED AT BS 945, RBL 3. FLOORBEAM REPAIRED PER EA.SDR C2XA04SH024Buttstrap · corrodedSHV-DURING C-CHECK THE LEFT OMEGA BEAM BUTTSTRAP BETWEEN FRAMES 58 AND 59 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 C2XA04SH023Floorbeam · corrodedSHV- DURING C-CHECK THE ATTACHMENT ANGLE BETWEEN THE RIGHT SILL AND THE CROSS BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE ATTACHMENT ANGLE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR RAIA00401050Floorbeam · corrodedSTL - DURING BLOCK CHECK FOUND LEFT HAND FLOORBEAM CORRODED. MAINTENANCE REPAIRED LEFT HAND FLOORBEAM IAW SRM 5321-10.SDR RAIA00401049Floorbeam · corrodedSTL - DURING BLOCK CHECK FOUND CORROSION ON LEFT HAND DIGITAL. MAINTENANCE REMOVED AND REPLACED LEFT HAND DIGITAL.SDR AWXA200400138Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON FLOORBEAM AT BS 328, BETWEEN RBL 24 AND RBL 45. MAINTENANCE REMOVED DAMAGED SECTION OF FLOORBEAM UPPER TEE CAP AT BS 328, BETWEEN RBL 24 AND RBL 45; FABRICATED A NEW REPLACEMENT UPPER TEE CAP AND 4SDR AWXA200400130Floorbeam · corrodedDURING C-15 CHECK INTERGRANULAR CORROSION WAS FOUND ON MAIN CABIN FLOORBEAM BELOW FORWARD LAVATORY AT BS 300, LBL 10. MAINTENANCE REMOVED CORRODED SECTION OF FLOORBEAM AT BS 300, LBL 10; FABRICATED 8 EACH REPAIR ANGLES; INSTALLED REPAIR PARTS IAW B737-200 SRMSDR AALA20040129Floorbeam · corrodedAFW FLOORBEAM AT STATION BS 347 RBL 43 HAD .90 INCH BY .90 INCH, .045 INCH DEPTH CORROSION BLENDED BEYOND SRM LIMITS. REMOVE CORROSION. APPLY CORROSION PREVENTATIVE COMPOUND TO BARE ALUMINUM SURFACE OF REPAIR AREA. FABRICATE REPAIR STRAP FROM .050 INCH THINK SDR SWAA040192Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 663.75, BL 0. REPAIRED FLOORBEAM WEB PER ER.SDR ASAA0440003Floorbeam · corrodedGYR - DURING MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM AT STATION 967. REPAIR IAW EA. (M)SDR AWXA200400124Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-15 CHECK INTERGRANULAR CORROSION WAS FOUND ON UPPER SURFACE OF AFT CABIN FLOORBEAM AT BS 986, LBL 18 TO RBL 44. MAINTENANCE REMOVED FLOORBEAM UPPER TEE CAP AT BS 986, LBL 18 TO RBL 44; FABRICATED A NEW REPLACEMENT TEE CAP; INSTALSDR SWAA040181Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT BAGGAGE BIN FLOORBEAMS CORRODED AT BS 770, LBL 8, BS 857, RBL 8 TO RBL 3, BS 857, LBL 12. REPAIRED AFT BAGGAGE BIN FLOORBEAMS PER EA.SDR CALA0400043Floorbeam · corrodedINSPECTION FOUND MAIN CABIN FLOORBEAM UPPER AND LOWER SURFACES CORRODED AROUND SCREW HOLES AT STA 986.5, RBL 0 TO RBL 50. THE CORRODED SECTION OF FLOORBEAM UPPER CHORD WAS REMOVED AND A NEW REPAIR CHORD WAS INSTALLED IAW ECRA 5310-03851.SDR SWAA040168Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM CORRODED AT BS 727 + 6, RBL 3 TO RBL 14. REPAIRED FLOORBEAM PER EA.SDR C2XA04TY018Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE CENTER FLOORBEAM AT THE CARBON FIBER GALLEY FLOOR SUPPORT. MAINTENANCE ACCOMPLISHED A BLEND OUT REPAIR IAW EMB MM 53-21-10 AND CPM 51-21-04/05/06, SRM 53-21-10, 51-40-02. THE REPAIR WAS SATISFACTOSDR DL73S040046Floorbeam · crackedDURING ACCOMPLISHMENT OF 03-062982-03AD THE UPPER CHORD OF THE BL 0.07 FLOORBEAM WAS FOUND SEVERED AT A TYPICAL LOCATION (BS 661) AND A CRACK INDICATION AT BS 665, BS 669 AND BS 673. DAMAGE WAS REPAIRED AS PER ERA 385959-14AD.SDR C2XA04TY016Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE CENTER FLOORBEAM TOP CAP AT FRAME 58. MAINTENANCE REMOVED AND REPLACED THE TOP CAP IAW EMB SRM 51-40-02, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR C2XA04TY015Floorbeam · corrodedDURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE CENTER FLOORBEAM AT FRAME 19. MAINTENANCE REMOVED AND REPLACED THE CENTER FLOORBEAM IAW EMB SRM 51-40-02 AND CPM 51-21-04, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF SDR C2XA04TY014Floorbeam · corrodedDURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE RAMP ANGLE AT THE CENTER FLOORBEAM OF FRAME 18. MAINTENANCE REMOVED AND REPLACED THE RAMP ANGLE IAE EMB SRM 51-40-02, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPESDR 04FDEA00179Floorbeam · corrodedMAIN CARGO DECK RT STA 1912 FLOORBEAM CORRODED BETWEEN FLOOR SUPPORT AT 53.5 FROM CENTER LINE AND SEAT TRACK 89.5. CORRODED FLOORBEAM SUPPORT BETWEEN FLOOR SUPPORT AT 53.5 FROM CENTER LINE AND SEAT TRACK 89.5 AT MAIN CARGO DECK RT STA 1912 REMOVED AND REPLACESDR DL73S040038Floorbeam · crackedDURING INSPECTION OF THE BS 520 FLOORBEAM, CRACKS WERE NOTED IN THE RADIUS OF THE UPPER CHORD AT LBL 24.75, 45.5 AND RBL 45.5. EACH CRACK WAS APPROXIMATELY 2 INCHES IN LENGTH. UPPER CHORD WAS CUT OFF AND A NEW SECTION SPLICED IN PER ERA 385945-14.SDR RAIA00401026Gusset · corrodedDURING BLOCK CHECK FOUND CENTER FLOORBEAM GUSSET CORRODED BEYOND BLEND LIMITS. MAINTENANCE REMOVED AND REPLACED CENTER FLOORBEAM GUSSET.SDR RAIA00401021Floorbeam · corrodedMX-STL- DURING HEAVY CHECK FOUND LT FLOORBEAM WITH CORROSION BEYOND BENDABLE LIMITS. REMOVED AND REPLACED LT FLOORBEAM.SDR RAIA00401020Floorbeam · corrodedMX-STL- LEFT FLOORBEAM AT FRAME 20 CORRODED BEYOND BLENDABLE LIMITS. REPAIRED LT FLOORBEAM AT FRAME 20 IAW EMB 145 SRM 53-21-10.SDR SWAA040153Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 859, RBL 8 TO LBL 3. REPAIRED BEAM PER EA.SDR USAA040025Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY .5 INCH AREA, STATION 283, RBL 88 TOP OF FLOORBEAM. CUT T-CAP OUT AND FABRICATED NEW CAP PER SRM 53-00-51. (M)SDR ASAA0410031Floorbeam · corrodedOAK - DURING SCHEDULED D-CHECK, FOUND CABIN FLOORBEAM AT STATION 500A TOP SIDE CORRODED FROM RBL 4 TO RBL 23. REPAIR IAW EA. (M)SDR COMA0460045Floorbeam · corrodedFLOORBEAM CAP AT FS 559+12 TO 620 AT LBL 27 CORRODED. REMOVED AND REPLACED CAP IAW WVAC EO 601R-53-4581.SDR ASAA0410027Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 807, LEFT BUTTOCK LINE 62.5- RIGHT BUTTOCK LINE 62.5 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0410029Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 847, RIGHT BUTTOCK LINE 24.75, RIGHT BUTTOCK LINE 61 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR F3LA200300193Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED CORROSION ON NUT PLATE HOLES ON FLOORBEAM UPPER CAP AT STA 947.5. REPAIRED DAMAGED SECTION OF FLOORBEAM UPPER CAP AT STA 947.5 PER EA B3-53R-10270.SDR F3LA200300192Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM CAP FROM L2 DOOR MOP SILL TO 20 INCHES INBOARD, STA 986.5. REPAIRED FLOORBEAM CAP PER EA B3-53R-10275.SDR 04FDEA00136Floorbeam · corrodedCABIN - FLOORBEAM CORRODED AT STA 5/73 RIGHT X = 47.5 TO 75.25. CORRODED FLOOR SUPPORT AT CABIN STA 5/73 RT X = 47.5 TO 75.25 REMOVED AND REPLACED WITH FABRICATED FLOOR SUPPORT AS PER DWG AEA736 AND AS PER SRM 51-35-01 VOL II.SDR ASAA0410025Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 360, RIGHT BUTTOCK LINE 19, RIGHT BUTTOCK LINE 52 CORRODED. REPAIRED FLOORBEAM PER SRM. (M)SDR ASAA0410023Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 727B, LEFT BUTTOCK LINE 60, RIGHT BUTTOCK LINE 41 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0410018Floorbeam · damagedOKC - DURING SCHEDULED D-CHECK, FOUND AFTER ACCOMPLISHING A FLOORBEAM REPAIR, THE SHEAR WEB AT FUSELAGE STATION 500A, LEFT BUTTOCK LINE 24 HAS MISALIGNED HOLES. REPAIRED SHEAR WEB PER EA. (M)SDR UPS04241778Floorbeam · corrodedINSPECTION TYPE: C, LIGHT SURFACE CORROSION AROUND SOME ANCHOR NUT ATTACH POINTS AT CABIN FLOOR STRUCTURE FROM BS1130 - BS 1183. CORROSION REMOVED IAW SRM 51-10-6. HFEC AREA NDF. AREA FLAP PEENED I AW SOPM 20-10-30. REPAIR CARRIED OUT IAW MFG INSTRUCTIOSDR C2XA04SH015Floorbeam · corrodedDURING C CHECK THE LT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A SHIM AND FILLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04TY009Floorbeam · corrodedDURING A SCHEDULED INSPECTION, CORROSION WAS FOUND ON THE RT OMEGA BEAM TOP CAP AT FRAME 59. MAINTENANCE REMOVED AND REPLACED THE RT OMEGA BEAM TOP CAP IAW EMB SRM 51-40-02, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECSDR ASAA0410017Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 947, LEFT BUTTOCK LINE 24.75, RIGHT BUTTOCK LINE 24.75 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR SWIA200412836Floorbeam · crackedCARGO PIT FS 621.00 RBL 42.0 FLOORBEAM ANGLE IS CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED DAMAGE IAW CRJ REO 601R-53-61-117 REV-A.SDR ASAA0410015Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 540-727B, RIGHT BUTTOCK LINE 44 CORRODED. REPLACED FLOORBEAM PER SRM. (M)SDR ASAA0410010Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 540-727B, BUTTOCK LINE 0 CORRODED. REPLACED FLOORBEAM PER SRM. (M)SDR GTIA040021Floorbeam · corrodedFTW - FOUND FORWARD CABIN CORRODED AT FLOORBEAM STATION 200 LBL 44 INCHES TO LBL 55 INCHES. NO MATERIAL LOSS AT FLOORBEAM. MATERIAL ID TAB END. FABRICATED NEW TAB. INSTALLED NEW TAB END. (M)SDR GTIA040023Floorbeam · corrodedFTW - FOUND FORWARD CABIN STATION 218 LBL 13 INCHES RBL 13 INCHES FLOORBEAM CORRODED TWO FROZEN SCREWS. REMOVED FLOORBEAM. DRILLED AND LOCATED HOLES. INSTALLED NEW FLOOR SUPPORT. (M)SDR GTIA040025Floorbeam · corrodedFTW - FOUND FORWARD CABIN STATION 218 LBL 30 TO LBL 36 FLOORBEAM CORRODED. REMOVED CORRODED FLOOR SUPPORT. FABRICATED NEW FLOORBEAM. INSTALLED NEW FLOORBEAM. (M)SDR DHL2004365513Floorbeam · corrodedEXFOLATING CORROSION AT BOTTOM OF FLOOR BEAM FRAME 27 BELOW AFT END OF CARGO LOADING ROLLER AT 40 FT RT OF CENTER LINE. REMOVED CORROSION. FOUND OUT OF LIMITS .050 MAT LOSS. ACCOMPLISHED UT THICKNESS CHECK AFTER CORROSION REMOVED MAX THICKNESS FOUND .090. SDR AWXA200400097Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-18 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER SURFACE OF FLOORBEAM AT BS 296, LBL 11, WL 208. MAINTENANCE REMOVED CORRODED FLOORBEAM BS 296, LBL 11, WL 208; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW B7SDR SWAA040074Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND FLOORBEAM CORRODED AT BS 767, FROM LT TO RT TRANS ANGLES. REPAIRED FLOORBEAM PER EA.SDR ASAA0410002Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 480, RIGHT BUTTOCK LINE 5, RIGHT BUTTOCK LINE 59 CORRODED. REPAIRED FLOORBEAM PER EA. (M)
Back to JASC 5315