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 SWIA201333706Beam · corrodedC-CHECK, RT BEAM BS 1088.20 CORRODED BETWEEN RBL 27 AND FLOOR SILL AREA. REPAIRED BEAM AT BS 1088.20 IAW REO. REPLACED BEAM SUPPORT IAW SRM.SDR SWIA201333704Crossbeam · corrodedCORROSION ON BS 1031 CROSSBEAM BETWEEN LBL 9 AND LBL 27 BEAMS. (C-CHECK) REPAIRED F.S. 1031 CROSSBEAM LT SIDE IAW REO.SDR REXA2013061900707Structure · crackedFS 280 IS CRACKED ON UPPER CROSS SUPPORT AT LBL 11 AND THE INBD AND OTBD SUPPORT ANGLES AT LBL 9 AND RBL 9 ARE CRACKED. REPAIRED IAW REO 601R-53-11-136 & 601R-53-11-171.SDR SIMA20130617005Gusset · corrodedDURING MX INSPECTION, FOUND RT LAV GUSSET CORRODED. ACFT REMOVED FROM SERVICE. R & R GUSSET IAW SRM 51-40-02 AND 51-40-09. ACFT RETURNED TO SERVICE.SDR DALA13032643218Angle · crackedDURING INSPECTION, FOUND RT AFT EMERGENCY EXIT DOOR LT LOAD TRANSMITTING PROFILE HAS SEVERAL CRACKS AROUND FASTENER. HFEC IAW NTM 51-10-08, PT6 CONFIRMED CRACKS AROUND FASTENER HOLES. REMOVED CRACKED ANGLE IAW SRM 51-42-11. LOCATED AND DRILLED IAW SRM 51-44SDR USAA2013062400042Crease Beam · corrodedC4 CHECK - LEVEL 2 EXFOLIATION CORROSION ON CREASE BEAM BETWEEN BS1254.5 TO BS1282, RBL54.9. REPAIRED CREASE BEAM BETWEEN BS1254.5 TO BS1282, RBL54.9 IAW EA 104901 & 104902.SDR REXA2013061701194Stowage Box · brokenFIRST OFFICER OXYGEN STOWAGE BOX BROKEN. R & R STOWAGE BOX IAW AMM 35-11-04. CHECKED GOOD.SDR A6WA20134M1028Support Angle · crackedCARGO BAY DOOR LOWER SEAL HAS 2 FWD SUPPORT ANGLES CRACKED UNDER SEAL PLATE. REMOVED ANGLES AND REPLACED WITH NEW SERVICEABLE ANGLES.SDR QXEA2013061501124Structure · corrodedMODERATE TO HEAVY PITTING CORROSION DETECTED AROUND BASE OF LAVATORY DUMP MAST ASSY INTERNAL STRUCTURE BETWEEN STR 25R TO STR 27R, BETWEEN FS X-18.25 TO FS X-5.40. REMOVED LAV SEWAGE DRAIN VALVE FOM REF AMM 38-31-04-000-803. REMOVED LAV FLUSH/FILL RECEPTACLE SDR DALA1315530683Crease Beam · corrodedCORROSION ON AND AROUND RIVET HEADS OF CREASE BEAM WEB BETWEEN BS 1420-1440 MAIN CABIN. REPLACED BEAM IAW SRM 51-40-02, PG 2-3.SDR DALA1315430683Crease Beam · corrodedDISCOVERED CORROSION ON UPPER SURFACE OF SUPPORT ANGLE ON CREASE BEAM WEB JUST FWD OF BS 1040. REPLACED SUPPORT ANGLE IAW SRM 51-40-02.SDR DALA13029463753Crease Beam · corrodedDURING INSPECTION, FOUND PASSENGER CABIN AFT WET AREA FLOOR STRUCTURE RT SIDE BS 947 CREASE BEAM INNER CHORD CORRODED. TASK 53-380. MX R & R CREASE BEAM AT R-2 DOOR AREA INNER CHORD IAW SRM 51-40-02 AND DWG 147A8501.SDR DALA13029433753Structure · corrodedDURING INSPECTION, FOUND PASSENGER CABIN AFT WET AREA FLOOR STRUCTURE BS 986+7" RBL 36:SUPPORT BEAM NUTPLATE HOLE ELONGATED. MX R & R WEB AT BS 986 -1006 IAW SRM 51-40-02 AND DWG 147A5700. R & R SUPPORT ANGLE STA 996-1003 IAW SRM 51-40-02 AND DWG 147A5710. SDR IPXA3M79052Door Frame · crackedINSPECTION TYPE:4C, R-3 FWD LOWER DOOR JAMB CRACKED. REPAIRED R-3 FWD LOWER DOOR JAMB REF SRM 53-40-15, REPAIR 3, FIG 201.SDR UALA2013061404122Door Frame · damagedL3 DOOR FRAME NR 9 BEAM HAS HOLES OVERSIZED. REPAIRED IAW ECRA 5211-01343.SDR UALA2013061404115Door Frame · crackedL4 DOOR UPPER FRAME CRACK. REMOVED DAMAGE. MANUFACTURED AND INSTALLED REPAIR IAW SRM 51-40-02.SDR UALA2013061404114Door Frame · crackedL2 DOOR UPPER FRAME CRACK. REMOVED DAMAGE. MANUFACTURED & INSTALLED REPAIR IAW SRM.SDR UALA2013061404113Door Frame · crackedR5 DOOR UPPER FRAME CRACKED. REMOVED DAMAGE. MANUFACTURED AND INSTALLED REPAIR IAW SRM 51-40-02.SDR UALA2013061404112Door Frame · crackedR2 DOOR FRAME CRACKED. REMOVED DAMAGE. MANUFACTURED AND INSTALLED REPAIR IAW SRM 51-40-02. MAJOR REPAIR.SDR QXEA2013061401086Door Frame · corrodedAFT SERVICE DOOR FRAME AFT SIDE HAS SURFACE CORROSION AROUND SCREW HOLES. REMOVED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. APPLIED ALODINE AND PRIMER IAW SRM 51-21-10-02-01 AND SRM 51-25-10-02-01. APPLIED CSDR QXEA2013061401085Door Frame · corrodedAFT SERVICE DOOR FRAME FWD SIDE SURFACE CORROSION AROUND SCREW HOLES. REMOVED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED AREA CRACK FREE REF NTM 51-00-06-910-801, PT 1. APPLIED ALODINE AND PRIMER IAW SRM 51-21-10-02-01 AND 51-25-10-02-01. APPLIED CPC IAW AMSDR A6WA201306181021Structure · crackedACFT GROUND POWER HAS CRACKS IN STRUCTURE AROUND POWER PLUG. R & R ACFT GROUND POWER SUPPORT IAW SRM 51-42-06, 51-42-21, 51-42-13.SDR GLBA2013061400260Door Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK IN THE CARGO DOOR FRAME IN THE BEND RADIUS AT FS 456.00 AND STRINGER 3L, 3.5" IN LENGTH. REPAIRED IAW EO 13-1900-53-045. MAJOR REPAIR.SDR FDEA201306141292Structure · corrodedCENTER TANK BS 984, LBL 70 IS CORRODED ON UPPER SURFACE. REPAIRED IAW EA 757-5710-16-F4272, REV.SDR FDEA201306141288Support Fitting · crackedDURING HIGH FREQUENCY EDDY CURRENT INSPECTION, OPEN HOLE INSPECTION CARRIED OUT AND FOUND NR 7 LOWER CARGO DOOR FRAME SUPPORT FITTING HOLE "C" WITH CRACK INDICATION AT 12 O'CLOCK POSITION (PLAIN VIEW) AND APPROX 0.080" IN LENGTH. R & R IAW SRM 51-31-01, REV 5SDR FDEA201306141287Support Fitting · crackedDURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION CARRIED OUT AND FOUND NR 4 LOWER CARGO DOOR FRAME SUPPORT FITTING HOLE "D" WITH CRACK INDICATION AT 1 O'CLOCK POSITION AND APPROX 0.085" IN LENGTH. R & R IAW SRM 51-31-01, REV 52 REPAIR CLASSIFIED MAJOR SDR UHLA2013061300274Door Frame · corrodedCORROSION FOUND ON FWD CARGO BAY DOOR FRAME CUTOUT LOWER HORIZONTAL BEAM AFT FINGER DOUBLER. BLENDED AREA MATERIAL, TREATED PRIMED AND TOPCOATED.SDR UHLA2013061300263Door Frame · corrodedCORROSION FOUND ON FWD CARGO BAY DOOR FRAME CUTOUT FWD FINGER DOUBLER. R & R DOUBLER.SDR A6WA20134M1029Support Beam · crackedCARGO DOOR SUPPORT BEAM HAS A CRACKED SUPPORT ANGLE AT THE 621 BULKHEAD AT THE BOTTOM OF THE BEAM. R & R WITH SERVICEABLE PART IAW SRM 51-42-21.SDR UHLA2013061300238Support · corrodedCORROSION ON FWD CARGO DOOR SUPPORT AND LOWER LT SUPPORT NUT PLATE. R & R FWD CARGO DOOR CUTOUT LOWER SEAL REST.SDR FDEA201306131370Crease Beam · crackedCREASE BEAM OTBD ANGLE CRACKED AT BS 1641, S17L. REPAIRED CREASE BEAM IAW EA 757-5361-16-F4175. MAJOR REPAIR.SDR DALA13030429249Beam · corrodedMID CARGO DOOR FRAME HEADER BEAM STA 730-750 HAS CORROSION AROUND RIV-NUTS TASK 53-122-02. REMOVED CORROSION, OUT OF LIMITS. FABRICATED, ALODINED, PRIMED, TOP COATED AND INSTALLED REPAIR DOUBLER IAW 53-60-02.SDR FDEA201306131270Door Frame · crackedMAIN DECK DOOR NR 3 RT AFT DOOR JAMB LOWEST LIGHTENING HOLE FOUND CRACKED. REPAIRED AS PER SRM 53-40-15, FIGURE 201, REPAIR 3, REV.52. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100, REV.116.SDR FDEA201306131269Door Frame · crackedMAIN DECK DOOR NR 3 RT FWD DOOR JAMB LOWEST LIGHTENING HOLE FOUND CRACKED. MAIN DECK DOOR 3R BS 1256.75, LONGERON 27 CRACK WEB REPAIRED AS PER SRM 53-40-15, FIGURE 201, REPAIR 3, REV.52. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100, REV.116.SDR DALA13028801806Failsafe · crackedLEFT BS 955, REAR SPAR BULKHEAD FITTING AREA FOUND CRACKS IN THE FAIL SAFE STRAP, THROUGH THICKNESS REFER ATTACHED FIG. C/A REPAIR ACCOMPLISHED IAW DAL ER/A 513132-14AD, REV ORIG "RETAIN FOR RECORDS" ASSOCIATED ER/A 14-513132 ADDED FOR AC 1806.SDR SWAA2013070517951Crease Beam · crackedCREASE BEAM CRACKED AT BS 178, STRINGER 17L. REPAIRED BEAM IAW EO.SDR SWAA2013061917339Window Frame · crackedNR 7 FASTENER HOLE ON NR 3 COCKPIT WINDOW FRAME AFT CRACKED. REPAIRED FRAME IAW ACO.SDR A6WA201306181020Bushing · corrodedNLG AFT DOOR RT UPPER FITTING ATTACH BUSHING CORRODED. R & R FITTING AND ACCOMPLISHED REPAIR IAW REO 601R-53-11-2319.SDR DALA13028873216Fitting · corrodedDURING INSPECTION, FOUND CORROSION ON FITTING LOCATED INTERNAL STRUCTURE OF CUT OUT DOOR LOCKING FITTING AREA AND BETWEEN FR 26 AND FR 27 FWD CARGO. REPLACED FITTING AND FASTENER LOCATED INTERNAL STRUCTURE OF CUT OUT DOOR LOCKING FITTING AREA AND BETWEEN FR 2SDR FDEA201306121261Crease Beam · corrodedBS 980 -1000 RT CREASE BEAM FOUND CORRODED AROUND SIX FASTENER HOLES. REPAIRED IAW REPAIR DWG LOR5L53017 SHT 3, REV A. REPAIR IS MAJOR.SDR FDEA201306121256Crease Beam · corrodedBS 1380 -1400, RT CREASE BEAM OTBD ANGLE FOUND CORRODED. REPAIRED IAW EA F-5310-167509, PART 1. REPAIR IS CAT B, MAJOR.SDR ASOA20130612174Beam · corrodedDURING C-CHECK, CARGO DOOR CUTOUT LOWER BEAM CORRODED IN MULTIPLE AREAS. MXE R & R CARGO DOOR CUTOUT LOWER BEAM IAW SRM 51-40-02 AND CPM 51-21-06. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2013F00131Structure · crackedWHILE PERFORMING INSPECTION CALLED OUT IN AD 2012-18-01, FOUND TWO CRACKS. LT MAIN SPAR AFT FITTING CRACKED IN THE UPPER RADIUS. CRACK LENGTH 1 INCH. RT MAIN SPAR FWD FITTING CRACKED AT INBD BOLT HOLE. CRACK LENGTH .1250 INCH. THE ACFT HAS NO EVIDENCE SDR DALA13028751806Failsafe · crackedRIGHT BS 955, REAR SPAR BULKHEAD FITTING AREA WAS FOUND 2 EA CRACKS AT THE FAIL-SAFE STRAP APPROX .1250" AND THROUGH THICKNESS IN LENGTH. C/A FITTING REPLACED IAW ER/A 513131-14AD, REV ORIG "RETAIN FOR RECORDS" ASSOCIATED ER/A 14-513131, ADDED FOR AC 1806.SDR SWAA2013061717197Window Frame · crackedL1 WINDOW POST C-D FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED WINDOW FRAME IAW EA.SDR FDEA201306101244Crossbeam · crackedCROSSBEAM FOUND CRACKED LOCATED AT Y812 OTBD. REPAIRED IAW EA 6-5300-167423. REPAIR CLASSIFIED AS MAJOR.SDR SWAA2013061917338Window Frame · crackedRIGHT FLIGHT DECK WINDOW FRAME E-F POST CRACKED AT SECOND LOWER CORNER FASTENER. REPAIRED FRAME IAW ACO.SDR SWAA2013061417135Window Frame · crackedLEFT FLIGHT DECK WINDOW FRAME E-F POST CRACKED AT SECOND LOWER CORNER FASTENER. REPAIRED FRAME IAW EA.SDR DALA13028143753Crease Beam · corrodedDURING INSPECTION, FOUND L2 DOOR CUTOUT LOWER SILL CREASE BEAM CORRODED. MX REPLACED L2 DOOR LOWER SILL CREASE BEAM INNER IAW DWG 147A8540 AND DWG 147A8540. ALODINED AND PRIMED IAW SRM 51-20-01 RESTORED PRESERVATION.SDR DALA13028029252Door Frame · damagedBLEND OUTS ON AFT CARGO DOOR FRAME. FABRICATED DOUBLER, STRAP AND BUSHINGS IAW ERA 513348-14. INSTALLED REPAIR PARTS IAW 51-30-05, 51-30-02 AND ERA 513398-14.
Back to JASC 5310