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 CALA9701496Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, RBL 15. A SPLICE REPAIR WAS INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR ABXA9701679Floorbeam · corrodedDURING C-CHECK, FOUND THE FLOORBEAM AT FS 1011 CORRODED AT THE AFT LOWER CARGO COMPARTMENT DOOR HOLD OPEN BRACKET. REPAIRED FLOORBEAM IAW DC9 SRM 53-05.SDR UPS97824874Floorbeam · corrodedINSPECTION TYPE-C, FLOORBEAM 920 RBL 64 TANG BLOWN OUT. REPAIRED IAW DHC SK 801-907.SDR UPS97824855Floor Beam · corrodedINSPECTION TYPE-C, EXFOLIATED CORROSION IN FLOORBEAM AT FS 902 LBL 48. REPAIRED IAW DHC SK-801-911.SDR SWAA970921Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND BS 967 FLOORBEAM CORRODED. REPAIRED PER BOEING SRM.SDR UPS97824854Floorbeam · corrodedINSPECTION TYPE-C, FS 660 RBL 58 - TOP OF FLOORBEAM HAS HEAVY CORROSION (METAL IS SEPARATING AT ATTACH TANG). REPAIRED IAW DHC SK-801-609.SDR AALA974055Floorbeam · corrodedAFW - FLOORBEAM CORRODED BEYOND LIMITS. FILLED, PRIMED AND PAINTED PER ENGINEERING MRB 767-1492. (M)SDR 97ZZZX4548Floor Beam · corrodedFLOOR BEAM CORRODED AT FS 879 OUTBOARD OF SECOND SEAT TRACK FROM CENTER RT. REPAIR FLOOR BEAM PER SRM 53-00-51. TAT: 2,628.8 HOURS. TAC: 5,944.SDR 97ZZZX4543Floor Beam · corrodedSTA 880 FLOOR BEAM BETWEEN LBL 45.5 AND LBL 24.75, FORWARD UPPER CHORD OUTBOARD, FLOOR BOARD FASTENERS HOLE LOWER SIDE, HAS INTERGRANULAR CORROSION. REPAIR SEAT TRACK PER SRM 53-00-51. TAT: 2,628.8 HOURS. TAC: 5,944.SDR 97FDEA00756Floorbeam · damagedBS 344, LBL 58 FWD UPPER FLANGE FLOORBEAM HAS .75 RADIUS CUT IN IT SHARP AND JAGGED. INSTALLED NEW FLOORBEAM CAP SPLICE BS 344, LBL 50 TO LBL 69 PER FED-EX DRAWING SR 27-53-007.SDR 97FDEA00751Floorbeam · corodedNR 0621 GEN NR 72C237-02, BS 950 FLOORBEAM CAP LBL 45 TO LBL 55 HAS CORROSION ON TOP AND AROUND NUTCLIP HOLES INSTALLED STRAP IN ACCORDANCE WITH EA 7-5310-29241 DATED 10/7/97.SDR SIMA972841Floor Beam · corrodedSAW - DURING CPCP-1 INSPECTION, MAINTENANCE DISCOVERD RT FLOOR BEAM NR 40 CORRODED OUT OF LIMITS. MAINTENANCE REMOVED AND REPLACED FLOOR BEAM NR 40 IAW SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (X)SDR USAA970297Floor Beam · corrosionCLT - DURING Q-6 VISUAL INSPECTION, FOUND CORROSION AROUND SCREW HOLES ON FLOOR BEAM STA 344 RBL 2 AND 10. CORROSION TASK NR C53-107-02. REMOVED AND REPLACED T-CAP PER TYPICAL REPAIR DOCUMENT 53-10-03. (X)SDR USAA970296Floor Beam · corrosionCLT - DURING Q-6 VISUAL INSPECTION, FOUND CORROSION AROUND SCREW HOLES ON FLOOR BEAM STA 344 LBL 9.5, 21, 28, AND 49. CORROSION TASK NR C53-107-02. REMOVED AND REPLACED T-CAP PER TYPICAL REPAIR DOCUMENT 53-10-03. (X)SDR USAA970295Floor Beam · corrosionCLT - DURING Q-6 VISUAL INSPECTION, FOUND A CORRODED AREA OF 6 INCH BY 3 INCH STA 947 BL ZERO ON FLOOR BEAM. CORROSION TASK NR C53-107-02. INSTALLED DOUBLER ON FLOOR BEAM 947 LBL 8- RBL 8 PER SRM 53-00-51. (X)SDR USAA970292Floor Beam · corrosionCLT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND CORROSION ON STA FLOOR BEAM COVERING APPROXIMATELY 124 INCHES BY 2 INCHES LONG AT 328 FLOOR BEAM FROM LBL 36 TO RBL 58 ON UPPER AND LOWER SURFACE OF T-CAP. INSTALLED T-CAP PER REPAIR DOCUMENT T/R 53-10-03. (X)SDR UPS97824779Floorbeam · crackedINSPECTION TYPE-C, FLOORBEAM CRACKED AT BOLT HOLE FS 1660 LBL 44. REPAIRED IAW DHC SK-810-602.SDR 97ZZZM1115Floorbeam · corrodedFLOORBEAM AT STATION 344 CORRODED BEYOND LIMITS END TO END. REMOVED AND REPLACED FLOORBEAM IAW BOEING SRM 51-10-2, 51-10-6, 51-30-2 AND 51-10-01 AND 53-10-8. (M)SDR 97ZZZM1113Floorbeam · corrodedFLOORBEAM AT STATION 380 CORRODED BEYOND LIMITS. REMOVED AND REPLACED FLOORBEAM IAW BOEING SRM 51-10-2, 51-10-6, 51-30-2, 51-10-01 AND 53-10-8. (M)SDR 97ZZZM1108Floorbeam · corrodedFLOORBEAM CORRODED END TO END AT STATION 400 BEYOND LIMITS. REMOVED AND REPLACED FLOORBEAM IAW BOEING SRM 51-10-2, 51-10-0, 51-10-6, 51-30-2 AND 53-10-8. (M)SDR 97FDEA00725Floorbeam · corrodedCORROSION (C53-224-01) ON FLOORBEAM TOP FLANGE BS 344, RBL 20 LBL 55, WL 208. *S/D* REMOVED AND REPLACED UPPER CHORD FLOORBEAM BS 344 FROM RBL 63 TO LBL 63 IAW FEDEX SRM 53-10-8.SDR SIMA9728210Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE DISCOVERED FLOORBEAMS 36 AND 38 CORRODED OUT OF LIMITS. MAINTENANCE REMOVED AND REPLACED FLOORBEAM 36 IAW SRM 51-25-01. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 97FDEA00717Floorbeam · corrodedCORROSION ON UPPER CHORD OF FLOORBEAM AT BS 312, LBL 30, WL 208. *S/D* FOUND CORROSION TO BE OUT OF LIMITS. REMOVED CORROSION AT BS 312 FLOORBEAM UPPER CHORD LBL 30, WL 208 IAW FED-EX SRM 53-10-8 FED-EX SRM 53-10-1.SDR SWAA970890Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 1006. REPAIRED PER BOEING SRM.SDR P5CA9701657Floorbeam · corrodedLEVEL 1 CORROSION ON FLOORBEAM FRAME AT STATION 2340, LBL 14 TO LBL 40. REMOVED CORROSION AND TREATED PER BOEING SRM 51-10-01.SDR P5CA9701646Floor Beam · corrodedLEVEL 1 CORROSION ON FLOORBEAM AT STATION 2320, RBL 23. REMOVED CORROSION AND TREATED PER BOEING SRM 51-10-01.SDR P5CA9701637Floor Beam · corrodedLEVEL 1 CORROSION ON FLOORBEAM UPPER SURFACE AT STATION 228, LBL 50. REMOVED CORROSION AND TREATED PER BOEING SRM 51-10-01.SDR DL76S972039Floorbeam Web · crackedTHE FS 246 FLOORBEAM WEB WAS FOUND WITH A VERTICAL CRACK APPROX 3 LONG AT RBL 20. ADDITIONALLY, THE ATTACHING VERTICAL STIFFENER WAS FOUND CRACKED. REPAIRED PER ERA 330789-14.SDR CALA9701423Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CLIP NUT HOLES CORRODED AT STA 967L, WL 208. A NEW UPPER T-CAP WAS INSTALLED IAW ECRA 5310-03588.SDR 9724976615Floorbeam · crackedDURING ARMAR, FOUND CRACK IN UPPER DECK FLOORBEAM WEB FS 460, RBL 110, WL 300. REPAIRED PER EA 66-152673.SDR TWAA9807901Floorbeam · crackedMCI - DURING OP 16 MAINTENANCE CHECK, FOUND A CRACK AT FLOORBEAM TO LONGERON TIE AT STATION 996, LONGERON 18R. INSTALLED REPAIR AT STATION 996, LONGER 18R PER DC9 SRM 53-03. (M)SDR CKSA97549Floor Beam · corrodedDURING ROUTINE CPCP CHECK INSPECTION FOUND LEVEL 2 CORROSION: CORROSION ABOVE 2 NUT PLATES FS 1600 RBL 36 ON CARGO FLOORBEAM APPROX 3 FOOT INBD OF RT SIDE. REPAIRED IAW DC8 SRM 53-2-0 FIG. 1B SHEET 3. CORROSION TASK CARD NUMBER 5600-0551. NON-ROUTINE TASK SDR 97FDEA00714Floorbeam · corrodedCORROSION (C53-224-08) ON FLOORBEAM UNDER NUT PLATE BS 1150, LBL 58, WL 208. *S/D* FABRICATED AND INSTALLED REPAIR PARTS FOR FLOORBEAM AT BS 1130, LBL 60, WL 208 PER FED 5710-36882.SDR 97FDEA00712Floorbeam · corrodedCORROSION (C53-111-01, 2) UNDER NUT PLATES ON FLOORBEAM BS 600, RBL 25 TO LBL 25, WL 200 FWD CARGO BAY.SDR CALA9701415Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 312. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 51-10-51.SDR ASAA9780232Floorbeam · gougedBFM - DURING 30K CHECK, GOUGE WAS FOUND ON AFT LAVATORY FLOORBEAM AT FS 1338. REMOVED AND REPLACED TOP ANGLE OF FLOORBEAM AT FS 1338 IAW DC9 SRM 51-10-04 AND 51-30-02. (M)SDR UPS97824628Floorbeam · corrodedINSPECTION TYPE-B, FLOORBEAM CORRODED IN AFT ACCESSORY COMPT APPROX AT STA 1600 APPROX 12 FROM LT SIDEWALL. BLENDED CORROSION, AWAITING REPAIR INSTRUCTIONS FROM DAC 920. REMOVED DAMAGED AREA OF FLOORBEAM, FABRICATED AND DRILLED REPAIR DOUBLER PER EO DC8-5310SDR AWXA9700644Floorbeam · corrodedDURING SCHEDULED C-23 INSPECTION, FOUND CORROSION ON FLOORBEAM STA 987, LBL 16 AND 20, WL 208. REMOVED CORROSION AT BS 987, LBL 20 1.75 X 1.75 X .015 AND AT BS 987, LBL 16 2.0 X 1.25 X .024 PER SRM 53-10-01, PAGE 4. UPPER CHORD OF FLOORBEAM REPLACED DUE TO ASDR UPS97824776Floorbeam · crackedINSPECTION TYPE-C, F/S 1560 FLOORBEAM IS CRACKED AT RT ATTACH FITTING (FWD SIDE). REPAIRED IAW DHC SK 810-059.SDR SIMA972762Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE DISCOVERED THE RIGHT SIDE OF FLOORBEAM 40 CORRODED. MAINTENANCE REMOVED AND REPLACED RIGHT SIDE OF FLOORBEAM 40 IAW SRM 53-61-40. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR AALA971875Floor Beam · corrodedTUL - STA 380 FLOOR BEAM HAS CORROSION BETWEEN RT INBD TIE-DOWN TRACK AND RT CREASE ANGLE. REMOVED CORRODED PIECE OF FLOOR BEAM PER SRM 53-10-8. REPLACED WITH FLOOR BEAM REPAIR IAW SRM 53-10-8. TST: 55,509 HOURS. CYCLES, 33,962. (X)SDR UPS97825196Floorbeam · corrodedINSPECTION TYPE-C/CK, CORROSION ON UNDER SIDE OF FLOORBEAM FWD UPPER FLANGE AT STA 1720 BETWEEN L29L TO L29R. REMOVED FLOORBEAM AT FS 1720, FABBED NEW FLOORBEAM FROM 1706317 T EXTRUSION .090 7075 T6 IAW DC8 SRM 53-7-1. ALODINED AND PRIMED IAW DC8 SRM 51-1-8SDR TSAA9753251Floor Beam · corrosionDURING HEAVY MAINTENANCE VISIT, DISCOVERED CORROSION ON BS 328 FLOOR BEAM UPPER CHORD AT LBL 11.0. REPAIRED PER ECO 2850 CORROSION BLEND-OUT. AIRCRAFT RETURNED TO SERVICE. TAT: 27,890.42 HOURS. TAC: 27,480. (X)SDR UPS97824593Floorbeam · corrodedINSPECTION TYPE-C, FLOORBEAM AT FS 822 RBL 32 CORRODED OUT OF LIMITS UPPER FLANGE. REPAIRED IAW DHC SK 803-466.SDR AALA971893Floor Beam · corrodedTUL - FOURTH FLOOR SUPPORT, RIGHT OF CENTERLINE, CORROSION ON LOWER SURFACE. REPLACED FOURTH FLOOR SUPPORT BEAM, RIGHT OF CENTERLINE PER SRM 51-72-10-0. TST: 26,111 HOURS. CYCLES: 10,811. (X)SDR 9719762296Floor Beam · corrodedDURING M CHECK, FOUND CORROSION ON UPPER CHORD OF FLOORBEAM FS 344, LBL 24 - RBL 15. REPAIRED PER EA 22-152253.SDR 9718656628Floorbeam · corrodedDURING PERIODIC CHECK, FOUND CORROSION OF MAIN DECK FLOORBEAM UPPER CHORD FROM FS 1270 TO 1300 AT LBL 11.3. REPAIRED PER EA 66-152593.SDR EIAA97221Floor Beam · corrodedMZJ - DURING C-CHECK INSPECTION, DISCOVERED CORROSION ON THE LOWER T-CHORD OF THE FLOOR BEAM AT BS 642. REPAIRED BY FABRICATING AND INSTALLING A REPAIR T-CHORD, RESTORED AREA FINISH IAW EVERGREEN INTERNATIONAL AIRLINES ECRA 915-53-017-2. (X)SDR 97FDEA00689Floorbeam · corrodedREMOVED CORROSION CAP OF FLOORBEAM OUT OF LIMITS. REPLACED FLOORBEAM CAP PER SRM 27-53-007.SDR P5CA9701600Floorbeam · crackedCRACK ON UPPER CAP ON FLOORBEAM AT STA 1860, BL 58. FABRICATED AND INSTALLED UPPER CAP PER BAC SRM 51-30-00.
Back to JASC 5315