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 FDEA200910073496Doubler · crackedCTR LANDING GEAR WHEEL WELL LT WEB DOUBLER CRACKED AT STA 1392, X = 31.5. REMOVED AND REPLACED WITH NEW FABRICATED DOUBLER AS PER SRM 51-31-01 REVISION 41. DOUBLER FABRICATED AS PER DRAWING NR AEA0526 REVISION NC. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-SDR ASAA0996753Support · corrodedRT FLOOR TO SIDEWALL SUPPORT SHIELD HAS SPOTS OF CORROSION. REPLACED SUPPORT.SDR FDEA200910063494Vertical Beam · misinstalledAFT CARGO COMPT, BS 1183 PRESSURE BULKHEAD LBL 17.8 VERTICAL BEAM INBD FLANGE FASTENERS HAVE IMPROPER SPACING IN 4 AREAS. REPAIRED AFT CARGO COMPARTMENT BS 1183 PRESSURE BULKHEAD IAW EA NR 7-53-10-126851.SDR ZZDA2009286Door Frame · corrodedAFT CARGO DOOR JAMB CUTOUT AREA HAS CORROSION STA FROM 954 TO 994. INSTALLED AFT CARGO COMPARTMENT DOOR JAMB LOWER SPLICE REPAIR PER B717 SRM 53-20-15 REPAIR 7 FIGURE 201. SEE NR 3797, 3829 AND 2382.SDR SIMA200928102Door Frame · crackedDURING MAINTENANCE BASE INSPECTION AND DURING THE CARGO DOOR SILL REMOVAL FRAME 67 WAS FOUND TO BE CRACKED. AIRCRAFT REMOVED FROM SERVICE. REPAIRED FRAME 67 IAW SRM 53-00-04 FIGURE 201. AIRCRAFT RETURNED TO SERVICE.SDR GLBA20091008GAngle · crackedMAJOR REPAIR - DURING ROUTINE SHEDULED MAINTENANCE, A CRACK WAS FOUND ON THE LT HEAVY ANGLE AT FS 288. CRACK IS LOCATED AT THE BEND RADIUS APPROXIMATELY 1.6 IN LENGTH. REPAIRED CRACK IN LT HEAVY DOUBLER AT FS 288 IAW EO 09-1900-53-022. RII INSP COMPLIED IAWSDR CA091007007Beam · cracked(CAN) CRACK WAS FOUND ON VISUAL INSP OF MLG WHEEL WELL INTIAL REPORT CRACK LOOKED 2 INCHES LONG FUTHER INVESTIGATION SHOWED CRACK MIGRATING TO MLG TRACK. REMOVAL PROGRESS OF BEAM SHOWED CRACK ALMOST THROUGH THE BEAM (.200") OF MATERIAL NOT CRACKED.SDR SIMA200927801Door Frame · crackedDURING MAINTENANCE BASE INSPECTION AND DURING THE CARGO DOOR SILL REMOVAL FOUND FRAME 66 TO BE CRACKED. AIRCRAFT REMOVED FROM SERVICE. REPAIRED FRAME 66 IAW EMBRAER STRUCTURAL REPAIRS MANUAL 53-00-04 FIGURE 201, ITEM 4. AIRCRAFT RETURNED TO SERVICE.SDR ASOA200901097Structure · corrodedMAIN AVIONICS COMPARTMENT FS 333.00, STR 27 TO FS 364.00, STR 27 HAS AREAS OF CORROSION. CORROSION FROM FRAME STA 333 TO FRAME STA 364 AROUND STR 27 HAS BEEN ADDRESSED WITH INDIVIDUAL NON ROUTINES TO COVER ALL CORROSION. REF 8727611.SDR 2009FA0000813Fastener · missingFOUR RIVETS WERE MISSING FROM THE LATERAL FLOOR SUPPORT TO FRAME 71 AT STRINGER 16L.SDR ASOA200901085Structure · corrodedFS 349.00 FRAME BETWEEN ST23L AND 23R HAS CORROSION ON FWD AND AFT SIDES. REMOVED AND REPLACED IAW SRM 51-42-06.SDR SWAA096317Door Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND R1 DOOR AFT FRAME CRACKED. REPAIRED FRAME PER SRM.SDR SWAA096313Door Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND R2 DOOR FWD FRAME CRACKED. REPAIRED FRAME PER SRM.SDR SWAA096270Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND LT CREASE BEAM WEB CORRODED AT BS 639. REPAIRED BEAM PER EA.SDR CA091125005Structure · chafed(CAN) WITH REGARDS TO THE EXOTRIM INTERIOR SUPPORT STRUCTURE DAMAGE WAS FOUND. 1. LOCK FASTENERS CHAFING ON THE ALUMINUM STRUCTURE (FROM INITIAL INTERIOR INSTALL) 2. SECURING SCREWS BEING USED WERE TOO LONG CHAFING INTO THE ALUMINUM SUB-STRUCTURE (FROM ORIGINSDR ZZDA2009289Door Frame · damagedINSTALLED AFT CARGO COMPARTMENT DOOR JAMB LOWER SPLICE REPAIR PER B717 SRM 53-20-15 REPAIR 7 FIGURE 201. SEE NR 3391, 3451 AND 5655.SDR ASOA200901074Beam · crackedFS 280 TRANSVERSE BEAM IS CRACKED AT LWR FLANGE OTBD OF RBL 9 AND ATTACH CLIP AT OTBD SIDE OF RBL 9 IS CRACKED. COMPLIED WITH EC/TC REO 601R-53-11-926 IAW REO 601R-53-11-926, REV. B.SDR ASAA0976707Vapor Barrier · crackedVERTICAL CRACK IN VAPOR BARRIER AT FASTENER ROW OUT OF LIMITS.SDR A6WA200940779Beam · crackedCARGO DOOR BEAM ANGLE CRACKED (CRACK LENGTH IS 1.00) CARGO DOOR BEAM ANGLE REPLACED IAW SRM 51-42-21.SDR AALA20090930TUL12Stop Fitting · crackedDOOR STOP FITTING AT FORWARD END OF NUMBER 3 BEAM IS CRACKED. REMOVED DAMAGED STOP PAD FITTING AND INSTALLED NEW FITTING PER ESO 80174.SDR ASAA0976708Stop Fitting · crackedFWD CARGO DOOR CUTOUT 2ND FROM THE BOTTOM STOP FITTING CRACKED. REPLACED FWD CARGO DOOR CUTOUT 2ND FROM THE BOTTOM STOP FITTING.SDR QXEA2009100200752Structure · corrodedDURING INSP FOUND CORROSION AT LWR FS 319.70 AT STR 622LT. REMOVED 2 RIVETS FOR ACCESS AND REMOVED CORROSION IAW SRM 51-42-06-001-001-A01, 51-21-06. PERFORMED LPI ON WORKED AREA IAW 51-20-008. NO CRACKS NOTED OR CORROSION FOUND REO 670-53-21-496. TREATED, SDR ZZDA2009276Door Frame · corrodedAFT CARGO DOOR CUTOUT LOWER JAMB CORRODED. INSTALLED NEW PAN SPLICES AND PARTS AT AFT CARGO COMPARTMENT LOWER JAMB AREA PRE B717 SRM 53-20-15. SEE NR 3006 AND 3009.SDR QXEA2009100100749Door Frame · corrodedCORROSION FOUND ALONG DOOR FRAME OF AVIONICS DOOR (FWD) BETWEEN FS349 AND FS 364 NEXT TO STR 27R. REMOVED 6 RIVETS FROM AREA FOR ACCESS IAW SRM 51-42-06. REMOVED CORROSION IAW SRM 51-21-06. MAX MATERIAL REMOVED .007", WITHIN LIMITS IAW SRM 53-21-23. TREATEDSDR SWAA096201Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 348.2 TO BS 303.9, LBL 58. REPAIRED WEB PER SRM.SDR SWAA096200Crease Beam · crackedDURING SCHEDULED 8Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 294, RBL 55. REPAIRED WEB PER SRM.SDR C2XA09SH312Door Frame · crackedSHV - DURING C-CHECK FRAME 68 IS CRACKED AT CARGO DOOR ROD HOLD OPEN SUPPORT. MAINTENANCE REPAIRED FRAME 68 AT CARGO DOOR ROD HOLD OPEN SUPPORT IAW EC5330-01719 REV B. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DHLA20098051Door Frame · crackedFWD SVC DOOR FWD UPPER JAMB CORNER CRACKED 1/4 INCH. C/A INSTALLED DOUBLER REPAIR IAW DWG SR08530021, SRM 53-4-1 FIG 9 ITEM D, AND AD-2000-20-08 S/BDC8-53-075.SDR SWAA096257Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 420 TO BS 440, STR 17R. REPAIRED WEB PER SRM.SDR AALA20090930TUL02Door Frame · corrodedCORROSION ON CARGO DOOR FRAME. REPAIRED PER EA MD80-53-00=7585 AND SRM 51-70-5.SDR QXEA2009100100723Beam · corrodedLT AND RT STA 280 BEAMS SHOW CORROSION. AFTER REMOVAL OF BEAMS THEY ARE FOUND TO BE CORRODED BEYOND LIMITS IAW SRM 53-00-00-001-A01 PAGE 103. REPLACED 280 BEAM.SDR ASOA200901057Door Frame · crackedPAX DOOR FWD FRAMES CRACKED AT UPPER RADIUS AT FS319 AND 323. INSTALLED REPLACEMENT FRAME AT FS323.3 IAW SRM 51-42-13 & 51-42-06.SDR QXEA2009093000734Structure · corrodedFOUND CORROSION AT FUSELAGE STA 349.00 AT STR 27. REMOVED RIVETS TO FOM. REMOVED CORROSION. REMOVED MATERIAL WITHIN LIMITS. TREATED AND PRIMED, INSTALLED NEW RIVETS, INSTALLED TOP COAT.SDR QXEA2009093000729Structure · corrodedFOUND CORROSION AT FUSELAGE STA 379.00 BETWEEN STR 22LT AND 24 LT. REMOVED RIVETS TO FOM. REMOVED CORROSION. REMOVED MATERIAL WITHIN LIMITS. TREATED AND PRIMED, INSTALLED NEW RIVETS, INSTALLED TOP COAT.SDR QXEA2009093000728Structure · corrodedFOUND CORROSION AT FUSELAGE STA 319.70 AT STR 26LT. REMOVED RIVETS TO FOM. REMOVED CORROSION. REMOVED MATERIAL WITHIN LIMITS. TREATED AND PRIMED, INSTALLED NEW RIVETS, INSTALLED TOP COAT.SDR QXEA2009093000727Structure · corrodedFOUND CORROSION AT LR FUSELAGE STA 295 BETWEEN STR 24LT AND 23LT. REMOVED RIVETS TO FOM, REMOVED CORROSION. REMOVED MATERIAL WITHIN LIMITS. TREATED AND PRIMED, INSTALLED RIVETS THEN TOP COAT.SDR QXEA2009093000724Structure · corrodedFOUND CORROSION ON LWR SECTION OF FS 310 NEXT TO STR 26LT. REMOVED 2 RIVETS FOR FOM. REMOVED CORROSION, REMOVED MATERIAL WITHIN LIMITS. TREATED AND PRIMED AREA, INSTALLED NEW RIVETS THEN INSTALLED NEW TOP COAT.SDR QXEA2009092900726Structure · corrodedDURING INSP, FOUND CORROSION ON LWR FUSELAGE STA 295 AT INTERSECTION OF STR 25LT. REMOVED RIVET TO FOM. REMOVED CORROSION IAW SRM 51-21-06. .003" MATERIAL REMOVED, WITHIN LIMITS. PRIMED AND PAINTED AREA. INSTALLED RIVET. APPLIED TOP COAT.SDR FDEA200909253388Structure · corrodedNLG WHEEL WELL UPPER STRUCTURE - CORROSION ON MID CHORD UPPER SURFACE AT APPROX STA 350, LT SIDE, ( INSIDE FWD WALKWAY ACCESS). REMOVED CORROSION AND FOUND OUT OF LIMITS, REMOVED CHORD, LOCATED AND DRILLED NEW CHORD PN 5312412 PO NR 29105100 AND INSTALLED IAWSDR A6WA200940618Shim · corrodedSERVICE DOOR KICK PLATE SHIM IS CORRODED. SERVICE DOOR KICK PLATE SHIM REPLACED IAW AMM 20-21-00-910-801. (K)SDR SIMA200927106Door Frame · corrodedDURING MAINTENANCE INSPECTION FOUND THE STIFFENER BETWEEN THE LEFT BEAM AND PASSENGER DOOR FRAME 17-18 TO BE CORRODED. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED STIFFENER BETWEEN LT BEAM AND THE PASSENGER DOOR AT FRAME 17-18 IAW SRM 51-40-02. THE ASDR USAA2009111093079Stop Fitting · corrodedSAL - Q2 - MAJOR REPAIR - CORROSION ON STOP FITTING AT BS 983, LBL 60. REPLACED STOP FITTING AT BS 983, LBL 60 IAW B737 SRM 51-10-02 & 51-40-02.SDR USAA2009101992810Stop Fitting · corrodedSAL - Q2 - MAJOR REPAIR - CORROSION SUPPORT STOP ASSEMBLY AT LOWER SILL CUTOUT OF AFT ENTRY DOOR BS 996.5 & BS 983, LBL 60. REPLACED SUPPORT STOP ASSEMBLY AT LOWER SILL CUTOUT OF AFT ENTRY DOOR BS 996.5 & BS 983, LBL 60 IAW B737 SRM 51-10-02 & 51-40-02.SDR USAA2009101992808Stop Fitting · corrodedSAL - Q2 - MAJOR REPAIR - CORROSION ON STOP FITTING AT LOWER SILL OF AFT SERVICE DOOR CUTOUT STRUCTURE BS 967, RBL 60. REPLACED STOP FITTING AT LOWER SILL OF AFT SERVICE DOOR CUTOUT STRUCTURE BS 967, RBL 60 IAW B737 SRM 51-40-02.SDR WX0A070423Beam · corrodedWHILE IN WORK AT MAINTENANCE BASE. BOW 1C/2C/S1, FOUND AFT CARGO DOOR BEAM CORRODED STA 1170. ADDRESSED AS REQUIRED.SDR ASAA0976665Support · corrodedCORROSION ON FLOOR TO SIDEWALL SUPPORT AFT CARGO BAY RT SIDE. REMOVED CORROSION FABRICATED NEW ZEE SUPPORT AND INSTALLED.SDR ASAA0976661Stop Fitting · gougedFWD CARGO DOOR CUTOUT FWD LOWER STOP FITTING GOUGED. FWD CARGO DOOR STOP FITTING FOUND TO BE OUT OF LIMITS.SDR SWAA096029Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 312 TO BS 344, LBL 59. REPAIRED BEAM PER SRM.SDR DHLA20098054Door Frame · crackedMAIN CARGO DOOR LWR. JAMB CRACKED 1/2 INCH STA. 200.000 L-21L TO 22L. REF N/R 229834: CUT OUT DAMAGED SECTION AND INSTALLED REPAIR IAW DWG ED-4987 AND SRM 51-1-11,SRM 51-1-21, SRM51-1-20D,SRM 51-3-1.SDR USAA2009100692720Doubler · crackedSAL - Q2 - MAJOR REPAIR - CRACK ON DOUBLER AT FORWARD ENTRY DOOR LOWER STOP FITTING BS 303.9, S16L. REPLACED DOUBLER AT FORWARD ENTRY DOOR LOWER STOP FITTING BS 303.9, S16L IAW B737 SRM 51-10-02 & 51-40-02.
Back to JASC 5310