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 SWAA100925Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 705 TO BS 715, LBL 24.5. REPAIRED BEAM PER AEM EO.SDR FDEA201002190475Floorbeam · damagedEXISTING FLOORBEAM REPAIR AT STA 1661 LBL 61-RBL 61 WILL INTERFERE WITH INSTALLATION OF 4EA MOD SEAT TRACKS. REMOVED/INTERFERING FLOORBEAM AT BS 1661, PER SRM 51-40-02, DUE TO INTERFERING WITH PTF MOD SEAT TRACK INSTALLATIONS (4EA.). REPLACED BS 1661 FLOOSDR FDEA201002190477Floorbeam · bentMDCC FLOORBEAM AT FR 65 BETWEEN SEATTRACKS 3L AND 4L IS BENT/ DISTORTED APPROX 18 " IN LONG X .08 DEFLECTION. REPAIRED FLOORBEAM AT FR 65 BETWEEN 3L AND 4L USING SPLICING METHOD IAW SRM 53-10-15, CONFIG 2, PG 27, FIG 3, SHEET 2 COMPLIED WITH REQUIRED OPS TEST SDR USAA2010022690454Floorbeam · corrodedCLT - C2 - MAJOR REPAIR - CORROSION ON FLOORBEAM FORWARD LOWER SURFACE AT BS 377.7 BETWEEN LBL 9.25 TO LBL 35.75. REPAIRED FLOORBEAM AT BS 377.7 BETWEEN LBL 9.25 TO LBL 35.75 IAW B757 SRM 53-00-51.SDR DALA103853225Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON FLOORBEAM AT -Y465 FR66. REPAIRED IAW SRM 51-42-11 & 51-23-11.SDR UIEA201000057Floorbeam · crackedFUSELAGE: BS 680, BL28-30 FLOORBEAM WEB CRACK REPAIR SRM 53-10-07, FIG 11, COMPLETED.SDR FDEA201002170444Floorbeam · corrodedAFT CARGO STATION 1070, BOTTOM OF FLOORBEAM, CORROSION AROUND SCREW HOLES. RBL 12-45. CUT OUT 2 DAMAGED AREAS IAW SRM 53-10-8 FIG 8. FABRICATED 2 REPAIR ANGLES AND 2 FILLERS IAW SRM 53-10-8 FIG 8. HEAT TREATED ANGLES TO T6 CONDITION IAW FASI ER 2-37153-801 RSDR FDEA201002170438Floorbeam · damagedELONGATED HOLE MAIN CABIN FLOOR BEAM BS 1110 LBL 45. CUT OUT DAMAGED AREA IAW SRM 53-10-8 FIG 8. FABRICATED 2 ANGLE REPAIRS. IAW SRM 53-10-8 FIG. 8. FABRICATED 2 SHIMS. IAW SRM 53-10-8. FABRICATED CHANNEL. FABRICATED FILLER IAW SRM 53-10-8, 51-10-3, AND 51-SDR SWAA100905Floorbeam · corrodedDURING SCHEDULED 26Y CHECK, FOUND AFT CARGO BAY FLOORBEAM CORRODED AT BS 858, BETWEEN LBL 3 TO LBL 8. REPAIRED BEAM PER EA.SDR SWAA100898Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 19. REPAIRED BEAM PER EA.SDR FDEA201002170443Floorbeam · damagedFLOORBEAM AT FR 64 BETWEEN SEAT TRACKS 3L AND 4L IS BENT/DISTORTED APPROX 18 IN LENGTH X .05 IN DEFLECTION. REPAIRED FR 64 CROSSBEAM USING SPLICING METHOD IAW FREIGHTER SRM 53-10-15, FIG 207, SHT 41.SDR AALA20100226TUL07Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 986.5 BETWEEN RIGHT BUTTLINES 40 AND 45. INSTALLED DOUBLER REPAIR PER AARD 53-00-00-7 AND SRM 53-00-51-2R.SDR 2010FA0000372Floorbeam · cracked(KADY) CRACK WAS FOUND ON THE WEB OF THE UPPER DECK FLOORBEAM AT STA 340 RT SIDE.SDR 2010FA0000364Floorbeam · cracked(KADY) CRACK WAS FOUND ON THE WEB OF THE UPPER DECK FLOORBEAM AT STA 340 RT SIDE.SDR FDEA201002160539Floorbeam · corrodedCORROSION FLOORBEAM MAIN CABIN BS 560, LBL10 CUT-OUT DAMAGED AREA IAW SRM 53-10-8 FIG 3, FABRICATED CHORD FAB 2 EA SUPPORT ANGLES, FAB 2 EA REINFORCEMENT STRAP IAW SRM 53-10-8 FIG REV 102, INSTALLED FLOORBEAM REPAIR AT BS 560 LBL 10 IAW SRM 51-30-2 REV 102.SDR USAA2010022290422Floorbeam · crackedCLT - MAJOR REPAIR - Q5 CHECK - CRACKED FLOORBEAM AT BS 698 - BS 717, BL 0. REPAIRED FLOORBEAM AT BS 698 - BS 717 BL 0 IAW TASK CARD M2C57002.SDR SWAA100895Floorbeam · corrodedDURING SCHEDULED 26Y CHECK, FOUND AFT CARGO BAY BEAM CORRODED AT BS 858, BETWEEN LBL 1 TO RBL 13. REPAIRED BEAM PER EA.SDR USAA2010031590585Floorbeam · corrodedSAL - S2 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR12 TO FR24, Y254. REPLACED FLOORBEAM BETWEEN FR12 TO FR24, Y254 IAW A320 SRM 51-72-11.SDR USAA2010022390436Floorbeam · crackedMCN - C4 - MAJOR REPAIR - CRACKS ON MAIN DECK FLOORBEAM AT BS 700, RBL 24.75 & BS 700, RBL 45.5. REPAIRED MAIN DECK FLOORBEAM AT BS 700, RBL 24.75 & BS 700, RBL 45.5 IAW B757 SRM 53-00-51.SDR WX0A070527Floorbeam · corrodedCABIN FLOORBEAM UPPER FLANGE UPPER AND LOWER SURFACES HAS CORROSION AROUND SCREW HOLES, FS 1079, LBL 21 - RBL 21. REMOVED FLOORBEAM UPPER FLANGE, FABRICATED NEW PART FROM EXTRUSION P/N S2929169 AND INSTALLED IT PER MD 80 51-30-5.SDR USAA2010021990413Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM UPPER CHORD AT BS 1581, LBL 28. REPAIRED FLOORBEAM UPPER CHORD AT BS 1581, LBL 28 IAW B767 SRM 53-00-51, 53-06-51 REPAIR 1, 51-40-02 &51-21-01.SDR IPXA10658559Floorbeam · crackedINSPECTION TYPE:6C, BULK CARGO LT STA 1417 LBL 8" FLOOR SUPPORT RIVET HOLE FOUND CRACK. BULK CARGO LT STA 1417 LBL 8" FLOOR SUPPORT REPLACED IAW SRM 51-10-02 AND INSTALLED IAW SRM 51-40-02 REV 46.SDR ASOA201000258Floorbeam · crackedWHILE REPLACING THE CARGO FLOOR FILLPLATE ON THE LT SIDE FS 564-621, FOUND THE FS 605 FLOORBEAM TO BE CRACKED, DENTED, GOUGED AND THE HOLE IS ELONGATED AT LBL42. THE DAMAGE IS ALL AROUND ONE HOLE. REPAIR TO TRAVERSE BEAM COMPLETED IAW REO 601R-53-61-3542 ANDSDR ASOA201000257Floorbeam · crackedFS 484.00 RBL 27 OTBD FLOOR SUPPORT ANGLE CRACKED PREVIOUS REPAIRED ANGLE. REPAIR TO THE INTERCOSTAL AT FS 484 BETWEEN BL 27.00 AND BL 36.00 IS COMPLETED IAW REO 601R-53-41-059 AND MEETS WITH ALL THEIR REQUIREMENTS.SDR ASOA201000246Floorbeam · crackedRT FS621 FLOOR SUPPORT ANGLE PREVIOUS REPAIR IS CRACKED. REPAIR OF THE DAMAGED PORTIONS OF ANGLE 601R35031-239 IS COMPLETED IAW REO 601R-53-61-117 & MEETS WITH ALL ITS REQUIREMENTS.SDR QXEA2010021800089Floorbeam · corrodedC-CHECK -FLOORBEAM ANGLE ON FWD SIDE OF 280.0 IS CORRODED. REMOVED FLOORBEAM ANGLE IAW SRM 51-42-06-001-001-A01. INSTALLED NEW ANGLE IAW SRM 51-42-21-001-001-A01. INSTALLED NEW NUTPLATES USING CR3214-4 FASTENERS, ALL WORK IAW SRM 51-42-13-001-001-A01. APPLSDR QXEA2010021800088Floorbeam · corrodedC-CHECK -SURFACE CORROSION FOUND ON TOP FLANGE OF FS 280.0 BEAM. BLENDED SURFACE CORROSION, REMOVED .002" MATERIAL IAW SRM 53-21-43-101-001-A01. TREATED, PRIMED AND PAINTED IAW SRM 51-21-11-001-001-A01, 51-25-06-001-001-A01, 51-25-06-001-001-A01. APPLIED CSDR SWAA100865Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 986.5 TO BS 987, LBL 41 TO RBL 42. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA100823Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT FLOOR BEAM T-CAP CORRODED AT BS 986.5, LBL 14. REMOVED AND REPLACED T-CAP PER SRM.SDR SWAA100822Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND AFT FLOORBEAM T-CAP CORRODED AT BS 987, RBL 31. REMOVED AND REPLACED T-CAP PER SRM.SDR FDEA201002150431Floorbeam · corrodedFWD LAV AREA - CORROSION ON FLOOR SUPPORT ANGLE AT BS 328 FROM BL 0 TO LBL 55, UPPER AND LOWER SURFACES. CUT OUT DAMAGED AREA APPROX DIM 2" IAW SRM 53-10-8 FIG 9. FABRICATED REPAIR FLOORBEAM. FABRICATED ANGLES 2. FABRICATED 2 ANGLES IAW SRM 53-10-8 FIG 9. SDR V0XR201002150003Floorbeam · corrodedRT CROSSBEAM AT FRM 16 BETWEEN Y.0.0 AND RY 479 IS CORRODED BEYOND LIMITS ON THE TOP EDGE OF THE ANGLE. R & R BEAM.SDR USAA2010021990414Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM UPPER CHORD AT BS 1480, LBL 28. REPAIRED FLOORBEAM UPPER CHORD AT BS 1480, LBL 28 IAW B767 SRM 53-00-51, 51-40-02 & 51-20-01.SDR ASOA201000222Floorbeam · corrodedFS 280 COCKPIT FLOORBEAM IS CORRODED BEYOND LIMITS IAW SRM 53-00-00-101-001-A01. REMOVE COCKPIT FLOOR SUPPORT IAW CRJ7/9 51-42-06-001-001-A01, 51-42-22-001-001-A01 AND 51-42-21-001-001-A01. DRILLED UP NEW COCKPIT FLOOR SUPPORT IAW SRM 51-40-11-001-001-A01. ISDR ASOA201000221Floorbeam · corrodedFS 280 FLOORBEAM AT APPROX LBL 11.0 TO 12.0 IS EXFOLIATED. REMOVED FLOORBEAM PER SRM 51-42-06-001-001-A01, 51-42-13-001-001-A01, & 51-42-21-001-001-A01. FABRICATED NEW SPLICE PER REO 670-53-11-047 REV E. DRILLED NEW FLOORBEAM PER SRM 51-40-11-001-001-A01. SDR SWAA100810Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 709, RBL 24.5. REPAIRED BEAM PER ER.SDR SWAA100809Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BETWEEN LBL 5 TO RBL 45. REPAIRED BEAM PER ER.SDR F3LA2010021700343Floorbeam · corrodedDURING C4 S1 C CHECK INSPECTION, NOTED CORROSION ON FLOOR PROFILE AT FRAME 58 IN AFT PIT. MAINTENANCE REMOVED AND REPLACED PROFILE IAW SRM 51-42-11.SDR R61A20100075Floorbeam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON RT FLOORBEAM AT FR 17. MAINTENANCE REMOVED AND REPLACED FLOORBEAM PER EMB SRM. AC STILL OUT OF SERVICE FOR HEAVY CHECK INSPECTION.SDR R61A20100074Floorbeam · corrodedWHILE AC WAS IN FOR HEAVY CHECK, LEVEL TWO CORROSION WAS FOUND ON CENTER LT FLOORBEAM AT FR 17. MAINTENANCE REQUESTED ENGINEERING SUPPORT FROM EMB AND RECEIVED ETD2010-170/01078. MAINTENANCE REPAIRED PER ETD. AC STILL OUT OF SERVICE FOR HEAVY CHECK INSPECTISDR A6WA201040122Floorbeam · cracked280 AFT FLOOR SUPPORT ANGLE CRACKED LBL 9 REPAIRED IAW REO 601R-53-11-138.SDR FDEA201002120418Floorbeam · corrodedAFT CARGO, BL 0 FLOORBEAM REPAIR, SCREW HOLES CORRODED, 3EA AT RBL5, STA 1070. REMOVED FLOORBEAM REPAIR LOWER STRAP IAW SRM 51-30-2. FABRICATED NEW STRAP IAW SRM 53-10-8 FIG 2. TREATED AND PRIMED NEW STRAP IAW SRM 51-10-2 INSTALLED NEW STRAP IAW SRM 53-10-SDR ASOA201000217Floorbeam · crackedFLOORBEAM AT FS 280 & LBL9 HAS A 2" CRACK.SDR A6WA201040222Floorbeam · crackedMWC 51552-2000-0130 FS 280 FLOOR SUPPORT CRACKED AT RBL 9. COMPLIED WITH REO 601R-53-11-1842.SDR A6WA201040120Floorbeam · crackedFS280, RBL 9 INBD CLIP CRACKED. REMOVED DAMAGED CLIP, DUPLICATED PART AND INSTALLED NEW SERVICEABLE CLIP.SDR DL738100360Floorbeam · corrodedREMOVED AFT CARGO FLOOR PANEL FOR MAINT. AFTER REMOVAL OF PANEL FOUND CORROSION ON FLOORBEAM. UNDER PANEL 2 FT AFT OF C2 DOOR 260446. REMOVED TEE EXTRUSION AT AFT CARGO BIN STA 887.485961. FABRICATED NEW SEAM STRIP AND REINSTALLED .303452.SDR IPXA10658616Floorbeam · crackedINSPECTION TYPE:C, MEC CABIN FLOOR SUPPORT BEAM STA246 RBL10" FWD CLIP FOUND CRACKED. MEC CABIN FLOOR SUPPORT BEAM STA246 RBL10" FWD CLIP REPLACED IAW SRM 51-10-02 AND INSTALLED IAW SRM 51-40-02, REV 46.SDR IPXA10658558Floorbeam · crackedINSPECTION TYPE:6C, MEC CABIN FLOOR SUPPORT BEAM STA246 LBL50" AFT CLIP FOUND CRACKED. MEC CABIN FLOOR SUPPORT BEAM STA 246 LBL 50" AFT CLIP REPLACED IAW SRM 51-10-02 AND INSTALLED IAW SRM 51-40-02 REV.46.SDR DALA103503225Floorbeam · corrodedDURING "H" CHECK FOUND FLOORBEAM, Y765 AT FR66 CORRODED. INSTALLED FLOORBEAM SPLICE. WORK ACCOMPLISHED IAW SRM 53-41-15, SRM 51-42-11, AND SRM 51-44-11.SDR C77A235118Floorbeam · corrodedDURING BASIC CHECK INSP MX VISIT CORROSION WAS FOUND ON FLOORBEAM PN 170-21766-409. PERMANENT REPAIR WAS MADE IAW ETD 2010-170/00794 AND COMPASS EO E175-53MR-023.
Back to JASC 5315