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 DL76L071651Floorbeam · corrodedCABIN: STATION 1480 RBL 36 TO 42 FLOORBEAM UPPER CHORD FOUND CORRODED. REPAIRED ON NR515625 AT HMV3/PSV22 PER SRM 53-00-51D FIG 201.SDR SWAA076478Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 946, RBL 5. REPAIRED FLOORBEAM PER SRM.SDR 07FDEA05118Floorbeam · corrodedCORROSION AROUND NUT PLATE HOLES ON TOP OF FLOORBEAM AT SEVERAL LOCATIONS, FS 1130, LBL 64 TO RBL 64, WL 208. BLENDED DAMAGE AREA STA 1130, RBL 64, FOUND TO BE OUT OF LIMITS, REF SRM 53-10-8 TOOL NR IN17-0023 CAL DATE DUE 2-13-08. REMOVED DAMAGE AREA, REF SRSDR 2007UALA05219Floorbeam · corrodedAFT CARGO BAY, STA 1131, RBL 36, TEE CAP CORRODED UNDER NUT PLATES.
SDR 2007UALA05218Floorbeam · corrodedAFT PIT "T" CAP CORRODED STA 1197, LBL 34 TO LBL 41.SDR USAA920080054Floorbeam · corrodedPIT - MAJOR REPAIR - C4 CHECK, LEVEL 2 CORROSION ON FLOORBEAM, BS 1661, BL 0 - LBL 58.22. REPAIRED FLOORBEAM, BS 1661, BL 0 - LBL 58.22 IAW B757 SRM 53-00-51 REPAIR 5.SDR USAA920080066Floorbeam · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FLOORBEAM, BS 328, LBL 12. REPLACED FLOORBEAM, BS 328, LBL 12 IAW B737 SRM 53-10-51-2R5.SDR 2007UALA05171Floorbeam · crackedFLOORBEAM CRACKED IN UPPER CHORD BS 325 LBL 10 AND ADJACENT FASTENER SHEARED.SDR USAA920080063Strap · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FLOORBEAM STABILIZER STRAP, BS 328, RBL 48. REPAIRED FLOORBEAM STABILZER STRAP, BS 328, RBL 48 IAW B737 SRM 53-10-51.SDR USAA920080064Strap · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FLOORBEAM STABILIZER STRAP, BS 312, LBL 45. REPLACED FLOORBEAM STABILZER STRAP, BS 312, LBL 45 IAW B737 SRM 53-10-51.SDR F3LA200700397Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED FLOORBEAM AT FR16, STA Y254, CORRODED ON THE TOP CAP. DETERMINED CORROSION TO BE OUT OF LIMITS IAW SRM 53-11-14. REMOVED AND REPLACED FLOORBEAM FROM FR12 THRU FR24, STA 254, IAW SRM 52-42-11 AND 51-72-11.SDR F3LA200700384Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM AT Y1292 AND FR16, AT ATTACH POINT. REMOVED AND REPLACED FLOORBEAM AT Y1292 IAW SRM 51-42-11.SDR 2007UALA05116Floorbeam · corrodedCABIN DIAGONAL FLOOR SUPPORT CORRODED BS 1006 LBL 1" - 6". MAJOR REPAIR ACCOMPLISHED: INSTALLED NEW FLOOR SUPPORT.SDR 2007UALA05115Floorbeam · corrodedAFT LT LAV FLOOR STRUCTURE STA 1016 FLOORBEAM LBL5 WL 208 IS CORRODED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR ANGLE AND STRAP REPAIR. INSTALLED NEW INTERCOSTALS AT RBL 3" AND LBL 3".SDR F3LA200700398Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED FLOORBEAM AT Y765, FR68, CORRODED. DETERMINED CORROSION TO BE OUT OF LIMITS IAW 53-00-14. REMOVED AND REPLACED FLOOR BEAM AT Y768 IAW SRM 51-42-11.SDR F3LA200700396Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED FLOORBEAM AT Y1292, FR68, CORRODED. DETERMINED CORROSION TO BE OUT OF LIMITS IAW SRM 53-00-14, PAR 4 B. REMOVED AND REPLACED FLOORBEAM Y1292 AT FR 68-69 IAW SRM 51-42-11 AND 51-44-11.SDR F3LA200700394Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED FLOORBEAM AT Y1292, FR66, CORRODED AT NUTPLATE HOLES. REMOVED AND REPLACED FLOORBEAM AT Y1292, FR66, IAW SRM 51-42-11.SDR F3LA200700380Floorbeam · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED FLOORBEAM AT BS -Y1292 HAD CORROSION AT NUT PLATE HOLES BETWEEN FR 68 AND FR 69. FOUND CORROSION TO BE OUT OF LIMITS IAW SRM 53-00-14, FIG. 102. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-11.SDR 08FDEA00003Floorbeam · crackedCROSSBEAM AT FR 65 WITH DEFORMITY BETWEEN Y953 AND Y1456. CROSSBEAM AT FR 65 REPAIRED BETWEEN Y953 AND Y1456 IAW SRM 53-17-15, FIG 203, SHEET 1 AND 2.SDR 08FDEA00002Floorbeam · crackedCROSSBEAM AT FR 66 WITH DEFORMITY BETWEEN Y953 AND Y1456. CROSSBEAM AT FS 36 REPAIRED BETWEEN Y953 AND Y1456 IAW SRM 53-10-15, FIG 205, SHEET 2.SDR TRAX200701927Floorbeam · corrodedFOUND FS 280 FWD FLOORBEAM ANGLE IN CORRODED.SDR 07FDEA05053Floorbeam · corrodedAFT CARGO COMPARTMENT FLOORBEAM AND FLOOR SUPPORT ARE EXFOILIATED AROUND NUMERIOUS NUTPLATES ON UPPER CHORDS ALONG ENTIRE LENGTH AT F/S 1841 BLENDED WORN AREAS IAW SRM 51-21-01 CHECKED LIMITS ORIGINAL MAT. .094 AFTER REWORK .078 WITHIN LIMITS ON FLOORBEAM, ON SDR 07FDEA05052Floorbeam · corrodedAFT CARGO COMPARTMENT FLOORBEAM AND FLOOR SUPPORT ARE EXFOILIATED ARROUND NUMEROUS NUTPLATES ON UPPER CHORDS ALONG ENTIRE LENGTH AT F/S 1841 BLENDED WORN AREAS IAW SRM 51-21-01 CHECKED LIMITS ORIGINAL MAT. .094 AFTER REWORK .078 WITHIN LIMITS ON FLOORBEAM, ON SDR 2007UALA05079Floorbeam · corrodedCABIN FLOORBEAM CORRODED ON UPPER CHORD, BS 986 RBL 45". SUSPECT NORMAL AC OPERATION. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOOR UPPER BEAM T-CAP.
AC OK FOR SERVICE.SDR USAA920080130Floorbeam · corrodedMCN - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION FLOORBEAM, BS 402, RBL 24, WL 208. REPLACED FLOORBEAM, BS 402, RBL 24, WL 208 IAW B757 SRM 51-40-02.
SDR USAA920080129Floorbeam · corrodedMCN - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION FLOORBEAM, BS 377, LBL 58 - RBL 58. REPLACED FLOORBEAM, BS 377, LBL 58 - RBL 58 IAW USAIRWAYS TYPICAL REPAIR 53-15-01.
SDR USAA920080128Floorbeam · corrodedMCN - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION FLOORBEAM TOP PLATE / FILLER, BS 297 - BS 310, BL 0. REPLACED FLOORBEAM TOP PLATE / FILLER, BS 297 - BS 310, BL 0 IAW B757 SRM 51-40-02.
SDR USAA920080046Floorbeam · corrodedMCN - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON FLOORBEAM, BS 1640, LBL 58 - RBL 58, WL 208. REPAIRED FLOORBEAM, BS 1640, LBL 58 - RBL 58, WL 208 IAW USAIRWAYS TYPICAL REPAIR 53-15-02.
SDR USAA920080045Floorbeam · corrodedMCN - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON FLOORBEAM SUPPORT, BS 310 - BS 324, LBL 20, WL 208. REPLACED FLOORBEAM SUPPORT BS 310 - BS 324, LBL 20, WL 208 IAW B757 SRM 51-40-02.SDR COMA0760711Attach Fitting · crackedLONGITUDINAL FLOORBEAM ATTACH CLIP CRACKED AND HAS LOOSE FASTENERS, INBOARD SIDE OF BEAM FS 280, LBL 9. REMOVED AND REPLACED CLIP IAW CRJ SRM 51-42-21.
SDR COMA0760710Attach Fitting · crackedLONGITUDINAL FLOORBEAM ATTACH CLIP CRACKED FS 280, LBL 10 OUTBOARD SIDE OF BEAM. REMOVED AND REPLACED CLIP IAW CRJ SRM 51-42-21.SDR USAA920071342Floorbeam · corrodedSAL - MAJOR REPAIR - C-7 CHECK - CORROSION ON CABIN BEAM, BS 3101/FR 65+23" - BS 3158/FR 66+4", Y512. REPLACED CABIN BEAM BS 3101/FR 65+23" - BS 3158/FR 66+4", Y512 IAW A320 SRM 51-72-11.SDR USAA920080111Floorbeam · corrodedMCN - MAJOR REPAIR - C4 CHECK - LEVEL 2 CORROSION ON FLOORBEAM, BS 345, LBL 58 - RBL 58. REPAIRED FLOORBEAM, BS 345, LBL 58 - RBL 58 IAW USAIRWAYS TYPICAL REPAIR 53-15-01.
SDR USAA920071389Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3101 /FR 65, -Y1292. REPLACED CABIN FLOORBEAM, BS 3101 /FR 65, -Y1292 IAW A320 SRM 51-72-11.SDR USAA920071387Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3207 / FR 67, -Y1292. REPLACED CABIN FLOORBEAM, BS 3207 / FR 67, -Y1292 IAW A320 SRM 51-72-11.SDR USAA920071325Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3158 / FR 66 - BS 3366 / FR 70, -Y765. REPLACED CABIN FLOORBEAM, BS 3158 / FR 66 - BS 3366 / FR 70, -Y765 IAW A320 SRM 51-72-11.SDR TRAX200701900Floorbeam · corrodedFOUND FLOORBEAM 36 CORRODED.
SDR TRAX200701899Floorbeam · corrodedFOUND FLOORBEAM 41 CORRODED.
SDR DHL2007742061Floorbeam · crackedSPLICE PLATE (FLOORBEAM) AT LBL 65 BS 600 HAS CRACK FROM SLOT RADIUS. REMOVED CRACK FLOORBEAM SPLICE PLATE IAW B-727 SRM 51-30-2 AND AEI DRAWING NR AE727-3-A004. FABRICATED NEW SPLICE PLATE FROM 2024-T3 0.125" PO NR 9005802 APPROXIMATE DIMENSION 10.9375" BY SDR DHL2007742060Floorbeam · crackedFLOORBEAM SPLICE PLATE AT LBL 65 BS 660 HAS CRACK FROM SLOT RADIUS. REMOVED CRACK FLOORBEAM SPLICE PLATE IAW B727 SRM 51-30-2 AND AEI DRAWING NR AE727-3-A004. FABRICATED NEW SPLICE PLATE FROM 2024-T3 0.125" PO NR 9005802 APPROXIMATE DIMENSION 10.9375" BY 6.7SDR DHL2007742058Floorbeam · crackedFLOORBEAM SPLICE PLATE AT LBL 65 HAS CRACK FROM SLOT RADIUS BS 680. REMOVED CRACKED FLOORBEAM SPLICE PLATE IAW B-727 SRM 51-30-2 AND AEI DRAWING NR AE727-3-A004. FABRICATED NEW SPLICE PLATE FROM P/N 2024-T3 0.125 PO NR 9005802 APPROXIMATE DIMENSION 10.625" BYSDR SWAA076071Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 12. REPAIRED FLOORBEAM PER SRM.SDR ASAA0772398Floorbeam · corrodedAFT CABIN FLOORBEAM BS 947 LBL 53 CORRODED. REPAIRED WITH REPAIR PART.SDR ASAA0772429Floorbeam · corrodedAFT CABIN FLOORBEAM BS 986 LBL 52 TO RBL 52 CORRODED. REPAIRED WITH REPAIR PART.SDR ASAA0772396Floorbeam · corrodedPASSENGER COMP FLOORBEAM BS 344 RBL 4 TO LBL 56 CORRODED. REPAIRED WITH REPAIR PART.SDR SWIA200719336Floorbeam · crackedFOUND AT C-CHECK, BS 280 AT LBL 9 LOWER FLOORBEAM IS CRACKED. COMPLIED WITH REPAIRS PER CRJ200 REO 601R-53-11-171.
SDR SWIA200719335Floorbeam · crackedFOUND AT C-CHECK, FLOORBEAM IS CRACKED AT BS 280 AND LBL9. INSTALLED REPAIR PARTS IAW REO 601R-53-11-136.
SDR SWIA200719334Floorbeam · crackedFOUND AT C-CHECK, STA 280 RIGHT UPPER FLOORBEAM ANGLE IS CRACKED AT RBL9. COMPLIED WITH REPAIRS IAW REO 601-53-11-136.
SDR SWIA200719333Floorbeam · crackedFOUND AT C-CHECK, FLOORBEAM STA 280 AND RBL9, LOWER FLOORBEAM IS CRACKED. COMPLIED WITH REPAIR PER REO 601R-53-11-1305 AND REO 601R-53-11-171.SDR SWIA200719315Floorbeam · corrodedCOCKPIT FLOOR SUPPORT BEAM HAS CORROSION, FOUND AT C-CHECK. REPLACED COCKPIT FLOOR SUPPORT PER CRJ7/9 SRM 51-23-00- P 10-11 AND 51-42-06 P7-8 AND SB670BA-53-026.
Back to JASC 5315