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 CALA0100876Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 947.5, RBL 4 TO LBL 24. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-04187 AND SRM 53-00-51, FIGURE 202.SDR MWEA011256Floorbeam · crackedFLOORBEAM CRACKED APPROXIMATELY 8 INCHES FORWARD OF AFT PRESSURE BULKHEAD AT LOWER LEFT CORNER OF VENTRAL DOOR BELOW FLOORBOARD. CRACK INDICATION FOUND ON RADIOGRAPH LLB. -- REMOVED AND REPLACED FITTING.SDR AWXA200100495Floorbeam · crackedYVR - C19 CK -RT OVERWING SEAT TRACK AILERON CUTOUT STRUCTURE AT RT I/B SEAT TRACK BS 658 VERT FLANGE CRACKED .3125 INCH. VISIBLE THROUGH CUTOUT UNDER STRUCTURE OF CLOSED FLOOR PANEL. MAINTENANCE STOP DRILLED CRACK AND INSTALLED REPAIR IAW AWA ER 15-5710-0126SDR AWXA200100494Floorbeam · crackedYVR - C19 CK - RT OVERWING PRESSURE DECK LOWER VERT CHORD AT BS 698, RBL 24.82 CRACKED .5 INCH. MAINTENANCE TRIMMED OUT DAMAGED AREA, FABRICATED REPAIR ANGLE AND INSTALLED IAW AWA ER 15-5702-01271-SS2.SDR SWAA012545Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BL 0 TO RBL 15. REPAIRED FLOORBEAM PER SRM.SDR 2001UALA02036Beam · misdrilledSTATION 360 BL 0 FLOOR BEAM UPPER CAP WAS DRILLED INTO. MAJOR REPAIR ACCOMPLISHEDINSTALLED ANGLE AND STRAP REPAIR.SDR CALA0100873Floorbeam · damagedINSPECTION FOUND A NOTCH CUT INTO FLOORBEAM WEB AT STA 328, LOCATED JUST FORWARD OF RT HORIZONTAL STABILIZER PULLEY CABLE. A REPAIR DOUBLER WAS INSTALLED IAW ECRA 5320-01694.SDR C2XA01TY112Beam · corrodedTYS During a scheduled inspection, The left omega beam was found corroded at frame 20. Maintenance removed damaged area, fabricated repair filler, shims & external angle. Alodined, primed and installed repair parts. I.A.W.-EMB-135/145-SRM-51-40-02, 53-21-10 SDR USAA011306Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH, STATION 847 JUST ABOVE STRINGER 26R. INSTALLED DOUBLER. (M)SDR USAA011279Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 4 INCHES, STATION 663 BL 0. INSTALLED WEB, SPLICE ANGLE REPAIR. (M)SDR USAA011289Floorbeam · corrodedCLT - FOUND BEAM CORRODED 2 INCHES BY 33 INCHES, BS 1016 BBL 0 LBL 33. INSTALLED T-CAP PER T/R 53-60-02. (M)SDR USAA011290Floorbeam · corrodedCLT - FOUND BEAM/CHANNEL/WEB CORRODED 5 INCHES, BS 1014-1019 BBL 0 LBL 6. INSTALLED T-CAP. (M)SDR AWXA200100506Web · crackedMCN - C17 CK - "C" - 3 EA. CRACKS ABOUT 1" EA. FOUND ON FLOOR BAEAM WEB BS 706 TO 714, RBL 24, BELOW FLOOR PANELS. MAINTENANCE REMOVED DAMAGED AREA OF WEB AND FABRICATED REPAIR PARTS AND INSTALLED IAW AWA ER 03-5715-01267-DL1.SDR AWXA0002216Fitting · corrodedDiscrepancy/Corrective Action: RH MLG Door Actuator Fitting PN# D533-72613-60400, Fastener Hole Has Corrosion.Corrective Action: Repaired As Per AWA ER 26-5315-01250-JS2SDR UPS01836951Floorbeam · corrodedINSPECTION TYPE: C2, FLC FS 70 FLOORBEAM AT RBL 32 CORRODED FABBED REPAIR ANGLES IAW TIMCO SRM STD 5310-001 ALODINED & PRIMED IA W DC8 SRM 51-1-8. INSTALLED REPAIR ANGLES IAW 51-1-20 INSTALLED 2 EA FLOOR PANELS IAW DC8 SRM 51-3-0SDR SWAA012521Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND 2 FLOORBEAMS CORRODED AT BS 859, LBL 3 & RBL 14. REPAIRED FLOORBEAMS PER SWA 1-A53-2021.SDR UPS01836949Floorbeam · corrodedINSPECTION TYPE: C2, FLOORBEAM CORRODED IN FWD UPPER FLANGE APPROX 10 INCHES FROM LT CUSP AT FS 1080. CUT OUT DAMAGED FLOORBEAM SECTION. FABRICATED NEW SECTION & REPAIR A NGLES. REMOVED TAIL DEICE AIR LINE. INSTALLED NEW SECTION & REPAIR S PLICES IAW DC8 SDR UPS01836948Floorbeam · corrodedINSPECTION TYPE: C2, FLOORBEAM CORRODED IN FWD UPPER FLANGE APPROX 10 INCHES FROM LT CUSP AT FS 1080. CUT OUT DAMAGED FLOORBEAM SECTION. FABRICATED NEW SECTION & REPAIR A NGLES. REMOVED TAIL DEICE AIR LINE. INSTALLED NEW SECTION & REPAIR S PLICES IAW DC8 SDR USAA011261Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 4 FEET BY 2 INCHES, STATION 328, BL 0 RIGHT TO SERVICE DOOR. FABRICATED AND INSTALLED T-CAP. (M)SDR 2001UALA01998Floorbeam · corrodedCABIN FLOORBEAM UPPER FLANGE IS CORRODED BODY STATION 986 FORWARD, RBL 24, WL 208. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED STRAP REPAIR.SDR UPS01437079Floorbeam · crackedINSPECTION TYPE:C M/D - BS 220 RBL 10 FLOORBEAM SURFACE FOUND CRACKED AS MARKED. REPAIRED FLOORBEAM AT BS 220 BETWEEN RBL 7 TO RBL 13 PER SRM 53-10-07 FIG 10.SDR SIMA200125002Floorbeam · corrodedABI - DURING MBV INSPECTION, FOUND CORROSION ON THE LEFT OMEGA BEAM AT FRAME 20. REMOVED CORROSION FROM LEFT OMEGA BEAM AT FRAME 20 AND REPAIRED IAW EMB 145 SRM. (M)SDR AWXA200100497Floorbeam · corrodedYVR - C19 CK - FLOORBEAM AT BS 987 TOP SURFACE HAS CORROSION BETWEEN LBL 30 AND RBL 12. MAINTENANCE REMOVED PREVIOUS BEAM CAP REPAIR, FABRICATED NEW BEAM CAP AND INSTALLED IAW B737 SRM 53-10-9, FIG 2, PG 7.SDR AWXA200100496Floorbeam · corrodedYVR - C19 CK - FLOORBEAM AT BS 967 HAS CORROSION BETWEEN BL 0 AND RBL 30 ON TOP SURFACE. AFTER CORROSION REMOVAL, MATERIAL LOSS BEYOND SRM LIMITS. MAINTENANCE REMOVED DAMAGED SECTION OF FLOORBEAM TOP CAP AND REPLACED IAW B737 SRM 53-10-9, FIG 2, PG 7.SDR 2001UALA01979Floorbeam · corrodedCABIN FLOORBEAM UPPER FLANGE IS CORRODED AT BS 986 FORWARD, RBL 24, WL 208. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP REPAIR.SDR ZIAA04043Floorbeam · corrodedYIP - FOUND FLOORBEAM AT FS 200 RIGHT SIDE NEAR PORTA POTTY AREA CORRODED. REMVOED CORRODED SECTION OF FLOORBEAM AND REPAIRED FS 200 FLOORBEAM PER L-188 SRM 53-2-4, FIG 2 SHEET 1. (M)SDR AWXA200100545Floorbeam · corrodedPHX - C8 CK - C - CORROSION FOUND ON TOP CAP OF FLOORBEAM AT BS 377, LBL 15 TO LBL 60, BEYOND SRM ALLOWABLE LIMITS. MAINTENANCE REMOVED DAMAGED SECTION OF FLOORBEAM UPPER CAP, FABRICATED REPAIR PARTS AND INSTALLED IAW AWA ER 19-5311-01269-DL4.SDR ASOA01166Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, MAINTENANCE DISCOVERED CORROSION ON THE FLOORBEAM AT FRAMES 36 AND 38. MAINTENANCE REPAIRED CORROSION IAW ASA EO 72-53-0115. (M)SDR ASOA01167Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, MAINTENANCE DISCOVERED CORROSION ON THE FLOORBEAM TOP FLANGE AT FRAMES 39, 40 AND 41. MAINTENANCE REPAIRED CORROSION IAW ASA EO 72-53-0115. (M)SDR 2001UALA01985Floorbeam · corrodedEXISTING REPAIR AT FLOORBEAM AT BS 910 RBL 23 THRU RBL 45 IS CORRODED, OUT OF LIMITS. MAJOR REPAIR ACCOMPLISHED. REPLACED TEE CHORD.SDR AWXA0002266Floorbeam · corrodedFS 366 FLOORBEAM UPPER CHORD CORRODED FROM RBL 8 TO RBL 50. REMOVED UPPER CHORD FROM RBL 8 TO RBL 50 IAW SRM 51-40-02, FABBED UPPER CHORD AND INSTALLED PER SRM 53-10-51 & 53-00-51 FIG 203.SDR SWAA012506Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO BIN FLOOR BEAMS CORRODED ( 2 EA ) AT BS 859, LBL 12 & LBL 8. REPAIRED FLOOR BEAMS PER SWA RA 1-A53-2021.SDR SWAA012505Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO BIN FLOOR BEAMS CORRODED ( 3 EA ) AT BS'S 795, 813 & 826, LBL3. REPAIRED FLOOR BEAMS PER SWA RA 1-A53-2021.SDR 2001F00354Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT BS 328 LBL 28. REPAIRED PER EO 01-0731. (M)SDR 2001F00353Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT BS 344 LBL 35. REPAIRED PER ER 01-0730. (M)SDR 2001F00352Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT BS 328 LBL 15 TO RBL 56. REPAIRED PER EO 01-0731. (M)SDR 2001F00351Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT BS 312 RBL 38 TO LBL 37. REPAIRED PER SRM 53-10-51. (M)SDR 2001F00350Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT BS 344 LBL 55. REPAIRED PER ER 01-0730. (M)SDR 2001UALA01961Floorbeam · damagedAFT CABIN FLOOR STATION 967 FLOORBEAM CAP HAS NICKS, GOUGES AND AN ELONGATED HOLE AT LBL 5 TO LBL 14. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE AND INSTALLED REINFORCEMENT REPAIR.SDR SIMA200124703Floorbeam · corrodedABI - DURING MBV INSPECTION, FOUND LEFT OMEGA BEAM AT FRAME 25 CORRODED. REMOVED CORROSION FROM LEFT OMEGA BEAM AT FRAME 25 AND REPAIRED IAW EMB145 SRM AND EMB REPAIR STATEMENT GST-2930/01. (M)SDR SIMA200124704Floorbeam · corrodedDURING MBV INSPECTION, FOUND LEFT OMEGA BEAM AT FRAME 20 CORRODED. REMOVED CORROSION FROM OMEGA BEAM AT FRAME 20 AND REPAIRED IAW EMB 145 SRM. (M)SDR SIMA200124705Floorbeam · corrodedABI - DURING MBV INSPECTION, FOUND CENTER OMEGA BEAMS AT FRAMES 20 AND 22 CORRODED. REMOVED CORROSION FROM CENTER OMEGA BEAMS AT FRAMES 20 AND 22 AND REPAIRED IAW EMB145 SRM AND EMB REPAIR STATEMENT GST-2930/01. (M)SDR 2001UALA01967Floorbeam · corrodedBODY STATION 1351 RBL 15-RBL 33 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2001UALA01962Floorbeam · damagedEXCESSIVE MATERIAL LOSS ON CABIN FLOORBEAM AT BODY STATION 294.5 LBL 27. MAJOR REPAIR ACCOMPLISHED. REPLACED FLOORBEAM.SDR 2001UALA01975Floorbeam · corrodedBODY STATION 1197 STRINGER 33L T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2001UALA01968Floorbeam · corrodedBODY STATION 830-860 RBL 59 FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM SECTION AND SPLICES.SDR 2001UALA01930Floorbeam · corrodedUPPER DECK FLOORBEAM STATION 1060 RBL 46 CORRODED. MAJOR REPAIR ACCOMPLISHED, TO FLOORBEAM STATION 1060 RBL 46.SDR ABXA010480Support · corrodedFLOOR SUPPORT AT FUSELAGE STATION 945 WAS FOUND TO BE CORRODED ABOVE LONGERON 30. MAINTENANCE MANUFACTURED AND INSTALLED A SUPPORT SPLICE IAW DRAWING 99577 AND DC-9 SRM.SDR USAA011187Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 2 INCHES, FS 377.7 AT LBL 49 AND LBL 21. REMOVED DAMAGED SECTION OF T-CAP AND INSTALLED NEW PER T/R 53-15-01 EA 69911. (M)SDR 2001UALA01916Floorbeam · corrodedCABIN STATION 312 FLOORBEAM UPPER SURFACE LBL 5 TO RBL 8 CORROSION REMOVAL MATERIAL LOSS IS BEYOND LIMITS. MAJOR REPAIR ACCOMPLISHED. REMOVED ORIGINAL REPAIR AND FABRICATED NEW REPAIR PARTS FOR UPPER CAP DOUBLE FLANGE REPAIR. INSTALLED DOUBLER FLANGE REPAIR
Back to JASC 5315