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 2002UALA00029Floorbeam · corrodedBODY STATION 1197-1188 RBL 40-44 RBL 20-25 LBL 6-9 LBL 40-44 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR F3LA200200001Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED FLOORBEAM CORRODED AT FLOOR PANEL SPLICE, STA 770, LBL 2.5. FABRICATED AND INSTALLED REPAIR PER SRM 53-10-1 AND 53-10-5.SDR 0200506624Floorbeam · crackedDURING "H" CHECK FOUND CRACK IN UPPER DECK FLOORBEAM AT BS 300 RBL 64. REPAIRED PER EA 66-188018.SDR AWXA200200028Web · crackedMCN - MAJOR REPAIR - "C" - DURING C-17 CHECK 2 CRACKS WERE FOUND ON WEB BELOW SEAT TRACKS AT BS 709-710, LBL 24. MAINTENANCE REMOVED DAMAGED AREA OF WEB, FABRICATED REINFORCEMENT DOUBLER AND NEW WEB AND INSTALLED REPAIRS IAW AWA ER 03-5715-02011-ES3.SDR SWAA020005Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 500C PLUS 3 TO 500C PLUS 18, LBL 18. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR F3LA200200002Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED CARGO BEAM CORRODED AT FLOOR PANEL SPLICE, STA 770, RBL 8. FABRICATED AND INSTALLED REPAIR PER SRM 53-10-1, 53-10-3 AND 53-10-5.SDR SQ7A032002Floorbeam · corrodedYXD - DURING SCHEDULED MAINTENANCE CORROSION WAS FOUND T- EXTRUSION AT BS 720F LBL 10 RBL 10. REPLACED T SECTION PER SRM 51-20-1 & 51-30-1.SDR SIMA200202306Floorbeam · corrodedABI - DURING MBV INSPECTION, MAINTENANCE FOUND THE LEFT OMEGA BEAM CORRODED AT FRAME 20. MAINTENANCE REPAIRED LEFT OMEGA BEAM IAW EMB REPAIR STATEMENT NGST-0012/02. (M)SDR AWXA200200046Tee Chord · corrodedMCN - MAJOR REPAIR - "C" - DURING C-17 CHECK CORROSION WAS FOUND ON FLOOR BEAM UPPER FLANGE AT BS 947, LBL 10 TO RBL 10. MAINTENANCE REMOVED 6 EACH FLOOR SUPPORT, 1 EACH INTERCOASTAL BRACKET ASSEMBLY, AND TEE CHORD FROM LBL 32 TO RBL 33. FABRICATED AND INSTALLSDR AWXA200200029Floorbeam · corrodedMCN - MAJOR REPAIR - C - DURING C-17 CHECK CORROSION WAS FOUND ON FLOORBEAM UPPER FLANGE AT BS 986, RBL 3 TO LBL 18. REMOVED DAMAGED AREA OF FLOORBEAM UPPER T-CHORD AT BS 986, RBL 3 TO LBL 50. FABRICATED 2 SPLICE STRAPS AND REPAIR ANGLES AND NEW UPPER T-CHORSDR 0200165504Support · corrodedDuring "H" check found corrosion on seat track support at BS 400 RBL 25. Repaired per EA 55-187555.SDR AWXA200200060Floorbeam · corrodedMCN - MAJOR REPAIR - C - DURING C-15 CHECK MAINTENANCE DISCOVERED CORROSION ON MAIN CABIN FLOORBEAM AT PREVIOUS REPAIR FILLER, BS 967, LBL 28, WL 208.1. MAINTENANCE REMOVED REPAIR ANGLES AND FILLER AT BS 967 BEAM, CLEANED CORROSION ON FILLER AND FOUND MATERIASDR AWXA200200011Floorbeam · corrodedMCN - MAJOR REPAIR - C - DURING C-15 CHECK MAINTENANCE FOUND CORRODED FLOORBEAM AT BS 967, FROM RBL 15 TO RBL 18, WL 208.1. MAINTENANCE CLEANED AND BLENDED CORRODED SECTION OF FLOORBEAM AND PERFORMED MATERIAL THICKNESS MEASUREMENT FINDING MATERIAL LOSS OUT OFSDR 2001UALA02499Floorbeam · corrodedAFT PIT FLOORBEAM T-CAP CORRODED RBL 8, STATION 1197.66. MAJOR REPAIR ACCOMPLISHED. T-CAP REPAIRED.SDR 2001UALA02498Floorbeam · corrodedAFT PIT FLOORBEAM T-CAP CORRODED UNDER NUT PLATE STRINGER 33L STATION 1197 + 110. MAJOR REPAIR ACCOMPLISHED. T-CAP REPAIRED.SDR 2001UALA02497Floorbeam · corrodedAFT PIT FLOORBEAM T-CAP CORRODED ABOVE STRINGER 36L, STATION 1153. MAJOR REPAIR ACCOMPLISHED. REPAIRED T-CAP.SDR 2001UALA02495Floorbeam · corrodedSTATION 1640 CABIN FLOORBEAM HAS EXCESSIVE MATERIAL LOSS AT RBL 34-50. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED T-CAP REPAIR.SDR 2001UALA02485Floorbeam · corrodedSTATION 1006, WL 208 LBL 26, FLOORBEAM MATERIAL LOSS AFTER CORROSION REMOVAL EXCEEDS LIMITS. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED FLOORBEAM REPAIR.SDR SIMA200202210Floorbeam · corrodedABI - DURING MBV INSPECTION, MAINTENANCE FOUND THE LEFT OMEGA BEAM TO BE CORRODED AT FRAME 20. MAINTENANCE REPAIRED THE LEFT OMEGA BEAM IAW EMB 135 SRM 53-21-10. (M)SDR 2001UALA02484Floorbeam · corrodedFLOORBEAM AT BODY STATION 294.5, REPAIR PLATE ON CAP BETWEEN RBL 28 AND RBL 44, UPPER SURFACE IS CORRODED. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED SPLICE REPAIR.SDR C2XA01TY223Floorbeam · corrodedTYS, DURING A SCHEDULED 1C INSPECTION, CORROSION WAS FOUND ON SEVERAL AREAS OF THE FORWARD DIGITAL. MAINTENANCE REMOVED FORWARD DIGITAL AND CUT OUT DAMAGED AREA, FABRICATED DOUBLERS AND INSTALLED, REINSTALLED DIGITAL IAW-EC5320-01059, EMB-135/145-SRM-51-20-03SDR C2XA02IA005Floorbeam · corrodedIAH- DURING C-CHECK INSPECTION IT WAS NOTED THAT THE OMEGA BEAM AT FRAME 20 WAS CORRODED. MAINTENANCE REMOVED THE CORRODED AREA, FABRICATED A FILLER, REINFORCEMENT AND INSTALLED IT ON THE OMEGA BEAM AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE, WHEN RSDR SWAA013450Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 294, WL 208 AND LBL 47. REPAIRED FLOORBEAM PER BFG ER.SDR 2002F00119Floorbeam · corrodedFORWARD CABIN FLOOR STRUCTURE, FLOORBEAM UPPER CHORD AT BS 294 RBL 10 TO LBL 10 WL 208 HAS CORROSION. (M)SDR AWXA200200024Floorbeam · corrodedMCN - MAJOR REPAIR - C - DURING C-17 CHECK MAINTENANCE DISCOVERED CORROSION ON FLOORBEAM UPPER FLANGE AT BS 986, RBL 17. REMOVED DAMAGED AREA OF FLOORBEAM UPPER T-CHORD AT BS 986, FABRICATED 2 SPLICE STRAPS, REPAIR ANGLES, NEW UPPER T-CHORD AND INSTALLED REPSDR AWXA200200016Frame · crackedMCN - MAJOR REPAIR - "C" - DURING C-15 CHECK MAINTENANCE DISCOVERED CRACKED FRAME AT FASTENER BS 616, LBL 64. MAINTENANCE CUTOUT DAMAGED AREA OF FRAME, DAMAGED AREA WITHIN REPAIRABLE LIMITS IAW AWA ER 03-5311-01143-DD1. HFEC INSPECTION COMPLIED WITH TO VERIFY SDR SWAA013423Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND 3 EA FLOORBEAMUPPER CHORDS CORRODED, BS 312, LBL 11 TO RBL 19, BS 328, LBL 11, AND BS 294, LBL 11 TO RBL 22. REMOVED AND REPLACED UPPER CHORD SECTIONS PER SRM.SDR F3LA200100144Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM AT STA 294 FROM LBL 17 TO LBL 25. FABRICATED REPAIR AND INSTALLED PER SRM 51-40-3, FIG 1 AND 53-10-9, FIG 5.SDR C2XA01TY211Floorbeam · corrodedTYS DURING A SCHEDULED 1-C INSPECTION CORROSION WAS FOUND AT THE LEFT OMEGA BEAM. MAINTENANCE CLEAN INSPECTED AND OVERSIZE ONE RIVET IAW EMB 135/145 SRM 51-10-02 AND 51-40-02. WILL BE RELEASED UPON COMPLETION OF THE 1-C INSPECTION.SDR 2001UALA02474Floorbeam · corrodedAFT PIT FLOORBEAM T-CAP LOWER SURFACE HAS CORROSION AT STATION 1197+132 AT STRINGER 33L. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM T-CAP.SDR SWAA013416Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED, BS 986.5, LBL 16.5. REPAIRED BEAM PER SRM.SDR ASAA0140184Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM AT BS 360 HAS CORROSION AT NUT CLIP HOLES, RBL 13 TO 40 AND WL 208. REPAIRED IAW SRM. (M)SDR SWAA013393Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED, BS 986, LBL 29 TO RBL 51.5. REMOVED AND REPLACED FLOORBEAM UPPER CHORD PER SRM.SDR SIMA200202201Floorbeam · corrodedABI - DURING MBV INSPECTION MAINTENANCE, FOUND CORROSION ON THE CENTER OMEGA BEAM BETWEEN FRAMES 20 AND 22. MAINTENANCE REPAIRED OMEGA BEAM IAW EMB REPAIR STATEMENT GST4085A/01. (M)SDR 2001UALA02458Floorbeam · corrodedCABIN FLOORBEAM UPPER CHORD HAS CORROSION RBL 53 TO RBL 62 STATION 324. MAJOR REPAIR ACCOMPLISHED. SPLICED IN NEW SECTION OF FLOORBEAM UPPER CHORD.SDR SIMA200202209Floorbeam · corrodedABI - DURING MBV INSPECTION MAINTENANCE, FOUND THE FORWARD DIGITAL TO BE CORRODED. MAINTENANCE REPAIRED THE FORWARD DIGITAL IAW EMB REPAIR STATEMENT GST4123/01. (M)SDR 2002F00070Floorbeam · corrodedDURING C-CHECK, FLOORBEAM UPPER CHORD FOUND CORRODED, BS 324, RBL 58, WL 208. REPAIRED UPPER CHORD PER SRM. (M)SDR SWAA013371Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AT FLOORBEAM UPPER CHORD, BS 312, LBL 20 TO RBL 22, WL 208. REMOVED AND REPLACED UPPER CHORD SECTION PER SRM.SDR 2001UALA02462Floorbeam · corrodedBODY STATION 347 LBL 88 WL 200 FLOORBEAM T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2001UALA02447Floorbeam · corrodedCABIN FLOOR STATION 77 LBL 42 HAS EXCESSIVE MAT LOSS ON UPPER CAP OF BEAM. MAJOR REPAIR ACCOMPLISHED. REPAIR STRAPS 11 INSTALLED.SDR 2001UALA02446Floorbeam · corrodedCABIN FLOOR STATION 377 LBL 22 HAS EXCESSIVE MAT LOSS ON UPPER CAP. MAJOR REPAIR ACCOMPLISHED. REPAIR STRAPS INSTALLED.SDR 2001UALA02439Floorbeam · damagedAFT CABIN FLOORBEAM STATION 947 RBL 46 WL 208 BLENDED REPAIR OUT OF LIMITS. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED T-CAP. MANUFACTURED NEW T-CAP. INSTALLED NEW CAP AND SPLICE ANGLES.SDR 2001UALA02438Floorbeam · damagedCABIN FLOORBEAM STATION 967 RBL 10 HOLE ELONGATED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGE. INSTALLED ANGLE REPAIR WITH FILLER.SDR SWAA013367Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND BS 860 AND BS 859, LBL 3, LONGITUDINAL BEAM CORRODED AT NUT PLATE HOLES. REPAIRED FLOORBEAM PER SWA RA.SDR SIMA200200205Floorbeam · corrodedSAW - DURING CPCP4 INSPECTION FLOORBEAM 36 WAS FOUND TO BE CORRODED. FLOORBEAM 36 WAS REPLACED IAW ATR SRM 51-25-02. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA200200204Floorbeam · corrodedSAW - DURING CPCP4 INSPECTION FLOORBEAM 39 WAS FOUND TO BE CORRODED. FLOORBEAM 39 WAS REPLACD IAW ATR SRM 51-25-01. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA200200201Floorbeam · corrodedSAW - DURING CPCP2 INSPECTION, FLOORBEAM 38 WAS FOUND TO BE CORRODED. FLOORBEAM 38 WAS REMOVED AND REPLACED IAW ATR72 SRM 53-00-00, FIGURE 435. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA200202101Floorbeam · corrodedABI - DURING MBV INSPECTION MAINTENANCE, FOUND THE LEFT OMEGA BEAM TO BE CORRODED AT FRAME 20. MAINTENANCE REPAIRED LEFT OMEGA BEAM IAW REPAIR STATEMENT EMB GST 4044/01. (M)SDR 2002F00127Floorbeam · corrodedFOUND CORROSION AROUND FLOORBEAM FASTENER HOLES AT STATION 344 LBL 10 AND STATION 360 RBL 1. (M)SDR 2001UALA02436Floorbeam · corrodedSTATION 1681, RBL 47 RBL 48, FLOORBEAM UPPER CAP HAS EXCESSIVE MATERIAL LOSS. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE DOUBLERS AND FILLER.
Back to JASC 5315