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 SWAA101516Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 670, RBL 24.5. REPAIRED BEAM PER AAR EA.SDR SWAA101515Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 666, LBL 24.5. REPAIRED BEAM PER AAR EA.SDR CALA2010031600082Floorbeam · corrodedSUPPORT TASK - CABIN STA, 1320 LBL 24.75 REF UNDER SEAT TRACK- FLOORBEAM HAS CORROSION ON TOP FLANGE. COMPLIED WITH ECRA 5321-01719, REPAIRED BS 1320, LBL 15-35 FLOORBEAM CORROSION.SDR DALA105523264Floorbeam · corrodedDURING "M" CHECK FOUND CORROSION ON FLOOR SUPPORT BEAM AT -Y189 FR 20. REPAIRED IAW SRM 51-42-11.SDR ASAA1047611Strap · corrodedFLOORBEAM RBL 24 BETWEEN STA 1006 1025. REMOVED DAMAGED STRAP, FABRICATED AND INSTALLED NEW STRAP.SDR AALA20100311TUL06Floorbeam · crackedCRACK IN FLOORBEAM STATION 700 LEFT BUTTLINE 24 AND LEFT BUTTLINE 48. INSTALLED DOUBLER PER AARD 53-30-51-2 REPAIR 2 AND CARD 53-98-01.SDR SWAA101480Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.5. REPAIRED BEAM PER AEM EA.SDR DALA105509872Floorbeam · damagedDURING "H" CHECK FOUND 3 DOUBLE DRILLED HOLES ON FLOOR SUPPORT AT BS 160 RBL 44. REPAIRED PER SRM 53-13-1, SRM 51-70-5.SDR FDEA201003100876Floorbeam · corrodedSTA 365 RBL 0-18 HAS EXISTING REPAIR THAT INTERFERS WITH MOD CARD 1183650461AZ2R05 INSTALL, ALSO FOUND CORRODED OUT OF LIMITS LBL 58. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DETAIL 3; ORIGINAL THICKNESS=.125' / AFTER REWORK=.092SDR FDEA201003100874Floorbeam · corrodedFLOORBEAM HAS CORROSION AT STA 345 LBL 12 TO 17. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51. FIG 101, DET III. FABRICATED UPPER T-CHORD MAT BAC 1505-100880, REPAIR ANGLES MAE TRAV NR T10/824058, AND REPAIR STRAPS MAE TRAV NR T10/8240SDR FDEA201003100738Floorbeam · damagedDECK FLOORBEAM TOP FLANGE BS 780 HAS ELONGATED HOLE LBL 24.5. COMPLIED WITH EA F-5310- 131582. REF FORM 8110-3, DATED MAR 25, 2010. MAJOR REPAIR.SDR DLM88100786Floorbeam · corrodedMAIN PASS CABIN STA 241 LBL42 FLOOR SUPPORT CORRODED/ FABRICATED NEW FRAME SECTION USING EXT S2929169 IAW SRM 53-01 AND 51-10-03.SDR SWAA101434Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 668, RBL 24. REPAIRED BEAM PER ER.SDR SWAA101433Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 657 TO BS 669, LBL 24. REPAIRED BEAM PER ER.SDR SWAA101431Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 24.5. REPAIRED WEB PER ER.SDR SWAA101392Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CRACKED AT BS 727B, RBL 24.5. REPAIRED BEAM PER AEM EO.SDR SWAA101380Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, RBL 48. REPAIRED BEAM PER SRM.SDR SWAA101378Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD AFT END CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER ER.SDR SWAA101376Floorbeam · corrodedDURING SCHEDULED 14Y CHECK, FOUND AFT GALLEY AREA, FLOORBEAM UPPER T-CAP CORRODED AT BS 986.5, RBL 43. REPAIRED T-CAP PER SRM.SDR SWAA101357Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 770, LBL 17.24. REPAIRED BEAM PER EA.SDR SWAA101341Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 770, LBL 8.1. REPAIRED BEAM PER EA.SDR SWAA101340Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 770, LBL 3. REPAIRED BEAM PER EA.SDR SWAA101339Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 770, RBL 8.1. REPAIRED BEAM PER EA.SDR SWAA101338Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 770, RBL 3. REPAIRED BEAM PER EA.SDR SWAA101311Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED CHORD PER AEM EO.SDR SWAA101297Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, BETWEEN RBL 2 TO RBL 62. REPAIRED BEAM PER EA.SDR DALA104963307Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON RT FLOOR STRUCTURE FROM FR75-FR77. REPAIRED PER SRM 51-42-11.SDR DALA105079872Floorbeam · damagedDURING "H" CHECK FOUND FLOOR SUPPORT AT BS160 RBL1 TO RBL44 HAS DOUBLE DRILLED HOLE. REPLACED FLOOR SUPPORT PER SRM 51-11 AND 51-30-5.SDR DALA105059872Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON FLOOR SUPPORT AT BS 160 LBL 1-LBL 8, REPAIRED PER SRM 53-13-01, 51-30-1.SDR DALA104953307Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON LT FLOOR STRUCTURE AT FR73-FR74 YC. REPAIRED PER SRM 51-42-11.SDR DALA104943307Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON LT FLOOR STRUCTURE FROM FR73-FR74 YA TO YB. REPAIRED PER SRM 51-42-11.SDR USAA2010031290572Floorbeam · corrodedPIT - C11 - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR65 TO FR69 & BETWEEN Y1292 TO Y1160. REPLACED FLOORBEAM BETWEEN FR65 TO FR69 & BETWEEN Y1292 TO Y1160 IAW A321 SRM 53-41-14.SDR USAA2010031290571Floorbeam · corrodedPIT - C11 - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR65 TO FR69 & BETWEEN Y1292 TO Y1160. REPLACED FLOORBEAM BETWEEN FR65 TO FR69 & BETWEEN Y1292 TO Y1160 IAW A321 SRM 53-41-14.SDR USAA2010031290565Floorbeam · corrodedPIT - C11 - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR65 TO FR69 & BETWEEN Y1292 TO Y1160. REPLACED FLOORBEAM BETWEEN FR65 TO FR69 & BETWEEN Y1292 TO Y1160 IAW A321 SRM 53-41-14.SDR USAA2010031290564Floorbeam · corrodedPIT - C11 - MAJOR REPAIR - CORROSION ON FLOORBEAM JUST FORWARD OF FR66, Y512.5. REPLACED FLOORBEAM AT FR66, Y512.5 IAW A321 SRM 53-41-14.SDR ASOA201000353Floorbeam · crackedFS 484 SUPPORT CLIP AT LBL 27 IS CRACKED. R & R FS 484 SUPPORT CLIP AT LBL 27 IAW SRM 51-42-21.SDR ASOA201000352Floorbeam · crackedFS 484 FLOOR CLIP AT RBL 27 IS CRACKED. R & R FS 484 FLOOR SUPPORT CLIP AT RBL 27 IAW SRM 51-42-21.SDR USAA2010030890526Floorbeam · corrodedPIT - C11 - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR68, Y765. REPLACED FLOORBEAM AT FR68, Y765 IAW A321 SRM 51-72-11.SDR USAA2010030590501Floorbeam · corrodedPIT - C11 - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR66 TO FR67, -Y464.8. REPLACED FLOORBEAM BETWEEN FR66 TO FR67, -Y464.8 IAW A321 SRM 53-40-14.SDR SWAA101252Angle · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM ANGLE CRACKED AT BS 639, RBL 45. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA101237Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 21. REPAIRED BEAM PER EA.SDR SWAA101236Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 39. REPAIRED BEAM PER EA.SDR USAA2010030490494Floorbeam · corrodedPIT - C11 - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR65 TO FR66 AT -Y317.9. REPLACED FLOORBEAM BETWEEN FR65 TO FR66 AT -Y317.9 IAW A321 SRM 53-41-04.SDR SWIA201023855Floorbeam · crackedFS 280 FLOORBEAM CRACKED AND CORRODED. (C CHECK) REPLACED PER REO.SDR USAA2010030490493Floorbeam · corrodedPIT - C11 - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR66 TO FR69 & BETWEEN -Y2192 TO -Y1165. REPLACED FLOORBEAM BETWEEN FR66 TO FR69 & BETWEEN -Y2192 TO -Y1165 IAW A321 SRM 53-41-14.SDR USAA2010030490492Floorbeam · corrodedPIT - C11 - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR66 TO FR69 & BETWEEN -Y2192 TO -Y1165. REPLACED FLOORBEAM BETWEEN FR66 TO FR69 & BETWEEN -Y2192 TO -Y1165 IAW A321 SRM 53-41-14.SDR AALA20100302TUL14Floorbeam · crackedSTATION 700 FLOORBEAM CRACKED AT LEFT BUTTLINE 24. PERFORMED INTERNAL DOUBLER REPAIRED PER AARD 53-30-51-2.SDR AALA20100302TUL10Floorbeam · crackedFLOORBEAM CRACKED AT STATION 700 LEFT BUTTLINE 48. REPAIRED PER WORKCARD 53-98-01 AND SRM 53-00-51-2R 3.SDR CALA2010030800061Floorbeam · corrodedAFT FLOORBEAM STA 1640 FROM LBL 4 TO RBL 4 HEAVY CORROSION. REPAIRED UPPER FLOORBEAM CAP REF SRM 53-00-51 REPAIR 3.SDR Q2S2010F00045Floorbeam · damagedWS 0784, WC SAI NR 4753119, HFEC OPEN HOLE FOUND 07 HOLES ELONGATED ON UPPER DECK FLOORBEAM AT BS 520, FROM RBL 0 TO RBL 35 FWD CHORD. DAMAGED UPPER CHORD TRIMMED OUT FORM LBL 54 TO RBL 54 IAW SRM 53-10-07, FIG 13, REV 116. HFEC INSP CARRIED OUT ON TRIMMED O
Back to JASC 5315