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 GAIA01084STShear Tie · corrodedDURING A LTC INSPECTION AT FLIGHTSTAR, IT WAS DISCOVERED LEFT LOWER NOSE CHORD ATTACH ANGLE (SHEAR TIE) AT BS 312 HAS HEAVY CORROSION AND IS CRACKED. ACCOMPLISHED FABRICATION AND INSTALLATION OF SHEAR TIE REPAIR IAW B727 SRM 53-10-4 AND 51-30-2. (M)SDR UPS01835606Shear Tie · crackedINSPECTION TYPE:C2,3 STA. 660 SHEAR TIE CLIP IS CRACKED BETWEEN LONG. 26L-27L REPAIRED SHEARTIE I.A.W. SRM. 53-2-0 FIG. 2ASDR DL72S010546Door Frame · crackedINSPECTION OF THE C1 DOOR OPENING FWD FRAME AT FS 560 PER AD 99-23-13 REVEALED 3 CRACKS IN THE WEB (1 BELOW THE NR 4 STOP AND 2 BELOW THE NR 1 STOP). THE WEB WAS CUT AT THE NR 6 STOP AND THE UPPER SECTION WITH THE CRACKS REMOVED. WEB REMOVAL REVEALED SEVERSDR 2001UALA00377Door Frame · crackedFORWARD GALLEY DOOR FRAME CRACKED AT THE LOWER AFT CORNER UPPER OUTBOARD BOLT HOLE FOR THE STOP FITTING. INSTALLED FRAME KIT. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00376Door Frame · crackedFORWARD GALLEY DOOR FRAME CRACKED AT THE LOWER FORWARD CORNER UPPER OUTBOARD BOLT HOLE FOR THE STOP FITTING. REPAIRED CRACKED DOOR FRAME. MAJOR REPAIR ACCOMPLISHED.SDR SWAA011012Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 908, BELOW STR 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA010991Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 460, BETWEEN STR 27R & 28R. REPAIRED SHEAR TIE PER SRM.SDR MWEA010507Door Frame · corrodedFORWARD CARGO COMPARTMENT DOOR JAMB WEBBING BETWEEN STATION 305 AND 377 HAS AREAS OF LIGHT CORROISON ON TOP SIDE FORM LONGERON 26 RIGHT TO 29 RIGHT. REMOVED AND BLENDED CORROSION AND FORWARD CARGO DOOR JAMB WEB, LOCATED, DRILLED AND INSTALLED NEW DOOR JAMB SDR MWEA010497Gusset · corrodedFORWARD CARGO COMPARTMENT DOUBLER PLATE ON DOOR JAMB WEBBING AT LONGERON 28 RIGHT FROM STATION 300 TO 318 HAS LIGHT CORROSION AND MISDRILLED HOLES. REMOVED GUSSET, FABRICATED AND INSTALLED NEW GUSSET.SDR MWEA010495Door Frame · bentAFT SIDE OF CARGO DOOR JAMB AT STATION 756-761 IS BENT BACK ABOUT .065 BETWEEN LONGERONS 24 TO 26 RIGHT. FABRICATED REPAIR DOUBLERS AND INSTALLED ASSEMBLED REPAIR.SDR AUS20010942Structure · corroded(AUS) CORROSION CONTROL INSPECTION FOUND AREAS OF LEVEL 2 CORROSION.FOUND DURING INSPECTION IAW AD/B737/52 AMDT2.SDR AUS20010941Structure · corroded(AUS) CORROSION CONTROL INSPECTION FOUND AREAS OF LEVEL 2 CORROSION.FOUND DURING INSPECTION IAW AD/B737/52 AMDT2.SDR EIA2001222Forging · corrodedMZJ-EAC - FOUND RIGHT STATION 1160-1180, STRINGER 20R TO STRINGER 22R CORROSION UNDER WINDOW FORGING. REPAIRED PER ECRA 3203-53-047-2. (M)SDR EIA2001221Forging · corrodedFOUND LEFT STATION 1040-1060 STRINGER 20L TO STRINGER 22L CORROSION UNDER WINDOW FORGING. REPAIRED PER ECRA 3203-53-047-2. (M)SDR UPS01835773Fitting · corrodedINSPECTION TYPE:C2,3 STA 320 BATHTUB FITTING IS CRACKED BETWEEN LONG. 29L-30L REMOVED AND REPLACED FITTING I.A.W. DWG. 3755822,AND SRM.51-1-20DSDR QXEA0100591Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 7305 AND STATION 19. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100590Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 7305 AND STRINGER 18. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100589Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 6805 AND STRINGER 19. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100557Shear Tie · crackedYYC- LEFT HAND AT FRAME 5805 AND STRINGER 18 HAS CRACKED CASTELLATION. REPAIRED IAW HORIZON AIR EA 4-53-1461.SDR QXEA0100556Shear Tie · crackedYYC- LEFT HAND AT FRAME 5805 AND STRINGER 19 HAS CRACKED CASTELLATION. REPAIRED IAW HORIZON AIR EA 4-53-1461.SDR 2001UALA00405Shear Tie · corrodedAFT PIT AT STA. 1395 STRINGERS 38L & 39L SHEAR TIE IS CORRODED. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR TIE PER BOEING DWG 140T2102 AND SRM 51-40-02.SDR 2001UALA00368Angle · misdrilledFORWARD CARGO DOOR REINFORCING ANGLES HAVE AREAS WITH SHORT EDGE DISTANCE. REPAIRED FORWARD CARGO DOOR. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA00367Structure · corrodedAFT PIT SUPPORT STRUCTURE FOR THE VHF ANTENNA IS CORRODED BETWEEN STA 727D AND STA 727E. REPLACED CHANNEL SUPPORT STRUCTURE FOR THE VHF ANTENNA. MAJOR REPAIR ACCOMPLISHED.SDR RRXA10910Doubler · crackedDURING A MAINTENANCE VISIT FOUND A CRACK TO THE BULKHEAD HORIZ. INTERCOSTAL AT STA 70 RBL 30 ABOVE L30R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// FABRICATED PART AND INSTALLED IAW DC-8 SRM 51-1-21 AND 51-1-20D.SDR QXEA0100575Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 12875 AND STRINGER 29. REPAIRED IAW FOKKER SRM 53-02-11.SDR QXEA0100528Door Frame · corrodedYYC- FORWARD CARGO PIT FORWARD DOOR FORWARD LOWER CORNER OF APERTURE HAS MINOR SURFACE CORROSION AROUND SCREW HOLES. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9.SDR QXEA0100527Door Frame · corrodedYYC- FORWARD CARGO PIT AFT DOOR AFT LOWER CORNER OF APERTURE HAS MINOR SURFACE CORROSION AROUND SCREW HOLES. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9.SDR QXEA0100526Door Frame · corrodedYYC- FORWARD CARGO PIT FORWARD DOOR AFT LOWER CORNER OF APERTURE HAS MINOR SURFACE AROUND SCREW HOLES. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9.SDR SWAA010951Door Frame · crackedDURING SCHEDULED D-CHECK, FOUND AFT CARGO DOOR FWD FUSELAGE FRAME CRACKED AT BS 794, RBL 29. REPAIRED FRAME PER SRM.SDR SWAA010945Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME SHEAR TIE CORRODED AT BS 520, BETWEEN STR 28R & 28L. REMOVED AND REPLACED FRAME SHEAR TIE PER SRM.SDR MWEA010480Splice · elongatedLONGERON 1 SPLICE CAP HAS 4 EA. HOLES ELONGATED AND IN RADIUS OF LONG SPLICE CAP AT STATION 226 TO 230. REMOVED LONGERON SPLICE CAP, CUT AND FABRICATED NEW SECTION OF STRAP AND SPLICE PLATE, CUT OUT DAMAGED SKIN, FABRICATED EXTERNAL DOUBLER, INSTALLED SKIN PSDR RRXA10906Seat Track · wornDURING A MAINTENANCE VISIT FOUND A WORN SEAT TRACK IN THE MAIN CABIN AT STA 130-510 AT RBL 24, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// FABRICATED PART AND INSTALLED IAW DC-8 SRM 53-2-3 FIG 14 AND DWG 5750864.SDR RRXA10902Support Bracket · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE MCD SUPPORT BRACKET FWD NR 7 LATCH SPOOL, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. RECEIVED PART AND INSTALLED IAW DC-8 SRM 51-3-0.SDR QXEA0100588Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 10966 AND STRINGER 44. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100587Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 10346 AND STRINGER 44. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100577Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 12405 AND STRINGER 36. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100576Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 12405 AND STRINGER 46. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100574Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 12875 AND STRINGER 33. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100573Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 13815 AND STRINGER 33. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100572Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 13815 AND STRINGER 57. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100571Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 14755 AND STRINGER 28. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100569Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 14755 AND STRINGER 39. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100568Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 14755 AND STRINGER 40. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100567Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 14755 AND STRINGER 44. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100566Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 14755 AND STRINGER 56. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100564Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 14755 AND STRINGER 58A. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100562Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 15205 AND STRINGER 39. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100561Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 15205 AND STRINGER 40. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100560Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 15205 AND STRINGER 45. REPAIRED IAW FOKKER SRM 53-02-13.SDR QXEA0100559Shear Tie · crackedYYC- CRACKED CASTELLATION AT FRAME 15205 AND STRINGER 57. REPAIRED IAW FOKKER SRM 53-02-13.
Back to JASC 5310