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 C2XA02SH012Floorbeam · corrodedSHV- DURING C-CK INSPECTION, THE RIGHT HAND INBOARD FLOORBEAM AT FRAME 20 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED SECTION OF FLOORBEAM IAW EMB-145 SRM 51-40-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA021350Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, WL 208 AND LBL 45. REPAIRED FLOORBEAM PER BFG ER.SDR 2003F00055Floorbeam · corrodedFOUND DURING DOUGLAS D-CHECK INSPECTION, AT STATION 1600 LBL 42 INCH FLOORBEAM UPPER FLANGE LOWER SURFACE HAS 1 INCH BY 2 INCH CORRODED BEYOND LIMITS. REMOVED CORROSION IAW DC-8 SRM 51-1-8. FABRICATED REPAIR DOUBLER, FILLER IAW EO NR 02-039. TREATED, PRIMEDSDR ABXA020111Floorbeam · corrodedFORWARD CARGO TEE CHORD AT FS 70 WAS CORRODED BETWEEN LONGERON 29 LEFT - LONGERON 31 LEFT. FABRICATED REPAIR DOUBLER AND REPAIRED AREA IAW DC-8 SRM 51-1-27 AND REA D853-43935-MR.SDR SIMA200217305Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING. AFT DIGITAL HAS CORROSION. PERFORMED NDT INSPECTION AND FOUND NO DEFECTS. DIGITAL FOUND TO BE WITHIN EMB 145 SRM 53-21-10 LIMITS. (M)SDR 2002UALA01023Floorbeam · corrodedAFT PIT T-CAP CORRODED BODY STATION 1207 AND RBL 40. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM T-CAP.SDR 2002UALA01022Floorbeam · corrodedAFT PIT T-CAP CORRODED BODY STATION 1285, LBL 40. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM T-CAP.SDR 2002UALA01021Floorbeam · corrodedAFT PIT T-CAP CORRODED AT BODY STATION 1175, BL 0 TO RBL 40. MAJOR REPAIR ACCOMPLISHED. REPAIRED AND INSTALLED FLOORBEAM T-CAP.SDR 2002UALA01020Floorbeam · corrodedCABIN STATION 825-850, RBL 34, TRANSVERSE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. REPAIRED BEAM.SDR 2002UALA01019Floorbeam · corrodedAFT PIT FLOORBEAM T-CAP CORRODED BODY STATION 1241, RBL 44. MAJOR REPAIR ACCOMPLISHED. REPAIRED AND INSTALLED T-CAP.SDR 2002UALA01014Floorbeam · corrodedCABIN FLOORBEAM STATION 1640, RBL15-53R, WL208 CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED T-CAP.SDR 2002UALA01011Floorbeam · corrodedCABIN FLOORBEAM STATION 365, STRINGER 17R UPPER SURFACE OF UPPER I BEAM FLANGE HAD EXCESS MATERIAL REMOVED DURING CORROSION CLEANUP BETWEEN RBL 4 OUT TO RBL 60. MAJOR REPAIR ACCOMPLISHED. DOUBLER REPAIRED.SDR USAA020250Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED, STATION 967, RBL 29. FLOORBEAM UPPER CHORD REPAIR PER SRM 53-00-51. (M)SDR UPS02238800Floorbeam · corrodedINSPECTION TYPE:C+SI CORROSION ON FLOORBEAM AT BS 480 AT RBL 27.39. CORRODED FLANGES CUTOUT AT STA 480 RBL 27-31 AS CORROSION NOT ALLOWED AND AT RBL 35-39 IAW SRM 53-10-8. FLOORBEAM REPAIR IAW SRM 53-10-8 FIGURE 5.SDR MALA020396Floorbeam · corrodedDURING C-CHECK IN CVG, CORROSION WAS FOUND ON THE FRAME 18 FLOORBEAM BETWEEN SEAT RAILS 3 & 4. MAINTENANCE REPAIRED DAMAGE IAW RIL HC531H9486, BAE APPROVED FAX/BARA/AVR/5950/02-DC AND EO 53086.SDR 02FDEA00399Floorbeam · corrodedCORROSION ON UPPER FLANGE OF FLOORBEAM BS 1050, LBL 19, WL 208.SDR 2002UALA00998Floorbeam · corrodedCABIN FLOOR SUPPORT CORD HAD CORROSION ON UPPER FLANGE AT STATION 345 TO 365 BL 0 WL 208.10 MAJOR REPAIR ACCOMPLISHED. REMOVED T ANGLE CORD FROM BETWEEN STA 324 AND 417 DRILLED UP NEW PART AND INSTALLED.SDR AWXA200200534Floorbeam · corrodedYVR - MAJOR REPAIR - DURING C-15 CHK, CORROSION WAS FOUND ON FLOOR BEAM 987 IN THE CENTER OF THE CABIN AT BL 0 HAD CORROSION ON TOP SURFACE. FLOORBEAM REPAIRED IAW SRM 53-10-9 PAGE 7 FIG 2.SDR 2002UALA00997Floorbeam · gougedCABIN FLOOR STRUCTURE AT STATION 1200-1220 HAD DEEP GOUGES AT NUT CLIP HOLES, TO INNER CREASE BEAM AT 65 LBL STRINGER 17L. MAJOR REPAIR ACCOMPLISHED. FABRICATED REPLACEMENT AND INSTALLED WITH EXTERNAL SPLICE AT STA 1230 ONE L ANGLE AND L ANGLE WITH FLANGE.SDR 2002UALA00996Floorbeam · gougedCABIN FLOORBEAM UPPER SURFACE GOUGED NEXT TO GALLEY FITTING AT BODY STATION 807, RBL 29. MAJOR REPAIR ACCOMPLISHED. REMOVED AND REPLACED FLOORBEAM SPLICE DOUBLER.SDR C2XA02SH009Floorbeam · corrodedSHV- DURING C-CHECK INSPECTION, MULTIPLE AREAS OF CORROSION WERE FOUND ON THE LAV COMPARTMENT FLOORBEAM GUSSETTS. MAINTENANCE REMOVED AND REPLACED THE AFFECTED GUSSETTS IN ACCORDANCE WITH EMB-145 SRM 51-40-02, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVISDR PCAA0206063Floorbeam · crackedDURING ROUTINE MAINTENANCE VISIT NOSE GEAR FLOORBEAM AT STATION X97 FOUND CRACKED. CRACK WAS REPAIRED AT FUSELAGE FLOOR BEAM 85310380 AND NESTED DOUBLER IN ACCORDANCE WITH DER CAS AAL76 REVISION A AND DEHAVILLAND REPAIR DRAWING RD8-53-1336 ISSUE 5. AIRCRAFT SDR USAA020263Floorbeam · corrodedFLOORBEAM, 24 INCH CORRODED AREA. NO LEVEL OR TASK NR. STA 324, RBL 40-64. FABRICATED REPLACEMENT PER SRM AND EA.SDR 2002UALA00977Floorbeam · gougedMID-CABIN FLOORBEAM STA 880, LBL 49 TO 65, IS GOUGED AROUND CLIP NUT HOLES, FORWARD TOP SIDE AND AFT LOWER SURFACE RADIUS. MAJOR REPAIR ACCOMPLISHED. INSTALLED FREEZE PLUG AND STRAP REPAIR.SDR 02FDEA00398Floorbeam · corrodedCORROSION ON FLOORBEAM LWR FLANGE BS 900, LBL 54-68, WL 208 (C53-224-01, 2).SDR 2002UALA00990Floorbeam · corrodedCABIN FLOORBEAM UPPER SURFACE CORRODED AT BS 800-825, RBL 54. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM.SDR 2002UALA00987Floorbeam · corrodedBS 1300 LBL 40-44 T-CAP FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP REPAIRS.SDR 2002UALA00980Floorbeam · corrodedBS 852, LBL 34, FLOORBEAM CORRODED, MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM SECTION AND SPLICES.SDR 2002UALA00979Floorbeam · corrodedBS 830-870, RBL 11, WL 200, UPPER CHORD CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM REPAIR.SDR 2002UALA00978Floorbeam · crackedBS 786, LBL 12, FLOORBEAM CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW FLOORBEAM SECTION.SDR AWXA200200558Floorbeam · corrodedDURING C-16 CHECK CORROSION WAS FOUND OF FLOORBEAM UPPER FLANGE AT BS 312, RBL 8.5 TO RBL 12. MAINTENANCE BLENDED CORROSION AND FOUND MATERIAL LOSS TO EXCEED ALLOWABLE LIMITS, REMOVED DAMAGED FLOORBEAM UPPER TEE FROM EXISTING REPAIR SPLICE RBL 8.5 TO RBL 61.5,SDR AWXA200200545Floorbeam · corrodedDURING C-16 INSPECTION CORROSION WAS FOUND ON FLOORBEAM UPPER FLANGE AREA AT BS 294.5 LBL 11 TO LBL 14. MAINTENANCE REMOVED FLOORBEAM UPPER T-CHORD, FROM LBL 21.5 TO RBL 60,SDR AWXA200200532Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C-16 CHECK, CORROSION WAS FOUND ON FLOORBEAM UPPER FLANGE BS 328 RBL 22 TO RBL 30. MAINTENANCE REMOVED CORRODED FLOORBEAM UPPER T-CHORD BS 328 FROM RBL 5 TO 65. MADE REPAIR SECTION AND INSTALLED IAW B 737-300 SRM 53-10-51 PGS 220-SDR 02FDEA00391Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM BS 360, RBL 6. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8 FIG 3.SDR ASAA0210149Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 967, LEFT BUTTOCK LINE 18 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR SIMA200215901Floorbeam · corrodedABI - DURING AN IMBV INSPECTION MAINTENANCE, FOUND CORROSION ON GALLEY RIGHT FLOORBEAM. REMOVED CORRODED GALLEY RIGHT BEAM. INSTALLED NEW BEAM IAW EMB SRM 145/1142, CHAPTER 51, REV 18, 51-40-02, GST-1826/02, ITEM NR 1, AND STANDARD SRM PRACTICES. (M)SDR 2002UALA00964Floorbeam · gougedAFT CABIN FLOORBEAM GOUGED AT STATION 986 RBL 44 INCH. MAJOR REPAIR ACCOMPLISHED. INSTALLED STRAP REPAIR.SDR SIMA200215801Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND CORROSION ON GALLEY CENTER FLOORBEAM. REMOVED CORRODED GALLEY CENTER BEAM. INSTALLED NEW CENTER BEAM IAW EMB 145 SRM 145/1142, CHAPTER 51, REV 18, 51-40-02, ETN-EM53-020, AND STANDARD SRM PRACTICES. (M)SDR SIMA200215802Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND CORROSION ON LEFT OMEGA BEAM BETWEEN FRAMES 24 AND 25. REMOVED CORROSION BY CUT OUT. FABRICATED A DOUBLER ANGLE, TWO SHIMS. INSTALLED IAW EMB 145 SRM 145/1142, CHAPTER 53, REV 18, 53-21-10, AND STANDARD SRM PRACTICES. SDR 2002UALA00969Floorbeam · crackedSTA 246 MIDCHORD (FLOORBEAM) CRACKED AT LBL 38.5. MAJOR REPAIR ACCOMPLISHED. CRACKED MID CHORD REPAIRED PER 777 SRM 53-10-51.SDR 2002UALA00968Floorbeam · cracked246 MIDCHORD CRACKED AT RBL 38. MAJOR REPAIR ACCOMPLISHED. CRACKED MID CHORD REPAIRED PER 777 SRM 53-10-51.SDR 159PL0013Floorbeam · corrodedCORROSION ON STA328 FLOORBEAM AT RBL30SDR 159PL0010Floorbeam · corrodedCORROSION AT CLIP NUT HOLE IN FLOORBEAM AT LBL6 STA 344.SDR 159PL0005Floorbeam · corrodedCORROSION ON TOP OF 987 FLOORBEAM.SDR 159PL0003Beam · corrodedB.S.967 floor beam at RBL24 has corroded spot at fastener holeSDR 159PL0002Angle · crackedVertical chord cracked on aft side of BS 178 bulkhead B/B 5.7LSDR N159PL0001Angle · crackedVertical chord cracked on aft side of BS 178 bulkhead B/B 5.7LSDR 2002UALA00989Floorbeam · crackedBS 287 FLOORBEAM CRACKED, LEFT HAND SIDE. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR PARTS.SDR 2002UALA00972Floorbeam · crackedBS 287 FLOORBEAM CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR PARTS.SDR 2002UALA00970Floorbeam · corrodedBS 790, LBL 11, WL 200 TOP OF FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR PARTS AND SPLICES.
Back to JASC 5315