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 SWAA2013111322331Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B+13, STRINGER 10L. REPAIRED SKIN IAW EA.SDR C77A20131111005Skin · damagedEVIDENCE OF LIGHTNING STRIKE ON FUSELAGE SKIN AT FRAME 20, STRINGER 29R. REMOVED DAMAGE IAW SRM 51-40-02, FABRICATED A SPACER IAW SRM 51-31-00 AND 51-40-02.SDR ASOA20131109268Skin · corrodedDURING C-CHECK, GALLEY SKIN WAS FOUND TO BE CORRODED BETWEEN FRAMES 17-18 AND STRINGERS 21L-21R. MAINTENANCE REMOVED THE CORROSION AND PERFORMED A DOUBLER REPAIR IAW SRM 53-21-01. ACFT APPROVED FOR RETURN TO SERVICE.SDR COEA2013112201821Skin Panel · corrodedEXTERNAL SKIN PANEL HAS SEVERAL SPOTS OF LEVEL 2 CORROSION BETWEEN FRAMES 14 - 16. REPAIR IAW SRAS DT S-6251 13 8077 DATED 11/21/2013.SDR ASOA2013112209470Skin · dentedDENT FOUND IN FUSELAGE SKIN BETWEEN BS 193-202.75 AND BETWEEN S12-13L. COUNTERSUNK DEBURRED TREATED AND PRIMED NWE SKIN PANEL IAW SRM 51-21-11-001-001-A01, 51-40-11-001-001-A01. INSTALLED NEW SKIN PANEL AND APPLIED FILLET SEALANT IAW SRM 51-42-06-001-001-A01SDR DALA13060546813Skin · dentedFUSELAGE SKIN BS 605 S27-28R DENTED AND CREASED. DAMAGE WAS REMOVED AND REPAIRED IAW ER/A 519285-14.SDR FDEA201311082715Skin · puncturedSKIN DENTED AT BS 460-480, STR 27L- 28L, PUNCTURED THROUGH. REPAIRED IAW EA F-5240-T0303070. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100.SDR FDEA201311082714Skin · damagedNUMEROUS SMALL NICKS AND SCRATCHES BETWEEN STRINGER 26 RT AND 26 LT AT BS 540-520, 540 -560, STR 26L-26R EXTERIOR SKIN NICKS AND SCRATCHES. REMOVED, FOUND OUT OF LIMIT AT STA 523, ABOVE STR 28L AND STA 529 BELOW STR 27L IAW SRM 53-00-01, FIG 101 DETAIL II, SDR SWIA201335405Skin · chafedFUSELAGE SKIN CHAFE AT FS 927 STRINGER 27. C-CHECK REWORKED BELLY SKIN CHAFE DAMAGE AT FS 927.00 & STRINGER 27 IAW REO.SDR CHQA20131107427Skin · corrodedCORROSION WAS FOUND ON THE SKIN BETWEEN FRAMES 13 & 14 BETWEEN STRINGERS 20L & 20R. THE SKIN WAS REPAIRED IAW ETD 2013-145-057134.SDR SWAA2013111822403Skin · crackedFUSELAGE SKIN CRACKED AT 540 CHORD 2ND FASTENER BELOW STRINGER 22L. REPAIRED SKIN IAW EA.SDR V0XD201311150284Skin · dentedRIGHT SIDE OF FUSELAGE SKIN HAS DENT AFT OF FWD POTABLE WATER SERVICE PANEL BETWEEN FS 364 TO 379 AT STRINGER 20RT. CUT OUT DAMAGED AREA AND INSTALLED REPAIR PARTS, LOWER & UPPER DOUBLERS AND A FILLER, IAW REO 670-53-21-1032, REV B.SDR IPXA2013110880784Skin · corrodedDURING HFEC INSPECTION OF FASTENERS ON HEAT DAMAGED AREA ABOVE APU EXHAUST, FOUND HEAVY CORROSION BETWEEN AND UNDER EMPENNAGE FAIRING. REMOVED CORROSION IAW SRM 51-21-01. ACCOMPLISHED INTERNAL DVI IAW EO MD11-5330-52665A. NO STRUCTURAL DEFECTS OR FASTENER SDR SWAA2013120322954Skin · crackedRT BS 727A+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 7. REPAIRED SKIN IAW EA.SDR SWAA2013112722802Skin · crackedFUSELAGE SKIN CRACKED AT BS 847+10, UPPER AFT WINDOW CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2013111922585Skin · crackedRT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2 & 3. REPAIRED SKIN IAW SB.SDR SWAA2013111922581Skin · crackedLT BS 887+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 2 & 3. REPAIRED SKIN IAW SB.SDR SWAA2013111922580Skin · crackedLT BS 827+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111922579Skin · crackedLT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111922578Skin · crackedLT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3,6 & 9. REPAIRED SKIN IAW SB.SDR SWAA2013111922577Skin · crackedRT BS 827+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3 & 8. REPAIRED SKIN IAW SB.SDR SWAA2013111922576Skin · crackedRT BS 787+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,6 & 7. REPAIRED SKIN IAW SB.SDR SWAA2013111922575Skin · crackedRT BS 767+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3 & 6. REPAIRED SKIN IAW SB.SDR SWAA2013111922574Skin · crackedRT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1-3. REPAIRED SKIN IAW SB.SDR SWAA2013111922573Skin · crackedRT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 2, 3 & 7. REPAIRED SKIN IAW SB.SDR SWAA2013111822546Skin · crackedLT BS 807+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822545Skin · crackedRT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2 & 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822543Skin · crackedLT BS 867+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 1. REPAIRED SKIN IAW EA.SDR SWAA2013111822542Skin · crackedLT BS 847+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 1. REPAIRED SKIN IAW EA.SDR SWAA2013111822541Skin · crackedLT BS 767+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013111822540Skin · crackedLT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3,5 & 9. REPAIRED SKIN IAW EA.SDR SWAA2013111822531Skin · crackedLT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822530Skin · crackedLT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822529Skin · crackedLT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822528Skin · crackedRT BS 867+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822527Skin · crackedRT BS 847+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822526Skin · crackedRT BS 807+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822525Skin · crackedRT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3 & 9. REPAIRED SKIN IAW SB.SDR SWAA2013111822524Skin · crackedRT BS 847+10 UP AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR AALA20131106015Skin · gougedGOUGES IN FUSELAGE SKIN AT STATION 1572. INSTALLED DOUBLER REPAIR IAW SRM 53-00-01-2R-14.SDR DALA13060536813Skin · dentedFUSELAGE SKIN BS 574, S27-28R, DENTED & CREASED. DAMAGE REMOVED AND REPAIRED IAW ER/A 519284-14.SDR SWAA2013111322328Skin · crackedRT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 4. REPAIRED SKIN IAW EA.SDR DALA13060156813Skin · dentedUPPER FUSELAGE SKIN HAS MULTIPLE DENTS IN CROWN AREA BS 1480-1500 S4L-6L. DENTS 2,3 & 4 FOUND TO BE WITHIN LIMITS, DENT FOUR FOUND TO BE OUT OF LIMITS IAW SRM 53-00-01. REPAIRED IAW ERA 519296-14 REV ORIG.SDR DALA13059666710Skin · damagedEVIDENCE OF LIGHTINING STRIKE ON BOTTOM OF FUSELAGE BS 210, 8 INCHES AFT OF THE RADOME APPROX 7 OCLOCK . CLEANED DAMAGED AREA PER SRM 53-00-01.SDR DALA1504500981Skin · damagedFUSELAGE AFT LAV SERVICE DOOR CUTOUT FS 1315 & L-22L SKIN & SURROUND DOUBLER REPAIRED IAW ERA 501813-14, T484790, LOG 0582213, LOG 1176332.SDR SWAA2013112722810Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED SKIN IAW SWA EA & SRM.SDR DALA13063470957Skin · corrodedDURING SCHEDULED CHECK, CORROSION FOUND ON FUSELAGE SKIN BS 780 BETWEEN L28 - 29R. REPAIRED IAW SRM 53-04D, FIG. 57, 51-30-5.SDR DALA13062270171Skin · dentedFUSELAGE SKIN FS 368 BETWEEM S34-36L DENTED. REPAIRED IAW ERA 508889-14.SDR R61A201311051169Skin · scratchedDURING HEAVY CHECK, FOUND RT FUSELAGE SKIN BS 301 S22-23R FOUND THREE SCRATCHES. BLENDED DAMAGE AND FOUND TO BE BEYOND ALOWABLE LIMITS. CUT OUT DAMAGE AND REPAIRED IAW RD8/4-53-2000. ACFT RETURNED TO SERVICE.SDR DALA13060526815Skin · damagedLIGHTNING STRIKE STR 29 - 30R AT BS 530. DRILLED OUT DAMAGE IAW SRM 53-00-01. INSTALLED FASTENER AND RESTORED FINISH IAW SRM 53-00-01.
Back to JASC 5330