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 ZW0A0201111Floorbeam · crackedDURING CHECK-C MAINT FOUND CRACK APPROXIMATELY 1.5 INCHES LONG AT FWD END OF CABIN FLOORBEAM APPROXIMATELY STA 1350, LBL 7. REMOVED AND REPLACED FLOORBEAM PER SPM 6-70-01.SDR 2002UALA00042Floorbeam · corrodedFWD CABIN BS 344, RBL 70R, FLOORBEAM T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. SPLICED IN NEW T-CAP.SDR 2002UALA00041Floorbeam · corrodedMAIN CABIN FLOOR TRANSVERSE FLOORBEAM CORRODED. STA 784, LBL 33.06 MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2005UALA01416Floorbeam · damagedFOUND STA 480 FLOORBEAM IS DAMAGED.SDR 2002UALA00100Floorbeam · corrodedMAIN CABIN LAVATORY SUPPORT BEAM AT STATION 992 BETWEEN RBL 18 TO RBL 44 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGE. FABRICATED AND INSTALLED NEW SUPPORT.SDR SWAA020105Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAMS CRACKED (3 EA) AT BS 747, RBL 14, BS 787, RBL 14 AND BS 945, RBL 3. REPAIRED FLOORBEAMS PER SRM.SDR AWXA200200069Support · corrodedYVR - MAJOR REPAIR - "C" - DURING C-13 CHECK CORROSION WAS FOUND ON UPPER SURFACE OF FLOOR SUPPORT AT BS 992, LBL 24. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS. REMOVED SUPPORT AT BS 992, LBL 24; FABRICATED NEW ATTACH ANGLE AND INSTALSDR 2002UALA00082Floorbeam · damagedAFT CABIN FLOORBEAM ANGLED INTERCOSTAL JUST AFT OF FLOORBEAM 986, EXCESSIVE MATERIAL LOSS AT RBL 14 INCHES AT 996. MAJOR REPAIR ACCOMPLISHED. INTERCOSTAL FLOORBEAM REPLACED.SDR ASAA0210038Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 500A, LEFT BUTTOCK LINE 8, LEFT BUTTOCK LINE 24 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0210037Floorbeam · crackedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 727B, RIGHT BUTTOCK LINE 45 CRACKED. REPAIRED FLOORBEAM PER EA. (M)SDR SWAA020076Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AT BS 867, RBL 14. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR 02FDEA00048Floorbeam · corrodedN 926 CORROSION ON FLOORBEAM BS 344, RBL 5- LBL 65, WL 208 AT FASTENER HOLES. R&R UPR FLOORBEAM.SDR F3LA200200018Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED FLOORBEAM IN CARGO COMPARTMENT CORRODED AT RBL 8 AND PANEL SPLICE AT STA 770 OUT OF LIMITS. FABRICATED REPAIR ANGLES AND INSTALLED PER SRM 53-10-5.SDR F3LA200200019Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED CORROSION ON CARGO COMPARTMENT FLOORBEAM, LBL 2.5, STA 770. REMOVED DAMAGED AREA, FABRICATED REPAIR ANGLE AND INSTALLED PER SRM 53-10-5.SDR 2002UALA00075Floorbeam · corrodedSTATION 1681 FLOORBEAM UPPER CAP FORWARD FLANGE HAD CORROSION AND EXCESSIVE MAT LOSS AT RBL 30 THROUGH RBL 33 RBL 39 THROUGH RBL 41 AND RBL 47. MAJOR REPAIR ACCOMPLISHED. DAMAGE REMOVED, INSTALLED REPAIR ANGLES.SDR 2002UALA00074Floorbeam · damagedAFT CABIN FLOORBEAM AT STATION 1681.1 UPPER CAP LOWER SURFACE HAS EXCESSIVE MATERIAL REMOVED FROM LBL 11 TO LBL 13. MAJOR REPAIR ACCOMPLISHED. DAMAGED AREA TRIMMED OUT AND ANGLE DOUBLER AND TRIPLER INSTALLED.SDR 2002UALA00072Floorbeam · corrodedAFT CABIN FLOORBEAM STATION 1681 FORWARD LOWER SURFACE EXCESSIVE MAT REMOVED AT LBL33. MAJOR REPAIR ACCOMPLISHED. ANGLE REPAIR INSTALLED.SDR ZW0A0200508Floorbeam · corrodedDURING CHECK-C MAINT FOUND CORROSION ON CABIN FLOORBEAM CAP STA 1155, LBL 22 TO 44. REPLACED SUPPORT ASSEMBLY PER SPM 6-70-01 AND SRM 51-30-5.SDR USAA020037Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1.5 INCHES, STATION 1661 LBL 4. INSTALLED T-CAP REPAIR AND FILLER ON FLOORBEAM PER SRM 53-00-51. (M)SDR ASAA0210031Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 460, LBL 20 LBL 39 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0210034Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 500A, LBL 52 CORRODED. REPAIRED CHORD PER EA. (M)SDR ASAA0210032Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 420, RBL 2, RBL 23 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR DL757020027Floorbeam · corrodedTHE UPPER CAP OF THE FS 1681 PASSENGER FLOORBEAM WAS FOUND WITH SEVERAL AREAS OF CORROSION. TO REMOVE THE DAMAGE, THE ENTIRE UPPER CAP WAS TRIMMED OFF. A NEW CAP WAS FABRICATED FROM ALUMINUM EXTRUSION AND INSTALLED PER ER/A 382227-14, REV A.SDR 0200139946Floorbeam · crackedDURING HCK IN ATL, A CRACK WAS FOUND IN THE UPPER VERTICLE FLANGE OF THE STATION 237 FLOORBEAM AT X=6. REPAIRED PER EA 99-185447.SDR 2002UALA00070Floorbeam · corrodedBODY STATION 1197 + 132 LBL 40-44 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR CALA0200008Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 270. REPAIRED FLOORBEAM IAW ECRA 5321-01119.SDR ASAA0210016Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 420, LEFT BUTTOCK LINE 2, LEFT BUTTOCK LINE 54 CORRODED. REPAIRED PER EA. (M)SDR ASAA0210015Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 360, STRINGER 17L-17R CORRODED. REPAIRED PER EA. (M)SDR ASAA0210013Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 787, RIGHT BUTTOCK LINE 27 CORRODED. REPAIRED PER EA. (M)SDR ASAA0210012Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 480, STRINGER 17L CORRODED. REPAIRED PER EA. (M)SDR ASAA0210007Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 400, STRINGER 17L CORRODED. REPAIRED PER EA. (M)SDR TSAA0253034Floorbeam · crackedFOUND CABIN INTERIOR LONGITUDINAL FLOORBEAM UPPER CHORD AND WEB CRACKED AT BS 663.75 BL 0. VERIFIED CRACK REMOVED USING HFEC. REPAIRED LONGITUDINAL FLOORBEAM IAW ECO 223R2 PART II, DEVIATION "C". AIRCRAFT RETURNED TO SERVICE. (M)SDR AWXA200200070Support · corrodedYVR - MAJOR REPAIR - "C" - DURING C-13 CHECK CORROSION WAS FOUND ON UPPER SURFACE OF FLOOR SUPPORT AT BS 986 TO BS 1006, LBL 38. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS. REMOVED SUPPORT AT BS 986 TO 1006, LBL 38; FABRICATED NEW FLOOSDR F3LA200200005Floorbeam · corrodedDURING C-7 CHECK, INSPECTION REPORTED FLOORBEAM AT STA 528, RBL 10, CORRODED. REMOVED DAMAGED PORTION OF FLOORBEAM UPPER CHORD PER SRM 51-30-2. FABRICATED AND INSTALLED REPLACEMENT UPPER CHORD PER SRM 53-10-9.SDR 2002UALA00050Floorbeam · corrodedFORWARD CABIN FLOORBEAM AT STATION 365, RBL9 HAS EXCESSIVE MATERIAL LOSS, MAJOR REPAIR ACCOMPLISHED. REINFORCING REPAIR INSTALLED.SDR UPS02237533Floorbeam · corrodedINSPECTION TYPE:C+SI EXFOLIATION CORROSION ON THE UPPER CHORD FLANGE OF FLOORBEAM AT BS 480 LBL 25 TO 45.SDR ASAA0210003Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 420, LBL 51.5-53 CORRODED. REPAIRED PER EA. (M)SDR ASAA0210002Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM FLANGE AT BS 947, WATERLINE 207 CORRODED. REPAIRED PER EA. (M)SDR 02FDEA00047Floorbeam · corrodedN 676 CORROSION AROUND NUTPLATE HOLES ON LWR CHORD OF 1130 BEAM, LBL 1 TO LBL 38. R&R CHORD PER E.A. 7-5310-62713 & SRM 53-10-1.SDR AWXA200200076Floorbeam · crackedDURING C-13 CHECK A 1/4 INCH CRACK WAS FOUND ON AFT CARGO DOORWAY FLOORBEAM AT BS 727E, STR 24R. MAINTENANCE REMOVED AND REPLACED FLOOR TRACK BETWEEN BS 727 TO BS 877 IAW DWG 65-46592, AND SRM 51-40-2, PG. 1.SDR AWXA200200073Support · corrodedYVR - MAJOR REPAIR - "C" - DURING C-13 CHECK CORROSION WAS FOUND ON UPPER SURFACE OF FLOOR SUPPORT AT BS 1006, RBL 6. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS. REMOVED SUPPORT AT BS 1006, RBL 6; FABRICATED NEW ATTACH ANGLE AND INSTALSDR AWXA200200072Support · corrodedYVR - MAJOR REPAIR - "C" - DURING C-13 CHECK CORROSION WAS FOUND ON UPPER SURFACE OF FLOOR SUPPORT AT BS 967, RBL 20. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS. REMOVED DAMAGED PORTION OF SUPPORT AT BS 967, RBL 20; FABRICATED NEW FLOOSDR AWXA200200071Support · corrodedYVR - MAJOR REPAIR - "C" - DURING C-13 CHECK CORROSION WAS FOUND ON UPPER SURFACE OF FLOOR SUPPORT AT BS 986, RBL 24 TO LBL 24. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS. REMOVED SUPPORT AT BS 986, RBL 24 TO LBL 24; FABRICATED NEW FLOSDR UPS02837437Floorbeam · corrodedINSPECTION TYPE:C2 STA -80 FLOORBEAM AND PRESSURE WEB ARE CORRODED BEYOND LIMITS AT LBL 47-59 APPROX. FABRICATED AND INSTALLED WEB AND FINGER DOUBLERS IAW SRO 8530026, FABRICATED AND INSTALLED FLOORBEAM SPLICE REPAIR IAW 8110-3 DH SK 702-953.SDR ASAA0140191Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOORBEAM BS 986 AND RBL 32 AND WL 208. REPAIRED FLOORBEAM IAW SRM. (M)SDR 2002UALA00035Floorbeam · corrodedBODY STATION 1153 RBL 20-25 LBL 2-35 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2002UALA00034Beam · corrodedBODY STATION 874 LBL 12 TRANSVERSE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SPLICE.SDR 2002UALA00033Floorbeam · corrodedBODY STATION 1219 LBL 20-44 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2002UALA00032Floorbeam · corrodedBODY STATION 1197 + 66 LBL 25-44 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2002UALA00031Floorbeam · corrodedBODY STATION 284 RBL 70 FLOOR EDGE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW EDGE BEAM.
Back to JASC 5315