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 CALA2010060100231Floorbeam · corrodedMULT-25-3-0042 CABIN - LT STA 303 LBL 14-30 FLOORBEAM UPPER SURFACE FOUND CORROSION. BS 303 FLOORBEAM REPAIRED IAW SRM 53-00-51.SDR FDEA201005271689Stiffener · crackedLWR FWD CARGO CEILING FRAME 25 FLOORBEAM FWD SIDE 27" RT OF CTRLINE THE VERTICAL STIFFENER IS CRACKED AT THE TOP (APPROX. LENGTH IS 1/4IN) BLENDED CRACK AT FRME 25 IAW SRM 51-73-10. NDT VERIFIED REMOVAL OF CRACK. FABRICATED REPAIR ANGLE AND REPAIRED CROSSBEASDR FDEA201005271688Stiffener · crackedLWR FWD CARGO CEILING AREA FRAME 38 FLOOR BEAM, FWD SIDE 67" LT OF CTRLINE THE VERTICAL STIFFENER IS CRACKED AT THE TOP (CRACK LENGTH APPROX. .3750 IN. LONG) SMOOTH AND BLENDED CRACKED AREA IAW SRM 51-73-10. NDT CHECKED AND FOUND NO CRACKS. FABRICATED RSDR MASA2010052700553Floorbeam · crackedRT AND LT 280 FLOORBEAM CRACKED AND CORRODED. MX REPAIRED 280 FLOORBEAM IAW RO CRJ-53-0311.SDR USAA2010062291215Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON CABIN FLOORBEAM BETWEEN FR66 TO FR68, Y1292. REPLACED CABIN FLOORBEAM BETWEEN FR66 TO FR68, Y1292 IAW A319 SRM 51-72-11.SDR USAA2010062191201Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, Y1292, S23L. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, Y1292, S23L IAW A319 SRM 51-72-11.SDR USAA2010062191200Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, -Y1292, S23R. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, -Y1292, S23R IAW A319 SRM 51-72-11 & AIRBUS DRAWING 53472000.SDR USAA2010062191199Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y1292, S23R. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, -Y1292, S23R IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53472000.SDR ASOA201000826Floorbeam · corrodedBS 280 FLOORBEAM CORRODED. REMOVED FS 280 BEAM, ALL WORK DONE IAW SRM 51-42-21-001-001-A01 AND 51-42-06-001-001-A01. PERFORMED LPI, TYPE1, METHOD C ON CUT LINE ON NEW FS 280.00 BEAM IAW SRM 52-12-00-001-001 IAW NDT INSP PROCEDURE PT-1. NO INDICATIONS NOTEDSDR QXEA2010052800311Floorbeam · corrodedC-CHECK - FLOOR SUPPORT ANGLE FOR PANEL 141ALF HAS CORROSION AT FS 280. DRILLED OFF FLOOR SUPPORT ANGLE. ANGLE IS CORRODED BEYOND LIMITS IAW SRM 51-42-06-001-001-A01 AND TASK 53-21-43-101-001-A01 AND 53-21-43-001-A01 PG 103. LOCATED FASTENER HOLES IN NEW PASDR FDEA201005261660Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER CAP CORRODED AT STA 324 RBL 30 TO RBL 58. ACCOMPLISHED EA F-5310-139154, PART 2 TO BE ACCOMPLISHED NO LATER THAN 37,500 TFC, PART 3 TO BE ACCOMPLISHED EVERY 12,000 FC AFTER PART 2. MAJOR REPAIR.SDR USAA2010062291219Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66, Y1292, S23L. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, Y1292, S23L IAW A319 SRM 51-72-11.SDR USAA2010062291218Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR68 TO FR70, Y230, S23L. REPLACED FLOORBEAM BETWEEN FR68 TO FR70, Y230, S23L IAW A319 SRM 51-72-11.SDR USAA2010062291217Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 + 10 INCHES TO FR70, S23R, -Y765. REPLACED FLOORBEAM BETWEEN FR66 + 10 INCHES TO FR70, S23R, -Y765 IAW A319 SRM 51-72-11 DRAWING D53472000.SDR USAA2010062291216Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC ON FLOORBEAM RAIL SEAT BETWEEN FR64 TO FR66, -Y1292, S23R. REPLACED FLOORBEAM RAIL SEAT BETWEEN FR64 TO FR66, -Y1292, S23R IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53472000.SDR USAA2010062191202Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR 65+19 INCHES, -Y765, S23R. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, -Y765, S23R IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53472090003.SDR USAA2010062191198Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR65 + 19 INCHES, Y1500. REPLACED FLOORBEAM BETWEEN FR65 TO FR66, Y1500 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53472750.SDR USAA2010062191197Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR68, Y230, S23L. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, Y230, S23L IAW A319 SRM 51-72-11.SDR USAA2010062191196Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR65, Y765, S23L. REPLACED FLOORBEAM AT FR65, Y765, S23L IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53472000.SDR USAA2010062191195Floorbeam · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR68, Y765, S23L. REPLACED FLOORBEAM AT FR68, Y765, S23L IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53472000.SDR GTIA1000030Floorbeam · damagedBEAM STATION Y-160.5 JUST AFT OF SPLICE HAS A DRILL MARKSDR ASOA201000812Floorbeam · corrodedMAIN AVIONICS COMPARTMENT FS 280.00, 241ALF, FLOOR SUPPORT STRUCTURE UPPER SURFACE HAS CORROSION. FLOOR SUPPORT ANGLE WAS R & R FOR ALL WORK ACCOMPLISHED.SDR SWAA103093Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 986, LBL 4. REPAIRED FLOORBEAM PER SRM.SDR SWAA103067Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 312, BL 0. REPAIRED FLOORBEAM PER EA.SDR USAA2010061691149Coupling · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON UPPER OUTBOARD FLOORBEAM SPLICE AT FR68, -Y1292. REPLACED UPPER OUTBOARD FLOORBEAM COUPLING AT FR68, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2010052491005Floorbeam · crackedBFM - MAJOR REPAIR - C4 CHECK - CRACKED FLOORBEAM UPPER CHORD, BS 347, LBL 10, WL 199. REPAIRED FLOORBEAM UPPER CHORD, BS. 347, LBL 10, WL 199 IAW EA 134231.SDR USAA2010061691148Coupling · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON LOWER OUTBOARD FLOORBEAM SPLICE AT FR66, -Y1292. REPLACED LOWER OUTBOARD FLOORBEAM COUPLING AT FR66, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2010061691147Coupling · corrodedSAL - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON UPPER INBOARD FLOORBEAM SPLICE AT FR66, -Y1292. REPLACED UPPER INBOARD FLOORBEAM COUPLING AT FR66, -Y1292 IAW A319 SRM 51-72-11.SDR IPXA10560535Floorbeam · corrodedINSPECTION TYPE:C3, FLOORBEAM UPPER SURFACE CORRODED AT FASTENER HOLES BS 1540, LBL 25 TO 45, WL 208. REPAIR FLOORBEAM IAW ER NR10-2918.SDR IPXA10560564Floorbeam · corrodedINSPECTION TYPE:C3, MCB FLOOR SUPPORT HAS CORROSION ON UPPER SURFACE BS 900 LBL 5-20, WL 208. R & R PLATE IAW SRM 51-40-02.SDR IPXA10560562Floorbeam · corrodedINSPECTION TYPE:C3, MCB FLOOR SUPPORT HAS CORROSION ON UPPER SURFACE BS 900, LBL 5-20, WL 208. R & R PLATE IAW SRM 51-40-02.SDR SWAA103055Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER SRM AND EO.SDR SWAA103054Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 727D+5, RBL 8.10. REPAIRED BEAM PER SRM AND EA.SDR SWAA103053Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER FLANGE CRACKED AT BS 727B, LBL 24.5. REPAIRED BEAM PER SRM AND EO.SDR SWAA103052Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER FLANGE CRACKED AT BS 294.5, RBL 42 TO RBL 47. REPAIRED BEAM PER SRM.SDR SWAA103051Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER FLANGE CRACKED AT BS 294.5, STR 17R. REPAIRED BEAM PER SRM.SDR SWAA103050Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER FLANGE CRACKED AT BS 947.5, LBL 53. REPAIRED BEAM PER SRM.SDR SWAA103047Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER FLANGE CORRODED AT BS 328, RBL 13 TO RBL 45. REPAIRED FLOOR BEAM PER TYP REPAIR MANUAL.SDR USAA2010052491009Floorbeam · corrodedBFM - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON FLOORBEAM UPPER CHORD, BS 325, RBL23, WL 200. REPAIRED FLOORBEAM UPPER CHORD, BS 325, RBL 23, WL 200 IAW B767 SRM 53-0051 AND 51-40-02.SDR SWAA103020Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 733D, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA102987Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 670, LBL 23. REPAIRED BEAM PER AEM.SDR SWAA102986Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 670, LBL 24.5. REPAIRED BEAM PER AEM.SDR UALA2010052001704Bolt · sheared(2) SHEARED BOLTS FOUND AT FLOORBEAM EXPANSION JOINT FWD OF C47 FRAME. REPLACED ALL (6) BOLTS, NDT AT RMD. BOLTS LOC, NO CRACKS. TASK DONE ON SMB W-U H7313S AND H7312S. CREATED ENTRY FOR REFERENCE AND HISTORY.SDR SIMA201014007Floorbeam · crackedDURING MAINTENANCE BASE VISIT FOUND FRAME 280 FLOORBEAM CRACKED ON LEFT AND RIGHT SIDES. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED FRAME 280 BEAM IAW EO -CR-53MR-134R1. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR IPXA10560551Floorbeam · corrodedINSPECTION TYPE:C3, FLOOR PANEL SUPPORT IS CORRODED AT BS 397, RBL 22, WL 208. R & R SUPPORT IAW SRM 51-40-02.SDR IPXA10560508Floorbeam · corrodedINSPECTION TYPE:C3, FLOORBEAM UPPER CHORD IS CORRODED AT BS 310, LBL 58, WL 208. REPAIR FLOORBEAM IAW ATS ER NR 10-2868.SDR IPXA10560507Floorbeam · corrodedINSPECTION TYPE:C3, FLOORBEAM UPPER CHORD IS CORRODED AT FASTENER HOLES COMMON TO FLOOR BOARD PANEL HOLES, BS 310, RBL 7 TO LBL 17, WL 208. REPAIRED FLOORBEAM IAW ATS ER NR 10-2868.SDR IPXA10560287Floorbeam · corrodedINSPECTION TYPE:C3, FLOORBEAM UPPER CHORD IS CORRODED AT BS 297, LBL 39, WL 208. REMOVED UPPER CHORD RECEIVED PART AND INSTALLED IAW SRM 51-10-02-0G, SRM 51-40-02, SRM 53-10-51-01.SDR SWAA102954Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CRACKED AT BS 727B, LBL 24.8. REPAIRED BEAM PER AEM.SDR SWAA102951Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 845.5, BETWEEN STR 26R TO STR 27R. REPAIRED BEAM PER EA.
Back to JASC 5315