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 07FDEA00936Floorbeam · corrodedAFT CARGO COMP FLOORBEAM AT C63 LT, Y 445 CORRODED. REPAIR WAS PERFORMED IAW SRM 53-10-15/FIG 207 BY LHT SDR.SDR KCSA071066Vertical Support · crackedAFT BILGE FLOORBEAM VERTICAL SUPPORT IS CRACKED AT STA 2000, RBL 49, AFT SIDE.SDR SWIA200718212Floorbeam · crackedFOUND COCKPIT FLOOR SUPPORT IS CRACKED AT FS 280, DISCOVERED AT C-CHECK. REPLACED COCKPIT FLOOR SUPPORT ANGLE P/N CC670-33292-9 IAW CRJ700 SRM 51-42-21-001-001-A01.SDR SWIA200718211Floorbeam · crackedSTATION 280 FLOOR SUPPORT BEAM CRACKED, DISCOVERED AT C-CHECK. REPLACED STATION 280 FLOORBEAM AND FLOORBEAM SUPPORT IAW REO 670-53-11-047 AND SB670BA-53-026 AND SRM 51-42-06-001-001-A01 AND REPLACED BRACKETS AT STATION 280 LBL 9.0 AND RBL 9.0 IAW SB670BA-53-0SDR UPS07849602Floorbeam · corrodedINSPECTION TYPE:C3 FLOORBEAM STA 1723 RBL 30 - RBL 15 HAS POPPED RIVETS AND EXFOLIATION CORROSION. REMOVED CORROSION AND REPAIRED FLOORBEAM AT STA 1723 RBL 30 - RBL 15 IAW SAA EA 008-5320-01-A0762, UPS RAA DC8-53-20617, AND FAA FORM 8100-9.SDR AWXA200700391Strap · crackedMCN - FOUND CRACKED LOWER FLOORBEAM STRAP, BS 312, RBL 46. REPAIRED LOWER FLOORBEAM STRAP, BS 312, RBL 46 IAW B737-300 SRM 51-70-11.SDR 2007UALA00782Floorbeam · damagedDOUBLE DRILLED FIGURE 8 HOLES ON FLOORBEAM UNDER CABIN FLOOR AT BS 654+22, RBL 66 TO RBL 77, 2 PLACES. MAJOR REPAIR ACCOMPLISHED: FABRICATED AND INSTALLED 2 EACH FREEZE PLUGS AND REPAIR STRAPS.SDR 2007UALA00781Floorbeam · damagedELONGATED HOLE ON FLOORBEAM AT BS 654+88, RBL 77.0. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED SECTION OF UPPER CHORD FLANGE. FABRICATED & INSTALLED CHORD ANGLE AND SPLICE STRAPS.SDR 07FDEA00916Floorbeam · crackedFLIGHT DECK FLOOR SUPPORT CHANNEL IS CRACKED ON TOP OF CHANNEL LOCATED AT BS 285, LBL 6.5. INSTALLED NEW SUPPORT CHANNEL PER SRM 51-30-2 PG 2. CLASSIFIED AS A MAJOR REPAIR.SDR 07FDEA00905Floorbeam · misrepairedMDCC - FLOORBEAM FRAME 36 CRACKED (PREVIOUS REPAIR NOT PER SRM). REWORKED PREVIOUS REPAIR IAW EA 6-5321-29042.SDR 07FDEA00883Floorbeam · maint errorMISDRILLED HOLE IN THE FLOOR STRUCTURE OF FWD CARGO COMPARTMENT C22 RT. REPAIR WAS PERFORMED IAW EA 6-5313-103406 AND RAS/DABRE/7007121/2006 ISSUE "A". REPAIR ANGLE INSTALLED.SDR 07FDEA00879Floorbeam · corrodedFOUND TOP CAP BEAM C25 AD UPPER FLANGE A537-73651-210 CORRODED. REPAIR WAS PERFORMED IAW SRM 53-10-15/FIG 207.SDR 07FDEA00873Floorbeam · crackedFOUND CRACK FR 38 PROFILE MDCC FLOORBEAM LT FWD CARGO COMPARTMENT BETWEEN SEAT TRACKS L-4 & L-5, REF SRM 53-10-00 AND SRM 53-10-15. REPAIRED FR 38 MDCC FLOORBEAM BETWEEN SEATRACKS L-4 AND L-5 IAW A310-200 SRM 53-10-15, FIG 201, SHT 6A.SDR KCSA071065Floorbeam · puncturedMAIN DECK FLOORBEAM WEB IS PUNCTURED AT STA 180, LBL 49, WL 195.SDR USAA070204Floorbeam · crackedSTA 328 LBL 45, FLOORBEAM SUPPORT CRACKED. INSTALLED FABRICATED REPAIR PARTS PER SRM 53-15-01, BOEING DWG 65C33942, DEFECT SIZE: 2 INCHES.SDR USAA070203Floorbeam · crackedSTA 328 LBL 45 FWD SIDE OF FLOORBEAM, FLOORBEAM SUPPORT CRACKED. REMOVED DAMAGE & INSTALLED FABRICATED REPAIR PARTS PER SRM 53-15-01, BOEING DWG 65C33942, DEFECT SIZE: 2 INCHES.SDR KNNA200700022Floorbeam · corrodedFLOOR PANEL ATTACH POINT STA 344, LBL 12 IS CORRODED. PROVIDE INSTRUCTIONS ON REPAIR OF STA 344, LBL 12 FLOOR PANEL ATTACH POINT. REMOVED AND REPLACED FLOORBEAM SRM 53-10-9 FIG 6.SDR SIMA200707809Floorbeam · corrodedLT OMEGA BEAM CORRODED AT FRAME 27. PERFORMED A CUTOUT TO REMOVE CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW IC2007-145/01665, DATED 03-08-07. RETURNED AIRCRAFT TO SERVICESDR SIMA200707810Floorbeam · corrodedCENTER OMEGA BEAM WAS FOUND CORRODED AT FRAME 25. PERFORMED CUTOUT TO REMOVE CORROSION, FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.SDR TRAX200700353Floorbeam · corrodedCORROSION ON FLOORBOARD SUPPORT ANGLE AT FS 280.00 IN AVIONICS CRAWLWAY.SDR SWAA071392Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 65 TO RBL 65. REPAIRED FLOORBEAM PER ER.SDR 07FDEA00845Floorbeam · misrepairedPREVIOUS REPAIR ON CABIN FLOORBEAM FRAME 37 REPAIR ANGLES IMPROPERLY INSTALLED. CORRECTED REPAIR IAW EA 6-5310-107701.SDR 07FDEA00836Floorbeam · crackedDURING ACF MODIFICATION, FOUND TO FWD CARGO COMPARTMENT BILGE STA 1090 FLOORBEAM WITH CRACK 2" LONG. REPLACE FLOORBEAM FOR SRM 51-31-01 VOIL II P/N AFA0039-5N E TEE ADA3645-15.SDR SWIA200718148Floorbeam · corrodedSTA 280 FORWARD FLOOR SUPPORT ANGLE SHOWS EVIDENCE OF CORROSION, DISCOVERED AT C-CHECK. REPLACED FLOOR SUPPORT ANGLE AND INBOARD AND OUTBOARD ENDS OF ANGLE P/N 600-34017-21 IAW CRJ200 SRM CH 51-42-06 PG 11 PARA 9.SDR SWIA200718141Floorbeam · crackedRBL9 STATION 280 LOWER FLOOR SUPPORT IS CRACKED AT INBOARD AND OUTBOARD CLIPS, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLE ANGLE FILLER IAW CRJ200 REO 601R-53-11-171 STEP 6 AND 7. INSTALLED CLIPS AND FILLERS AT STATION 280 RBL 9.0 IAW CRJ200 REO 601R-53-11SDR SWIA200718140Floorbeam · crackedLBL AND RBL9 AT STATION 280 UPPER FLOOR SUPPORT CRACKED, DISCOVERED AT C-CHECK. INSTALLED NEW FORWARD STATION 280 FLOOR SUPPORT ANGLE P/N 600-34017-21 ALONG WITH SPLICE ANGLE AND FILLER ANGLE IAW CRJ200 REO 601R-53-11-136, REV NC.SDR SWIA200718139Floorbeam · crackedLBL9 STATION 280 LOWER FLOOR SUPPORT ANGLE IS CRACKED AT INBOARD AND OUTBOARD CLIPS, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLE AND ANGLE FILLER PER CRJ200 REO 601R-53-11-171 STEPS 6 AND 7. INSTALLED CLIPS STATION 280 LBL9.0 PER CRJ200 REO 601R-53-11-171 SDR SWAA071364Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 996, LBL 65 TO RBL 65. REPAIRED FLOORBEAM PER ER.SDR 07FDEA00782Floorbeam · corrodedFOUND CORROSION ON TOP CAP BEAM, UPPER FLANGE, C25 AD. REPAIR WAS PERFORMED IAW SRM 53-10-15, FIG 207 AND SRM 51-72-10.SDR DU4R2007071Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM UPPER CAP AT BS 1681 LBL 24. CUT OUT CORRODED AREAS. FABRICATED AND INSTALLED REPAIR DOUBLER 26.5 BY 2 FROM 2024-T3 .080 AND 3 FILLERS FROM 2024-T3 .071 IAW B757 SRM 53-60-51 FIG 201, 51-20-01.SDR 2007UALA00744Floorbeam · corrodedAFT GALLEY AREA, MAIN FLOORBEAM STA 1562, RBL 48 AREA, TOP BEAM FLANGE CORRODED AND BLEND OUT EXCEEDS LIMITS. MAJOR REPAIR ACCOMPLISHED: CUT-OUT DAMAGED AREA. FABRICATED & INSTALLED UPPER CHORD ANGLE SPLICE SECTION.SDR 2007UALA00743Floorbeam · corrodedRIGHT FWD MAIN CABIN FLOOR STRUCTURE, FLOORBEAM UPPER CHORD ON UPPER AND LOWER SURFACES CORRODED AROUND FASTENER HOLES IN MULTIPLE PLACES, BS 365.25, RBL 0 TO RBL 64. MAJOR REPAIR ACCOMPLISHED: RMV'D CORROSION. FABRICATED & INSTALLED REPAIR ANGLE & STRAP.SDR ASAA0771526Floorbeam · corrodedAFT CARGO PIT FLOORBEAM CORRODED AT BS 887. REPAIRED IAW SRM 53-60-53 FIG 2.SDR ASAA0771519Floorbeam · corrodedAFT CARGO CORROSION FOUND ON CARGO FLOORBEAM AT BS 767+4. REPAIRED IAW EA 5320 01793.SDR ASAA0771518Floorbeam · corrodedAFT CARGO CORROSION FOUND ON CARGO FLOORBEAM AT BS 767. REPAIRED IAW EA5320 01793.SDR ASAA0771517Floorbeam · corrodedAFT CARGO CORROSION FOUND ON CARGO FLOORBEAM AT BS 767.SDR ASAA0771516Floorbeam · corrodedAFT CARGO CORROSION FOUND ON CARGO FLOORBEAM AT BS 767+4. REPAIRED IAW EA 5320 01793.SDR ASAA0771515Floorbeam · corrodedAFT CARGO CORROSION FOUND ON CARGO FLOORBEAM AT BS 767. REPAIRED IAW EA 5320 01793.SDR SWAA071330Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 344, LBL 10. REPAIRED FLOORBEAM PER SRM.SDR WRLA2007046Floorbeam · brokenDURING C-04 CHECK, FOUND FLOORBEAM BULKHEAD BROKEN AT STA Y=1841 X=42. REPAIRED PER SRM VOL.III 53-16-01 REV.38 AND SRM 53-00-01 VOL.I FIG.10 REV.38SDR 2007UALA00722Floorbeam · corrodedRIGHT SIDE STA 280 FLOORBEAM HAS CORROSION AND BLEND-OUT EXCEEDS LIMITS. MAJOR REPAIR ACCOMPLISHED: REMOVED SECTION OF T-CAP. FABRICATED & INSTALLED NEW SECTION OF T-CAP CHORD.SDR 2007UALA00721Floorbeam · damagedAFT CABIN FLOORBEAM HAS TOOLING MARK 27 INCHES LONG DOWN CENTER OF T-CAP STA 947 LBL 12 RBL 15. MAJOR REPAIR ACCOMPLISHED: INSTALLED T-CAP SPLICE REPAIR.SDR KNNA200700021Floorbeam · crackedCARGO FLOORBEAM CRACKED AT BS 460, RBBL 14.5 FWD CARGO COMPARTMENT. PROVIDE INSTRUCTIONS ON REPAIR OF CARGO FLOORBEAM BS 460 RBL 14.5. REMOVED AND REPLACED CARGO DOOR FLOORBEAM SRM 53-10-5 FIGURE 11.SDR USAA070174Floorbeam · corrodedRIGHT FLOORBEAM TO FLANGE FROM FR 64-68; -Y1160 TO -Y1292 HAS CORROSION. REMOVED AND REPLACED FLOORBEAM PER SRM 51-72-11; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1 SQ INCH.SDR SIMA200707103Floorbeam · corrodedFOUND LEFT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 25. PERFORMED CUT OUT, FABRICATED AND INSTALLED REPAIRS PARTS IAW EMB SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.SDR USAA070170Floorbeam · corrodedRIGHT FLOORBEAM -Y1732 AT FR 66 AT NUT PLATE HOLE HAS CORROSION. INSTALLED NEW REPAIR ANGLES & FILLER PER SRM 53-41-14; CORR TASK JA-260-53500, LEVEL 1, DEFECT SIZE: 0.750 X 0.750 INCH.SDR USAA070171Floorbeam · corrodedSEVERAL AREAS, FLOORBEAM AT Y254 BETWEEN FR C14 & C23 HAS CORROSION. REMOVED & REPLACED BEAM PER SRM 51-72-11; CORR TASK JA-220-53500, DEFECT SIZE: 1 X 1 INCH.SDR USAA070172Floorbeam · corrodedFLOORBEAM AT Y505 HAS CORROSION. REMOVED & REPLACED BEAM PER SRM 51-72-11; CORR TASK JA-220-53500; LEVEL 1, DEFECT SIZE: 1 X 8 INCHES.SDR 07FDEA00713Floorbeam · crackedFWD CARGO COMPARTMENT UPPER FLAP AT BEAM/FLOOR OF CABIN FOUND CRACK AT FR 38 AND Y1700 REPAIRED PER SFEDEX EA 6-5310-106694. REPAIR EVALUATED PER GMM 6-2-100 AND CLASSIFIED AS "MAJOR".SDR 2007UALA00663Floorbeam · damagedCABIN FLOORBEAM EXFOLIATED, STA FRAME C21 TO C22, LBL 9 IN. [SUP 05-24-07] REMOVED AND REPAIRED DAMAGED AREA IN ACCORDANCE WITH SRM.
Back to JASC 5315