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 FDEA201304280875Door Frame · crackedR3 DOOR FORWARD FRAME WEB FOUND CRACKED. REPAIRED IAW SRM 53-40-15, FIG 201, REPAIR 3, REV 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR DALA13019915657Door Frame · damagedRAMP FOUND DAMAGE TO C-2 CARGO DOOR FRAME FWD EDGE. REMOVED DAMAGE AND INSPECTED. REPAIRED DAMAGED AREA REFER TO ERA 514326-14, REV ORIG.SDR ASAA2013042794751Failsafe · corrodedFWD CARGO BS 500G FAILSAFE CORRODED AT S28R. ACFT GROUNDED. R & R FAILSAFE IAW SRM 51-40-02-0.SDR SWAA2013050615664Window Frame · crackedFLIGHT DECK RIGHT NR 1 WINDOW FRAME TOP OUTBOARD CORNER OF WINDOW CUTOUT FRAME CRACKED. REPAIRED DOUBLER IAW AAR EA AND EA.SDR FDEA201304260869Failsafe · corrodedFWD CARGO DOOR UPPER FRAME, BS 620 - 640, FAILSAFE STRAP CORRODED. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-30-15. R & R FAILSAFE IAW SRM 51-40-02. MAJOR REPAIR.SDR DALA13020249261Door Frame · crackedRT MLG DOOR FRAME HAS A CRACK 2.5" LOCATED 4" BELOW DOOR SENSOR. REMOVED FRAME. DRILLED NEW DOOR FRAME AND INSTALLED.SDR FDEA201304260872Crease Beam · corrodedMAIN DECK STRINGER 17R CREASE BEAM INNER CHORD BS 820-900 HAS CORROSION ON UPPER AND LOWER SURFACES. R & R INBD ANGLE IAW SRM 51-40-02 AND DWG 143N5520 BS 754 - 900. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-30-13, FIG 101, DETAIL 3. MAJOSDR CALA2013042600242Splice Plate · corrodedAFT CARGO SPLICE PLATE BS 1401, STR 28 & 29 LT HAS CORROSION.SDR AALA20130425015Door Frame · dentedFORWARD E AND E DOOR FRAME DENT AT POINT LATCHING MECHANISM INTERSECTS FROM STATIONS 231 AND BUTTLINE 0. REMOVED DAMAGE AND INSTALLED REPAIR ANGLE REO-G16140 REVISION A.SDR SIMA20130425010Door Frame · corrodedDURING MAINTENANCE INSPECTION FOUND FRAME 65 CORRODED AROUND CARGO DOOR FORWARD LOWER STRIKER PLATE NUT PLATE HOLES. THE AIRCRAFT WAS REMOVED FROM SERVICE. BLENDED OUT CORROSION AND INSTALLED REINFORCEMENT DOUBLER IAW AE EO EM-53MR-2123. THE LEVEL OF CORROSSDR FDEA201304241003Doubler · crackedWHEN REMOVING EXISTING REPAIR DOUBLER, FOUND ADDITIONAL CRACK IN AEA0161-11 DOUBLER. BS 1391 APPROX 4" DOWN FROM TOP. REPAIRED IAW EA 8-5310-157389, PART 1.SDR QXEA2013042400829Door Frame · corrodedFWD BAGGAGE DOOR FWD FRAME HAS CORRODED NUT PLATES ONE BELOW NR 3 STOP FITTING AND ONE BELOW NR 4 STOP FITTING. REMOVED NUT PLATE BRACKETS FROM FWD BAG DOOR FWD FRAME BELOW STOP FITTINGS 3 & 4. REMOVED CORRODED NUT PLATES FROM BRACKETS AND REPLACED WITH NEW SDR FDEA201304230832Door Frame · corrodedCARGO DOOR CUTOUT LOWER FRAME UPPER SURFACE BS 660 FOUND CORRODED. REMOVED AND REPLACED IAW SRM 51-31-01 REVISION 52 AND DRAWING ACA7224 REVISION G. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REVISION 116.SDR SWAA2013050215473Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 500A TO BS 500B. REMOVED AND REPLACED WEB PER SRM.SDR DALA13020239201Crease Beam · gougedLEFT CREASE BEAM WEB GOUGED UNDERSIDE AT BS 250. REMOVED CORROSION FROM CUSP WEB. 100 PERCENT MATERIAL LOSS. FABRICATED AND INSTALLED REPAIR IAW SRM 53-20-02.SDR DALA13019309201Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED AROUND CENTER LIGHTENING HOLE BS 550. REMOVED CORROSION. 100 PERCENT MATERIAL LOSS. NDT, REPAIRED, INSTALLED REPAIR AND CIC'D IAW SRM 53-20-02 AND 51-10-03.SDR FDEA201304230837Doubler · crackedWHEEL WELL CRACKED ON RT KEEL BEAM BULKHEAD MACHINED DOUBLER AT BS 1386 AT X 31.5. R & R CRACKED DOUBLER AEA 0526U2, REF SRM 51-33-01, VOL 2.SDR QXEA2013042200870Nut Plate · corrodedPILOTS WINDSHIELD HAS THREE NUT PLATES CORRODED ON THREE RETAINING STRIPS. R & R NUT PLATES IAW SRM 51-42-05-02-01, 51-42-75-02-01 REV 12.SDR QXEA2013042200869Nut Plate · corrodedF/O WINDSHIELD HAS SEVEN CORRODED NUT PLATES ON FIVE RETAINING STRIPS. R & R NUTPLATES IAW SRM 51-42-05-02-01, 51-42-75-02-01, REV 12.SDR USAA2013042400018Fitting · damagedS3 CHECK - ELONGATED HOLE ON FRAME FITTING AT R2 DOOR CUTOUT AT STOP FITTING NR 5 AT FR68, S14R. ACCOMPLISHED INTERIM REPAIR ON FRAME FITTING AT R2 DOOR CUTOUT AT STOP FITTING NR 5 AT FR68, S14R IAW EA 503840A.SDR USAA2013042400017Fitting · damagedS3 CHECK - ELONGATED HOLE ON FRAME FITTING AT L2 DOOR CUTOUT AT STOP FITTING NR 7 AT FR66, S12L. ACCOMPLISHED INTERIM REPAIR ON FRAME FITTING AT L2 DOOR CUTOUT AT STOP FITTING NR 7 AT FR66, S12L IAW EA 503840A.SDR USAA2013042400016Fitting · damagedS3 CHECK - ELONGATED HOLE ON FRAME FITTING AT R2 DOOR CUTOUT AT STOP FITTING NR 1 AT FR66, S22R. ACCOMPLISHED INTERIM REPAIR ON FRAME FITTING AT R2 DOOR CUTOUT AT STOP FITTING NR 1 AT FR66, S22R IAW EA 503840A.SDR DALA13018589201Crease Beam · corrodedCABIN LT CREASE BEAM WEB CORRODED STA 610-650. REMOVED CORROSION. OUT OF LIMITS. FABRICATED AND INSTALLED DOUBLERS IAW SRM 53-20-02, FIG 19 AND 51-30-02, PG 1.SDR EVCA201304230042Box Beam · cracked2 INCH CRACK FOUND IN RT SIDE OF BOX BEAM STRUCTURE AT APPROX FS 87.36.SDR UHLA2013042100197Structure · corrodedTHE BEAM UNDER THE FWD PAX DOOR SLIDE FITTING BAR HAS CORROSION. R & R BEAM. MAJOR REPAIRSDR TSAA20130421004Intercostal · crackedCRACK FOUND ON INTERCOSTAL INSIDE OF FWD SERVICE DOOR FRAME BS 332.SDR TSAA20130421003Door Frame · crackedCRACK FOUND ON FWD SERVICE DOOR DOOR FRAME B.S. 332.SDR SIMA20130420011Gusset · corrodedDURING B INSPECTION, FOUND THE LAV RT BEAM GUSSET CORRODED. THE ACFT WAS REMOVED FROM SERVICE. R & R THE LAV RT BEAM GUSSET IAW SRM 51-40-02. THE ACFT WAS RETURNED TO SERVICE.SDR DALA13020571820Panel · corrodedDURING PSV, MX FOUND CORROSION DAMAGE ON THE LT MLG WEB CLOSURE PANEL AT BS 955 AND LBL 90.0. PERMANENT REPAIR ACCOMPLISH IAW ER/A 513857-14 WITH 24 MONTH DTA RESTRICTION.SDR FDEA201304200815Crease Beam · corrodedBS 1280 -1400 CORROSION FOUND ON THE SURFACE OF RT CREASE BEAM INNER ANGLE. R & R WITH NEW INNER ANGLE IAW DWG 146N8322 SHT 1, REV F, MAJOR REPAIR.SDR SWAA2013042315050Window Frame · crackedL1 COCKPIT WINDOW FRAME CRACKED AT UPPER LEFT CORNER. REPAIRED WINDOW FRAME PER EA.SDR AALA20130419009Crease Beam · corrodedRIGHT CREASE BEAM AT STATION 984, RIGHT BUTTLINE 48 AND WATERLINE 208 CORRODED. REPLACED SILL CHORD PER AARD 51-00-05.SDR ASOA20130421132VBeam · corrodedDURING C-CHECK, THE CARGO DOOR LOWER BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 65-68 AND STRINGERS 15L-16L. MX R & R THE BEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ABXR2013041900002Door Frame · corrodedDURING 'A' CHECK FOUND AFT LOWER CARGO DOOR JAMB AFT LOWER CORNER CORRODED. REPAIRED IAW AMES REA 47048REA02.SDR JJBA20130418012Structure · corrodedCORROSION WAS FOUND UNDER THE ATC TRANSPONDER ANTENNA.SDR JJBA20130418005Structure · corrodedCORROSION WAS FOUND UNDER THE ATC TRANSPONDER ANTENNA.SDR SWAA2013043015342Window Frame · crackedCAPTAINS NR 1 WINDOW FRAME CRACKED AT OUTBOARD UPPER CORNER. REPAIRED FRAME IAW ER AND EA.SDR FDEA201304180807Crease Beam · corrodedMAIN DECK CREASE BEAM INNER ANGLE BS 428-665 UPPER AND LOWER SURFACES HAVE CORROSION. FOUND BLENDED AREAS TO BE OUT OF LIMITS IAW SRM51-30-13, DETAIL 8. REMOVED CREASEBEAM AT STR 17R BS428-BS665 IAW SRM51-40-02. LOCATED AND DRILLED NEW CREASE BEAM IAW SRM51SDR UALA2013041802645Doubler · crackedBS 1120 LEFT TENSION TIE DOUBLER HAS ONE FASTENER HOLE CRACKED. REPLACED DOUBLER. MAJOR REPAIR.SDR UALA2013041802641Tension Tie · crackedBS 1120, LEFT TENSION TIE, HAS THREE FASTENER HOLES CRACKED. REMOVED DAMAGE. HFEC, FABRICATE AND INSTALLED REPAIR IAW SRM 53-40-30 REPAIR 1.SDR DALA1313100681Frame · corrodedCORROSION ON WING TO BODY FRAME BS 900 LBL6. REPAIRED IAW SRM 51-70-12, PG 1, FIG 1.SDR DALA13018940952Pan · crackedCRACKED LT WINDOW RING PAN AT FWD LWR CORNER BS 984. DAMAGE REMOVED AND REPAIR PARTS WERE INSTALLED IAW SRM 53-05 FIG 122.SDR DALA13018930952Pan · damagedCRACKED LT WINDOW RING PAN AT AFT LWR CORNER BETWEEN BS 807. DAMAGE REMOVED AND REPAIR PARTS WERE INSTALLED IAW SRM 53-05, FIG 122.SDR CALA2013041700230Door Frame · damagedTWO MISDRILLED HOLES ON L1 DOOR CUT OUT FWD INNER CHORD AT STA 303.9 STR 16 L, DAMAGED REPAIRED IAW ECRA 5311-01540 PART 1 DIP ISSUED TO ACCOMPLISH ECRA 5311-01540, PART 3 WITHIN 2 YEARS FROM 2/6/12. REPAIRED IAW EC/RA 5311-01593 PART 1 INTERIM REPAIR. REF LSDR UHLA2013041600217Door Frame · corrodedCORROSION ON L2 DOOR FRAME LOWER ENTRY WAY. R & R L2 DOOR LOWER FRAME.SDR UHLA2013041600161Door Frame · corrodedCORROSION DAMAGE FOUND IN L1 LOWER ENTRY WAY FWD FRAME. R & R L2 DOOR FRAME IAW SRM 51-41-00.SDR SWAA2013050715765Window Frame · crackedLEFT WINDOW FRAME CRACKED BETWEEN STA 598 TO STA 617. REPAIRED FRAME IAW SRM.SDR SWAA2013043015344Window Frame · crackedRIGHT NR 1 WINDOW FRAME CRACKED AT UPPER OUTBOARD CORNER. REMOVED AND REPLACED FRAME IAW ACO.SDR SWAA2013043015343Window Frame · crackedLEFT NR 1 WINDOW FRAME CRACKED AT UPPER OUTBOARD CORNER. REMOVED AND REPLACED FRAME IAW CCO.SDR FDEA201304160789Crease Beam · corrodedCORROSION ON CREASE BEAM WEB. CREASE BEAM WEB REMOVED AND REPLACED WITH NEW WEB FABRICATED AND INSTALLED IAW DWG 141N8322 SHT.1 REV.K. REPAIR IS MAJOR.
Back to JASC 5310