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 SWAA2013082319448Window Frame · crackedFLIGHT DECK RT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER APPROXIMATELY 500" BELOW CORNER RADIUS. REPAIRED FRAME IAW EA.SDR CALA2013081990556Door Frame · leakingEXCESSIVE AIR NOISE COMING FROM R2 DOOR DURING DESCENT. PRESSURIZED ACFT AFTERWARD, NO LEAKS NOTED. ACCOMPLISHED REPAIR ON LWR FWD AND LOWER AFT DOOR FRAME.SDR C77A20130816004Finger Doubler · corrodedFORWARD CARGO DOOR CUTOUT STRUCTURE AFT FINGER DOUBLER HAS CORROSION AT X= 7505-7685 Y= 280-390. R & R AFT FINGER DOUBLER IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130820015Bushing · migratedNLG RETRACT ACTUATOR LWR INBD BUSHING IS MIGRATED. REPLACED NLG RETRACT ACTUATOR FITTING BUSHINGS IAW ED-LLI-10-0008 AND EO E17X-3200-007, REV IR.SDR C77A20130820014Seal Depressor · corrodedFORWARD CARGO DOOR CUTOUT STRUCTURE CENTER SEAL DEPRESSOR, PN 170-66804-401, HAS CORROSION AT X=7120-7675 Y=450. R & R CENTER SEAL DEPRESSOR IAW SRM 51-41-01 AND 51-43-01.SDR SWAA2013090319778Window Frame · crackedLT NR 3 WINDOW POST E-F CRACKED AT THE SECOND LOWER FASTENER HOLE. R&R FRAME IAW EA.SDR SWAA2013082719642Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME NR 2 HOLE CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013082719641Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME NR 1 HOLE CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013082719640Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME NR 3 HOLE CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013082719639Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME NR 2 HOLE CRACKED. REPAIRED FRAME IAW EA.SDR FDEA201308161908Door Frame · crackedMAIN DECK CARGO LOWER FRAME NR 1 FITTING FOUND HOLE "B", 3RD LAYER AFTER REAMING TO MAXIMUM IAW SRM STILL SHOWING CRACK INDICATION.SDR SWAA2013082919700Window Frame · crackedLT MAIN CABIN WINDOW FRAME CRACKED AT STATION 908. R&R FRAME IAW MM.SDR R61A201308150756Crossbeam · corrodedDURING HEAVY CHECK, CROSSBEAM AT FRAME 14 CORRODED. MX R & R CROSSBEAM IAW SRM 51-40-2, 51-43-03, 51-41-01, 51-43-01.SDR FDEA201308151903Crease Beam · corrodedL2 DOOR INBD CREASE BEAM CHORD CORRODED. REMOVED CORROSION IAW-SRM-51-10-02, ORIG. MAT .080 100 PERCENT MAT LOSS, OUT OF LIMITS IAW-SRM-53-30-15 DETAIL VI FIG 101, PROCURED NEW BEAM PN 143N8328U53, BATCH 0002482082, LOCATED AND DRILLED IAW SRM-51-40-02 AND DWSDR RAIA201308140010Beam · corrodedDOUBLER ON BEAM Y-479.0 AT FR22 IS CORRODED BEYOND LIMITS. MX REPLACED DOUBLER.SDR RAIA201308140009Beam · corrodedDOUBLER ON BEAM Y-479.0 AT FR20 IS CORRODED BEYOND LIMITS. MX REPLACED DOUBLER.SDR RAIA201308140004Beam · corrodedBOTH FWD AND AFT BEAM ASSY NEAR PASSENGER DOOR AT Y-479.0 CORRODED BEYOND LIMITS. MX REPLACED BOTH ANGLES.SDR SWAA2013082719638Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED AT UPPER 2 FASTENER ON INNER SIDE ATTACHMENT. R&R FRAME IAW ACO.SDR SIMA20130814012Structure · crackedCRACK ON FWD AVIONICS DOOR OPENING. PERFORMED DVI IAW EO-EM-53MR-2092 PTB. NO FURTHER DAMAGE NOTED.SDR C77A20130814002Floorbeam · damagedFASTENER HOLE ELONGATED ON CROSSBEAM AT FRAME 89.SDR AALA20130819002Pan · crackedRT WINDOW RINGPAN CRACKED AT UPPER TAB STATION 1192. COMPLETED RINGPAN DOUBLER REPAIR IAW AARD 53-10-00 REPAIR 25.SDR DALA13039899206Door Frame · gougedAFT CABIN ENTRY DOOR FRAME IS GOUGED IN SEVERAL PLACES. REMOVED DAMAGE. FOUND TO BE OUT OF LIMITS. R & R CHANNEL IAW SRM 51-30-05, 51-30-02, 51-30-04.SDR DALA13039499206Door Frame · gougedAFT CABIN ENTRY DOOR FRAME, BOTTOM SIDE, IS GOUGED IN SEVERAL AREAS. REMOVED DAMAGE. FOUND TO BE OUT OF LIMITS. R & R CHANNEL IAW SRM 51-30-05, 51-30-02 AND 51-30-04.SDR SWAA2013081519239Window Frame · crackedNR 1 LT COCKPIT WINDOW FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME IAW SRM.SDR ASOA20130814209VBeam · corrodedDURING SCHEDULED MX, THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MX R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA13039310965Door Frame · corrodedDURING ROUTINE INSPECTION, CORROSION WAS NOTED AT THE AFT CARGO DOOR JAMB ADJACENT TO LONGERON 28R AND SEVERAL LOCATIONS. REPAIRS INCORPORATED IAW SRM 53-05 AND ALL APPLICABLE INSPECTIONS COMPLETED.SDR FDEA201308131856Frame · crackedLEFT FUSELAGE FRAME 43 FOUND CRACKED. REPAIRED IAW EA 6-5310-T0301727.SDR DALA13039889206Door Frame · gougedAFT CABIN ENTRY DOOR LOWER RT FRAME GOUGED. R & R AFT CABIN ENTRY DOOR LOWER RT IAW SRM 51-30-02, 51-30-01, AND DWG 9929480.SDR ASOA20130814208VBeam · corrodedDURING C-CHECK THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED. MX R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR CALA2013081400564Structure · crackedCTR WING BOX REAR SPAR WEB AT BS 663 RT SIDE FOUND 1 INCH CRACK AT RBL 42 & WL-197. ALL WORK ACCOMPLISHED IAW SRM 57-10-10, REPAIR-3, PAGE-209, FIG-20 4 AND IAW PAGE 211, TABLE-B.SDR CALA2013081400563Structure · crackedCENTER WING BOX REAR SPAR WEB AT BS 663 LT SIDE FOUND 1" CRACK AT LBL-43 & WL-197. ALL WORK ACCOMPLISHED IAW SRM 57-10-10, REPAIR-3, PAGE-209, FIG-20 4 AND IAW PAGE 211, TABLE-B.SDR FDEA201308131853Door Frame · crackedMAIN DECK R3 DOOR AFT FRAME LOWER CORNER WEB FOUND CRACKED. REPAIRED IAW SRM 53-40-15, FIG 201, REPAIR 3, REV 53. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REVISION 116.SDR FDEA201308131850Door Frame · crackedMAIN DECK R3 DOOR FORWARD FRAME LOWER CORNER WEB FOUND ONE CRACK. REPAIRED IAW SRM 53-40-15, FIG 201, REPAIR 3, REV 53, REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 116.SDR SWAA2013082719622Door Frame · crackedFWD CARGO DOOR CUTOUT FRAME WEB CRACKED AT BS 440, STRINGER 24R. R&R FRAME IAW EA.SDR SWAA2013082719637Window Frame · crackedNR 1 LT WINDOW FRAME CRACKED. R&R FRAME IAW ACO.SDR FDEA201308121834Crease Beam · corrodedBS 756 TO 780 LT INBD CREASE BEAM IS CORRODED. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53 -30-13, FIG 101, DETAIL VIII. R & R CREASE BEAM BS 760 -900 IAW SRM 51-40-02 AND 143N5522-27. MAJOR REPAIR.SDR SWAA2013081319166Window Frame · crackedLT NR 3 WINDOW FRAME NR 8 HOLE CRACKED. REPAIRED FRAME IAW SRM.SDR MJYA20130813007Structure · corrodedACFT LT SIDE REAR FUSELAGE, UN-PRESSURIZED AREA AFT OF VENT LOUVERS HAS CORROSION.SDR SIMA20130812003Crossbeam · crackedDURING MBV INSPECTION, FOUND CROSSBEAM SUPPORT IN THE NOSE WHEELWELL CRACKED. R & R CROSSBEAM IAW SRM 51-40-02.SDR IPXA3B79963Tension Tie · crackedINSPECTION C, M/D LT BS 820, TENSION TIE FWD CHANNEL FOUND CRACKED AT 1 EA HOLE RUNNING UPWARD AND DOWNWARD BOTH CRACKS APPROX 0.030" IN LENGTH. REPAIRED IAW SRM 53-20-30- 2R-2, REPAIR 2, FIG 201, REV.67, MAJOR REPAIR.SDR IPXA3B79962Tension Tie · crackedINSPECTION C, M/D RT BS 820 TENSION TIE FWD CHANNEL 1 EA HOLE FOUND CRACKED APPROX 0.060" IN LENGTH RUNNING DOWNWARD. M/D RT STA 820, TENSION TIE FWD CHANNEL IS REPAIRED IAW SRM 53-20-30-2R-2, REPAIR 2, REV 201, REV.67, THIS REPAIR IS CLASSIFIED AS A MAJOR RESDR IPXA2013082300941Tension Tie · crackedINSPECTION TYPE: C, BS 740 TENSION TIE AFT CHANNEL FOUND CRACKED. REPAIRED IAW SRM 53-20-30-2R-1, REPAIR 1, FIG 201, REV 67.SDR IPXA2013082300940Tension Tie · crackedINSPECTION TYPE: C, BS 720 TENSION TIE AFT CHANNEL FOUND CRACKED. REPAIRED IAW SRM 53-20-30-2R-1, REPAIR 1, FIG 201, REV 67.SDR IPXA2013082300939Tension Tie · crackedINSPECTION TYPE: C, BS 760, TENSION TIE AFT CHANNEL FOUND CRACKED. REPAIRED IAW SR SRM 53-20-30-2R-1. REPAIR 1, FIG 201, REV 67.SDR IPXA2013082300938Tension Tie · crackedINSPECTION TYPE:C, BS 760 TENSION TIE FWD CHANNEL FOUND CRACKED. REPAIRED IAW SRM 53-20-30 -2R-2, REPAIR 2, FIG 201, REV 67. MAJOR REPAIR.SDR IPXA3B79936Tension Tie · crackedINSPECTION TYPE:C, BS 760, TENSION TIE FWD CHANNEL CRACKED. REPAIRED IAW SRM 53-20-30-2R-1, REPAIR 1, FIG 201, REV 67. MAJOR REPAIR.SDR IPXA3B79934Tension Tie · crackedINSPECTION TYPE:C, MAIN DECK BS 740 TENSION TIE FWD CHANNEL FOUND CRACKED. REPAIRED IAW SRM 53-20-30-2R-1, REPAIR 1, FIG 201, REV67. MAJOR REPAIR.SDR CALA2013081200561Door Frame · crackedR1 DOOR CUTOUT, FWD FRAME, LOWER INBD FLANGE CRACKED. REPAIRED IAW EC/RA 5311-01626.SDR ASOA20130811361TDoor Frame · corrodedC-CHECK, THE CARGO DOOR FWD LWR SIDE WAS FOUND WITH 3 NUTPLATES SURROUNED BY CORROSION. MX CUT OUT THE DAMAGE AND INSTALL A FILLER WITH A INTERNAL DOUBLER IAW EC 52-30-10304.SDR SWAA2013082719636Window Frame · crackedRT NR 1 WINDOW FRAME TOP OTBD CORNER CRACKED IN FRAME. R&R FRAME IAW ACO.
Back to JASC 5310