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 0104916307Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON FLOORBEAM UPPER CHORD AT BS 920 RBL 51. REPAIRED PER EA 63-186690.SDR 2001UALA02374Floorbeam · corrodedSTATION 1640 BBL 63 FLOORBEAM CAP CORRODED. MAJOR REPAIR ACCOMPLISHED, INSTALLED DOUBLER REPAIRSDR 2001UALA02369Floorbeam · crackedBODY STATION 520 FLOOR BEAM WEB CRACKED AT LBL 24.75. MAJOR REPAIR ACCOMPLISHED, ACCOMPLISHED REINFORCEMENT REPAIR.SDR 2001UALA02378Floorbeam · damagedFORWARD CABIN FLOORBEAM AT BODY STATION 328 RBL 48 HAS DAMAGE WHICH EXCEEDS .250 FROM EDGE OF FLOORBEAM UPPER CHORD. MAJOR REPAIR ACCOMPLISHED, STRAP REPAIR INSTALLED.SDR 2001UALA02362Floorbeam · damagedFORWARD CABIN FLOORBEAM AT BODY STATION 328 RBL 48 DAMAGED AT EDGE OF FLOOR BEAM UPPER CHORD. MAJOR REPAIR ACCOMPLISHED, STRAP REPAIR INSTALLED.SDR SWAA013270Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL BEAM CRACKED (2 EA) AT BS 727A, WL 208, LBL 44 AND RBL 23. REPAIRED BEAM PER BFG ER.SDR F3LA200100134Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM AT STA 312, FROM LBL 13 TO RBL 13. REMOVED DAMAGED SECTION OF FLOOR BEAM, FABRICATED REPLACEMENT FLOORBEAM AND ANGLE SPLICES AND INSTALLED PER SRM 53-10-4.SDR ABXA010617Floorbeam · crackedFLOORBEAM CRACKED AND EXFOLIATED CORROSION IN THE LEFT WHEEL WELL AT FS STATION 902, LEFT BUTT LINE 50. REPLACED THE FLOORBEAM IAW DC-8 MM AND REA D853-42779.SDR AWXA200100621Floorbeam · corrodedMCN - MAJOR REPAIR - C - CORROSION FOUND ON UPPER FLOORBEAM BS 986.5, LBL 45 TO RBL 45. REMOVED AND REPLACED ENTIRE UPPER T-CORD OF CORRODED FLOORBEAM AT BS 986.5, LBL 52 TO RBL 52 IAW AWA ER 03-5310-01334-JS2.SDR AALA20012116Floorbeam · corrodedTUL - FOUND FORWARD SIDE OF FLOORBEAM WEB CORRODED STATION 200 RIGHT SIDE AT BELTFRAME ATTACH. CUT OUT CORRODED SECTION AND INSTALLED DOUBLER PER SRM 51-70-4 PAGE 5 FIG 2. (M)SDR AWXA200100634Floorbeam · crackedMCN - C12 CK - C - .25 INCH CRACK FOUND AT LOWER FWD CORNER OF LIGHTING HOLE IN FLOORBEAM UPPER CHORD OF LONGITUDINAL BS 668, LBL 24, VERIFIED BY HFEC INSPECTION. MAINTENANCE STOP DRILLED CRACK; REVERIFIED WITH HFEC INSPECTION CRACK WAS CONTAINED; FABRICATED SDR C2XA01TY190Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE FORWARD DIGITAL PLATE LOCATED BENEATH THE FLOOR AND JUST AFT OF THE COCKPIT ENTRANCE DOOR WAS FOUND TO HAVE SEVERAL AREAS OF CORROSION. MAINTENANCE REMOVED THE DAMAGED AREA AND ACCOMPLISHED A FILLER/DOUBLER REPAIR IAW CSDR 2001UALA02343Floorbeam · gougedCABIN FLOORBEAM AT STATION 328, RBL 48 HAS DEEP GOUGE ON UPPER SURFACE. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE. INSTALLED SPLICE REPAIR.SDR ASAA01400159Floorbeam · damagedPAE - DURING SI CHECK, FOUND FLOORBEAM AT BS 967 RBL 16 AND WL 208 HAS MECHANICAL DAMAGE. REPAIRED PER SRM. (M)SDR 2001UALA02333Floorbeam · corrodedBODY STATION 246 RBL 68 FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED, FABRICATED AND INSTALLED FLOOR BEAM.SDR SIMA200133201Floorbeam · corrodedDURING INSPECTION, FOUND CORROSION ON THE LEFT OMEGA AT FRAME 20. REMOVED CORROSION. FABRICATED A DOUBLER AND INSTALLED IAW EMB 145 (SRM 145/1142 CHAPTER 53 REV 15) 53-21-10 AND STANDARD SRM PRACTICES. (M)SDR SIMA200133202Floorbeam · corrodedDURING INSPECTION, FOUND CORROSION ON THE GALLEY CENTER OMEGA BEAM AT FRAME 20. REMOVED CORROSION. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED A REPAIR DOUBLER AND INSTALLED IAW EMBRAER GST-3729/01, PARA 5 AND STANDARDSDR SIMA200133211Floorbeam · corrodedABI - THIS IS LEVEL 2 FINDING ON A CORROSION REPAIR ITEM. LEFT OMEGA BEAM CORRODED AT FRAME 20. REPAIRED LEFT OMEGA BEAM IAW EMB145 SRM 53-21-10 AND 51-40-02. (M)SDR 2001UALA02396Floorbeam · corrodedAFT CABIN STA 1640 FLOORBEAM UPPER SURFACE HAS CORROSION AROUND N-P HOLES RBL 1 TO RBL 53. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP AND FLANGE CUTOUT REPAIR.SDR QXEA0102016Floorbeam · crackedPDX - FLOORBEAM CRACKED 9 INCHES AFT OF FRAME 3450 AND APPROXIMATELY 30 INCHES FROM SERVICE/EMERGENCY DOOR. REPAIRED IAW HORIZON AIR EA 4-53-1525 AND FOKKER SRM 53-02-14.SDR SWAA013169Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 846, RBL 3. REPAIRED FLOORBEAM PER SWA RA.SDR 2001UALA02402Floorbeam · corrodedCABIN FLOORBEAM AT STA 1681 LBL12 HAS CORROSION AROUND NUTPLATE HOLE. MAJOR REPAIR ACCOMPLISHED. FLOORBEAM STRAP & ANGLE DOUBLER INSTALLED. VERIFIED NO CRACKS AFTER DAMAGE REMOVED.SDR C2XA01TY186Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE FORWARD DIGITAL PLATE LOCATED JUST AFT OF THE COCKPIT ENTRANCE DOOR WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE FORWARD DIGITAL PLATE IAW EMB 135 SRM 51-40-02 AND EC 35320-01059, THE REPAIR WAS FOUND TSDR C2XA01TY184Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE CENTER FLOORBEAM TOP CAP WAS FOUND CORRODED BETWEEN FRAMES 19 AND 22. MAINTENANCE REMOVED AND REPLACED THE TOP CAP IAW EMB135 SRM 51-40-02, THE REPAIR WAS SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSDR C2XA01IA404Support · corrodedDURING C-CK INSPECTION THE FLOOR SUPPORT AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOOR SUPPORT IN ACCORDANCE WITH THE EMB 145 SRM 51-40-02 AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA01IA403Floorbeam · crackedDURING C-CK INSPECTION THE LEFT FLOORBEAM AT FRAME 20 WAS FOUND TO BE CORRODED AND CRACKED. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM IN ACCORDANCE WITH EMB 145 SRM 51-40-02. THE AIRCRAFT WAS THEN APPROVED FOR RETURN TO SERVICE.SDR IXXA0100079SFloorbeam · crackedDURING ROUTINE C-CHECK INSPECTION A CRACK WAS DETECTED ON THE FLOORBEAM LEFT HAND FRAME ATTACHMENT PLATES AND CLIPS AT FS 320 TO 480. ACCOMPLISHED REMOVAL OF DAMAGED PLATES AND CLIPS. FABRICATED AND INSTALLED NEW ATTACHMENT PLATES AND CLIPS IN ACCORDANCE WITH SDR SIMA200132405Floorbeam · corrodedABI - DURING MBV INSPECTION, FOUND CORROSION ON THE FORWARD DIGITAL. REMOVED CORROSION BY BLENDING OUT. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED A REPAIR DOUBLER. REPAIR DONE IAW EMB GST 3664/01 PARA 1 AND STANDARDSDR SIMA200132404Floorbeam · corrodedABI - DURING MBV INSPECTION, FOUND CORROSION ON THE LEFT OMEGA BEAM GOING UNDER CENTER AISLE SUPPORT AT FRAME 58. REMOVED CORROSION BY CUT OUT. FABRICATED A REPAIR FILLER AND SHIMS. REPAIR DONE IAW EMB GST-3679/01 PARA 3B AND STANDARD SRM PRACTICES. (M)SDR SIMA200132403Floorbeam · corrodedABI - DURING A MBV INSPECTION, FOUND CORROSION ON THE LEFT OMEGA BEAM (PREV REPAIR) AT FRAME 20. REMOVED PREVIOUS REPAIR (CORROSION LIMITED TO PREV REPAIR). FABRICATED A DOUBLER ANGLE AND FILLER. WORK DONE IAW EMB 145 (SRM-145/1142 CHAPTER 53 REV 15) 53-21-1SDR SIMA200132402Floorbeam · corrodedABI - DURING INSPECTION, FOUND CORROSION ON THE LEFT OMEGA BEAM BETWEEN FRAMES 21 AND 23. REMOVED CORROSION BY BLENDING. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED A REPAIR DOUBLER. REPAIR DONE IAW EMB GST-3679/01 ANSDR SIMA200132401Floorbeam · corrodedABI - DURING AN MBV INSPECTION, FOUND CORROSION ON THE LEFT OMEGA BEAM AT FRAME 29. REMOVED CORROSION BY CUT OUT. FABRICATED A DOUBLER ANGLE, FILLER, AND SHIMS. REPAIR DONE IAW EMB GST-3354/01, EMB 145 (SRM145/1142 CHAPTER 53 REV 15) 53-21-10 AND STANDARD SSDR ARWA20011114Floorbeam · crackedDURING "C" CHECK INSPECTION, STA 1120, X=10 RT SIDE, FLOORBEAM WEB WITH CORROSION. ACCOMPLISHED HFEC INSPECTION IAW DC-8 NDT MANUAL CHAPTER 06, FOUND CRACK OF 0.562 INCHES LENGTH DUE TO CORROSION & MATERIAL LOSS. TRIMMED OUT DAMAGED AREA; FABRICATED FILLER ASDR SWAA013134Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 312, BETWEEN RBL 8 AND LBL 8, WL 208. REPAIRED FLOORBEAM PER SRM.SDR ASAA0140146Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOORBEAM AT STATION 360 WL 208 AND RBL 19 AND 26. REPAIRED IAW SRM. (M)SDR QXEA0101979Floorbeam · corrodedPDX - FLOORBEAM REPAIR BL 0 JUST FORWARD OF FRAME 4900 TOP TIE PLATE HAS LIGHT CORROSION. REPAIRED IAW HORIZON AIR EA 4-53-1526.SDR 2001UALA02305Floorbeam · corrodedFWD CABIN FLOORBEAM T-CAP BODY STATION 310 RBL 40 HAS SURFACE CORROSION AND ADJACENT WEB DAMAGED DURING INTERCOSTAL REMOVAL. MAJOR REPAIR ACCOMPLISHED. STRAP AND ANGLE REPAIR INSTALLED.SDR C2XA01TY179Floorbeam · corrodedTYS DURING A SCHEDULED 1C INSPECTION THE FLOORBEAM SPLICE CAP OVER FRAME 20 ON RIGHT SIDE WAS FOUND CORRODED AROUND THE RIVETS. MAINTENANCE REMOVED AND REPLACED THE RIVETS, CLEAN THE CORROSION, REWORKED THE AREA IAW EMB 135/145 SRM 51-40-02 AND CPM 51-17-00-SDR 2001UALA02295Floorbeam · corrodedAFT CABIN STATION 947 RBL 27 FLOORBEAM CAP HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLE.SDR 2001UALA02294Floorbeam · corrodedAFT CABIN FLOORBEAM STATION 947 RBL 22 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLE.SDR SIMA200132001Floorbeam · corrodedTHIS IS A LEVEL 2 FINDING ON A CORROSION REPAIR ITEM. GALLEY CENTER FLOORBEAM CORRODED. REMOVED AND INSTALLED SERVICEABLE GALLEY CENTER BEAM IAW EMB 145 SRM 51-40-02. (M)SDR ASAA0140141Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION TOP OF FLOORBEAM AT BS 312 LBL 1, 6, 15 AND WL 208. REPAIRED IAW SRM. (M)SDR AWXA200100625Floorbeam · corrodedMCN - C12 CK - C - TOP OF FLOORBEAM CORRODED AT SCREW HOLES BS 312, RBL 10. MAINTENANCE REMOVED CORRODED FLOORBEAM UPPER CHORD AT BS 312. FABRICATED AND INSTALLED NEW FLOORBEAM UPPER CHORD AND REPAIR ANGLES IAW B737-300 SRM 53-10-51, FIG 205, PG 222 & 223.SDR QXEA0101797Floorbeam · corrodedPDX - FLOORBEAM BL600L FROM FRAME 3820 TO 4900 TOP TIE PLATE HAS LARGE BUBBLES OF PAINT AND CORROSION. REPAIRED IAW FOKKER SRM 51-10-4 AND SRM 51-31-01.SDR ASOA01225Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, BOTH TOP AND BOTTOM SURFACES OF THE FLOORBEAM TOP FLANGE WAS FOUND CORRODED AT FRAMES 36, 38, 39, 40 AND 41. MAINTENANCE REPAIRED CORROSION IAW ASA EO72-53-0119. THE EO REF FORM 8110-3, REPORT NR 01-286, WHICH INCLUDES REPAISDR 2001UALA02255Floorbeam · corrodedCABIN FLOORBEAM UPPER T-CAP CORRODED AT STATION 324 RBL 42 AND OUT TO 68 RBL STRINGER 17. MAJOR REPAIR ACCOMPLISHED. REMOVED CORRODED SECTION OF T-CAP FROM 10 LBL TO 68 RBL. INSTALLED NEW PIECE OF T-CAP.SDR C2XA01TY178Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION, CORROSION WAS FOUND ON THE FORWARD DIGITAL BETWEEN FRAMES 15 AND 16 AT CENTER AND LEFT SIDE. MAINTENANCE REMOVED THE DAMAGED SECTION, FABRICATED NEW ANGLE, SHIM, FILLER AND PLATE. INSTALLED REPAIRED PARTS IAW-EMB-135/145-SDR C2XA01TY177Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION, CORROSION WAS FOUND ON THE LEFT OMEGA BEAM AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED SECTION, FABRICATED NEW ANGLE, SHIM, FILLER AND PLATE. INSTALLED REPAIRED PARTS AND FLOORBEAM IAW EMB-135/145-SRM-53-21-10 & 53-40-02SDR AWXA200100629Floorbeam · corrodedMCN - C12 CK - C - TOP OF FLOORBEAM CORRODED AT BS 328, RBL 12 TO RBL 26. MAINTENANCE CLEANED CORROSION AND PERFORMED DEPTH CHECK (OUT OF LIMITS).SDR 2001UALA02264Floorbeam · gougedFORWARD SIDE OF 246 FLOORBEAM WEB AT RBL 7.88 HAS DEEP GOUGE IN EXCESS OF 50 PERCENT WEB THICKNESS. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIR ACCOMPLISHED PER 777 SRM 53-10-51-201.
Back to JASC 5315