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 CALA0400287Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 365, RBL 18. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR MWEA040033Longeron · crackedWINDOW BELT CRACK VISUALLY DETECTED, STATION 408 LONGERON 15 LEFT. FABRICATED AND INSTALLED REPAIR PARTS FABRICATED AND INSTALLED EACH LONGERON SPLICE, INSTALLED TITANIUM DOUBLER AND INSTALLED INTERCOSTAL.SDR C2XA04SH180Strap · corrodedSHV- DURING C-CHECK THE AFT FLOORBEAM AT FRAME 17 TO 19 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVSDR C2XA04SH179Strap · corrodedSHV- DURING C-CHECK THE FORWARD FLOORBEAM AT FRAME 16 TO FRAME 18 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DIGITAL IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA04300Floorbeam · corrodedDURNG A C-CHECK IN YUL, THE FLOORBEAM AT FRAME 36 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM AT FRAME 36 IAW SRM 51-25-01. (M)SDR ASOA04301Floorbeam · corrodedDURING A C-CHECK IN YUL, THE FLOORBEAMS AT FRAME 38 AND 39 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED THE FLOORBEAMS AT FRAME 38/39 IAW SRM 53-00-00. (M)SDR GTIA040473Floorbeam · corrodedAFT PIT STA 1309 FLOORBEAM CORRODED AT LOWER SIDE LBL 30-RBL 30. CUT FLOORBEAM AT STA 1309 LBL 33. FABED 2 EA L ANGLES. FABRICATED NEW FLOORBEAM AND SPLICE DOUBLER. RT OB FITTING OUT OF LIMITS. FABRICATED FLOORBEAM SUPPORT ANGLE. INSTALLED FLOORBEAM. 2 SDR ASAA0440086Floorbeam · corrodedGYR - MAIN DECK FLOORBEAM AT STATION 294.5 APPROX LBL 12 TO RBL 50, UPPER T-CAP HAS SEVERAL AREAS OF CORROSION ON UPPER SURFACE. BLENDED CORROSION CK OUT OF LIMITS. REMOVED 'T' AND REPAIR ANGLE EPR SRM 53-10-51. (M)SDR ASAA0410149Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND CORROSION ON FLOORBEAM STATION 480. REPAIR IAW EA. (M)SDR ASOA04232Floorbeam · crackedDURING A C-CHECK IN MCN, THE OUTBOARD FLOORBEAM ANGLES AT FS 621, LBL 27 AND RBL 27 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE OUTBOARD FLOORBEAM ANGLES AT FS 621, LBL 27 AND RBL 27 IAW ASA EO 600-53-0105. (M)SDR SWAA040849Floorbeam · corrodedDURING SCHEDULED SPV, FOUND FLOORBEAM TOP CHORD AT BS 988, BL 0 TO RBL 45, WL 208 CORRODED. REPAIRED FLOORBEAM CHORD PER ER.SDR C2XA04SH176Buttstrap · corrodedSHV- DURING C-CHECK THE AFT FLOORBEAM BUTTSTRAP WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DHL2004803502Floorbeam · wornITEM REF. NR. 1122: MAIN CARGO COMPT. NR 7 FLOORBEAM LUGS WORN, STA. 1120.000. CUT OUT NR 7 FLOORBEAM DAMAGE SECTION IAW SRM 53-2-3 PG.17 FIG. 6D. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW CHANNEL AND FLOORBEAM PLUG IAW SRM 51-3-0 PG.1, SDR C2XA04SH172Buttstrap · corrodedSHV- DURING C-CHECK THE FORWARD FLOORBEAM BUTTSTRAP AT FRAME 14 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 135 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR COMA0460233Floorbeam · corrodedCARGO BAY FLOORBEAM LBL 27 HAS CORRODED SURFACE DAMAGE. REMOVED CARGO BAY FLOORBEAM CAP AT LBL 27, LOCATED HOLES IN A NEW FLOORBEAM CAP (P/N: 601R35031-3). INSTALLED NEW CAP WITH SERVICE HI LOKS RIVNUTS, AND CHERRY RIVETS IN ACCORDANCE WITH CRJ SRM 51-42-06,SDR ABXA040130Floorbeam · corrodedRIGHT PRESSURE DECK MAIN CABIN LOWER SIDE OF FLOORBEAMS AT STA 920 AND 940 ARE EXFOLIATED. REPAIRED AREA IAW REA D853-48871MR AND REA D853-48873MR.SDR SWAA040830Floorbeam · corrodedDURING SCHEDULED SPV, FOUND FLOORBEAM AT BS 344, LBL 49, WL 208, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR ASAA0410146Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND FLOORBEAM UPPER CHORD IS CORRODED AT STATION 1016. REPAIR IAW SRM. (M)SDR ASAA0410126Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND CORROSION ON T-CHORD AT STATION 1115-1125. REPAIR IAW SRM. (M)SDR ASAA0410124Floorbeam · corrodedOKC DURING MAINTENANCE, FOUND AFT PIT CABIN FLOORBEAM T-CHORD CORRODED AT FS 747. REPAIR IAW SRM. (M)SDR ASAA0410129Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND FORWARD PIT CEILING FLOORBEAM AT STATION 460 CORRODED. REPAIR IAW SRM. (M)SDR ASAA0410134Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND FLOORBEAM AT STATION 1006 CORRODED ON UPPER CHORD. REPAIR IAW SRM. (M)SDR ASAA0410138Floorbeam · corrodedOKC - DURING MAINTENANCE, FOUND AFT PIT CABIN FLOORBEAM UPPER T-CHORD CORRODED AT STATION 986.5. REPAIR IAW SRM. (M)SDR SWIA200413117Floorbeam · corrodedCABIN FLOORBOARD FRAMES HAVE CORROSION AT FRAME 38. DISCOVERED DURING C-CHECK INSPECTION. REPLACED FRAME AT CABIN FLOOR IAW SRM 120 51-10-02 PG 3 SEC 3.A.SDR AALA20040411Floorbeam · corrodedAFW - CORROSION DISCOVERED ON THE TOP SURFACE OF THE UPPER FLOORBEAM AT STATION 1518. REMOVED CORROSION AND FABRICATED REPAIR STRAP FROM 0.050 INCH 301 1/2 H STAINLESS STEEL, MADE SURE STRAP COVERED THREE ROWS OF FASTENERS PAST DAMAGE. ALODINED ALL BARE ALUMSDR AALA20040369Floorbeam · corrodedAFW - CORROSION REMOVED AT FLOORBEAM AT RIGHT BUTTOCK LINE 8, 12.5, 17, 21.5, 23, 24, 28, 30 32, 34.5, 39,40, 43.5, 44.75, 46, 47.25, 51.25, 52, AND 54. LARGEST BLEND IS AT RIGHT BUTTOCK LINE 40 AND IS 1.0 INCH WIDE AND 0.039 INCH DEEP AT STATION 325. REMOVESDR AALA20040368Floorbeam · corrodedAFW - CORROSION REMOVED AT FLOORBEAM AT RIGHT BUTTOCK LINE 24, 30, 33, 45, 52, 56, 58, 60, 62, 65, 66, 68, 70, AND 73. LARGEST BLEND IS AT RIGHT BUTTOCK LINE 66 AND IS 1.0 INCH BY 0.050 INCH AND 0.050 INCH DEEP AT STATION 347. REMOVED CORROSION. FABRICATED SDR SWAA040820Floorbeam · corrodedDURING SCHEDULED SPV, FOUND FLOORBEAM AT BS 312, LBL 11 CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR 2XA04SH171Strap · corrodedSHV - DURING C-CHECK THE LEFT FORWARD DIGITAL STRAP FROM FRAME 15 TO FRAME 16.5 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED STRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH167Floorbeam · corrodedSHV - DURING C-CHECK THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A FILLER SHIM REPAIR IAW EMB 135 SRM 51-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH166Floorbeam · crackedSHV - DURING C-CHECK, THE T-SECTION IN THE LOWER CARGO DOOR CUTOUT AT FRAME 67 WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE CRACKED T-SECTION IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR UPS04842195Floorbeam · corrodedINSPECTION TYPE: C1, MAIN CABIN FS 1727 FLOORBEAM AT RBL 34 & FLOOR SUPPORT CORRODED. REMVOED CORROSION FROM FLOORBEAM IAW DC8 SRM 51-1-8. OUT OF LIMITS IAW DC8 SRM 53-2-0. FABRICATED TEE & L ANGLES IAW DAC DWG 575503. LOCATED AND DRILLED PARTS IAW DC8 SRM SDR C2XA04SH161Floorbeam · crackedSHV - DURING C-CHECK THE CENTER FLOORBEAM RAMP ANGLE WAS FOUND TO BE CRACKED AT FRAME 21. MAINTENANCE REMOVED AND REPLACED THE CRACKED ANGLE IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH160Strap · corrodedSHV - DURING C-CHECK THE AFT LEFT CENTER DIGITAL STRAP WAS FOUND TO BE CORRODED AT FRAME 16 TO FRAME 18. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DIGITAL STRAP IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA040790Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 344, LBL 33 TO RBL 39. REPAIRED FLOORBEAM PER SRM.SDR SWAA040776Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEBS CRACKED AT BS 576, LBL 71, WL 208 AND BS 637, LBL 71, WL 208. REMOVED AND REPLACED CREASE BEAM WEBS PER SRM.SDR UPS04842193Floorbeam · corrodedINSPECTION TYPE:C1 MAIN CABIN FS 1660 FLOORBEAM AT LBL 20-LBL 30 HAS CORROSION ON UPPER SURFACE. REMOVED CORROSION IAW DC8 SRM 51-1-8. FOUND PRE-EXISTING PLUG AT SEAT TRACK ATTACH HOLE OUT OF LIMITS. ROUTED OUT DAMAGE & FAB REPAIR ANGLE AND FILLER IAW DC8 SSDR 2004UALA00246Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM CAP AT STA 986.5 RBL 45.5. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED FLOORBEAM REPAIR.SDR C2XA04TY050Floorbeam · corrodedTYS, DURING A SCHEDULED INSPECTION, CORROSION WAS FOUND ON THE FORWARD CENTER DIGITAL PLATE AT THE FORWARD NUT PLATE HOLE. MAINTENANCE REPAIRED THE CORRODED AREA, ALODINED, PRIMED AND PAINTED IAW EMB-145 SRM 51-21-01 AND CMP-51-21 04/05/06.SDR C2XA04SH157Floorbeam · corrodedSHV - DURING C-CHECK, THE LEFT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A SHIM FILLER REPAIR IAW EMB 245 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04TY047Floorbeam · corrodedTYS DURING A SCHEDULED 2C INSPECTION CORROSION WAS FOUND ON THE RAMP ANGLE AT THE GALLEY AREA. MAINT REMOVED AND REPLACED THE RAMP ANGLE IAW EMB 135/145 SRM 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE RELEASED UPON COMPLETION OF ALL WORK.SDR C2XA04TY046Floorbeam · corrodedTYS DURING A SCHEDULED 1C INSPECTION THE LT OMEGA BEAM WAS FOUND CORRODED AT FR 20. MAINT CUT OUT THE CORRODED AREA, FABBED A NEW FILLER, SHIM AND DOUBLER, INSTALLED. ALODINED, PRIMED AND PAINTED IAW SRM 51-21-10. ALL WORK WAS ACCOMPLISHED AND WILL BE RELESDR CALA0400236Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON BOTTOM SIDE AT STA 360, BL 0. A DOUBLER WAS INSTALLED IAW SRM 53-00-51.SDR C2XA04SH148Floorbeam · corrodedSHV - DURING C-CHECK, THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA040763Floorbeam · corrodedDURING SCHEDULED SPV, FOUND FLOORBEAMS CORRODED AT BS 1006, LBL 14 TO LBL 38, WL 208 AND BS 1016, LBL 3 TO LBL 8, WL 208. REPAIRED FLOORBEAMS PER ER.SDR SWAA040750Floorbeam · corrodedDURING SCHEDULED SPV, FOUND FLOORBEAM CHORD CORRODED AT BS 986, RBL 38, WL 208. REPAIRED FLOORBEAM CHORD PER ER.SDR SWAA040762Floorbeam · crackedDURING SCHEDULED SPV, FOUND FLOORBEAM CRACKED AT BS 947, LBL 53, WL 208. REPAIRED FLOORBEAM PER ER.SDR C2XA04SH147Floorbeam · corrodedSHV - DURING C-CHECK, THE LEFT HAND FLOORBEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 24 AND 25. MAINTENANCE REMOVED THE AFFECTED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA04SH146Floorbeam · corrodedSHV - DURING C-CHECK, THE CENTER FLOORBEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 24 AND 25. MAINTENANCE REMOVED THE AFFECTED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASAA0440074Floorbeam · corrodedGYR - FOUND CABIN FLOORBEAM STATION 986.5 CORRODED RBL 48 TO LBL 48. REPLACED FLOORBEAM. (M)
Back to JASC 5315