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 USAA2009052891322Floorbeam · corrodedCLT - Q1 - MAJOR REPAIR - NR 03C10753060/008 - LEVEL 2 EXFOLIATION CORROSION ON FLOOR BEAM T-CAP AT BS328 AT RBL12 THRU 24 & RBL56. REPAIRED FLOOR BEAM T-CAP AT BS328 AT RBL12 THRU 24 & RBL56 IAW B737 SRM 53-10-51.SDR FDEA200905281833Floorbeam · damagedFOUND NON RECORDED CROSSBEAM REPAIR C 57RH, AD-Y-805. SPLICE REPAIR RENEWED IAW SRM 53-10-15 FIG 208.SDR FDEA200905281831Floorbeam · corrodedFOUND CORROSION ON CROSSBEAM C 56LT SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR FDEA200905281829Floorbeam · corrodedFOUND CORROSION ON CROSSBEAM C 58 LT AND RT SPLICE REPAIRS PERFORMED IAW SRM 53-10-15 FIG 207.SDR FDEA200905281827Floorbeam · corrodedFOUND CORROSION ON SHORT CROSSBEAM C 67 RT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW. SRM 51-72-10.SDR FDEA200905281826Floorbeam · corrodedFOUND CORROSION ON CROSSBEAM C 67 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR IPXA09556262Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION ON BS 1200 FLOORBEAM FWD FLANGE BL 0 TO LBL 55 WL 208. BLENDED CORROSION FROM FLOORBEAM BS 1200 LBL BL 0 AND SUBMITTED ENGINEERING, FABRICATED REPAIR ANGLE, NDI ALL HOLES, ALODINE AND PRIMED PARTS INSTALLED REPAIR ANGLE PER ER E09SDR SWAA093441Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BETWEEN RBL 40 TO LBL 19. REPAIRED BEAM PER SRM.SDR FDEA200905271810Floorbeam · crackedBULK CARGO COMPARTMENT FR 66 BETWEEN SEAT TRACKS NR 3 AND 4 RT MAIN DECK CARGO FLOORBEAM CRACK AT VERTICAL STIFFENER. REMOVED CRACK AND INSTALLED CROSSBEAM REPAIR AT CRACKED STIFFENER AT FLOORBEAM IAW SRM 53-10-15,FIG 211,PAGE 389/390SDR ASAA0995768Floorbeam · corrodedBS 771, RBL 3 FLOOR SUPPORT HAS CORROSION IN NUTPLATE AT FLOOR PANEL .SDR ASAA0995767Floorbeam · corrodedBS 771, RBL 8 FLOOR SUPPORT HAS CORROSION IN NUTPLATE AT FLOOR PANEL SPLICE JOGGLE. REPAIRED FLOOR SUPPORT IAW SRM.SDR ASAA0995766Floorbeam · corrodedBS 771, RBL 3, FLOOR SUPPORT HAS CORROSION IN NUTPLATE HOLES AT FLOOR PANEL SPLICE JOGGLES. REPAIRED FLOOR SUPPORT WITH SPLICE.SDR ASAA0995773Floorbeam · corrodedFLOOR SUPPORT HAS CORROSION IN NUTPLATE HOLES AT FLOOR PANEL SPLICE JOGGLE. REMOVED AND REPLACED CARGO TRACK TIE DOWN.SDR ASAA0995772Floorbeam · corrodedCORROSION AT NUMEROUS LOCATIONS ON FLOORBEAM STA 986 FROM RBL 45, WL 208 AFT CABIN. REPAIRED FLOORBEAM PER SRM.SDR ASAA0995771Floorbeam · corrodedAREAS OF CORROSION AT STA 951 FROM RBL 51 WL 208 AFT CABIN. REMOVED AND REPLACED INTERCOSTAL.SDR ASAA0995770Floorbeam · corrodedNUMEROUS AREAS OF CORROSION AT FLOORBEAM STA 947.5 FROM RBL 11 TO LBL 4 WL 208 AFT CABIN. REPAIRED FLOORBEAM.SDR ASOA200900587Bracket · crackedFS 280 FLOORBEAM T-BRACKETS CRACKED AT LBL 9 AND RBL 9. REMOVED FLOORBEAM T-BRACKETS IAW SRM 51-42-06 & SRM 51-42-21. LOCATED, DRILLED AND PREPPED BRACKETS IAW SRM 51-40-11. INSTALLED BRACKETS IAW SRM 51-42-21. APPLIED PRIMER & TOPCOAT IAW SRM 51-25-06 & 5SDR ASAA0995741Floorbeam · corrodedFLOOR SUPPORT SPLICE CHANNEL IS CORRODED AT NUTPLATE LOCATIONS. REMOVED AND REPLACED DAMAGED SECTION OF FLOOR SUPPORT.SDR FDEA200905261799Floorbeam · crackedFWD CARGO COMPARTMENT FR 25 BETWEEN SEAT TRACKS NR 2 AND NR 3 RT MAIN DECK CARGO FLOORBEAM CRACKED ON VERTICAL STIFFENER. CUT OUT DAMAGED AREA AND INSTALLED CROSSBEAM REPAIR AT CRACKED STIFFENER AT FR 25 BETWEEN SEAT TRACKS NR 2 AND NR 3 RT IAW A300-600 FREIGSDR FDEA200905261798Floorbeam · crackedBULK CARGO COMPARTMENT FR 66 BETWEEN SEAT TRACKS NR 3 AND NR 4 LT AT VERTICAL STIFFENER ON MAIN DECK CARGO FLOORBEAM CRACKED. ROUTED OUT CRACK AND INSTALLED CROSSBEAM REPAIR AT CRACKED STIFFENER AT FR 66 BETWEEN SEAT TRACKS NR 3 AND NR 4 LT IAW A300-600 FREIGSDR IPXA09556296Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION ON TOP OF FLOORBEAM AT BS 100 LBL 7-55 WL 208. REPAIRED PER ATS ER 09-2958.SDR IPXA09556259Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION ON TOP OF FLOORBEAM AT BS 1200 LBL 55 RBL 55 WL 208. REPAIRED PER ATA ER 09-2975 DATED 07JUN09.SDR CALA2009052700282Floorbeam · corrodedSUPPORT TASK: CABIN FLOORBEAM UPPER CORD HAS CORROSION STA 1640 LBL 30 TO RBL 20. REPAIRED FLOORBEAM REF SRM 53-00-51 REPAIR 3.SDR USAA2009052991342Floorbeam · corrodedCLT - C4 - MAJOR REPAIR - NR 19T22053007/026 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT BS365.25, BETWEEN RBL24 TO RBL45. REPAIRED FLOORBEAM AT BS365.25, BETWEEN RBL24 TO RBL45 IAW US AIRWAYS EA 101164.SDR FDEA200905231774Floorbeam · crackedFWD CARGO COMPARTMENT FR 27 BETWEEN SEAT TRACKS NR 2 AND NR 3 RT AT MAIN DECK CARGO FLOORBEAM HAS CRACK REMOVED CRACK ON FLOORBEAM AND INSTALLED CROSSBEAM REPAIR AT CRACKED STIFFENER AT FR 27 BETWEEN SEAT TRACKS NR 2 AND NR 3 RT IAW A300-600 FREIGHTER SRM 53-1SDR USAA2009052991344Floorbeam · corrodedCLT - Q1 - MAJOR REPAIR - NR 03C10853029/006 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS967 BETWEEN LBL10 TO LBL46. REPAIRED FLOORBEAM T-CAP AT BS967 BETWEEN LBL10 TO LBL46 IAW B737 SRM 53-60-51.SDR CALA2009052700276Floorbeam · corrodedB737-53-0738 AFT ENTRY FLOORBEAM STA 986.5 HAS CORROSION AT NUT PLATE HOLE APPROX RBL 4. REMOVED DAMAGED SECTION AND INSTALLED PARTS REF SRM 53-00-51 REPAIR 1.SDR ASOA200900571Floorbeam · corrodedFS 280.00 FLOOR SUPPORT BEAM HAS CORROSION ON UPPER FLANGE AT LBL 9.00 & RBL 9.00. REMOVED CORRODED SECTION OF FLOOR SUPPORT IAW REO 670-53-11-414. FABRICATED AND INSTALLED UPPER FLANGE REPAIR FILLERS. TREATED & PRIMED REWORKED SECTION.SDR SWAA093349Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 771,RBL 7. REPAIRED BEAM PER SWA EA.SDR SWAA093348Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 771,RBL 2. REPAIRED BEAM PER SWA EA.SDR SWAA093347Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOOR BEAM CORRODED AT BS 771, LBL 12. REPAIRED BEAM PER SWA EA.SDR SWAA093346Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOOR BEAM CORRODED AT BS 771, LBL 7. REPAIRED BEAM PER SWA EA.SDR SWAA093345Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO FLOOR BEAM CORRODED AT BS 771, LBL 2. REPAIRED BEAM PER SWA EA.SDR SWAA093310Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOOR BEAM CORRODED AT BS 771, LBL 18. REPAIRED BEAM PER SWA EA.SDR SWAA093300Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOOR BEAM CRACKED BETWEEN BS 655 TO BS 670, BBL 0, WL 207. REPAIRED BEAM PER AAR EA.SDR SWAA093299Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 666 TO BS 677, BBL 0, WL 203. REPAIRED BEAM PER AAR EA.SDR SWAA093298Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 664 TO BS 667, BBL 0. REPAIRED BEAM PER AAR EA.SDR SWAA093288Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOOR BEAM CRACKED BETWEEN BS 715 TO BS 716, BL 0, WL 207. REPAIRED BEAM PER AAR EA.SDR SWAA093286Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOOR BEAM WEB CRACKED BETWEEN BS 707 TO BS 716, RBL 24.5. REPAIRED BEAM PER AAR EA.SDR A6WA200940276Floorbeam · crackedMWC 135174-136 - FLOORBEAM LOWER FLANGE AT FS 280.00, LBL 9.00 CRACKED IN 2 LOCATIONS. FLOOR BEAM LOWER FLANGE AT FS 280.00, LBL 9.00. REPAIRED IAW 601R-53-11-171 REV. D REPAIR SCHEME B. (K)SDR USAA2009052291263Floorbeam · corrodedCLT - C4 - MAJOR REPAIR - NR 19T22053007/009 - LEVEL 2 EXFOLIATION CORROSION ON TOP OF FLOORBEAM AT BS365.25 BETWEEN RBL24 TO RBL45.5. REPAIRED FLOORBEAM AT BS365.25 BETWEEN RBL24 TO RBL45.5 IAW US AIRWAYS TYPICAL REPAIR 53-15-01.SDR USAA2009052191255Floorbeam · corrodedCLT - Q1 - MAJOR REPAIR - NR 03C10753060/022 - LEVEL 2 EXFOLIATION CORROSION FLOOR BEAM AT BS270 BETWEEN LBL20.5 TO RBL17. REPAIRED FLOOR BEAM AT BS270 BETWEEN LBL20.5 TO RBL17 IAW US AIRWAYS TYPICAL REPAIR 53-20-08.SDR FDEA200905191743Floorbeam · crackedAFT LOWER CARGO COMPARTMENT R/H SIDE FR 60,MAIN UPPER DECK FLOORBEAM CRACKED,BETWEEN SEAT TRACKS NR 4 & 5,CRACK .250 IN LONG CUT OUT DAMAGED SECTION OF FLOORBEAM AND INSTALLED CROSSBEAM REPAIR AT CRACKED STIFFENER AT FR 60 BETWEEN SEAT TRACKS NR 4 RT & 5 RT SDR SWAA093247Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, LBL 24.5. REPAIRED BEAM PER AAR EA.SDR A6WA200940291Floorbeam · corrodedFS 280, LBL 9.0 TO RBL 9.0, CORROSION FOUND ON FWD FLOOR ANGLE UPPER SURFACE. CORROSION REMOVED ON FWD FLOOR ANGLE AT FS 280 BTW LBL 9 AND RBL 9 - OUT OF LIMITS. ANGLE REPLACED. (K)SDR USAA2009052191253Floorbeam · corrodedSAL - C21 - MAJOR REPAIR - NR 6201060 - GALVANIC CORROSION ON FLOORBEAM BETWEEN BS986 TO BS1006, LBL16. REPLACED FLOORBEAM BETWEEN BS986 TO BS1006, LBL16 IAW B737 SRM 51-10-02.SDR UALA2009051801401Floorbeam · wornMAIN CABIN FLOORBEAMS FLANGE WORN AT CLIPNUT HOLES BS 1197 - BS 1197, RBL 12 - 50. MAJOR REPAIR ACCOMPLISHED, CUTOUT DAMAGE AND INSTALLED REPAIR STRAP AND ANGLE DOUBLER.SDR USAA2009060991445Floorbeam · corrodedPIT - MAJOR REPAIR - S3 CHECK - CORROSION ON FLOORBEAM AT FR 66, +Y515. REPLACED FLOORBEAM AT FR 66, +Y515 IAW A320 SRM 51-72-11.SDR USAA2009051891219Floorbeam · corrodedCLT - MAJOR REPAIR - Q1 CHECK - NR 03C10853029/002 - LEVEL 2 EXFOLIATION CORROSION ON FLOOR BEAM T-CAP AT BS986, LBL52 TO RBL52. REPAIRED T-CAP AT BS986, LBL52 TO RBL52 IAW B737 US AIRWAYS TYPICAL REPAIR 53-60-01A.SDR FDEA200905151675Floorbeam · damagedFLOORBEAM AT BS 1640, REQUIRES REPLACEMENT DUE TO EXISTING REPAIRS. REMOVED FLOORBEAM AND FASTENERS AT R4 AND L4 DOOR, S17L/R, BS 1640-1681, IAW SRM 51-40-02. ANODIZED NEW FLOORBEAM PER DWG 146N5110. FABRICATED NEW FLOORBEAM PER DWG 146N5110. LOCATED AND D
Back to JASC 5315