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 CALA2014052791154Skin · dentedDENT IN FUSELAGE EXTERIOR REPAIR BS 608.5 & 1 IN BELOW STRINGER 16L. REMOVED EXISTING REPAIR DOUBLER AT BS 608.5, STRINGER 16L. INSTALLED NEW REPAIR DOUBLER AT BS 596 - 620 & STRINGER 15L - 18L. THIS IS A CAT A REPAIR. THE SKIN REPAIR BETWEEN BS 596 - 620 SDR SWIA201438090Skin · chafedCHAFING ON SKIN S27 BS 977-985. C-CHECK, REPAIRED SKIN IAW REO AND MODSUM.SDR SWAA2014060428688Skin · crackedSKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED SKIN IAW SRM.SDR SWAA2014053028511Skin · crackedLOWER FUSELAGE BELLY DRAINS 3 & 4 FROM THE FRONT CRACKED. R & R SKIN IAW MM.SDR SWIA201437777Skin · dentedAFT LOWER CORNER OF BAGGAGE BAY DOOR CUTOUT IS DENTED IN AND OUT OF LIMITS IAW SRM. CUT-OUT DAMAGE, FABRICATED DOUBLERS AND LOCATED FASTENER HOLES, PERFORMED FINAL CUT ON 3 DOUBLERS AND COUNTERSUNK FASTENER HOLES. INSTALLED SEALANT AND DOUBLERS AND COMPLETED SDR DALA14032146815Skin · damagedLOWER FUSELAGE SKIN AT BS 272, TWO INCHES ABOVE STRINGER 19R HAS LIGHTNING STRIKE DAMAGE. DRILLED OUT DAMAGE IAW SRM 53-00-01, FIG 201 AND APPLIED ALODINED IAW SRM 51-20-01, HFEC INSPECTED IAW NDTM PART 6, 51-00-16, NO CRACKS NOTED. APPLIED PRIMED AREA IAWSDR DALA14032136815Skin · damagedFWD FUSELAGE AT BS 535 ABOVE S25L HAS ONE LIGHTNING STRIKE EXIT. DRILLED OUT DAMAGE IAW SRM 53-00-01. COMPLIED WITH HFEC INSPECTION IAW HDTM P 6, 51-00-16, NO CRACKS NOTED A 15270, APPLIED PRIMED IAW SRM 51-20-01, INSTALLED FASTENERS IAW SRM 51-40-02 AND 5SDR CALA2014052300655Doubler · corrodedSEVERAL CORROSIONS WERE FOUND ON UPPER SURFACE OF FWD CARGO BOTTOM ANTENNA DOUBLER STATION 500 - STATION 500A STRINGER 28L - STRINGER 28R S=3"X2". REMOVED CORROSION, MEASURED AREA, TRIMED OUT DAMAGED AREA & INSTALLED NEW DOUBLER IAW ECRA 5331-01884 PART 1. ISDR DALA14032399213Skin · crackedAFT ACCESSORY COMPARTMENT AT BS 1520 INBD SIDE OF LONGERON 2R SKIN DOUBLER CRACKED. CUT OUT DAMAGED SECTION. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-10-03.SDR DALA14031883237Skin · corrodedCORROSION ON EXTERNAL SKIN UNDER SCUFF PLATE LOCATED AT FRAME 68, AFT OF LT ENTRY DOOR. PERFORMED PERMANENT ON SKIN IAW ER/A 525501-14, REV ORIGINAL.SDR DALA14031746904Skin · damagedFUSELAGE SKIN STR 18L DAMAGED AT BS 1380, C/W ERA 526120-14, REV ORIG.SDR DALA14031696904Skin · dentedFUSELAGE SKIN DENTED AT BS 1382 BELOW STRINGER 19L. COMPLIED WITH ERA 526120-14, REV ORIGINAL.SDR DALA2016112509230Skin · corrodedCORROSION WAS FOUND ON THE EXTERNAL SKIN LOCATED BETWEEN FRAMES 64 - 70, STRINGERS 37 - 41R. THE CORROSION WAS REMOVED IAW SRM.SDR DALA1601583262Doubler · corrodedFUSELAGE AFT LAV SERVICE DOOR CUTOUT REINFORCING DOUBLER CORRODED, REPAIRED IAW ER/A 525852-14, LOG 1436046.SDR FDEA201405211104Skin · crackedFUSELAGE CTR WING BOX REAR SPAR & BOTTOM PANEL RT SIDE HOLE P FOUND CRACK SIGNAL. COMPLIED WITH EA 6-5710-T0308679 PT1. MAJOR REPAIR IAW GMM 6-2-100.SDR SWIA2014061338154Skin · dentedDENT DAMAGE TO AFT FUSELAGE BS 718 AND 736, S20-21R, C-CHECK, REPAIRED SKIN IAW REO.SDR FXGA201405211424Skin · corrodedREPAIR AROUND WINDOW AT STATION 157 BETWEEN STRINGER 14R & 16R. THE CORROSION IS LOCATED BETWEEN THE OUTER SKIN & WINDOW CUT OUT DOUBLER. THE OUTER SKIN WILL BE CUT OUT & THE INTERNAL DOUBLER WILL BE CLEANED UP & PROTECTED FROM CORROSION. THE AREA WILL BE RSDR DALA14032689257Skin · crackedLEFT LOWER AFT FUSELAGE, BS 1531, SKIN CRACKED, AT RIVET ABOVE VENTRAL STAIR CUTOUT. REMOVED DAMAGE. COMPLETED REPAIR IAW SRM 53-00-01, FIG 6.SDR DALA14032679257Skin · crackedSKIN HAS A CRACK THROUGH 2 SIDE OF FASTENER HOLE, BS 1475, L2R. REPAIRED FUSELAGE AND INSTALLED DOUBLER IAW ERA 526106-14, REV O.SDR DALA14032590662Skin · damagedLIGHTNING STRIKE BS 720, S14R. C/W ERA 526192, REV ORIG.SDR AALA20140523004Skin · damagedAFT FWD CARGO CUT OUT SURROUND SKIN BENEATH SCUFF PLATE DAMAGED. ACCOMPLISHED REPAIR IAW EA B737-53-035009.SDR SWAA2014052728369Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 680 TO BS 681, STRINGER 10R. REPAIRED SKIN IAW ER & EA.SDR DALA14032003237Skin · corrodedCORROSION WAS FOUND ON INNER FUSELAGE SKIN FRAMES 64-65 STRINGERS 43-44R. CORROSION REMOVED WITH CUTOUT IN FUSELAGE SKIN. PERFORMED TIME LIMITED REPAIR IAW ERA 525506-14, REV ORIGINAL.SDR CALA2014052291122Skin · corrodedCORROSION AFT CARGO COMPARTMENT JUST AFT RT FRAME 57 UNDER FLOOR STRINGER 38. PERFORMED LT ANGLE REPAIR AT AFT CARGO STRINGER 42L BETWEEN FRAME 58 & FRAME 59 IAW SRM53-00-13 FIG 205 SHEET 3. REPAIR IS A CAT B REPAIR & REQUIRES RE-INSP AT 60000 FC & 75000 FH SSDR SWAA2014052328292Filler · crackedGROUND POWER CUT OUT DOUBLER FILLER CRACKED. R & R FILLER IAW SRM.SDR SWAA2014052328315Skin · crackedSKIN CRACKED AT BS 486, STRINGER 9R. REPAIRED SKIN IAW EA.SDR SWIA201437700Skin · dentedDENT TO AFT FUSELAGE AFT OF BS 718 - 736, S20 - 21R. REPAIRED FUSELAGE DAMAGE IAW REO.SDR AALA20140521022Skin · corrodedCORROSION ON FUSELAGE SKIN AROUND 10 FASTENERS AT STATION 927 & STRINGER 22LT. REMOVED CORROSION & ACCOMPLISHED REPAIR IAW EA B737-53-034990.SDR AALA20140521021Skin · corrodedCORROSION ON FUSELAGE SKIN AROUND 3 FASTENERS AT STATION 927 & STRINGER 24 LT. REMOVED CORROSION & ACCOMPLISHED REPAIR IAW EA B737-53-034990.SDR SWAA2014071429976Skin · crackedFUSELAGE SKIN CRACKED AT BS 994, LONGERON 25R. REPAIRED SKIN IAW SRM.SDR SWAA2014071129880Doubler · crackedFUSELAGE SKIN CUT OUT DOUBLER CRACKED AT BS 200. R & R SKIN IAW SRM & DWG.SDR SIMA20140520010Doubler · corrodedANTENNA DOUBLER BETWEEN FS 295.00 - 310.00 AT STRINGER 27 IS CORRODED. R & R THE ANTENNA DOUBLER BETWEEN FS 295.00 - 310.00 AT STRINGER 27 IAW SRM 51-42-06.SDR SWAA2014060928853Skin · crackedSKIN CRACKED AT BS 540, BETWEEN STRINGER 22L TO STRINGER 23L. REPAIRED SKIN IAW ER & EA.SDR SWAA2014060928852Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED SKIN IAW ER & EA.SDR A6WA201441604Skin · scratchedACFT SKIN UNDER TCAS ANTENNA HAS MULTIPLE SURFACE SCRATCHES. REPAIRED IAW STS EA 15-2014-128 DATED 5/23/2014.SDR CALA2014052291115Skin · corrodedBS 1350 STRINGER 17L - 18R SKIN CORRODED, REMOVED DAMAGE. HFEC FABRICATED & INSTALLED REPAIR PARTS IAW ECRA 5330-04801.SDR DALA14031766904Skin · dentedDENT AND TOOL DAMAGE FOUND ON SKIN.SDR DALA14031715812Skin · damagedLIGHTNING STRIKE AT BS 860, S7L. REMOVED DAMAGE IAW SRM 53-00-01. HFEC INSPECTED IAW SRM 53-00-01, NO DEFECTS, INSTALLED BLIND FASTENER IAW SRM 53-00-01.SDR DALA14031705812Skin · damagedLIGHTNING STRIKE BS 865, FOUR INCHES BELOW STRINGER 7. REMOVED DAMAGE IAW SRM 53-00-01. HFEC INSPECTED IAW SRM 53-00-01, NO DEFECTS. INSTALLED BLIND FASTENER IAW SRM 53-00-01.SDR AALA20140520001Skin · crackedSKIN CRACKED AT 1427 CANT FRAME, 20 INCHES ABOVE AIRSTAIR CUT OUT. INSTALLED EXTERIOR DOUBLER IAW SRM 53-10-00-001.SDR DALA14031515812Skin · damagedLIGHTNING STRIKE AT BS 780, TWO INCHES ABOVE STRINGER 9 LEFT. REMOVED DAMAGE IAW SRM 53-00-01. HFEC INSPECTED IAW SRM 53-00-01 WITH NO ITEMS. INSTALLED SOLID FASTENER IAW SRM 53-00-01.SDR DALA14031505812Skin · damagedLIGHTNING STRIKE AT BS 780 AND 1200 ON STRINGER 8 LEFT. REMOVED DAMAGE IAW SRM 53-00-01. HFEC INSPECTED IAW SRM 53-00-01 WITH NO ITEMS. INSTALLED SOLID FASTENER IAW SRM 53-00-01.SDR DALA14031495812Skin · damagedLIGHTNING STRIKE AT BS 780 AND 790, TWO INCHES ABOVE STRINGER 9 LEFT. REMOVED FASTENER IAW SRM 53-00-01. HFEC INSPECTED IAW SRM 53-00-01 WITH NO ITEMS. INSTALLED SOLID FASTENER IAW SRM 53-00-01.SDR DALA14031485812Skin · damagedLIGHTNING STRIKE AT BS 862, ONE INCH ABOVE STRINGER 7 LEFT. REMOVED DAMAGE IAW SRM 53-00-01. HFEC INSPECTED IAW SRM 53-00-01, NO ITEMS. INSTALLED SOLID FASTENER SRM 53-00-01.SDR DALA14031475812Skin · damagedLIGHTING STRIKE AT BS 820, S8L. REMOVED DAMAGED FASTENER IAW SRM 53-00-01. HFEC INSPECTED IAW SRM 53-00-01, NO ITEMS DETECTED. INSTALLED SOLID FASTENER IAW SRM 53-00-01.SDR DALA14031465812Skin · damagedLIGHTNING STRIKE AT BS 800, FOUR INCHES ABOVE S8L. REMOVED DAMAGED FASTENER IAW SRM 53-00-01. HFEC INSPECTED IAW SRM 53-00-01, NO ITEMS DETECTED. INSTALLED SOLID FASTENER IAW SRM 53-00-01.SDR DALA14031535812Skin · damagedLIGHTNING STRIKE AT BS 780 S9L. REMOVED DAMAGE IAW SRM 53-00-01. HFEC INSPECTED WITH NO ITEMS. INSTALLED SOLID FASTENER IAW SRM 53-00-01.SDR DALA2016112509231Skin · corrodedCORROSION ON EXTERNAL SKIN UNDER SCUFF PLATE ARE LOCATED AT LEVEL FRAME 68 AFT LT ENTRY DOOR. REPAIRED EXTERNAL SKIN UNDER SCUFF PLATE AT LEVEL FR 68 AT L/H ENTRY DOOR AS PER ER/A. LP#1448053SDR DALA2016111708952Skin · corrodedTHE AFT CARGO BAY INNER FUSELAGE SKIN BETWEEN STRINGERS 41 AND 42 AND FRAMES 56 AND 57 UNDER THE ATG ANTENNA DOUBLER. CORROSION WAS REMOVED AND REPAIRED IAW ERA 525523-14.SDR CA140522001Skin · damaged(CAN) THE ACFT SUFFERED A LIGHTNING STRIKE AFTER DEPARTURE. SINCE THERE WAS NO LOSS OF SYSTEMS OR OTHER ABNORMAL INDICATIONS THE FLIGHT CONTINUED. AFTER ARRIVAL, MAINTENANCE INSPECTION OF THE ACFT FOUND EXTENSIVE DAMAGE. APPROXIMATELY 37 BURN MARKS OF VARYI
Back to JASC 5330