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 06FDEA03384Shear Web · damagedFOUND NUMEROUS DOUBLE HOLES IN SHEAR WEB BS 1130-1176, LBL 25-45, WL 208. REMOVED AND REPLACED SHEAR WEB PER SRM 51-30-2.SDR 06FDEA03382Shear Web · misdrilledWHILE WORKING N00648 FOUND NUMEROUS DOUBLE HOLES IN SHEAR WEB BS 1130-1176, RBL 25-45, WL 208. REMOVED, FABRICATED AND INSTALLED SHEAR WEB IAW SRM 51-30-02.SDR SWAA063571Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR 2007FA0000131Crease Beam · corrodedAFT GALLEY DOOR CREASE BEAM INNER CHORD ANGLE, BS 947 TO 992, STRINGER 17R, WL 208, CORROSION OUT OF LIMITS. (K)SDR C2XA06SH095Beam · corrodedSHV- DURING C CHECK, THE BAGGAGE DOOR LOWER CUT BEAM WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED BEAM IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR QXEA200602553Stop · wornC4 YYC - FUSELAGE MID LEFT STATION 355, 376, EMERGENCY EXIT DOOR STOPS, UPPER, LOWER AND FORWARD AND AFT ARE WORN. REPAIRED IAW RD8-53-126.SDR SWAA063510Door Frame · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR LOWER FRAME CRACKED AT LOWER AFT DOOR STOP. REMOVED AND REPLACED R1 DOOR PER MM.SDR 06FDEA03335Door Frame · corrodedEXFOLIATING CORRSIONON P/N AFA3931-501 CARGO DOOR JAMB LOWER FITTING STA 1875 TO 1821 FROM CLOGGED DRAIN HOLES. REMOVE CORROSION AND OPENED DRAIN HOLES IN AFT UPPER TORQUE BOX AT FS 1827 IAW MD/DC10 SRM 53-00-01 FIG 1B VOL II AND EA 8-5310-94486.SDR KCSA061319Shear Web · crackedRT BS 820 SLOPING SHEAR WEB CRACKED AT IB RADIUS ABOVE STR 12R .5 INCH LONG.SDR A6WA200640351Beam · crackedTRANSVERSE BEAM AT FS 250, RBL 30, NEAR STRINGER 16 IS BENT AND CRACKED .3 INCH INBOARD OF STRINGER 16. MAINTENANCE REPAIRED TRANSVERSE BEAM IAW EO 601R-53-9822. (M)SDR USAA061167Web · corrodedFOUND CORROSION BETWEEN STA 1006 AND 1016 BELOW FLOOR AT WATER LINE SHIELD. REMOVED CORROSION INSTALLED DOUBLER IAW SRM 51-10-02 LEVEL 1 C53-202-01, DEFECT SIZE: 1".SDR SWAA063465Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER BOEING DRAWING AND ACO.SDR SWAA063449Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME SECTION PER EA.SDR DLM88070397Door Frame · corrodedSEVERAL CORROSION POINTS IN THE AFT CARGO COMPARTMENT DOOR JAMB BEAM BETWEEN STA Y=1155.0 AND 1212.0. CORROSIONS BLENDED OUT. ACCOMPLISHED PERMANENT REPAIR FOLLOWING INSTRUCTIONS AND RECOMMENDATIONS CONTAINED IN THE MD-80 SRM 53-05D, FIG 63, INCLUDING MINOR SDR DLM88070407Window Frame · damagedDAMAGE IN CABIN WINDOW FRAMES - LIGHTNING STRIKE DAMAGE WAS FOUND IN THE CORNERS ON NR 60 AND 62 CABIN WINDOW FRAMES. PERMANENT REPAIRS INSTALLED PER ERA 385062-14 REV C. THE WINDOW BELT PANEL P/N 9958156-1 WAS REPLACED PER BOEING DRAWING 5930543-577.SDR 06FDEA03236Door Frame · corrodedMAIN DECK CARGO, FOUND R3 DOOR CUTOUT LOWER FORWARD AND AFT CORNER SEAL LAND LOCATION WITH CORROSION. CORROSION REMOVED AS PER SRM 51-21-01 VOLUME II AND FOUND WITHIN LIMIT AS PER SRM 53-50-00 FIGURE 17 VOLUME I. ORIGINAL THICKNESS = 0.270", MATERIAL RESDR 06FDEA03235Door Frame · corrodedMAIN DECK CARGO, FOUND L3 DOOR CUTOUT LOWER FORWARD AND AFT CORNER SEAL LAND LOCATION WITH CORROSION. MAIN DECK CARGO LT HAND DOOR FORWARD AREA CORROSION REMOVED AS PER SRM 51-21-01 VOLUME II. MATERIAL THICKNESS = 0.270", REMAINING THICKNESS = 0.235", MATERIASDR QXEA200602488Window Frame · corrodedC3 PDX - PASSENGER CABIN LEFT WINDOW FRAME HAS CORROSION AROUND LOCK FASTENER 5TH FROM TOP ALONG FORWARD EDGE OF FS X401.000. REPAIRED IAW SRM 51-21-00, 51-21-10, AND 51-25-10.SDR UPS06447973Window Frame · corrodedFOUND CORROSION ON UPPER RT (F/O'S) R1 WINDOW FRAME. BEGAN REMOVAL OF CORROSION BY MECHANICAL MEANS AS PER SRM 56-10-01 & 51-10. REMOVED FILLER AND FAB'D NEW PART PER DWG 69B10705-1. OK TO INSTALL FILLERS. INSTALLED FILLERS PER SRM AND B747 52-30-02.SDR 060602Rib · corrodedTHE DEFECT WAS DISCOVERED DURING THE INITIAL COMPLIANCE WITH AD 2002-26-02 ON AN AIRCRAFT THAT HAD BEEN IN STORAGE FOR A NUMBER OF YEARS. AN APPROXIMATE 0.5 INCH BY 0.25 INCH AREA AT THE BOTTOM EDGE OF A LIGHTENING HOLE WAS CORRODED AND FLAKING. A COLLECTION OSDR 2006UALA01750Crease Beam · corrodedFOUND CABIN FLOOR CREASE BEAM WEB IS CORRODED BS 635-639 LBL 69 WL208. REMOVED AND REPLACED WEB.SDR AWXA200601602Door Frame · crackedMCN - FOUND CRACK IN R-1 DOOR CUTOUT FWD FRAME AT UPPER STOP FITTING O/B SIDE IN RADIUS, HFEC VERIFIED. REMOVED AND REPLACED R-1 DOOR CUTOUT FWD UPPER FRAME IAW B737-300, SRM 51-40-02-06, FIGS 3, 8, AND 12.SDR AWXA200601600Door Frame · crackedMCN - FWD CARGO DOOR CUTOUT, AFT FRAME CRACKED AT LOWER DOOR STOP FITTING. REPAIRED CARGO DOOR CUTOUT AFT FRAME IAW ER 03-5332-06250-ES1.SDR SWAA063379Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 907 TO BS 927, STR 17L. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA063378Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 727B TO BS 727C, STR 17L. REPAIRED CREASE BEAM WEB PER SWA EA.SDR QXEA200602554Stop · wornC4 YYC - FUSELAGE INTERIOR MID RIGHT AT STATION 355 AND 376. EMERGENCY DOOR EXIT STOPS, UPPER, LOWER, FORWARD AND AFT ARE WORN. REPAIRED IAW RD8-53-126 AND SRM 51-20-26.SDR 0601999613Door Frame · crackedDURING L-CHECK FOUND CRACK IN RIGHT MAIN LANDING GEAR DOOR CUTOUT FRAME. REPAIRED PER EA 96-206883.SDR SWAA063324Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063323Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 06FDEA03197Door Frame · damagedINTERNAL FUSELAGE MAIN CABIN STA 1305 TO 1315 BETWEEN LONG 26 TO 27 RT R3 DOOR JAMB EXISTING REPAIR REMOVED AND REPAIRED IAW SRM 53-50-00 FIG 19 VOL 1.SDR 06FDEA03196Door Frame · damagedINTERNAL FUSELAGE MAIN CABIN STA 1305 TO 1315 BETWEEN LONG 26 TO 27 LT R3 DOOR JAMB EXISTING REPAIR REMOVED AND REPAIRED IAW SRN 53-50-00 FIG 19 VOL 1.SDR 06FDEA03195Door Frame · damagedINTERNAL FUSELAGE MAIN CABIN STA 1305 TO 1315 BETWEEN LONG 26 TO 27 RT R3 DOOR JAMB EXISTING REPAIR REVED AND REPAIR IAW SRM 53-50-00 FIG 19 VOL 1.SDR 06FDEA03194Door Frame · damagedINTERNAL FUSELAGE MAIN CABIN STA 1249-1254 BETWEEN LONG 26 LT TO 27 L3 DOOR JAMB EXISTING REPAIR REMOVER AND REPAIRED IAW SRM 53-50-00 FIG 19 VOL 1.SDR USAA061133Door Frame · crackedFWD SERVICE DOOR CUTOUT FWD FRAME CRACKED AT UPPER STOP FITTING. REPLACED FRAME 1141088, IAW SRM 51-10-02, DEFECT SIZE: .187 INCH.SDR USAA061132Door Frame · corrodedFROM STA 787 DOOR CLOSEOUT FRAME AT STA 25R CORROSION. REPLACED PART IAW SRM 51-10-02 LEVEL 1 C53-208-01, DEFECT SIZE: .5 X .5 INCH.SDR 0601989756Door Frame · crackedDURING H-CHECK FOUND CRACKS IN THE LOWER AFT CORNER OF FWD SERVICE DOOR JAMB. REPAIRED PER EA 97-206872.SDR UPS06M48167Strut · damagedINSPECTION TYPE:C FWD CARGO,AT STA 6.30 LT, X=16.5 FOUND STRUT DAMAGED FWD CARGO AT STA 6.30 LH, X=16.5 DAMAGED STRUT REMOVED AND NEW STRUT INSTALLED AS PER DRAWING ADA0033 AND SRM 51-31-01 VOL II REV 38.SDR TRAX200600698Door Frame · crackedSERVICE DOOR FWD DOOR FRAME BOTTOM STIFFENER CRACKED.SDR DHL2006745522Window Frame · corrodedFOUND CORROSION ON WINDOW FRAME BS 950C +10" LEFT SIDE. CORROSION ON WINDOW FRAME SKIN WAS FOUND OUT OF LIMITS, MATERIAL REMOVED .008" IAW B727 SRM 56-20-1. REMOVED FASTENERS IAW B727 SRM 51-30-2. FABRICATED REPAIR DOUBLER USING 2024 T3, .160", PO NR 614918SDR SWAA063287Door Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063286Door Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063278Door Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT LOWER INBOARD STOP. REPAIRED FRAME SECTION PER EA.SDR SWAA063275Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP FITTING. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 2006UALA02272Door Frame · crackedMAIN ENTRY DOOR 2R FRAME IS CRACKED AT UPPER HINGE CUTOUT. REPLACED WITH A NEW MAIN ENTRY CABIN DOOR. REMOVED DOOR SENT TO SHOP FOR EVALUATION. ROOT CAUSE OF CRACK IS STILL UNDER INVESTIGATION.SDR CALA0600326Door Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN FWD CARGO DOOR SURROUNDING (FRAME) AFT DOOR JAMB WEB ABOVE STRINGER 23R, STA 480-500. THE AFT JAMB WEB WAS REPLACED IAW SRM 51-40-02 AND BOEING DRAWING 65-20723.SDR SWAA063255Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 2 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR TAMF20060047SFailsafe · corrodedDURING C1 CHECK WAS FOUND CORROSION AT FUSELAGE SECTION 46, AFT CARGO DOOR STRUCTURE UPPER MAIN SILL FAILSAFE STRAP AT BS 1287 AND BS 1307. DAMAGED AREA WAS REPAIRED IAW EWO 767-53-025 AND MFG SERVICE REQUEST ID 1-224967878. THIS REPAIR CONSTITUTES A MAYOR RESDR SIMA200625503Beam · corrodedFUSELAGE CENTER BEAM AT FRAME 25 WAS FOUND TO BE CORRODED BEYOND LIMITS. PERFORMED A CUTOUT OF THE DAMAGE AREA, FABRICATED A DOUBLER, FILLER AND TWO SHIMS. REPAIR DONE IAW EMB, SRM 53-00-10 REV 34. RETURNED AIRCRAFT TO SERVICE. (M)SDR SWAA063247Door Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER BOEING DRAWING AND SRM.SDR USAA061102Crease Beam · corrodedFOUND CORROSION, BS 640-660 BL58L WL 208 CREASE BEAM. FAB NEW SECTION OF CREASE BEAM AND TWO PLATES PER SRM 53-30-13, 51-70-02; CORROSION LEVEL 1; TASK C53-123, DEFECT SIZE: 2"L BY 1"W BY .022"D.
Back to JASC 5310