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 SWIA201024046Floorbeam · crackedFS 280 FLOORBEAM CRACKED AND CORRODED. (C CHECK) REPLACED PER REO.SDR USAA2010030590505Strap · crackedMCN - C20 - MAJOR REPAIR - CRACK ON FLOORBEAM STABILIZER STRAP AT BS 314, WL 208.1, LBL 45.5. REPAIRED FLOOR BEAM STABILIZER STRAP AT BS 314, WL 208.1, LBL 45.5 IAW B737 SRM 53-10-51 REPAIR 4.SDR USAA2010030590504Strap · crackedMCN - C20 - MAJOR REPAIR - CRACK ON FLOORBEAM STABILIZER STRAP AT BS 328, WL 208.1, BL 0. REPAIRED FLOORBEAM STABILIZER STRAP AT BS 328, WL 208.1, BL 0 IAW B737 SRM 53-10-51 REPAIR 4.SDR USAA2010030590503Strap · crackedMCN - C20 - MAJOR REPAIR - CRACK ON FLOORBEAM STABILIZER STRAP AT BS 344, WL 208.1, LBL 11. REPAIRED FLOORBEAM STABILIZER STRAP AT BS 344, WL 208.1, LBL 11 IAW B737 SRM 53-10-51 REPAIR 4.SDR USAA2010030590502Strap · crackedMCN - C20 - MAJOR REPAIR - CRACK ON FLOORBEAM STABILIZER STRAP AT BS 328, WL 208.1, RBL 45. REPAIRED FLOORBEAM STABILIZER STRAP AT BS 328, WL 208.1, RBL 45 IAW B737 SRM 53-10-51 REPAIR 4.SDR ASOA201000339Floorbeam · corrodedCARGO FLOORBEAM CAP FROM FS 574.00 - 605.00 LBL 27.00 IS CORRODED AROUND NUTPLATE HOLES. REMOVED CARGO FLOORBEAM CAP FROM STA 574-605 LBL 27.00 IAW SRM 51-42-06 AND 51-42-21. LOCATED, DRILLED, COUNTERSUNK AND DEBURRED NEW CARGO FLOORBEAM CAP IAW SRM 51-40-11.SDR SWAA101215Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER SRM.SDR SWAA101176Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, BETWEEN RBL 35 TO RBL 42. REPAIRED BEAM PER SRM.SDR DALA104639872Floorbeam · crackedDURING H-CHECK FOUND APD TEE FITTING CRACKED ON LBL 10 SIDE. R & R TEE FITTING IAW SRM 51-30-5.SDR DALA104519872Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOORBEAM AT BS 237, BL 2-22L. REPAIRED IAW SRM 53-05-20 & 51-30-2.SDR DALA104509872Floorbeam · crackedDURING H-CHECK FOUND CRACK IN FLOOR SUPPORT AT BS 237 LBL 2. REPLACED FLOOR SUPPORT IAW SRM 51-30-2.SDR CALA2010022600053Floorbeam · corrodedB757-53-3-0007 FLOORBEAM STA 720 HAS HEAVY CORROSION AT UPPER CAP FROM L2 DOOR THRESHOLD TO R2 DOOR THRESHOLD. REMOVED AND REPLACED UPPER FLOORBEAM CAP AT STA 720 FROM L2 DOOR THRESHOLD TO R2 DOOR THRESHOLD REF B757 SRM 51-40-02 AND EA 5320-01454.SDR AALA20100225TUL21Floorbeam · corrodedSTATION 986 FLOORBEAM CORRODED AT RIGHT BUTTLINES 25 TO 30. ACCOMPLISHED DOUBLER REPAIR.SDR AALA20100225TUL20Floorbeam · corrodedSTATION 986 FLOORBEAM CORROSION AT RIGHT BUTTLINES 15 TO 20. ACCOMPLISHED DOUBLER REPAIR.SDR AALA20100225TUL19Floorbeam · corrodedSTATION 986 FLOORBEAM CORRODED AT RIGHT BUTTLINES 10 TO 15. ACCOMPLISHED DOUBLER REPAIR.SDR AALA20100225TUL18Floorbeam · corrodedSTATION 986 FLOORBEAM CORRODED AT RIGHT BUTTLINES 5 TO 10. ACCOMPLISHED DOUBLER REPAIR.SDR AALA20100225TUL16Floorbeam · corrodedSTATION 986 FLOORBEAM CORROSION AT NUT PLATE LEFT BUTTLINE 5. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-00-51.SDR AALA20100225TUL30Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 967 AND RIGHT BUTTLINE 18 TO 30. INSTALLED FLOORBEAM DOUBLER REPAIR PER SRM 53-00-51-2R.SDR IPXA10558861Floorbeam · corrodedINSPECTION TYPE:C2, MAIN CARGO FLOOR UPPER FLOOR SUPPORT HAS CORROSION ON ENTIRE SUPPORT BRACKET AT STA 1024 FROM LBL 1 TO LBL 22 WL 208. FABRICATED FLOOR SUPPORT AND UPPER SKIN COMMON TO FLOOR SUPPORT, ALODINED AND PRIME, INSTALLED REF SRM 51-40-05-0G, SRSDR ASOA201000368Crossbeam · corrodedRT 280 CROSS BEAM REQUIRES REMOVAL FOUND CORRSION. REMOVED RT 280 CROSSBEAM IAW SRM 51-42-06 & 51-42-21 TASK 51-42-06-001-001-A01, 51-42-21 001-001-A01. INSTALLED RT 280 BEAM.SDR IPXA10558742Floorbeam · crackedINSPECTION TYPE:C2 MAIN CARGO FLOOR UPPER FLOOR SUPPORT NUT PLATE RIVETS PULLED APART FROM SUPPORT BRACKET AT STA 1024 RBL 1 TO RBL 22 WL 208. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR IPXA10558735Floorbeam · corrodedINSPECTION TYPE:C2 MAIN CARGO FLOOR UPPER FLOOR SUPPORT HAS CORRODED NUT PLATES AT STA 1056 LBL 1 TO LBL 22 WL 208. BLENDED CORROSION, FOUND TO BE OUT OF LIMITS. REPLACED WITH NEW FLOOR SUPPORT IAW SRM 53-00-51-1A-1, FIG 101, DETAIL II, SRM 51-40-05-0G, SRM SDR ASOA201000340Floorbeam · corrodedLT 280 CROSSBEAM REQUIRES REMOVAL FOUND CORROSION. REMOVED LT 280 CROSSBEAM IAW SRM 51-42-06-001-001-A01 & 51-42-21-001-001-A01. PICKED UP FASTENERS HOLES IN NEW FS 280 LT CROSSBEAM FOR SOLID RIVETS AND LOCK FASTENERS IAW SRM 51-42-05-001-001-A01 & 51-42-06-SDR USAA2010030190470Floorbeam · crackedCLT - Q5 - MAJOR REPAIR - CRACKS IN LONGITUDINAL FLOORBEAM AT BS 665 & BS 670, LBL 24.8. REPAIRED LONGITUDINAL FLOORBEAM AT BS 665 & BS 670, LBL 24.8 IAW EA 101709.SDR IPXA10558691Floorbeam · corrodedINSPECTION TYPE:C2 MAIN CARGO FLOOR UPPER FLOOR SUPPORT HAS CORROSION ON ENTIRE SUPPORT BRACKET AT STA 1024 FROM LBL 1 TO LBL 22 WL208. FABRICATED FLOOR SUPPORT AND UPPER SKIN COMMON TO FLOOR SUPPORT, ALODINED AND PRIME, INSTALLED REF SRM 51-40-05-0G, SRM 51-SDR ASOA201000313Floorbeam · corrodedFWD FLOOR SUPPORT ANGLE OF FS 280 BEAM CORRODED. REMOVED FS 280 FWD SUPPORT ANGLE IAW SRM 51-42-21. INSTALLED FLOOR SUPPORT ANGLE PN CC670-33292-135 IAW SRM 51-42-06-001-001-A01 AND 51-42-20-001-001-A01.SDR ZZDA2010132Floorbeam · corrodedCABIN FLOOR SUPPORT BEAM, STA 200, RBL 8 TO RBL 48, CORROSION. ACCOMPLISHED FLOOR SUPPORT BEAM REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2010131Floorbeam · corrodedCABIN FLOOR SUPPORT BEAM, STA 200, LBL 6 TO RBL 6, CORROSION. ACCOMPLISHED FLOOR SUPPORT BEAM REPLACEMENT PER B717 SRM 51-41-02.SDR ZZDA2010130Floorbeam · corrodedCABIN FLOOR SUPPORT BEAM, STA 160, LBL 6 TO RBL 6, CORROSION. ACCOMPLISHED FLOOR SUPPORT BEAM REPLACEMENT PER B717 SRM 51-41-02.SDR C77A241171AFloorbeam · corrodedDURING BASIC CHECK MX INSPECTION VISIT CORROSION WAS FOUND ON LT FLOORBEAM PN170-65669-004 AT FR 86. PERMANENT REPAIR WAS ACCOMPLISHED REF ETD 2010-170/01245 AND COMPASS EO E175-53MR-026.SDR AALA20100224TUL06Floorbeam · corrodedCORROSION TOP OF FLOORBEAM AT STATION 680 LEFT BUTTLINE 12. BLENDED AND TREATED PER EA 009248.SDR AALA20100224TUL13Stiffener · crackedSTIFFENER CRACKED ON FLOORBEAM AT STATION 700 AND LEFT BUTTLINE 24. REMOVED DAMAGED STIFFENER AND INSTALLED SERVICEABLE STIFFENER PER SRM 51-10-02-G8.SDR ASAA1047669Floorbeam · corrodedFLOORBEAM AT FS 987 RBL 10 REPAIRED SECTION HAS CORROSION IN MULTIPLE AREAS. REMOVED REPAIR SECTION, FABRICATED REPAIR CHORD, SPLICES AND INSTALLED REPAIR PARTS.SDR ASAA1047668Floorbeam · corrodedFLOORBEAM AT FS 947 LBL 15 TO RBL 15 REPAIRED SECTION HAS CORROSION IN MULTIPLE AREAS. REMOVED REPAIR SECTION, FABRICATED REPAIR CHORD, ANGLES AND INSTALLED REPAIR PARTS.SDR ASAA1047517Floorbeam · corrodedFLOORBEAM UPPER CAP AT STA 294 RBL 44. REMOVED DAMAGED FLOORBEAM UPPER CAP, FABRICATED NEW AND INSTALLED.SDR DALA104299872Floorbeam · crackedDURING "H" CHECK FOUND CRACK IN FLOOR SUPPORT AT BS 313 RBL3. REPLACED FLOOR SUPPORT IAW SRM 51-10-4, 51-30-2.SDR ZZDA2010126Floorbeam · corrodedCABIN FLOOR SUPPORT BEAM, STA 150, RBL 32 TO RBL 45, CORROSION. ACCOMPLISHED FLOOR SUPPORT BEAM REPLACEMENT PER B717 SRM 51-41-02.SDR AALA20100223TUL03Floorbeam · corrodedFLOORBEAM 986 HAS CORROSION AROUND NUT PLATE HOLES FROM BUTTLINE 20 TO BUTTLINE 30. INSTALLED REPAIR PER AARD 53-00-00-7 AND SRM 53-00-51-2R.SDR USAA2010031090558Floorbeam · crackedCLT - Q5 - MAJOR REPAIR - CRACK ON FLOORBEAM UPPER CHORD AT BS 663, RBL 24.8. REPAIRED FLOORBEAM UPPER CHORD AT BS 663, RBL 24.8 IAW EA 101708.SDR ASOA201000304Floorbeam · corrodedON INSP, FOUND 280 BEAM TO BE CORRODED OUT OF LIMITS. EO 700-53-0061 ITEM 3 CUT OUT DAMAGED 280 LT AND RT BEAM SECTIONS. REMOVED FS 280 FLOORBEAM FASTENERS IAW SRM 51-42-06 AND 51-42-21 TO COMPLETELY REMOVE DAMAGED BEAM SECTIONS FOR REPLACEMENT. CUT FLOORBEASDR UVVR2010022600006Floorbeam · corrodedANGLE CORRODED (EXFOLIATED) ON LOWER FS 166.3 FUSELAGE FLOOR SUPPORT WEB RT BP 8-10, ATTACHED TO LOWER FUSELAGE SKIN AND WEB.SDR AALA20100222TUL03Floorbeam · corrodedFLOORBOARD CORRODED AT STATION 967 LEFT BUTTLINE 31. INSTALLED ANGLE REPAIR PER AARD 53-00-00-7 AND SRM 53-00-51.SDR ASOA201000298Floorbeam · corrodedCARGO BAY FLOORBEAM AT LBL 27 IS CORRODED OUT OF LIMITS (EXFOLIATION) AT AFT END AROUND OTBD FLANGE NUTPLATE HOLE. REMOVED DAMAGED FLOORBEAM CAP IAW SRM 51-42-06 & 51-42-21. LOCATED & DRILLED & INSTALLED NEW FLOORBEAM CAP IAW REO 601R-53-61-3548 STEPS 1-7. SDR SIMA201005307Floorbeam · corrodedDURING MAINTENANCE BASE VISIT THE RIGHT FLOORBEAM AT FRAME 280 WAS FOUND TO BE CORRODED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE RIGHT FLOORBEAM AT FRAME 280 IAW EO CR-53MR-134R1. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA201005306Floorbeam · corrodedDURING MAINTENANCE BASE VISIT THE LEFT FLOORBEAM AT FRAME 280 WAS FOUND TO BE CORRODED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE LEFT FLOORBEAM AT FRAME 280 IAW EO CR-53MR-134R1. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR GTIA1000009Floorbeam · corrodedRT FLOORBEAM BETWEEN FR66 AND FR68. R & R "Z" BEAM.SDR GTIA1000007Floorbeam · corrodedFLOORBEAM AT 765 BETWEEN FRAME 66.5 AND FRAME 70 CORRODED. R & R FRAME.SDR GTIA1000006Floorbeam · corrodedFLOORBEAM AT -765 BETWEEN FRAME 66.5 AND FRAME 70 CORRODED. R & R FRAME.SDR SWAA100953Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND LONGITUDINAL FLOORBEAM LOWER WEB CRACKED AT BS 713, LBL 24.5. REPAIRED WEB PER ER.SDR SWAA100948Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, LBL 22. REPAIRED BEAM PER EA.
Back to JASC 5315