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 DALA14028243714Skin · damagedDURING INSPECTION FOUND LOWER FUSELAGE SKIN DAMAGE BS 500E-500F BETWEEN S26-28R. MAINTENANCE REPAIRED IAW ERA 525412-14.SDR A6WA201441503Skin · crackedNLG CUT OUT LT & RT AFT RADIUS CRACKS AT FS 235. REPAIRED NLG CUT OUT AFT RADIUS SURROUND SKIN ON LT & RT SIDES IAW REO 601R-53-121-048 REV C DATED 2008-10-01.SDR DALA2016111008683Doubler · corrodedRADIO ALTIMETER ANTENNA DOUBLER CORRODED, NEW DOUBLER FABRICATED AND INSTALLED.SDR FDEA201404250845Skin · gougedFUSELAGE SKIN THERE ARE SCRATCHES AT BS 871 - 880, STRINGER 10L. REPAIRED IAW EA F-5330-T0307573 PART 1. REPAIR CLASSIFIED AS MINOR.SDR FDEA201404250844Skin · gougedFUSELAGE SKIN SCRATCHEED AT BS 832 - 844, STRINGER 10L AREA. REPAIRED IAW EA F-5330-T0307573 PART 1. REPAIR CLASSIFIED AS MINOR.SDR SWAA2014050727769Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 500+3.5- TO BS 500+4.5, STRINGER 16R. REPAIRED SKIN IAW SRM.SDR SWAA2014050527686Skin · crackedFUSELAGE SKIN CRACKED AT BS 950, STRINGER 11L. REPAIRED SKIN IAW SRM.SDR SWAA2014050527685Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 931 TO BS 932, STRINGER 4R. REPAIRED SKIN IAW SRM.SDR SWAA2014050527684Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 951 TO BS 953, STRINGER 4R. REPAIRED SKIN IAW SRM.SDR SWAA2014042827501Skin · damagedCENTER WING SECTION UPPER SKIN SHEAR FITTING DAMAGED AT BS 540, LBL 6.14, ADJACENT TO SECOND FROM AFT FASTENER HOLE IN UPPER SKIN. REPAIRED SKIN IAW EA.SDR AALA20140426010Skin · corrodedAFT LOWER FUSELAGE HAS CORROSION AT STATION 1219 & STRINGERS 36 LT. INSTALLED DOUBLER REPAIR IAW SRM 53-00-01-2R REPAIR 1.SDR DALA14026410609Skin · damagedFUSELAGE SKIN BS 884, S14R LAP JOINT UPPER ROW, HAS A SHEARED RIVET. REPAIRED IAW ERA 514437-14, REV A.SDR DALA14026273153Skin · damagedDURING MAJOR CHECK, ONE DENT AND ONE GOUGE HAVE BEEN NOTED ON EXTERNAL SKIN FRAME 75+9' STRINGER 33L. DAMAGE REMOVED AND REPAIR ACCOMPLISHED IAW ERA 524819-14 SECT. I. ERA 524819-14 SECT.I.SDR DALA2015102806559Skin · damagedFASTENER AT BS 1051 AND S6L HAD A LIGHTNING STRIKE.SDR DALA2015102806558Skin · damagedACFT SKIN HAD LIGHTNING STRIKE DAMAGE AT BS 1030 TWO INCHES UP FROM S6L.SDR DALA1501443240Skin · damagedFUSELAGE SKIN HAS BIRD STRIKE DAMAGE. REPLACED THE SKIN IAW ERA 525216-14.SDR SWIA201437570Skin · puncturedFUSELAGE IS CRACKED FORWARD OF AFT EQUIPMENT BAY. CLASSIFIED AS A PUNCTURE, REMOVED DAMAGE IN FUSELAGE FORWARD OF AFT EQUIPMENT BAY IAW SRM.SDR SWAA2014050527662Skin Splice · crackedRIGHT WING TO BODY FAIRING SUPPORT LOWER STRUCTURE SKIN SPLICE CRACKED AT BS 680 WW AREA. R & R SPLICE IAW SRM & DWG.SDR FDEA201404240838Skin · dentedLOWER FUSELAGE SKIN HAS A DENT AT BS 1478 BETWEEN STRINGERS 27 & 28L. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-01 FIG 101. CUT OUT DAMAGE, FABRICATED REPAIR DOUBLER AND INSTALLED IAW SRM 53-00-01 REPAIR 16.SDR DALA14027346904Skin · damagedFASTENER AT BS 977, S6L LIGHTNING BURNED. REMOVED FASTENER CLEANED AREA INSPECTED WITH 10X MAGNIFICATION. REMOVED, TREATED, PAINTED AND INSTALLED BLIND RIVET IAW SRM 53-00-01, FIG 201.SDR SWAA2014043027559Skin · crackedFUSELAGE SKIN CRACKED AT BS 907+4, STRINGER 22R. REPAIRED SKIN IAW SRM.SDR CALA2014042590901Skin · damagedEXTERIOR UPPER FUSELAGE STATION 700, BETWEEN STRINGER 3L & 4L HAS A DEEP BLENDED OUT AREA. CUT OUT DAMAGED SKIN, HFEC CUT SKIN & SURROUNDING HOLES. INSTALLED REPAIR DOUBLERS & FILLER.SDR CALA2014042590896Skin · corrodedFORWARD PIT FWD FRAME 34 BETWEEN STRINGERS 42R & 41R HAS CORROSION AROUND FASTENERS ON INNER SURFACE OF SKIN. REMOVED .011 OF .091 SKIN IAW SRM 53-21-11 FIG 114 SHEET 1 P149. REMOVED LESS THAN 25% & FOUND TO BE IN LIMIT.SDR CALA2014042590895Skin · corrodedFORWARD PIT FWD FRAME 34 BETWEEN STRINGERS 42L & 40L, CORROSION AROUND FASTENERS ON INNER SURFACE OF SKIN. REMOVED .012 OF.071 SKIN IAW SRM 53-21-11 FIG 114 SHEET 1 P149, REMOVED LESS THAN 25% & FOUND TO BE IN LIMIT.SDR CALA2014042590894Skin · corrodedFORWARD PIT FWD FRAME 34 BETWEEN STRINGER 43R & 42R HAS CORROSION AROUND FASTENERS ON INNER SURFACE OF SKIN. REMOVED .014 OF.071 SKIN IAW SRM 53-21-11 FIG 114 SHEET 1 P149. REMOVED LESS THAN 25% & FOUND TO BE IN LIMIT.SDR WX0A071927Skin · dentedUPPER FUSELAGE EXTERNAL SKIN SCRATCHED & DENTED OUT OF LIMITS STATION 1401, LONGERON 4R AREA. CUT OUT SKIN, FABRICATED FILLER & DOUBLER, LOCATED, DRILLED & INSTALLED IAW SRM 53-01 FIGURE 4 SHEET 4. WORK ACCOMPLISHED ON WO 218787 M301 ITEM 441 & WO 1010750-22SDR DALA14026066904Skin · damagedFASTENER AT BS 1004, STRINGER 6L HAS A LIGHTNING BURN. REMOVED FASTENER CLEANED AREA INSPECTED WITH 10X. DAMAGE REMOVED TREATED & PAINTED, INSTALLED BLIND RIVET IAW SRM 53-00-01, FIG 201.SDR DALA14026056904Skin · damagedFASTENER AT BS 1130, STRINGER 7L HAS A LIGHTNING STRIKE, REMOVED FASTENER, CLEANED AREA INSPECTED WITH 10X. DAMAGE REMOVED, TREATED & PAINTED, INSTALLED BLIND RIVET IAW SRM 53-00-01 FIG 201.SDR DALA14026046904Skin · damagedACFT SKIN AT BS 1086, SIX INCHES DOWN FROM STRINGER 6L HAS LIGHTNING STRIKE DAMAGE. DRILLED OUT DAMAGE INSPECTED WITH 10X. TREATED PAINTED INSTALLED BLIND RIVET IAW SRM 53-00-01, FIG 201.SDR DALA14026036904Skin · damagedACFT SKIN AT BS 1160, FOUR INCHES DOWN STRINGER 7L LIGHTNING STRIKE DAMAGE, REMOVED FASTENER, CLEANED AREA INSPECTED WITH 10X. DAMAGE REMOVED, TREATED & PAINTED, INSTALLED BLIND RIVET IAW SRM 53-00-01, FIG 201.SDR DALA14026026904Skin · damagedACFT SKIN AT BS 1337, TWO INCHES DOWN FROM STRINGER 6L, LIGHTNING STRIKE DAMAGE DRILLED OUT DAMAGE INSPECTED WITH 10X. TREATED, PAINTED INSTALLED BLIND RIVET IAW SRM 53-00-01, FIG 201.SDR DALA14026016904Skin · damagedFASTENER AT BS 1705 AND S8L BURNED. R & R BLIND FASTENER IAW SRM 53-00-01, SECTION 2, PARA 4.SDR DALA14026006904Skin · damagedFASTENER AT BS 525, S11L, LIGHTNING STRIKE, R & R FASTENER WITH A BLIND FASTENER IAW 757-200, SRM 53-00-01, SECTION 2, PARA 4.SDR DALA14025996904Skin · damagedFASTENER AT BS 952 S6L, LIGHTNING DAMAGE. REMOVED FASTENER, CLEANED AREA, INSPECTED WITH 10X. DAMAGE REMOVED, TREATED & PAINTED. INSTALLED BLIND FASTENER IAW SRM 53-00-01, FIG 201.SDR DALA14025986904Skin · damagedFASTENER AT BS 886 AND S56L IS BURNED. REMOVED FASTENER, CLEANED AREA, INSPECTED, WITH 10X DAMAGE REMOVED, TREATED & PAINTED, INSTALLED BLIND FASTENER IAW SRM 53-00-01, FIG 201.SDR DALA14025976904Skin · damagedFASTENER AT BS 500 S11L BURNED. R & R WITH BLIND FASTENER IAW SRM 53-00-01, SECTION 2, PARA 4.SDR ASOA2014052210559Skin · chafedCHAFE DAMAGE FROM THE AFT FAIRING SPLICE STRIP AT BS 935+2 & STRINGER 27 ON THE BELLY. DAMAGE IS GREATER THAN ALLOWABLE LIMITS OF SRM 53-00-01-101-001-A01. COMPLIED WITH REO 670-53-72-411 & GREO 670-53-00-240. MAJOR REPAIR.SDR ASOA2014052110524Skin · gougedREPAIR DOUBLER HAS SCREW DAMAGE BETWEEN FS 969-985, STR 27. RECEIVED REO 670-53-00-410 P1. COMPLIED WITH REO 670-53-00-410 P1.SDR SWAA2014052128221Post · crackedLEFT NR 3 EF WINDOW POST 2ND FROM BOTTOM CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014052128220Post · crackedRIGHT NR 3 EF WINDOW POST 2ND FROM BOTTOM CRACKED. REPAIRED POST IAW ACO.SDR DXTA2014050205753Skin · corrodedFUSELAGE LOWER SKIN & STRINGER CORROSION. REPAIRED IAW S-560XL-5365 04RD.SDR DXTA2014050205754Skin · corrodedFUSELAGE SKIN UNDER DORSAL LE FAIRING CORRODED. REPAIRED IAW S-750-020113RD.SDR DALA14026166904Skin · damagedACFT SKIN AT BS 1374, FOUR INCHES DOWN FROM STRINGER 6L HAS LIGHTNING DAMAGE. DRILLED OUT DAMAGE AND INSPECTED WITH 10X MAGNIFICATION. TREATED, PAINTED, INSTALLED BLIND RIVET IAW SRM 53-00-01, FIG 201.SDR DALA14026156904Skin · damagedACFT SKIN AT BS 1516, JUST BELOW STRINGER 7L HAS A LIGHTNING STRIKE. DRILLED OUT DAMAGE AND INSPECTED WITH 10X MAGNIFICATION, TREATED, PAINTED AND INSTALLED BLIND RIVET IAW 53-00-01, FIG 201.SDR DALA14026146904Skin · damagedACFT SKIN AT BS 1550 ABOUT FIVE INCHES DOWN FROM STRINGER 7L HAS A LIGHTNING STRIKE. DRILL OUT DAMAGE AREA .159 IAW SRM 53-00-01, FIG 201, SECTION I. PERFORMED HFEC IAW NDT 51-00-16, NO DEFECTS FOUND. TREATED, PAINTED AND INSTALLED BLIND RIVET IAW SRM 53-00SDR DALA14026136904Skin · damagedACFT SKIN AT BS 1585, THREE INCHES DOWN FROM STRINGER 7L HAS A LIGHTENING STRIKE. DRILLED OUT DAMAGE AREA .159 IAW SRM 53-00-01, FIG 201, SECTION I, PERFORMED BHEC IAW NDT 51-00-16. NO DEFECTS FOUND. TREATED, PAINTED AND INSTALLED BLIND RIVET IAW SRM 53-00SDR DALA14026126904Skin · damagedSTATIC DISCHARGE ON SKIN AT BS 1195 AND 2.5 INCHES ABOVE STRINGER 9L. DRILLED OUT DAMAGE AND INSPECTED WITH 10X MAGNIFICATION. TREATED, PAINTED AND INSTALLED BLIND RIVET IAW SRM 53-00-01, FIG 201.SDR DALA14026116904Skin · damagedSTATIC DISCHARGE ON SKIN AT BS 1225, THREE INCHES BELOW STRINGER 9L. DRILLED OUT DAMAGE INSPECTED WITH 10X MAGINIFCATION. TREATED, PAINTED AND INSTALLED BLIND RIVET IAW SRM 53-00-01, FIG 201.SDR DALA14026106904Skin · damagedSTATIC DISCHARGE ON SKIN AT BS 1233, FIVE INCHES BELOW STRINGER 9L. DRILLED OUT DAMAGE, INSPECTED WITH 10X MAGNIFICATION. TREATED, PAINTED AND INSTALLED BLIND RIVET IAW SRM 53-00-01, FIG 201.SDR DALA14026096904Skin · damagedSTATIC DISCHARGE ON FASTENER AT BS 1259 AND FIVE INCHES BELOW STRINGER 9L DRILLED OUT DAMAGE, INSPECTED WITH 10X MAGNIFICATION. TREATED, PAINTED AND INSTALLED BLIND RIVET IAW SRM 53-00-01, FIG 201.
Back to JASC 5330