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 ASAA0944867Floorbeam · corrodedSTA 986.5 FLOORBEAM UPPER FLANGE CORRODED. REMOVED ENTIRE UPPER FLANGE, FABRICATED AND INSTALLED REPLACEMENT UPPER FLANGE CHORD SPLICE ANGLES AND SPLICE STRAPS IAW EA 400 53EA 00794.SDR ASAA0944737Floorbeam · corrodedFLOORBEAM UPPER FLANGE CORRODED STA 947 LBL 6 TO RBL 6. REMOVED FLOORBEAM UPPER CAP FABRICATED AND INSTALLED SPLICE REPAIR IAW EA 400 53EA 007.SDR USAA2009030390490Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR67 + 18 INCHES TO FR69 + 5 INCHES, Y1165. REPLACED FLOORBEAM BETWEEN FR67 + 18 INCHES TO FR69 + 5 INCHES, Y1165 IAW A320 SRM 51-72-11.SDR USAA2009030290480Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR67 + 16 INCHES TO FR69 + 5 INCHES, -Y1165. REPLACED FLOORBEAM BETWEEN FR67 + 16 INCHES TO FR69 + 5 INCHES, -Y1165 IAW A320 SRM 51-72-11.SDR USAA2009030290478Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 + 5 INCHES TO FR67 + 16 INCHES, Y1175. REPLACED FLOORBEAM BETWEEN FR66 + 5 INCHES TO FR67 + 16 INCHES, Y1175 IAW A320 SRM 51-72-11.SDR USAA2009021990381Floorbeam · corrodedSAL - C8 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 +5 INCHES TO FR70, -Y765. REPLACED FLOORBEAM BETWEEN FR66 +5 INCHES TO FR70, -Y765 IAW A320 SRM 51-72-11.SDR DU4R2009295Floorbeam · crackedS/O 312003 N/R 37981 DURING SCHEDULED INSPECTION, FOUND FLOORBEAM WEB AT BS 706, LBL 46 HAS 4 INCH CRACK.SDR AALA2009021100216Floorbeam · corrodedCORROSION ON FLOORBEAM, REMOVED AND REPLACED FLOORBEAM PER SRM 51-03.SDR AALA2009021100215Floorbeam · corrodedFLOORBEAM CORRODED, REMOVED AND REPLACED FLOORBEAM PER SRM 51-03.SDR UPS09654789Floorbeam · crackedINSPECTION TYPE:C MAIN E/E COMPT MAIN DECK FLOORBEAM MID CHORD AT VERTICAL EDGE CRACK 0.75 INCH LENGTH. MAIN E/E COMPT M/D FLOORBEAM MID CHORD UPPER VERTICAL FLANGE REPAIRED AS PER SRM 53-10-51-2R 2 REPAIR 2 REV (43), THIS IS CLASSIFIED AS A MAJOR REPAIR WITHSDR ASOA200900198Floorbeam · corrodedFWD FLOORBEAM ANGLE AT FS 280 IS CORRODED. REMOVED FWD SUPPORT FLOOR ANGLE IAW SRM 51-42-06 AND 51-42-20. DRILLED AND INSTALLED NEW FWD SUPPORT FLOOR ANGLE PER SRM 51-40-11 AND 51-42-06. BAT7023167. RII C/W SATISFACTORY IAW SP 607 & SRM 51-40-11.SDR F3LA2009021300025Floorbeam · corrodedREFERENCE NON-ROUTINE C057562. DURING C3 C-CHECK, INSPECTION NOTED CORROSION ON FLOORBEAM -Y1292 BETWEEN FRAME 66 AND FRAME 68. MAINTENANCE REMOVED AND REPLACED FLOORBEAM -Y1292 BETWEEN FRAME 66 AND FRAME 68 IN REFERENCE TO SRM 51-42-11 PARAGRAPHS 5 AND 7.SDR CALA2009021200096Floorbeam · corrodedFLOORBEAM SUPPORT HAS CORROSION BETWEEN STA 700 -720 AND RBL-24. FABRICATED AND INSTALLED INTERCOSTAL AND SHIMS PER ECRA5310-04900. FABRICATED AND INSTALLED REPAIR SECTION TO UPPER T-CHORD PER SRM 53-00-51 FIG 201 REPAIR 3.SDR CALA2009021200095Floorbeam · corrodedFLOORBEAM HAS CORROSION AT RBL-58. REMOVED FLOOR SUPPORT, FABRICATED FLOOR SUPPORT REF DWG 143N5434 -1. INSTALLED FABRICATED FLOOR SUPPORT REF DWG 143N5434-1 AND SRM 51-40-02.SDR CALA2009021200094Floorbeam · corrodedB757-53-3-0427 FLOORBEAM SUPPORT BEAM HAS CORROSION STA 695, RBL 4.5. REMOVED FLOOR SUPPORT STA 695 RBL 45. FABRICATED NEW FLOOR SUPPORT T REF DWG 143N5123-1 AND ECRA 5310-04899. INSTALLED FABRICATED FLOOR SUPPORT REF DWG 143N5123-1 AND SRM 51-40-02. ISSUESDR CALA2009021200093Floorbeam · corrodedLAV S FLOOR BEAM EXTRUSION AROUND MOUNT AT STA 685 LBL 45 HAS DEEP SCRIBE MARK. REMOVED PART BECAUSE SCRIBE MARK AND CORROSION WERE BEYOND SRM LIMITS, FABRICATED, NDT INSPECTED, ALODINED, PRIMED, INSTALLED, IDENTIFIED NEW SUPPORT FITTING AND INITIATED DIP TO SDR CALA2009021200092Floorbeam · corrodedFOUND HEAVY CORROSION AT FLOORBEAM STA 740 LBL-13 THRU RBL-16. REPAIRED FLOORBEAM STA 740 LBL-13 TO RBL-16 REF SRM 53-00-51 REPAIR 3 FIG 201. SHIMMED FLOORBEAM STA 720 TO 740 RBL-16 REF ECRA 5310-04901 REV A.SDR IPXA09554951Floorbeam · corrodedINSPECTION TYPE: C3 MAIN CARGO BAY. THE BS 560 FLOORBEAM IS CORRODED AFT UPPER FLANGE LBL 14.5 AND 20 WL 208. REPAIRED PER ATS ENGEERING REPAIR 09-1556.SDR ASAA0944387Floorbeam · crackedFLOORBEAM CRACKED. R&R.SDR DU4R2009294Floorbeam · corrodedS/O 312003 N/R 27863 DURING SCHEDULED INSPECTION, FOUND CORRODED CHORD AT BS 349 LBL 34 T-CAP.SDR DU4R2009293Floorbeam · corrodedS/O 312003 N/R 37879 DURING SCHEDULED INSPECTION, FOUND CORROSION ON FLOORBEAM AT BS 994.5 LBL 12 - LBL 30.SDR DU4R2009292Floorbeam · corrodedS/O 312003 N/R 39298 DURING SCHEDULED INSPECTION, FOUND CORROSION ON FLOORBEAM T-CAP AT BS 947.5 RBL TO LBL 10.SDR FDEA200902090488Floorbeam · misrepairedEXISTING FLOORBEAM REPAIR LOCATED AT BS 1661, LBL 25-RBL 52, WL 208, UPON EVALUATION OF ATTACHMENT "B" OF EO F-5100-7-5001, PART 1, DOES NOT MEET SRM REQUIREMENTS. REPAIR ACCOMPLISHED DURING PTF CONVERSION, W/O 41399, AND MAE EA 757-5365-16- F1603, REV B. TSDR FDEA200902090487Floorbeam · misrepairedEXISTING FLOORBEAM REPAIR AT BS 1661, LBL 52, WL 208, UPON EVALUATION, OF ATTACHMENT "B" OF EO F-5100-7-5001, PART 1, REPAIR DOES NOT MEET SRM REQUIREMENTS. REPAIR ACCOMPLISHED DURING PTF CONVERSION, W/O 41399, AND MAE EA 757-5365-16- F1603, REV B. THIS SSDR IPXA09555016Floorbeam · corrodedINSPECTION TYPE:C3 FLOORBEAM AT STA 1200 EVIDENCE OF CORROSION BETWEEN RBL 24.75 AND 45.5 AROUND HOLES AND NUT PLATES. REPAIRED PER ATS EO 09-1552.SDR IPXA09555015Floorbeam · corrodedINSPECTION TYPE:C3 FLOORBEAM AT STA 1200 HAS CORROSION ON UPPER SURFACE AT LBL 24.75 AND 45.5 AT FASTENER HOLES AND NUT PLATES. REPAIRED PER ATS ENGINEERING REPAIR 09-1552.SDR IPXA09554939Floorbeam · corrodedINSPECTION TYPE:C3 FLOORBEAM AT STA. 1200 HAS CORROSION ON UPPER SURFACE AT LBL 5, LBL.5 AND LBL 15. FLOORBEAM WILL BE REPAIRED ON CUSTOMER CARD 794472SDR ASOA200900191Floorbeam · corrodedFS 280.00 LT CROSS BEAM CORRODED ON TOP FLANGE. REMOVED AND REPLACED 280 LT CROSSBEAM PER SRM 51-40-11 AND 51-42-00.SDR ASOA200900190Floorbeam · corrodedFS 280.00 RT CROSS BEAM CORRODED ON TOP FLANGE. REMOVE AND REPLACED RT CROSSBEAM PER SRM 51-40-11 AND 51-42-00.SDR SWAA091025Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 671, LBL 24. REPAIRED BEAM PER EA.SDR SWAA091024Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 666, LBL 24. REPAIRED BEAM PER EA.SDR SWAA091023Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663, LBL 24. REPAIRED BEAM PER EA.SDR SWAA091022Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 656, LBL 24. REPAIRED BEAM PER EA.SDR SWAA091021Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 659, LBL 24. REPAIRED BEAM PER EA.SDR SWAA090997Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL BEAM WEB CRACKED BETWEEN BS 705 TO BS 711, LBL 24. REPAIRED BEAM PER ER.SDR SWAA090994Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 772, LBL 3. REPAIRED BEAM PER SWA EA.SDR SWAA090951Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 695, RBL 24. REPAIRED BEAM PER SRM.SDR ASOA200900178Floorbeam · crackedFLOOR ATTACH ANGLE CRACKED AT OTBD SIDE OF LBL 9 FS 280.SDR ASOA200900177Floorbeam · crackedFLOOR ATTACH ANGLE CRACKED AT OTBD SIDE OF RBL 9 FS 280.SDR UALA2009020900420Floorbeam · damagedFLOORBEAM AT STA 972 HAS DAMAGE DUE TO BURNED C2 PUMP FEEDER CABLES. RECEIVED REPAIR METAL 2030 (TITANIUM & ALUMINUM PLATE). ROUTE TO SHOP FOR REPAIR ANGLE MFG. REMOVED DAMAGE AND INSTALLED REPAIR.SDR QXEA2009021000101Floorbeam · crackedPDX - C5- 280 BEAM CRACKED AT UPPER FWD BEND RADIUS AT APPROX LBL 8.0 TO LBL 11.0. CONFIRMED CRACK WITH HFEC AND FPI IAW CRJ NDTM 51-20-001 AND 51-20-008. REMOVED LT SIDE OF 280 BEAM IAW SRM 51-42-13, 51-42-06, AND 51-42-21. LOCATED AND DRILLED FASTENER HOLSDR UALA2009020900415Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM UPPER CHORD WITH REPAIR ANGLE AND SPLICE STRAPS.SDR CALA2009020600089Floorbeam · corrodedCABIN FLOOR STRUCTURE FLOORBEAM STATION 1661 LBL 30 HAS CORROSION ON TOP SURFACE. FABRICATED AND INSTALLED REPAIR PER SRM 53-00-51 REPAIR 3 FIG 201.SDR C8GA20090024Floorbeam · crackedWHILE IN HEAVY MAINTENANCE PERFORMING INSPECTION IT WAS NOTED THAT THE FUSELAGE UPPER LOBE WING CENTER SECTION OVERWING FLOORBEAM IS CRACKED UNDER SEAT TRACK SECTION BS 760.9 RBL 24.75. CRACKED FLOORBEAM WAS REMOVED AND REPLACED WITH NEW CHORD FROM BS 760.9. SDR C8GA20090023Floorbeam · crackedWHILE IN HEAVY MAINTENANCE PERFORMING INSPECTION IT WAS NOTED THAT THE FUSELAGE UPPER LOBE WING CENTER SECTION OVERWING FLOORBEAM CRACKED UNDER SEAT TRACK SECTION BS 760.9 RBL 45.50. CRACKED FLOORBEAM WAS REMOVED AND REPLACED WITH NEW CHORD FROM BS 760.9. NOSDR C8GA20090022Floorbeam · crackedWHILE IN HEAVY MAINTENANCE PERFORMING INSPECTION IT WAS NOTED THAT THE FUSELAGE UPPER LOBE WING CENTER SECTION OVERWING FLOORBEAM CRACKED UNDER SEAT TRACK SECTION BS 760.9 LBL 24.75 CRACKED FLOORBEAM WAS REMOVED AND REPLACED WITH NEW CHORD FROM BS 740-850 IAW SDR C8GA20090017Floorbeam · corrodedWHILE IN HEAVY MAINTENANCE IT WAS NOTED THAT THE FLOORBEAM AT BS 277 BL 14L HAS CORROSION. CUT OUT DAMAGED AREA 13 INCH. FABRICATED REPAIR CHORD FROM BAC 1505-39042 7075 T65N DIM 13 INCH AND FILLER FROM 7075 T6 .050 INCH DIM 6.125 INCH BY 9.00 INCH. INSTALSDR DL75E090162Floorbeam · corrodedCORROSION ON MAIN CABIN FLOOBEAM UPPER SURFACE AND BOTTOM OF FASTENER HOLES AT STA365 BL-0 TO RBL-65.SDR DL75E090161Floorbeam · corrodedCABIN FLOORBEAM 1640 UPPER SURFACE HAS CORROSION INCLUDING AREAS AROUND FASTENER HOLES RBL 60 TO LBL 60.SDR DL75E090158Floorbeam · corrodedCORROSION ON MAIN CABIN FLOOR SUPPORT UPPER SURFACE AT STA 333 RBL-4.
Back to JASC 5315