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 SWAA011978Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 308, LBL 11 TO LBL 19. REPAIRED FLOORBEAM PER SRM.SDR USAA010767Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED APPROXIMATELY 2 INCH AREA, BS 1320 RBL 62. DAMAGE REMOVED, REPAIR DOUBLER INSTALLED PER SRM 53-00-51, FIG 205. (M)SDR SIMA200119701Floorbeam · corrodedABI - DURING MBV INSPECTION, CORROSION WAS FOUND ON THE LEFT OMEGA BEAM AT FRAME 20. BEAM WAS REPAIRED IAW EMB SRM AND AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR AWXA0001943Floorbeam · corrodedFLOORBEAM T-CAP HAS CORROSION AT STA 986 I/B OF R-2 DOOR. REMOVED AND REPLACED WITH NEW T-CAP REPAIR STA 986 LBL 28 TO RBL 50 PER EA 03-5310-01179-SS24.SDR AWXA0001941Floorbeam · corrodedFLOORBEAM STA 947 LBL 60 RBL 60 HAS CORROSION ON TOP CAP. REPAIRED TOP CAP LBL 60 TO RBL 60 PER AWA ER 03-5365-01179 DD2.SDR AWXA0001934Crease Beam · crackedD: L/H crease beam cracked / broken at STA 178 W L 207C: Corrective action Fabricated repair clip Per E.R. # 03-5311-01177-DD4 and installed.SDR SIMA200119001Floorbeam · corrodedABI - DURING MBV INSPECTION MAINTENANCE REPORTED THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND TO BE CORRODED. AFTER REMOVAL OF CORROSION IT WAS FOUND TO BE OUT OF LIMITS. OMEGA BEAM WAS REPAIRED IAW EMB SRM AND AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 01FDEA00523Floorbeam · crackedSNRM N 552 MAIN DECK COMPT FLOORBEAM AT BS 1661 FND CRACKED. R&R PER EA 1-5310-57085.SDR AWXA0002138Floorbeam · corrodedDURING D-CHECK INSPECTION FOUND CORROSION ON MAIN CABIN FLOORBEAM BS 312 LBL 8 TO RBL 14 WL 207.5. REMOVED CORROSION AND REPAIRED FLOORBEAM BS 312 IAW B737 SRM 53-10-9.SDR AWXA0001917Floorbeam · corrodedMAIN DECK FLOORBEAM CORRODED UPPER CHORD BOTH SIDES BS 986.5 LBL 21 TO LBL 45. REPAIRED BS 986.5 FLOORBEAM UPPER CHORD IAW B737 SRM 53-00-51 FIG 202.SDR AWXA0001916Floorbeam · corrodedMAIN DECK FLOORBEAM CORRODED UPPER CHORD BOTH SIDES BS 986.5 RBL 7 TO RBL 41. REPAIRED BS 986.5 FLOORBEAM UPPER CHORD IAW B737 SRM 53-00-51 FIG 202.SDR 2001UALA01295Floorbeam · corrodedAFT PIT BS 1241, LBL 26.5, T-CAP IS CORRODED.SDR 2001UALA01294Floorbeam · crackedAFT PIT BS 1285, LBL 2, T-CAP WEB IS CRACKED.SDR 2001UALA01292Floorbeam · gougedAFT PIT BS 1307, RBL 1, T-CAP UPPER FLANGE GOUGED.SDR 2001UALA01290Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AROUND FASTENER HOLES BETWEEN SEAT TRACKS BS 840-889, LBL 54.SDR 2001UALA01288Floorbeam · corrodedAFT PIT FRAME 1285 T-CAP CORRODED UNDER FLANGE RBL 18-40.SDR 2001UALA01285Floorbeam · corrodedAFT PIT T-CAP CORRODED BS 1219, LBL6-RBL26.SDR 2001UALA01283Floorbeam · corrodedAFT PIT T-CAP CORRODED BS 1175, LBL 6-RBL 25.SDR 2001UALA01281Floorbeam · corrodedAFT PIT CORROSION ON LOWER SIDE OF T-CAP, BS 1153 RBL 8-20.SDR 2001UALA01279Floorbeam · corrodedAFT PIT, BS 1131, LBL 43-49, STRAP ON TOP OF FLOORBEAM CORRODED. FABRICATED NEW T-CAP PER BAC DWG 146T1203 AND INSTALLED PER SRM 51-40-2. MAJOR REPAIR.SDR 2001UALA01262Floorbeam · corrodedCABIN FLOORBEAM CORRODED. HEAVY MATERIAL LOSS DURING CORROSION REMOVAL AT BS 324, RBL 41 TO RBL 60. REPLACED T-CAP AND INSTALLED SUPPORT ANGLES. MAJOR REPAIR ACCOMPLISHED.SDR ARWA0010713Floorbeam · corrodedDURING SCHEDULE MAINTENANCE FLOORBEAM AT FS 237 HAS EVIDENCE OF CORROSION UNDER MOON COVER. REMOVED TO EVALUATE. REMOVED CORROSION AT FS 237 IAW SRM 51-21-01 FOUND OUT OF LIMITS IAW SRM 51-21-01. INSTALLED FLOORBEAM REPAIRED IAW SRM 53-21-00 FIG 815.SDR ARWA0010712Floorbeam · corrodedDURING SCHEDULE MAINTENANCE FLOORBEAM AT FS 251 HAS EVIDENCE OF CORROSION. REMOVE TO EVALUATE. REMOVED CORROSION ON FS 251 FLOORBEAM AS PER SRM 51-21-01, FOUND OUT OF LIMITS AS PER 51-21-01. INSTALLED FLOORBEAM REPAIR ON FS 251 IAW SRM 53-21-00 FIG 815.SDR ARWA0010710Floorbeam · corrodedDURING SCHEDULE MAINTENANCE FLOORBEAM FS 281 FROM BL 22L TO BL 22R HAS EVIDENCE OF CORROSION. REMOVED FLOOR TO EVALUATE. REMOVED CORROSION AT FLOORBEAM STA 281 BL 22L TO BL 22R IAW SRM 51-21-01. FOUND OUT OF LIMITS IAW SRM 51-21-01. INSTALLED FLOORBEAM REPSDR ARWA0010708Floorbeam · corrodedDURING SCHEDULE MAINTENANCE FWD ENTRY AREA, STA 281 FLOORBEAM, TOP CAP HAS CORROSION FROM APPROX LBL 48 TO RBL 48. REMOVED CORROSION AT FLOORBEAM STA 281 IAW SRM 51-21-01, FOUND OUT OF LIMITS IAW SRM 51-21-01, INSTALLED FLOORBEAM REPAIR IAW SRM 53-21-00 FIG 8SDR 0104389989Floorbeam · crackedDURING H-CK AT ATL BASE MTC, THE UPPER CAP OF THE STATION 200 FLOORBEAM T-CAP WAS FOUND WITH A CRACK AT X=44 RT. REPAIRED PER EA 99-181292.SDR USAA010850Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 3 INCHES BY 30 INCHES, STATION 328 NR 3 GALLEY 10 INCHES RIGHT OF C/L TO FORWARD SERVICE DOOR. CUT OUT CORROSION OF FLOORBEAM T-CAP, SPLICED IN NEW SECTION PER PER RM 51-40-02. (M)SDR AALA20011356Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAMS AROUND NUTPLATE HOLES. REMOVED CORROSION BY REAMING HOLES AND INSTALLING FREEZE PLUGS PER ESO80559 DATED 6-27-2001. (M)SDR SWAA011943Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 312, WL 208. REPAIRED FLOORBEAM PER SRM.SDR SIMA200117808Floorbeam · corrodedABI - DURING MBV INSPECTION OF THE AIRCRAFT, THE LEFT OMEGA BEAM AT FRAME 20 WAS FOUND TO BE BELOW SRM LIMITS AFTER THE REMOVAL OF CORROSION. REPAIRED AREA IAW EMB145 SRM (1141 REV 12) 53-21-10 PARA 2, PAGE 201, 202 AND FIG 201 SHEET. (M)SDR SIMA200117807Floorbeam · corrodedABI - DURING MBV INSPECTION, THE CENTER GALLEY FLOORBEAM WAS FOUND TO BE BELOW SRM LIMITS AT FRAME 20 AND 22 AFTER THE REMOVAL OF CORROSION. REPAIRED CORRODED AREA IAW EMB145 REPAIR STATEMENT GST-2108/01 AND STANDARD SRM (145/1142 REV 10) PRACTICES. (M)SDR UPS01836377Floorbeam · corrodedINSPECTION TYPE:C2 STA 1580 LBL 24 FLOORBEAM IS CORRODED BEYOND LIMITS. REPAIRED FLOORBEAM IAW 8110-3 APPROVED DH SK 807-644.SDR 2001UALA01213Floorbeam · corrodedBS 1131 LBL 5 T-CAP CORRODED. *S/D* FABRICATED AND INSTALLED T-CAP REPAIR IN ACCORDANCE WITH BAC DWG 146T1060 N-R. MAJOR REPAIR.SDR 2001UALA01212Floorbeam · corrodedBS 1197 RBL22-35 T-CAP CORRODED. *S/D* FABRICATED AND INSTALLED T-CAP REPAIR IN ACCORDANCE WITH BAC DWG 146T1206 N-R. MAJOR REPAIR.SDR 2001UALA01206Floorbeam · corrodedBS 1263 RBL 23-38 T-CAP CORRODED. *S/D* FABRICATED AND INSTALLED T-CAP REPAIR IN ACCORDANCE WITH BAC DWG 146T1209 N-R. MAJOR REPAIR.SDR 2001UALA01184Floorbeam · crackedLT MID CABIN UPPER T-CHORD CRACKED LATERALLY IN VERTICAL LEG, JUST BELOW UPPER RADIUS FILLER, AT BS 520, LBL 24. ACCOMPLISHED ANGLE REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA01182Floorbeam · crackedCABIN FLOORBEAM CLIP CRACKED AT BS 328, RBL 32, WL 200. REPLACED CLIP. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA01168Floorbeam · corrodedFLOORBEAM T-CAP CORRODED STA 380, LBL 48 AND LBL 58. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED T-CAP SPLICE REPAIR.SDR 01FDEA00497Floorbeam · corroded(C53-224-01) CORROSION ON FLOORBEAM AT BS 620, LBL 42, WL 208. *S/D* REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8 FIG 3.SDR AWXA0001904Tee Chord · crackedD: Fwd Cargo Door Lower Cross Beam Cracked Aft End.C: Repaired IAW E.O 52-31-04 Pg 17-36SDR AWXA0001902Floorbeam · corrodedMAIN CABIN BS 986.5 RBL 0 TO LBL 20, FLOORBEAM HAS SEVERAL AREAS OF CORROSION. REMOVED AND REPLACED UPPER T-CHORD IAW B737-300 SRM 53-00-51 PG 207-211.SDR AWXA0001891Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER CHORD CORRODED BS 947 RBL 8.0. REPAIRED BS 947 FLOORBEAM IAW B737 SRM 53-00-51 FIG 202.SDR AALA20011358Floorbeam · corrodedTUL - FOUND FLOORBEAM HAS CORROSION IN LAVATORY PAN HOLES STATION 1322 RIGHT AFT LAVATORY. REMOVED CORROSION PER SRM 51-10-3. INSTALLED REPAIR PER ESO 80559 DATED 6-22-2001. (M)SDR P5CA0100581Floorbeam · corrodedLEVEL 1 CORROSION, FOUND MAIN DECK FLOORBEAM CORROSION ON TOP FLANGE AT STA 2260 RBL 41. REPAIR CARRIED OUT AS PER 53-11-23 & SRM 51-40-04.SDR 0100577Floorbeam · corrodedCORROSION FOUND ON MAIN DECK FLOORBEAM STA 2240 RBL 54 TOP OF CHORD. REPAIR CARRIED OUT AS PER SRM 53-11-23 & SRM 51-40-04.SDR 2001UALA01252Floorbeam · corrodedBS 1109 RBL 45-LBL45 T-CAP CORRODED. *S/D* FABRICATED AND INSTALLED T-CAP REPAIR IN ACCORDANCE WITH BAC DWG 146T1202 N-R. MAJOR REPAIR.SDR 2001UALA01251Floorbeam · corrodedBS 1175 LBL 23-RBL23 T-CAP CORRODED. *S/D* FABRICATED AND INSTALLED T-CAP REPAIR IN ACCORDANCE WITH BAC DWG 146T1205 N-R. MAJOR REPAIR.SDR 2001UALA01246Floorbeam · corrodedBS 1087 RBL40-LBL40 T-CAP CORRODED. *S/D* FABRICATED AND INSTALLED T-CAP REPAIR IN ACCORDANCE WITH BAC DWG 146T1201 N-R. MAJOR REPAIR.SDR 2001UALA01238Floorbeam · corrodedBS 1219 BL 0-RBL45 FRAME T-CAP CORRODED. *S/D* FABRICATED AND INSTALLED T-CAP REPAIR IN ACCORDANCE WITH BAC DWG 146T1207 AND SRM 51-40-02 N-R. MAJOR REPAIR.SDR 2001UALA01223Floorbeam · corrodedBS 1241 RBL10-RBL15 T-CAP CORRODED. *S/D* FABRICATED AND INSTALLED T-CAP REPAIR IN ACCORDANCE WITH BAC DWG 146T1208 N-R. MAJOR REPAIR.
Back to JASC 5315