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 SWAA2013081419224Window Frame · crackedLT NR 1 WINDOW FRAME ASSEMBLY CRACKED AT UPPER AFT CORNER. R&R FRAME IAW ACO.SDR SWAA2013081419223Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED AT FASTENER HOLE. R&R FRAME IAW ACO.SDR SWAA2013081419194Door Frame · crackedFWD GALLEY DOORWAY STUB FRAME CRACKED AT BS 296, STRINGER 17R. REPAIRED FRAME IAW SWA EA.SDR FDEA201307311706Door Frame · crackedBS 1305.25 - 1315.42, R3 DOOR AFT FRAME LOWER WEB CRACKED. REPAIRED IAW SRM 53-40-15, FIG 201 REPAIR 3 REV 53. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 116.SDR FDEA201307311705Door Frame · crackedBS 1250.75 - 1256.75, R3 DOOR FWD FRAME LOWER WEB CRACKED. REPAIRED IAW SRM 53 -40-15, FIG 201, REPAIR 3, REVISION 53. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201307311704Door Frame · crackedBS 1305.25 - 1315.42 L3 DOOR AFT FRAME LOWER WEB CRACKED. REPAIRED IAW SRM 53-40-15, FIG 201, REPAIR 3, REV 53. REPAIR CLASSIFIED AS MAJOR IAW GMM 6 -2-100, REV 116.SDR FDEA201307311703Door Frame · crackedBS 1250.75 - 1256.75 L/E DOOR FORWARD FRAME LOWER WEB FOUND CRACKED. REPAIRED IAW SRM 53-40-15, FIG 201, REPAIR 3, REV 53. REPAIR CLASSIFIED AS MAJOR IAW GMM
6 -2-100, REV 116.SDR DALA13037209251Window Frame · crackedMAIN CABIN WINDOW FRAME CRACKED LOWER AFT CORNER STA 943, LEFT SIDE. REMOVED DAMAGE. FABRICATED, TREATED PRIMED AND INSTALLED REPAIR ANGLE IAW SRM 51-10-03 AND ERA 333615-14.SDR REXA2013080201108Structure · damagedSIX DAMAGED RIVETS AT WL 86.5, LBL AND RBL 9.5, 18, 27.5, TWO GOUGES AT WL 86.5, LBL 8 AND RBL 7, TEN DAMAGE MARKS AT WL 103, LBL 7.75, RBL 6.75, LBL AND RBL 9, 18, 27.5, AND 36.2, MEASURING 0.004" TO 0.014" DEEP. REPAIRED IAW REO 601R-53-61-2155.SDR SIMA20130731008Support Beam · corrodedDURING HMBV INSPECTION, QC FOUND LAVATORY CENTER BEAM CORRODED AT FWD NUT PLATE HOLES. ACFT WAS REMOVED FROM SERVICE AND RETURNED TO SERVICE AFTER HMBV INSPECTION.SDR AALA20130731019Door Frame · crackedTHE FORWARD RT NR 1 DOORWAY FRAME CRACKED AT THE LOWER FRAME. REMOVED THE DAMAGE & INSTALLED REPAIR DOUBLER IAW SRM 51-70-11-2R.SDR REXA2013073001630Doubler · chafedAFT LAV SERVICE PANEL DOUBLER IS CHAFED. AREA FOUND TO BE SERVICEABLE AS IS. TREATED PRIMED AND TOPCOATED IAW REO690-53-51-083 AND EOR53445.SDR CALA2013082090617Crease Beam · corrodedRT CREASE BEAM WEB, JUST AFT OF BS 1020 IS CORRODED. CORROSION WAS REMOVED & THE MATERIAL LOSS WAS MEASURED AT.013" WHICH IS OUT OF LIMITS IAW SRM 53-40-13. MAJOR REPAIR ACCOMPLISHED: CORROSION WAS REMOVED & THE MATERIAL LOSS WAS MEASURED AT .013" WHICH IS OSDR FDEA201307301699Crease Beam · corrodedBS 310.5 - 324 RT CREASE BEAM WAS FOUND CORRODED AT INNER UPPER SURFACE. R & R IAW SRM 51-40-02 AND DWG 141N8422 SHT.1 REV R. MAJOR REPAIR.SDR FDEA201307291686Door Frame · crackedLOWER FUSELAGE RT A/C PACK NR 3 DOOR FRAME AFT UPPER CORNER AREA FOUND CRACKED. TRIMMED OUT AND REPAIRED IAW SRM 53-20-15, FIG 201, REPAIR 3, REV 53. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR SWAA2013081219086Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME SECOND FASTENER HOLE FROM THE BOTTOM ALONG THE E-F POST CRACKED. R&R FRAME IAW SRM & DRAWING.SDR SWAA2013081219085Window Frame · crackedLT NR 3 WINDOW FRAME CRACKED AT THE SECOND LOWER CORNER FASTENER HOLE. R&R FRAME IAW SRM & DRAWING.SDR FDEA201307291691Support Fitting · crackedDURING HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION, FOUND ONE CRACK INDICATION ON NR 7 MAIN DECK CARGO DOOR LOWER FRAME FITTING AT HOLE "A". SUPPORT FITTING R & R IAW SRM 51-31-01, REV 53. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 116.SDR QXEA2013082101251Rib · corrodedRIB AT FS 547, S31-32L HAS CORROSION ON AND AROUND RIVETS. REMOVED CORROSION ON RIB IAW SRM 51-21-00. FOUND WITHIN LIMITS.SDR QXEA2013082101231Fastener · corrodedCORROSION AROUND THE RIVETS ON S31L BETWEEN FS 196 AND 216. REMOVED CORRODED RIVETS IAW SRM 51-42-05, STEP 4E. INSTALLED RIVETS IAW SRM 51-42-05, STEP 4D(3)-(10).SDR USAA2013082100007Door Frame · crackedDURING 2S CHECK, A CRACK ON DOOR FRAME SEGMENT OF EMERGENCY EXIT. REPLACED DOOR FRAME SEGMENT IAW EO 5210Y228.SDR USAA2013082100006Door Frame · crackedDURING 2S CHECK, CRACK ON FRAME SEGMENT OF EMERGENCY EXIT DOOR. REPLACED DOOR FRAME SEGMENT IAW EO 5210Y228.SDR REXA2013072601461Skin · crackedFWD EQUIPMENT BAY SKIN OTBD CORNER CRACKED UNDER ADG HAND PUMP. REPAIRED EQUIPMENT BAY SKIN OTBD CORNER CRACK UNDER ADG HAND PUMP IAW EO R53446.SDR USAA2013073100026Crease Beam · corrodedC4 CHECK - CORROSION ON CREASE BEAM WEB AT BS 1636, LBL 60. REPLACED CREASE BEAM WEB IAW SRM 51-10-02 & 51-40-02.SDR UALA2013072505223Tension Tie · damagedBS 1220 RT TENSION TIE FASTENER HOLE HAS SHORT EDGE MARGIN. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-40-30, REPAIR 2.SDR UALA2013072505222Tension Tie · crackedBS 1180, LT TENSION TIE, TWO FASTENER HOLES CRACKED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-40-30, REPAIR 2.SDR UALA2013072505221Tension Tie · crackedBS 1140, LT TENSION TIE THREE FASTENER HOLES CRACKED. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-40-30, REPAIR 2.SDR USAA2013072900039Fairing · faultyCREW REPORTED THE WINDOW SHADE IN EMERGENCY EXIT ROW 9F BROKEN, OBSCURES VIEW OF WINDOW WHEN STUCK IN CLOSED POSITION. MX REPLACED WINDOW FAIRING ASSY IAW AMM AND IPC 25-23-47.SDR ASOA20130727197Bolt · brokenDURING SCHEDULED MX A BROKEN BOLT WAS FOUND IN THE LT AFT HOLE OF THE WINDSHIELD CENTER POST LOWER FITTING WHERE IT ATTACHES TO THE FORWARD PRESSURE BULKHEAD NEAR FRAME 7 AT THE 12 O'CLOCK POSITION. MX R & R THE BOLT IAW EC5310-01715, REV A. THE ACFT WAS APSDR UHLA2013072400342Doubler · corrodedCORROSION FOUND ON DOUBLER AT FRAME 19. R & R DOUBLER.SDR UHLA2013072400341Gusset · corrodedCORROSION FOUND ON LT GUSSET AT FRAME 90. R & R GUSSET.SDR FDEA201307241656Crease Beam · corrodedR2 DOOR AREA, INBD CREASE BEAM CORRODED. REMOVED CORROSION IAW SRM-51-10-02, CHECKED LIMITS IAW-SRM-53-30-15, DET VI FIG 101 FOUND TO BE OUT OF LIMITS. R & R INBD CREASE BEAM IAW SRM 51-40-02 AND DWG 143N8328. CAT "A" MAJOR REPAIR.SDR ASOA2013072608778Window Frame · damagedCAPTAIN`S WINDSHEILD FRAME LOWER SILL DAMAGE 9.0" FROM AFT SIDE. BLENDED OUT DAMAGE TO WINDSHIELD FRAME LOWER SILL, FOUND TO BE WITH IN LIMITS IAW SRM 53-11-35. MAJOR REPAIR IAW GMM 5-3.SDR 39LA2013072400084Window Frame · corrodedDURING WINDSHIELD REMOVAL AT HEAVY CHECK CORROSION FOUND ON THE CO-PILOT'S WINDSHIELD FRAME LOWER SECTION. REPAIRED IAW EO2012032-309 AND EO2021032-424, AND AIRLIFT DWG 2012032-2036, SUPPORTED BY FAA FORM 8110-3, DATED 31 MAY 2013.SDR R61A201307230768Fitting · corrodedDURING HEAVY CHECK, FOUND FWD EMERGENCY DOOR LOWER DOOR BRACKETS ON THRESHOLD SHOWS EVIDENCE OF CORROSION. MX R & R TWO STOP FITTINGS IAW SRM 51-41-00, AND AMM 52-23-00, SHEET 4, FIG 504 RT.SDR SWAA2013080618908Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME IAW ACO.SDR SWAA2013080618892Window Frame · crackedLT WINDOW FRAME CRACKED AT OPEN FASTENER HOLE. REPAIRED FRAME IAW ACO.SDR SWAA2013080218774Window Frame · crackedLT EF CONTROL CABIN WINDOW POST CRACKED AT 2ND LOWER CORNER FASTENER HOLE. REPAIRED FRAME ASSEMBLY, IAW EA.SDR LR7A2013072300653Manifold · crackedDURING SCHEDULED C-11 CHECK, FOUND RT MAIN WHEEL WELL MANIFOLD CRACKED AT BS 567, RBL 62, WL 142. REPAIR BY REPLACEMENT ACCOMPLISHED IAW SMP583, 51-60 AND 51-70.SDR REXA2013072501107Panel · damagedKIDNEY PANEL UPPER EDGE SCREW HOLE OVERSIZED. REPAIRED IAW REO 601R-53-11-162.SDR UALA2013072305165Window · damagedR3 WINDOW DELAMINATED, BUBBLE BETWEEN LAYERS IN LOWER RT CORNER. INSPECTED R3 WINDOW IAW MM, ONE BUBBLE RT CORNER MEASURED 2 X .250 AT NON CRITICAL VISION AREA. BUBBLE IS CLEAR & NOT BLACK OR DARK BROWN. ACCOMPLISHED R3 WINDOW HEATER CONTROL SYS TEST IAW MMSDR SWAA2013072518551Crease Beam · corrodedLT CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 800. R&R WEB IAW SRM & DRAWING.SDR ASOA20130725133Rib · crackedDURING 4A INSPECTION THE LEFT WHEELWELL AFT RIB WAS FOUND TO BE CRACKED THROUGH THE TOP OTBD RIVET APPROXIMATELY .5" LONG. MX REMOVED THE DAMAGED SECTION OF RIB AND PERFORMED A FILLER/DOUBLER REPAIR IAW CHANGE REPAIR AUTHORIZATION EC5320-01974, AND THE ACFT WSDR SWAA2013080618907Window Frame · crackedRT NR 1 WINDOW FRAME FOUND UPPER OPEN HOLE CRACKED. REPAIRED FRAME IAW ACO.SDR SWAA2013080618906Window Frame · crackedRT NR 1 WINDOW FRAME CRACKED AT UPPER INBD CORNER. REPAIRED FRAME IAW ACO.SDR UALA2013072405210Support · crackedUPPER AFT CARGO DOOR OPENING AT FWD TOP HAS A CRACKED DOOR STOP SUPPORT. REMOVED CRACKED DOOR STOP SUPPORT AND REPLACED WITH A SERVICEABLE DOOR STOP SUPPORT. CARGO DOOR CHECKED FOR ADJUSTMENT. CHECKED GOOD FOR GAP LIMITS IAW AMM 52-34-00, PAGE 512,STEP 4 A,SDR DALA13035973754Door Frame · crackedDURING INSPECTION, FOUND E & E COMPARTMENT DOOR CUTOUT AFT FRAME CRACKED. MX R & R E & E DOOR AFT FRAME IAW SRM 51-40-02, PG 1 AND DWG 141A3501.SDR FDEA201307221633Window Frame · chafedCAPTAIN`S SLIDING WINDOW FRAME SHOWS EVIDENCE OF CHAFING AND FRETTING DAMAGE FROM AN ADJACENT SOLID RIVET TAIL WHEN IN THE CLOSED POSITION. SLIDING WINDOW REPLACED IAW AMM 56-12-11-P401.SDR UHLA2013072100333Rib · crackedRIGHT RIB 10 CRACKED. R & R RIB. MAJOR REPAIR.SDR UHLA2013072100332Rib · crackedLEFT RIB 10 EXTENSION CRACKED. R & R RIB. MAJOR REPAIR.
Back to JASC 5310