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 UHLA2013092100466Gusset · corrodedCORROSION FOUND ON RT GUSSET AT FRAME 90. R & R GUSSET.SDR UHLA2013092100465Splice · corrodedCORROSION FOUND ON RT SPLICE PLATE FRAME 90. R & R SPLICE PLATE .SDR UHLA2013092100463Splice · corrodedCORROSION FOUND ON LEFT SPLICE PLATE FRAME 90. R & R SPLICE PLATE.SDR FOTR2013102500047Door Frame · corrodedFWD CARGO BAY DOOR FRAME FWD SIDE CORRODED STR 25-26R. REPAIRED.SDR FDEA201309202265Crease Beam · corrodedBS 755-780 RT CREASE BEAM INBD ANGLE FOUND CORROSION AT UPPER & LOWER SURFACES AROUND FASTENER HOLES. REPAIRED IAW EA F-5310-T0302508. REPAIR CALSSIFED MAJOR PER GMM 6-2-100.SDR UHLA2013092000481Crossbeam · corrodedCORROSION FOUND ON RIVETS ON RT SEAL CROSSBEAM 84. R & R CROSSBEAM.SDR SWAA2013101121092Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME E-F POST, 2 NS FASTENER HOLE FROM BOTTOM CRACKED AT FORWARD & AFT SIDES OF FASTENER HOLE. R & R FRAME IAW DRAWING & EA.SDR SWAA2013101121091Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME E-F POST CRACKED AT FORWARD & AFT SIDES OF FASTENER HOLE. R & R FRAME IAW DRAWING & EA.SDR SWAA2013100820986Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME E-F POST, 5TH FASTENER HOLE FROM BOTTOM CRACKED. R & R FRAME IAW EA.SDR SWAA2013100820985Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME E-F POST, 4TH FASTENER HOLE FROM BOTTOM CRACKED. R & R FRAME IAW EA.SDR SWAA2013100720934Window Frame · crackedNR 1 RT COCKPIT WINDOW FRAME CRACKED IN THE UPPER OTBD CORNER VERTICAL FLANGE UPPER HOLE. R & R FRAME IAW ACO.SDR SWAA2013100720933Window Frame · crackedLT NR 1 WINDOW FRAME ASSEMBLY CRACKED AT UPPER AFT HOLE. R & R FRAME IAW ACO.SDR SWAA2013100320761Window Frame · crackedLT NR 1 COCKPIT WINDOW CRACKED IN UPPER OTBD CORNER. R &R FRAME IAW ACO.SDR EVCA201309230050Stiffener · crackedDURING ROUTINE INSPECTION, THE MECHANIC FOUND A CRACK IN THE STIFFENER ANGLE AT THE TOP OF THE VERTICAL TUNNEL ACCESS PANEL.SDR LR7A2013092000714Beam · crackedDURING SCHEDULED B-2 CHECK, FOUND RT MLG LOWER WHEEL WELL BOW BEAM FS557 UPPER END CRACKED, FS 557 WL 200 RBL 61. REPAIRED IAW SMP583 SRM FIG. 53-40-14.SDR SWAA2013100320760Window Frame · crackedRT NR 1 WINDOW FRAME OTBD UPPER AFT FASTENER HOLE CRACKED. R & R FRAME IAW ACO.SDR GLBA2013091900318Door Frame · crackedDURING A SCHEDULED INSPECTION, MX FOUND THE CARGO DOOR FWD FRAME AT FS 456 CRACKED AT THE UPPER INBD GAS STRUT MOUNT ATTACHING NUT PLATE. THE CRACKS RADIATE UPWARD AND INBD FROM THE NUT PLATE. REPAIRED IAW EO 13-1900-53-074. MAJOR REPAIR.SDR GLBA2013091900317Door Frame · crackedDURING A SCHEDULED INSPECTION, MX FOUND THAT THE AIRSTAIR DOOR LOWER AFT FRAME CORNER AREA AT APPROXIMATELY FS 172.35 WAS CRACKED, 1.2" IN THE OTBD UPPER BEND RADIUS. REPAIRED IAW EO 13-1900-53-061. MAJOR REPAIR.SDR AALA20130918017Door Frame · crackedRT NR 1 DOOR CUTOUT CRACKED AT FRAME ATTACH FASTENER TO CREASE ANGLE, STATION 312. INSTALLED DOUBLER REPAIR IAW SRM 51-70-11-2R.SDR SWAA2013100220706Crease Beam · corrodedRT CREASE BEAM WEB CORRODED BETWEEN BS 500B & BS 500C. REPAIRED WEB IAW SRM.SDR CHQA20130918351Door Frame · corrodedDURING INSPECTION, SERVICE DOOR LOWER FRAME WAS FOUND TO BE CORRODED. THE FRAME WAS REPAIRED IAW SRM 51-10-03 AND ETD 2013-145-042010.SDR R61A201309180896Structure · corrodedDURING HEAVY CHECK, FWD CARGO DOOR FRAME LOWER FWD AFT CORNER SEAL REST HAVE MULTIPLE NUTPLATES WITH CORROSION AND DAMAGED PAINT. MX R & R SEAL REST CORNER SECTION, PN 170-66803-402, SEAL REST. ACFT REMAINS UNTIL COMPLETION OF HEAVY CHECK.SDR DALA13052290955Beam · corrodedCORROSION ON MID CARGO BAY DOOR FRAME BEAM FROM BS 636 TO 670. REPAIRED IAW ER/A 519117-14.SDR SWAA2013100720875Door Frame · crackedFWD CARGO DOOR FWD FRAME CRACKED AT LOWER STOP FITTING UPPER SIDE AT FASTENER HOLE LOCATION. R & R FRAME IAW SRM & DRAWING.SDR ASOA2013101109202Crossbeam · corrodedCORROSION ON END OF CROSSBEAM AT BS 349.00, RBL 45. REMOVED CORROSION IAW SRM 51-21-06-00.SDR SWAA2013100220665Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME E-F POST SECOND LOWER CORNER FASTENER HOLE CRACKED AT FWD & AFT SIDES OF FASTENER HOLE. R & R FRAME IAW EA & DRAWING.SDR CALA2013091600670Door Frame · damagedR1 FWD DOOR JAMB LOWER REVEAL HAS INBD SECTION MISSING. REPAIRED R1 DOOR STATION 296.4 STUB FRAME IAW ECR4A 5311-01629.SDR SWAA2013100720905Window Frame · crackedLT NR 3 WINDOW FRAME E-F POST SECOND LOWER CORNER FASTENER HOLE CRACKED. R & R FRAME IAW EA.SDR SWAA2013100720904Window Frame · crackedRT NR 3 WINDOW FRAME E-F POST SECOND LOWER CORNER FASTENER HOLE CRACKED. R & R FRAME IAW EA.SDR SWIA201334774Door Frame · corrodedAVIONICS BAY DOOR SURROUND STRUCTURE HAS CORROSION AT FWD LT CORNER, AFT LT & RT CORNER, ALONG LT, RT SIDES & AFT EDGE. C-CHECK REMOVED CORROSION IAW REO.SDR SWIA201334775Door Frame · corrodedAVIONICS BAY DOOR SURROUND STRUCTURE HAS CORROSION AT FWD RT CORNER & IN CENTER. C-CHECK REMOVED CORROSION IAW REO.SDR DALA1502000967Lock Fastener · shearedFOUND TWO LOCK FASTENERS WITH HEADS SHEARED. RT SIDE OF FUSELAGE BS 1463 RT WHERE VERTTCAL STABILIZER MEETS THE FUSELAGE, R & R THE LOCK FASTENER IAW SRM 51-30-5.SDR SIMA20130913011Profile · corrodedFRAME 65 LT PROFILE CORRODED AROUND CARGO DOOR SILL AREA. REPAIRED IAW EO EM-53MR-1129.SDR SWAA2013092320435Window Frame · crackedFUSELAGE FLIGHT DECK LT NR 1 WINDOW FRAME CRACKED. REPAIRED FRAME IAW SWA EA.SDR SWAA2013092320434Window Frame · crackedFS FLIGHT DECK RT NR 1 WINDOW FRAME CRACKED. REPAIRED FRAME IAW SWA EA.SDR SCNA20131004161Support Frame · corrodedAFT WET AREA LBL 31 SUPPORT FRAME HAS CORROSION AT BS 992. FABRICATED, LOCATED & DRILLED NEW SUPPORT FRAME.SDR SWAA2013093020567Crease Beam · corrodedLT CREASE BEAM CORRODED AT BS 706 WL 208. R & R BEAM IAW ER & EA.SDR AALA20130917017Door Frame · corrodedAFT CARGO DOOR FORWARD FS FRAME AT STATION 1380 & STRINGER 25 RT CORRODED AT AREA OF CARGO DOOR DOWN SWITCH. ACCOMPLISHED REPAIR IAW SRM 53-00-07-2R-2.SDR FDEA201309122189Support Fitting · crackedDURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION, NR 7 LOWER DOOR FRAME SUPPORT FITTING, FOUND HOLE "D" CRACKED. AFTER REWORK TO SIZE 0.560" CRACK STILL EXISTS. SUPPORT FITTING REMOVED AND REPLACED IAW SRM 51-33-01 REVISION 53. REPAIR CLASSIFIED ASDR FDEA201309122188Support Fitting · crackedDURING OPEN HOLE HIGH FREQUENCY EDDY CURRENT INSPECTION, FOUND LOWER DOOR FRAME SUPPORT FITTING FOUND HOLE "A" CRACKED. REWORKED TO SIZE 0.560" CRACK STILL EXISTS. SUPPORT FITTING REMOVED AND REPLACED IAW SRM 51-33-01 REVISION 53. REPAIR CLASSIFIED AS MAJORSDR FDEA201309122199Angle · corrodedL1 DOOR SILL, CREASEBEAM STA 330-380, WL 208, CORRODED. FOUND OUT OF LIMITS IAW SRM 51-10-02 STEP 15 AND SRM 53-10-08 FIG 101 DET IX. REMOVED AND REPLACED WITH NEW CREASE BEAM ANGLE IAW DWG 657N3381 AND SRM 51-40-02. MAJOR REPAIR.SDR FDEA201309112182Crease Beam · corrodedBS 1340 -1360, RT CREASE BEAM INBD ANGLE FOUND CORRODED AROUND FIVE FASTENER HOLES. REMOVED AND REPLACED WITH NEW ANGLE IAW DWG 146N8322 SHT.1 REV F. MAJOR REPAIR.SDR FDEA201309112181Crease Beam · corrodedBS 1320-1360, LT CREASE BEAM INBD ANGLE FOUND CORRODED AROUND FASTENER HOLES. REMOVED AND REPLACED WITH NEW ANGLE IAW DWG 146N8322 SHT.1 REV.F. MAJOR REPAIR.SDR DALA13044916811Crease Beam · corrodedMAIN CABIN CREASE BEAM WEB CORRODED BS 1360-1380, RT SIDE. REMOVED CORROSION, TREATED AND PRIMED BLENDED AREA REF SRM 51-10-02.SDR DALA13044210930Door Frame · crackedFOUND LT WHEEL WELL DOOR JAMB FWD CRACKED. REPAIR IAW ER/A 497265-14MA.SDR DALA13044000949Dome Nut · corrodedRUSTED DOME NUTS ON INNER FUSELAGE SKIN STA 266 AND 296. PROJECTION LONG 1 (FCS) (MRB 53-139-02). ANTENNA TCAS PLATE INTERCOSTALS LONG SECTION WERE REMOVED. NEW LONGERON WAS DRILLED INSTALLED. INSTALLED ALL COMPONETS PREVIOSLY REMOVED IAW SRM 51-30-5, 51-3SDR C77A20130911003Seal Depressor · corrodedFWD CARGO DOOR CUTOUT STRUCTURE AFT SEAL DEPRESSOR, HAS CORROSION AT X=8558, STR 24-26R. R & R FWD SEAL DEPRESSOR IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130911001Seal Depressor · corrodedFWD CARGO DOOR CUTOUT STRUCTURE, CENTER SEAL DEPRESSOR, HAS CORROSION. R & R CENTER SEAL DEPRESSOR IAW SRM 51-41-01 AND 51-43-01.SDR CALA2013091091194Post · gougedFOUND LT SIDE LOWER ATTACHMENT AREA OF WINDSHIELD SIDE POST GOUGED ON TOP SIDE OF AREA IAW 53-11-00-210-014-A PAGE 5. BLENDED GOUGE IAW SRM 51-73-00.SDR SWAA2013100720801Window Frame · crackedRT NR 1 WINDOW FRAME UPPER CORNER CRACKED. R &R FRAME IAW SRM & DRAWING.
Back to JASC 5310