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 01FDEA00599Floorbeam · corrodedCORROSION IN AND AROUND NUT PLATE HOLES ON LOWER CHORD OF BS 1130 FLOORBEAM RBL 50 - LBL 25, WL 200. REMOVED AND REPLACED FLOORBEAM PER IAW FEDEX EA 7-5310-59209.SDR SWAA012094Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND UPPER FLOORBEAM CHORD CORRODED AT BS 328, BETWEEN RBL 0-65, WL 208. REPAIRED FLOORBEAM CHORD PER SRM.SDR AALA20011485Floorbeam · corrodedTUL - FOUND RIGHT BUTT LINE 10 CORROSION ON TOP OF FLOORBEAM STATION 380. REPAIRED FLOORBEAM PER 53-10-08. (M)SDR USAA010885Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 4 INCHES BY 2 INCH AREA, BS 1006, LBL 8 TO LBL 12. REPLACED UPPER T-CAP PER EA 69770 AND TR 53-10-05A. (M)SDR USAA010881Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH AREA, BS 1016 LBL 6 TO LBL 34. CORROSION LEVEL 1, TASK NR C53-202-01. REMOVED AND REPLACED T-CAP PER TYPICAL REPAIR 53-10-05A. (M)SDR C2XA01TY098Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE FORWARD DIGITAL PLATE, LOCATED JUST AFT OF COCKPIT ENTRANCE WAS FOUND TO HAVE SEVERAL AREAS OF CORROSION. MAINTENANCE ACCOMPLISHED THE DOUBLER REPAIR IAW EMB GST 2405-01, THE REPAIR WAS SATISFACTORY. AIRCRAFT RELEASED FSDR SIMA200120702Floorbeam · corrodedSAW - DURING CPCP2 INSPECTION, FOUND CORROSION ON FLOORBEAM 40. THE FLOORBEAM WAS REMOVED AND REPLACED IAW ATR72 SRM 51-25-02. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR AALA20011483Floorbeam · corrodedTUL - FOUND CORROSION ON THE TOP OF THE FLOORBEAM AND FAST HOLES STATION 380 RBL 20-60. CUT OUT AND REMOVED CORROSION AND INSTALLED REPAIRS PER 53-10-8 PAGE 9A AND 9B AND 53-10-8 FIG 1 STIFFENER REPAIRS AND FILLERS. (M)SDR USAA010878Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 18 INCH AREA, BS 986.5, BL 0 TO RBL 18. CORROSION LEVEL 1, TASK NR C53-107-02. REMOVED AND REPLACED T-CAP PER TYPICAL REPAIR 53-10-05A. (M)SDR USAA010877Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED, ENTIRE LENGTH OF FLOORBEAM, BS 294.5 STRINGER 17L TO 17R. CORROSION LEVEL 1, TASK NR C53-107-02. DAMAGE REMOVED, INSTALLED DOUBLER PER SRM 53-10-51. (M)SDR SIMA200119906Floorbeam · corrodedSAW - DURING CPCP2 INSPECTION, FOUND CORROSION ON FLOORBEAM 38 AND 39. THE FLOORBEAMS WERE REPAIRED BY INSERTION OF A SPLICE IAW ATR72 SRM. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SWAA012128Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 947.5, LBL 52. REPAIRED CHORD PER SRM.SDR ZW0A0105409Floorbeam · corrodedDURING CHECK-C MAINT IN THE AFT CABIN FOUND TOP OF FLOORBEAM STA 1322 WAS CORRODED AT LBL 15 TO SIDEWALL. REMOVED CORROSION MECHANICALLY PER SPM 6-80-1. INSTALLED REPAIR PER SRM 53-05, FIG 20A.SDR USAA010845Floorbeam · damagedCLT - FOUND FLOORBEAM WITH ELONGATED CLIPNUT HOLES .125 INCH AND .25 INCH, BS 328, LBL 28. INSTALLED REPAIR ANGLES PER SRM 53-10-51, FIG 206. (M)SDR 0102665519Floorbeam · crackedDURING L CHECK, FOUND CRACK IN FLOORBEAM. REPAIRED PER EA55-184811.SDR UPS01836468Floorbeam · corrodedINSPECTION TYPE:C1 STA -67 FLOORBEAM IS CORRODED BEYOND LIMITS AT LBL 60. REPAIRED FLOORBEAM IAW 8110-3 APPROVED DH SK 874-130SDR AWXA0002006Doubler · crackedD: Doubler on floor beam at BS 670 LBL 24 cracked.C: Removed and replaced doubler IAW B737 SRM 51-30-05 pg 5SDR AWXA0002003Floorbeam · corrodedPASSENGER CABIN FLOORBEAM BS 377, BL 0 TO LBL 24, UPPER T-CAP TOP FLANGE AND LOWER SURFACE CORRODED. CUT OUT DAMAGED SECTION OF UPPER T-CAP FLOORBEAM. FABRICATED NEW SECTION OF BEAM AND REPAIR SPLICE ANGLES AND INSTALLED ALL THE NEW REPAIR PARTS AND PREVIOUSSDR 0102535519Floorbeam · crackedIN L CHECK, FOUND CRACKED FLOORBEAM. REPAIRED PER EA55-184810.SDR 2001UALA01361Floorbeam · corrodedFLOORBEAM T CAP CORRODED. STA 967, RBL 4 TO RBL 45. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED TCAP SPLICE REPAIR.SDR ZW0A0105303Floorbeam · crackedDURING CHECK-C MAINT FOUND CABIN FLOORBEAM FITTING CRACKED AT STA 1308, LBL 35. REMOVED AND REPLACED FITTING PER SRM 51-30-5.SDR SWAA011986Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOOR BEAM UPPER T CHORD CRACKED AT BS 344, LBL 9. REPAIRED FLOOR BEAM TEE PER SRM.SDR SIMA200119901Floorbeam · corrodedSAW - DURING CPCP 2 INSPECTION, FOUND 4 FLOORBEAMS WERE FOUND TO BE CORRODED, FLOORBEAM 36, FLOORBEAM 38, FLOORBEAM 39, FLOORBEAM 40. THE FLOORBEAMS WERE REMOVED AND REPLACED IAW ATR72 SRM. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR AWXA0002033Angle · corrodedD: Right crease beam corroded BS 294.5 to BS 345C: repaired per SRM 51-70-11 fig 1SDR COOSDR010073Floorbeam · crackedPAX CABIN FROM BS 520 RBL 25 AND WL 208, FLOOR BEAM CRACKED.SDR COOSDR010063Floorbeam · crackedFUSELAGE FLOOR BEAM SECTION UPPER CHORD AT BS 328 BETWEEN RBL 24.5 AND RBL40, CRACKED.SDR COOSDR010052Floorbeam · crackedFORWARD C/C, FLOOR BEAM, LOWER CHORD, RBL 25 INCHES, WL 201 WITH CRACK.SDR LR7A01038Stiffener · distortedDURING POST TAIL STRIKE DAMAGE EVALUATION (REF. OPER CTRL NO. LR7A01033) FOUND FS 797E VERTICAL STIFFENERS DISTORTED AT LBL 10 AND RBL 10, WL 127.75 - 145.FABRICATED AND REPLACED STIFFENERS IAW SRM SMP 583-53-10 PG 7 D., 51-70. NR 9, CONT. SHEET ITEM 8, 9, 10SDR LR7A01036Cap · crackedDURING POST TAIL STRIKE DAMAGE EVALUATION (REF. OPER CTRL NO. LR7A01033) FOUND FS 797E - 817E BEAM LOWER CAP CRACKED FS 797E AT LBL 10, WL 127.75.FABRICATED AND REPLACED LOWER CAP IAW SRM SMP 583-53-10 PG 7 D., 51-70. NR 9, CONT. SHEET ITEM 17, 18, 19.SDR PCAA0107067Floorbeam · crackedDURING SCHEDULED A INSPECTION NOSE GEAR WELL FLOORBEAM AT STATION X97 FOUND CRACKED. REPAIR STRAP INSTALLED PER DEHAVILLAND REPAIR DRAWING RD 8-53-5993 AS AN INTERIM REPAIR FOR 250 HOURS AT WHICH A PERMANENT REPAIR WILL BE INSTALLED. DEHAVILLAND HAD ISSUED RSDR USAA010796Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 24 INCH AREA, BS 344, LBL 12 TO RBL 12. DAMAGE REMOVED, REPLACED T-CAP SECTION PER SRM 53-10-51. (M)SDR USAA010795Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCH BY 90 INCH AREA, BS 987, DOOR TO DOOR. REMOVED AND REPLACED FLOORBEAM T-CAP PER TYPICAL REPAIR 53-60-01. (M)SDR USAA010792Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCH BY 18 INCH AREA, BS 947 LBL 12 TO RBL 6. DAMAGE REMOVED, REPLACED T-CAP PER TYPICAL REPAIR 53-60-02. (M)SDR AWXA0002063Floorbeam · crackedBS 725 BL 24LT SEAT TRACK LOWER ATTACH FLANGE CRACKED. REMOVED CRACK FROM SEAT TRACK LOWER ATTACH FLANGE, INSTALLED REPAIR ON SEAT TRACK LOWER ATTACH FLANGE IAW ER 15-5715-01202-DL3.SDR USAA010781Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 3 INCHES BY 4 INCHES, BS 287, RBL 64. DAMAGE REMOVED, INSTALLED REPAIR DOUBLER PER EA 85042. (M)SDR 0102762710Floorbeam · corrodedDURING "M" CHECK FOUND CORROSION ON UPPER CHORD OF FLOORBEAM. REPAIRED PER EA 27-184389.SDR AWXA0001956Floorbeam · corrodedFS 365 BL 0 TO RBL 60 FOUND SURFACE CORROSION ON UPPER T-CAP AT FLOORBEAM. REMOVED DAMAGED T-CAP, FABRICATED NEW T-CAP AND INSTALLED PER SRM 53-0051 FIG 203 SH 2.SDR AWXA0001954Floor Support · corrodedD: corrosion on top surface of floor structure, FS 350 BL 00C: Removed damaged section of floor support from STA 330 to STA 360 BL0 fabricated installed repair per SRM 51-70-11 fig 1 pg 1SDR AWXA0002029Floorbeam · damagedSTA 312 FLOORBEAM HAS NON SRM REPAIR. REPAIRED PER SRM 53-10-51.SDR AWXA0002030Floorbeam · corrodedD: STA 328 Floor beam Corroded from RBL 30 to RBL 45C: Repaired per SRM 53-10-51 Fig 205SDR AWXA0002028Floor Support · corrodedD: Floor support corroded STA 312 to 328 RBL 10C: Replaced support IAW 51-10-2 & 53-10-51SDR AWXA0002075Floorbeam · crackedLOWER T-CHORD CRACKED BS 717 BL 0 BELOW CABIN FLOOR. REPAIRED IAW AWA ER 15-5702-01209-DD2.SDR UPS01836433Floorbeam · corrodedINSPECTION TYPE:C2 STA 1700 FLOORBEAM UPPER FLANGE IS CORRODED BEYOND LIMITS AT LBL 24. REPAIRED FLOORBEAM IAW 8110-3 APPROVED DH SK 807-264SDR 2001UALA01326Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AT BS 294, RBL 35 RBL 38. REPAIRED T-CAP. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA01325Floorbeam · corrodedFLOORBEAM T-CAP CORRODED AT BS 986.5, RBL 22.5- RBL 31. REPAIRED FLOORBEAM. MAJOR REPAIR ACCOMPLISHED.SDR AWXA0002002Web · crackedD: Floor beam cracked @ BS 712, LBL 25C: Repaired floor beam web at BS 712, LBL 25 IAW AWA ER #15-5715-01195-SS1SDR AWXA0001999Floorbeam · corrodedAFT CABIN FLOOR PANEL SUPPORT AT Y-1732 RT FR 66 SCREW HOLES CORRODED. REMOVED CORROSION, MATERIAL REMOVED .100 INCH (BEYOND LIMITS AS PER SRM 51-72-11 PG 1). REPLACED BEAM AS PER A320 SRM 51-42-11 PAR 6.SDR AWXA0002147Floorbeam · corrodedCORROSION ON FLOORBEAM BS 947 RBL 43.0 TOP AND BOTTOM OF UPPER FLANGE. CUT OUT CORRODED SECTION OF BS 947 RBL 43 FLOORBEAM UPPER FLANGE. INSTALLED REPAIR IAW B737 SRM 53-10-9 FIG 3.SDR AWXA0002068Floorbeam · corrodedCORROSION ON FLOOR BS 947 RBL 43.0 TOP AND BOTTOM OF UPPER FLANGE. CUT OUT CORRODED SECTION OF BS 947 RBL 43 FLOORBEAM UPPER FLANGE. INSTALLED REPAIR IAW B737 SRM 53-10-9 FIG 3.SDR GAIA01226STFloorbeam · corrodedDURING A LTC INSPECTION AT FLIGHTSTAR, IT WAS DISCOVERED IN DOG HOUSE AREA, FLOORBEAM T-CAP IS CORRODED AT BS 312 LBL 3. ACCOMPLISHED BS 312 FLOORBEAM UPPER CHORD REPAIR AT LBL 3 IAW B727 SRM 53-10-2 FIG 7 AND SRM 51-40-3 FIG 1. (M)
Back to JASC 5315