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 ASAA0945491Crease Beam · damagedR1DOOR CUTOUT I/B CREASE BEAM SPLICE HAS DAMAGED HOLE. REPLACED CREASE BEAM SPLICE PER SRM.SDR ASAA0945638Crease Beam · corrodedCREASE BEAM HAS AREAS OF CORROSION BS 380 440 WL 208 RBL 65. REPLACED CREASE BEAM IAW SRM.SDR ASAA0995415Plate · corrodedCORROSION FWD CARGO COMPARTMENT BS 500H+7 TO 500I+12 FLOOR TO SIDEWALL SUPPORT. SIDEPLATE REPLACED.SDR ASAA0995418Plate · corrodedCORROSION FWD CARGO COMPT BS 500G+16 LT FLOOR TO SIDEWALL SUPPORT CORRODED AT LOWER SURFACE. SIDEPLATE TO BE REPLACED.SDR ASAA0995416Plate · corrodedCORROSION FWD CARGO COMPARTMENT 500I+12 LT FLOOR TO SIDEWALL SUPPORT CORRODED AT FASTENERS. SIDEPLATE TO BE REPLACED.SDR ASAA0945426Crease Beam · corrodedCREASE BEAM HAS AREAS OF CORROSION BS 380-440 WL 208 RBL 65. REPLACED CREASE BEAM PER SRM 51-70-12.SDR ASAA0945398Crease Beam · crackedCREASE BEAM UPPER SPHERE IS CRACKED. REMOVED FABRICATED AND INSTALLED NEW CREASE BEAM SPLICE.SDR ASAA0945396Door Frame · crackedFWD GALLEY DOOR AFT FRAME CRACKED AT NR 3 AND 4 STOP FRAME CUTOUTS. BLENDED ON AFT NR 3 AND 4 CUTOUTS BOTH FOUND TO BE OUT OF LIMITS FABRICATED REPAIR DOUBLES TREATED AND INSTALLED.SDR ASAA0945395Door Frame · crackedFWD GALLEY DOOR AFT FRAME AND DOUBLER CRACKED AT LOWER STOP FITTING. REMOVED AND REPLACED.SDR ASAA0945394Door Frame · crackedFWD ENTRY DOOR AFT FRAME CRACKED AT NR 6 STOP PIN FITTING. REPAIRED IAW SRM 51-70-11.SDR AALA20090512TUL37Rib · wornSTA1039 HAS WORN RIB. REMOVED AND REPLACED KNUCKLE RIB ASSY PER AARD 27-80-00-2.SDR FDEA200904271416Crossbeam · corrodedFOUND CORROSION ON CROSSBEAM C 61 RT REPAIR PREFORMED BY RE-PLACEMENT OF PART IAW SRM 51-72-10.SDR SWIA200921898Stop Fitting · corrodedCARGO DOOR LATERAL STOPS ON FUSELAGE CORRODED. (C CHECK) REPLACED PER AMM.SDR ASAA0945285Crease Beam · corrodedCREASE BEAM WEB CORRODED. REPLACED WEB WITH FABRICATED CREASE BEAM WEB.SDR ASAA0945299Web · damagedFWD CARGO BAY DOOR CUTOUT WEB DAMAGED. REMOVED AND REPLACED WEB.SDR ASOA200900486Beam · crackedFS 280 OTBD OF RBL 9, TRANSVERSE BEAM IS CRACKED.SDR ASAA0945226Door Frame · corrodedCORROSION ON AFT CARGO DOOR CUTOUT AFT FRAME CLOSEOUT WEB. REMOVED WE FABRICATED NEW WEB WEB TO BE INSTALLED ON MIG 5.SDR ASOA200900476Post · damagedFOUND FS 409.0+128 VERTICAL POST LBL 18.0 OTBD SIDE HAS INDICATION NOTED A1TWL 69.0 AFT FLANGE APPROX .2 INCH IN LENGTH 50 PERCENT FSH FAILED NDT INSP. REMOVED VERTICAL POST IAW SRM 51-42-06. FABRICATED NEW VERTICAL POST IAW SRM 51-24-16. HEAT TREATED REPAIRSDR C2XA09TY067Frame · corrodedTYS - DURING C-CHECK CORROSION WAS FOUND AROUND THE SERVICE DOOR LOWER FRAME NUT PLATES. THE AREA WAS CUT OUT AND REPAIRED IAW EC 5310-01373. A/C STILL IN C-CHECK.SDR AALA20090512TUL24Beam · corrodedAFT CARGO DOOR BEAM HAS CORROSION. INSTALLED DOOR BEAM DOUBLER PER AARD 53-10-00-03.SDR SWAA092538Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM ANGLE CRACKED BETWEEN BS 291 TO BS 295, STR 17R. REMOVED AND REPLACED ANGLE PER SRM.SDR FDEA200904201349Web · corrodedCRACK INDICATION FOUND ON SECOND LAYER WEB FROM TOP DURING HFEC OPEN HOLE INSPECTION ON 0.520 INCH HOLE AT MAIN CARGO DOOR NR 1 LOWER JAMB AT HOLE C. REPAIRED AS PER EA 1-5310-129206, REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100 REVISION 107.SDR DL75E090709Structure · corrodedLAV SERVICE BOX CORRODED ON UPPER SIDE AT PLUMBING CONNECTION IN FWD CARGO COMPARTMENT AT FS 710 S21L. FABRICATED REPAIR DOUBLER ON NR 134068 AT SAA IN SAT DURING HMV VISIT.SDR DL75E090697Structure · corrodedMAIN CABIN FLOOR RT CUSP INNER CHORD CORRODED ON BOTH LEGS STA 324-377 RBL 64. REPLACED CHORD AT SAA/SAT DURING HMV VISIT ON NR 126393 JOB NUMBER 82599190001.SDR AALA20090512TUL36Structure · corrodedCORROSION ON SUBFLOOR AT STA 200, 12 INCH FORWARD OF NR 6 SEAT TRACK. INSTALLED DOUBLER AT STA 200 TO 218 PER AARD 53-20-16-00.SDR USAA2009041790921Attach Bracket · crackedCLT - C1 - MAJOR REPAIR - CRACK AT FORWARD CARGO DOOR FRAME ATTACH BRACKET AT BS 570, 14R. REPAIRED FORWARD CARGO DOOR FRAME ATTACH BRACKET AT BS 570, 14R IAW B737 SRM 51-40-02.SDR USAA2009041790922Door Frame · crackedCLT - C1 - MAJOR REPAIR - CRACK AT R4 DOOR FRAME AT BS 1650, S15R. REPAIRED R4 DOOR FRAME AT BS 1650, S15R IAW US AIRWAYS EA 101093.SDR FDEA200904151306Doubler · crackedAFT AIRSTAIR AREA - LOWER RT TORQUE BOX LIGHTNING HOLE HAS 2 STOP-DRILLED CRACKS AT BS 1243 CUT OUT DAMAGED AREA IAW SRM 51-10-1. FABRICATED 2 EA DOUBLERS IAW SRM 51-40-2 FIG 1 AND 53-10-2 FIG 6. ALODINED AND PRIMED PARTS AND AREA IAW SRM 51-10-2. INSTASDR DLM88090668Door Frame · corrodedFLOOR SUPPORT FWD EDGE OF AFT ENTRY DOOR FRAME STA 1361 CORRODED UNDER SEALANT. REPAIRED VERTICAL DOOR JAMB ERA 457386-14 REV ORIG DATED 4/7/09.SDR SWAA092439Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM WEB CRACKED BETWEEN BS 727B TO BS 727C, STR 17L. REPAIRED WEB PER SRM.SDR SWAA092438Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM CRACKED AT BS 639, RBL 64. REPAIRED BEAM PER SRM.SDR AALA20090424TUL28Beam · corrodedCORROSION ON MID CARGO DOOR BEAM DOUBLER. REMOVED CARGO DOOR BEAM DOUBLER AND REPLACED WITH NEW DOUBLER.SDR DLM88090675Window Frame · damagedLIGHTNING STRIKE AT WINDOW 17L DAMAGE CLEANED UP PER SRM 53 -05 FIGURE 111 AND ERA 474350-14.SDR SWAA092388Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FWD CARGO DOORWAY AFT SIDE FRAME CRACKED. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA092316Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 616 TO BS 639, STR 17R. REMOVED AND REPLACED WEB PER SRM.SDR C2XA09SH118Door Frame · corrodedSHV DURING C-CHECK, CORROSION ON SERVICE DOOR LOWER FRAME. REPAIRED SERVICE DOOR LOWER FRAME IAW EC 5210-01154. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR VNAA2009041500005Fastener · damagedCREW REPORTED LIGHTNING STRIKE IN CLT. MAINTENANCE FOUND AND REPAIRED BURNED RIVETS PER REO 670-53-00-045. NO OTHER DEFECTS WERE NOTED AFTER CHECKS BY AIRCRAFT MAINTENANCE MANUAL. AIRCRAFT WAS RELEASED FOR SERVICE.SDR FDEA200904091238Door Frame · crackedMAIN CABIN, FOUND CRACKS ON LWR AFT JAMB DOOR 3 LT. REPAIRED LWR DOOR JAMB IAW SRM 53-50-00 FIGURE 19 SHT 2 VOL I.SDR FDEA200904091237Door Frame · crackedMAIN CABIN, FOUND CRACK ON FWD UPPER JAMB DOOR 3 LT. REPAIRED UPPER DOOR JAMB WEB IAW SRM 53-50-00 FIGURE 19 SHT 1 VOL I.SDR FDEA200904091235Beam · crackedFOUND CRACK INDICATION ON BEAM 4 RT, C 49 OUTBOARD. REPAIR PERFORMED IAW DRAWING R538-10581, INSTALLATION OF REINFORCING ANGLE, SHIMS AND REPAIR STRAP.SDR IPXA09M55584Door Frame · misrepairedINSPECTION TYPE:1C REPAIR SURVEY SEQ F1-04, FWD CARGO DOOR JAMB AND EXISTING REPAIR BETWEEN FS 871-878 LONGERONS 35-38 RT, REPAIR DOUBLER GAUGE INCORRECT. REMOVED EXISTING DOUBLERS, REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR DOUBLERS AND FILLER IAW MD-11SDR AALA20090422TUL10Beam · damagedFASTENER HOLE DAMAGED IN AFT CARGO DOOR BEAM STATION 1163. INSTALLED FREEZE PLUG PER EA MD80-53-005908.SDR IPXA09M55583Door Frame · damagedINSPECTION TYPE:1C REPAIR SURVEY SEQ F1-02, CTR CARGO DOOR JAMB, EXISTING REPAIR DOUBLER DAMAGED AT AFT LWR CORNER BETWEEN FS 1787-1793 AND LONGERONS 39-42 RT. REMOVED EXISTING REPAIR DOUBLER, FABRICATED AND INSTALLED REPAIR FILLER, DOUBLER AND TRIPLER IAW MDSDR A6WA200940186Structure · crackedCLIP OF FS 280.00, LBL 9.0 INBD AND OTBD FOUND CRACKED IAW SRM 51-42-21. NEW CLIP OF FS 280.00 LBL 9.0 INBD AND OTBD INSTALLED. (K)SDR GLBA20090410FDoor Frame · crackedDURING SCHEDULED STRUCTURAL INSP MX DISCOVERED CRACKS AROUND THE CARGO DOOR UPPER FRAME AT FWD CORNER AREA AT FS 456 AND UPPER FRAME AFT CORNER AT FS 509. APPROXIMATE CRACK LENGTHS 5 INCHES AND 2.75 INCHES RESPECTIVELY. MX REPAIRED THE AFFECTED AREAS IAW EO-0SDR SWAA092262Door Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT BS 492. REPAIRED FRAME PER SRM.SDR SWAA092261Door Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT BS 440. REPAIRED FRAME PER SRM.SDR DU4R2009340Door Frame · corrodedS/O NR 312003 NR 24905, DURING SCHEDULED INSPECTION FOUND CORROSION ON TOP SIDE OF FRAME BS 793 RT SIDE INBD AND FWD OF CARGO DOOR CUTOUT AFT PIT.SDR DLM88090629Seat Track · corrodedCABIN SEAT TRACK CORRODED OUT OF LIMITS AT STATION 321 RBL 22. REPAIRED BY REPLACEMENT PER 51-30-5 ON AAR 240659.SDR AALA20090409TUL14Pan · crackedAFT UPPER WINDOW PAN TAB CRACKED AT FASTENER, STATION 1079 LEFT SIDE. CUT OUT CRACK AND INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.
Back to JASC 5310