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 04FDEA01601Floorbeam · corrodedCORROSION (C53-224-04) ON FLOORBEAM AROUND NUT PLATE HOLES BS 1130, LBL 27 - LBL 43, WL 207. CORROSION OUT OF LIMITS. REPAIRED 1130 FLOORBEAM UPPER CHORD LBL 27-43 WL 207 IAW SRM 53-10-8 FIG 10.SDR 04152632BFloorbeam · crackedDURING HEAVY INSPECTION THE FLOORBEAM AT FS 280 WAS FOUND CRACKED. THE BEAM WAS REPAIRED PER MANUFACTURER INSTRUCTIONS AND AIRCRAFT WAS RETURNED TO SERVICE UPON INSPECTION COMPLETION.SDR 2004UALA00536Floorbeam · corrodedCABIN FLOORBEAM UPPER CAP CORRODED AROUND FASTENER HOLES STA 365 AT RBL 26 TO 44. MAJOR REPAIR ACCOMPLISHED. INSTALLED FLOORBEAM SPLICE REPAIR.SDR 04FDEA01566Floorbeam · corrodedWHILE CLOSING MAIN CARGO FLOOR PANELS FOUND BS 970 LBL 12 WL 200 LOWER FLOORBEAM CORRODED. CORROSION OUT OF LIMITS. REMOVED CORRODED FLOORBEAM LOWER CHORD 1 X 4.25 INCHES. FABRICATED & INSTALLED REPAIR ANGLES (2 EA) & FILLER, AND RESTORED ALL ACCESS PER SRMSDR 04FDEA01565Floorbeam · corrodedCORROSION (C53-224-01) FLOORBEAM UPPER FLANGE LWR SURFACE IS GOUGED AND CORROSION STA 400 LBL 2-8 WL 208. REPAIRED FLOORBEAM AT BS 400, LBL 2-8, WL 208 IAW SRM 53-10-8 FIG 3, 51-40-3, 51-10-3, FED EX MM 51-20-000-7, 51-20-021-7, SRM 51-30-2. ORIGINAL MATERIASDR 04FDEA01564Floorbeam · corrodedCORROSION (C53-224-01, 3) FLOORBEAM STA 1130 LWR CHORD FWD FLANGE UPPER SURFACES CORRODED LBL 1-45 WL 200 AROUND NUT PLATE. REMOVED CORROSION ON 1130 FLOORBEAM, LOWER CHORD, FWD FLANGE UPPER AND LOWER SURFACES LBL 1 - LBL 45, WL 200 AROUND FASTENER HOLES. ORSDR ASAA0410278Floorbeam · corrodedPAE - FOUND CORROSION ON LOWER CHORD FLOORBEAM. REMOVED CORROSION. FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR USAA040242Floorbeam · corrodedPIT- FOUND BEAM ASSEMBLY CORRODED 1.5 INCHES LONG BY 1.3 INCH BY .65 INCH AREA, FRAME 64-66, -Y1300, Z240. REMOVED AND REPLACED BEAM ASSEMBLY PER SRM 51-42-11, 53-00-14, EA 95512. (M)SDR USAA040241Floorbeam · corrodedFOUND BEAM CORRODED 1.5 INCHES LONG BY 2 INCHES WIDE BY .029 INCH DEEP, FRAME 64-66, Y1375, Z240. REMOVED AND REPLACED BEAM ASSEMBLY PER SRM 53-41-14, 51-42-11, 51-23-11 AND EA 95512. (M)SDR USAA040263Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 1.5 INCH BY 1 INCH BY .075 INCH AREA, FS 66-68M Y1192 TO Y1292, -Z240. REPLACED FLOORBEAM PER SRM 53-00-14. CORRODED LEVEL 2, TASK NR JA-160-53500. (M)SDR USAA040244Floor Support · corrodedCLT - FOUND FLOORBEAM CORRODED 6 INCH TOTAL AREA, LOWER DOOR SILL OF AFT CARGO DOOR FUSE STATION 1380-1440. REMOVED VERY LIGHT SURFACE CORROSIONPER SRM 53-60-15 FIG 101, SH 6. (M)SDR 04FDEA01551Floorbeam · crackedFWD CARGO OVERHEAD FLOORBEAM AT FR 27, 27 INCHES RIGHT OF CENTERLINE ON THE FWD SIDE IS CRACKED ON UPPER VERTICAL LEG. REWORKED CRACK AT FR 27 IAW A300-600 SRM 51-27-00, NDT VERIFIED CRACK, REMOVED CRACK IN WEB IAW 53-10-15 P207. NDT VERIFIED NO CRACK FOUND.SDR C2XA04SH341Doubler · corrodedDURING C CHECK THE RT OMEGA BEAM AFT DOUBLER WAS FOUND TO BE CORRODED AT FRAME 22. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DOUBLER IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWIA200413497Floorbeam · crackedLEFT FRAME 13 FLOOR PROP CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED FRAME 13 FLOOR PROP ON LEFT SIDE IAW SRM 53-10-10.SDR SWIA200413496Floorbeam · crackedRIGHT FRAME 13 FLOOR PROP CRACKED. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED RIGHT FLOOR PROP AT FRAME 13 IAW SRM 53-10-10.SDR AWXA200400618Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND ON UPPER FORWARD FLANGE OF FLOORBEAM AT BS 1681, RBL 32. MAINTENANCE CUT OUT DAMAGE ON FLOORBEAM AT BS 1681, RBL 32; FABRICATED 2 EACH ANGLES AND STRAPS; INSTALLED REPAIR PARTS IAW B757-20SDR 2004UALA00513Floorbeam · corrodedCABIN FLOORBEAM UPPER CAP CORRODED AT STA 365 RBL 9 TO 16. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR ANGLE AND STRAPS.SDR SWAA041540Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 947, LBL 53.5, CRACKED. REPAIRED FLOORBEAM CHORD PER ER.SDR C1HA200483009Floorbeam · corrodedSTA 344 LBL 18 FLOORBEAM CORRODED. REPAIRED IAW SRM 53-10-8 FIG 9.SDR C2XA04TY086Floorbeam · corrodedDURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE LAVATORY CENTER FLOORBEAM CAP AT FRAME 58. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM CAP IAW EMB SRM 51-40-02, THE REPAIR WAS FOUND TO BE SATISFACTORY. THE AIRCRAFT WILL BE RELEASED UPON COMPLETIOSDR 04FDEA01533Floorbeam · corrodedT-CAP CORRODED IN FORWARD PIT AT FS 909 RBL 30. REMOVED DAMAGED T-CAP, LOCATED DRILLED AND SIZED NEW EXTRUSION IAW DC10 SRM 51-31-01 AND INSTALLED NEW T-CAP IAW DC10 SRM 51-31-01 VOL 2.SDR C2XA04SH330Floorbeam · corrodedDURING C CHECK THE CENTER OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA0410275Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM LOWER SURFACE. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR ASAA0410274Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM UPPER CHORD. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR USAA040254Floorbeam · corrodedFLOORBEAM, 2.5 INCH X 1.5 INCH X .030 INCH DEEP, CORROSION. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR 2004UALA00508Floorbeam · corrodedCABIN FLOORBEAM UPPER CAP CORRODED AT STA 310 RBL 42. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FILLER & CAP REPAIR.SDR 04FDEA01498Floorbeam · corrodedCORROSION (C53-224-01,3) FLOORBEAM STA 1110 WL 208 CORRODED UPPER CHORD. REMOVED CORROSION FROM BS 1110 FLOOR BEAM, FOUND TO BE OUT OF LIMITS PER SRM 53- 10-1. ACCESSED AREA, REPLACED UPPER CHORD PER FED EX EA 7-5310-77727, RESTORED ACCESS PER SRM 51-30-2 ASDR C2XA04SH326Floorbeam · corrodedSHV-DURING C CHECK THE LT OMEGA BEAM 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. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH325Floorbeam · corrodedSHV-DURING C CHECK THE SHELL PLATE ON TOP OF THE CENTER OMEGA BEAM AT FRAME 23 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SHELL PLATE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR USAA040249Floorbeam · corrodedFLOORBEAM, 2.0 INCH X 2.0 INCH X .025 INCH D, BETWEEN FR 68-69, Y1270, Z240, CORROSION. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR USAA040248Floorbeam · corrodedFLOORBEAM, 2.0 INCH X 2.0 INCH X .035 INCH D, CORROSION BETWEEN FR 64 &66, +Y 1270, Z240. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR USAA040247Floorbeam · corrodedFLOORBEAM, 3.0 INCH X 1.5 INCH X .03 INCH AREA. CORROSION; LEVEL 2. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR A6WA200460016Floorbeam · crackedCRACK LOCATED IN THE LOWER RADIUS OF FLOORBEAM 33B AT LBL 62.0 INCHES. MAINTENANCE REQUESTED REPAIRS FROM MFG SYSTEMS REF AVMAX FAX 611-1908002. REPAIRED IAW BAE FAX BARA/AVR/6759/04-DC AND BARA/AVR/6752/04-02. PRIMED IAW BAE 146 AMM 20-10-11. (M)SDR AWXA200400626Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-15 CHECK CORROSION WAS FOUND ON UPPER T-CAP OF MAIN CABIN FLOORBEAM AT BS 294.5, FROM LBL 11 TO RBL 55. MAINTENANCE REMOVED CORRODED UPPER T-CAP AND PREVIOUSLY INSTALLED REPAIR ANGLES ON MAIN CABIN FLOORBEAM AT BS 294.5, FROM LBLSDR N150AW0018Floorbeam · corrodedBS 1016 AT RBBL 14 CORROSION AT FLOORBOARD ATTACH HOLE. REPLACED FLOORBEAM T-CAP PER SRM 51-10-2.SDR DL73S040562Floorbeam · crackedFLOORBEAM TEE CAP UPPER FLANGE CRACKED STA 328 AT LBL 12. INSTALLED REPAIR PER SRM 53-10-9D.SDR SWAA041483Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 947.5, LBL 53, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER ER.SDR 04FDEA01435Floorbeam · corrodedCORROSION (C53-224-01) ON FLOORBEAM UPPER SURFACE BS 380 RBL 25 TO 35 WL 208. BLENDED CORROSION, FOUND TO BE OUT OF LIMITS. CUT OUT DAMAGED AREA RBL 25.75 TO 27.75 AND RBL 46 TO 48 AT BS 380, WL 208. FABRICATED AND INSTALLED REPAIR DOUBLERS AND FILLERS, BOTSDR 04FDEA01428Floorbeam · corrodedCORROSION (C53-224-01), ON FLOORBEAM LWR FLANGE STA 600 RBL 49 TO 60 WL 201. REMOVED CORROSION ON LOWER FLANGE FLOORBEAM CHORD AT BS 600, RBL 49-60, WL 201. FOUND TO BE OUT OF LIMITS. ACCESSED AREA AND CUT LOWER CHORD FROM RBL 35 TO END OF FLOORBEAM. FABRISDR 04FDEA01427Floorbeam · corrodedCORROSION (C53-224-01), ON FLOORBEAM BS 344 LBL 33 TO 60 WL 208 AROUND NUT PLATE HOLES. REMOVED CORROSION ON FLOORBEAM, BS 344. FOUND TO BE OUT OF LIMITS PER SRM 53-10-1 FIG 1. REMOVED AND REPLACED FLOORBEAM UPPER CHORD BS 344, RBL 65 - LBL 65, WL 208. ALLSDR SWAA041473Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM WEB AT BS 294, RBL 55, CORRODED. REMOVED AND REPLACED FLOOR WEB PER SRM.SDR 04FDEA01422Floorbeam · corrodedFLOORBEAM TOP TEE CORRODED STA 1030 LBL 25 - RBL 25 WL 208. FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REPAIRED DAMGE AREA PER SRM 53-10-8.SDR SWAA041461Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM SUPPORTS AT BS 859, LBL 3, BS 794, LBL 3, CORRODED. REPAIRED FLOORBEAMS PER EA.SDR ASAA0410271Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REMOVED DAMAGE FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR SWAA041460Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM AT BS 294, RBL 18 TO RBL 50, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD PER SRM.SDR C2XA04SH317Gusset · corrodedSHV - DURING C-CHECK THE RIGHT FLOORBEAM DOUBLER AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DOUBLER IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH316Gusset · corrodedDURING C-CHECK THE RIGHT FLOORBEAM DOUBLER AT FRAME 22 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DOUBLER IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR USAA040259Floorbeam · corrodedFLOORBEAM, 1.5 INCH X 1.0 INCH X .02 INCH DEEP, CORROSION; LEVEL 2; FR 66-68, Y787, Z240. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR USAA040256Floorbeam · corrodedFLOORBEAM, 1.0 INCH X 1.0 INCH X .03 INCH D, CORROSION; LEVEL 2; FR64-66, Y787, Z240. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR 2004UALA00485Stiffener · crackedSTA 246 FLOORBEAM RBL 46 FWD SIDE STIFFENER CRACKED (BUCKLED). MAJOR REPAIR ACCOMPLISHED. REPLACED STIFFENER.
Back to JASC 5315