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 UPS07449291Floorbeam · crackedINSPECTION TYPE:C BULK CARGO COMPT M/D FLOORBEAM LOWER WEB FOUND CRACK AT 1940 RBL 64". CRACK LENGTH .5 INCH. BULK CARGO COMPT M/D FLOORBEAM LOWER WEB REPAIRED AS PER SRM 51-40-02 FIG 1, JUST AT STA 1940 RBL 64 AREA.SDR SIMA200705707Floorbeam · corrodedPREVIOUS REPAIR ON LEFT OMEGA BEAM AT FRAME 20 CORRODED. FABRICATED AND INSTALLED REPAIR DOUBLERS AND FILLERS. CLEANED, TREATED AND RESTORED PROTECTIVE FINISH IAW EMB SRM 53-00-10. RETURNED AIRCRAFT TO SERVICE.SDR AWXA200700260Strap · crackedMCN - FOUND FLOORBEAM STABILIZER STRAP CRACKED, BS 328, LBL 45.5, WL 208. REPAIRED FLOORBEAM STABILIZER STRAP, BS 328, LBL 45.5, WL 208 IAW B737-300 SRM 53-10-51-2R4.SDR 07FDEA00513Floorbeam · crackedFOUND FWD CARGO COMPT, FS 38, FLOORBEAM, LBL66, (1) EA CRACK IN RADIUS 0.380 INCH LENGTH. REPAIRED FLOORBEAM PER A310-200 SRM 53-10-15.SDR 07FDEA00512Floorbeam · crackedFOUND FWD CARGO COMPT, FR36 FLOORBEAM LBL 66 (1) EA CRACK IN RADIUS 0.380 INCH LENGTH. REPAIRED FLOORBEAM FR36 LBL66 IAW A310-200 SRM 53-10-15 PB 201 FIG 201.SDR 07FDEA00511Floorbeam · crackedFOUND FWD CARGO COMPT, FR 38, FLOORBEAM, LBL66, (1) EA CRACK IN RADIUS 0.380 INCH LENGTH. REPAIRED FLOORBEAM PER A310-200 SRM 53-10-15.SDR 07FDEA00510Floorbeam · corrodedFOUND CORROSION IN AND AROUND FASTENER HOLE FR55/58 LT SIDE AFT CARGO COMPARTMENT MDCC FLOORBEAM. REMOVED CORROSION IAW A310-200 SRM 51-74-10 AREA WENT OUT OF LIMITS IAW A310-200 SRM 53-10-15. INSTALLED FABBED REPAIR ANGLE PARTS IAW A310-200 SRM 53-10-15. ASDR GTIA200700012Floorbeam · corrodedCORROSION AFT CARGO CABIN FLOORBEAM. INSTALLED NEW FLOORBEAM.SDR UPS07849372Floorbeam · crackedINSPECTION TYPE:C3 CRACKED END FITTING ON FLOORBEAM AT STA 280, RBL 48 A-PIT DOORWAY UPPER FWD CORNER REMOVED FLOORBEAM END FITTING AT STA 280, RBL 48 A-PIT DOORWAY UPPER FWD CORNER IAW SRM 51-1-20D. FABRICATED AND INSTALLED FLOORBEAM END FITTING AT STA 2SDR DU4R2007070Floorbeam · corrodedFOUND CORROSION ON TOP CENTER OF AFT CABIN FLOORBEAM AT FS 1640. REPAIRED BY CUTTING OUT CORRODED AREA OF UPPER CAP IAW B757 SRM 53-00-51D FIG 206. FABRICATED AND INSTALLED REPAIR PARTS 28” FROM BAC1505-100617, 7.5 FROM BAC1490-2738, DOUBLER 7.5 FROM 7075-TSDR SWAA070879Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 53. REMOVED AND REPLACED FLOORBEAM PER ER.SDR SWAA070912Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 35 TO RBL 5. REPAIRED FLOORBEAM PER SRM.SDR CALA0700068Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES AT STA 986, BL 0 TO LBL 31. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01445.SDR 07FDEA00483Floorbeam · corrodedFOUND MAIN DECK FLOORBEAM AT STA 1166 RBL 30 - 45.5 UPPER CHORD HAS CORROSION. REPAIRED FLOORBEAM STA 1166 RBL 30 - 45.5 IAW SR 27-53-033.SDR K11A2008112091501Floorbeam · corrodedFLOOR SUPPORT CORRODED AT STA 200 LBL 55.SDR GTIA200700011Floorbeam · corrodedCORROSION ON FLOORBEAM. INSTALLED NEW FLOORBEAM.SDR GTIA200700010Floorbeam · corrodedCORROSION AT FWD CABIN FLOOR SUPPORT. INSTALLED NEW FLOOR SUPPORT.SDR UPS07449349Floorbeam · corrodedINSPECTION TYPE:C M/D BS 1940 RBL 89 TO 92 FLOORBEAM UPPER SURFACE FOUND CORRODED. CORROSION BLEND OUT 0.082" X 1" X 1" EXCEED SRM LIMIT. M/D BS 1940 RBL 70" TO 92" RIGHT O/B FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 3.SDR UPS07449296Floorbeam · corrodedINSPECTION TYPE:C BULK CARGO LT STA 1960 LBL 56" FLOOR SUPPORT CORRODED AS MARKED. CORROSION BLEND OUT 0.025" X .5" X 1" EXCEED SRM 53-10-01 FIG 1 LIMITS, BULK CARGO COMPT FLOOR SUPPORT REPLACED WITH EXISTING SPLICE FROM BS 1920-1970 LBL 55 - 57" PER SRM 51-1SDR SWAA070857Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM WEB CORRODED AT BS 986, RBL 50. REPAIRED WEB PER SRM.SDR 07FDEA00477Floorbeam · misrepairedPREVIOUS REPAIR LOCATED ON MAIN CABIN FLOORBEAM FRAME 37 AND BETWEEN SEAT TRACKS 4 AND 5 LT HAS 2 REPAIR ANGLES MEASURING 16.8" BY 1.7" LONG LOCATED AT THE UPPER FLANGE AREA, FWD AND AFT SIDE OF FLOORBEAM. PREVIOUSLY INSTALLED REPAIR LOCATED ON MAIN CABIN FLOSDR USAA07099Floorbeam · corrodedTWO AREAS, 13 INCHES LEFT OF CENTER FLOORBEAM C16 HAS CORROSION. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 53-14-14; CORR LEVEL 1; CORR TASK: JA-220-25503, DEFECT SIZE: 1 X 1 INCH.SDR USAA070100Floorbeam · corrodedFLOORBEAM -Y1292 BETWEEN FRAMES 66 & 68, SEVERAL SPOTS CORRODED. DEFECTIVE PART REPLACED WITH IDENTICAL PART; CORR LEVEL 1; TASK JA-260-53500, DEFECT SIZE: .5 X .5 INCH.SDR USAA070102Floorbeam · corrodedTOP OF BEAM, FWD END OF SEAT TRACK I/B LEFT BEAM HAS CORROSION. REMOVED & REPLACED BEAM PER SRM 51-72-11; CORR LEVEL 1; TASK JA-220-25503, DEFECT SIZE: .5 INCH.SDR UPS07449422Floorbeam · crackedINSPECTION TYPE:C RIGHT BS 340 U/D FLOORBEAM UPPER CHORD TO FRAME CONNECTION AREA FOUND 1EA FASTENER HOLE CRACKED AT U/D FLOORBEAM WEB APPROX .125 INCH. RIGHT BS 340 U/D FLOORBEAM WEB REPAIRED AS PER SRM 53-10-07 FIG 11, JUST BETWEEN RBL 52 AND RIGHT MOST O/BSDR UPS07449417Floorbeam · corrodedINSPECTION TYPE:C M/D BS 860 LBL 80-97 FLOORBEAM FOUND CORRODED. CORROSION BLEND OUT 0.040 X 2 X 2 INCHES EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 860 LBL 65 TO MOST LEFT O/B FLOORBEAM REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR SWIA200717978Floorbeam · cracked280 FLOOR SUPPORT BEAM CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED LT INBD AND OTBD INTERCOSTALS, RT OTBD INTERCOSTAL AND FASTENERS IN RT FLOORBEAM REO 670-53-11-047 REV 'D' P/N 670-53-11-047-5 AND MODSUM DWG I567053110026 REV 'B1'.SDR SWIA200717977Floorbeam · crackedFS 280 FLOOR SUPPORT ANGLES CRACKED LBL9, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED 2 'T' BRACKETS PER MODSUM 1567053110026.SDR UPS07449346Floorbeam · crackedINSPECTION TYPE:C M/D BS 860 LBL 47 TO 49 FLOORBEAM WEB FOUND CRACKED. CRACK LENGTH: .75 INCH. M/D FLOORBEAM WEB REPAIRED AS PER SRM 53-10-07 FTG 11 JUST AT BS 860 BETWEEN LBL 39 & LBL 49.SDR UPS07449318Floorbeam · crackedINSPECTION TYPE:C M/D BS 960 RBL 9 TO 11 FLOORBEAM WEB FOUND CRACKED. CRACK LENGTH .75 INCH. M/D FLOORBEAM WEB REPAIRED AS PER SRM 53-10-07 FIG 11, JUST AT BS 960 BETWEEN RBL 6 AND RBL16 AREA.SDR ASAA0771456Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT FS 986.5. REPAIRED IAW SRM 53-00-51.SDR SWAA070801Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 41 TO RBL 5. REPAIRED FLOORBEAM PER SWA EA.SDR 07FDEA00471Floorbeam · misrepairedPREVIOUS REPAIR MAIN CABIN FLOORBEAM FR 54.3 HAS FLOORBEAM SPLICE SECT REPAIR BETWEEN SEAT TRACKS 3 AND 5 LT, SPLICE SECTION MEASURES 19.9 IN LONG 4EACH REPAIR SPLICE ANGLES 8.8 IN LONG EACH LOCATED ON THE AFT FACE ONLY OF FLOORBEAM ZONE 150. REPAIR AREA WAS SDR USAA070096Floorbeam · corrodedFOUND FLOORBEAM CORRODED, -Y1732 BNTH TAB FITTING AFT RT DOOR. MODIFIED PART INSTALLED PER SRM 53-41-14; CORROSION LEVEL 1; TASK NR JA-260-53500 DEFECT SIZE: 1" BY 1".SDR USAA070098Floorbeam · corrodedFOUND 2 AREAS, TOP SIDE OF FLOORBEAM Y1292 FR 64-49. INSTALLED NEW BEAMS PER SRM 51-42-11; CORROSION LEVEL 1; TASK JA-260-53500, DEFECT SIZE: 1.5" BY 1.5".SDR UPS07449460Floorbeam · corrodedINSPECTION TYPE:C M/D BS 640 RBL 100-108 FLOORBEAM FOUND CORROSION. CORROSION BLEND 0.136 X 1 X 2 INCH EXCEED SRM LIMIT. M/D BS 640 RBL 100-108 FLOORBEAM FITTING REPAIRED AS PER RS R53-25-35757 AND UPS ENGINEERING FILE NUMBER 747-53-20405.SDR UPS07449377Floorbeam · corrodedINSPECTION TYPE:C M/D - LBL 75-97 BS 760 FLOORBEAM CORRODED. CORROSION BLEND OUT 0.044" X 1" X 2" EXCEED SRM 53-10-01 FIG 1 LIMITS. M/D BS 760 LBL 67 TO MOST LEFT O/B FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 3.SDR CALA0700062Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 947, RBL 6 TO LBL 6. A FLOORBEAM REPAIR WAS INSTALLED IAW SRM 53-00-51, FIGURE 201.SDR DL76S070120Floorbeam · corrodedFOUND CORROSION ON FWD CARGO FLOORBEAM UPPER CHORD AT STA 632, LBL 18. REPLACED CHORD SECTION 142T1060-5 PER DWG 143T1209 AND SRM 51-40-02.SDR DL76S070119Floorbeam · corrodedFOUND CORROSION ON FWD CARGO FLOORBEAM UPPER SURFACE AT STA 698, LBL 19. REPLACED UPPER CHORD SECTION PER SRM 51-40-02, PG 1.SDR HNAA0700024Floorbeam · corrodedFORWARD CENTER FLOORBOARD SUPPORT AT FRAME X182.00 IS CORRODED. REPLACED SUPPORT.SDR NOCA04007Floorbeam · corrodedFOUND FLOORBEAM CORRODED STA 365 RBL58. REPAIRED PER NAA EO NR 757-53-048.SDR NOCA03807Floorbeam · corrodedFOUND CORROSION ON HAT CHANNEL ON TOP OF FLOORBEAM STA365 RBL12-RBL50. REMOVED AND REPLACED BOTH HAT CHANNELS ON TOP FLOOR BOARD SUPPORT AT STA 365 RBL12-RBL 50 PER SRM 51-10-02.SDR CALA0700060Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT NUT PLATES ON TOP AND BOTTOM, STA 1016, LBL 6 TO LBL 34. THE FLOORBEAM CHORD WAS REMOVED AND REPLACED IAW ECRA 5310-03851.SDR HNAA0700016Floorbeam · corrodedLEFT HAND FLOORBOARD SUPPORT CAP ANGLE AT X600.000 IS CORRODED.SDR 2007UALA00382Floorbeam · corrodedMAIN CABIN FLOORBEAM UPPER TEE CAP CORRODED STA 324.0 AND RBL 50 WL 208. MAJOR REPAIR ACCOMPLISHED. REMOVED FLOORBEAM TEE CAP FROM LBL 50 TO LBL 55. INSTALLED TEE CAP SPLICE AND STRAP REPAIR.SDR 07FDEA00442Floorbeam · crackedFWD CARGO COMPARTMENT, MDC FLOORBEAM FRAME 21 CRACKED RT SIDE. LENGTH OF CRACK .380 INCH. REPAIRED PER ENG DISPO AND A310-200 SRM SUPP 53-10-15 FIG 201 SHEET 2. MAJOR REPAIR IAW FEDEX GMM 6-2-100. SEE JPF N00344.SDR SWAA070689Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, RBL 9 TO LBL 50. REPAIRED FLOORBEAM PER SRM.SDR 07FDEA00433Floorbeam · crackedFOUND CRACK IN FLOORBEAM UNDER CLS ADAPTER AT FR 58 BETWEEN TRACK 4R AND 5R COMPLIED WITH EA 6-5310-106317 PG 1 REF 4.SDR 07FDEA00428Floorbeam · corrodedMDCC - FLOORBEAM FR 63 HAS CORROSION FROM SEAT TRACK 5L TO 5R. REPAIRED FLOORBEAM AT FR 63 FROM SEAT TRACK 5L TO 5R IAW A310 SRM 51-40-21 AND 53-10-15 FIG 201 SH 17.
Back to JASC 5315