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 SWAA012879Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 767 TO 787, RBL 3. REPAIRED FLOORBEAM PER SWA RA 1-A53-2021.SDR SWAA012878Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED FLOORBEAM PER SWA RA 1-357-1116.SDR SCNA01360Floorbeam · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON FLOORBEAM TEE CAP AT BS 380 LBL 20 TO RBL 64. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED SECTION IAW B727 SRM 513002. FABRICATED REPAIRS AND INSTALLED IAW B727 SRM 513002.SDR SCNA01359Floorbeam · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS BS 400 LBL 20 TO RBL 44 FLOORBEAM TEE CAP. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED AREA IAW B727 SRM 531008. REMOVED FLOOR SUPPORT AND INTERCOSTAL IAW B727 SRM 513002. FABSDR SCNA01358Floorbeam · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS AT BS 420 0 BL FLOORBEAM TEE CAP. REMOVED CORROSION IAW B277 SRM 511006. CUT OUT DAMAGED SECTION IAW B727 SRM 531008. FABRICATED REPAIRS IAW B727 SRM 531008. INSTALLED IAW B727 SRM 513002SDR SWAA012906Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 987, RBL 21 TO RBL 44, WL 208. REPAIRED FLOORBEAM PER BFG ER 01-0891.SDR SWAA012866Beam · crackedDURING SCHEDULED 1/2D CHECK AT DALFORT, FOUND FLOOR BEAM CRACKED AT BS 744A, RBL 43.5. REPAIRED FLOOR BEAM PER DLF XEA.SDR 0104246642Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON FLOORBEAM LOWER CHORD AT BS 1780 LBL 24. REPAIRED PER EA 66-186583.SDR SIMA200129017Floorbeam · corrodedABI - LEFT OMEGA BEAM AT FRAMES 19 THROUGH 23 WAS FOUND TO BE CORRODED. REPAIRED LEFT OMEGA BEAM AT FRAMES 19 THROUGH 23 IAW EMB 145 REPAIR GST-3414.01. (M)SDR SIMA200129013Floorbeam · corrodedABI - LEFT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 20. REPAIRED LEFT OMEGA BEAM IAW EMB145 SRM. (M)SDR 2001UALA02143Floorbeam · corrodedFORWARD PIT, FS 588, RBL 42, CARGO FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR ON FLOORBEAM.SDR 2001UALA02142Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 1197, RBL 15, AFT CARGO COMPARTMENT. MAJOR REPAIR ACCOMPLISHED. INSTALLED T-CAP AND DOUBLER REPAIR ON FLOORBEAM.SDR 2001UALA02141Floorbeam · crackedCABIN FLOORBEAM CRACKED AT STATION 303, LBL 57. MAJOR REPAIR ACCOMPLISHED. INSTALLED T-CAP AND DOUBLER ON FLOORBEAM.SDR 2001UALA02140Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 1188 TO 1197, RBL 38, AFT CARGO COMPARTMENT. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW T-CAP SECTION.SDR 2001UALA02139Floorbeam · corrodedFLOORBEAM AT BODY STATION 347, BL 48 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER ON FLOORBEAM.SDR SWAA012843Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LOWER CHORD BULGED AT 1016 BULKHEAD, BL 0. REMOVED AND REPLACED LOWER CHORD PER SRM.SDR SWAA012842Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 11.0. REPAIRED FLOORBEAM PER SRM.SDR PCAA0110127Floorbeam · crackedDURING A LEVEL INSPECTION NOSE GEAR DRAG STRUT ACTUATOR BRACKET FOUND CRACKED. THREE FASTENER HOLES FOUND TO HAVE SMALL CRACKS FORMING IN NOSE GEAR FLOORBEAM. CRACKED FLOORBEAM TEMRORARILY REPAIRED IAW DEHAVILLAND REPAIR DRAWING RD 8-53-6246. ACTUATOR BRACKESDR 2001UALA02158Floorbeam · crackedSTA 246 WEB CRACKED AT RBL 26.06 JUST OUTBOARD OF UPPER FASTENER COMMON TO MID-CHORD. MAJOR REPAIR: DAMAGE REMOVED AND DOUBLER INSTALLED. NOTED CRACKING OF THE 141W8518-17 WEB IS DUE TO THERMAL CONTRACTION THAT RESULTS IN HIGHER THAN EXPECTED IN-SERVICE LOADSDR CALA0100954Flange · corrodedAFT CARGO COMPARTMENT UNDER LAV FLOOR BEAMS AT STATION 986.5 NUT CLIPS CORRODED ON UPPER BEAM. REMOVED DAMAGED UPPER BEAM AND CLIPS. INSTALLED REPAIR DOUBLER PER SRM 51-40-2.SDR CALA0100953Flange · corrodedAFT CARGO COMPARTMENT UNDER RIGHT LAV FLOOR BEAM STATION 986.5 HAS CORROSION ON THE OUTBOARD. REMOVED CORRODED PREVIOUS REPAIR AND INSTALLED NEW UPPER FLANGE DOUBLER PER SRM 5310-03139 AND SRM 51-40-2.SDR CALA0100952Flange · corrodedAFT CARGO COMPARTMENT UNDER LEFT LAV FLOOR BEAM STATION STATION 986.5 CORRODED. REMOVED CORRODED REPAIR AND REINSTALLED NEW UPPER FLANGE DOUBLER PER SRM 5310-03139 ADN SRM 51-40-2.SDR 2001UALA02131Floorbeam · corrodedCABIN FLOORBEAM HAS EXCESSIVE CORROSION BETWEEN RBL 6 - RBL 56 STATION 365. MAJOR REPAIR ACCOMPLISHED. INSTALLED T-CAP SPLICE.SDR 2001UALA02126Floorbeam · corrodedCABIN FLOOR BEAM CORRODED BETWEEN RBL6 TO RBL 56. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED.REPLACED T-CAP.SDR USAA011345Floorbeam · corrodedCLT - FOUND BEAM CORRODED 1 INCH BY 1 INCH, STATION 345 RBL 14. CUTOUT DAMAGE AND INSTALLED DOUBLER PER SRM 53-15-01 TYPICAL REPAIR. (M)SDR DL75A011670Floorbeam · corrodedTHE UPPER CAP OF THE FS 1681 PASSENGER FLOORBEAM WAS FOUND CORRODED IN SEVERAL AREAS. THE ENTIRE CAP WAS CUT OFF TO REMOVE ALL CORROSION. A NEW CAP WAS FABRICATED AND INSTALLED IN PLACE OF THE REMOVED CAP PER ER/A 381633-14, REV A.SDR CALA0100947Floorbeam · corrodedFLOORBEAM BS 360, RBL 0-60, CORROSION UNDER G-2 GALLEY. REPAIRED FLOORBEAM IN REF TO SRM 53-00-51.SDR 2001UALA02114Floorbeam · corrodedCORROSION ON UPPER FORWARD FLANGE OF BODY STATION 986 FLOORBEAM AT RBL 41. MAJOR REPAIR ACCOMPLISHED. REMOVED CORROSION. INSTALLED REINFORCEMENT REPAIR.SDR MWEA011382Floorbeam · damagedCAP ON FLOORBEAM AT STATION 1338 FROM LEFT LAV TO RIGHT LAV REQUIRES REPLACEMENT. FABRICATED AND INSTALLED NEW FLOORBEAM CAP AND INSTALLED LEFT HAND AND RIGHT HAND LAV FLOOR SUPPORTS.SDR SIMA200128305Floorbeam · corrodedABI - FOUND GALLEY AFT DIGITAL CORRODED. REPAIRED GALLEY DIGITAL IAW EMB 145 REPAIR STATEMENT GST 3309/01. (M)SDR SWAA012790Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAMS CORRODED AT BS 770, LBL 3 TO LBL 12, BS 793, RBL 3 TO LBL 8 & BS 857, LBL 17. REPAIRED FLOORBEAMS PER SRM & SWA RA 1-A53-2021.SDR 01FDEA00876Floorbeam · corrodedAFT CARGO COMPARTMENT BS 1871, RBL 12 CORRODED. R&R FLOORBEAM PER 53-60-00.SDR 01FDEA00875Floorbeam · corrodedAFT CARGO COMPARTMENT FLOORBEAM CORRODED BS 1841, LBL 50 - RBL 50. R&R FLOORBEAM.SDR SIMA200128103Floorbeam · corrodedABI - THIS IS LEVEL 2 FINDING ON A CORROSION REPAIR ITEM CARD NR 27521. CORROSION HAS BEEN FOUND ON GALLEY FORWARD DIGITAL. REPAIRED FORWARD DIGITAL IAW EMB GST-3309/01. (M)SDR 0103569607Floorbeam · corrodedDURING M-CK IN ATL, CORROSION HAS BEEN FOUND ON STA 160 CABIN FLOOR BEAM CAP AFT FACING FLANGE WHERE THE OUTBOARD GALLEY MOUNT IS ATTACHED. IT WAS ELECTED TO TO TRIM THE AFT FACING FLANGE TO REMOVE THE DAMAGE. THE RADIUS OF THE CAP WAS NOT TRIMMED. 7075-T6511SDR 2001UALA02097Floorbeam · corrodedAFT CABIN FLOORBEAM WEB CORRODED STA 1685, RBL 51. MAJOR REPAIR ACCOMPLISHED. INSTALLED UPPER SURFACE DOUBLER STA 1685, RBL 47.5 TO RBL 54.SDR 2001UALA02096Floorbeam · corrodedCABIN FLOORBEAM AT STA 297, RBL 34 CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED UPPER SURFACE STRAP REPAIR STA 297, RBL 41 TO RBL 47.5.SDR C2XA01TY132Beam · corrodedTYS Durind a scheduled inspection corrosion was found under and around the forward carbon fiber omega beam. Maintenance removed and replaced the top cap, ramp angle, L-profile angle, cross fiber beam and installed shim, filler, plate and external angle. I.A.WSDR C2XAA01TY132Beam · corrodedTYS Durind a scheduled inspection corrosion was found under and around the forward carbon fiber omega beam. Maintenance removed and replaced the top cap, ramp angle, L-profile angle, cross fiber beam and installed shim, filler, plate and external angle. I.A.WSDR 0103716642Attach Fitting · corrodedDuring "PCK" found corrosion/pitting on number 4 strut to aft diagonal brace attach fitting. Repaired per EA 66-186714.SDR AALA20011905Floorbeam · corrodedTUL - FOUND CORROSION ON TOP OF FLOORBEAM STATION 400 OUTBOARD OF OUTBOARD SEAT TRACK AND AT SCREW HOLE. REMOVED CORROSION TREATED AND PRIMED WITHIN LIMITS PER ECO 11697. (M)SDR SWAA012777Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 1006, LBL 9 & WL 208. REPAIRED FLOORBEAM PER SRM.SDR SIMA200127803Floorbeam · corrodedABI - DURING MBV INSPECTION, FOUND CORROSION ON THE LEFT OMEGA FLOOR BEAM AT FRAME 20. REPAIRED LEFT OMEGA FLOORBEAM IAW EMB 145 SRM. (M)SDR AWXA200100524Floorbeam · corrodedMCN - C18 CK - C - CORROSION FOUND ON FLOORBEAM UPPER HORIZONTAL FLANGE AT BS 1016, LBL 6, WL 208.1, BEYOND SRM LIMITS AFTER CORROSION CLEAN UP. MAINTENANCE REPAIRED THE FLOORBEAM UPPER HORIZONTAL FLANGE IAW SRM 53-00-51 FIG 203 PG 212 - 214.SDR AWXA200100154Floorbeam · corrodedMCN - C18 CK-C, CORROSION FOUND ON FLOORBEAM UPPER HORIZONTAL FLANGE AT BS 1016, LBL 6, WL 208.1, BEYOND SRM LIMITS AFTER CORROSION CLEAN UP. MAINTENANCE REPAIRED THE FLOORBEAM UPPER HORIZONTAL FLANGE IAW SRM 53-00-51 FIG 203 PG 212 - 214.SDR 0104256642Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON UPPER DECK FLOORBEAM UPPER CHORD AT BS 500 LBL 46. REPAIRED PER EA 66-186643.SDR DHL2001742526Floorbeam · crackedDURING C-CHECK, CABIN FLOORBEAM HAS CRACKED WEB BS 825.95 LEFT O/B LBL 60, CRACK STARTS FROM ABOVE GUSSET FASTENER HOLE. REMOVED WEB AT BS 825.95 LBL 60 AS PER B-727 SRM 51-30-2. FABRICATE NEW WEB AS PER B-727 SRM 53-10-2 FIGURE 7. INSTALLED WEB AS PER B-727 SDR AWXA200100530Floorbeam · corrodedMCN - C18 CK -C- CORROSION FOUND ON FLOORBEAM UPPER FLANGE AT BS 967, RBL 15 TO RBL 19, BEYOND SRM LIMITS. MAINTENANCE REMOVED DAMAGED SECTION, FABRICATED REPAIR PARTS AND INSTALLED IAW B737 SRM 53-00-51, FIG 202, PG 207 - 211.SDR 2001UALA02100Floorbeam · corrodedBS 520 FLOORBEAM UPPER CHORD EXCESSIVELY CORRODED. BLENDED BEYOND LIMITS.SDR SWAA012730Web · corrodedDURING SCHEDULED 1/2D CHECK AT DALFORT, FOUND WEB CORRODED AFT OF BS 1016 FLOOR BEAM, RBL 32 TO RBL 36. REPAIRED WEB PER SRM.
Back to JASC 5315