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 CHQA20120806267Door Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE CARGO DOOR SURROUND STRUCTURE FORWARD AND AFT L-SHAPE. THE CARGO DOOR SURROUND STRUCTURE FORWARD AND AFT L-SHAPE WAS REPAIRED IN ACCORDANCE WITH ETD 2012-145-010938-1 REVISION A.SDR UALA2012081304392Door Frame · corrodedBS 1681 R4 DOOR FRAME HAS CORROSION OUT OF SRM LIMITS. ACCOMPLISH RII INSPECTION OF AMIS ITEM 2342114. INSTALLED INTERIM REPAIR IN REF TO ECRA 5310-05554.SDR FDEA201208062866Crease Beam · corrodedMAIN DECK CARGO RT CREASE BEAM BS 600 -640 CORRODED. FOUND TO BE OUT OF LIMITS IAW SRM 53-30-13, PAGE 102 AND 101 DETAIL V. R & R CREASE BEAM BS 460 THRU 660 RT IAW SRM 51-40-02 AND DWG 143N5520. MAJOR REPAIR.SDR ASOA20120806064VBeam · corrodedDURING C-CHECK, BAGGAGE DOOR LOWER CUTOUT BEAM HAS CORROSION. MX R & R BAGGAGE DOOR LOWER CUTOUT BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2012080706515Window Frame · crackedR1 WINDOW FRAME POST CRACKED. REPAIRED FRAME PER EA.SDR SWAA2012080706514Window Frame · crackedL1 WINDOW FRAME POST CRACKED. REPAIRED FRAME PER EA.SDR DALA1243879260Beam · corrodedAFT CARGO COMPARTMENT CUTOUT LOWER HEADER BEAM IS CORRODED AND REPLACED AS PER SRM 51-30-02, 51-30-05 VOL 2 AND DWG 5930483.SDR FDEA201208032833Crease Beam · crackedINBD CREASE BEAM AT STA 800 -820 NOTCHED REPAIR CUTOUT. AFTER EVALUATION CREASE BEAM FOUND TO BE OUT OF LIMITS IAW SRM 53-30-13, PAGE 103, DETAIL V. R & R CREASE BEAM STA 800 -900 RT IAW SRM 51-40-02 AND DWG 143N5520. MAJOR REPAIR.SDR ASAA2012082692766Door Frame · corrodedFRAME CORRODED. INSTALLED FORWARD CARGO DOOR AFT CORRODED REINFORCEMENT STRAP. ACFT GROUNDED. R & R REINFORCEMENT STRAP.SDR ABXA20120802241Door Frame · corrodedLEFT OVERWING EXIT CUTOUT FRAME CORRODED ALONG THE AFT SIDE MIDWAY UP. CUT OUT CORRODED SECTION AND REPAIRED PER REA B653-59933-MR, ACFT WAS GROUNDED.SDR DALA12004180853Stop Fitting · crackedDETECTED A CRACK ON THE NR 4 AFT DOOR STOP APPROXIMATELY .125 IN LENGTH STARTING AT DOOR STOP HOLE AND EXTENDING FORWARD. REMOVED DAMAGE PER DRAWING SR095302 52. FABRICATED DOUBLER AND FILLER PER DWG SR09530252 AND LOCATED AND DRILLED REPAIR PARTS TREATED ANSDR DALA12004170853Door Frame · corrodedFORWARD CARGO DOOR FRAME LOWER EDGE HAS CORROSION AND IS BULGED. REMOVED AND REPLACED DOOR FRAME IAW SRM 53-05 FIG 44 AND SRM 51-30-2 SRM 51-30-8 .SDR IPXA12M74767Door Frame · crackedINSPECTION TYPE:4C, R3 DOOR BS 1305 AFT JAMB LOWER LIGHTNING HOLE CRACKED IN CORNER. REPAIRED R-3 AFT DOOR JAMB LOWER LIGHTNING HOLE AT STA 1305 REF SRM 53-40-15, REPAIR 3, FIG 201.SDR SIMA20120729010Gusset · corrodedDURING B INSPECTION, FOUND THE LAVATORY RIGHT BEAM GUSSET CORRODED FORWARD AND AFT ENDS. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND INSTALLED NEW SERVICEABLE LAVATORY RIGHT BEAM GUSSET IAW EMB SRM 51-40-02, 51-20-03,AND 51-40-06. THE AIRCRAFT WAS RESDR SWAA2012080706477Window Frame · crackedR1 WINDOW FRAME POST CRACKED. REPAIRED FRAME PER EA.SDR SWAA2012080706476Window Frame · crackedL1 WINDOW FRAME CRACKED. REPAIRED FRAME PER EA.SDR USAA2012080800024Door Frame · crackedFPBH INSPECTION - FORWARD CARGO DOOR FRAME CRACKED AT LOWER AFT STOP. REMOVED AND REPLACED DOOR IAW JOB CARD 03C20852008.SDR SWAA2012073106372Window Frame · crackedR1 WINDOW FRAME CRACKED AT UPPER RIGHT CORNER. REPAIRED FRAME PER EA.SDR SWAA2012073006266Window Frame · crackedLEFT WINDOW POST FRAME CRACKED BETWEEN L1 AND L2 WINDOW. REPAIRED FRAME PER SRM.SDR FDEA201207272720Beam · corrodedNOSE LANDING GEAR BOX BS 345 UPPER SURFACE BEAM FWD SIDE AT FASTENER ROW HAS CORROSION, DOT 122-011 COMPLIED WITH EA F-3510-162401, REF 8100-9. FUSELAGE NLG WHEEL WELL UPPER PANEL BEAM CORROSION AT BS 345 NEAR LBL19 CAT"A" MAJOR REPAIR. MAJOR REPAIR.SDR FDEA201207272713Door Frame · corrodedAFT CARGO COMPARTMENT DOOR FRAME LOWER SILL INNER CHORD HAS CORROSION, BS 1400-1420. REPAIRED IAW EA F-5310-158084. REPAIR IS MINOR.SDR FDEA201207252678Crease Beam · corrodedSTRINGER 17R CREASE BEAM WEB, BS 1360-1380 CORRODED. REPAIR CONSIDERED MINOR.SDR UALA2012072403996Fastener · looseLEFT OVERWING SLIDE PACK ON OUTSIDE OF AIRCRAFT HAS A LOOSE CAM SCREW. TIGHTENED LOOSE FASTENER, NOW OKAY.SDR FDEA201207232659Crease Beam · corrodedBS 730 LBL 54 CREASE BEAM CORROSION ON INNER CHORD. REMOVED AND REPLACED IAW SRM 51-40-02 REV 106 AND DWG 143N8322, SHT 5, REV.-. REPAIR IS MAJOR.SDR SIMA20120721008Door Frame · crackedCARGO DOOR LWR AFT CORNER FRAME. REPAIRED IAW EO-EM-52MR-249, PART B.SDR SIMA20120720008Gusset · corrodedDURING B INSPECTION, FOUND THE RIGHT LAVATORY GUSSET BEAM CORRODED. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED GUSSET IAW SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR CHQA20120720243Door Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND AT THE CARGO DOOR CUTOUT FRAME 65. MAINTENANCE REPAIRED THE CARGO DOOR CUTOUT FRAME 65 IN ACCORDANCE WITH ETD 2012-145-010345 REVISION A.SDR DALA1242459019Beam · corrodedDURING HMV, CORROSION WAS FOUND ON MID CARGO COMPARTMENT LOWER BEAM BS 636-693 (C2). BEAM WAS BLENDED OUT AND BS 655 AND 674 WAS OUT OF LIMITS. THE AREA WAS CUT OUT FILLER AND Z REPAIR INSTALLED IAW SRM 53-05 FIG 123.SDR DALA12003760865Door Frame · corrodedFWD CARGO DOOR FRAME CORRODED ON AND UNDER PAN FROM BS 389 TO 408. REMOVED AND REPLACED FWD LOWER FRAME PER SRM 51-10-4 AND 51-30-1. ACCOMPLISHED REPAIR PER SRM 53-05 FIG 44.SDR FDEA201207202626Crease Beam · corrodedMAIN CABIN AREA, STRINGER 17L CREASE BEAM BS 730-760 CORRODED. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-30-15, FIG 101, DETAIL IV. R & R IAW SRM 51-40-02 AND DWG 143N8322. MAJOR REPAIR.SDR SIMA20120720002Beam · corrodedDURING MAINTENANCE INSPECTION, FOUND THE RIGHT BEAM CORRODED FORWARD OF FRAME 19. AIRCRAFT REMOVED FROM SERVICE. REPAIRED IAW EO EM-53MR-1993. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA1242309019Structure · corrodedDURING HMV, CORROSION WAS FOUND ON REPAIR SPLICE OF LONGERON 28 LT AND 29 LT BTW STA Y=1250-1271 AT AFT CARGO COMPARTMENT LONGERON 28L WAS ATTENDED ON NRC 254176 AND REPAIR SPLICE OF LONGERON 29LH BTW Y=1250-1271 WAS REPLACED IAW SRM 53- 02 FIG 18.SDR FDEA201207192607Crease Beam · crackedCREASE BEAM INNER WEB HAS CRACK ON LOWER SIDE AT THE INNER CHORD AREA BS 860-880 LT SIDE. R & R WITH WEB FABRICATED AND INSTALLED IAW DWG 143N5520, SHT 4, REV E. REPAIR IS MAJOR.SDR FDEA201207192606Crease Beam · corrodedCREASE BEAM INNER CHORD AT BS 370 TO 378, LBL 60 CORRODED. R & R IAW DWG 1418322 SHT 1, REV K. REPAIR IS MAJOR.SDR UALA2012071803894Windshield · delaminatedDELAMINATED WINDSHIELD 1L IN UPPER RIGHT CORNER. REPLACED WINDSHIELD PER AMM.SDR UALA2012071803883Failsafe · corrodedAFT CARGO COMP STA 1562 FAILSAFE CORRODED STR 39L-39R. FABRICATED AND INSTALLED NEW FAILSAFE PER ECRA 5360-01213 DATED 7-17-2012. MAJOR REPAIR.SDR CA120912005Beam · cracked(CAN) IT WAS REPORTED THAT OPERATOR DISCOVERED A 3.5" CRACK ON THE ROOF PANEL ASSY IN FRONT OF THE RT FWD PYLON BEAM FOOT, APPROXIMATELY WL 72, BL 18, STAT 110. NO DAMAGE WAS DISCOVERED INSIDE THE CABIN, BELOW THE BEAM FOOT. THE BEAM WAS REPAIRED.SDR SWAA2012072006030Window Frame · crackedNR 1 & NR 2 LEFT WINDOW FRAME O/B POST CRACKED AT UPPER CORNER. REPAIRED FRAME IAW EA.SDR SWAA2012072006029Window Frame · crackedNR 1 & NR 2 RT WINDOW FRAME O/B POST CRACKED AT UPPER CORNER. REPAIRED FRAME IAW EA.SDR SWAA2012082707004Window Frame · crackedCAPTAINS L1 WINDOW POST FRAME CRACKED. REMOVED AND REPLACED FRAME IAW EA.SDR ASOA2012080902041Crossbeam · corrodedBS 280 BEAM CORRODED, LT, RT AND CENTER. FOUND CORROSION TO BE OUT OF LIMITS IAW SRM 53-21-43-101-001-A01. REPAIRED IAW GREO 670-53-11-047.SDR DALA1241719264Door Frame · gougedMID CARGO DOOR AFT FRAME PAN GOUGED ABOVE BEARING OF LOCK MECHANISM. REMOVED BEARING OF LOCK MECHANISM AND STOP FITTINGS NR 1 AND NR 2 FOR ACCESS, REF MD90 SRM 51-30-05 VOL II. BLENDED OUT GOUGE AT MID CARGO DOOR. AFT JAMB PAN FOUND OUT OF LIMITS REF SRM 5SDR SWAA2012080706569Crease Beam · crackedCREASE BEAM CRACKED AT BS 637, RBL 63. REMOVED AND REPLACED BEAM IAW SRM AND DWG.SDR DALA1241309005Strap · corrodedAFT CARGO DOOR FRAME WEB STRAP AT BS 1174 CORRODED OUT OF LIMITS. FABRICATED NEW STRAP PER DWG 5936442 AND INSTALLED.SDR FDEA201207132561Crease Beam · damagedLEFT CREASE BEAM AT BS 1584 HAS DAMAGED. CREASE BEAM REPAIRED IAW EA F-5310-161089, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR DALA1246160914Door Frame · crackedLOW FREQUENCY EDDY CURRENT INSPECTION OF FWD SERVICE DOOR JAMB UPPER FWD CORNER DETECTED 2 CRACKS APPROX .125 IN LENGTH EMANATING FROM FASTENER AS MARKED. FABRICATED DOUBLER, TRIPLER, AND FILLERS AND INSTALLED IAW SRMDC-9/MD-8053-05 AND REINSTALLED RIVETS AT SDR DALA1245630914Door Frame · crackedLOW FREQUENCY EDDY CURRENT INSPECTION OF FWD SERVICE DOOR JAMB UPPER FWD CORNER DETECTED 2 CRACKS APPROX .125 IN LENGTH EMANATING FROM FASTENER. REMOVED FASTENERS, CUT OUT DAMAGED AREA. FABRICATED DOUBLER, TRIPLER AND FILLER AND INSTALLED IAW SRM 53-05 DURINSDR UHLA2012071200221Door Frame · corrodedMAJOR REPAIR - FWD CARGO DOOR CUTOUT FWD LOWER SEAL REST CORRODED. REMOVED, MATCH DRILLED, AND INSTALLED NEW FWD LOWER SEAL REST IAW EMB 170 SRM 51-40-02.SDR QXEA2012071200643Door Frame · scratchedAFT RT SERVICE DOOR AFT DOOR FRAME IS SCRATCHED BELOW SECOND STOP FITTING FROM TOP OF DOOR. SMOOTHED OUT SCRATCH IAW SRM 51-14-00-02-03. MIN THICKNESS REMAINING .060" REF NTM 51-00-04-910-801 PT 1. BLENDED AREA CONFIRMED CRACK FREE REF NTM 51-00-06-910-801 SDR FDEA201207112538Failsafe · dentedLT LOWER LOBE INTERNAL FRAME AT STA 365.25 BETWEEN STR 20L TO STR 21L FAILSAFE WITH A DENT. FABRICATED FAILSAFE IAW DWG 141N1219 REV - AND INSTALLED IAW SRM 51-40-02 REV 106. MAJOR REPAIR.
Back to JASC 5310