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 DALA1026856901Floorbeam · corrodedFLOORBEAM HAS UPPER FLANGE CORRODED AT STA 365 BETWEEN RBL 1 AND RBL 16 INCLUDING LBL 24. COMPLIED WITH ERA 485737-14 REV ORIGINAL DURING HMV AT ST AEROSPACE SAT ON NON ROUTINE CARD 179222 (DL75E102743).SDR CALA2010091700427Floorbeam · corrodedFLOORBEAM AT STA 986.5 RT SIDE HAS CORROSION AT FASTENER HOLE APPROX RBL 4.5 (MARKED). REMOVED DAMAGED SECTION OF FLOORBEAM, FAB'D REPAIR PIECES, TREATED, PRIMED AND INSTALLED IN REF TO SRM 53-00-51 REPAIR 1.SDR SWAA105401Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BS 694, BL 0. REPAIRED BEAM PER SRM.SDR SWAA105400Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 716, BL 0. REPAIRED WEB PER SI.SDR DALA1026806901Floorbeam · corrodedFLOORBEAM HAS UPPER CAP CORRODED AT STA 1640 BETWEEN BL 0 AND LBL 20 INCLUDING AREA AT LBL 58. REPAIRED UPPER FLOORBEAM DURING HMV AT ST AEROSPACE SAT ON NON ROUTINE CARD 179150 (DL75E102738).SDR USAA2010091491989Floorbeam · corrodedMIA - C20 - MAJOR REPAIR - CORROSION ON FLOORBEAM AT BS 328 BETWEEN RBL 26 TO RBL 36. REPAIRED FLOORBEAM AT BS 328 BETWEEN RBL 26 TO RBL 36 IAW B737 SRM 53-10-51, 53-30-51 & 53-00-51.SDR COEA2010090816803Floorbeam · corrodedWO#: 97861 NR#: 100085 / COE / HEAVY CHECK / LEVEL 2 CORROSION / FLOOR BEAM 15 UPPER FLANGE HAS AREAS OF BARE METAL AND IS CORRODED BETWEEN LT AND RT INBOARD SEAT TRACKS. WILL REQUIRE REPAIR IN ACCORDANCE WITH ATR 72 STRUCTURAL REPAIR MANUAL.SDR SWIA201024856Floorbeam · corrodedFS 280 FLOORBEAM CRACKED AND CORRODED. (C-CHECK) REPAIR PER REO.SDR FDEA201009083312Floorbeam · corrodedMAIN CARGO COMPARTMENT FLOORBEAM HAS CORROSION AND ELONGATED HOLES TOP SIDE AT STA 365. REMOVED CORROSION ON FLOORBEAM, STA 365, AND FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DETAIL III. ORIG MATERIAL .125 AFTER REWORK .023. R & R FLOORBEAM IAW SRSDR FDEA201009083311Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER CHORD CORRODED AT STA 377.5, LBL 38.5-45.5. REMOVED CORROSION FROM FLOORBEAM UPPER CHORD AT STA 377 BETWEEN LBL 20 AND LBL 58 IAW SRM 51-10-02. REMOVED .017 FROM .125 ORIGINAL THICKNESS. MATERIAL FOUND OUT OF LIMITS IAW SRM 53-00-5SDR GTIA1000080Floorbeam · corrodedSTATION Y1292 AT FR 67 HAS CORROSION.SDR GTIA1000079Floorbeam · corrodedSTATION Y1292 AT FR66 HAS CORROSIONSDR GTIA1000078Floorbeam · corrodedSTATION Y765 AT FR67,68,AND 69 HAS CORROSION.SDR GTIA1000077Floorbeam · corrodedSTATION Y765 AT FRAME 66 HAS CORROSION.SDR GTIA1000076Floorbeam · corrodedSTATION Y300 AT FRAME 68 HAS CORROSION.SDR GTIA1000075Floorbeam · corrodedSTATION Y254 ATFR68 HAS CORROSION.SDR GTIA1000074Floorbeam · corrodedSTATION Y765 AT FRAME 68 HAS CORROSION.SDR GTIA1000073Floorbeam · corrodedFLOORBEAM STA Y1292 AT FR68 HAS CORROSION.SDR GTIA1000072Floorbeam · corrodedFLOORBEAM STA Y1292 L Z BEAM AT FRAME 66 HAS CORROSION.SDR GTIA1000071Floorbeam · corrodedFLOORBEAM STA Y 1292 AT FRAME 66 HAS CORROSION.SDR GTIA1000070Floorbeam · corrodedSTA Y254 BETWEEN FRAMES 67 AND 68 HAS CORROSION.SDR IPXA10562884Floorbeam · corrodedINSPECTION TYPE:C3, LBL 25 TO BL 0 BS 1200 FLOORBEAM IS CORRODED. REPAIRED IAW ATS ER 10-4493, DATED 9-29-10.SDR IPXA10562883Floorbeam · corrodedINSPECTION TYPE:C3, LBL 53 TO LBL 48 BS 1200 FLOORBEAM IS CORRODED. REPAIRED IAW ATS ER 10-4493, DATED 9-29-10.SDR IPXA10562791Floorbeam · corrodedINSPECTION TYPE:C3, LBL 41, BS 1600 FLOORBEAM IS CORRODED. REPAIRED FLOORBEAM IAW SRM 51-10-02-G AND ER 10-4500SDR IPXA10562751Floorbeam · corrodedINSPECTION TYPE:C3, LATERAL FLOORBEAM UPPER CHORD SURFACE IS CORRODED AT BS 310, LBL 10, WL 208. REPAIRED IAW ATS ER-10-4474.SDR USAA2010092092044Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACKS ON LONGITUDINAL FLOORBEAM AT BS 667 & AT BS 671, LBL 24.8. REPAIRED LONGITUDINAL FLOORBEAM AT BS 667 & AT BS 671, LBL 24.8 IAW EA 102139.SDR USAA2010092092041Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON LONGITUDINAL FLOORBEAM BETWEEN BS 667 TO BS 671, RBL 24.5. REPAIRED LONGITUDINAL FLOORBEAM BETWEEN BS 667 TO BS 671, RBL 24.5 IAW EA 102140.SDR SWAA105351Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 25.8. REPAIRED BEAM PER EA.SDR SWAA105284Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 294.5, LBL 54. REPAIRED CHORD PER AEM.SDR SWAA105282Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 711.5, LBL 24.5. REPAIRED WEB PER AEM.SDR SWAA105281Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 707.5, LBL 24.5. REPAIRED WEB PER AEM.SDR SWAA105280Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 706.5, LBL 24.5. REPAIRED WEB PER AEM.SDR SWAA105278Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED CHORD PER EA.SDR IPXA10562904Floorbeam · corrodedINSPECTION TYPE:C3, BS 620, RBL 45 TO LBL 45 FLOORBEAM IS CORRODED. REPAIR IAW 10-4485.SDR IPXA10562891Floorbeam · corrodedINSPECTION TYPE:C3, BS879, RBL45 TO RBL 60 FLOORBEAM IS CORRODED. REPAIR IAW ATS ER 10-4496, DATED 9-30-10.SDR IPXA10562744Floorbeam · crackedINSPECTION TYPE:C3, BS 483, RBL 12 FLOOR SUPPORT IS CRACKED. REPLACED IAW DWG 284N1020, SRM 51-40-05, 51-40-02.SDR IPXA10562589Floorbeam · puncturedINSPECTION TYPE:C3, BS 900 LBL 25-45 FLOOR SUPPORT PUNCTURED. REMOVED, FABRICATED AND INSTALLED PLATE IAW SRM 51-40-02.SDR DALA1021449868Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT BS 237 LBL 1 TO LBL 20. REPAIRED IAW SRM 51-10-4, SRM 51-30-2.SDR SWIA201024995Floorbeam · corrodedFS 280.00 FLOORBEAM HAS CRACK AND CORROSION LT & RT SIDES. (C-CHECK) REPLACED FS 280 FLOORBEAM PER SRM.SDR UHLA2010090500147Floorbeam · corrodedLEVEL 2 CORROSION LEFT CENTER FLOORBEAM UPPER SHEET BETWEEN FRAMES 86 AND 87. REMOVED AND REPLACED LEFT CENTER FLOORBEAM UPPER SHEET IAW EMB 170 SRM 51-41-01.SDR UHLA2010090500145Floorbeam · corrodedMAJOR REPAIR - LEVEL 2 CORROSION AT FRAME 84 AT RIGHT CENTER FLOORBEAM ON UPPER SHEET. INSTALLED SERVICEABLE DOUBLER ASSY AND SERVICEABLE RT CENTER AFT SEAT TRACK BEAM ASSY PER EMB SRM 51-43-03 AND 51-43-04.SDR UHLA2010090500140Floorbeam · corrodedLEVEL 2 CORROSION LEFT CENTER FLOORBEAM UPPER SHEET BETWEEN FRAMES 85 AND 86. INSTALLED NEW UPPER SHEET STRAP ON LT CENTER FLOORBEAM BETWEEN FRAMES 85 AND 86 IAW EMB 170 SRM 53-23-03, 53-23-10, 51-21-01, 51-41-01, 51-43-01, 51-23-06.SDR UHLA2010090500138Floorbeam · corrodedLEVEL 2 CORROSION RIGHT CENTER FLOORBEAM BETWEEN FRAMES 89 AND 90 CORRODED. REMOVED AND FABRICATED INTERCOSTAL AND SUPPORT. INSTALLED BETWEEN FR89 TO 90 IAW EMB 170 SRM 51-43-001, 51-41-01.SDR UHLA2010090500134Floorbeam · corrodedLEVEL 2 CORROSION RIGHT CENTER FLOORBEAM UPPER SHEET BETWEEN FRAMES 86 AND 87. REMOVED AND REPLACED RT FLOORBEAM FROM FR85 TO FR89 IAW EMB 170 SRM 51-41-01, 51-41-02, 51-43-02, 51-43-03.SDR USAA2010092092043Support · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FLOORBEAM SUPPORT AT BS 500B BETWEEN S20L TO S21L. REPAIRED FLOORBEAM SUPPORT AT BS 500B BETWEEN S20L TO S21L IAW B737 SRM 53-00-07.SDR A6WA201040677Floorbeam · corrodedFS 280 FLOOR SUPPORT ANGLE HAS CORROSION UNDER FLIGHT DECK CTR FLOOR PANEL. REMOVED CORRODED SUPPORT ANGLE FABRICATED AND INSTALLED NEW SERVICEABLE SUPPORT ANGLE AT FS 280.SDR A6WA201040678Floorbeam · crackedFS 280 FLOOR SUPPORT ON OTBD SIDE OF LBL 9 IS CRACKED. REMOVED DAMAGED AREA FABRICATED AND INSTALLED NEW SERVICEABLE ANGLE SUPPORT.SDR ASOA201001288Floorbeam · corrodedFS 559+80 FLOOR SUPPORT CAP STRIP BETWEEN RBL 27- RBL 36 CORRODED. REMOVED FLOOR SUPPORT CAP STRIP IAW SRM 51-42-06. LOCATED, DRILLED AND INSTALLED A SERVICEABLE CAP STRIP AT FS 559+80 BETWEEN RBL 27 - RBL 36 IAW SRM 51-40-11, 51-42-06 AND 51-42-15.SDR ASOA201001287Floorbeam · corrodedFS 559+80 FLOOR SUPPORT CAP STRIP BET RBL 9 - RBL 27 CORRODED. REMOVED FLOOR SUPPOR TCAP STRIP IAW SRM 51-42-06. INSTALLED NEW CAP STRIP IAW SRM 51-42-06 & 51-45-00.SDR DALA1021429868Floorbeam · crackedDURING M-CHECK FOUND CRACKS IN FLOORBEAM INTERCOSTAL AT BS 465 BL 0. REPAIRED IAW SRM 51-30-5 & SRM 51-30-2.
Back to JASC 5315