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 USAA001904Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH BY .5 INCH, STATION 986, LBL 30 TO RBL 45. INSTALLED T-CAP TR 53-60-01 REV A. (M)SDR USAA001899Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1 INCH, BL 0 LONGITUDINAL WEB STATION 706 TO 714, WL 203. INSTALLED REPAIR DOUBLER AND WEB PER EA 68300 AND SRM 53-60-51. (M)SDR USAA001898Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED .25 INCH, LBL 25 LONGITUDINAL WEB STATION 706 TO 710, WL 203. INSTALLED WEB REPAIR PER EA 68300. (M)SDR USAA001896Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1.5 INCHES, LBL 24 LONGITUDINAL AT AILERON QUADRANT STATION 677. INSTALLED DOUBLER AND U-CHANNEL PER EO 5791G632. (M)SDR USAA001894Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1.5 INCH, RBL 24 LONGITUDINAL FLOORBEAM STATION 677, WL 206. INSTALLED DOUBLER AND U-CHANNEL PER EA 68275. (M)SDR USAA001890Floorbeam · corrodedCORROSION LEVEL 1 C 53-107-02 FLOORBEAM INTERCOASTAL STRAP STA 1016, LBL 17.5INSTALLED FLOORBEAM REPAIR ANGLE PER SRM 51-10-1SDR USAA001889Intercostal · corrodedCORROSION LEVEL 1 C 53-107-02 FLOORBEAM INTERCOASTAL STRAP STA 1016, RBL 2.5.INSTALLED DOUBLER PER SRM 531009 & 536002SDR USAA001888Floorbeam · corrodedFLOORBEAM CORRODED. INSTALLED DOUBLER PER SRM 53-10-09 & TR 53-60-02.SDR DL73E002186Floorbeam · corrodedFLOORBEAM CORRODED FS 344, RBL 14 TO LBL 48. REMOVED CORROSION PER SRM 51-10-6 AREA OUT OF LIMITS PER SRM 53-10-1. BEGAN REMOVING T-CAP. DRILLED UP REPLACMENT T-CAP PER M/M 53-21-0 FIG 803. OK TO INSTALL. STARTED INSTALLATION OF T-CAP PER M/M 53-21-0 FIG SDR MWEA001128Floorbeam · crackedFLOORBEAM HAS A CRACK ORIGINATING FROM FASTENER HOLE ON AFT SIDE OF RIGHT FUSELAGE FRAME STATION 544. FABRICATED AND INSTALLED NEW FLOORBEAM.SDR MWEA001124Floorbeam · corrodedRIGHT LAV AREA HAS CORROSION ON FLOORBEAM STATION 801. FABRICATED AND INSTALLED REPAIR ANGLE.SDR C2XAOOIA401Floorbeam · corrodedIAH-DURING C-CHECK INSPECTION, THE CENTER FLOOR BEAM WAS FOUND TO BE CORRODED FROM FRAME 60-61. MX REMOVED/REPLACED AFFECTED FLOOR BEAM IN ACCORDANCE WITH EMB145 SRM 51-40-02 AND A/C WAS APPROVED FOR RETURN TO SERVICE.SDR C2XAOOIA402Floorbeam · corrodedIAH-DURING C-CHECK INSPECTION, RH FLOOR BEAM WAS FOUND TO BE CORRODED FROM FRAME 59-61. MX REMOVED/REPLACED THE AFFECTED FLOOR BEAM IN ACCORDANCE WITH EMB145 SRM 51-40-02, AND THE A/C WAS APPROVED FOR RETURN TO SERVICE.SDR 2000UALA00717Floorbeam · crackedSTA 246 FORWARD STIFFENERS DAMAGED:TWO CRACKED IN THE RADIUS AT RBL 27.34 & LBL 7.88. TWO BUCKLED IN THE FREE FLANGE AT RBL 7.88 AND LBL 26.06. SUPPLEMENTAL DATA UPDATE, REPLACED STIFFENERS PER SRM 53-10-51.SDR DL73E002177Floorbeam · corrodedFLOORBEAM CORRODED, FS 312, LBL 14 TO RBL 24. REMOVED CORROSION SRM 51-10-6. AREA OUT OF LIMITS PER SRM 53-10-1. BEGAN REMOVING FASTENERS. CHEMICAL TREATED PER 900-4-06. DRILLED REPLACEMENT CAP PER M/M 53-21-0 FIG 803. OK TO INSTALL. REPAIRED PER M/M 53SDR TWAA0017508Floorbeam · corrodedDURING CHECK-C MAINT FOUND CORROSION ON FLOORBEAM CAP AT STA 1250, LBL 24 IN TO LBL 48 INCHES. REPLACED FLOOR PANEL SUPPORT PER DRAWING 9930612.SDR TWAA0017507Floorbeam · corrodedDURING CHECK-C MAINT FOUND CORROSION ON CABIN FLOORBEAM CAP AT STA 1155, LBL 24 TO LBL 47. REMOVED AND REPLACED FLOORBEAM CAP PER SPM 6-70-01, PAGE 2 AND 3. INSTALLED BEAM CAP USING HI-LOKS PER SRM 51-30-5, PAGE 12, AND PER TORQUE VALUES SRM 51-30-1, PAGE 11SDR USAA001877Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 2 INCHES AND 1 FT BY 2 INCHES, STATION 1006 TO 1016, LBL 5.5 TO 9. REMOVED AND REPLACED PER SRM 51-30-00. (M)SDR USAA001875Floorbeam · corrodedCLT - FOUND FLOORBEAM 2 INCH BY 3 INCH, STATION 328, BL 0 CABIN FLOORBEAM. CORROSION LEVEL 1. INSTALLED NEW T-CAP PER SRM 53-10-51 FIG 205. (M)SDR 20010111SG019Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAM 36 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS IAW SRM 51-25-01. AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA3081. (M)SDR SIMA3081Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAM 36 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAMS IAW SRM 51-25-01. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR UPS00434324Floorbeam · crackedINSPECTION TYPE:C, TEE PIECE CRACKED AT BS 400 BL 0 AT E&E FLOOR LEVEL. T-PIECE REPLACED IAW SRM 51-30-02.SDR SWAA002228Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD, LOWER SURFACE, CORRODED AT BS 986.5, LBL 14.5, WL 207.5. REMOVED AND REPLACED ENTIRE UPPER CHORD SECTION PER ER 00-1204.SDR USAA001853Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH IN SIX AREAS, UPPER T-CAP FLOORBEAM STATION 1006, LBL 9, 11, 15, 28.5. INSTALLED NEW T-CAP SECTION PER SRM 53-10-9 FIG 2. (M)SDR USAA001862Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 2.5 INCH, STATION 679, LBL 25 CABIN FLOORBEAM. FABRICATED NEW FLOORBEAM INSTALLED PER DWG NR 65C34537. (M)SDR 20010111SG022Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAMS 36, 38 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM 38 AND 39 IAW SRM 51-25-02. MAINTENANCE REPAIRED FLOORBEAM 36 IAW SRM 53-00-00. AIRCRAFT WAS RETURNED TO SERVICE. REF SIMASDR 20010111SG021Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAMS 36, 38 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM 38 AND 39 IAW SRM 51-25-02. MAINTENANCE REPAIRED FLOORBEAM 36 IAW SRM 53-00-00. AIRCRAFT WAS RETURNED TO SERVICE. REF SIMASDR SIMA3072Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAMS 36, 38 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM 38 AND 39 IAW SRM 51-25-02. MAINTENANCE REPAIRED FLOORBEAM 36 IAW SRM 53-00-00. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR TWAA0017701Floorbeam · corrodedDURING OP 16 MAINT CHECK, FOUND CORROSION ON FLOORBEAM CAP AT STA 1351, BETWEEN STRINGER 33L AND 39L. REPLACED FLOORBEAM CAP AT STA 1351 PER SRM 51-10-02.SDR SWAA002218Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 13 - RBL 14, WL 208. REPAIRED FLOORBEAM PER SRM.SDR DL73K002153Floorbeam · crackedTHE BL 0.07 FLOORBEAM WAS FOUND CRACKED FROM FS 700 TO FS 717 IN THE WEB. THE DAMAGE WAS REMOVED AND REPAIRED PER B737 S/B 57-1210 AT HMV.SDR DL73K002151Floorbeam · crackedCRACKS WERE FOUND IN THE BL 0 FLOORBEAM WEB AND CHORD BETWEEN FS 650 AND FS 675. THE DAMAGE WAS REMOVED AND REPAIRED SIMILIARL TO THAT OF S/B 737-57-1210 PER ERA 396377-14 AT HMV.SDR COMA0060866Floorbeam · crackedFLOOR MEMBER (P/N 600-34017-17) AT FS 280.00 HAS A .5 INCH CRACK. TRIMMED OUT CRACKED AREA AND FABRICATED REPAIR ANGLE. INSTALLED IAW WVAC EO 601R-53-1861.SDR USAA001841Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED .250 INCH, BS 668 - BS 680, LBL 23.5. REMOVED AND REPLACED BEAM PER DWG 65-45410. (M)SDR AWXA0000824Floorbeam · damagedC-CHECK, CABIN FLOORBEAM AT FS 847, LBL 25, HAS 4 OPEN HOLES AND 1 ELONGATED HOLE. REMOVED DAMAGE, FABBED AND INSTALLED DOUBLER, FILLER, AND ANGLE IAW 737 SRM 53-10-9.SDR AWXA0000820Floorbeam · corrodedC-CHECK CORROSION LVL 2, CORROSION ON TOP OF FLOORBEAM AT STA 294.5, RBL 16 TO 40. REMOVED T-CHORD IAW 737 SRM 51-20-2, FABRICATED T-CAP IAW 737 SRM 53-10-9, TREATED AND PRIMED, INSTALLED T-CAP IAW 737 SRM 53-10-9 FIG 5.SDR SWAA002201Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 360, RBL 14. REPAIRED FLOORBEAM UPPER CHORD PER SRM.SDR TWAA0017607Floorbeam · corrodedDURING OP 16 MAINT CHECK, FOUND CORROSION ON FLOORBEAM STA 1285, FROM STRINGER 34R TO 39R. REPLACED FLOORBEAM PER SRM 51-40-02 AND SPM 6-70-01.SDR SWAA002186Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOOR BEAM CORRODED AT CLIP NUT HOLES BS 986, WL 208, LBL 45 - RBL 45. REPAIRED FLOORBEAM PER SRM.SDR QXEA0003010Floorbeam · corrodedPDX- FLOORBEAM PLATE WEB HAS CORROSION REMOVAL GREATER THAN 15 PERCENT AT FLOOR PANEL NUT PLATE AREA AND ONE HOLE AT FORWARD END HAS TWO CRACKS STEMING FROM HOLE BETWEEN FRAMES 4175 AND 4850. REPAIRED IAW FOKKER SRM 51-31-01 AND 53-11-05.SDR USAA001832Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 3 INCHES, LOWER SURFACE CREASEBEAM WEB AFT SERVICE DOOR. INSTALLED DOUBLER AND REPAIR ANGLE PER SRM 51-10-1. CORROSION LEVEL 1 C53-107-02. (M)SDR 2000UALA00715Floorbeam · crackedSTA 246 FORWARD STIFFENERS DAMAGED:ONE CRACKED IN THE RADIUS AT RBL 7.88. THREE BUCKLED IN THE FREE FLANGE AT RBL 26.06 & 49.0 AND LBL 7.88. SUPPLEMENTAL DATA UPDATE, REPLACED CRACKED AND DISTORTED STIFFENERS PER SRM 53-10-51.SDR TWAA0017404Floorbeam · corrodedDURING OP 15 MAINT CHECK IN THE RT AFT LAVATORY, AT STA 996 THE FLOORBEAM WAS CORRODED, 55 INCHES RBL, UNDER TOP FLANGE. FABRICATED AND INSTALLED REPAIR PER SRM 53-05, FIG 18.SDR TWAA0017215Floorbeam · corrodedDURING OP 15 MAINT CHECK AT RT AFT LAV AT STA 996, FLOORBEAM 8 PLACES HAD CORROSION ON TOP FLANGE. REMOVED THE CORROSION PER SPM 6-80-01. FABRICATED AND REPAIRED PER SRM 53-05, FIG 108.SDR SWAA002166Floorbeam · corrodedDURING SCHEDULED 1/4 CHECK, FOUND AFT B/B FLOORBEAM CORROSION AT BS 770, RBL 3 - 7. REPAIRED FLOORBEAM PER RA 1-A53-2021.SDR USAA001827Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH IN 3 AREAS, T-CAP FLOORBEAM 377.7, LBL 26, 43, 48. INSTALLED DOUBLER PER TR 53-15-02. (M)SDR USAA001825Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH IN FOUR PLACES, STATION 947.5 RBL 4, 5, 10.5 AND LBL 5. CORROSION LEVEL 1. SPLICED T-CAP PER SRM 53-10-2. (M)SDR USAA001823Floorbeam · corrodedCLT - FOUND FLOOBEAM CORRODED 12 INCHES BY 5 INCHES, STATION 344, BL 0 TO BL 12L. CORROSION LEVEL 1. REPLACED PER TR 53-10-13. (M)SDR ASAA0040122Floorbeam · corrodedPAE DURING MAINTENANCE INSPECTION FOUND CORROSION ON UPPER FLANGE OF FLOOR BEAM @STA 986.5. REPAIRED IN ACCORDANCE WITH EA 5310-01972.SDR SWAA002149Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAMS CORRODED AT BS 947.5, LBL 23 AND BS 328, RBL 42. REPAIRED FLOORBEAMS PER RA 1-353-2385 AND SRM.
Back to JASC 5315