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 2001UALA00337Floorbeam · damagedCABIN FLOORBEAM STA 947 HAS EXCESSIVE MATERIAL REMOVED. REPAIRED CABIN FLOORBEAM. MAJOR REPAIR ACCOMPLISHED.SDR MWEA010427Floorbeam · corrodedMODERATE CORROSION ON TOPSIDE OF FLOORBEAM, STATION 802, THIRTY FIVE INCHES LEFT OF CENTER. REMOVED OLD FILLER, FABRICATED NEW FILLER, FABRICATED STAINLESS STEEL SHIM, INSTALLED FILLERS.SDR MWEA010446Floorbeam · corrodedCORROSION, GOUGES AND ELONGATED HOLES ON RIGHT LAV FLOORBEAM AT STATION 980. REMOVED DAMAGED SECTIONS OF BEAM TOP SURFACE, BLENDED GOUGES, REMOVED CORROSION, FABRICATED FILLER AND WEAR PLATE, DRILLED ANGLE AND FILLER, INSTALLED ANGLE AND FILLERS.SDR USAA010335Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY .102 INCHES, STATION 987 BETWEEN RBL 54 AND LBL 48. INSTALLED REPAIR TO T-CAP, SRM 53-00-01 AND TR 53-60-01. CORROSION LEVEL 1, C53-107-02. (M)SDR 2001UALA00315Floorbeam · damagedFORWARD CABIN FLOORBEAM UPPER CHORD STA 294.5 HAS EXCESSIVE MATERIAL LOSS. SPLICED IN NEW SECTION OF UPPER T-CHORD. MAJOR REPAIR ACCOMPLISHED.SDR TWAA0105513Floorbeam · corrodedDURING CHECK-C MAINT AT STA 1155, LBL 24 TO 42, THE FLOOR CAP HAD HEAVY CORROSION TOP SIDE. FLOORBEAM CAP GROUND BEYOND LIMITS. REPLACED SUPPORT CAP PER SPM 6-70-1.SDR AWXA0001536Floorbeam · crackedFLOORBEAM AT FS 520 RBL 24.75 HAS A CRACK IN THE RADIUS OF UPPER CHORD EXTENDING PAST STOP DRILL. REMOVED EXISTING DOUBLERS; VERIFIED CRACK LENGTH; STOP DRILLED CRACK; VERIFIED CRACK TERMINATION AT STOP DRILL. REINSTALLED DOUBLERS IAW SRM 51-30-2 PG 1.SDR ASAA0140042Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOORBEAM NUT PLATE HOLES AT BS 986.5 LBL 2 TO 43 AND WL 208, LEVEL 2. REPAIR PENDING. (M)SDR ASAA0140041Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOORBEAM AT BS 947, RT BL 4 AND WL 208, LEVEL II. REPAIRED PER SRM 53-00-51. (M)SDR 2001UALA00316Floorbeam · corrodedCABIN STA 1016 LBL 17 TO LBL 37 HAS CORROSION ON FLOOR BEAM. MANUFACTURED AND INSTALLED REPAIR PARTS. MAJOR REPAIR ACCOMPLISHED.SDR SWAA010891Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 660 CENTER WING BOX LONGITUDINAL FLOORBEAM TEE CHORD CRACKED AT BL 0. REPAIRED FLOORBEAM TEE CHORD PER SWA RA.SDR 2001UALA00344Floorbeam · corrodedFORWARD PIT BS 368 RBL 35 FLOORBEAM T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED INSTALLED T-CAP REPAIR REF: SRM 53-30-07 FIGURE 201.SDR ASAA0110149Floorbeam · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 500B, BL 0 - LBL 55 CORRODED. REPAIRED PER EA. (M)SDR RRXA10718Floorbeam · crackedDURING A MAINTENANCE VISIT FOUND CRACK DAMAGE TO MAIN CARGO COMP FLOOR BEAM AT STA 200 LT OF L22, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM.SDR 2001UALA00342Floorbeam · corrodedCABIN TRANSVERSE FLOORBEAM CORRODED BS 824 LBL 11. MAJOR REPAIR ACCOMPLISHED INSTALLED FLOORBEAM REPAIR REF: SRM 53-00-51.SDR 2001UALA00298Floorbeam · corrodedAFT CABIN STA 1661 RBL 0 TOP CAP OF FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR SPLICE PER AMM.SDR ASAA0110144Floorbeam · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 420, BL 0 TO LBL 55 CORRODED. REPAIRED PER EA. (M)SDR DHL2001747507Floorbeam · crackedD-CHECK, FWD CARGO PIT ST 580 S 27L, FLOORBEAM CRACKED. REMOVED CRACKED AND DAMAGED PORTION OF Z-ANGLE IAW 51-10-04 FIG 4 PER SRM. ALODINED PER SRM 51-10-2. PRIMED PER SRM SOPM 20-41-02. INSTALLED PARTS PER SRM 53-10-5 FIG 4 SHEET 2 AND FASTENERS IAW SRM 51SDR EIA2001123Floorbeam · misdrilledMZJ-EAC - FOUND FS 460 RBL 19 DOUBLE DRILLED HOLE IN FLOORBEAM AFT FLANGE. REMOVED DAMAGED SECTION OF FLOORBEAM UPPER CHORD FROM BL 0 TO RBL 45, FABRICATED NEW UPPER CHORD SECTION 1 AND 2 SPLICE ANGLES, 3 STRAPS, 6 AND 7 FILLERS, AND INSTALLED PER SRM 53-10-0SDR EIA2001121Floorbeam · misdrilledMZJ-EAC - FOUND FS 474 RIGHT OUTBOARD FLOORBEAM NUTPLATE HOLE DOUBLE DRILLED AT RBL 90. REPAIRED BEAM PER B747 SRM 51-20-01 AND ECRA 3203-53-33-2. (M)SDR 2001UALA00292Floorbeam · corrodedSTA 1016 RBL 4 AND LBL 4 HAS EXCESSIVE MATERIAL REMOVED FROM CORROSION REMOVAL. PERFORMED STA 1016 FLOORBEAM SPLICE REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR SWAA010855Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 663 CENTER WING BOX LONGITUDINAL FLOORBEAM TEE CHORD CRACKED AT BL 0.7. REPAIRED FLOORBEAM TEE CHORD PER SWA RA.SDR SWAA010853Floorbeam · corrodedDURING SCHEDULED D-CHECK AT DALFORT, FOUND FLOORBEAM CORRODED AT BS 980, FROM RBL 22 TO OUTBOARD END. REPAIRED FLOORBEAM PER SRM.SDR AWXA0001527Floorbeam · corrodedSURFACE CORROSION ON TOP OF CABIN FLOORBEAM AT BS 986.5. FLOORBEAM REPAIRED IAW SRM 53-10-9 FIG 2.SDR AWXA0001516Floorbeam · crackedFLOORBEAM LOWER ANGLE HAS ELONGATED/CRACKED FASTENER HOLES BS 178 RBL 24 WL 195. REMOVED FASTENERS; CUT OUT DAMAGE ON FLOORBEAM LOWER ANGLES; FORMED, CUT DRILLED AND INSTALLED REPAIR ANGLES AND FILLERS IAW B737-300 SRM 51-70-12 PG 1SDR AWXA0001513Floorbeam · corrodedCABIN FLOORBEAM UPPER CHORD UPPER SURFACE CORRODED AT BS 312 RBL 13 WL 208. REMOVED UPPER CHORD SECTION OF FLOORBEAM AT BS 312 BL 18L - 24R WL 208; LOCATED, DRILLED, TREATED, PRIMED AND INSTALLED NEW SECTION IAW B737-300 SRM 53-10-51 FIG 205.SDR USAA010316Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 10 INCHES, STATION 967 FROM LBL 32 TO RBL 32. CORROSION LEVEL 1 C53-107-02. INSTALLED REPAIR DOUBLER PER SRM 53-00-51 FIG 202. (M)SDR USAA010315Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED 4 INCHES, BS 340 FROM LBL 10 TO RBL 10. CORROSION LEVEL 1C53-107-02. SPLICED IN NEW T-CAP PER SRM 53-10-51. (M)SDR USAA010314Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED 3 INCHES, BS 312 FROM LBL 33 TO RBL 10. SPLICED IN NEW T-CAP SECTION PER SRM 53-10-51. (M)SDR USAA010312Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES, STATION 312, BL 0, RBL 12, LBL 7, 32, 39. REPLACED T-CAP PER SRM 53-10-51. (M)SDR 2001UALA00284Floorbeam · tool damageCABIN FLOORBEAM UPPER CAP AT STA 740 BETWEEN LT AND RT SEAT TRACK HAS TOOLING DAMAGE. MAJOR REPAIR ACCOMPLISHED. REPAIRED T CAP WITH SPLICE PER SRM.SDR C2XA01IA176Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED FROM FRAME 59 TO FRAME 61. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IN ACCORDANCE WITH EMB 145 SRM 51-40-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA01IA175Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE RIGHT HAND OUTBOARD FLOORBEAM WAS FOUND TO BE CORRODED FROM FRAME 18 TO FRAME 20. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IN ACCORDANCE WITH EMB145 SRM51-40-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SSDR C2XA01TY054Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION SEVERAL AREAS OF CORROSION WAS FOUND ON THE RIGHT HAND OMEGA BEAM BETWEEN FRAMES 19 AND 22. MAINTENANCE REPAIRED THE RIGHT HAND OMEGA BEAM IAW EMB GST-0823/01, REPAIR WAS SATISFCATORY. THE AIRCRAFT WILL BE RELEASED UPON COMSDR C2XA01TY051Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE LEFT OMEGA BEAM WAS FOUND TO HAVE CORROSION UNDER THE CARBON FIBER SUPPORT RAIL AT FRAME 20. MAINTENANCE REPAIRED THE OMEGA BEAM IAW EMB-145 SRM-53-21-10, EMB-145 SRM-51-40-02 AND EMB-145 CPM-51-21-03,04. THE REPAIR WASSDR 2001UALA00277Floorbeam · damagedCABIN FLOORBEAM WEB STA 324 RBL 44 HAS OVERSIZED HOLE. MAJOR REPAIR ACCOMPLISHED. INSTALLED FREEZE PLUB AND T-CAP REPAIR PER SRM.SDR SWAA010788Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED T BS 986, LBL 45. REPAIRED FLOORBEAM PER SRM.SDR 2001UALA00519Floorbeam · crackedMID CABIN FLOORBEAM WEB STA 700 LBL 25 CRACKED. MAJOR REPAIR ACCOMPLISHED.INSTALLED DOUBLERS ON FLOORBEAM PER SRM.SDR DL76L010438Floorbeam · crackedTHE LOWER CHORD AREA OF THE FS 1439 FLOOR BEAM WAS FOUND WITH SEVERAL CRACKS BETWEEN LBL 20 AND LBL 30 CAUSED BY IMPACT WITH CARGO. THE DAMAGED AREA OF LOWER CHORD WAS REMOVED WITH A 7.25 INCH LONG CUTOUT. THE BEAM WAS REPAIRED WITH AN ALUMINUM WEB DOUBSDR 2001UALA00259Floorbeam · corrodedFLOORBEAM HAS 27 PERCENT MATERIAL LOSS AT STA 294. REPAIRED FLOORBEAM. MAJOR REPAIR ACCOMPLISHED.SDR DHL2001806592Floor Support · brokenC-CHECK - MAIN CARGO FLOOR SUPPORT ANGLE AT STA 8.000 RBL 46 BROKEN. STOP DRILLED IAW SRM 53-2-0 FIG 1B. FABRICATED REINFORCING ANGLE.SDR 01FDEA00191Floorbeam · corrodedCORROSION (C53-224-04) AT FASTENER HOLES IN FLOORBEAM BS 1130, RBL 36-42 AND BL 0 - LBL 25, WL 201. *S/D* REPAIRED PER FEDEX EA 7-5310-56290.SDR 01FDEA00192Floorbeam · corrodedCORROSION ON 720A FLOORBEAM UPPER SURFACE OF UPPER FLANGE AT RBL 5 & 11. *S/D* REMOVED AND REPLACED PER SRM 51-10-1 FIG 4, 53-10-8 FIG 3 AND EA 7-5310-56300.SDR 01FDEA00189Floorbeam · corrodedFWD LOWER FLANGE OF FLOORBEAM BS 1010 CORRODED BEYOND LIMITS. *S/D* REMOVED, REPLACED AND FAB PER IAW FEDEX SRM 53-10-8.SDR DHL2001747509Floorbeam · corrodedD-CHECK, TOP CAP OF FLOORBEAM FS 400 RBL 18 HAS EXFOLIATED CORROSION ON BOTTOM-SIDE AT FLOORBOARD SCREW HOLE. ALODINED PER B727 SRM 51-10-2 PG 1. FABRICATED ANGLES -2 & -3 AND LOCATED HOLES PER B727 SRM 53-10-8 PG 44-48. ALODINED PER B727 SRM 51-10-2 PG 1. SDR UPS01435484Floorbeam · corrodedINSPECTION TYPE: C, UPPER DECK FLOOR. CORROSION ON UPPER CHORD OF FLOORBEAM AT BS 520 LBL 46 TO LBL 64 CORROSION REMOVED AND FOUND TO BE OUTSIDE LIMITS. REPAIRS ACCOMPLISHED IAW SRM 53-10-07SDR EIA2001142Floorbeam · crackedHKG-HAECO - FOUND FLOORBEAM LEFT BS 360 CRACKED AT UPPER CHORD FASTENER HOLE THROUGH THICKNESS, RUNNING UPWARD. TRIMMED OFF CRACK, NDT INSPECTED, REPAIRED UPPER CHORD PER EO 53-747-1625-01 REV A AND BSB 53-2429 FIG 4 AND DWG 141U0044 SH 3. (M)SDR EIA2001144Floorbeam · crackedHKG-HAECO - FOUND FLOORBEAM RIGHT BS 420 CRACKED AT FLOORBEAM WEB FASTENER HOLE THROUGH THICKNESS, RUNNING DOWNWARD. TRIMMED OFF CRACK, NDT INSPECTED, AND REPAIRED FLOORBEAM WEB PER SRM 53-10-07 FIG 11. (M)SDR EIA2001145Floorbeam · crackedHKG-HAECO - FOUND FLOORBEAM LEFT BS 420 CRACKED AT FLOORBEAM WEB FASTENER HOLE THROUGH THICKNESS, RUNNING INBOARD. TRIMMED OFF CRACK, NDT INSPECTED, AND REPAIRED FLOORBEAM WEB PER SRM 53-10-07 FIG 11. (M)SDR EIA2001146Floorbeam · crackedHKG-HAECO - FOUND FLOORBEAM RIGHT BS 380 CRACKED AT FLOORBEAM WEB FASTENER HOLE THROUGH THICKNESS, RUNNING UPWARD. TRIMMED OFF CRACK, NDT INSPECTED AND REPAIRED PER EO 53-747-1625-01 REV A AND BSB 53A2429 FIG 5. (M)
Back to JASC 5315