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 08FDEA00405Floorbeam · corrodedCORROSION AT TOP CAP BEAM C30 RT, C35 RT SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 08FDEA00401Floorbeam · corrodedCORROSION AT TOP CAP BEAM, C57, Y-450. SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 08FDEA00400Floorbeam · corrodedCORROSION AT TOP CAP BEAM, C63, Y1470 REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 08FDEA00398Floorbeam · corrodedCORROSION ON TOP CAP BEAM C 57.2, Y 480 SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 08FDEA00397Attach Fitting · corrodedCORROSION ON ATTACH FITTING TO TOP CAP BEAM, C 61 REPAIR PERFORMED BY REPLACING OF PART IAW SRM 51-72-10.SDR 08FDEA00396Floorbeam · corrodedCORROSION ON TOP CAP BEAM C61 REPAIR PERFORMED BY REPLACING OF PART IAW SRM 51-72-10.SDR 08FDEA00394Floorbeam · corrodedCORROSION FOUND ON TOP CAP BEAM C 62 LT, Y450. SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 208.SDR SWAA080745Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 46 TO RBL 46. REPAIRED FLOORBEAM PER SWA EA.SDR USAA920080487Floorbeam · corrodedMIA - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON CABIN FLOORBEAM, BS 847 - BS 899, LBL 56. REPAIRED CABIN FLOORBEAM, BS 847 - BS 899, LBL 56 IAW B767 SRM 53-00-51 REPAIR 3.SDR SWIA200819551Floorbeam · crackedSTA 280 BEAM IS CRACKED AT RIGHT BUTT LINE 9, FOUND AT C-CHECK. REPAIRED AREA PER CRJ700 SRM TASK 51-42-21-001-001-A01 AND REO 670-53-11-047.
SDR USAA920080442Floorbeam · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED CABIN FLOOR SUPPORT CRACKED, BS 540, LBL 2.5. REPLACED CABIN FLOOR SUPPORT, BS 540, LBL 2.5 IAW B737 SRM 51-40-04.SDR G60A200800001Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM LBL 5 STATION 1781.SDR TRAX200800230Floorbeam · crackedLOWER FS 280 FLOORBEAM WEB CRACKED OUTBOARD OF RBL9 (MARKED). REPAIRED DAMAGE IAW EO 600-53-90.SDR USAA920080360Floorbeam · corrodedBFM - MAJOR REPAIR - C4 CHECK - NR 6040676, LEVEL 2 CORROSION ON FLOOR SUPPORT, BS 1681, RBL 56. REPLACED FLOOR SUPPORT, BS 1681, RBL 56 IAW B757 SRM 51-40-02.SDR F3LA200800043Floorbeam · corrodedREFERENCE NON ROUTINE 26658, DURING C3/S1 C CHECK, INSPECTION REPORTED CORROSION WAS FOUND ON THE MAIN DECK FLOORBEAM AT LBL 47 AND FRAME 68. MAINTENANCE REMOVED AND REPLACED THE CORRODED FLOORBEAM IN ACCORDANCE WITH THE REQUIREMENTS OF A319 SRM 51-42-11. UPSDR F3LA200800042Floorbeam · corrodedREFERENCE NON ROUTINE 26654, DURING C3/S1 C CHECK, INSPECTION REPORTED CORROSION WAS FOUND ON THE MAIN DECK FLOORBEAM AT LBL 51 AND FRAME 66. MAINTENANCE REMOVED AND REPLACED THE CORRODED FLOORBEAM IN ACCORDANCE WITH THE REQUIREMENTS OF A319 SRM 51-42-11. UPSDR SWIA200819555Floorbeam · crackedCOCKPIT FLOOR SUPPORT IS CRACKED AT FS 280, FOUND AT C-CHECK. INSTALLED COCKPIT FLOOR SUPPORT PER CRJ700/900 SRM 51-42-06-001-001-A01.
SDR SWIA200819554Floorbeam · crackedFS 280 BEAM IS CRACKED AT LBL 9, FOUND AT C-CHECK. REPAIRED FLOORBEAM AT FS 280 PER CRJ700/900 SRM 51-42-068 AND REO 670-53-11-265.
SDR DL757080341Floorbeam · damagedMAIN CABIN FLOOR SUPPORT STA 329 RBL 23 HAS ELONGATED FASTENER HOLE. REFABRICATED FLOOR SUPPORT IAW DWGJ141N5150.SDR 08FDEA00359Floorbeam · crackedMCD FLOORBEAM HAS CRACK AT FR 32 LBL 67 FWD SIDE, REWORKED CRACKED FLOORBEAM IAW 53-10-15 FIG 212 SHEET 2.SDR 08FDEA00358Floorbeam · crackedMCD FLOORBEAM HAS CRACK AT FR 31 LBL67 FWD SIDE REWORKED CRACKED AREA IAW SRM 53-10-15 AND SRM 51-22-0, FINISHED REWORKED AREA IAW 51-75-10.SDR 08FDEA00357Floorbeam · crackedMCD FLOORBEAM HAS CRACK AT FR31 LBL67 FWD SIDE REWORKED CRACKED AREA IAW SRM 53-10-15 AND SRM 51-22-0, FINISHED REWORKED AREA IAW 51-75-10.SDR 08FDEA00355Floorbeam · crackedMCD FLOORBEAM HAS CRACK AT FR30 LBL 27 FWD SIDE REWORKED AREA IAW 51-75-10 53-10-15 FIG 212, FINISHED REPAIR IAW 51-75-10-8.SDR 08FDEA00354Floorbeam · crackedMCD FLOORBEAM HAS CRACK AT FR25 RBL27 FWD SIDE REWORKED REPAIR AREA IAW 53-10-15, SRM 51-21-10 AND SRM 51-75-10, FINISHED REPAIR IAW SRM 51-40-21.SDR 08FDEA00353Floorbeam · crackedMCD FLOORBEAM HAS CRACK AT FR25 RBL27 FWD SIDE REWORKED REPAIR AREA IAW 53-10-15, SRM 51-21-10 AND SRM 51-75-10, FINISHED REPAIR IAW SRM 51-40-21.SDR 08FDEA00352Floorbeam · crackedMCD FLOORBEAM HAS CRACK AT FR23 RBL27 FWD SIDE REPAIRED FLOORBEAM IAW 53-10-15 FIG 212, RESTORE FINISH IAW 51-21-10.SDR 08FDEA00351Floorbeam · crackedMCD FLOORBEAM HAS CRACK AT FR 30 LBL 67 FWD SIDE REWORKED AREA OF FLOORBEAM IAW SRM 51-10-15 FIG 212, RESTORED AREA IAW SRM 51-710.SDR DL757080344Floorbeam · corrodedCORROSION ON MAIN CABIN FLOORBEAM STA 1640 RBL 2. REMOVED DAMAGE IAW SRM 53-00-51. FABRICATED AND INSTALLED BEAM IAW SRM 53-00-51.SDR USAA920080354Floorbeam · corrodedBFM - MAJOR REPAIR - C4 CHECK - NR 6039970, LEVEL 2 CORROSION ON CABIN FLOORBEAM PREVIOUS REPAIR, BS 377.7, LBL 1 - LBL 20. REPLACED CABIN FLOORBEAM, BS 377.7, LBL 1 - LBL 20 IAW B757 SRM 53-15-01.SDR SWAA080654Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 661, LBL 25. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA080655Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 664, LBL 25. REPAIRED FLOORBEAM PER SWA EA.SDR SWIA200819550Floorbeam · corrodedCOCKPIT FLOOR SUPPORT IS CORRODED AT FS 280, FOUND AT C-CHECK. REPLACED COCKPIT FLOOR SUPPORT AT FS 280 PER CRJ700 SRM 51-42-06-001-001-A01.
SDR SWIA200819549Floorbeam · crackedSTA 280 BEAM IS CRACKED AT RBL11 AND LBL11, FOUND AT C-CHECK. INSTALLED NEW CROSSBEAM PER CRJ7/9 SRM 51-42-06.
SDR USAA920080382Floorbeam · corrodedSAL - MAJOR REPAIR - C8 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3158 / FR 66 - BS 3207 / FR 67, +Y1280. REPLACED CABIN FLOORBEAM, BS 3158 / FR 66 - BS 3207 / FR 67, +Y1280 IAW A320 SRM 51-72-11.SDR NWAA080396308Floorbeam · damagedDURING "M" CHECK, FOUND DOUBLE DRILLED FASTENER HOLES IN UPPER DECK FLOORBEAM AT BS 380 LBL 20 AND LBL 40. REPAIRED PER EA 63-211700.SDR NWAA080406308Floorbeam · damagedDURING "M" CHECK, FOUND DOUBLE DRILLED FASTENER HOLES IN UPPER DECK FLOORBEAM AT BS 400 LBL 20 AND LBL 40. REPAIRED PER EA 63-211701.SDR TRAX200800184Floorbeam · corrodedSTA 280 CROSSBEAM CORRODED.SDR GTIA0800012Floorbeam · corrodedFLOORBEAM BETWEEN Y254 AND Y765 BETWEEN FRAME 66 AND 70 SHOWS SIGNS OF CORROSION. REPLACED FLOORBEAM.SDR GTIA0800011Floorbeam · corrodedFLOORBEAM AT Y765 BETWEEN FRAME 66 AND 70 SHOWS SIGNS OF CORROSION. REPLACED FLOORBEAM.SDR GTIA0800010Floorbeam · corrodedFLOORBEAM AT Y254 AT FRAME 70 SHOWS SIGNS OF CORROSION. REPLACED FLOORBEAM.SDR USAA920080353Floorbeam · corrodedBFM - MAJOR REPAIR - C4 CHECK - NR 6040679, LEVEL 2 CORROSION ON CABIN FLOORBEAM, BS 1640, BL 0. REPLACED CABIN FLOORBEAM, BS 1640, BL 0 IAW B757 SRM 53-15-01.SDR DL76G080451Floorbeam · corrodedFLOORBEAM CORRODED AT 1480 RBL 28 TO RBL56. REPAIRED ON AVM508455 PER SRM 53-00-51D FIGURE 201 AT HMV.SDR SWAA080584Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM UPPER TEE CAP CRACKED AT BS 727B, LBL 45. REPAIRED FLOORBEAM TEE CAP PER SWA EA.SDR 08FDEA00336Floorbeam · damagedMAIN DECK FLOORBEAM, UPPER CHORD FWD FLG, IS MISDRILLED, BS 480, LBL 62, WL 208 ACCOMPLISHED HFEC, NO DEFECTS NOTED. APPLIED SEALANT TO AFFECTED HOLE. REF FED EX EA NR 7-5310-113134. THIS IS CLASSIFIED AS A MINOR REPAIR.SDR 2008UALA00531Floorbeam · corrodedAFT CABIN FLOORBEAM TEE CAP UPPER SURFACE CORRODED AT BS 986. FROM RBL 20 TO RBL 37. MAJOR REPAIR: CORROSION DAMAGE REMOVED. FABRICATED AND INSTALLED NEW TEE SECTION SPLICE ANGLES.SDR SWAA080552Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM TEE CAP CORRODED AT BS 689.5, LBL 45. REMOVED AND REPLACED TEE CAP PER SRM.SDR UPS08551724Floorbeam · corrodedINSPECTION TYPE:C4 CORROSION ON UPPER SURFACE OF FLOORBEAM STA 1100 LBL-23-RBL-43 WL 208. REPAIRED PER ENGINEERING REPAIR NR 08-1204.SDR USAA920080379Floorbeam · corrodedSAL - MAJOR REPAIR - C8 CHECK - CORROSION ON CABIN SEAT RAIL BEAM, BS 3043 / FR 64 - BS 3158 / FR 66, +Y1242. REPLACED CABIN SEAT RAIL BEAM, BS 3043 / FR 64 - BS 3158 / FR 66, +Y1242 IAW A320 SRM 51-72-11.SDR KCSA081044Floorbeam · dentedAFT PIT FLOORBEAM UPPER T-CHORD DENTED AT BS 1780, RBL 51.SDR SWIA200819635Floorbeam · corrodedFS 280 FLOOR SUPPORT BETWEEN LBL 9 AND RBL 9 IS CORRODED, FOUND AT C-CHECK. COMPLIED WITH REPAIRS IAW CRJ 200 SRM 57-42-06 AND 51-40-11.
Back to JASC 5315