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 SWIA200820428Floorbeam · crackedFS 280 LBL9 LOWER FLOOR SUPPORT CRACKED AT RADIUS. REPAIRED PER REO.SDR SWIA200820427Floorbeam · crackedC-CHECK, FS 280 RBL9 AND LBL9 UPPER FLOOR SUPPORT CRACKED. REPAIRED PER REO.SDR SWIA200820426Floorbeam · crackedC-CHECK, FS 280 RBL9 LOWER FRAME CRACKED. REPAIRED PER REO.SDR K11A2008102372204Floorbeam · corrodedCORROSION AROUND FASTENER HOLE ON FLOORBEAM BOTTOM CHORD.SDR 2008UALA04380Floorbeam · corrodedMAIN CABIN STA 1640 FLOORBEAM TEE CAP CORRODED AT RBL 55. MAJOR REPAIR ACCOMPLISHED: CUTOUT CORRODED SECTION & INSTALLED REPAIR PER MM 53-00-98.SDR UPS08553233Floorbeam · crackedINSPECTION TYPE:C3 BS 900 BL 0 RBL 25 WL 208 FLOOR SUPPORT UPPER COVER BROKEN. FABRICATED & REPLACED IAW SRM 51-20-01 53-01-60.SDR SWIA200820414Floorbeam · corrodedC-CHECK, FS 280 LEFT WEB CORRODED. REPAIRED PER REO.SDR SWIA200820413Floorbeam · corrodedC-CHECK, FS 280 RIGHT WEB CORRODED. REPAIRED PER REO.SDR SWIA200820412Floorbeam · crackedC-CHECK, FS 280 CROSSBEAM CRACKED AT LBL9. REPAIRED PER REO.SDR KCSA081409Floorbeam · gougedSTA 540 FLOORBEAM GOUGED ON UPPER CHORD LBL 41. (S)SDR SWIA200820394Floorbeam · crackedC-CHECK, CROSSBEAM AT FS 280 CRACKED AT RBL11 AND LBL11. REPAIRED PER REO.SDR USAA920081589Floorbeam · corrodedMCN - CORROSION MAJOR REPAIR - CORROSION ON FLOORBEAM AT FASTENER HOLES AT BS 986, RBL 15, BL 0, LBL 16. REPLACED FLOORBEAM AT BS 986, LBL 60 TO RBL 60 IAW US AIRWAYS EA NR 130099.SDR 08FDEA03502Floorbeam · corrodedMAIN CABIN BS 1070 LBL8 LOWER FLANGE ON FLOORBEAM HAS CORROSION. REMOVED 2 EACH PREVIOUS REPAIRS ON FLOORBEAM IAW SRM 51-30-2. REMOVED CORROSION ON LBL 8, FOUND AREA OUT OF LIMITS IAW SRM 51-10-6 AND 53-10-1. CUT OUT DAMAGED AREA IAW SRM 53-10-8 FIG 8. FABSDR SWAA084592Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 727D, LBL 12 TO RBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA084591Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 767, LBL 3 TO RBL 13. REPAIRED FLOORBEAM PER SWA EA.SDR SWIA200821307Floorbeam · corrodedLEFT INBOARD LONGITUDINAL FLOORBEAM CORRODED (C CHECK). REPAIRED PER SRM.SDR SWIA200821303Floorbeam · crackedFLOORBEAM WEB AT FRAME 13 CRACKED (C CHECK). REPAIRED PER SRM.SDR SWIA200820423Floorbeam · crackedC-CHECK, FS 280 FLOOR SUPPORT BEAM LBL 9 INBOARD CLIP CRACKED. REPAIRED PER REO.SDR SWIA200820422Floorbeam · crackedC-CHECK, FS 280 FLOOR SUPPORT BEAM INBOARD AND OUTBOARD CLIPS CRACKED. REPAIRED PER REO.SDR USAA920081557Floorbeam · corrodedPIT-S4-MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 AND FR68, -Y1162 TO -1292. REPLACED FLOORBEAM BETWEEN FR66 AND FR68, -Y1162 TO -1292 IAW A319 SRM 51-72-11. (S)SDR 08FDEA03489Floorbeam · crackedMAIN CABIN FRAME 48 SUB-FLOOR AT Y 145.6 FLOORBEAM WEB LOWER INBD MOUNT IS CRACKED. REMOVED AND REPLACED THE FITTING IAW A300-600 SRM 51-40-21;PARA 10-B.SDR 08FDEA03465Floorbeam · corrodedCABIN FLOORBEAM AT BS 350, LBL8, HAS CORROSION. MINOR SURFACE CORROSION BLENDED OUT AND SURFACE TREATED AND FOUND TO BE WITHIN ALLOWABLE LIMITS IAW B757-200, SRM 53-00-51 REV 93 DETAIL III, FIG 101. REPAIR IS CLASSIFIED AS MINOR PER GMM 6-2-100 CRITERIA.SDR 08FDEA03464Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM AT BS 324, LBL 20. MINOR SURFACE CORROSION BLENDED OUT AND SURFACE TREATED, FOUND WITHIN ALLOWABLE LIMIT IAW B757-200 SRM 53-00-51 REV. 93 DETAIL III FIG 101. REPAIR IS CLASSIFIED AS MINOR PER GMM 6-2-100 CRITERIA.SDR K11A20080817001Floorbeam · gougedFLOORBEAM STA 380, RBL 45 HAS GOUGES ON BOTH SIDES ON LOWER SURFACE OF UPPER CHORD AND ON UPPER WEB.SDR USAA920081546Stiffener · crackedCLT-Q6 -MAJOR REPAIR- CRACK ON FLOORBEAM WEB VERTICAL STIFFENER AT BS 328, BL 0. REPLACED FLOORBEAM WEB VERTICAL STIFFENER AT BS 328, BL 0 IAW B737 SRM 51-10-02. (S)SDR USAA920081559Floorbeam · corrodedPIT-S4-MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR66, -Y1292. REPLACED FLOORBEAM AT FR66, -Y1292 IAW A319 SRM 51-72-11. (S)SDR USAA920081556Floorbeam · corrodedPIT-S4- MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR68, -Y1182. REPLACED FLOORBEAM AT FR68, -Y1182 IAW A319 SRM 51-72-11. (S)SDR COMA086358Floorbeam · corrodedFOUND CORROSION ON UNDER FLOOR FRAME AT FS 280 BETWEEN LBL 9.00 AD RBL 9.00. REMOVED AND REPLACED FLOOR SUPPORT IAW CRJ SRM 51-42-06. (S)SDR UPS08553316Floorbeam · corrodedINSPECTION TYPE:C3 CORROSION ON UPPER SURFACE OF FLOOR SUPPORT AT STA 1720 RBL 4. REPAIRED OUT OF LIMITS. CORROSION BLEND PER EO B757-5310-30513A WITH DOUBLER, TRIPLERS AND FILLERS.SDR UPS08553292Floorbeam · corrodedINSPECTION TYPE:C3 CORROSION ON UPPER SURFACE OF FLOORBEAM AT STA 1320 RBL 25-65 WL 208. BLENDED OUT CORROSION PER ATS ER08-2738 DATED 28AUG08.SDR 08FDEA03454Floorbeam · crackedBULK CARGO DOOR ENTRY FLOOR T-CAP ON INTERCOSTAL HAS 4 IN CRACK BEGINNING AT FR 68 REMOVED DAMAGED T-CAP AND SPLICE STRIPS AND INSTALLED NEW PARTS AT BULK CARGO DOOR FLOOR ENTRY BETWEEN FR 67 AND FR 69 IAW A310-200 SRM 51-40-21 AND 51-72-10.SDR UPS08553291Floorbeam · corrodedINSPECTION TYPE:C3 MAIN CARGO FLOORBEAM UPPER SURFACE IS CORRODED BL 0 - RBL 65 WL 208 BS 440. BLENDED OUT CORROSION PER ATS ER08-2754 DATE 08AUG08.SDR USAA920081523Floorbeam · corrodedPIT -S4- MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR66, Y1292. REPLACED FLOORBEAM AT FR66, Y1292 IAW A319 SRM 51-72-11. (S)SDR USAA920081524Floorbeam · corrodedPIT-S4 -MAJOR REPAIR- LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 & FR68, FROM Y1162 TO 1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, Y1162 TO Y1292 IAW A319 SRM 51-72-11. (S)SDR USAA920081525Floorbeam · corrodedPIT - S4- MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR68, Y1162. REPLACED FLOORBEAM AT FR68, Y1162 IAW A319 SRM 51-72-11. (S)SDR USAA920081526Floorbeam · corrodedPIT - S4- MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR66, -Y1730. REPLACED FLOORBEAM AT FR66, -Y1730 IAW A319 SRM 51-72-11. (S)SDR 08FDEA03443Floorbeam · corrodedMAIN CABIN BS 1110 LBL 65 AND LBL 45 FLOORBEAM UPPER FLANGE HAS CORROSION. REPAIRED MAIN CABIN FLOORBEAM UPPER FLANGE BS 1110 LBL 57 CUTOUT AREA DIMS 3 1/2 INCH BY 1 INCH, FABRICATED REPAIR ANGLES (2EA). FABRICATED FILLER. INSTALLED REPAIR PARTS AT BS 1110 SDR 08FDEA03438Floorbeam · corrodedFOUND CORROSION ON CROSSBEAM C 67 RT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 08FDEA03437Floorbeam · corrodedFOUND CORROSION ON CROSSBEAM C 67 REPAIR PERFORMED BY REPLACEMENT OF PART IAW. SRM 51-72-10.SDR 08FDEA03430Floorbeam · corrodedLWR FWD CARGO COMPT FLOOR SUPPORT FITTING ATTACHED ON FLOORBEAM UPPER FLANGE HAS CORROSION AROUND FASTENER HOLES AT STA 735, X4 - 25. FABRICATED NEW SUPPORT ON MAE TRAVELER T8/754216. REMOVED AND REPLACED SUPPORT IAW SRM 51-31-01. MAJOR REPAIR.SDR 08FDEA03429Floorbeam · corrodedLWR FWD CARGO COMPT FLOOR SUPPORT ANGLE ATTACHED ON FLOORBEAM UPPER FLANGE HAS CORROSION AROUND FASTENER HOLE AT STA 1059, X 41-55. FABRICATED NEW FLOOR SUPPORT ON MAE TRAVELER T8/754037. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM 51-31-01. MAJOR REPAIR.SDR 08FDEA03428Floorbeam · corrodedLWR FWD CARGO COMPT FLOOR SUPPORT FITTING ATTACHED ON FLOORBEAM UPPER FLANGE HAS CORROSION AROUND FASTENER HOLES AT STA 791, X 4 - 25. FABRICATED NEW FLOOR SUPPORT ON MAE TRAVELER NR T8/754204. REMOVED AND REPLACED SUPPORT IAW SRM 51-31-01. MAJOR REPAIR.SDR 08FDEA03417Floorbeam · crackedFOUND CRACK ON FITTING FOR CROSSBEAM, C 67RH, P45. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 08FDEA03415Floorbeam · corrodedFOUND CORROSION ON CROSS BEAM C 58 IN AFT CARGO COMPARTMENT REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 08FDEA03414Floorbeam · damagedFOUND DOUBLE HOLE AT CROSSBEAM C 68, Y-525, AFT CARGO COMPARTMENT. SPLICE REPAIR OF CROSSBEAM PERFORMED IAW SRM 53-10-15 FIG 207.SDR SWIA200820410Floorbeam · crackedC-CHECK, FS 280 INBOARD AND OUTBOARD FLOOR SUPPORT CLIPS AT RBL9 CRACKED. REPAIRED PER REO.SDR SWIA200820409Floorbeam · crackedC-CHECK, FS 280 FORWARD FACE ANGLE CRACKED, REPLACED.SDR SWIA200820408Floorbeam · crackedC-CHECK, FS 280 FLOOR SUPPORT CAP ANGLE CRACKED. REPAIRED PER REO.SDR K11A2008102372203Floorbeam · corrodedFLOORBEAM ON THE LOWER SURFACE OF THE UPPER CHORD AT WEB HAS GRINDING MARKS AND CORROSION BEYOND LIMITS.SDR SWAA084484Floorbeam · corrodedDURING SCHEDULED HC2 CHECK, FOUND FLOORBEAM CORRODED AT BS 270, LBL 8 TO RBL 8. REPAIRED FLOORBEAM PER SRM.
Back to JASC 5315