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 F3LA200700112Floorbeam · corrodedDURING C-3 CHECK, INSPECTION REPORTED AFT LT LONGITUDINAL BEAM Y1292 HAD SURFACE CORROSION IN FASTENER HOLES AND ON TOP SURFACE. REPLACED CORRODED FLOORBEAMS (P/N D5347217220400 AND D5347218820400) AND COUPLING JUST FWD OF FR67 THRU FR 69 IAW A318 SRM 53-41-1SDR 07FDEA01812Floorbeam · corrodedTOP CAP BEAM C38.2 CORRODED REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 07FDEA01807Floorbeam · crackedFWD CARGO COMP FLOORBEAM C38 HAS A CRACK BETWEEN SEAT TRACKS 4L AND 5L REMOVED FLOOR PNL 231VF TO BETWEEN FR 37-40 TO FOM REPAIR PER A310/200 SRM 51-40-12 REWORKED THE MILLED MERTRIAL STIFFENER TO REMOVE CRACK PER A310/200 SRM SUPPLEMENT 53-10-15 FIG 201 NDT SDR 07FDEA01805Floorbeam · crackedAFT CARGO PIT/CABIN FLOORBEAM 54.2 CRACKED RLL 2.5 FEET APPROX TOTAL CRACKED LENGTH .25 REPAIRED FLOORBEAM 54.2 PER FEDEX EA6-5310-110456 AND AIRBUS REPAIR DRAWING R53706311.SDR 07FDEA01803Floorbeam · crackedAFT CARGO PIT/CABIN FLOORBEAM 61 CRACKED AT APPROX 6 FEET RLL TOTAL CRACK LENGTH .30 APPROX COMPLIED WITH FEDEX EA6-5310-11460.SDR 07FDEA01800Floorbeam · crackedFWD CARGO COMP MDCC FLOORBEAM C23 HAS A CRACK BETWEEN SEAT TRACKS 2R AND 3R, CRACK LENGTH .125. FAB`D 2 REPAIR ANGLES PER A310/200 SRM SUPPLEMENT 53-10-15 ALODINED; PRIMED, TOP COATED PER SRM51-75-10; INSTALLED 2 REPAIR ANGLES PER SRM SUPPLEMENT 53-10-15.SDR 07FDEA01795Floorbeam · misrepairedPREVIOUS REPAIR LOCATED ON MAIN CABIN FLOORBEAM FRAME 60 BETWEEN SEAT TRACK 3 AND 4 LT, FWD AND AFT SIDES HAVE 2 EACH REPAIR ANGLES AND 2 EACH REPAIR STRAPS. THE FLOORBEAM HAS A NEW SECTION REPLACED ON THE LEFT SIDE PREVIOUSLY INSTALLED REPAIR FOUND NOT TO BESDR 07FDEA01794Floorbeam · misrepairedPREVIOUS REPAIR LOCATED ON AFT CARGO FLOORBEAM FRAME 63 JUST OUTBOARD OF LT AND RT NR 1 ROLLER TRACKS WITH 1 REPAIR SECTION MEASURING 31" LONG AND 4 EACH REPAIR ANGLES PREVIOUS REPAIR FOUND NOT TO BE IAW A310 SRM 53-10-15 FIG 207. REMOVED EXISTING FASTENERS ASDR 07FDEA01793Floorbeam · misrepairedPREVIOUS REPAIR LOCATED ON MAIN CABIN FLOORBEAM FRAME 55/58 BETWEEN SEAT TRACK 4 AND 5 RT, AFT UPPER FLANGE HAS 1 REPAIR ANGLE MEASURING 12.6" BY 2.6", ALSO THERE IS A REPAIR FILLER ON THE TOP SURFACE OF FLOORBEAM UNDER THE CLS ADAPTER MEASURING 14.3" BY 1" PRSDR 07FDEA01792Floorbeam · corrodedA 1/2" CRACK EXISTS AT FRAME 38 FLOORBEAM FWD FACE BETWEEN SEAT TRACK 4L AND 5L (VISIBLE FROM FWD CARGO OVERHEAD). REPAIRED CROSS BEAM AT FRAME 38 BETWEEN SEAT TRACK 4L AND 5L IAW A310 SRM 53-10-15 FIG 201 SHEET 6A.SDR A6WA200740250Floorbeam · crackedFS 280 FLOORBEAM CLIP AT OB SIDE OF LBL 9.0 IS CRACKED IN RADIUS APPROX .20 INCH LONG. (K) [07-17-07] MAINTENANCE REPLACED CLIP IAW BSC EO 601R-53-0057A. (M)SDR A6WA200740249Floorbeam · crackedFS280, FLOORBEAM CLIP AT IB SIDE OF LBL 9.0 IS CRACKED IN RADIUS APPROX. .20 INCH LONG. S/D - MAINTENANCE REPLACED CLIP IAW BSC EO 601R-53-0057A. (K)SDR A6WA200740248Floorbeam · crackedFS 280, FLOORBEAM CLIP AT IB SIDE OF RBL 9.0 IS CRACKED IN RADIUS APPROX .30 INCH LONG. S/D MAINTENANCE REPLACED CLIP IAW BSC EO 601R-57-0057A. (K)SDR A6WA200740247Floorbeam · crackedFS 280 FLOORBEAM CLIP AT OB SIDE OF RBL 9.0 IS CRACKED IN RADIUS APPROX .60 INCH LONG. (K) [07-17-07] MAINTENANCE REPLACED CLIP IAW BSC EO 601R-53-0057A. (M)SDR UPS07849836Floorbeam · corrodedINSPECTION TYPE:C2 FLOORBEAM STA 1300 RBL 12 HAS EXFOLIATION CORROSION BETWEEN FLOORBEAM AND FLOORBOARD. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR ANGLE AND FILLER. IAW SRM 51-1-8, 53-7-3 FIG 10, 51-2-1 FIG 1 SHT 7, TR 51-130 NOTE 19.SDR SIMA200714031Floorbeam · corrodedFOUND CORROSION AROUND A NUT PLATE ON THE RIGHT OMEGA BEAM. REMOVED CORROSION, PERFORMED NDT WITH NO REJECTABLE INDICATIONS. FABRICATED AND INSTALLED A DOUBLER IAW EMB SRM 53-21-10 AND 53-40-02. AIRCARFT RETURNED TO SERVICE.SDR ASAA0741633Floorbeam · corrodedFLOORBEAM CORRODED UPPER CHORD. REMOVED CORRODED SECTION OF UPPER CHORD FABRICATED AND INSTALLED REPLACEMENT CHORD ANGLES AND SHIMS IAW SRM 53-10-51.SDR USAA070383Floorbeam · corrodedSTA 947 RBL 4 HAS CORROSION. INSTALLED TEE CAP REPAIR PER EA 98634 & TYP REP 53-60-02; LEVEL 2; CORR TASK C53-107-01.SDR USAA070382Floorbeam · corrodedSTA 344 LBL 40 HAS CORROSION. INSTALLED NEW T-CAP SECTION PER SRM 53-10-01; CORR TASK C53-107-02; LEVEL 2, DEFECT SIZE: 1 X 1 INCH.SDR USAA070388Floorbeam · corrodedFLOORBEAM Y254 HAS CORROSION. REMOVED & REPLACED BEAM PER SRM 51-72-11; CORR TASK JA-220-53500, LEVEL 1, DEFECT SIZE: 2.5 X 3.5 INCHES.SDR COMAO760371Floorbeam · crackedDURING HMV7 INSPECTION FOUND FLOOR SUPPORT CHANNEL CRACKED AT LEFT CORNER FS 295, LBL 10. INSTALLED NEW P/N 600-34017-351 CHANNEL IAW SRM 51-42-06.SDR CALA0700242Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FLOORBOARD MOUNT HOLES, STA 967, S17L TO S17R. REPAIRED FLOORBEAM IAW SRM 53-00-51, FIGURE 201, PAGE 201.SDR CALA0700241Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, RBL 43-54. THE CORRODED SECTION OF FLOORBEAM WAS REPLACED IAW SRM 51-40-02.SDR CPCP20070054Floorbeam · corrodedFOUND FLOORBEAM AT FRAME 36 IS CORRODED. FLOORBEAM AT 36 REPLACED AS PER SRM 51-25-01 AND 51-25-04.SDR CPCP20070053Floorbeam · corrodedFOUND FLOORBEAM AT FRAME 40 IS CORRODED. NEW FLOORBEAM INSTALLED IAW SRM 51-25-01 AND 51-25-04.SDR CPCP20070052Floorbeam · corrodedFOUND FLOORBEAM AT FRAME 38 IS CORRODED. FLOORBEAM AT FRAME 38 REPLACED AS PER SRM 51-25-01.SDR SWIA200718381Floorbeam · crackedFS 280 FLOOR SUPPORT BEAM IS CRACKED AT RBL9, DISCOVERED AT C-CHECK. REPAIRED LOWER SUPPORT BEAM AND INBOARD OUTBOARD CLIPS AT FS 280 RBL9 PER CRJ200 REO 601R-53-11-171 REV "C".SDR SWIA200718380Floorbeam · crackedFS 280 FLOOR SUPPORT BEAM IS CRACKED AT LBL9, DISCOVERED AT C-CHECK. INSTALLED INBOARD AND OUTBOARD CLIPS AT LBL9 FS280 FLOOR SUPPORT AND REPAIR ANGLE PER CRJ200 REO 601R53-171 REV C.SDR SWAA072369Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 744A, RBL 25. REPAIRED FLOORBEAM PER SRM.SDR 07FDEA01737Floorbeam · crackedFWD CARGO COMP MDCC FLOORBEAM C33 HAS A CRACK BETWEEN SEAT TRACKS 4L AND 5L, CRACK LENGTH .125. REMOVED CRACK FROM FLOORBEAM PER SRM 53-10-15; FABBED 2 REPAIR ANGLES PER SRM 50-40-21; ALODINED, PRIMED, TOPCOATED PER SRM 51-75-10; INSTALLED REPAIR PARTS PER SSDR KNNA200700034Floorbeam · corrodedPASSENGER CABIN/CORRODED UPPER SURFACE ON FLOORBEAM BS 941.5 AND LBL-16 TO RBL-7ACO NR 075378 REV. 0 PROVIDE INSTRUCTION ON REPAIR OF FLOOR BEAM AT BS-947.5, LBL 36-RBL 12, SRM 53-10-9 FIGURE 9.SDR SIMA200714030Floorbeam · corrodedGALLEY FLOOR SUPPORT ANGLE AT FS272 CORRODED. CUTOUT CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW SAAB SRM 53-70-30. AIRCRAFT RETURNED TO SERVICE.SDR CALA0700238Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, RBL 32-34. A REPAIR STRAP WAS INSTALLED IAW SRM 53-00-51, FIGURE 201.SDR SWAA072318Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 294, LBL 13 TO RBL 12. REMOVED AND REPLACED FLOORBEAM CHORD PER SRM.SDR USAA070366Floorbeam · corrodedFLOORBEAM T-CAP AT BS 986.5, BL 0.0-BL 5 HAS CORROSION. FAB'D & INSTALLED FILLERS, ANGLES, STRAPS PER EA 98654, CORR LEVEL 2, DEFECT SIZE: 4 AREAS; 2 = 1" X .75" X .010" TO .025", AND 2 = 1" X 2" X .060".SDR SIMA200714037Floorbeam · corrodedGALLEY FLOOR SUPPORT ANGLE CORRODED AT FS 225. CUTOUT CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW SAAB REPAIR STATEMENT 340SDS012273. AIRCRAFT RETURNED TO SERVICE.SDR 200714304Floorbeam · corrodedAT STATION 280 FLOORBEAM FOUND CORROSION ALONG TOP FLANGE FROM BL 24L TO BL 42R. SPLICED IN FRAME 280 AND EXTENSION MOUNTS IAW AEA EO CR 53MR 119. RETURNED AIRCRAFT TO SERVICE.SDR AWXA200700592Floorbeam · corrodedSAL - CORROSION ON CABIN FLOORBEAM, FR 65 + 22", -Y1292. REPLACED CABIN FLOORBEAM, FR 64 - FR 66, -Y1292 IAW A319 SRM 51-72-11.SDR AWXA200700583Floorbeam · corrodedSAL - MAJOR REPAIR - BC-4 CHECK - CORROSION ON CABIN FLOORBEAM, FR 66 + 6 TO FR 67 + 16, -Y1292. REPLACED CABIN FLOORBEAM, FR 66 + 6 TO FR 67 + 16, -Y1292 IAW A320 SRM 51-72-11.SDR AWXA200700582Floorbeam · corrodedSAL - MAJOR REPAIR - BC-4 CHECK - CORROSION ON CABIN FLOORBEAM, FR 68 + 6 TO FR 69 + 4, -Y1162. REPLACED CABIN FLOORBEAM, FR 68 + 6 TO FR 69 + 4, -Y1162 IAW A320 SRM 51-72-11.SDR AWXA200700584Floorbeam · corrodedSAL - MAJOR REPAIR - BC-4 CHECK - CORROSION ON CABIN FLOORBEAM, FR 66 + 6 TO FR 67 + 16, +Y1162 TO +Y1292. REPLACED CABIN FLOORBEAM, FR 66 + 6 TO FR 67 + 16, +Y1162 TO +Y1292 IAW A320 SRM 51-72-11.SDR TRAX200700628Floorbeam · corrodedCORROSION ON FLOORBEAM BETWEEN FS 559.00 + 80 TO FS 559.00 + 112 RBL 27. [SUP 05-15-07] CORROSION ON FLOOR BEAM BTWN FS 559.00 + 80 TO FS 559.00 +112 RBL 27 REMOVED AS PER 51-21-06. ALODINED, PRIMED AND PAINTED AS PER SRM 51-21-11.SDR TRAX200700627Floorbeam · corrodedCORROSION ON FLOORBEAM BETWEEN FS 559.00 + 80 TO FS 559.00 + 112 RBL 9. [SUP 05-22-07] CORROSION ON FLOOR BEAM BTWN FS559.00+80 TO FS559.00+112 RBL 9 REMOVED IAW SRM 51-21-06. FOUND BEYOND LIMITS IAW SRM 53-51-43 FIG. 101. REPAIR PREFORMED IAW SRM 53-00-43SDR C1HA200795024Floorbeam · corrodedBS 1130 FLOORBEAM AT LOWER FORWARD FLANGE HAS CORROSION (RBL-10). FOUND CORROSION OUT LIMITS, CUT OUT DAMAGE, FABRICATED AND INSTALLED FILLERS, ANGLE, RADIUS FILLER AND STRAP REPAIRS TREATED AND PRIMED IAW B727 SRM 51-10-2, 53-10-1, 53-10-8 AND 51-30-2 FIG 1.SDR C1HA200795015Floorbeam · corrodedFOUND FLOORBEAM CORRODED AT STA 1110 LBL 25-45. REPAIRED FLOORBEAM STA 1110 FROM RBL 20 TO LBL 65 IAW B727 SRM 53-10-8 FIG 3.SDR A6WA200740237Floorbeam · crackedFOUND LEFT FS 621 FLOOR SUPPORT ANGLE IS CRACKED 1.25 INCH LONG IN OUTBOARD RADIUS. MAINTENANCE CUT OUT DAMAGED AREA AND INSTALLED REPAIR IAW BOMBARDIER REO 601R-53-61-117. (M)SDR A6WQA200740237Floorbeam · crackedLT FS 621.00 FLOOR SUPPORT ANGLE IS CRACKED 1.2500 INCH LONG IN OB RADIUS. (K)SDR A6WA200740236Floorbeam · crackedRT FS 621..00 FLOOR SUPPORT ANGLE IS CRACKED 1.2500 INCH LONG IN OB RADIUS. (K) [07-17-07] MAINTENANCE CUT AWAY DAMAGED AREA AND INSTALLED SERVICEABLE REPAIR IAW BOMBARDIER REO 601R-53-61-117. (M)SDR SIMA200714013Floorbeam · corrodedFLOORBEAM AT FRAME 258.0 CORRODED. CUTOUT CORROSION, FABRICATED AND INSTALLED NEW REPAIR PARTS IAW SAAB SRM 53-70-30. RETURNED AIRCARFT TO SERVICESDR AWXA200700585Floorbeam · corrodedSAL - MAJOR REPAIR - BC-4 CHECK - CORROSION ON CABIN FLOORBEAM, FR 68 + 6 TO FR 69 + 4, +Y1162. REPLACED CABIN FLOORBEAM, FR 68 + 6 TO FR 69 + 4, +Y1162 IAW A320 SRM 51-72-11.
Back to JASC 5315