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 SWAA071999Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 830, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA072003Skin · chafedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE SKIN CHAFED UNDER DORSAL FIN BS 925. REPAIRED SKIN PER SRM.SDR 07FDEA01538Skin Panel · corrodedCORROSION AT SKIN PANEL (A539-89559-386) AT C92 AND SEVERAL PARTS C91/92 BILGE AREA. REPAIR PERFORMED BY REPLACEMENT IAW SRM 51-72-10 OF FOLLOWING PARTS: T-SECTION A539-89317-208 / -209 / -206, SUPPORT SECTION A539-89330-216, PROFILE A539-89317-228, ANGLES ASDR USAA070305Skin · crackedFUSELAGE SKIN BS 727E + 3 INCHES, 1 INCH BELOW S-18L HAS CRACK. FABRICATED & INSTALLED DOUBLER PER SRM 53-00-01, REPAIR 31, DETAIL XI, DEFECT SIZE: 2 INCHES.SDR USAA070306Skin · crackedSKIN AT BS 380, BL 0 (E&E EXHAUST DUCT CUTOUT) HAS CRACK. FAB'D & INSTALLED INNER & OUTER DOUBLERS PER TYP REP 53-30-18A & EA 98624, DEFECT SIZE: .75 INCH.SDR AWXA200700757Skin · corrodedMCN - MAJOR REPAIR - CORROSION ON FUSELAGE SKIN INTERIOR SURFACE, BS 796, S23R - S25R. REPAIRED FUSELAGE SKIN INTERIOR SURFACE, BS 796, S23R - S25R IAW B737-300 53-00-01-2R32, FIGURE 201.SDR CA070514029Skin · cracked(CAN) FOUND CRACK IN SKIN OF MAIN TRANSMISSION DECK DURING SCHEDULED 500 HOUR INSPECTION. DECK REPAIRED IAW MFG REPAIR INSTRUCTIONS FOR CRACKS DISCOVERED IN THIS AREA. (TC NR 20070514029)SDR CALA0700221Skin · crackedINSPECTION FOUND A 2.125" CRACK IN LT FUSELAGE SKIN AT STA 727E, S24L, AFT OF EMERGENCY LIGHT. REPAIRED IAW SRM 53-00-01, REPAIR 31.SDR HALA0700184Skin · damagedFUSELAGE SKIN LT BS 276, STR 26 HAS LIGHTNING DAMGE AT FASTENER. REMOVED AND REPLACED FASTENER ON FUSELAGE SKIN AT BS 276 STR 26R PER SRM 53-00-01 FIG 201 SECTION II AND HAL M105 597053.SDR HALA0700189Skin · damagedSEVERAL LIGHTNING STRIKES ON EXTERNAL FUSELAGE SKIN BS 284 STR 34L. REPAIRED PER 767 SRM 53-00-01 FIG 201 AND HAL M105 597053.SDR HALA0700193Skin · damagedFUSELAGE SKIN, LT BS 256, BETWEEN STR 24 AND STR 26 HAS LIGHTNING DAMAGE AT FASTENER. REMOVED AND REPLACED FASTENER PER SRM 53-00-01 FIG 201 SECTION II AND HAL M105 FILE NR 597053.SDR HALA0700186Skin · damagedFUSELAGE SKIN RT BS 261, BETWEEN STR 33 AND STR 34 HAS LIGHTNING DAMAGE. REPAIRED LIGHTNING STRIKE OF FUSELAGE SKIN AT BS 261 BETWEEN STR 33 AND 34 PER 767 SRM 53-00-01-2R-8 AND HAL M105 597053.SDR HALA0700180Skin · damagedFUSELAGE SKIN RT BS 246, STR 32 HAS LIGHTNING DAMAGE. REPAIRED DAMAGED FUSELAGE SKIN AT BS 246, STR 32R IAW ER 06-3352 SECTION 11 AND SRM 53-00-01-2R-1 FIG 201SDR HALA0700179Skin · gougedWHILE WORKING CUSTOMER CARD NR 01731, FOUND SKIN GOUGED AT BS 426 STR 33 RT. REPAIRED PER HAL M105 597053.SDR HALA0700188Skin · damagedFUSELAGE SKIN, LT BS 220 BETWEEN STR 24 AND STR 27 HAS LIGHTNING DAMAGE AT FASTENERS. REMOVED DAMAGE AND REPAIRED IAW 767 SRM 53-00-01/201 SECT II STEP 3A AND HAL M105 597053.SDR HALA0700187Skin · damagedLIGHTNING STRIKES, BS 266 TO BS 276 BETWEEN STR 27L AND 30L. REPAIRED PER HAL M105 597053.SDR HALA0700196Skin · damagedFUSELAGE SKIN RT BS 236 TO BS 246 BETWEEN STR 32 AND STR 35 HAS 3 AREAS OF LIGHTNING DAMAGE. REPAIRED PER HAL M105 NR 597053.SDR HALA0700198Skin · damagedFUSELAGE SKIN LT BS 184, ABOVE STR 30 HAS LIGHTNING DAMAGE. REPAIRED PER HAL M105 NR 597053.SDR HALA0700191Skin · damagedFUSELAGE SKIN RT BS 355 BETWEEN STR 34 AND STR 35 HAS LIGHTNING STRIKE. REPAIRED PER HAL M105 FILE 597053.SDR HALA0700185Skin · damagedFUSELAGE SKIN LT BS 266, BETWEEN STR 24 AND STR 26 HAS LIGHTNING DAMAGE AT FASTENER. REMOVED DAMAGE AND REPAIRED IAW 767 SRM 53-00-01 FIG 201 AND HAL M105 597053.SDR HALA0700195Skin · damagedFUSELAGE SKIN LT BS 254, BETWEEN STR 24 AND STR 26 HAS LIGHTNING DAMAGE. REPAIRED PER HAL M105 597053.SDR HALA0700192Skin · damagedFUSELAGE SKIN BS 320 BETWEEN STR 23L AND STR 24L HAS LIGHTNING STRIKE. REPAIRED PER HAL M105 597053.SDR HALA0700181Skin · damagedLIGHTNING STRIKE, BS 256 ABOVE STR 27L DAMAGE. REPAIRED LIGHTNING STRIKE BY REMOVING AND REPLACING FASTENER AT BS 256 STR 27L PER SRM 53-00-01 FIG 201 SECITON II AND HAL M105 FILE 597053.SDR HALA0700183Skin · damagedFUSELAGE SKIN RIGHT BS 273, BETWEEN STR 29 AND STR 30 HAS LIGHTNING STRIKE. LIGHTNING STRIKE REPAIRED PER HAL M105 597053.SDR HALA0700197Skin · damagedFUSELAGE SKIN RT BS 185.5 JUST BELOW STR 30 HAS LIGHTNING STRIKE. REPAIRED PER HAL M105 NR 597053.SDR HALA0700190Skin · damagedFUSELAGE SKIN BS 322, BETWEEN STR 23L AND STR 24L HAS LIGHTNING STRIKE. LISGHTNING STRIKE OF FUSELAGE SKIN BS 332 BETWEEN STR 23 AND 24 LH WAS REPAIRED PER HAL M105 597053.SDR HALA0700194Skin · damagedFUSELAGE SKIN LEFT BS 274 STR 26 HAS LIGHTNING DAMAGE. REPAIRED PER HAL M105 597053.SDR HALA07001082Skin · damagedFOUND FUSELAGE SKIN LEFT BS 264 STRINGER 26 HAS LIGHTNING DAMAGE AT FASTENER. REMOVED DAMAGE FASTENER AND REPAIRED LIGHTNING DAMAGE AT BS 264 STR 26 IAW 767 SRM 53-00-01 FIG 201 AND HAL M105 597053.SDR USAA200704004Skin · cracked1.5" CRACK FOUND AT L2 DOOR LOWER HINGE CUT OUT. INSTALLED DOUBLER/TRIPLER PER EA 84451.SDR MASA200700235Skin · unserviceableFUSELAGE SKIN HAS SEVERE DISTORTIONS, PUNCTURES AND GOUGES FROM FS 559+112 TO FS 640 BETWEEN STRINGERS 6L TO 20L. REMOVED AND REPLACED FUSELAGE SKIN.SDR IXXA07SMN153SSkin · misrepairedDURING ROUTINE C CHECK INSPECTION, FOUND IMPROPER REPAIR AT AFT FUSELAGE SKIN PANEL AND SKIN SPLICES OF LONGERON 27 LEFT AT STATION 1699. REMOVED EXISTING EXTERNAL REPAIR DOUBLER. PERFORMED NDT INSPECTION. NO CRACK OR CORROSION FOUND. FABRICATED NEW SKIN, EXTSDR IXXA07SMN156SSkin · corrodedDURING ROUTINE C CHECK INSPECTION, FOUND IMPROPER REPAIR AT AFT FUSELAGE SKIN PANEL AND SKIN SPLICES OF LONGERON 28RIGHT AT STATION 1690. REMOVED EXISTING EXTERNAL REPAIR DOUBLER. PERFORMED NDT INSPECTION. NO CRACK OR CORROSION FOUND. FABRICATED NEW SKIN, SDR IXXA07SMN143SDoubler · crackedDURING ROUTINE C CHECK INSPECTION, FOUND EXTERNAL FUSELAGE NOSE SECTION RIGHT AFT PRIMARY HEAT INTERCHANGER AFT LOWER CORNER DOUBLER CRACKED AT STATION -12 LONGERON 27 RIGHT. REMOVED EXISTING REPAIR. FABRICATED REPAIR DOUBLER. CLEANED TREATED AND PRIMED ARESDR IXXA07SMN142SSkin · misrepairedDURING ROUTINE C CHECK INSPECTION, FOUND IMPROPER REPAIR LOCATED AT FS 1725 LONGERON 16.5 RIGHT. REMOVED EXISTING REPAIR. REMOVED DAMAGED AREA. FABRICATED NEW SKIN, AND INTERNAL DOUBLER. CLEANED, TREATED AND PRIMED AREA AND REPAIR PARTS. APPLIED SEALANT TSDR IXXA070029SSkin · misrepairedDURING ROUTINE C CHECK INSPECTION, FOUND IMPROPER REPAIR AT AFT FUSELAGE SKIN PANEL AND SKIN SPLICES OF LONGERON 28 RIGHT AT STATION 1690. REMOVED EXISTING EXTERNAL REPAIR DOUBLER. PERFORMED NDT INSPECTION. NO CRACK OR CORROSION FOUND. FABRICATED NEW SKIN,SDR IXXA07SMN135SSkin · misrepairedDURING ROUTINE C CHECK INSPECTION, FOUND IMPROPER REPAIR AT AFT FUSELAGE SKIN PANEL AND SKIN SPLICES OF LONGERON 28 LEFT AT STATION 1690. REMOVED EXISTING EXTERNAL REPAIR DOUBLER. PERFORMED NDT INSPECTION. NO CRACK OR CORROSION FOUND. FABRICATED NEW SKIN, SDR UPS07849809Skin · gougedINSPECTION TYPE:C3 FUSELAGE EXTERIOR EXISTING REPAIR DOUBLER HAS DEEP GOUGE AND FASTENER HEADS MISSING AT STA 520 L31R. REMOVED DAMAGED DOUBLER AND CUT OUT AREA AT STA 520 L31R IAW SRM 51-1-20D. FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLERS AT STA 520 SDR DU4R2007108Skin · damagedFOUND LIGHTNING STRIKE ON SKIN BETWEEN BS 610 AND 630 AT S-7R AND S-8R. REPAIRED BY CUTTING OUT S-7R FROM BS 610 TO 630. FABRICATED AND INSTALLED STRINGER REPAIR 9-1/2 BY 3 FROM BAC1498-234 AND 4 SPLICES 9-1/2 BY 1 FROM 7075-T6 .040 IAW B757 SRM 53-00-01 FIGSDR SWAA071967Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA071966Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT EQUIPMENT COOLING DUCT CUTOUT BS 378.5, LBL 2.8. REPAIRED SKIN PER SWA EA.SDR LR7A07017Skin · damagedDURING SCHEDULED A CHECK PER JOB CARD HA1200, FOUND FUSELAGE DAMAGED RT SIDE APPROX 4 INCHES LONG 2 INCHES WIDE AT FS 902, WL198, RBL 61.62. REPAIRED DAMAGE IAW MEA 382-53-07-036, LOG PAGE 26514 ITEM M1.SDR CALA0700194Skin · corrodedFUSELAGE SKIN INSIDE AIR DISTRIBUTION BAY FWD SIDE OF STA 540 STR 28RT KEEL BEAM CORRODED. REPAIRED IAW ECRA 5331-01301.SDR DALA1202991501Skin · damagedFUSELAGE SKIN FS 437 TO FS 440. REPAIRED IAW ERA 455189-14.SDR FDKA200704174Buttstrap · corrodedCENTER BUTT STRAP BETWEEN FRAME 15 TO JUST AFT OF FRAME 16 IS CORRODED BEYOND ALLOWABLE LIMITS. DAMAGE WAS REPAIRED.SDR ABXA070153Skin · crackedFUSELAGE SKIN CRACKED 2 PLACES FS 1087 LONGERON 3 - LONGERON 4 RIGHT. REPAIRED FUSELAGE SKIN AT STA 1095, LONGERON 3 - 4 RIGHT IAW DC9 SRM 53-04.SDR UPS07849803Skin · crackedINSPECTION TYPE:C1 HFEC & VISUAL INSPECTION DETECTED A CRACK ON THE C-4 (D-PIT) UPPER FWD DOOR JAMB CORNER. CRACK RUNS FROM FASTENER HOLE TO EDGE OF CUTOUT. REMOVED EXISTING DOUBLER. CUT OUT DAMAGE. FABRICATED AND INSTALLED DOUBLER, TRIPLER AND FILLER. RESDR UPS07849781Skin · misrepairedINSPECTION TYPE:C3 REMOVE STEEL DOUBLER FROM THE C-4 (D-PIT) UPPER FWD CORNER AND REPAIR PER SRM 53-2-0 FIG 21. REMOVED AND REPLACED DOUBLER AT C-4 (D-PIT) UPPER FWD CORNER IAW SRM 53-02-00 FIG 21, AND SRM TR 53-140, & 53-188, THIS REPAIR REQUIRES AN MPI WITHSDR 2007UALA01241Skin · crackedCRACK ON AFT LT LOWER FUSELAGE AFT OF WING SCAN LIGHT AFT OF PREVIOUS RPR, CRACK IS ON THE EDGE OF A STRINGER. [SUP 05-08-07] MAJOR REPAIR ACCOMPLISHED: DAMAGED AREA CUTOUT. MFG'D & INSTALLED DOUBLER, TRIPLER AND FILLER REPAIR.SDR GUUA04200702Skin · corrodedSCHEDULED INSPECTION DISCOVERED BELLY SKIN CORROSION AT FS 327.830 BETWEEN STRINGER 15R THRU 14R. REMOVED DAMAGED SKIN AND INSTALLED EXTERNAL REINFORCEMENT DOUBLER IAW STRUCTURAL REPAIR MANUAL 51-70-06.SDR DL76S070352Skin · gougedTHE FUSELAGE SKIN WAS GOUGED FORWARD OF THE C2 DOOR OPENING AT STA 1269, S31R. GOUGE AFTER BLENDING WAS 1 BY 0.8 IN. THE DAMAGED SKIN WAS CUT OUT AND A REPAIR DOUBLER WAS INSTALLED.
Back to JASC 5330