JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, 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 = '5310' 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 = '5310' 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 DHL2003802547Door Frame · crackedEXTERNAL FUSELAGE FWD PASSENGER DOOR JAMB AFT LWR CORNER CRACKED 0.750 STA 55.000, L20 - L21L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 15, SERVICE REWORK DWG SRO8530021, DWG 5750776. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. TRIMMED OUT DAMAGSDR UPS03841582Bulkhead · crackedINSPECTION TYPE: C1 AFT PRESSURE BULKHEAD IS CRACKED AT STATION 1766 AT RBL 36, 65 INCHES ABOVE FLOOR LEVEL. REMOVED EXISTING REPAIR, CUTOUT CRACKED AREA, NDT VERIFIED NO CRACKS AT CUTOUT, FABRICATED AND INSTALLED FILLER AND REPLACEMENT DOUBLER I.A.W. DWG. SDR AUS20031240Structure · deteriorated(AUS) AIRCRAFT STRUCTURE DETERIORATED. NUMEROUS DEFECTS FOUND DURING INSPECTION IAW AD/400/40. MAIN LANDING GEAR ACTUATOR COLLAR CRACKED AT UPPER BARREL NEAR WELD, FOUND USING MAGNETIC PARTICLE INSPECTION. ENGINE MOUNT BEAM IB MOUNT DOUBLER CRACKED. LOWERSDR C2XA03SH454Door Frame · corrodedSHV-DURING C-CHECK THE CARGO DOOR LOWER CUTOUT BEAM WAS FOUND TO CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR TSAA0253245Structure · corrodedBLENDED REWORK AREA TO A 10 TO 1 RATION SPANWISE. PERFORMED 10X VISUAL TO ENSURE CORROSION COMPLETELY REMOVED. FLAT PEENED, ALODINED AND PRIMED REWORKED AREA WITH BMS 10-11, TYPE 1. FABRICATED EXTERNAL DOUBLER AND REPAIR STRAP FROM .150 INCH 7075-T7351 PLATSDR 03FDEA01886Failsafe · crackedCRACKED FAILSAFE CHORD, BS 804 AT STR 14L.SDR SWAA032459Beam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL BEAM CRACKED AT BS 727A RBL 44 AND 47 WL 208. REPAIRED PER ER.SDR 03FDEA01870Shear Tie · corrodedCORROSION ON FWD CARGO COMPARTMENT SHEAR TIE ON AFT SIDE OF BS 700 FRAME RBL 9 WL 148. REPAIR PER SRM 53-10-4 FIG 13 SHT 1 AT BS 700, RBL 9, WL 148.SDR AMWA78Bracket · wornWHILE PERFORMING AN A-CHECK STRUCTURAL INSPECTION, THE CARGO DOOR UPPER FORWARD GAS SPRING ASSEMBLY BRACKET HAD WORKING RIVETS.SDR AWXA200301455Shear Tie · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK A .5 INCH CRACK WAS FOUND IN FORWARD CARGO COMPARTMENT SHEAR TIE AT BS 500A, STR 28 LT. MAINTENANCE REMOVED CRACKED SHEAR TIE AT BS 500A, STR 28 LT; INSTALLED NEW REPLACEMENT SHEAR TIE IAW SRM 51-40-02 FIG 4 PG 38.SDR AWXA200301452Shear Tie · crackedDURING C-15 CHECK A .375 INCH CRACK WAS FOUND IN FORWARD CARGO COMPARTMENT SHEAR TIE AT BS 500, STR 28 LT. MAINTENANCE REMOVED CRACKED SHEAR TIE AT BS 500, STR 28 LT; FABRICATED A NEW REPLACEMENT SHEAR TIE; INSTALLED REPAIR PART IAW SRM 51-40-02 PG 2-4, 26 & SDR 2003UALA00835Shear Tie · crackedSTA 344 STR 11R SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.SDR ASAA0380705Shear Tie · corrodedOKC - DURING 15K CHECK, FOUND SHEAR TIE IS CORRODED AT FS 1231 IN AFT CARGO BAY. REPLACED SHEAR TIE PER SRM 51-10-2, 3 AND 4. (M)SDR MWEA030440Splice · corrodedAFT BAG PIT LEFT CARGO TRACK SPLICE PLATE CORRODED AT FRAME STATION 1212. FABRICATED AND INSTALLED SPLICE.SDR 03FDEA01860Shear Tie · corrodedCORROSION (C53-111-01, 2) FWD CARGO COMPARTMENT SHEAR TIE ON AT SIDE OF BS 700 FRAME LBL 9 WL 148.SDR 03FDEA01864Shear Tie · corrodedCORROSION (C53-111-01, 2) FWD CARGO COMPARTMENT SHEAR TIE ON AFT SIDE OF BS 700 FRAME LBL 9 WL 148.SDR GTIA031031Beam · corrodedFTW - AFT CARGO LOWER DOOR JAMB HAS CORROSION FS 1155-1231. REMOVED JAMB BEAM FS 1117-1250. LOCATED AND DRILLED NEW JAMB BEAM. INSTALLED AFT PIT JAMB BEAM. (M)SDR GTIA031032Beam · corrodedFTW - FOUND MID CARGO DOOR LOWER JAMB HAS CORROSION FS 674-693. REMOVED JAMB BEAM. LOCATED AND DRILLED JAMB BEAM. INSTALLED MID PIT JAMB BEAM. (M)SDR SWAA032413Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND 2 EA FUSELAGE FRAME SHEAR TIES CORRODED AT BS 847, RBL 3, WL 149, AND BS 767, RBL 7, WL 149. REPAIRED SHEAR TIES PER SRM.SDR SWAA032406Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CORRODED AT BS 867 TO BS 887, LT SIDE. REPAIRED CREASE BEAM PER SRM.SDR USAA030242Plate · crackedFOUND SUPPORT PLATE CRACKED .62 INCH, FRAME 47/51 S39R FLOOR SUPPORT PLATE. DEFECTIVE PART REPLACED WITH IDENTICAL PART IAW SRM 51-72-11. (M)SDR SWAA032397Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME SHEAR TIE CRACKED AT BS 887, STRINGER 14R. REPAIRED SHEAR TIE PER SRM.SDR 2003UALA00820Shear Tie · corrodedSHEAR TIE HAS CORROSION, STA. 1628 TO STA 1620, AND STR 29L AND 28L. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW SHEAR TIE.SDR GTIA031036Stop Fitting · out of limitsFTW - AFT CARGO DOOR JAMB SURROUNDING HAS 9 SET SCREWS CORRODED. DOOR STOP FITTING ON AFT SIDE OF AFT CARGO DOOR FRAME IS OUT OF LIMITS. INSTALLED NEW DOOR STOP FITTING. (M)SDR 2003UALA00818Shear Tie · corrodedAFT PIT, STA 1520 & STR 29R AND 29L, SHEAR TIE HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW SHEAR TIE.SDR A6WA200360065Door Frame · crackedAFT PAX DOOR, AFT SIDE FRAME, HAS TWO CRACKS APPROXIMATELY .75 INCH LONG NEAR DOOR SNUBBER ATTACHMENT AREA. MAINTENANCE COMPLIED WITH PERMANENT REPAIR. INSTALLED REPAIR PLATE HC521H9032-200 IAW BAE FAX BARA/AVR/6571/03-MK. (M)SDR 2003UALA00816Shear Tie · crackedSTA 616 STR 7L SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.SDR 2003UALA00814Shear Tie · crackedSTA 500A STR 7R SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.SDR UPS03841519Window Frame · corrodedCAPTS WINDOW FRAME CORROSION. REMOVED CORROSION & APPLIED ZINC CHROMATE. LOWER CORNER IN SERVICEABLE CONDITION. OK TO CONTINUE.SDR 2003UALA00810Shear Tie · crackedSTA 597 STR 7R SHEAR TIE IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.SDR GTIA030947Beam · corrodedFTW - FOUND MID PIT STRINGER 28R JAMB BEAM CORRODED AT DOOR OPENING. REMOVED DOOR JAMB BEAM. DRILLED AND LOCATED NEW JAMB BEAM. INSTALLED NEW DOOR JAMB BEAM. (M)SDR CALA0300638Frame · corrodedMAINTENANCE DISCOVERED HEAVY CORROSION TO THE UPPER SURFACE OF THE HORIZONTAL LEG AND FORWARD SURFACE OF THE VERTICAL LEG ON THE LOWER OUTBOARD FRAME AT BULKHEAD STA 227.8. THE CORROSION WAS CENTERED AT BL 0.0 AND RAN FROM LBL 10 TO RBL 10.SDR 2003UALA00803Shear Tie · crackedCRACK IN STR 11R FRAME ANGLE AT BS 706. MAJOR REPAIR ACCOMPLISHED. REPLACED CLIP.SDR 2003UALA00802Shear Tie · crackedSHEAR TIE AT STA 639 BELOW STR 7 LT IS CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE.SDR 2003UALA00801Shear Tie · crackedCRACK IN STR FRAME SHEAR TIE AT BS 663.75. MAJOR REPAIR ACCOMPLISHED. REPLACED STR SHEAR CLIP.SDR 2003UALA00791Shear Tie · crackedCRACK IN STRINGER-FRAME SHEAR TIE AT BS 663.75. MAJOR REPAIR ACCOMPLISHED. REPLACED STR SHEAR CLIP.SDR SWAA032322Shear Tie · brokenDURING SCHEDULED D CHECK, FOUND SHEAR TIE DAMAGED AT BS 400, STRINGER 14R. REPAIRED SHEAR TIE PER SRM.SDR EIA2003135Structure · damagedBS 1760 STR 49 RT HAS CORROSION ON STRUCTURE LOWER SURFACE. REPLACED DAMAGED STR FROM BS 1740-1770 IAW B747 SRM 53-10-03 FIG 8.SDR 2003UALA00786Window Frame · corrodedFLIGHT DECK 3L WINDOW FRAME HAS CORROSION ON LWR SIDE. MAJOR REPAIR ACCOMPLISHED. REPLACED WINDOW SILL.SDR C2XA03SH390Buttstrap · corrodedDURING C-CHECK THE CENTER BUTTSTRAP AT FR 59-60 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BUTTSTRAP IAW EMB145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA032272Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 13L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR ASAA0380659Door Frame · crackedOKC - DURING 30K CHECK, FOUND L1 DOOR FRAME CRACKED. REPLACED FRAME. (M)SDR ASAA0380654Shear Tie · corrodedOKC - DURING 30K CHECK, FOUND AFT CARGO SHEAR TIE IS CORRODED. REPLACED SHEAR TIE. (M)SDR SWAA032263Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 460 AND BS 480. REPAIRED WEB PER SRM.SDR UPS03441465Angle · crackedINSPECTION TYPE: C, BS 380 LEFT STR 1 VERTICAL SUPPORT ANGLE FOUND CRACKED AS MARKED. COCKPIT BS 380 LEFT STR 1 VERTICAL SUPPORT ANGLE REPLACED AS PER SRM 51-10-01.SDR SWAA032253Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 763, WL 148 AND LBL 3. REPAIRED SHEAR TIE PER SRM.SDR SWAA032244Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 947, STR 23L TO STR 24L. REMOVED AND REPLACED SHEAR TIE SECTION PER SRM.SDR UPS03841393Door Frame · crackedINSPECTION TYPE: ASV, CRACK IN FUSELAGE DOOR JAM, PIT 31. CRACK STARTS AT JAM GOES TO FIRST ROW OF RIVETS AND INCLUDES SECOND LAYER OF SKIN, LOWER AFT CORNER. *S/D* REMOVED DAMAGE, FABRICATED DOUBLER AND TRIPLER, INSTALLED REPAIR PER SRM 53-02-00-0.SDR HNAA030054Door Frame · damagedWHEN LANDING GEAR WAS RETRACTED THE LEFT MAIN GEAR DOOR AMBER LIGHT REMAINED ILLUMINATED. CREW CYCLED GEAR AND LIGHT WENT OUT. AIRCRAFT RETURNED TO FIELD. FOUND THE BOLT FOR THE LT FWD MAIN GEAR DOOR PUSH ROD TO DOOR ATTACH POINT WORN INTO AND JAMMED AGAINST TSDR ASAA0380630Beam · corrodedFOUND DURING 15K CHECK, AFT CARGO BAY DOOR BEAM IS CORRODED IN SEVERAL PLACES. REPLACED DOOR BEAM PER SRM 51-30-5. (M)
Back to JASC 5310