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 ASOA201001393Floorbeam · corrodedFS 280.00 RT CROSSBEAM CORRODED. REMOVED RT FS280.00 FLOORBEAM IAW SRM 51-42-06 AND SRM 51-42-13. LOCATED AND DRILLED RT FS280 FLOORBEAM IAW SRM 51-24-36-001-001-A01 & 51-40-11-001-001-A01. INSTALLED RT FS 280.00 FLOORBEAM IAW SRM 51-42-06-001-001-A01 AND SSDR DALA1023289886Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOOR SUPPORT AT BS 200 LBL 32. REPAIRED IAW SRM 53-14-1, SRM 51-30-5.SDR DALA1023183355Floorbeam · crackedDURING H-CHECK, FOUND CRACK IN BULK CARGO COMPARTMENT UNDER FLOOR ANGLE AT Y950 AT FR68. REPAIRED IAW ERA 484963-14 REV 0.SDR ASOA201001362Floorbeam · crackedCABIN FLOORBEAM STRUCTURE HAS CRACKS AT FS 280.0 RBL 9.0 INBD AND OTBD CLIPS. UPON FURTHER INVESTIGATION FOUND ADDITIONAL DAMAGE AT FS 280 BETWEEN RBL 9 AND LBL 9.SDR ASOA201001361Floorbeam · crackedCABIN FLOORBEAM STRUCTURE HAS A CRACK AT FS 280.0 LBL 9.0 INBD CLIP. UPON FURTHER INVESTIGATION FOUND ADDITIONAL DAMAGE AT FS 280 BETWEEN RBL 9 AND LBL 9.SDR FDEA201009163508Floorbeam · corrodedINSIDE CABIN STA 1640 LBL 58" FLOORBEAM HAS CORROSION AT FASTENER HOLE. REMOVED CORROSION IAW SRM 51-10-02, CHECKED LIMITS FOUND REMAINING MAT 0.095", OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DET VI. REMOVED FLOORBEAM AT STA 1640 IAW SRM 51-40-02, RECEIVED SDR R61A20100455Floorbeam · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND IN MULTIPLE AREAS ON THE LT LONGITUDINAL BEAM BETWEEN FRAME 85 - 90. MAINTENANCE REMOVED AND REPLACED FLOORBEAM AND UPPER SHEET IAW EMB 170 SRM 51-41-01, 51-43-02 AND 51-40-02. P/N'S, UPPER SSDR FDEA201009153526Floorbeam · corrodedMAIN CABIN FLOORBEAM AT BS 400 BETWEEN LBL 45 AND 25 UPPER I BEAM TOP AND BOTTOM SURFACE IS CORRODED. CUT OUT DAMAGED AREA IAW SRM 53-10-8 FIG 3. FABRICATED REPAIR PARTS. INSTALLED REPAIR IAW SRM 53-10-8 FIG 3 AND 51-10-2.SDR C2XA10SH307Floorbeam · corrodedSHV - DURING C-CHECK LT OMEGA BEAM CARBON CROSSBEAM AREA AT FRAME 54 HAS CORROSION (LEVEL 2 LOCAL). MAINTENANCE PERFORMED REPAIR ON LT OMEGA BEAM CARBON CROSSBEAM AT FRAME 54 IAW EMB-145 SRM 53-00-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA201001347Floorbeam · corrodedJUST FWD OF FS 559+112 RBL 9 OTBD FLOOR SUPPORT ANGLE CORRODED. CONTINUATION OF MWC 8732821, OP 220. INSTALLED NEW SERVICEABLE RBL 9 FLOORBEAM TOP CAP AT FS 559 TO FS 574 IAW REO 601R-53-00-381, REV A AND SRM 51-42-34. INSTALLED SERVICEABLE FLOOR SEAT RAILSSDR ASOA201001341Floorbeam · corrodedFLOOR SUPPORT CHANNEL LOCATED AT FS 349.00, RBL 36.00, WL 73.50 IS CORRODED ON OTBD SIDE MAX DEPTH .030". REPAIRED TRANSVERSE BEAM BY COMPLYING WITH STEPS 1-11 OF REO 601R-53-21-1178. ECTC REQUIRED. REO 601R-53-21-1178 REV HAS BEEN ACCOMPLISHED AND ALL STEPS SDR ASOA201001336Floorbeam · corrodedBS 280 FLOORBEAM HAS CORROSION SEVERAL AREAS. REMOVED FS280 FLOORBEAM IAW SRM 51-42-06-001-001-A01 AND 51-42-13-001-001-A01, 51-42-21-001-001-A01. DRILLED NEW SERVICEABLE FS 280 FLOORBEAM IAW SRM 51-40-11-001-001-A01. TRANSFERED HOLES FROM NEW 280 BEAM INTO SDR SWAA105562Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 708 TO BS 711, LBL 24.8. REPAIRED WEB PER EO.SDR SWAA105550Support Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM SUPPORT ANGLE CRACKED AT BS 639, LBL 45.50. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR IPXA10M62909Floorbeam · damagedINSPECTION TYPE:2C, DEFERRED ITEM: D-412982: MAIN DECK FLOOR SUPPORT BEAM REPAIR. REMOVED DAMAGE, FABRICATED AIND INSTALED FILLER, REPLACEMENT T-ANGLE IAW STA-SA EA 011-5310-01-A2695 I/R AND EO MD11-5310-39940-A.SDR FDEA201009143420Floorbeam · corrodedCABIN: CORROSION ON FLOORBEAM UPPER CHORD AT STA 740, RBL 45-64, CORROSION REPAIR CARRIED OUT AS PER EA F-5310-142312. REPAIR IS CLASSIFIED AS MINOR PER GMM 6-2-100.SDR FDEA201009143388Floorbeam · corrodedFLOORBEAM UPPER TEE SURFACE HAS CORROSION BS 1661 LBL 55 NEAR DOOR TRESHOLD. REMOVED CORROSION IAW SRM 51-10-02, ORIG MAT THICKNESS 0.125" MEASUREMENT. FOUND OUT LIMITS IAW 53-00-51,PG 101,FIG 101, DETAIL VII. REMOVED & REPLACED FLOORBEAM IAW SRM 53-00-51,SDR COEA2010091440803Floorbeam · corrodedHEAVY CHECK / LEVEL 2 CORROSION / FLOORBEAM 40 UPPER SURFACE AND LAVATORY SUPPORT PLATES HAVE AREAS OF BARE METAL AND CORROSION. REMOVE AND REPLACE PART.SDR COEA2010091439803Floorbeam · corrodedHEAVY CHECK / LEVEL 2 CORROSION / FLOORBEAM 36 UPPER SURFACE HAS AREAS OF BARE METAL AND CORROSION. REMOVE AND REPLACE PART.SDR COEA2010091438803Floorbeam · corrodedHEAVY CHECK / LEVEL 2 CORROSION / FLOORBEAM 38 UPPER SURFACE HAS AREAS OF BARE METAL AND CORROSION. FABRICATED AND INSTALLED REPLACEMENT FLOORBEAM IAW SRM.SDR COEA2010091437803Floorbeam · corrodedHEAVY CHECK / LEVEL 2 CORROSION / FLOORBEAM 39 UPPER SURFACE HAS AREAS OF BARE METAL AND CORROSION. REMOVE AND REPLACE PART.SDR COEA2010091434803Floorbeam · corrodedHEAVY CHECK / LEVEL 2 CORROSION / FLOORBEAM 16 UPPER FLANGE TOP AND BOTTOM SURFACES HAVE AREAS OF CORROSION BETWEEN LT AND RT INBOARD SEAT TRACKS. MAJOR REPAIR.SDR COEA2010091425803Floorbeam · corrodedHEAVY CHECK / LEVEL 2 CORROSION / FLOORBEAM 13 UPPER FLANGE LOWER SURFACE BETWEEN STRINGERS 15R AND 17R HAS AREAS OF CORROSION.SDR DALA1023123701Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT STA 312, LBL 11 REPAIR IAW SRM 53-00-51.SDR UALA2010091603439Bolt · sheared1 BOLT FOUND SHEARED AT FLOORBEAMS EXPANSION JOINT AFT OF F46. REPLACED ALL 6 BOLTS AND NDT STRUCTURE, NO CRACKS. FOUND. C-W ON SMB W-U G8897H.SDR SWAA105542Support Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM SUPPORT ANGLE CRACKED AT BS 639, RBL 45.50. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR SWAA105539Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 664, BL 0. REPAIRED WEB PER SI.SDR DALA1022759868Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON FLOORBEAM AT BS 1151 BETWEEN LBL 10-20. REPAIRED IAW SRM 51-70-5.SDR AALA20100914TUL01Floorbeam · corrodedCORROSION ON TOP SURFACE OF FLOORBEAM STATION 947 RIGHT BUTTLINE 23 TO RIGHT BUTTLINE 26. INSTALLED NEW T CORD SECTION PER SRM 53-70-51-1A.SDR FDEA201009133422Floorbeam · corrodedCORROSION ON UPPER FLANGE OF FLOORBEAM AT BS 344 FROM LBL 10 TO RBL 10. REMOVED DAMAGED AREA 8' SECTION IAW SRM 53-10-8 AND 51-30-2. FABRICATED REPAIR TEE SECTION, ANGLES, AND SHIMS IAW SRM 53-10-8 FIG 9 DETAIL 1. INSTALLED REPAIR PARTS IAW SRM 51-30-2 AND 5SDR ASOA201001320Floorbeam · corrodedCORROSION ON FLOORBEAM AT LBL 9.0 BETWEEN FS 469.00 - FS 597 MULTIPLE LOCATION COMING FROM UNDER SEAT TRACK. REMOVED SEAT RAILS IAW AMM 53-00-49-000-801. CORROSION REMOVED FROM TOP OF FLOORBEAM IN 3 LOCATIONS BETWEEN FS 469 & FS 661.00 LBL9 IAW SRM 51-21-06-SDR ASOA201001319Floorbeam · corrodedCORROSION ON FLOORBEAM AT RBL 9.0 BETWEEN FS 469.00 FS 597 MULTIPLE LOCATIONS COMING FROM UNDER FLOOR TRACK. BLENDED CORROSION AND REMOVED 2 NUTPLATES IAW SRM 51-21-06-001-001-A01. AND 51-42-10-001-001-A01. PERFORMED UT THICKNESS INSP OF BLEND AREAS ON FLOORSDR CALA2010091700435Floorbeam · corrodedCABIN STA 325 LBL 40 FLOORBEAM FOUND CORROSION. CABIN FLOORBEAM UPPER CHORD CORROSION AREA REPAIRED AS PER SRM 53-00-51 REPAIR 1 FIG 201 AT STA 325 LBL 40 AND FORM 44.0008 ATTACHED ITEM 1-25 ACCOMPLISHED.SDR CALA2010091700434Floorbeam · corrodedCABIN STA 303 LBL 30-40 FLOORBEAM FOUND CORROSION. CABIN CORRODED FLOORBEAM UPPER CHORD REPLACED AS PER SRM 53-00-51 REPAIR FIG 201 AT STA 303 LBL 30-40 AND FORM 44.0008 ATTACHED ITEM 1-15 ACCOMPLISHED.SDR SWAA105521Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 675, BL 0. REPAIRED BEAM PER SRM.SDR SWAA105520Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 670.5, BL 0. REPAIRED BEAM PER SRM.SDR SWAA105518Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 660, BL 0. REPAIRED WEB PER EA.SDR SWAA105517Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM T-CAP CRACKED AT BS 660, BL 0. REPAIRED T-CAP PER EA.SDR SWAA105509Floorbeam · crackedDURING SCHEDULED 14YCHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 674, LBL 24.5. REPAIRED CHORD PER ER AND EA.SDR SWAA105508Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 670, LBL 24.5. REPAIRED CHORD PER ER AND EA.SDR SWAA105507Floorbeam · crackedDURING SCHEDULED 14YCHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 665, LBL 24.5. REPAIRED CHORD PER ER AND EA.SDR SWAA105500Floorbeam · puncturedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM PUNCTURED AT BS 1028, BETWEEN RBL 17R TO RBL 27R. REPAIRED BEAM PER SRM AND DWG.SDR SWAA105497Angle · crackedDURING SCHEDULED 26Y CHECK, FOUND FLOORBEAM VERTICAL ANGLE CRACKED AT BS 328, LBL 29. REMOVED AND REPLACED ANGLE PER BAC DWG.SDR SWAA105477Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER EA.SDR SWAA105466Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM WEB CORRODED AT BS 1010, LBL 39. REPAIRED WEB PER SRM.SDR LR7A2010091400036Floorbeam · corrodedDURING SCHEDULED C-10 CHECK PER JOB CARD HC5313 FOUND UNDER DECK FLOORBEAM EXFOLIATION CORROSION ON LOWER SURFACE AROUND ANCHOR NUTS AT FS 196 LBL 30 TO 50, WL 145. REPAIRED IAW LOCKHEED SMP583 FIG 51-140-23 & CHAP 51-30 & SMP515B 53-10-00 PG 1.SDR FDEA201009133358Floorbeam · corrodedMAIN CARGO COMPARTMENT FLOORBEAM, STA 1320 HAS CORROSION ON TOP SIDE. REMOVED CORROSION ON FLOORBEAM, STA 1320 AND FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DETAIL VI. ORIG MATERIAL .125 AFTER REWORK .106. R & R FLOORBEAM IAW SRM 51-40-02. CLASDR USAA2010100792213Floorbeam · corrodedSAL - C22 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON UPPER CHORD OF FLOORBEAM AT BS 294.5 BETWEEN RBL 37 TO RBL 50. REPAIRED UPPER CHORD OF FLOORBEAM AT BS 294.5 BETWEEN RBL 37 TO RBL 50 IAW B737 SRM 53-10-51 REPAIR 5.SDR DALA1022123102Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON CABIN FLOORBEAM AT +Y1292 FR68. REPAIRED IAW SRM 51-42-11, SRM 51-44-11.SDR DALA1022113102Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON CABIN FLOORBEAM AT +Y1292 FR66. REPAIRED IAW SRM 51-42-11, SRM 51-44-11.
Back to JASC 5315