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 DL75E101224Doubler · corrodedMAIN CABIN DECK PLATE DOUBLER CORRODED STA 1715, RBL 20. REPLACED DOUBLER, REF NON ROUTINE CARD 154863.SDR DALA1405329217Frame · damagedBS 883-962 OVERWING FRAME WAS DAMAGED. REPAIRED IAW AA 5310-01375.SDR DL75E101262Door Frame · gougedRT AFT OVERWING DOOR TOP FRAME INTERIOR SIDE GOUGED AFT SIDE OF DOOR OTBD OF INTERCOSTAL. REMOVED DAMAGED AND REPAIRED, REF NON ROUTINE 154840.SDR AALA20100409TUL01Pan · crackedCRACKED WINDOW PAN STATION 1155 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR DL75E101215Structure · corrodedCORROSION ON CHORD LOWER SURFACE AT FS 1060 RBL8 TO LBL8. REMOVED DAMAGED CHORD AND REPAIRED REF NON ROUTINE 160818.SDR AALA20100408TUL15Pan · crackedWINDOW PAN CRACKED AT STATION 807 AT LONGERON 14 RIGHT. STOP DRILLED CRACK AND INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR AALA20100408TUL14Pan · crackedWINDOW PAN CRACKED AT STATION 807 AT LONGERON 12 RIGHT. STOP DRILLED CRACK AND INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR AALA20100408TUL12Pan · crackedCRACKED WINDOW PAN STATION 1174. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100408TUL11Pan · crackedCRACKED WINDOW PAN STATION 1231. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100408TUL10Pan · crackedCRACKED WINDOW PAN STATION 1060. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100408TUL07Pan · crackedCRACKED WINDOW PAN AT STATION 1022. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100408TUL06Pan · crackedCRACKED WINDOW PAN AT STATION 1022 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100408TUL04Pan · crackedFUSELAGE STATION 788 LEFT WINDOW PAN CRACKED AT UPPER FORWARD CORNER. DAMAGED AREA REMOVED AND DOUBLER INSTALLED PER AARD 56-10-00-25.SDR AALA20100407TUL19Stiffener · crackedLEFT AFT LAVATORY/VAULT DOOR FRAME STIFFENER CRACKED. INSTALLED REPLACEMENT STIFFENER PER SRM 51-30.SDR AALA20100407TUL13Pan · crackedCRACKED WINDOW PAN STATION 1060 AFT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100407TUL12Pan · crackedCRACKED WINDOW PAN STATION 1060. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100407TUL11Pan · crackedCRACKED WINDOW PAN STATION 1079. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100407TUL10Pan · crackedCRACKED WINDOW PAN STATION 1041. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100407TUL05Pan · crackedCRACKED WINDOW PAN AT STATION 946 LEFT UPPER FORWARD SIDE. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR DL76S100931Failsafe · corrodedA CRACK INDICATION WAS FOUND ON THE RT FAIL SAFE STRAP REF ERA 481422-14AD.SDR DL76S100930Failsafe · corrodedA CRACK INDICATION WAS FOUND AT LWR BOLT HOLE FAIL SAFE STRAP INSP REF ERA 481421-14AD.SDR QXEA2010040800228Door Frame · chafedC CHECK - THE FWD DOOR FRAME FOR THE FWD PAX DOOR HAS A 1" BY APPROX .020 CHAFE AT FLOOR LEVEL. BLENDED AFFECTED AREAS IAW RD8/4-53-2120. HFEC IAW NDTM PART 6, 51-00-01 AND RD 8/4-53-2120. NO CRACKS NOTED. MATERIAL REMOVED DEEPEST POINT IS .013" AND WITHISDR QXEA2010040700227Structure · chafedC CHECK - CHAFING AT STR 27 FS 977.00 UNDER PANEL DL. BLENDED OUT DAMAGED AREA IAW SRM 51-12-00-001-001-A01. BLEND FOUND TO BE WITHIN LIMITS IAW REO 670-53-00-14. PERFORMED LPI IAW NDTM LPI 51-20-008-230-A01. ETCHED AND ALODINED IAW SRM 51-21-11-001-001-A0SDR QXEA2010040600216Beam · crackedC-CHECK - FWD CARGO DOOR BEAM CRACKED WHERE THE VENT DOOR STOP ATTACHES. REMOVED THE VENT DOOR FROM FWD CARGO DOOR IAW AMM 52-32-06-000-801. REMOVED VENT DOOR SURROUND AND LOWER INTERCOSTAL IAW SRM 51-42-05, SRM 51-42-45 AND SRM 51-40-15. HFEC IAW Q400 NDTMSDR COMA2010040550084Door Frame · crackedCARGO DOOR FRAME 605.00 (P/N 601R35027-31) IS CRACKED. REPLACED DISCREPANT FRAME SECTION IAW SRM 51-42-06.SDR QXEA2010040500218Door Frame · corrodedC-CHECK - PASSENGER DOOR SURROUND THRESHOLD MEMBER IS CORRODED. REMOVED CASTING AND THESHOLD BY REMOVING RIVETS. MATCH DRILLED PASSENGER DOOR SURROUND THRESHOLD MEMBER IAW SRM 51-40-07. INSTALLED THRESHOLD USING SOLID RIVETS IAW SRM 51-42-05.SDR ASOA201000477Crossbeam · corrodedCROSSBEAM FS 349.00 AT RT BEAM HAS CORROSION. (OPEN)SDR AALA20100331TUL04Pan · crackedRIGHT WINDOW PAN CRACKED AT LOWER FORWARD FASTENER AT STATION 1041 ABOVE STRINGER 15 RIGHT. REPAIRED PER AARD 53-10-00-25.SDR UALA2010033101087Structure · damaged20 EACH LIGHTNING STRIKES ON LT FWD FUSELAGE AFT OF BS 3500, FRAME 1, SUB ZONE 120. BURNISHED BURN AREAS. REMOVED BURNED RIVETS. REPLACED RIVETS AND LOCK FASTENERS WET PRIMED AND PAINTED AREA. HAD HFEC DONE ON HOLES. NO DEFECTS NOTED.SDR UALA2010033101086Window Frame · damaged3 EACH LIGHTNING STRIKES ON LT FWD FUSELAGE BELOW CAPT'S FIXED NR 1 AND SLIDING WINDOW AT BS 2540, SUB ZONE 210. INSTALLED 3 EA CHERRY MAX RIVETS WET. PERFORMED HFEC ON EXISTING FASTNER HOLES. NO DEFECTS NOTED.SDR ASOA201000460Frame · corrodedFS 280.00 BETWEEN STG 17 RT & STG 17 LT HAS CORROSION IN SEVERAL PLACES AND ON THE FWD ENDS OF THE LT & RT BEAMS. REMOVED DAMAGED 280 CROSSBEAM IN REF SP670BA-53-026 AND IS MOD 670531100026, JR161744 4. CUT 280 CROSSBEAM TO MAC & LIT IKE INSTALLATION ALL WORK SDR AALA20100330TUL09Pan · crackedCRACK IN LEFT WINDOW PAN UPPER FORWARD TANG STATION 788 AFT SIDE. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100330TUL08Pan · crackedWINDOW RING PAN CRACKED AT TOP AFT FASTENER AT STATION 1193 BELOW LONGERON 11 RIGHT. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20100330TUL07Pan · crackedCRACK AT LEFT WINDOW UPPER FORWARD TANG STATION 845 AFT SIDE. INSTALLED DOUBLER AARD 53-10-00-25.SDR AALA20100330TUL06Pan · crackedWINDOW RING PAN CRACKED AT LOWER FORWARD FASTENER AT STATION 1155 ABOVE LONGERON 15 RIGHT. CUT OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100330TUL05Pan · crackedCRACK AT LEFT WINDOW PAN UPPER FORWARD TANG STATION 946 AFT SIDE. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20100330TUL04Pan · crackedCRACK AT RIGHT WINDOW PAN UPPER FORWARD CORNER AFT OF STATION 807. CUT OUT CRACK AND INSTALLED NEW REPAIR ANGLE PER AARD 53-10-00-25 AT STATION 807 WINDOW PAN UPPER FORWARD CORNER.SDR DLM88100781Window Frame · damagedDURING LIGHTNING STRIKE INSP FOUND DAMAGE TO 2R AND 3R WINDOW FRAMES. REPAIRED DAMAGE IAW ERA 481177-14 BLENDED OUT DAMAGE AND HFEC INSPECTED BLENDS ALSO SUBMITTED DAMAGE TO MFG, ALL GOOD FOR CONTINUE IN SERVICE IAW ERA.SDR ASOA201000458Structure · corrodedCORROSION FOUND AT FS 280 AND IN BETWEEN STR 26R AND 25R ON FLOOR. (OPEN)SDR AALA20100329TUL10Pan · crackedCRACK AT LEFT WINDOW PAN UPPER AFT TANG STATION 1022 FORWARD SIDE. TRIMMED OUT CRACK AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100329TUL09Fitting · crackedCRACK AT LEFT WINDOW PAN LOWER FORWARD CLIP STATION 1022 AFT SIDE. TRIMMED OUT CRACK AND INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20100329TUL08Pan · crackedRIGHT WINDOW RING PAN CRACKED AT STATION 1061 ABOVE STRINGER 15 RIGHT. REPAIRED PER AARD 53-10-00-25.SDR AALA20100329TUL07Pan · crackedLEFT WINDOW PAN UPPER AFT CLIP CRACKED AT STATION 1022. REPAIRED PER AARD 53-10-00-25.SDR AALA20100329TUL06Pan · crackedLEFT WINDOW RING PAN LOWER FORWARD CLIP CRACKED AT STATION 1022. REPAIRED PER AARD 53-10-00-25.SDR AALA20100329TUL04Pan · crackedRIGHT WINDOW RING PAN CRACKED AT STATION 1059 BELOW STRINGER 11 RIGHT. REPAIRED PER AARD 53-10-00-25.SDR DLM88100793Window Frame · damagedDURING LIGHTNING STRIKE INSP, FOUND DAMAGE TO 2R, 3R, WINDOW FRAMES. REPAIRED DAMAGE IAW ERA 481177-14 BLENDED OUT DAMAGE AND HFEC INSPECTED BLENDS ALSO SUBMITTED DAMAGE TO MFG. ALL GOOD FOR CONTINUE IN SERVICE IAW ERA.SDR DALA106639867Door Frame · crackedDURING H-CHECK FOUND L1 DOOR JAMB WEB CRACKED AT ATTACH POINT TO INTERCOSTAL AT L12L. REPAIRED IAW SRM 53-01-4, 51-10-3, 51-30-2 AND 51-30-5.SDR IPXA10559168Beam · gougedINSPECTION TYPE:C2, GOUGE IN STUB BEAM BS 920, RBL64, WL207. REPAIRED IAW ATS ER 10-2249.SDR FDEA201003261016Structure · corrodedCORROSION ON NOSE WHEEL WELL RT MID-CHORD, REMOVED CORROSION AND FOUND OUT OF LIMITS, REMOVED CHORD, LOCATED AND DRILLED NEW CHORD PN 65-19862-20 PO 20017288 AND INSTALLED IAW SRM 51-30-5, 53-10-1 AND 51-30-2.SDR UIEA201000077Beam · damagedDURING C-CHECK, DAMAGE WAS FOUND IN THE 65B04721-2 AFT LOWER CARGO DOOR LOWER BEAM WEB BETWEEN BS 1840 TO 1852. DAMAGE WAS TRIMMED OUT AND REPAIRED IAW NRC 786 AND SRM 51-40-03, FIG 1. THE 65B04721-2 WEB IS MADE FROM 0.125 INCH THICK 7075-0 SHEET IAW QQ-A-25
Back to JASC 5310