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 CKSA97420Floorbeam · puncturedDURING ROUTINE C1-12 CHECK INSPECTION, FOUND BS 720 LBL 47 HOLE IN WEB OF FLOORBEAM. INSTALLED DOUBLER REPAIR IAW B747 SRM 51-40-02. NON-ROUTINE TASK CARD NUMBER 108403.SDR CKSA97418Floorbeam · crackedDURING CPCP CHECK INSPECTION FOUND, TWO CRACKS IN FLOORBEAM WEB AT BS1372 LBL113. REPLACEMENT OF PART IAW B747 SRM 51-10-01 AND 53-11-22 FIG 32 SHT 4 51-30-2. CORROSION TASK CARD NUMBER C53-210-06 PART 1. NON-ROUTINE TASK CARD NUMBER 108535.SDR CKSA97417Floorbeam · crackedDURING CPCP CHECK INSPECTION FOUND, SEVERAL CRACKS IN FLOORBEAM WEB AT BS1384 LBL99 TO LT SIDEWALL FRAME. INSTALLED DOUBLER REPAIR IAW B747 SRM 51-40-02. CORROSION TASK CARD NUMBER C53-210-06 PART 1. NON-ROUTINE TASK CARD NUMBER 108534.SDR CKSA97416Floorbeam · crackedDURING CPCP CHECK INSPECTION, FOUND SEVERAL CRACKS IN FLOORBEAM WEB AT BS1384 RBL99 TO RT SIDEWALL FRAME. REMOVED AND REPLACED WEB IAW B747 SRM 51-10-01. CORROSION TASK CARD NUMBER C53-210-06 PART 1. NON-ROUTINE TASK CARD NUMBER 108533.SDR CKSA97413Floorbeam · puncturedDURING ROUTINE C1-12 CHECK INSPECTION, FOUND PUNCTURE HOLE IN MAIN DECK FLOORBEAM WEB AT BS420 LBL14. REPAIRED IAW B747 SRM 51-40-2. NON-ROUTINE TASK CARD NUMBER 108361.SDR AWXA9700408Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON FLOORBEAM BS 986.5, WL 208, LBL 43. REMOVED AND REPLACED TOP CHORD AT BS 986.5, WL 208, LBL 25 TO 55 PER SRM 53-00-51.SDR 97FDEA00424Floorbeam · corrodedNR 0399 024 CORROSION (C53-224-01(3)) ON BS 1030 BEAM FROM LBL 47 TO RBL 62, WL 208.1. CORROSION ON BS 1030 BEAM FROM LBL 47 TO RBL 62, WL 208.1 WAS BLENDED AWAY. DAMAGE AT BS 1030, RBL 47 - 60 FOUND TO BE OUT OF LIMITS PER FED-EX SRM 53-10-1. REPAIRED DAMASDR UPS97223725Floorbeam · corrodedINSPECTION TYPE:SI, CORROSION (C53-224-01.05-02) AROUND NUT PLATE HOLES ON BS 740 FLOORBEAM RBL 10 AND RBL 16 WL 208. CORROSION REWORK OUT OF LIMITS IAW SRM 53-10-1. REPAIRED BS 740 FLOORBEAM RBL 10 TO 16 WL 208 IAW TRAMCO/BFG EWO 97-2280 UPS FILE NR 727- 53SDR AWXA9700465Floor Beam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION AT ANCHOR NUTS ON FLOOR SUPPORT Y 1292, RT FRAME 66 BEYOND LIMITS. PERFORMED REPAIR PER ER 32-53-15-08.SDR AALA971232Floor Beam · corrodedTUL - FLOOR BEAM CORRODED AROUND FASTENER HOLES, BOTTOM SIDE OF TOP FLANGE, STA 1110, LBL 21 INCHES TO BL ZERO INCH. REMOVED CORROSION, STA 1110 LBL 21, AND REPAIRED FLOOR BEAM IAW SRM 53-10-8, FIG 1. TREATED AND PRIMED. (X)SDR USAA970241Floorbeam · corrosionCLT - DURING Q-5 CHECK VISUAL INSPECTION, FOUND CORROSION ON UPPER FLANGE OF 986 FLOORBEAM BL 0 TO RBBL 18. TASK CARD NR C53-107-02. INSTALLED REPAIR ANGLE PER REPAIR DOCUMENT SRM 53-10-05. (M)SDR CKSA97395Floorbeam · corrodedDURING ACCOMPLISHMENT OF AD 93-20-03 FOUND LEVEL 2 CORROSION: C-3 CORROSION ON TOP OF FLOORBEAM STA1665 LBL33. REMOVED AND REPLACED FLOORBEAM SECTION IAW L1011 SRM 51-10-1 PG 2 PARA D AND 51-40-1 AND 53-23-00 FIG 1 SHEET 15. NON-ROUTINE TASK CARD NUMBER 102SDR CKSA97372Floorbeam · corrodedDURING ACCOMPLISHMENT OF AD 93-20-03 FOUND LEVEL 2 CORROSION: AFT LAV F CENTER FLOORBEAM CAP CORRODED. REMOVED AND REPLACED CENTER FLOOR BEAM CAP IAW L1011 SRM 53-21-00, SRM 51-40-01. NON-ROUTINE TASK CARD NUMBER 101497.SDR CKSA97321Floorbeam · corrodedDURING CPCP CHECK INSPECTION FOUND LEVEL 2 CORROSION: AFT LAV NR G CORROSION ON BEAM CAP JUST FOWARD OF RIGHT HAND SIDE WALL. BEAM CAP FOUND TO BE OUT OF LIMITS, IAW L1011 SRM 53-21-00. REMOVED AND REPLACED IAW SRM 51-40-01. CORROSION TASK CARD NUMBER C-53SDR 9715276719Floorbeam · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON MAIN DECK FLOORBEAM FS 400, LBL 22 TO 53. REPAIRED PER EA 67-151060.SDR P5CA9701334Floor Beam · crackedAFT CARGO FLOOR SUPPORT CRACK AT BS 1860 LBL 5. REPAIRED FLOOR SUPPORT PER BOEING SRM 51-40-04.SDR P5CA9701332Floor Beam · crackedFORWARD CARGO FLOOR SUPPORT FOUND CRACKED AT BS 620 LBL 6. REPAIRED FLOORBEAM PER BOEING SRM 51-40-04 FIG. 2, AFTER TRIM OFF CRACKED AREA.SDR AWXA9700539Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON CABIN FLOOR SUPPORT Y 1292, RT FRAME 66 BEYOND LIMITS. PERFORMED REPAIR PER ER 32-53-15-08.SDR AWXA9700466Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON CABIN FLOOR SUPPORT Y 1292, LT FRAME 66 BEYOND LIMITS. PERFORMED REPAIR PER ER 32-53-15-08.SDR AALA971451Floor Beam · corrodedAFW - FLOOR BEAM HAD CORROSION BEYOND SRM LIMITS IN DEPTH, BUT WITHIN LIMITS PER CROSS-SECTION REMOVED. ALODINED AND REFINISHED AREA. APPROVED FOR CONTINUED SERVICE WITH NOTED CONDITION BY ENGINEERING PER MRB 767-1448. TST: 190,457.26 HOURS. CYCLES, 2,975SDR 97ZZZM930Floorbeam · corrodedDURING C-CHECK, FOUND AFT CARGO CABIN FLOORBEAM HAS CORROSION BULGE AT BS 967 BL0 TO RBL. REMOVED CORROSION LOSS MATERIAL MORE THAN 20 PERCENT. FABRICATED NEW FLOORBEAM LBL 6 INCH TO RBL 57. MATERIAL T-CHORD 7075 T-6 DIMENSIONS 11.75 BY 1.125 INCH BY 1 INCHSDR 97FDEA00419Floorbeam · corrodedNR 0744 014 CORROSION FLOORBEAM BS 970, RBL 55, WL 200. CLEANED AND TREATED CORROSION ON FLOORBEAM BS 970, RBL 55, RBL 62, WL 200 AS PER FED-EX SRM 51-10-6, 51-10-2 AND M/M 51-20-157. FOUND TO BE WITHIN LIMITS AS PER FED-EX SRM 53-10-1.SDR 97FDEA00414Floorbeam · corrodedNR 0517 013 CORROSION ON LWR CHORD OF FLOORBEAM AT NUTPLATE HOLES BS 1130, RBL 36 TO LBL 19, WL 200. REMOVED AND REPLACED LOWER CHORD OF FLOORBEAM BS 1130, RBL 36 TO LBL 19, WL 200 PER FED EA 7-5310-34975.SDR 97FDEA00409Floorbeam · corrodedCORROSION ON LOWER FLANGE OF FLOORBEAM BS 1010, RBL 28 TO 48, WL 200 BETWEEN STRAP AND UNDER NUTPLATES. *S/D* REMOVED LOWER FLANGE OF FLOORBEAM BS 1010, RBL 19 TO RBL 70.5 AND REPLACED WITH T-CHORD 7075T73511, FABRICATED 2 ANGLES FROM 15-5 PH CRESS STEEL .07SDR W8PA971362Floor Beam · corrodedCORROSION ON FLOOR BEAM AT STA 344, BL ZERO, WL 208. REPAIRED FLOOR BEAM PER SRM 53-10-51 (UPPER CHORD REPLACEMENT) AFTER UPPER CHORD FOUND TO BE CORRODED OUT OF LIMITS. (X)SDR W8PA971280Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM BS 1006, RBL 7 - RBL 11, WL 208. REMOVED CORROSION, FABRICATED REPAIR PARTS, ALODINED AND PRIMED, INSTALLED REPAIR PARTS. (M)SDR SIMA9701883Floor Beam · corrodedSAW - DURING MBVI/CPCPI INSPECTION CARD NR ZL-141-GVI-10020-001, MAINTENANCE DISCOVERED FLOOR BEAMS 36, 38, AND 40 WERE CORRODED OUT OF LIMITS IAW SRM 53-61-00. MAINTENANCE REMOVED AND REPLACED THE THREE FLOOR BEAMS IAW SRM 51-00-00. AIRCRAFT RETURNED TO SERSDR CALA9701094Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312 BETWEEN RBL 15 AND LBL 12. THE FLOORBEAM WAS REPLACED IAW SRM 53-10-51.SDR 97ZZZX3185Floor Beam · corrodedSAW - DURING MBVI/CPCPI INSPECTION CARD NR ZL-141-GVI-10020-001, MAINTENANCE DISCOVERED FLOOR BEAMS 36, 38, AND 40 WERE CORRODED OUT OF LIMITS IAW SRM 53-61-00. MAINTENANCE REMOVED AND REPLACED THE THREE FLOOR BEAMS IAW SRM 51-00-00. AIRCRAFT RETURNED TO SERSDR 97ZZZX3184Floor Beam · corrodedSAW - DURING MBVI/CPCPI INSPECTION CARD NR ZL-141-GVI-10020-001, MAINTENANCE DISCOVERED FLOOR BEAMS 36, 38, AND 40 WERE CORRODED OUT OF LIMITS IAW SRM 53-61-00. MAINTENANCE REMOVED AND REPLACED THE THREE FLOOR BEAMS IAW SRM 51-00-00. AIRCRAFT RETURNED TO SERSDR 97FDEA00450Floorbeam · crackedFLOORBEAM FRAMES 33, 34, 35 AND 36 CRACKED FORM MAIN DECK CARGO. REPAIRED PER SRM 53-10-15 FIG 206, SHEET 3 AND EA 6-5321-29128 DATED JULY 7, 1997,SDR 97FDEA00391Floorbeam · corrodedCORROSION ON BS 1110 FLOORBEAM FROM BL 0 AND RBL 62, WL 208.1. *S/D* CORROSION ON BS 1110 BEAM FROM BL 0 TO RBL 62, WL 208.1 WAS FOUND TO BE OUT OF LIMITS AT BS 1110, RBL 35 TO RBL 70 PER FED-EX SRM 53-10-1. REPAIRED DAMAGED SECTION OF FLOORBEAM PER FED-EX SDR 9717486642Floorbeam · corrodedDURING M-CHECK AND PRIOR TO SERVICE, FOUND CORROSION ON FLOORBEAM WEB AT FS 580, LBL 115, WL 189. REPAIRED PER EA 66-150706.SDR 9717476642Floorbeam · corrodedDURING M-CHECK AND PRIOR TO SERVICE, FOUND CORROSION ON FLOORBEAM CHORD AT FS 760, LBL 99 TO 120, WL 189 TO 199. REPAIRED PER EA 66-151330.SDR 97FDEA00390Floorbeam · corrodedCORROSION (C53-221-01) ON FLOORBEAM UNDER NUT PLATE, STA 277, RBL 16.5, WL 207.9. *S/D* REPAIRED DAMAGED FLOORBEAM BS 277, RBL 16.5, WL 207.9 IAW FED-EX SRM 51-40-4.SDR 9713335514Floorbeam · corrodedDURING TRANSITION CHECK, FOUND CORROSION ON UPPER SURFACE OF FLOORBEAM AT FS 324, RBL 48-60. REPAIRED PER EA 55-150832.SDR CALA9701108Floorbeam · corrodedINSPECTION FOUND TOP OF FLOORBEAM CORRODED FROM BS 303-344, LBL 30 TO RBL 30. THE CORROSION WAS REMOVED. A T-CAP WAS FABRICATED AND INSTALLED IAW SRM 53-10-8.SDR CALA9701107Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT STA 1070, RBL 40. THE CORRODED AREA WAS CUT OUT. FILLER AND DOUBLER WERE FABRICATED AND INSTALLED IAW SRM 53-10-8.SDR CALA9701098Floorbeam · corrodedINSPECTION FOUNDTOP OF FLOORBEAM CORRODED AT STA 380, RBL 24 TO RBL 45.5. THE FLOORBEAM UPPER CHORD WAS REMOVED AND A REPLACEMENT WAS FABRICATED AND INSTALLED IAW SRM 53-10-8.SDR ABXA9701227Floorbeam · corrodedDURING C-CHECK, FOUND EXFOLIATION AT FLANGE OF FLOORBEAM, STA 937 AND RBL 25, IN AFT LOWER CARGO COMPARTMENT. REPAIRED FLOORBEAM IAW DC9 SRM 53-05.SDR 9714222299Floorbeam · corrodedDURING M CHECK, FOUND CORROSION ON CABIN FLOOR BEAM LBL 12 TO 23, FS 1130. REPAIRED PER EA 22-150605.SDR SWIA97945Floorbeam · corrodedLBL 9.00 FLOORBEAM HAS CORROSION EXTENDING THROUGH BEAM BETWEEN FS 310.0 AND 333.0. REMOVED CORRODED AREA OF EDGE OF LBL 9.00 BETWEEN FS 310.0 AND FS 333.0 AND INSTALLED DOUBLER REPAIR IAW ON1R-53-21-092.SDR DL72S971280Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM STA 344 AND RBL 2. INSTALLED REPAIR PER SRM 53-10-8 FIG 11.SDR 97FDEA00404Floorbeam · corrodedHEAVY CORROSION BS 344 FLOORBEAM RBL 10. CUTOUT DAMAGED SECTION OF FLOORBEAM CHORD AND REPLACED WITH NEW CHORD USING BS 344 CHORD SPLICE PER FED-EX DRAWING NR SR 27-53-007.SDR 97FDEA00400Floorbeam · corrodedCORROSION AT NUT PLATE HOLE AT EDGE OF FLOORBEAM BS 400, RBL 35. REMOVED CORROSION PER SRM 53-10-01, INSTALLED DOUBLER REPAIR PER SRM 53-10-1.SDR 97FDEA00398Floorbeam · corrodedCORROSION ON FLOORBEAM UNDERSIDE AT MISSING NUT PLATE AREA BS 344, RBL 35 FWD SIDE OF BEAM. CUT OUT DAMAGED SECTION OF FLOORBEAM CHORD AND REPLACED WITH NEW CHORD USING BS 344 CHORD SPLICE PER FED-EX DRAWING NR SR 27-53-007.SDR UPS97824325Floorbeam · corrosionINSPECTION TYPE-D, FS 1460 LBL 24 ON NR 4 PIT CEILING, FLOORBEAM TANG HAS HEAVY CORROSION, METAL IS SEPARATING. REPAIRED IAW DHC SK 809-737 AND SRM 51-1-30.SDR UPS97824117Floorbeam · corrodedINSPECTION TYPE:D F/S 1160 AT LBL 44 ON NR 3 PIT CEILING, FLOORBEAM TANGS HAVE SEVERE CORROSION (METAL IS SEPARATING). REPAIRED IAW DHC SK 809-807.SDR UPS97823749Floorbeam · corrosionINSPECTION TYPE:D, FS 55 RBL 46 FWD SIDE OF FLOORBEAM HAS MODERATE CORROSION UNDER NUT PLATE CHANNEL. ALSO, WEB IS CRACKED. CUT OUT DAMAGED AREA AND INSTALLED REPAIR IAW SRM 53-2-0 FIG 1D.SDR ASAA9710063Floorbeam · corrodedSEA - DURING C-CHECK, THE FLOORBEAM AT BS 500A UPPER AFT FLANGE UPPER SURFACE WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01537 AND BOEING TELEX ASA-SEA-96-0260RR. (M)
Back to JASC 5315