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 SWAA2014040126738Window Frame · crackedLEFT NR 1 WINDOW POST CRACKED IN ZONE A. REPAIRED POST IAW ACO.SDR SWAA2014032426386Stop Fitting · crackedDOOR STOP FITTING CRACKED SKIN AT BS 303.9, STRINGER 7L. R & R FITTING IAW SRM.SDR AALA20140307004Window Frame · crackedWINDOW FRAME AT STATION 1061 & STRINGER 14 LT CRACKED, INSTALLED DOUBLER IAW AARD 53-10-00-25.SDR KCSA201403071019Strap · corrodedCORROSION ON STRAP FOR L1 WINDOW UPPER OTBD CORNER.SDR 7AHR2014030782403Door Frame · gougedGOUGE IN LOWER BS 348 DOOR FRAME STRINGER 16L. INSTALLED NEW FRAME IAW SRM 53-10-2, FIG 1 AND DRG 65-54961-1, SH 1.SDR IPXA2014032182375Splice Plate · crackedINSPECTION C, BS 400, S44R, A .5 INCH DIA HOLE FOUND ON BS 400 BULKHEAD FRAME LOWER ATTACH SPLICE PLATE. SPLICE PLATE REPLACED IAW RI-53-11-10489, REV A & EO B747-5330-53796-A.SDR R61A201403060375Beam · corrodedDURING HEAVY CHECK, FWD CARGO HORIZONTAL BEAM FROM FRAME 24-27 STRINGER2R CORRODED. MAINTENANCE R & R FWD CARGO HORIZONTAL BEAM IAW IPM-12 FOR ALL COMPLETED MAINTENANCE ACTIONS.SDR USAA2014031000026Crease Beam · corrodedC4 CHECK, CREASE BEAM CHORD CORRODED BETWEEN BS 1260 & BS 1280 AT STRINGER 17R. REPAIRED CREASE BEAM CHORD IAW SRM 51-10-02, 53-60-13, 51-40-02, 51-40-05 & 51-20-01.SDR SWAA2014040126716Pressure Panel · crackedMLG WW PRESSURE DECK CRACKED BETWEEN BS 664 - 675, BETWEEN RBL 24.5 TO RBL 45.5. REPAIRED DECK IAW SRM.SDR ASOA2014032810222Door Frame · corrodedAT COCKPIT DOOR OPENING, LT SIDE POST CORRODED ON AFT LOWER CORNER. R & R AREA LT SIDE DOOR POST OF CORROSION AND REPLACED WITH DOUBLER IAW REO 690-53-11-650 REO 690-53-11-650.SDR R61A201403050421Doubler · nickedDURING HEAVY CHECK, FOUND NICKS ON SPAR 2 DOUBLER. EAMS R & R THE DOUBLER IAW SRM 51-40-02.SDR FDEA201403050445Door Frame · damagedFWD E & E DOOR CUTOUT FWD FRAME HAS DAMAGE ON UPPER SURFACE AT BL 0. CUT OUT DAMAGED AREA, FABRICATED NEW FRAME AND TWO SPLICES AND INSTALLED ALL PARTS IAW SRM 51-70-11.SDR SWAA2014031025938Window Frame · crackedRT NR 3 WINDOW FRAME CRACKED AT NR 8 HOLE. REPAIRED FRAME IAW ACO.SDR SWAA2014031025898Window Frame · crackedR1 COCKPIT WINDOW FRAME CRACKED IN THE UPPER OTBD CORNER. REPAIRED FRAME IAW EA.SDR ASOA20140303022VBeam · corrodedDURING C-CHECK CARGO DOOR LOWER BEAM CORRODED, BETWEEN FRAMES 65-68. MAINTENANCE R & R CARGO DOOR BEAM IAW SRM 51-40-02 AND CPM 51-21-06. THE ACFT WAS APPROVED FOR RETURN TO MAINTENANCE.SDR SWAA2014033126659Window Frame · crackedLT NR 3 WINDOW FRAME E F POST FASTENER HOLES CRACKED. REPAIRED POST IAW ER & EA.SDR SWAA2014033126658Window Frame · crackedRT NR 3 WINDOW FRAME E F POST FASTENER HOLES CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014032026289Window Frame · crackedFLIGHT DECK RT NR 3 FIXED WINDOW FRAME FWD SIDE PANE ATTACH FASTENER HOLES, 2ND HOLE FROM BOTTOM CRACKED. R & R FRAME IAW EA.SDR SWAA2014032026280Window Frame · crackedFLIGHT DECK LT NR 3 FIXED WINDOW FRAME FWD SIDE PANE ATTACH FASTENER HOLES 2ND HOLE FROM BOTTOM CRACKED. R & R FRAME IAW EA.SDR SWAA2014032026279Window Frame · crackedFLIGHT DECK LT NR 3 FIXED WINDOW FRAME FWD SIDE PANE ATTACH FASTENER HOLES, 1ST HOLE FROM BOTTOM CRACKED. R & R FRAME IAW EA.SDR SWAA2014032026278Window Frame · crackedFLIGHT DECK RT NR 3 FIXED WINDOW FRAME FWD SIDE PANE ATTACH FASTENER HOLES 5TH HOLE FROM BOTTOM CRACKED. R & R FRAME IAW EA.SDR SWAA2014032026277Window Frame · crackedFLIGHT DECK RT NR 3 FIXED WINDOW FRAME FWD SIDE PANE ATTACH FASTENER HOLES 3RD HOLE FROM BOTTOM CRACKED. R & R FRAME IAW EA.SDR SWIA201436705Window Frame · crackedRT SIDE COCKPIT WINDOW LOWER SIDE POST FITTING HAS POSSIBLE CRACK. C-CHECK, REPLACED RT SIDECOCKPIT WINDOW LOWER SIDE POST FITTING, PN 601R33235-4 IAW SRM.SDR USAA2014030500001Crease Beam · corrodedC4 CHECK, LEVEL 2 GALVANIC CORROSION ON CREASE BEAM INBD CHORD AT BS 1320, LBL 60. REPLACED CREASE BEAM INBD CHORD AT BS 1320, LBL 60 IAW SRM 53-60-15, FIG 101, 51-40-05, 51-40-02 & 51-20-01.SDR FDEA201403030437Failsafe · chafedAFT CARGO BAY LT SIDE FRAME BS 1620, FAILSAFE CHAFED BETWEEN STRINGERS 29R & 29L. REPAIRED IAW EAF-5310-T0306258 PART 1. REPAIR IS MAJOR.SDR SWAA2014033126657Window Frame · crackedFLIGHT DECK LT NR 1 WINDOW UPPER OTBD FRAME CRACKED AT CORNER. REPAIRED FRAME IAW MM.SDR USAA2014031200002Crease Beam · corrodedC4 CHECK, LEVEL 2 FILIFORM CORROSION ON LT CREASE BEAM BETWEEN BS 1257 TO BS 1263, STRINGER 17L, LBL 64. REPAIRED LT CREASE BEAM BETWEEN BS 1257 TO BS 1263, STRINGER 17L, LBL 64 IAW EA 105715.SDR USAA2014030400005Crease Beam · corrodedC4 CHECK, LEVEL 2 GALVANIC CORROSION ON CREASE BEAM WEB BETWEEN BS 1350 TO BS 1360, STRINGER 17L. REPAIRED CREASE BEAM WEB BETWEEN BS 1350 TO BS 1360, STRINGER 17L IAW SRM 51-40-02 & DWG 146N8322.SDR IPXA2014032682414Tension Tie · crackedINSPECTION C, MAIN DECK BS 720 TENSION TIE TO FRAME ATTACHMENT FOUND CRACKED. REPAIRED IAW SRM 53- 20-30-2R, REPAIR 1, FIG 201, REV 69. MAJOR REPAIR.SDR IPXA2014032682413Tension Tie · crackedINSPECTION C, MAIN DECK BS 720 TENSION TIE FRAME ATTACHMENT FOUND CRACKED. REPAIRED IAW SRM 53- 20-30-2R. REPAIR 1 FIG 201, REV 69. MAJOR REPAIR.SDR IPXA2014032682412Tension Tie · crackedINSPECTION C, MAIN DECK BS 760 TENSION TIE TO FRAME ATTACHMENT FOUND CRACKED. REPAIRED IAW SRM 53-20-30-2R, REPAIR 1 FIG 201, REV 68. MAJOR REPAIR.SDR IPXA2014031482263Tension Tie · crackedINSPECTION C, BS 760 TENSION TIE TO FRAME ATTACHMENT AREA FOUND CRACKED. TENSION TIE CHANNEL REPAIRED IAW SRM 53-20-30-2R. REPAIR 1, FIG 201, REV 68. MAJOR REPAIR.SDR IPXA2014031482261Tension Tie · crackedINSPECTION C, MAIN DECK BS 760 TENSION TIE TO FRAME ATTACHMENT FOUND CRACKED. REPAIRED IAW SRM 53-20-30-2R, REPAIR 1, FIG 201 REV 68. MAJOR REPAIR.SDR CALA2014030390511Crease Beam · corrodedCORROSION ON WEB BETWEEN STATION 1060L - 1080L ON TOP OF CREASE BEAM. REPAIRED CREASE BEAM WEB FROM STATION 1060L - 1080L.SDR ASOA20140302046Beam · corrodedLOWER CARGO DOOR BEAM CORRODED BEYOND LIMITS. R & R BEAM.SDR ASOA20140302044Fitting · corrodedFRAME 68 DOOR CUTOUT FITTING CORRODED BEYOND LIMITS. R & R CUTOUT FITTING.SDR SIMA20140301010Door Frame · crackedPASSENGER DOOR FRAME INNER WEB CRACKED BETWEEN FRAME 16 & FRAME 17 ABOVE DOOR CUT OUT AT FWD LIGHTNING HOLE. PERFORMED REPAIR PAX DOOR FRAME INNER WEB BETWEEN FRAME 16 & FRAME 17 ABOVE DOOR CUT OUT AT FWD LIGHTNING HOLE IAW AEA ERS-EM-53MR-334 PART A.SDR FDEA201403010427Door Frame · damagedR4 DOOR AREA UPPER DOOR FRAME HAS A DEEP GOUGES & CRACKED. REPAIRED IAW EA 8-5310-306410 PART 1SDR SWAA2014032126306Window Frame · crackedNR 1 COCKPIT WINDOW FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME IAW EA.SDR SWAA2014031926216Window Frame · crackedLT COCKPIT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. R & R FRAME IAW EA.SDR UHLA2014022200219Support Bracket · crackedUPPER AND LOWER RADAR SUPPORT BRACKETS CRACKED. R & R IAW SRM 51-41-01. MAJOR REPAIRSDR UHLA2014022800196Support Bracket · crackedCORROSION FOUND ON UPPER AND LOWER SUPPORT BRACKETS CRACKED. R & R UPPER AND LOWER RADAR SUPPORTS AND ATTACH ANGLE.SDR SWAA2014030625811Crease Beam · corrodedR1 DOOR CREASE BEAM INNER CHORD CORRODED BETWEEN BS 294 TO BS 328, RBL 60. R & R CHORD IAW SRM & DRAWING.SDR CALA2014030390520Door Frame · crackedAFT PIT FRAME AT BS 1329, WEB & FITTING ARE CRACKED AT LOWER CARGO DOOR OPENING. REMOVED CRACK DAMAGE ON WEB, FABRICATED A REPAIR DOUBLER & TAPERED FILLER & INSTALLED IAW TIMCO REO G17129, REV A & ECRA 5360-01362 AT RBL 42.SDR DALA14014003219Crossbeam · corrodedDURING INSPECTION, FOUND CORROSION ON CROSSBEAM FITTING FRAME 53 STR 41. REPLACED CROSSBEAM IAW SRM A320 51-72-11 AND DWG D53470261.SDR DALA14013481810Structure · crackedRIGHT BS 1809.5 FWD OUTER CHORD FOUND CRACK BETWEEN S6 - 7R, REPAIRED IAW SRM 53-80-08, REPAIR 9.SDR SWAA2014072930454Window Frame · crackedFIRST OFFICER NR 1 WINDOW FRAME UPPER OTBD CORNER CRACKED ON INNER SURFACE. REPAIRED FRAME IAW EO.SDR SWAA2014072530295Window Frame · crackedLEFT NR 3 FLIGHT DECK WINDOW FRAME CRACKED AT THE 2ND LOWER FASTENER HOLE. REPAIRED FRAME IAW EO.SDR ASOA2014031910156Window Frame · crackedWINDSHIELD CENTER POST LOWER RT FITTING CRACKED. REMOVED FITTING ON W/S CENTER POST LWR RT SIDE IAW SRM 51-42-21. DRILLED UP NEW FITTING IAW SRM 51-40-11. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR IAW SOP 5702. INSTALLED FITTING IAW SRM 51-42-21 AND DWGSDR SWIA201436720Splice · chafedINTERIOR SPLICE ANGLE CHAFED, BS 559+80, S4R. INSTALLED NEW SPLICE ANGLE IAW SRM.
Back to JASC 5310