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 SWAA2012051504028Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN FS 198 TO FS 210. REPAIRED WEB IAW SRM.SDR IPXA2M73733Web · crackedINSPECTION TYPE: 4C, L3 DOOR JAMB AFT LOWER LIGHTNING HOLE IS CRACKED. REPAIRED L3 DOOR JAMB AFT LOWER LIGHTNING REF SRM 53-40-15, REPAIR 3, FIG 201.SDR IPXA2M73732Web · crackedINSPECTION TYPE: 4C, R3 DOOR JAMB AFT LOWER LIGHTNING HOLE IS CRACKED. REPAIRED R3 DOOR JAMB AFT LOWER LIGHTNING HOLE REF SRM 53-40-15, REPAIR3, FIG 201.SDR IPXA2M73731Web · crackedINSP TYPE: 4C, R3 DOOR JAMB FWD LOWER LIGHTNING HOLE IS CRACKED. REPAIRED R3 DOOR JAMB FWD LOWER LIGHTNING HOLE REF SRM 53-40-15, REPAIR 3, FIG 201.SDR IPXA2M73730Web · crackedINSPECTION TYPE:4C, L3 DOOR FWD JAMB LOWER LIGHTNING HOLE IS CRACKED. REPAIRED L3 DOOR FWD JAMB LOWER LIGHTNING HOLE REF SRM 53-40- 15, REPAIR 3, FIG 201.SDR DALA1231510931Door Frame · corrodedDURING HMV, CORROSION WAS FOUND ON LWR DOORJAMB BEAM BTW STA Y=1154 AND 1211 REPAIRED IAW SRM 53-05 FIG 123.SDR SWAA2012060404620Crease Beam · corrodedCREASE BEAM INNER CHORD CORRODED AT BS 311, RBL 55. REMOVED AND REPLACED BEAM IAW SRM, DWG, AND MM.SDR REXA2012051200650Stop Fitting · chafedFWD E & E BAY DOOR OPENING FWD RT DOOR STOP FITTING IS CHAFED. REMOVED AND REPLACED WITH NEW END FWD RT DOOR STOP FITTING IAW CRJ 200 SRM 51-41-02 AAR AM-82.SDR DALA1231090999Beam · corrodedDURING PSV-Q CHECK, CORROSION WAS FOUND ON THE AFT CARGO BEAM AT BS 1155-1212 AND LONGERON 28R. CORROSION WAS OUT OF LIMITS PER SRM 53-05. BEAM WAS REPLACED.SDR FDEA201205101782Crease Beam · corrodedCABIN DURING REPLACEMENT OF FLOORBEAM FOUND CORROSION ON UNDERSIDE OF CREASE BEAM WEB AT BS 377 TO 395 LT. R & R WITH CREASEBEAM, FABRICATED IAW DWG 141N8322 SHEET 1, REV K AND INSTALLED IAW SRM 51-40-02, REV 105 AND DWG 141N8322 SHT 1, REV K. REPAIR IS CLASSDR FDEA201205101783Crease Beam · corrodedCREASE BEAM CORRODED AT BS 755 - 760. REPAIRED IAW EA F-5310-158189, PART 1. REPAIR IS CLASSIFIED AS MINOR.SDR FDEA201205091777Crease Beam · corrodedR2 DOOR SILL FLOOR CREASE BEAM HAS CORROSION FS 710. CLEANED UP AND CHECKED LIMITS, CREASE BEAM FOUND TO BE OUT OF LIMITS IAW SRM 53-30-13 FIG 101 SHEET 5, REMOVED CREASE BEAM IAW SRM 51-40-02. LOCATED AND DRILLED NEW CREASE BEAM IAW SRM 51-40-05, INSTALLED NESDR AALA20120509007Door Frame · damagedOBLONG HOLE IN DOOR BEAM STATION 1212 BETWEEN LONGERONS 25 AND 24 RIGHT. INSTALLED DOUBLER REPAIR PER EA MD80-53-023616.SDR ASOA20120507092Crossbeam · crackedTHE AVIONICS RACK HAS A CRACK JUST INSIDE DOOR PANEL 272DR. MX R & R THE CROSSBEAM IAW SRM 51-20-03 AND 51-40-02. ALL WORK WAS ACCOMPLISHED AND WILL BE RELEASED AT THE END OF THE CHECK.SDR FDEA201205071752Crease Beam · corrodedCREASE BEAM RT SIDE IS CORRODED ON THE BOTTOM SIDE AT BS 365-377. R & R WITH CREASEBEAM FABRICATED IAW DWG 141N8422, SHT 1, REV R AND INSTALLED IAW SRM 51-40-02, REV 105 AND DWG 141N8422 SHT 1, REV R. REPAIR IS CLASSIFIED AS MAJOR.SDR ASAA12511518Structure · wornECS LOWER CHORD WORN BY DOOR LATCH. ACFT GROUNDED. REPLACED ECS LOWER CHORD.SDR CALA2012050700328Frame · crackedSUPPORT TASK STA 294.5 TO 303.9, LT ABOVE LAV FRAME CRACK. R & R FRAME AT STA 294.5 TO 303.9 LT IN REF SRM 51-40-02.SDR UALA2012050802667Structure · damagedLIGHTNING STRIKE AT BS 1886. REPAIRED IAW SRM 53-00-01 REPAIR 3.SDR SIMA20120503017Structure · corrodedCARGO DOOR CUT OUT FWD LOWER CORNER CORROSION AT LOWER STRIKER PLATE AND RIVETS. REMOVED CORROSION ON FWD STRIKER PLATE REF SRM 51-20-00. REMOVED STRIKER PLATE FOM.SDR SIMA20120503015Rib · corrodedDURING SCHEDULED MAINTENANCE FOUND THE BAGGAGE DOOR CUTOUT FORWARD LOWER CORNER CORRODED AT NUT PLATE FOR TRIM. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED RIB DUE TO OUT OF LIMIT CORROSION. LOCATED & DRILLED NEW RIB IAW SRM 51-40-02. THE AIRCRAFT WAS RESDR REXA2012050300622Latch · chafedFWD BULKHEAD FS 169.00 CHAFED BELOW RADOME LATCHES. REMOVED CHAFING IAW SRM 51-12-00. FOUND TO BE IN LIMITS SRM 53-00-00.SDR ASOA201201556Crossbeam · corrodedCROSSBEAM BETWEEN RBL9 TO RBL27 HAS CORROSION. REMOVED CORROSION IAW SRM 51-21-06-001-001. MEASURED BLENDED AREA FOUND TO BE .018" DEEP . COMPLIED WITH STEP 2 OF REO 670-53-21-850 IAW NDTM PART 1, 51-20-006. NO INDICATIONS NOTED. REPAIRED IAW REO 670-53SDR ASOA201201552Crossbeam · corrodedCROSSBEAM CORRODED. REPAIRED IAW EC/TC REO 670-53-11-047.SDR FDEA201205031714Structure · corrodedSTRUCTURE IN PACK BAY NR1 FOUND CORROSION AT STRINGER 18 AND 19. REPAIRED IAW SRM 53-00-05 REPAIR 2 FIGURE 201 AND DWG3353 SH1.SDR FDEA201205031716Support Fitting · crackedAIR CONDITIONER DOOR AFT FRAME FITTING FOUND CRACKED. SUPPORT FITTING REMOVED AND REPLACED WITH FABRICATED SUPPORT FITTING AS PER SRM 51-33-01 REVISION 49. NEW SUPPORT FITTING FABRICATED AS PER DWG ACA3135-2 REVISION B . REPAIR CLASSIFIED AS MAJOR AS PER GMSDR DALA1228429263Door Frame · corrodedDURING HMV, FOUND MID CARGO BAY STA 693-750 L28R LOWER DOOR JAMB BEAM IS CORRODED. REMOVED AND REPLACED JAMB BEAM IAW SRM 51-30-05 AND DWG 5930481.SDR DALA1228409263Door Frame · corrodedDURING HMV, FOUND AFT CARGO BAY LOWER INBD DOOR JAMB HEADER BEAM STA 1193-1288 IS CORRODED. REMOVED CORRODED IBD JAMB HEADER AND REPLACED WITH NEW JAMB HEADER P/N 5936037-505 IAW MD90 SRM VOL2 51-30-05 FIG 13.SDR DALA1236290918Door Frame · corrodedAFT CARGO DOOR FRAME LOWER BTW BS 1154 -1211 IS CORRODED AROUND FASTENER HOLES. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED NEW AFT CARGO DOOR LOWER FRAME BETWEEN BS 1154-1211 IAW MD-88 SRM 51-30-5 PG12.SDR SIMA20120501004Door Frame · corrodedDURING B INSPECTION, FOUND THE SERVICE DOOR CUTOUT FORWARD FRAME HAS CORROSION AT LOWER AREA. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED SERVICE DOOR CUTOUT FORWARD FRAME IAW SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR USAA2012050400001Crease Beam · crackedQ1 CHECK - CRACK ON CREASE BEAM WEB BETWEEN BS 500C TO BS 500D, WL 207, RBL 64. REPLACED WEB BETWEEN BS 500C TO BS 500D, WL 207, RBL 64 IAW EA 100391A.SDR DALA1228309263Door Frame · corrodedFOUND E/E BAY CUTOUT AFT DOOR FRAME HAS AREA OF CORROSION AT FS 160 RBL 11. CUTOUT AND REPLACED DAMAGED SECTION OF FRAME BS 160 RBL 11 IWA ERA 500898-14 REV ORIG.SDR AALA20120430017Door Frame · crackedFRAME AT RIGHT NUMBER 1 DOOR CRACKED AT BOTTOM 2 FASTENERS, FORWARD SIDE AT STATION 294.5 RIGHT BUTTLINE 60. INSTALLED DOUBLER REPAIR PER SRM 51-70-11 AND ESO 61000.SDR 3POR201204300003Structure · misrepairedINCORRECT REPAIR, INCORRECT FASTENERS.SDR WX0A071188Door Frame · corrodedAFT CARGO DOOR CUTOUT LOWER JAMB STA 1154 TO 1211 CORRODED. REPAIRED AFT CARGO DOOR CUTOUT LOWER BEAM STA 1154 TO 1211 IAW MD80 SRM 53-05 FIG 123 OPT 1.SDR DALA1228046818Frame · corrodedCORROSION ON FRAME AT STA 1560 ABOVE STR 26R IS CORRODED AT FASTENER HOLE. REMOVED FRAME REPLACED FORMER PER DRAWING 453N1801.SDR MTNA201204270001Structure · corrodedCORROSION FOUND ON THE FUSELAGE AT FRAMES 14 AND FRAMES 17 OUT OF LIMITS IAW ATR 72 SRM 53-31-00.SDR DALA1235340940Door Frame · corrodedCORROSION ON CARGO COMPARTMENT DOOR FRAME BS 376-382 AND 417-423 C1. REPAIR DOUBLERS WERE INSTALLED IAW ERA 503262-14 REV A.SDR FDEA201204261626Door Frame · gougedL2 DOOR JAMB FWD FRAME IS GOUGED CHAFED 2 PLACES FS 680 PLUS 5 ABOVE FLOOR LINE. REMOVED AND REPLACED DOOR FRAME IAW DRAWING 143N8313 P1, REV. L, AND SRM 51-40-02. MAJOR REPAIR.SDR SWAA2012050203626Crease Beam · corrodedLT INNER CREASE BEAM CORRODED AT BS 312+2. REMOVED AND REPLACED BEAM IAW SRM AND DWG.SDR SWAA2012043003597Fastener · missingLT INNER CREASE BEAM STA 268.25 FWD END FASTENERS MISSING. INSTALLED FASTENERS IAW SRM.SDR ALGA2012042501Structure · corrodedSLAT ASSY CORRODED BEYOND REPAIR LIMITS.SDR IPXA12M73579Door Frame · crackedINSPECTION TYPE: 4C, R3 DOOR FRAME AT FWD LOWER LIGHTENING HOLE, CRACKED. REPAIRED IAW SRM 53-40-15, REPAIR 3 FIG 201 (-7007 CONFIG).SDR IPXA12M73578Door Frame · crackedINSPECTION TYPE: 4C, L3 DOOR AFT FRAME AT LOWER LIGHTENING HOLE, CRACKED. REPAIRED IAW SRM 53-40-15, REPAIR 3, FIG 201.SDR ALGA2012042402Bearing · wornBEARING WORN AND CORRODED BEYOND LIMITS.SDR FDEA201204241557Crease Beam · corrodedAPPROX STA 755 RT INBD CREASE BEAM CHORD CORRODED. REMOVED CORROSION IAW SRM 51-10-02, CHECK LIMITS AND FOUND TO BE OUT OF LIMITS IAW SRM53-30-13, FIG 101, DET VII. REMOVED CREASE BEAM IAW SRM 51-40-02, FABRICATED CREASE BEAM FROM BAC1515-553 IAW SRM 53-30-1SDR DALA12006953209Structure · corrodedDURING INSPECTIONS, FWD CARGO COMPARTMENT BETWEEN FR 28 AND FR 29 STRINGER 41R HAS CORROSION. REMOVED FASTENERS FROM FR 28 TO FR 29 STGR 41R IAW SRM 51-42- 11. REMOVED CORROSION IAW SRM 51-74-00. INSTALLED REPAIR PARTS IAW SRM 53-21-13 FIG 202.SDR ASOA201201352Crossbeam · corrodedFS 280 CROSSBEAM CORRODED. REMOVED AND REPLACED CROSSBEAM IAW SRM 50-42-06-001-001, 51-42-13-001-001, 51-42-22-001-001.SDR ASOA201201336Intercostal · corrodedINTERCOSTAL HAS CORROSION AT FS 364 S26L/R. R & R INTERCOSTAL IAW SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01.SDR ASOA201201328Support Beam · crackedDURING EXTERNAL DETAILED INSPECTION THE UPPER & LOWER WEB OF THE ENGINE SUPPORT BEAM BETWEEN FS 625 & FS 640, FOUND 3 CRACKS AROUND FASTENER HOLES IN UPPER WEB BETWEEN LBL 9 & RBL 9.
NO REPAIR GIVEN IN SUPPLEMENTAL REPORT SUBMITTED ON 6/15/2012, ONLY ITESDR UALA2012042302409Crease Beam · corrodedCREASE BEAM DOUBLER FASTENER HOLES ARE CORRODED BS 377 THRU 395. REMOVED AND REPLACED CORRODED CREASE BEAM REF SRM 51-40-02.
Back to JASC 5310