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 SWAA102936Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 708, BBL 0.07. REPAIRED BEAM PER SI.SDR SWAA102933Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 709 TO BS 711, BBL 0.07. REPAIRED WEB PER SI.SDR SWAA102926Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 733, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA102920Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM PER AEM.SDR SWAA102912Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 43. REPAIRED BEAM PER EA.SDR USAA2010062191194Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR64 TO FR67, -Y465. REPLACED FLOORBEAM BETWEEN FR64 TO FR67, -Y465 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53472000.SDR USAA2010062191193Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR16 TO FR18, Y254. REPLACED FLOORBEAM BETWEEN FR16 TO FR18, Y254 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53112816.SDR USAA2010062191192Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON UPPER INBOARD SPLICE OF FLOOR BEAM AT FR64, -Y1292. REPLACED FLOORBEAM UPPER INBOARD COUPLING AT FR64, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2010062191191Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON LOWER OUTBOARD SPLICE OF FLOORBEAM AT FR64, -Y1292. REPLACED FLOORBEAM LOWER OUTBOARD COUPLING AT FR64, -Y1292 IAW A319 SRM 51-72-11.SDR IPXA10560502Floorbeam · corrodedINSPECTION TYPE:C2, FLIGHT COMPT STA 310.5, BL 0 TO LBL 65 FLOORBEAMS ARE CORRODED AROUND FASTENERS HOLE. REPAIRED IAW ATS ER NR 10-2876 DATED 10JUN10 AND EO B757-5310-37937-A.SDR COEA2010052003917Floorbeam · crackedLEFT LONGITUDINAL CARGO MOD FLOORBEAM JUST FORWARD OF FRAME 21 IS CRACKED. CRACK IS 0.5 INCHES IN LENGTH. REPAIR PER ENGINEERING ORDER 5315-01 (M7 SERVICE BULLETIN ATR 42-53-023).SDR COEA2010052002917Floorbeam · crackedLEFT LONGITUDINAL CARGO MOD FLOORBEAM JUST FORWARD OF FRAME 17 IS CRACKED. CRACK 0.5 INCHES IN LENGTH. REPAIR PER ENGINEERING ORDER 5315-01 (M7 SERVICE BULLETIN ATR42-53-023 (R2).SDR COEA2010052001917Floorbeam · crackedLEFT LONGITUDINAL CARGO MOD FLOORBEAM JUST FORWARD OF FRAME 26 IS CRACKED. CRACK 0.5 INCHES IN LENGTH. REPAIR PER ENGINEERING ORDER 5315-01 (M7 SERVICE BULLETIN ATR 42-53-023 (R2).SDR SWAA102856Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FWD GALLEY FLOOR BEAM UPPER T-CAP CORRODED AT BS 328 BETWEEN LBL 34 TO RBL 56. REMOVED AND REPLACED T-CAP PER SRM AND EA.SDR FDEA201005181565Floorbeam · corrodedNEEDS TO REPLACE STA 1640, FLOORBEAM DUE TO EXISTING REPAIR. R & R 1640 FLOORBEAM IAW SRM 51-40-02, LBL63-RBL63. MAJOR REPAIR.SDR SWIA201024649Floorbeam · crackedLBL 9.0 FLOORBEAM ANGLE BRACKETS CRACKED. (C-CHECK) REPLACED PER SRM.SDR IPXA10560657Floorbeam · corrodedINSPECTION TYPE:C4, TRANSVERSE FLOORBEAM UPPER CHORD FLANGE IS CORRODED AT BS 1100 LBL 25-45 WL 208. UPON INVESTIGATION FOUND 100 PERCENT MATERIAL LOSS OF BS 1100 FLOORBEAM, ACCOMPLISHED CONDUCTIVITY TEST OF BEAM, REMOVED FLOORBEAM, FABRICATED NEW REPLACEMENTSDR IPXA10560595Floorbeam · corrodedINSPECTION TYPE:C4, CORROSION ON FLOORBEAM UPPER CHORD BS 879, LBL 48-LBL 55. REPAIRED IAW ATS ER 10-2838.SDR IPXA10560472Floorbeam · corrodedINSPECTION TYPE:C4, UPPER SURFACE OF FLOORBEAM SUPPORT CORRODED COMMON TO 2 EA FASTENER HOLES BS 1054, RBL 53 TO RBL 57, WL 207. R & R FLOOR BOARD SUPPORT IAW SRM 51-40-02-0G, 51-21-04-7.SDR IPXA10560471Floorbeam · corrodedINSPECTION TYPE:C4, FLOORBEAM FLANGE CORRODED AT BS 900, LBL 0-25, WL 208 BLENDED FLOORBEAM FLANGE AT BS 900, FOUND TO BE OUT OF LIMITS. REMOVED FLOORBEAM, FABRICATED NEW REPLACEMENT FLOORBEAM. DRILLED TRIMED ALODINED, PRIMED AND INSTALLED NEW FLOORBEAM IAW SSDR IPXA10560468Floorbeam · corrodedINSPECTION TYPE:C4, UPPER SURFACE OF FLOORBOARD SUPPORT CORRODED AT FASTENER HOLE B/S 1054, RBL34, WL 207. R & R FLOOR SUPPORT IAW SRM 51-40-02-0G, SRM 51-40-06-0G, AND DWG 144N5005.SDR IPXA10560427Floorbeam · corrodedINSPECTION TYPE:C4, MAIN CARGO STA 1420, LBL 45.5 TO LBL 60 FLOORBEAM UPPER SURFACE IS CORRODED AROUND FASTENER HOLE. REPAIR IAW ATS ER 10-2875.SDR IPXA10560405Floorbeam · corrodedINSPECTION TYPE:C4, MAIN CARGO STA 1540, LBL45.5 TO LBL 60 FLOORBEAM UPPER SURFACE IS CORRODED AROUND FASTENER HOLE. REPAIR IAW ATS ER 10-2852.SDR IPXA10560309Floorbeam · corrodedINSPECTION TYPE:C4, CORROSION ON UPPER SURFACE OF FLOORBEAM COMMON TO 2 EA FASTNERS HOLES. BS 1200, RBL 48 TO RBL 52, WL 207. REPAIRED IAW ATS 10-2828.SDR USAA2010052691037Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON UPPER CHORD OF FLOOR BEAM AT BS325, WL200, LBL55. REPAIRED FLOORBEAM AT BS 325, WL 200, LBL 55 IAW B767 SRM 53-00-51 REPAIR 1.SDR IPXA10560067Floorbeam · corrodedINSPECTION TYPE:C4, CORROSION ON UPPER SURFACE OF FLOORBEAM UPPER CHORD COMMON TO 4EA FASTENER HOLES BS 1100 RBL 48 TO RBL 54 WL 207. ENTIRE UPPER CHORD OF BS 1100 TRANVERSER FLOORBEAM WILL BE R & R ON CUST ID NR 861458.SDR IPXA10560066Floorbeam · corrodedINSPECTION TYPE:C4, 6EA NUTPLATES CORRODED ON TRANSVERSE FLOORBEAM AT BS 1100 LBL 45-62. REMOVED 6EA NUTPLATES FROM FLOORBEAM, BLENDED CORROSION., NOTE. THE ENTIRE UPPER CHORD OF BS 1100 TRANVERSE FLOORBEAM WILL BE R & R ON CUST ID 861458.SDR IPXA10560065Floorbeam · corrodedINSPECTION TYPE:C4, TRANSVERSE FLOORBEAM UPPER CHORD FLANGE IS CORRODED AT BS 1100 LBL 0-25, WL 208. ENTIRE UPPER CHORD OF BS 1100 TRANVERSER FLOORBEAM WILL BE R & R ON CUST. ID 861458.SDR IPXA10560585Floorbeam · corrodedINSPECTION TYPE:C1, DUE TO RCD PROCESS, REPAIR REQUIRED AT BS 1200 FLOORBEAM, FWD FLANGE, RBL9, WL 208. REPAIRED IAW EO B757-5310-37909-A.SDR ASOA201000756Floorbeam · crackedFLOOR SUPPORT STRUCTURE IS CRACKED FS 280 AT RBL 9.0, WEB AND CLIP. REMOVED I/B AND O/B RBL 9.0 FS 280 CLIPS IAW SRM 51-42-06 AND 51-42-21. REPLACED I/B CLIP RBL 9.0 WITH NEW SERVICEABLE CLIP IAW SRM 51-42-06 AND 51-42-21. PERFORMED NDT PER NDTM 51-20-06. SDR FDEA201005161549Floorbeam · corrodedBULK CARGO PIT FLOORBEAM FR 64 TOP L/E OF FLANGE CORRODED 1.5 SQ INCH. LT OF CTR LINE. REMOVED CORROSION IAW SRM 51-74-10 , FOUND OUT OF LIMITS IAW SRM 53-10-00, FIG 104, TABLE 102. REPAIRED FLOORBEAM IAW SRM53-10-15, FIG 207SDR FDEA201005161548Floorbeam · corrodedBULK CARGO PIT FLOOR , FRAME 66 AT CTR LINE FLOORBEAM TOP SURFACE CORRODED. R & R FLOORBEAM AT FR 66 IAW SRM 51-72-10 PAGE 1-2 AND SRM 53-17-15, PAGE A68, FIG 11.SDR SWAA102789Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOOR BEAM CORRODED AT BS 772, LBL 17.24. REPAIRED BEAM PER SWA EA.SDR ASOA201000737Floorbeam · corrodedBULKHEAD FITTING ON FLOORBEAM CAP RBL 9 AT FS 621 CORRODED. REMOVED BULKHEAD FITTING ON FLOORBEAM CAP IAW SRM 51-42-21. DRILLED AND LOCATED NEW SERVICEABLE FITTING IAW SRM 51-40-11. INSTALLED FITTING AT FLOORBEAM CAP IAW SRM 51-41-02 AND REO 601R-53-61-3679SDR FDEA201005141537Floorbeam · corrodedL-3 DOOR FLOORBEAM AT STA 1320 LBL60 CORRODED. REMOVED CORROSION ON FLOORBEAM AT STA 1320, LBL 60 IAW SRM 51-10-02. FOUND OUT OF LIMITS IAW SRM 53-00-51, FIG 101 DETAIL III. R & R FLOORBEAM AT STA 1320, LBL 34-60 IAW SRM 53-00-51, FIG 201, REPAIR 1. CLASSIFSDR SWIA201024647Floorbeam · crackedFS 280 FLOORBEAM CRACKED AND CORRODED. (C-CHECK) REPLACED PER SRM.SDR IPXA10560407Floorbeam · corrodedINSPECTION TYPE:C1, THE UPPER FLANGE OF THE BS 1200 FLOORBEAM IS CORRODED AROUND THE FLOOR PANEL FASTENER HOLES RBL 9-54 WL 208. REPAIRED IAW EO B757-5310-37909-A.SDR IPXA10560406Floorbeam · corrodedINSPECTION TYPE:C1, THE UPPER FWD FLANGE OF THE BS 1200 FLOORBEAM IS CORRODED AROUND THE FLOOR PANEL FASTENER HOLES, LBL 4.54, WL 208. REPAIRED IAW EO B757-5310-37909-A.SDR SWAA102772Support Channel · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM SUPPORT CHANNEL CORRODED BETWEEN BS 259.5 TO BS 268.25, BETWEEN LBL 3 TO RBL 3. REMOVED AND REPLACED SUPPORT CHANNEL PER SRM.SDR SWAA102767Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 15. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA102766Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, LBL 15. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA102762Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND FLOORBEAM CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM PER AAR EA.SDR SWAA102728Floorbeam · corrodedDURING SCHEDULED MV2 CHECK, FOUND FLOORBEAM CORRODED AT BS 777, RBL 8. REPAIRED BEAM PER EA.SDR SWAA102727Floorbeam · corrodedDURING SCHEDULED MV2 CHECK, FOUND FLOORBEAM CORRODED AT BS 777, LBL 8. REPAIRED BEAM PER EA.SDR SWAA102726Floorbeam · corrodedDURING SCHEDULED MV2 CHECK, FOUND FLOORBEAM CORRODED AT BS 777, LBL 3. REPAIRED BEAM PER EA.SDR SWAA102725Floorbeam · corrodedDURING SCHEDULED MV2 CHECK, FOUND FLOORBEAM CORRODED AT BS 777, RBL 3. REPAIRED BEAM PER EA.SDR UHLA2010051200063Seat Track · corrodedLEVEL 2 CORROSION ON LT SEAT TRACK BEAM AT FRAME 16. REMOVED AND REPLACED SEAT TRACK BEAM AT FRAME 16 IAW EMB 170 SRM 51-40-00 AND 51-40-04.SDR FDEA201005121524Floorbeam · corrodedCORROSION FLOORBEAM TOP MAIN CABIN BS 480 BL 0 TO RBL 25. CUT DAMAGE OUT AREA 2.5" X 2", FABRICATED UPPER CHORD FROM BAC 1505-100617 DIM: 14.5" AND INSTALLED FLOORBEAM REPAIR IAW SRM 53-10-8 FIG 3, REV 102 AND SRM 51-30-2.SDR ASOA201000714Floorbeam · crackedFLOOR SUPPORT ANGLE AFT OF FS 280 IS CRACKED AT LBL 9.0. C/W EC/TC 601R-53-11-171 AND MET ALL REQUIREMENTS OF REO 601R-53-11-171. EC/TC REQUIRED FOR REO 601R-53-11-1901. COMPLIED WITH EC/TC REO 601R-53-11-1901 AND REO 601R-53-11-1901 REV A.SDR ASOA201000713Floorbeam · corrodedBS 280 BEAM LT AND RT SIDE BADLY CORRODED. COMPLIED WITH EC/TC SB 670BA-53-026 REV.B.
Back to JASC 5315