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 SWAA091552Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BETWEEN LBL 5 TO RBL 18. REPAIRED BEAM PER ER.SDR FDEA200903090875Floorbeam · corrodedLAVATORY AREA FLOORBEAM AT STA 328 HAS CORROSION AT APPROX RBL 36 ON THE UPPER CHORD FWD EDGE (MARKED) REMOVED CORROSION 0.080 ORIGINAL 0.025 MATERIAL LOSS FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1. CUT OUT DAMAGE AND FABRICATED REPAIR ON TRAVELER T9/783SDR FDEA200903090874Floorbeam · corrodedMAIN CARGO DECK FLOORBEAM UPPER 'T' BS 1030 HAS CORROSION BETWEEN LBL 0 AND LBL 25 FABRICATED ANGLES REPAIRS FOR FLOORBEAM UPPER 'T' ON MAE TRAVELER T9/783860 IAW WITH SRM 53-10-8, FABRICATED 2 FILLERS BATCH NR 000104977, TREATED AND PRIMED ANGLES REPAIRS, FILSDR FDEA200903090869Floorbeam · corrodedLOWER AFT COMPT LIGHT CORROSION ON UPPER SIDE FLOORBEAM AND ANGLE SUPPORT FLOOR. REPAIRED AREA IAW SRM 53-00-01 FIG 9 VOL I.SDR SWIA200921495Floorbeam · crackedC-CHECK, FS 280 FLOORBEAM CRACKED. REPLACED ANGLES, BRACKETS, CLIPS, AND REPAIRED PER REO.SDR SWIA200921461Floorbeam · crackedC-CHECK, FS 280 SUPPORT ANGLES CRACKED. REPAIRED PER REO.SDR USAA2009042090941Floorbeam · corrodedSAL - C19 - MAJOR REPAIR - GALVANIC CORROSION ON UPPER FLANGE OF FLOORBEAM AT BS 967, RBL 27.5. REPAIRED UPPER FLANGE OF FLOORBEAM AT BS 967, RBL 27.5 IAW B737 SRM 53-30-51.SDR USAA2009040690813Doubler · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 CORROSION ON UPPER CHORD OF EXISTING FLOORBEAM REPAIR DOUBLER. REPAIRED FLOORBEAM REPAIR STRAP IAW B767 SRM 53-00-01, 51-10-02, & 53-00-51.SDR CALA2009030900129Floorbeam · corrodedCORROSION AT FLOORBEAM STA 986.5 RBL 23 - RBL 29 - RBL 34 HOLES. REPAIRED CORROSION AT FLOORBEAM STA 986.5 RBL - 23, RBL - 29 AND RBL - 34 HOLES PER CAL EC/RA 5321-01429, REPAIR B.SDR USAA2009040390797Floorbeam · corrodedSAL - C22 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT BS 344, RBL 5. REPAIRED FLOORBEAM AT BS 344, RBL 5 IAW B737 SRM 53-10-51.SDR USAA2009040190745Floorbeam · corrodedSAL - C22 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT BS 270 BETWEEN LBL 9 TO RBL 9. REPAIRED FLOORBEAM AT BS 270 BETWEEN LBL 9 TO RBL 9 IAW B737 SRM 51-70-12.SDR SWAA091496Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24. REPAIRED BEAM PER SRM.SDR SWAA091495Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 24. REPAIRED BEAM PER SRM.SDR SWAA091494Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM LOWER CHORD CRACKED AT BS 709, RBL 24. REPAIRED BEAM PER AAR EA.SDR SWAA091483Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 708, RBL 24. REPAIRED WEB PER AAR EA.SDR SWAA091476Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM T-CAP CORRODED AT BS 986, BETWEEN RBL 6 TO LBL 6. REMOVED AND REPLACED T-CAP PER SRM.SDR SWAA091474Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOOR FRAME CORRODED AT BS 986, BETWEEN LBL 18 TO LBL 43. REPAIRED T-CAP PER SWA EA.SDR AALA20090331TUL29Floorbeam · corrodedCABIN TRANSVERSE FLOORBEAM CORRODED STATION 328 AREA OF 3 INCHES BY 50 INCHES. REPLACED FLOORBEAM PER ESO61000 DATED 3/4/09.SDR USAA2009041390870Angle · corrodedSAL - C22 - MAJOR REPAIR - GALVANIC CORROSION ON ANGLE OF UPPER FLANGE OF FLOORBEAM AT BS 294.5 BETWEEN RBL 45.5 TO RBL 55. REPLACED ANGLE OF UPPER FLANGE OF FLOORBEAM AT BS 294.5 BETWEEN RBL 45.5 TO RBL 55 IAW B737 SRM 51-10-02.SDR USAA2009040790819Floorbeam · corrodedSAL - C22 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT BS 294.5, BETWEEN RBL 15 TO RBL 45. REPAIRED FLOORBEAM AT BS 294.5, BETWEEN RBL 15 TO RBL 45 IAW B737 SRM 53-10-51.SDR USAA2009040390798Floorbeam · corrodedSAL - C22 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT BS 328, RBL 60. REPAIRED FLOORBEAM AT BS 328, RBL 60 IAW B737 SRM 53-10-51.SDR F3LA2009031300049Floorbeam · corrodedDURING C4/S1 C-CHECK, INSPECTION NOTED CORROSION AT THE NUT CLIP HOLE ON FLOORBEAM -Y1162. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IN REFERENCE TO SRM 51-42-11 AND 53-41-14 FIGURE 11.SDR SWAA091432Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 328, RBL 30. REPAIRED BEAM PER SRM.SDR SWAA091431Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 270, LBL 18. REPAIRED BEAM PER SRM.SDR SWAA091430Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 328, LBL 30. REPAIRED BEAM PER SRM.SDR SWAA091429Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 709 TO BS 713, WL 202, BL 0. REPAIRED WEB PER SI.SDR SWAA091423Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM T-CAP CORRODED AT BS 986, BETWEEN RBL 50 TO LBL 50. REMOVED AND REPLACED FLOORBEAM T-CAP PER SRM.SDR CNMA20090141Floorbeam · crackedFOUND CRACKS ON FLOOR PANEL SUPPORTS AT STD 1980 RBL- 2 AND LBL- 5. DAMAGED FLOORBEAM PARTS REMOVED. NEW FABRICATED SEGMENT PN OAI-53-00121-0013 IAW SRM VOL 3 53-16-01 AND GMM 4.43 USING FASTENERS IAW SRM VOL 2 51-31-01, HL18PB6-4, B/N 69623-01, HL70-6, B/NSDR CNMA2009A0140Floorbeam · crackedFOUND CRACK ON FLOOR PANEL SUPPORT AT STD 1900 LBL - 5. DAMAGED SUPPORT REMOVED NEW FABRICATED PN OAI-53-0011 IAW SRM VOL 3 53-16-01 AND GMM 4.45 USING FASTENERS IAW SRM VOL 2 51-31-01, HL18PB6-4, B/N 89623-01, HL70-6 B/N 53306.SDR CNMA20090135Floorbeam · corrodedCORROSION ON CHANNEL STA 2007, RBL 53. DAMAGED FLOOR SUPPORT REMOVED. NEW FABRICATED PN OAI 53-0003 IAW SRM VOL 3 53-16-01 AND OMNI 4.45 USING FASTENERS IAW SRM VOL 2, 51-31-01, HL18PB5-4, BN 58313-01, HL70-5, BN 39320-03.SDR DL75E090352Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 345 HAS CORROSION AROUND FASTENER HOLES LBL 10 - LBL 20. COMPLIED WITH AT SAA - SAT ON N/R 108681 SAA JOB 82299830001.SDR DL75E090351Floorbeam · corrodedCORROSION ON FLOORBEAM AT FASTENER HOLES STA 1660 AND LBL 9 TO LBL 16 UPPER SURFACE OF BEAM CP53-251-01-02-051/COMPLIED WITH AT SAA, SAT ON N/R 119120 SAA JOB 82302660001.SDR SWAA091405Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24. REPAIRED BEAM PER AAR EA.SDR SWAA091404Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45. REPAIRED BEAM PER AAR EA.SDR AALA20090331TUL26Floorbeam · corrodedCABIN FLOORBEAM AT STATION 294.5 HAS CORROSION ON FOP OF BEAM FROM TOOLING MARKS LOCATED FROM BODY LINE 0 TO RIGHT SIDEWALL. INSTALLED T-CAP REPLACEMENT PER ESO 61000 DATED 3/4/09.SDR DU4R2009317Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND AFT CABIN FLOORBEAM UPPER SURFACE HAS CORROSION AT BS 967 LBL 27-30.SDR DU4R2009313Floorbeam · corrodedDURING SCHEDULED INSPECTION FOUND CORROSION ON UPPER FLOOR BEAM TEE-CAP UPPER SURFACE IN THE AFT CABIN AREA AT BS 1006 BL 10-R.SDR UALA2009031000713Floorbeam · corrodedFWD PIT STA 65+121 TOP CAP OF PIT FLOOR STRUCTURE CORRODED APPROX LBL 16. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF T-CAP, FABRICATED & INSTALLED REPLACEMENT T-CAP CHORD.SDR USAA2009030690517Floorbeam · corrodedCLT - Q4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP SURFACE, BS 986, RBL 5 TO RBL 11. REPAIRED FLOORBEAM T-CAP, BS 986, RBL 5 TO RBL 11 IAW B737 SRM 53-60-1A & 53-00-51-2R-1.SDR UALA2009030400713Floorbeam · corrodedFWD PIT STA 65+121 TOP CAP OF PIT FLOOR STRUCTURE CORRODED APPROX LBL 16. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF T-CAP, FABRICATED & INSTALLED REPLACEMENT T-CAP CHORD.SDR MZZA2009030400022Floorbeam · corrodedCORROSION FOUND AT FWD CABIN FLOORBEAM BS 344 AT LBL4.5, LBL3.5, RBL7 AND LBL8. REPAIR CARRIED OUT IAW EC/RA 5321-01608.SDR MZZA2009030400020Floorbeam · corroded3 AREAS AROUND SCREW HOLES ON CABIN FLOORBEAM BS 986.5 BETWEEN LBL 20 TO LBL40 CORRODED. REPAIR CARRIED OUT IAW EC/RA 5321-01429.SDR FDEA200903030823Floorbeam · corrodedFOUND CORROSION ON CROSS BEAM CONNECTION C 63 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR FDEA200903030816Crossbeam · corrodedFOUND CORROSION ON CROSSBEAM C 56 OUT OF SRM LIMIT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR FDEA200903030812Floorbeam · corrodedFOUND CORROSION ON CROSS BEAM C 67 OUT OF SRM LIMIT. SPLICE REPAIR PERFORMED IAW. SRM 53-10-15 FIG.207SDR MZZA2009030300014Floorbeam · corrodedCORROSION FOUND ON UPPER SURFACE CABIN FLOORBEAM AT BS 344 RBL 2 AND RBL 4. ONE FLANGE TRANSVERSE FLOORBEAM REPAIR CARRIED OUT IAW SRM 53-00-51 REPAIR 1 FIG 203 REV 34.SDR MZZA2009030300013Floorbeam · corrodedCORROSION FOUND ON UPPER SURFACE OF CABIN FLOORBEAM AT BS 986.5 40 LBL REPAIR CARRIED OUT IAW EC/RA 5321-01429 AS PER DETAIL A.SDR MZZA2009030300012Floorbeam · corrodedCORROSION FOUND ON UPPER SURFACE OF CABIN FLOORBEAM AT BS 986.5 40 RBL. REPAIR CARRIED OUT IAW EC/RA 5321-01429 AS PER DETAIL A.SDR IPXA09654962Floorbeam · crackedINSPECTION TYPE:C MAIN EQUIPMENT CENTER BS 246 FLOORBEAM ATTACH CLIP 1EA CRACKED AT LBL 50" ( CRACK 0.875" LENGTH ) FUSELAGE BS 246 LBL 50" MAIN EQUIPMENT CENTER FLOORBEAM ATTACH CLIP REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02.SDR ASAA0944580Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 270 RBL 10 LBL 10 WL 207. REMOVED UPPER ZEE CHORD, FABRICATED & INSTALLED NEW ZEE CHORD PER SRM 51-40-02.
Back to JASC 5315