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 UPS97822552Floorbeam · corrodedINSPECTION TYPE C/CK, CABIN FLOORBEAM BOTTOM SIDE OF UPPER CHORD AT SEAT TRACK CRACKED AT FASTENERS. REMOVED FASTENERS, REMOVED CORROSION IAW DC8 SRM 51-1-8. PERFORMED DYE PEN TEST ON FLOORBEAM, FOUND NO CRACKS. ALODINED AND PRIMED IAW DC8 SRM 51 1 8. INSSDR UPS97822469Floorbeam · corrodedINSPECTION TYPE-C/CK, CABIN FLOORBEAM STA 700 BOTTOM SIDE OF UPPER CHORD AT SEAT TRACK-G CRACK AT FASTENERS. REMOVED FASTENERS, REMOVED CORROSION IAW DC8 SRM 51-1-8. PERFORMED DYE PEN TEST ON FLOORBEAM, FOUND NO CRACKS. ALODINED AND PRIMED AREA IAW DC8 SRMSDR UPS97822468Floorbeam · corrodedINSPECTION TYPE-C/CK, CABIN FLOORBEAM FS 900 AT SEAT TRACK B-UPPER CHORD CRACKED AND CORRODED AT FASTENERS LOWER SIDE. REMOVED BOLT FROM SEAT TRACK, REMOVED CORROSION AND ALODINED AND PRIMED IAW SRM 51-1-8 AND DREO 08-02908 AND INSTALLED BOLT IAW DC8 SRM D51-3SDR UPS97822454Floorbeam · corrodedINSPECTION TYPE-C/CK, CABIN FLOORBEAM FS 900 AT SEAT TRACK C, UPPER CHORD CRACKED AND CORRODED AT FASTENERS LOWER SIDE. REMOVED CORROSION DYE PEN AREA WITH NO CRACK NOTED IAW DC8 SRM D51-1- 8 AND MIL S 271F, ALODINED AND PRIMED IAW DC8 SRM 51-1-8D AND REO O 0SDR TWAA9808817Support · corrodedMCI - DURING OP 16 MAINTENANCE CHECK, CABIN FLOOR SUPPORT HAD CORROSION AT FS 200, RBL 10 TO 48. REPLACED WITH NEW SUPPORT PER SRM 51-01. (M)SDR C2XA97IA090Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT FLOORBEAM AT FRAME 38 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED PORTION OF THE FLOORBEAM AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR DL73E970508Floor Beam · corrodedFLOOR BEAM AT STA 344 CORRODED MANY PLACES SPAN - BEAM . TASK NR C53-107-02.SDR UPS97822466Floorbeam · corrodedINSPECTION TYPE-C/CK, FS 857 FLOORBEAM HAS FITTING CORROSION IN AREAS WHERE FLOORBOARDS CONTACT BEAM. BLENDED CORROSION IAW DC8 SRM D51-1-8. REMOVED PULLEY BRACKET, FABRICATED ANGLE AND FILLER IAW REO 02906, ALODINED AND PRIMED REPAIR ANGLE FILLER AND FLOORBSDR UPS97222392Floorbeam · corrodedINSPECTION TYPE-C, CORROSION ON UNDERSIDE OF FLOORBEAM STN 930 RBL 55.5. HFEC CARRIED OUT IAW NDT PT6 51-00-00 FIG 4, NO DEFECTS INDICATED. REPAIR CARRIED OUT PER UPS MINOR REPAIR AUTHORIZATION FILE NR 727-53- 1870.SDR DHL9771277DFloorbeam · corrodedAT D-CHECK, FOUND CORROSION ON FLOORBEAM AT BS 950 RBL45 TO 64. REMOVED FASTENERS AND CUTOUT DAMAGED SECTION OF FLOOR T-CAP. INSTALLED FILLER AND EXTRUDED SECTION REPAIR PER SRM 51-40-4, REPAIR FILLER RADIUS STRAP AND ANGLE WAS 16.75 X 1.75 IN SIZE.SDR DHL9771276DFloorbeam · corrodedAT D-CHECK, CORROSION ON FLOORBEAM BS 950 LBL 45 TO 64. CUT OUT DAMAGED SECTION AND INSTALLED FILLER AND EXTRUDED SECTION REPAIR AS PER SRM 51-40-4. INSTALLED REPAIR STRAP AND ANGLES 16.75 X 2.5.SDR CALA9700316Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED IN THREE PLACES AT STA 312. THE CORRODED AREAS OF FLOORBEAM WERE CUT OUT, REPAIR DOUBLERS WERE FABRICATED AND INSTALLED IAW SRM 51-20-01 AND 53-10-51. A 23 SECTION OF UPPER T-CHORD WAS REPLACED.SDR C2XA97IA073Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE FLOOR SUPPORT BEAM AT FRAME 38 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR C2XA97IA071Floor Beam · corrodedIAH - DURING C-CHECK INSPECTION, THE FLOOR SUPPORT BEAM AT FRAME 36 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE SUPPORT BEAM AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR 97ZZZX3118Floor Beam · crackedMAIN LANDING GEAR FLOOR BEAMS 3, 5, 9, 15, AND 19, CRACKED AT FRAME 29, IN CABIN. REPAIRED FLOOR BEAMS IAW BAE RIL HC536H9211 AS LISTED ABOVE AT FR 29, BEAMS 3, 5, 9, 15, AND 19 AND FAX DJR/RJ0207-97.SDR 97FDEA00133Floorbeam · corrodedNR 0126 003 CORROSION (C53-224-03) ON FLOORBEAM LOWER CHORD AT BS 328, LBL 3, WL 200. REMOVED DAMAGE ON FLOORBEAM LOWER CHORD 1 INCH BY 1.5 INCH AT BS 328, LBL 3, WL 200. REPAIRED PER FED-EX SRM 53-10-8 FIG 7.SDR TWAA9747006Floor Beam · wornSTL - DURING OP-15, FOUND FLOOR BEAM UNDER FLOOR PANEL AT STA 313 SHOWING WEAR IN THREE PLACES. REPAIRED PER SSRM 53-00-101, AND SRM 53-05, FIGURE 20A. AIRCRAFT TOTAL TIME: 44,216 HOURS; 39,369 CYCLES. (X)SDR W8PA970102Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION ON UPPER CHORD OF FLOORBEAM AT BS 312, RBL 34.5, WL 208. BLENDED CORROSION. FOUND PART OUT OF LIMITS, FABRICATED AND INSTALLED REPAIR PARTS. (M)SDR W8PA970099Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION ON UPPER CHORD OF FLOORBEAM AT BS 294, LBL 20, WL 208. REMOVED CORROSION, REPAIRED UPPER CHORD OF FLOORBEAM AT BS 294, LBL 20, WL 208. (M)SDR W8PA970094Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION ON UPPER CHORD OF FLOORBEAM AT BS 947, RBL 6, WL 208. BLENDED OUT CORROSION, FOUND TO BE OUT OF LIMITS PER SRM 53-10-51. FABRICATED INSTALLED PARTS PER SRM 53-30-51. (M)SDR W8PA970092Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION BS 1006, LBL 36-RBL 36, WL 208, AROUND FLOOR BOARD ATTACH HOLES. REMOVED OUT OF LIMITS AREA AT BS 1006, LBL 29, WL 208. REPAIRED IAW SRM 51-70-11. (M)SDR W8PA970088Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION BS 967, FOUND ON UPPER CHORD OF THE FLOORBEAM AT BS 344, RBL 8.5, WL 208. CORROSION FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR PARTS. (M)SDR W8PA970084Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION ON UPPER CHORD OF FLOORBEAM AT BS 328, LBL 28.5, WL 208. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS, REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PARTS. (M)SDR W8PA970081Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION FOUND ON UPPER CHORD OF FLOORBEAM AT BS 294, LBL 20 WL 208. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED REPAIR PARTS. (M)SDR RRXA97097Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND MISDRILLED HOLE IN FLOOR SUPPORT, AT Y=560 AND X=-46. AWAITING ON ZANTOP AND COTNEY ENGINEERING TO DETERMINE REPAIR PROCEDURE. *S/D* REPAIRED FLOORBEAM BY FABRICATING AND INSTALLING 3 REINFORCEMENT ANGLES IAW DER APPROVED CSDR MWEA97167Floorbeam · corrodedDURING D/E CHECK, AFT CARGO BIN DOOR JAMB BEAM CORRODED. MAINT INSTALLED NEW BEAM IAW SRM 53-14-3.SDR UPS97222146Floorbeam · corrodedINSPECTION TYPE-C, CORROSION ON FLOORBEAM TOP CHORD FORWARD SIDE STA 328, WL 208 RBL 39. CORROSION REMOVAL OUT OF LIMITS. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, INSTALLED PER SRM 53-10-1, 53-10-8, 51-20-4 MM 51-20-131.SDR USAA970074Floorbeam · crackedINT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND FOUR .25 INCH CRACKS AT FASTENERS IN WEB SKIN OF LONGT FLOORBEAM BS 707, BL '0', WL 203. INSTALLED WEB REPAIR, REPAIRED PER BOEING DRAWING NR 65C34537. (M)SDR 97FDEA00121Floorbeam · corrodedNR 0256 001, CORROSION ON LOWER FLANGE OF FLOORBEAM BS 1070, RBL 12, WL 200. *S/D* REPAIRED LOWER FLANGE OF FLOORBEAM BS 1070, RBL 12, WL 200 PER FED EX SRM 53-10-8.SDR CALA9700334Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT B.S. 328 BETWEEN RBL 12 AND RT SIDE AND BETWEEN RBL 12 AND LT SIDE. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-10-51, FIGURE 205.SDR CALA9700333Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT B.S. 294 BETWEEN LBL 12 AND RBL 12. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR CALA9700332Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT B.S. 344 BETWEEN LBL 12 AND LT SIDEWALL. THE CORRODED AREA WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR CALA9700331Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT B.S. 312 BETWEEN LBL 12 AND RT SIDEWALL. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR 9704149943Floorbeam · crackedDURING H-CHECK, FOUND CRACK IN FORWARD CARGO COMPARTMENT FLOORBEAM AT FS 531. REPAIRED PER EA 99-112239.SDR SWAA970238Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD CRACKED AT BS 1138 PLUS 4, WL 294. REPAIRED PER BOEING SRM.SDR SWAA970237Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 53, WL 208. REPAIRED PER BOEING SRM.SDR SWAA970233Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 360, RBL 1 TO 20, WL 208. REPAIRED PER BOEING SRM.SDR SWAA970232Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 344, LBL 56 TO RBL 1, WL 208. REPAIRED PER BOEING SRM.SDR CALA9700283Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED BETWEEN TIE DOWN TRACKS AND OUTBOARD TO END AT BS 348.2, LT SIDE. THE CORRODED AREA WAS REMOVED, A REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-10-8.SDR 97FDEA00135Floorbeam · corrodedNR 0419 009 CORROSION (C53-224-01(1) ON FLOORBEAM AT BS 344, LBL 10 TO RBL 25, WL 208. REPAIRED BS 344 FLOORBEAM PER FED-EX SR DWG 27-53-007.SDR UPS97822073Floorbeam · corrodedINSPECTION TYPE-C, FLOORBEAM UPPER CAP CORRODED FS 640 RBL 34. CUT OUT DAMAGED AREA, FABRICATED REPAIR ANGLE AND INSTALLED PER DHC SRM 51-1-20, AND DHC SK-806-215A REF ENRG FILE NR DC8-53-1739.SDR SWAA970216Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CHORD CORRODED AT BS 312, AT LBL 39.26 AND RBL 7.5. REPAIRED PER BOEING SRM.SDR DHL9771297DFloorbeam · corrodedDURING D-CHECK, CORROSION WAS FOUND ON A CABIN FLOORBEAM AT BS 620 BLL 48 TO BLL 60. CUT OUT DAMAGED SECTION OF FLOORBEAM AT BS 620 LBL 28 TO LBL 60 PER BOEING SRM 53-10-8 FIG 3 AND INSTALLED FLOORBEAM REPAIR PER SAME REFERENCE.SDR RRXA97046Floorbeam · crackedDURING C-CHECK, FOUND 3 INCH CRACK ON FLOORBEAM UPPER FLANGE AT, Y=1600 AND X-45. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW TIMCO REO-02713 DTD 2/4/97 AND FAA-DER APPROVED CFG-01239 AND 8110-3 FORM (DER NR SO-135).SDR RRXA97045Floorbeam · crackedDURING C-CHECK, FOUND 5 INCH CRACK IN FLOORBEAM UPPER FLANGE AT, Y=1580 AND X PLUS 45. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW TIMCO REO-02712 DTD 2/4/97 AND FAA-DER APPROVED CFG-01239 AND 8110-3 FORM (DER NR SO-135).SDR DHL9771208DFloorbeam · corrodedAT D-CHECK, CORROSION OF FLOORBEAM UPPER SURFACE BS 1030 LBL 45-64. CUT OUT UPPER FLANGE AT STA 1030, INSTALLED FLOORBEAM UPPER CHORD REPAIR PER SRM 53-10-8. REPAIR 19.SDR AALA980352Floorbeam · corrodedTUL - CORROSION ON FLOORBEAM STA 1130 RBL 35. INSTALLED REPAIR STRAP ON TOP OF 1130 FLOORBEAM PER ESO 11697 DATED 2-4-98 AND AARD 53-10-07. TST: 51,688 HOURS. CYCLES: 31372. (X)SDR CALA9700262Floorbeam · corrodedINSPECTION FOUND CORROSION ON FLOOR BEAM UPPER CAP AT F.S. 860, RBL 72 BETWEEN 242EF AND 242FF. THE FLOOR BEAM WAS REMOVED AND REPLACED IAW 51-21-01.SDR DHL9771230DFloorbeam · corrodedAT D-CHECK, CORROSION CABIN FLOORBEAM STA 1110 RBL 48 TO RBL 60. CUT DAMAGED SECTION OF FLOORBEAM BS 110 FROM RBL 36 TO O/B END PER SRM 53-10-8, INSTALLED REPAIR PER SRM 53-10-8.SDR DHL9771227DFloorbeam · corrodedAT D-CHECK, CORROSION ON FLOORBEAM BS 111, RBL 32. CUT OUT DAMAGED SECTION ON UPPER SURFACE OF FLOORBEAM FROM RBL 36 TO O/B END, INSTALLED REPAIR PER SRM 53-10-8.
Back to JASC 5315