JASC 5330
Service difficulty reports · 79,365
Reports filed under 5330 · Fuselage Main, Plate/Skin, 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 = '5330' 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 = '5330' 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 AALA20150107004Skin · dentedDENT IN FS 500E STRINGER 18R. REPAIRED FUSELAGE SKIN DENT IAW SRM 53-00-01-2R-3.SDR SWIA201440404Skin · dentedFUSELAGE SKIN DENTED BELOW THE CARGO DOOR BETWEEN BS 574 - 589 AND S20-21L. REPAIRED THE DAMAGE IAW EA.SDR SWAA2014120834832Skin · crackedLEFT LOWER BULKHEAD SKIN CHORD CRACKED AT BS 540, STRINGER 22L FROM AFT FASTENER 2 ROWS. REPAIRED SKIN IAW EA.SDR DALA2014112606321Doubler · corrodedCORROSION ON REPAIR DOUBLER BETWEEN BS 826-830 X 54 - 60. DOUBLER WAS REPLACED IAW SRM 53-05, FIG 131A-13.SDR Y2PA20141124034Skin · damagedDURING C CHECK, DISCOVERED A DAMAGED FUSELAGE SKIN AT STATION 942 AT LONGERON 16L. REPAIRED DAMAGED FUSELAGE SKIN AT STATION 942 AT LONGERON 16L IAW DC9 SRM 53-01 FIG 4.SDR Y2PA20141124024Skin · corrodedDURING C CHECK, DISCOVERED A CORRODED SKIN FROM STATION 680 - 720 BETWEEN LONGERONS 23L - 28L INSTALLED REPAIR BETWEEN STATION 680 - 720 BETWEEN LONGERONS 23L - 28L IAW DER 8110-3 & DWG 53301423-1.SDR Y2PA20141124021Skin · crackedDURING C CHECK, DISCOVERED A SKIN CRACK AT STATION 680 BETWEEN LONGERONS 25R - 26R. INSTALLED REPAIR BETWEEN STATION 680 - 710.5 BETWEEN LONGERONS 25R - 26R IAW DER 8110-3 & DWG 53301422-1.SDR Y2PA20141124019Skin · corrodedDURING C CHECK, DISCOVERED SKIN CORRODED FROM BS 645 - 699 BETWEEN LONGERONS 23 - 30L. REPAIRED IAW SRM 51-30-2, 51-30-5 & DWG 5911421.SDR Y2PA20141124017Skin · crackedDURING C CHECK, DISCOVERED A CRACK IN THE NOSE SKIN AT STATION Y76.550 RBL 16. REPAIRED IAW DC9 SB 53-262.SDR SWAA2015012235960Skin · corrodedSKIN CORRODED AT BS 385, STRINGER 24L. REPAIRED SKIN IAW ER & EA.SDR SWAA2015011935855Skin · corrodedSKIN CORRODED BETWEEN BS 320 TO 360, STRINGER 25L. REPAIRED SKIN IAW SRM.SDR SWAA2015011935850Skin · corrodedSKIN CORRODED AT BS 378, STRINGER 25L. REPAIRED SKIN IAW SRM.SDR SWAA2015011535767Skin · corrodedSKIN CORRODED BETWEEN BS 360 TO 385, STRINGER 25L. REPAIRED SKIN IAW SRM.SDR SWAA2015011535766Skin · corrodedSKIN CORRODED AT BS 370, STRINGER 24L. REPAIRED SKIN IAW SRM.SDR SWAA2015011535762Skin · corrodedSKIN CORRODED BETWEEN BS 360 TO 400, STRINGER 24L. REPAIRED SKIN IAW SRM.SDR ASOA2014122311927Skin · corrodedSKIN BS 280 S27 CORRODED . REMOVED CORROSION IAW SRM 51-21-06-001-001-A01.SDR ASOA2014122311924Skin · corrodedFUSELAGE SKIN UNDER AFT DRAIN MAST FOUND TO BE CORRODED. BLENDED DAMAGE IAW SRM 51-21-06-001-001. REPAIRED IAW EA 32-2014-208. MAJOR REPAIR.SDR SWAA2014120834833Post · crackedLEFT NR 3 FLIGHT DECK WINDOW E - F POST CRACKED ON HOLE NR 8. REPAIRED WINDOW POST IAW ACO.SDR CALA2014112501478Skin · corrodedDURING WALK AROUND FOUND CORROSION AT FWD LAVATORY SERVICE DOOR CUT OUT, AFT INBD AREA. REPAIRED IAW ECRA 5331-01984 PART 1. ISSUE A DIP TO READ ACCOMPLISH A PERMANENT REPAIR IAW PART 3 OF ECRA 5331-01984 PRIOR TO NOVEMBER 21, 2016 OR BEFORE 21,932 TOTAL FLISDR DALA2014112406233Skin · dentedONE DENT AFT OF L2 DOOR BETWEEN BS 760-780 AND S16-17L. CUTOUT DAMAGE, FABRICATED AND INSTALLED A PERMANENT REPAIR IAW SRM 5300-01-R2-F201.SDR DALA2014112406232Skin · dentedONE DENT AFT OF L2 DOOR BETWEEN BS 760-780 AND S16-17L. FABRICATED AND INSTALLED PERMANENT REPAIR CATEGORY B IAW SRM 53-00-01-R-2-F201.SDR ASOA2014122211894Skin · corrodedMAIN AVIONICS BAY DOOR CUTOUT HAS CORROSION AROUND SEAL LAND. BLENDED DAMAGE IAW SRM 51-12-00-001-001-A1. BLENDED AREA WELL WITHIN LIMITS REF REO 670-53-21-242, REV-B .SDR R61A201411221209Skin · damagedDURING HEAVY CHECK, SKIN DAMAGED FRAME 21 ABOVE STRINGER 27L. REPAIRED THE SKIN IAW ETD 2014-170-098904, REV C.SDR DALA2014112306255Skin · corrodedLT SIDE AFT FUSELAGE BS 1338, L22L, CORROSION ON EXTERIOR FUSELAGE SKIN. REPLACED SKIN BS 1202-1338, L18-26L IAW DWG 593021, REV EH.SDR DALA2014112406223Skin · dentedFOUND DENT AND BENT LONGERON AT FORWARD CARGO BAY BS 305 LONGERON 28R. CUTOUT DAMAGE AND INSPECTED, INSTALLED REPAIR IAW SRM.SDR DALA2014112306221Skin · dentedDURING INSPECTION, NOTED A DENT AFT OF L1 DOOR BS 218 STRINGER 18L. REPAIRED IAW SRM 53-10-01, FIGURE 202.SDR R61A201411221199Skin · damagedDAMAGE ON LT SIDE OF CENTER FUSELAGE BELOW L3 PAX WINDOW BETWEEN FRAMES 24-25 STRINGER S18-19L. REPAIRED THE DAMAGE IAW SRM 53-21-01.SDR FDEA201411213839Skin · crackedINSPECTION OF REAR SPAR BOTTOM SKIN AROUND E HOLE FOUND CRACKED. REPAIRED IAW EA6-5710-T0313870. MAJOR REPAIR IAW GMM6-2-100.SDR FDEA201411213838Skin · crackedRIGHT FUSELAGE SKIN FOUND CRACKED. REPAIRED IAW EA6-5710-T0313870. MAJOR REPAIR IAW GMM 6-2-100.SDR SWAA2014120134547Skin · crackedFUSELAGE SKIN CRACKED AT BS 727D+2, STRINGER 19R. REPAIRED SKIN IAW SRM.SDR ASOA2014112611791Skin · damagedAFT SKIN AT BS 640 - 755 STR 20L-20R, FOUND CRACKED, BUCKLED, DENTED AND DEFORMED.SDR DALA2014112206216Buttstrap · corrodedCORROSION ON CROSS BUTTSTRAP INNER SKIN PANEL AT FRAME 64 BETWEEN STRINGER 32L - 41R. REPLACED THE BUTTSTRAP AT INNER SKIN PANEL IAW ER/A.SDR IXXA20150331093Skin · corrodedAIRCRAFT ON GND FOR HEAVY MX, FAILSAFE INSPECTION. FOUND CORROSION AT STATION 456 ON SKIN UNDER STRINGER 38R. REMOVED DAMAGED AREA, 1 X 2. FABRICATED FROM 7075-T6. INSTALLED FILLER & REPAIR DOUBLER IAW SRM 51-40-02 & 53-30-01.SDR ASOA2014122311951Skin · damagedAFT DRAIN MAST AFT RT MOUNT IN FUSELAGE IS DAMAGED. REPAIRED IAW REO 670-53-61-1108SDR SWIA201440356Skin · gougedRIGHT FUSELAGE GOUGED AFT OF AOA VANE CUTOUT AT APPROXIMATELY FS292.00, BETWEEN STR 13R AND STGR 14R BLENDED OUT THE GOUGE AT RT FUSELAGE AFT OF AOA VANE CUTOUT AT APPROXIMATELY FS292.00 BETWEEN STR 13R AND STR14R, REF SRM . RESTORED FINISH ON REPAIRED AREA SDR SWIA201440325Skin · chafedAVONICS DOOR OPENING SURROUND STRUCTURE FWD SIDE HAS CHAFFING WHERE DOOR SEAL MEETS ACFT STRUCTURE, AFT OF FS364.00, FROM STR 25L TO STR 25R, C-CHECK, RO 12/10/14. BLENDED CHAFING AREA ON FUSELAGE INNER SKIN SURFACE AT FWD SIDE OF AVIONICS BAY DOOR CUTOUT REFSDR AALA20141120007Fastener · defectiveREPAIR INSTALLED BETWEEN FUSELAGE STATIONS 500D & 500E, BETWEEN STRINGERS 24 LT & 22 LT WAS FOUND WITH BAD FASTENERS. REMOVED REPAIR. REPAIRED AREA IAW SRM 53-00-01-2R-3.SDR AALA20141120008Skin · corrodedFUSELAGE SKIN CORROSION STATION 540 STRINGER 22L AT DRAG BRACE OTBD EDGE. REMOVED CORROSION IAW SRM 51-10-02-0G.SDR DALA2014112106207Skin · damagedFUSELAGE SKIN, BS 399 - 411, S6-7R HAS LIGHTNING STRIKES. REPAIRED IAW PRI 530817-14 REV 0 AND1 AND ERA 530817-14, REV ORIGINAL.SDR DALA2014112106206Skin · damagedFUSELAGE SKIN BS 474, S6R, LIGHTNING STRIKE. REPAIRED IAW PRI 530843-14, REV 0 AND ERA 530843-14, REV ORIGINAL.SDR DALA2014112106205Skin · damagedLIGHTNING STRIKE DAMAGE TOP OF FUSELAGE, BS 440 AFT OF SPLIT LINE, 19 INCHES BELOW LAP SEAM. REMOVED DAMAGED FASTENER IAW SRM 53-00-01, REPAIR 6, SECTION II AND DRILLED DAMAGE IAW SRM 53-00-01, REPAIR 6, SECTION I. PREFORMED HFEC SURFACE SCAN IAW NDTM PART SDR DALA2014112106204Skin · damagedLIGHTNING STRIKE DAMAGE TOP OF FUSELAGE, BS 411, 27 INCHES BELOW UPPER LAP JOINT RT SIDE. REPAIRED IAW E/C ERA 530817-14, REV ORIG.SDR DALA2014112106203Skin · damagedLIGHTNING STRIKE DAMAGE TOP OF FUSELAGE BS 399, 22 INCHES BELOW LAP SEAM RT SIDE. REPAIRED IAW ERA 530817-14, REV ORIGINAL.SDR DALA2014112106202Skin · damagedLIGHTNING STRIKE DAMAGE TOP OF FUSELAGE BETWEEN BS 382 - 399 BETWEEN STRINGERS 6 AND 7, APPROXIMATELY 18 INCHES BELOW LAP SEAM, RT SIDE. REPAIRED IAW ERA 530817-14, REV ORIGINAL.SDR FDEA201411203830Skin · corrodedUPON REMOVAL OF UPPER FUSELAGE VHF ANTENNA LIGHT CORROSION FOUND ON SKIN. CORROSION REMOVED, SKIN REMAINING THICKNESS CHECKED TO PRODUCTION DWG. NDT HFEC CHECKS CARRIED OUT. REMOVED MATERIAL WITHIN SRM LIMITS MAXIMUM 0.003" 6"X1".SDR DALA2014112006194Skin · damagedLIGHTNING STRIKE DAMAGE BETWEEN BS 399-411 AND STRINGER 6-7R. DAMAGED AREAS CUT OUT AND DOUBLERS INSTALLED IAW SECTION I OF ER/A 530817-14.SDR DALA2014112006192Skin · damagedLIGHTING STRIKE DAMAGE TOP OF SURFACE BS 474, 18 INCHES BELOW LAP SEAM RT SIDE. REPAIRED IAW ERA 530843-14, REV ORIGINAL.SDR DALA2014112006191Skin · damagedLIGHTNING STRIKE DAMAGE AT BS 474 AND S6R. DAMAGE REPAIRED IAW SECTION I OF ER/A 530843-14.SDR UHLA2014111900827Finger Doubler · corrodedCORROSION FOUND ON THE FWD CARGO CUTOUT STRUCTURE LOWER BEAM. REPAIRED THE AFT FINGER DOUBLER IAW ETD 2014-170-095210.SDR UHLA2014111900825Finger Doubler · corrodedCORROSION FOUND ON FWD CARGO FWD FINGER DOUBLER. REPAIRED THE FWD FINGER DOUBLER IAW ETD2014-170-095748.
Back to JASC 5330