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 SWAA105895Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 706, LBL 45.5. REPAIRED WEB PER EA.SDR SWAA105891Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM VERTICAL WEB CRACKED AT BS 708.5, RBL 24.5. REPAIRED WEB PER EA.SDR SWAA105868Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.5. REPAIRED BEAM PER SWA EA.SDR DALA1025629868Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON MAIN CABIN FLOOR SUPPORT AT BS 160 LBL 1 TO LBL 6. REPAIRED IAW SRM 51-30-05.SDR USAA2010113092683Floorbeam · corrodedSAL - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, -Y1292 IAW A320 SRM 51-72-11.SDR USAA2010101592293Floorbeam · corrodedPIT - S1 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR66, S23L, Y1160. REPLACED FLOORBEAM AT FR66, S23L, Y1160 IAW A319 SRM 53-41-16 & EA 116312.SDR USAA2010101592292Floorbeam · corrodedPIT - S1 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOOR BEAM BETWEEN FR12 TO FR24, S23R, -Y1292. REPLACED FLOORBEAM BETWEEN FR12 TO FR24, S23R, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2010101592291Floorbeam · corrodedPIT - S1 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR68 TO FR70, -Y1160. REPLACED FLOORBEAM BETWEEN FR68 TO FR70, -Y1160 IAW A319 SRM 51-72-00.SDR DALA1027979865Floorbeam · damagedDURING M-CHECK FOUND DOUBLE DRILLED HOLE IN UPPER FLANGE OF FLOORBEAM AT BS 218 LBL 54. REPAIRED PER SRM 53-30-2, SRM 53-05 FIGURE 79A SHEET 1, SRM 51-10-3.SDR UALA2010100403664Bolt · shearedAT FLOORBEAMS EXPANSION JOINTS AFT OF F46, MOST LT BOLT FOUND SHEARED. REPLACED ALL 6 BOLTS, NDT JOINTS-NO CRACKS.SDR AALA20100930TUL17Strap · crackedFLOORBEAM STABILIZER STRAP CRACKED AT STATION 397.7 LEFT BUTTLINE 24. INSTALLED DOUBLER TO FLOORBEAM STABILIZER STRAP PER AARD 53-30-51-1.SDR USAA2010100192182Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - CORROSION ON UPPER SURFACE OF FLOORBEAM BETWEEN FR66 TO FR67, Y1292. REPLACED FLOORBEAM BETWEEN FR66 TO FR67, Y1292 IAW AIRBUS DRAWING 18D53473780.SDR USAA2010100192181Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - 5 AREAS OF CORROSION ON UPPER SURFACE OF FLOORBEAM BETWEEN FR67 TO FR68, Y1292. REPLACED FLOORBEAM BETWEEN FR67 TO FR68, Y1292 IAW AIRBUS DRAWING 18D53472780.SDR USAA2010100192180Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR68 + 10 INCHES, Y1292. REPLACED FLOORBEAM AT FR68 + 10 INCHES, Y1292 IAW AIRBUS DRAWING D5347425 & D53474200.SDR ASOA201001478Floorbeam · corrodedCORROSION OF FLOORBEAMS AFT OF SPLICE AT FS 570 LBL9 - RBL9, REPAIRED IAW REO 670-53-21-591.SDR SWAA105820Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 294.5, LBL 54. REPAIRED BEAM PER SRM.SDR SWAA105819Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 712, BBL 0.0. REPAIRED BEAM PER SRM.SDR SWAA105818Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, LBL 49. REPAIRED BEAM PER SRM.SDR SWAA105817Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, LBL 27. REPAIRED BEAM PER SRM.SDR SWAA105816Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, LBL 5. REPAIRED BEAM PER SRM.SDR SWAA105800Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CRACKED AT BS 947.5, LBL 51. REPAIRED BEAM PER EA.SDR SWAA105798Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 24.5. REPAIRED WEB PER EA.SDR SWAA105797Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 706, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA105796Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 665, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA105795Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 664, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA105793Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 668, RBL 24.5. REPAIRED BEAM PER EA.SDR SWAA105792Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 664, RBL 24.5. REPAIRED BEAM PER EA.SDR SWAA105791Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 672, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA105790Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 668, LBL 24.5. REPAIRED BEAM PER EA.SDR DALA1025009886Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOORBEAM AT BS 200 LBL 1 TO LBL 21. REPAIRED IAW SRM 51-10-3, SRM 53-01 FIGURE 1, SRM 51-30-5, SRM 51-10-2 & SRM 51-10-4.SDR DALA1024979865Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON MAIN CABIN FLOORBEAM AT BS 200 RBL 22 TO BL 0. REPAIRED IAW SRM 51-30-5 & DWG 9923484.SDR UHLA2010092800171Floorbeam · corrodedLEVEL 2 CORROSION RT FLOORBEAM BETWEEN FR 84 AND FR 85. REMOVED TOP SHEET ON RT FLOORBOARD IAW EMB 170 SRM 51-40-02, FABRICATED TOP SHEET AND INSTALLED.SDR FDEA201009283774Floorbeam · corrodedMAIN CARGO COMPARTMENT FLOORBEAM UPPER TEE HAS CORROSION BS 377 BLENED AREA IAW SRM 51-10-01. FOUND MUITIABLE AREA OUT OF LIMITS , EXCEEDS MAX OF 10% OF ORIG MAT IAW SRM 53-00-51 FIGURE 101 DETAIL III . REMOVED AND REPLACED UPPER TEE IAW SRM 51-10-01. ISDR ASAA1048324Floorbeam · corrodedSTA 947.5 FLOORBEAM HAS CORROSION AROUND FASTENER HOLES AT RBL 6. REPAIRED AFT FLANGE OF FLOORBEAM.SDR CALA2010092900460Floorbeam · damagedSUPPORT TASK, CABIN FLOORBEAM AT STA 377.7 BETWEEN LBL 26.5 AND LBL 42.75 SHOWS 5 ELONGATED NUT PLATE HOLES. REPAIRED DAMAGE CABIN FLOORBEAM AT STA 377.7 BETWEEN LBL 26.5 AND LBL 42.75 IAW SRM 53-00-51 REPAIR 1.SDR FDEA201009283773Floorbeam · corrodedMAIN CARGO COMPARTMENT FLOORBEAM UPPER TEE HAS CORROSION BS 363.25. BLENDED DAMAGED AREAS IAW SRM 51-10-01. AREAS OUT OF LIMITS IAW SRM 53-00-51, FIG.101, DETAIL 3. R & R UPPER TEE AT RBL 18-60, BS 363.25, IAW SRM 53-00-51, FIG 201, AND SRM 51-40-02. INSTSDR ASAA1048361Floorbeam · corrodedFLOOR FRAME STA 380 CORRODED ON TOPSIDE. REMOVED DAMGE AND INSTALLLED REPAIR PARTS.SDR ASOA201001460Floorbeam · corrodedCARGO BAY FLOORBEAM CAP AT LBL 27 OTBD FROM FS 574 TO FS 621 HAS CORROSION AROUND NUTPLATES.SDR ASOA201001459Floorbeam · crackedFOUND CRACK ON FLOORBEAM UPPER FLANGE LAST OTBD FASTENER HOLE AT FS 574.00 LBL 45. REPAIRED IAW REO 601R-53-61-3846.SDR AALA20100927TUL07Floorbeam · crackedCRACK BETWEEN UPPER BEAM CORD AND BEAM WEB OF THE EXTRUSION AT FLOOR BEAMS STATIONS 660 TO 700. FLANGE STATION 660 REPAIRED PER AARD 53-30-51-02 AND SRM 53-00-51-2R REPAIR 3. FLANGE STATION 700 FLOORBEAM REPAIRED PER SECTION 12 PATTERN CARD 53-98-01. MINOR SDR GTIA1000094Floorbeam · corrodedFLOORBEAM AT Y300 BETWEEN FR68 AND FR69 SHOWS SIGNS OF CORROSION.SDR GTIA1000092Floorbeam · corrodedLT FLOORBEAM AT FR68 HAS CORROSION.SDR GTIA1000091Floorbeam · corrodedLT FLOORBEAM AT FR67 HAS CORROSION.SDR GTIA1000090Floorbeam · corrodedFLOORBEAM AT Y-765 BETWEEN FR67 AND FR68 HAS CORROSION.SDR ASAA1048424Floorbeam · corrodedLT AND RT REPAIR SECTIONS ON T-CAP ARE CORRODED STA 986. REMOVED DAMAGE AND INSTALLED REPAIR PARTS.SDR DALA1026319865Floorbeam · crackedDURING M-CHECK FOUND CRACK IN MAIN CABIN FLOORBEAM SUPPORT FITTING AT BS 753, LBL 44. REPAIRED IAW SRM 51-30-2, SRM 51-30-4, SRM 51-10-3 & SRM 51-30-5.SDR FDEA201009263726Floorbeam · crackedFORWARD AVIONICS COMPARTMENT FLOORBEAM AREA FROM CABIN CENTER LOWER CHORD AT STA 392, RBL 15 FOUND CRACKED. HFEC INSPECTION CARRIED OUT AS PER NDT SPM REVISION 13 PART 06-10-01.001, RESULT NO CRACK EVIDENT.SDR FDEA201009263724Strap · crackedDURING FLOORBEAM REPLACEMENT AT BS 1661, FOUND STABILIZATION STRAP CRACKED AT FASTENER HOLES. CRACKED STABILIZATION STRAP AT BS 1661 REPAIRED AS PER E.A. F-5310-142338. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR SWAA105747Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, LBL 4.2. REPAIRED BEAM PER EA.SDR SWAA105746Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, LBL 4.8. REPAIRED BEAM PER EA.
Back to JASC 5315