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 RRXA991199Floorbeam · corrosionDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 640 AND STA 720 AT BL 36 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 51SDR RRXA991197Floorbeam · corrosionDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 540 AND BL 42 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 53-2-3 PAGES 39/4SDR RRXA991196Floorbeam · corrosionDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 560 AND BL 56 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 53-2-3 PAGES 30/4SDR RRXA991195Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 500 AND BL 42 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 53-2-3 PAGES 39/4SDR RRXA991194Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 320 AND BL 54 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM 1-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 53-2-3 FIG 10 PAGES 39/40. (CORROSION DAMAGE RECORDED IN EWA CSDR RRXA991193Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 260 AND STA 330 AT BL 12 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAWSDR RRXA991192Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 260 AND STA 300 AT BL 4 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 53-SDR RRXA991191Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 260 AND STA 300 AT BL 12 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 5SDR RRXA991190Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 260 AND STA 300 AT BL 20 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 5SDR UPS99829030Floorbeam · corrodedINSPECTION TYPE-C1, STA 1700 AT RBL 24, THE FLOORBEAM FLANGE HAS HEAVY CORROSION. REPAIRED AREA IAW DHC SK 811-080.SDR SWAA990462Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON FLOORBEAM AT BS 328 AROUND SCREW HOLES, RBL 25 TO RBL 43. REPAIRED PER SRM.SDR SWAA990461Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON FLOORBEAM AT T-CAP NUT PLATE HOLES ON BS 277, LBL 30, LBL 38, AND LBL 49. REPAIRED PER SRM.SDR SWAA990460Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON FLOORBEAM AT BS 326 BL 0. REPAIRED BEAM PER SRM.SDR P5CA9900314Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 680 LBL 12 FLOORBEAM LOWER FLANGE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900313Floorbeam · brokenFORWARD CARGO BS 640 LBL 45 FLOORBEAM UPPER CHORD FOUND BROKEN. CRACKED AREA TRIMMED OFF AS PER SRM 51-10-01 AND TREATED PER SRM 51-10-02.SDR P5CA9900290Floorbeam · corrodedLEVEL 1 CORROSION FOUND MAIN DECK BS 1372 RBL 57 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR AALA994042Floorbeam · corrodedAFW - FLOORBEAM AT STATION 764 HAS CORROSION REMOVAL ON UPPER SURFACE MATERIAL REMAINING IS BEYOND SRM LIMITS. BLENDED AREA. FABRICATED REPAIR STRAP OUT OF 301.5 HARD STAINLESS STEEL .050 INCH THICK. ALODINED ALL BARE ALUMINUM SURFACES AND FINISHED BLENDS WSDR RRXA991215Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 740 AND BL 49 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC8 SRM 51-1-8 AND 53-2-3 FIG 10SDR RRXA991210Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1300 AND STA 1340 AT BL 6 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW DC8 SRM 53-2-3 PASDR RRXA991209Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 1340 AND BL 12 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC8 SRM 53-2-3 PAGES 39/40 FIG SDR RRXA991208Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK AT STA 1360 AND BL 12 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 53-2-3 PAGES 39/4SDR P5CA9900331Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2140 LBL 73 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900330Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2140 LBL 22 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900329Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2100 LBL 92 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900328Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2040 LBL 91 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900327Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1920 LBL 90 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900326Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1700 LBL 85 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900321Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1416 TO 1500 LBL 11-33 FLOORBEAM AND ATTACH TIE DOWN FITTING. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900320Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 980 LBL 8295 FLOORBEAM LOWER FACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900317Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 800 LBL 82 TO 95 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900315Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 760 LBL 75-98 FLOORBEAM UPPER SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900310Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 520 LBL 33 TO 70 FLOORBEAM AT UPPER SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900309Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 500 LBL 20-30 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900307Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 460 LBL 68-95 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900304Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 360 LBL 33 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900303Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 320 LBL 11 TO 33 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900296Floorbeam · corrodedLEVEL 1 CORROSION FOUND MAIN DECK BS 2140 RBL 85 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900295Floorbeam · corrodedLEVEL 1 CORROSION FOUND MAIN DECK BS 2140 RBL 38 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900294Floorbeam · corrodedLEVEL 1 CORROSION FOUND MAIN DECK BS 2040 RBL 21 FLOORBEAM UPPER CHORD LOWER FACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900293Floorbeam · corrodedLEVEL 1 CORROSION FOUND MAIN DECK BS 1940 RBL 50 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900288Floorbeam · corrodedLEVEL 1 CORROSION FOUND MAIN DECK BS 980 RBL 55 TO 77 FLOORBEAM UPPER TEE CHORD LOWER FACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900287Floorbeam · corrodedLEVEL 1 CORROSION FOUND MAIN DECK BS 760 RBL 95-98 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900282Floorbeam · corrodedLEVEL 1 CORROSION FOUND MAIN DECK BS 400 RBL 38 FLOORBEAM SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900280Floorbeam · corrodedLEVEL 1 CORROSION FOUND MAIN DECK BS 2140 LBL 10 TO RBL 10 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900279Floorbeam · corrodedLEVEL 1 CORROSION FOUND MAIN DECK BS 2040 LBL 10 TO RBL 10 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900276Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 660 LBL 11 TO RBL 11 FLOORBEAM SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR ABXA9900239Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM CORRODED AT STATION 294. REPAIRED FLOORBEAM IAW ABX REA D953-26903MR.SDR P5CA9900332Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 2240 LBL 75 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900324Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1560 LBL 10 FLOORBEAM LOWER CHORD UPPER AND LOWER SURFACE. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.SDR P5CA9900323Floorbeam · corrodedLEVEL 1 CORROSION FOUND AT MAIN DECK BS 1500 LBL 82-96 FLOORBEAM. CORROSION REMOVED PER SRM 51-10-01, WITHIN SRM 53-10-01 LIMITS. AREA TREATED PER SRM 51-10-02.
Back to JASC 5315