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 CALA2014030390522Skin · damagedHORIZONTAL OUTWARD CREASE AT BS 1724 BETWEEN STRINGER 17R TO STRINGER 19R FUSE EXTERIOR SKIN. REMOVED DAMAGED SKIN, FABRICATED & INSTALLED A REPAIR DOUBLER BETWEEN BS 1664 - 1680 & BETWEEN STRINGER 17R - STRINGER 20R IAW REO G17222, REV IR & SRM 53-00-01, REPSDR CALA2014030390521Skin · damagedOUTWARD CREASE BETWEEN BS 1693 TO 1700 BETWEEN STRINGER 18L & STRINGER 19L. REMOVED DAMAGED SKIN, FABRICATED & INSTALLED A REPAIR DOUBLER BETWEEN BS 1665 - 1680 & BETWEEN STRINGER 18L - STRINGER 20L IAW REO G17222, REV IR & SRM 53-00-01, REPAIR 14 & ECRA 5380SDR RU3A20140228008Skin · corrodedSEVERE CORROSION ON LOWER FUSELAGE SKIN & ANTENNA DOUBLER AT APPROXIMATELY STATION 265.75.SDR DALA14014309211Skin · corrodedFUSELAGE EXTERIOR SKIN BETWEEN FS 826-845, LONGERON 28-29R HAS CORROSION UNDER RUBSTRIP. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED DOUBLER AND FILLER IAW ERA 520314-14, REV O.SDR CALA2014030300256Skin · dentedDENT AT FUSELAGE EXTERIOR SKIN BS 622 & BETWEEN STRINGER 17 - 18L. INTERIM REPAIR IAW ECRA 5331-01823.SDR CALA2014030300253Skin · dentedDENT IN FUSELAGE AFT OF R4 DOOR MEASURED DENT ON STATION 1705 & BETWEEN STRINGER 15R & 16R AS DEPTH 0.095 INCHES, WIDTH 2.0 INCHES & LENGTH 2.5 INCHES WPB CC41665 IAW SRM 53-00-01 ALLOWABLE DAMAGE 1 NOTE I A/Y RATIO LESS THAN 30.SDR CALA2014022800244Skin · dentedFWD CARGO DOOR CUTOUT LOWER SKIN APPROXIMATELY 6 INCHES FROM FWD EDGE IS DENTED. REPAIRED FWD CARGO DOOR CUTOUT LOWER SKIN IAW ECRA 5331-01821 & SRM 53-00-01 REPAIR 21 FIG 2 04 DETAIL III.SDR SWAA2014080130500Skin · crackedFUSELAGE SKIN CRACKED AT BS 540 STRINGER 22L. REPAIRED SKIN IAW EA.SDR SWAA2014040726875Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 365.5 TO BS 368.5, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014032726552Skin · crackedSKIN CRACKED AT BS 330, STRINGER 8R. REPAIRED SKIN IAW EA.SDR SWAA2014032726551Skin · crackedSKIN CRACKED AT BS 291.5+6, STRINGER 7R+2. REPAIRED SKIN IAW EA.SDR SWIA201436838Skin · gougedFUSELAGE SKIN GOUGED UNDER BLANKING PLATE. C-CHECK, REPAIRED SKIN IAW ETD.SDR SWAA2014032426446Skin · crackedRIGHT BS 767+10 UPPER AFT WINDOW SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014032126302Skin · crackedFUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUT OUT BETWEEN STATION 945 & STATION 956, STRINGER 7R. REPAIRED SKIN IAW SRM.SDR SWAA2014031826177Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 727A+13 TO BS 727A+16, STRINGER 5L. REPAIRED SKIN IAW ER & EA.SDR SWAA2014031826174Skin · crackedLT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014031726072Skin · crackedRT BS 787+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014031726146Skin · crackedRT BS 847+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB & TASK CARD.SDR SWAA2014031726145Skin · crackedRT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB & TC.SDR SWAA2014031726144Skin · crackedRT BS 787+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW TASK CARD.SDR SWAA2014031426040Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 817, LOWER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2014031426039Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 787, UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2014031426038Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 787, LOWER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2014031426037Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 817, UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2014031426036Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 787, UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2014031326020Skin · crackedFUSELAGE SKIN CRACKED AT STATION 540, BETWEEN STRINGER 22R & STRINGER 23R. REPAIRED SKIN IAW SWA EA.SDR SWAA2014031326011Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 827+10, LOWER FWD CORNER OF WINDOW CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014031326010Skin · crackedLT FUSELAGE SKIN CRACKED AT STATION 887+10, UPPER AFT CORNER OF WINDOW CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014031125958Forging · crackedLT BS 727A+10 WINDOW FORGING UPPER AFT CORNER CUTOUT CRACKED. R & R FORGING IAW DRAWING.SDR SWAA2014031125957Skin · crackedLT BS 887+10 LOWER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014031125956Skin · crackedLT BS 867+10 LOWER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR DALA14015650961Skin · corrodedNON ROUTINE CHECK, CORROSION FOUND ON PREVIOUS REPAIR ON MID CARGO BAY LOWER DOOR FRAME BEAM BETWEEN BS 648-662. REPAIR REMOVED IAW SRM 51-30-5, NEW SPACER REPAIR WAS FABRICATED IAW SRM 53-05, FIG 123, TREATED AND PAINTED IAW SRM 51-10-3, PAR 21 AND 14, FSDR SWAA2014030625821Skin · crackedFUSELAGE SKIN CRACKED AT BS 482B+17, STRINGER 16L. REPAIRED SKIN IAW SRM.SDR DALA14014365649Skin · dentedFUSELAGE SKIN DENTED AT BS 1648, S28L. CUT OUT DAMAGE IAW FIG 201, REPAIR 2. HFEC INSPECTED CUTOUT IAW NDTM PART 6, 51-00-19. NO CRACKS NOTED. INSTALLED DOUBLER AND FILLER IAW SRM 51-40-02, PAR 4.SDR DALA14013535649Skin · dentedFUSELAGE SKIN DENTED BS 1648 NEAR S28L. CUT OUT DAMAGE IAW 53-00-01, FIG 201, REPAIR 2. HFEC INSPECTED CUTOUT IAW NDTM PART 6, 51-00-19. NO CRACKS NOTED. LOCATED AND DRILLED DOUBLER AND FILLER IAW SRM 51-40-05. INSTALLED DOUBLER AND FILLER IAW SRM 51-40-SDR DALA14013889218Skin · crackedDURING LIGHTNING STRIKE INSPECTION, FOUND A 4.75 INCH LONG CRACK AT FRAME, BS 1379 AND SEVERAL SMALL CRACKS AT RIVETS ON LONGERONS 10 - 11R, JUST AFT OF BS 1379. REPAIRS COMPLIED WITH ON NON-ROUTINE CARDS.SDR DALA14013589004Skin · dentedFUSELAGE DENT AT BS 583, L21R. FOUND TO BE OUT OF LIMITS, CUT DAMAGE AREA, FABRICATED DOUBLER REPAIR & FINGER DOUBLER. TREATED, PRIMED, TOP COATED & INSTALLED REPAIR PARTS IAW SRM 53-04-01 PARA 7, 53-34-0 FIG 2, 53-04-2, FIG 2, 53-10-02, 51-10-3, 51-10-08 & SDR SIMA20140227002Skin · corrodedFUSELAGE SKIN IS CORRODED BELOW FLOOR BETWEEN FRAMES 13 - 14, STRINGER 19L - 18R. R & R FUSELAGE SKIN IAW ERS-EM-53MR-270.SDR DALA1401155649Skin · canningMAINTENANCE REPORTED EVIDENCE OF OIL CANNING DAMAGE BS 630-640, S16-17L. REPAIR IAW EA 522818-14.SDR ASOA2014032710194Doubler · corrodedANTENNA DOUBLER CORRODED AT STRINGER 27, BETWEEN BS 295-310. REMOVED CORRODED DOUBLER IAW SRM 51-42-06-001-001-A01. LOCATED, DRILLED AND DEBURED HOLES IN NEW DOUBLER IAW SRM 51-40-11-001-001-A01. INSTALLED DOUBLER IAW DWG SH 670-32-364, SRM 51-40-11-001-001SDR SWAA2014031726070Window Post · crackedLT COCKPIT NR 3 E - F WINDOW POST CRACKED AT 2ND FASTENER FROM BOTTOM. REPAIRED POST IAW ER & EA.SDR SWAA2014031726069Window Post · crackedRT NR 3 E - F WINDOW POST CRACKED AT 2ND FASTENER HOLE FROM BOTTOM. REPAIRED POST IAW ACO.SDR UHLA2014022600221Doubler · corrodedWASTE SERVICE BOX SKIN DOUBLER BY FWD INBD DOOR CUTOUT HOLE AT FRAME 88 CORRODED. R & R WASTE BOX SJIN DOUBLER, ON 170-66931-001.SDR UHLA2014022600190Skin · damagedLOWER FUSELAGE SKIN ABOVE RAM INLET DUCTS WORN. SMOOTHED DAMAGE AND INSTALLED DOUBLER IAW ETD2014-170-018449.SDR SWAA2014030525762Skin · crackedFUSELAGE SKIN CRACKED AT BS 482B+6, STRINGER 16L. REPAIRED SKIN IAW ER & EA.SDR AALA20140226003Skin · corrodedCORROSION FOUND IN SKIN BELOW AFT LAVATORY SERVICE DOOR CUT OUT. CUT OUT CORROSION & INSTALLED EXTERNAL DOUBLER IAW EA MD80-53-033796.SDR WVER2014022691006Skin · damagedBS 913 STRINGER 27 HAS TOOL DAMAGE IN FUSELAGE SKIN. REPAIRED DAMAGED AREA IAW REO 670-53-00-290, REV C AND MODSUM IS670508200021, REV C.SDR SWAA2014033126699Post · crackedFLIGHT DECK WINDOW POST CD RT, CRACKED 1 INCH LONG AT THE UPPER CORNER. REPAIRED POST IAW ACO.SDR EE4Y2014032700053Skin · dentedLOWER FUSELAGE AT BS 319 BETWEEN STRINGER 27 LT & 28 LT SKIN WITH DENT. THE DENT WAS REPAIRED IAW COO-AMX-14-0005-04B.SDR IPXA2014031482235Skin · gougedINSPECTION 2C, REPAIR AT LOWER AFT CORNER OF LOWER FWD CARGO DOOR CUT-OUT GOUGED ALONG EDGE. REPAIRED DOUBLER/TRIPLER EDGE BS 1002, L40R, L42R IAW EA 011- 5330-01-A5140, REV IR AND EO MD11-5330-53734-A.
Back to JASC 5330