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 DALA1231780931Skin · damagedDURING HMV LIGHTNING STRIKES WERE FOUND ON LT WINDOW BELT AT AFT UPPER CORNER BTW STA Y=560-579. AREA WAS BLENDED OUT IAW ERA 503255-14 REV ORIG.SDR DALA1231750931Skin · crackedSKIN CRACKED AT BS 1418 L1-2R, REMOVE DAMAGE AREA AND INSTALLED FILLER AND DOUBLER IAW ER/A5010910-14 REV ORIG.SDR SWAA2012051504029Skin · corrodedSKIN CORRODED AT BS 851, BETWEEN STR 24L TO STR 30L. REPAIRED SKIN IAW SRM.SDR SCNA2012051512018Skin · damagedLIGHTNING STRIKE DAMAGE ON INTERNAL FUSELAGE SKIN BS 727G TO 787 BETWEEN STRINGERS 27L AND 27R. ACCOMPLISHED HFEC INSPECTION ON BOTH SIDES OF SKIN AT DAMAGE LOCATIONS AND VISUAL INSPECTION OF UNDERLYING STRUCTURE - NO FURTHER DEFECTS NOTED. FABRICATED EXTERNSDR SCNA2012051512017Skin · dentedDENTED FUSELAGE SKIN BS 1064 BETWEEN STRINGERS 24R AND 25R. CUT OUT DAMAGED SECTION OF SKIN, ACCOMPLISHED HFEC INSPECTION OF CUTOUT, FABRICATED REPAIR DOUBLER USING .063" 2024-T3AL AND INSTALLED REPAIR IAW B737-800 SRM 53-00-01 REPAIR 3.SDR C77A20130502014Skin · dentedBIRD STRIKE DENT DAMAGE IN THE FWD FUSELAGE SKIN IN THREE LOCATIONS.SDR C77A20130502004Skin · dentedBIRD STRIKE DENT DAMAGE IN THE FWD FUSELAGE SKIN IN THREE LOCATIONS.SDR C77A201305020004Skin · dentedBIRD STRIKE DENT DAMAGE IN THE FWD FUSELAGE SKIN IN THREE LOCATIONS.SDR AALA20120614019Skin · corrodedCORROSION ON INTERNAL FUSELAGE SKIN AT FORWARD LAVATORY VENT NOZZLE. PERFORMED BLEND OUTSKIN REPAIR PER EA B767-53-024283.SDR SWAA2012053004465Skin · corrodedSKIN CORRODED AT BS 797, RBL 14. REPAIRED SKIN IAW EA.SDR CHQA20120514177Skin · damagedDURING INSPECTION, A SKIN BURN FROM A LIGHTNING STRIKE WAS FOUND ON THE RIGHT FUSELAGE SKIN BETWEEN FRAME 30 AND FRAME 31 AT STRINGER 16R. THE RIGHT FUSELAGE SKIN BETWEEN FRAME 30 AND FRAME 31 AT STRINGER 16R WAS REPAIRED IN ACCORDANCE WITH SRM 53-22-01.SDR CHQA20120514176Skin · burnedDURING INSPECTION, A SKIN BURN FROM A LIGHTNING STRIKE WAS FOUND ON THE RIGHT FUSELAGE SKIN BETWEEN FRAME 24 AND FRAME 25 AT STRINGER 18R. THE RIGHT FUSELAGE SKIN BETWEEN FRAME 24 AND FRAME 25 AT STRINGER 18R WAS REPAIRED IN ACCORDANCE WITH SRM 53-22-01.SDR USAA2012051700008Skin · crackedGEAR FITTINGS - CRACK IN SKIN LAP JOINT BETWEEN TWO RIVETS AT BS 747, S4L. REPAIRED SKIN LAP JOINT BETWEEN TWO RIVETS AT BS 747, S4L IAW B737-300 SRM 53-00-01-2R30.SDR SWAA2012051704090Skin · crackedFUSELAGE SKIN CRACKED AT BS 500D +16, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA2012051704089Skin · crackedFUSELAGE SKIN CRACKED AT BS 347, STR 2L. REPAIRED SKIN IAW EA.SDR DALA1231570931Skin · damagedDURING HMV, LIGHTNING STRIKES WERE FOUND ON LT WINDOW BELT AT FWD UPPER CORNER BTW STA Y=1079-1098. AREA WAS BLENDED AND DOUBLER INSTALLED IAW ERA 503253-14 REV ORIG.SDR DALA1231560931Skin · damagedDURING HMV, LIGHTNING STRIKES WERE FOUND ON LT WINDOW BELT AT AFT/LWR CORNER BTW STA Y=1231-1250. AREA WAS BLENDED OUT IAW ERA 503255-14 REV ORIG.SDR DALA1231540931Skin · damagedDURING HMV, LIGHTNING STRIKES WERE FOUND ON LT WINDOW BELT AT LWR AND UPPER EDGE BTW STA Y=984-1003. AREA WAS BLENDED OUT IAW ERA 503255-14 REV ORIG.SDR DALA1231530931Skin · damagedDURING HMV, LIGHTNING STRIKE FOUND ON LT WINDOW BELT AT FWD LWR CORNER BTW STA Y=1212-1231. AREA WAS BLENDED OUT AND DOUBLER INSTALLED IAW ERA 503254-14 REV ORIG.SDR DALA1231520931Skin · damagedDURING HMV, LIGHTNING STRIKE FOUND ON R WINDOW BELT FRAME AT LWR CORNER EDGE BTW STA Y=1098-1117. WINDOW BELT WAS REPAIRED IAW ER/A 503247-14 REV ORIG.SDR DALA1231490931Skin · damagedDURING HMV, LIGHTNING STRIKES WERE FOUND ON RT WINDOW BELT AT FWD UPPER CORNER BTW STA Y=370-389. AREA WAS BLENDED OUT IAW ERA 503255 REV ORIG.SDR DALA1231470931Skin · damagedDURING HMV, LIGHTNING STRIKES WERE FOUND ON RT WINDOW BELT AT AFT LWR CORNER BTW STA Y=503-522. AREAS WERE BLENDED OUT IAW ERA 503255-14 REV ORIG.SDR DALA1231460931Skin · damagedDURING HMV, LIGHTNING STRIKES WERE FOUND ON RT WINDOW BELT AT FWD UPPER CORNER BTW STA Y=408-427. BLENDED WINDOW BELT IAW ERA 503255-14 REV ORIG.SDR DALA1231450931Skin · damagedDURING HMV, SCRATCHES WERE FOUND ON RT WINDOW BELT AT FWD/LWR CORNERS BTW STA Y=1079-1098. SCRATCHES WERE BLENDED OUT IAW ERA503255-14 REV ORIG.SDR SWAA2012051504015Skin · crackedSKIN CRACKED AT BS 347, STR 2L. REPAIRED SKIN PER SRM.SDR SWAA2012051403963Skin · damagedSKIN CREASED AT BS 237, BETWEEN STR 17L TO STR 18L. REPAIRED SKIN PER SRM.SDR SWAA2012051403962Skin · damagedSKIN CREASED AT BS 218, BETWEEN STR 17L TO STR 18L. REPAIRED SKIN PER SRM.SDR PCSA2012051501Skin · corrodedFOUND CORROSION AT BODY STATION 764 BETWEEN STRINGER 34R AND 36R.SDR DALA1231330931Skin · corrodedDURING HMV, CORROSION WAS FOUND ON FUSELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING STA Y=1121-1124 BTW LONGS 26LH-27LH. CORROSION WAS BLENDED OUT AND DOUBLER INSTALLED IAW MD-88SRM 53-04 PARA 57.SDR DALA1231320931Skin · damagedDURING HMV, LIGHTNING STRIKES WERE FOUND ON WINDOW BELT AT FWD LWR CORNER BTW STA Y=750-731. WINDOW BELT WAS BLENDED OUT AND DOUBLER WAS INSTALLED IAW ER/A 503246-14 REV ORIG.SDR DALA1231310931Skin · damagedDURING HMV, LIGHTNING STRIKES WERE FOUND ON RT WINDOW BELT AT FWD LWR CORNER BTW STA Y=636-655. WINDOW BELT WAS BLENDED OUT AND DOUBLER INSTALLED IAW ER/A 503245-14 REV ORIG.SDR DALA1231300931Skin · damagedDURING HMV, LIGHTNING STRIKES WERE FOUND ON LT WINDOW BELT AT AFT LWR CORNERS BTW STA Y=693-712. WINDOW BELT WAS BLENDED OUT AND DOULER INSTALLED IAW ER/A 503250-14 REV ORIG.SDR DALA1231280931Skin · damagedDURING HMV, LIGHTNING STRIKES WERE FOUND ON RT WINDOW BELT AT FWD LWR CORNER BTW STA Y=1174-1193. WINDOW BELT WAS BLENDED OUT AND DOUBLER INSTALLED IAW ER/A 503248-14 REV ORIG.SDR DALA1231270931Skin · damagedDURING HMV, LIGHTNING STRIKE WAS FOUND ON LT WINDOW BELT AT AFT/LOW CORNERS BTW STA Y=655-674. WINDOW BELT WAS BLENDED AND DOUBLER INSTALLED IAW ER/A 503249-14 REV ORIG.SDR DALA1231260931Skin · damagedDURING HMV, LIGHTNING STRIKE WAS FOUND ON RT WINDOW BELT FRAMES AT AFT LOWER CORNER BTW STA Y=617, 636 WINDOW BELT FRAME WAS BLENDED OUT AND DOUBLER WAS INSTALLED IAW ER/A 503245-14 REV ORIG.SDR DALA1239430679Skin · dentedDURING HMV, SKIN HAS A DENT AT BS 430.5 BETWEEN L17-18L. DENT FOUND TO BE OUT OF LIMITS, CUT OUT DAMAGED SECTION. FABRICATED REPAIR DOUBLER AND INSTALLED IAW SRM 53-00-01.SDR UALA2012051602775Skin · damagedRT FUSELAGE SKIN FR 33 AND STR 23R UNDER FILLET PANEL 192AT EXCESSIVE MATERIAL REMOVED REF SMB WU U9578I. MAJOR REPAIR ACCOMPLISHED PER SRM 53-21-11 FIG.215.SDR SWAA2012051504012Skin · crackedR1 DOOR FUSELAGE SKIN LOWER HINGE CUTOUT BEAR STRAP CRACKED AT BS 288, STR 14R. REPAIRED SKIN PER SRM.SDR FDEA201205121806Skin · corrodedUPPER WING CENTER BOX UPPER EXTERNAL SKIN UNDER STUB BEAM AT BS 940, RBL 63, CORRODED. REMOVED CORROSION, FOUND OUT OF LIMITS IAW SRM 57-10-01, FIG 101, TABLE 1, NOTE A. COMPLIED WITH EA F-5710-159946. MAJOR REPAIR.SDR FDEA201205121805Skin · corrodedRT UPPER CENTER WING BOX EXTERNAL SKIN AT BS 960, RBL 64 CORRODED. REMOVED CORROSION, FOUND OUT OF LIMITS IAW SRM 57-10-01, FIG 101, TABLE 1, NOTE A. COMPLIED WITH EA F-5730-160574. MAJOR REPAIR.SDR FDEA201205121804Skin · corrodedCORROSION ON CENTER WING BOX UPPER SKIN, UPPER SURFACE AT BS 940, LBL 63. REMOVED CORROSION, FOUND OUT OF LIMITS IAW SRM 57-10-01, FIG 101, TABLE 1 NOTE A. REPAIRED IAW NR 4774935 AND EA 757-5710-16-F3831. MAJOR REPAIR.SDR SWAA2012052904390Skin · crackedSKIN CRACKED AT BS 767+3, STR 14L. REPAIRED SKIN PER EA.SDR SWAA2012051704099Skin · crackedSKIN CRACKED AT BS 757, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA2012051704098Skin · crackedSKIN CRACKED AT BS 799, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA2012051704097Skin · crackedSKIN CRACKED AT BS 727D, STR 4R. REPAIRED SKIN PER SRM.SDR AALA20120511005Skin · damagedLIGHTING STRIKE AT STATION 239 STRINGER 24. REMOVED DAMAGE PER SRM 53-00-01 AND INSTALLED WET RIVET PER SRM 53-00-01-2R.SDR DALA1231690128Skin · damagedGOUGE AFT OF FWD CARGO DOOR. REPAIRED DAMAGED PER SRM 53-00-01.SDR SWAA2012051403975Skin · crackedSKIN CRACKED AT BS 767 +3, STR 14L. REPAIRED SKIN PER SRM.SDR SWAA2012051403930Skin · crackedSKIN CRACKED AT BS 761 + 3, STR 14L. REPAIRED SKIN PER SRM.SDR MASA2012051434776Skin · corrodedFUSELAGE LOWER SKIN PANEL AT FS 310.00 TO FS 319.70 HAS CORROSION BETWEEN STR 27L AND 26L. PERFORMED A MAJOR PERMANENT REPAIR BY INCORPORATING REO 690-53-21-355 REV--AND RO CRJ9-53-1045.
Back to JASC 5330