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 CALA0400362Skin · dentedINSPECTION FOUND FUSELAGE SKIN DENTED AT BS 380 + 17 BELOW STRINGER 17L. THE DENT WAS REPAIRED USING A DOUBLER IAW SRM 53-00-01, FIGURE 208.SDR ASAA0440126Skin · dentedGYR - AFT CARGO DOOR OUTER SKIN DENTED AND GOUGED IN NUMEROUS PLACES. REPLACED THE AFT CARGO DOOR OUTER SKIN. (M)SDR DL73G040332Skin · dentedTWO DENTS WERE NOTED IN THE FUSELAGE SKIN JUST ABOVE S16L, NEAR BS 384 AND 400. DAMAGE WAS REWORKED PER ERA 089089-14.SDR DL73G040330Skin · dentedA DENT AND GOUGE WERE NOTED IN THE UPPER SKIN AT BS 807 NEAR S25R. DAMAGE WAS REMOVED AND REPAIRED IAW ERA 089247-14.SDR SWAA041043Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 500D + 6, STRINGER 16L, CRACKED. REPAIRED SKIN PER EA.SDR CALA0400359Skin · damagedINSPECTION FOUND LIGHTNING STRIKE DAMAGE TO RIVET AT STA 328, L22L. REPAIRED IAW ECRA 5331-01141.SDR USAA040118Skin · crackedCLT - FOUND SKIN CRACKED 1.5 INCH, STATION 933 STRINGER 24R. INSTALLED REPAIR DOUBLER PER SRM 53-00-01. (M)SDR DL75A040333Skin · dentedTHE FUSELAGE SKIN WAS FOUND DENTED AT FS 1645, JUST BELOW STRINGER 19R. THE DENT WAS REMOVED WITH A 3.5 X 3.2 INCH CUTOUT. THE CUTOUT WAS REPAIRED WITH TWO EXTERNAL ALUMINUM DOUBLERS PER ER/A 089688-14, REV A.SDR SWAA041035Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 940, STRINGER 21R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041034Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 500 + 2, STRINGER 12R, AND BS 500D + 18, STRINGER 12L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041033Skin · crackedDURING SCHEDULED D CHECK, FOUND 2 EACH BEAR STRAPS AT THE L1 DOOR UPPER AND LOWER HINGE CUTOUTS, CRACKED. REPAIRED BEAR STRAPS PER ER.SDR USAA040119Skin · crackedCLT - FOUND SKIN WITH TWO CRACKS .5 INCH AND 2 INCHES LONG, STATION 727E +4 AT STRINGER 22R, RIGHT FUSELAGE. INSTALLED REPAIR DOUBLER PER SRM 53-00-01. (M)SDR USAA040117Skin · crackedFOUND SKIN CRACKED 2.5 INCHES, STATION 727E AT STRINGER 18R, RT FUSELAGE. INSTALLED REPAIR DOUBLER PER SRM 53-00-01. (M)SDR AWXA200400499Skin · crackedMCN - MAJOR REPAIR, DURING C-17 CHECK A .2500 CRACK WAS FOUND AT FASTENER HOLE IN FUSELAGE SKIN AT LOWER FORWARD CORNER OF R-2 DOOR CUTOUT BS 981.8 TO BS 984.8, WL 198. MAINTENANCE STOP DRILLED CRACK AND PERFORMED A HFEC INSPECTION TO VERIFY CRACK WAS CONTAINSDR AWXA200400452Skin · bulgedMCN - MAJOR REPAIR - DURING C-17 CHECK THE SKIN WAS FOUND BULGING BETWEEN FASTENERS INSIDE THE FORWARD CARGO COMPARTMENT AT A PREVIOUSLY INSTALLED REPAIR DOUBLER BS 370 TO BS 390, RBL 36. MAINTENANCE REMOVED REPAIR DOUBLER BS 370 TO BS 390, RBL 36 AND FOUND ESDR SWAA041028Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 1016, STRINGER 7L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041025Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 440, STRINGER 16R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041030Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN BEHIND LT WING TO BODY FAIRING AT BS 767, CRACKED. REPAIRED SKIN PER SRM.SDR ABXA040148Doubler · corrodedCORROSION AT STA. 226, LONGERON 18 RIGHT ON ANGLE DOUBLER. REPLACED FITTING IAW DC-9 SRM.SDR ABXA040147Doubler · corrodedANTENNA SUPPORT CORRODED BETWEEN STA. 522 - 503, LONGERON 30 - 29 LT. REPLACED DOUBLERS AROUND THE ANTENNA IAW DC-9 SRM 51-30-2.SDR ABXA040146Doubler · corrodedANTENNA SUPPORT CORRODED BETWEEN STA. 465 - 446 LONGERON 30 - 29 LT. REPLACED DOUBLER 5911412-53 AND 5911412-55 AIW DC-9 SRM 51-30-2 AQND 51-30-5.SDR AWXA200400373Skin · crackedA 2 INCH CRACK WAS FOUND IN FUSELAGE SKIN AFT OF LEFT WING TO BODY FAIRING BS 727E, STR 23 LEFT. MAINTENANCE CUT OUT DAMAGED SKIN AT BS 727E, STR 23 LEFT; PERFORMED HFEC INSPECTION OF CUTOUT TO VERIFY NO CRACKS EXIST; FABRICATED A NEW REPLACEMENT SKIN SECTIONSDR SWAA041014Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 737, STRINGER 20R, BS 927, STRINGER 24R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041013Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 980, STRINGER 21L, CRACKED. REPAIRED SKIN PER SRM.SDR 2004UALA00322Skin · dentedEXT FUSLAGE AT STA 265 BETWEEN STR 17L AND 18L DENTED. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED AREA. FABRICATED & INSTALLED DOUBLER AND FILLER MATERIAL.SDR SROM200400051Skin · dentedDURING D CHECK INSPECTION DENT IN SKIN STA 1147.5, 8.5 INCHES ABOVE S5. A=2 INCHES Y=.056 A/Y=35.7, BUT DUE TO PROXIMITY OF CUTOUT FOR HORIZONTAL FITTING IT IS BEYOND LIMITS IAW SRM 53-30-1, FIG 1 NOTE K AND DETAIL 111. COMPLIED WITH HFEC. NO DEFECTS NOTESDR USAA040116Skin · crackedCLT - FOUND SKIN CRACKED .700 INCH, 3 INCHES AFT OF FS 727D ADJACENT OT S23R. INSTALLED DOUBLER PER SRM 53-00-01. (M)SDR DL73S040320Skin · crackedINSPECTION OF THE STRINGER 4R SKIN LAP JOINT PER AD 2003-08-15, REVEALED A TOTAL OF 9 CRACKED FASTENER HOLES AT THREE LOCATIONS IN THE JOINT. THE CRACKS WERE REMOVED WITH CUTOUTS OF 15.5 X 1 INCH AND TWO CUTOUTS OF 7.25 X 1 INCH. THE CUTOUTS WERE REPAIRED WISDR DL73S040319Skin · crackedINSPECTION OF THE STRINGER 10L LAP JOINT BETWEEN FS 360 & 540 REVEALED A CRACKED FASTENER HOLE AT FS 380. THE CRACKED HOLE WAS REMOVED WITH A 1 X 4 INCH CUTOUT AND REPAIRED WITH AN EXTERNAL ALUMINUM REPAIR DOUBLER PER BAC 737 SRM 53-30-3, FIG 42. THE REPAIR SDR DL73S040318Skin · crackedINSPECTION OF THE STRINGER 14L SKIN LAP JOINT PER AD 2003- 08-15, REVEALED A CRACKED FASTENER HOLE AT FS 500A+10 & ANOTHER AT FS 500B+15. THE CRACKS WERE REMOVED WITH SKIN CUTOUTS (1 X 4 & 1 X 7 INCH RESPECTIVELY). THE CUTOUTS WERE REPAIRED WITH ALUMINUM DOSDR SWAA041008Skin · crackedDURING THRU FLIGHT CHECK, FOUND FUSELAGE SKIN AT BS 750, STRINGER 18R, CRACKED. REPAIRED SKIN PER SRM.SDR AWXA200400358Skin · crackedPHX - MAJOR REPAIR - A 2 INCH CRACK WAS FOUND IN FUSELAGE SKIN AT BS 747, STR 25 LT. MAINTENANCE CUT OUT CRACK IN FUSELAGE SKIN AT BS 747, STR 25 LT; PERFORMED HFEC INSPECTION OF CUTOUT TO VERIFY NO CRACKS EXIST; FABRICATED A REPAIR DOUBLER & TRIPLER; INSTALLSDR AWXA200400357Skin · crackedPHX - MAJOR REPAIR - A 1.5 INCH CRACK WAS FOUND IN FUSELAGE SKIN AT BS 727E, STR 22 LT. MAINTENANCE CUT OUT CRACK IN FUSELAGE SKIN AT BS 727E, STR 22 LT; PERFORMED HFEC INSPECTION OF CUTOUT TO VERIFY NO CRACKS EXIST; FABRICATED A REPAIR DOUBLER; INSTALLED REPSDR CALA0400338Skin · crackedINSPECTION FOUND EXTERIOR FUSELAGE SKIN BULGED WITH RIVETS POPPING AROUND LOWER TCAS ANTENNA AND A 2 INCH CRACK WAS FOUND IN SKIN FORWARD OF TCAS ANTENNA AT STA 237. A REPAIR WAS INSTALLED IAW SRM 53-04, FIGURE 12C.SDR UIEA200400038Skin · dentedDURING D CHECK, SKIN DENT FOUND ON FWD CARGO DOOR CUTOUT. A SKIN GOUGE ON THE SKIN OF THE FORWARD CARGO DOOR CUTOUT AFT SKIN EDGE, BS670, BETWEEN S-37 AND S-38 WAS REPAIRED BY TRIMMING OUT THE GOUGE. A HFEC AND DETAILED VISUAL INSPECTION WITHIN 20 INCHES WASSDR USAA040112Skin · crackedFOUND SKIN CRACKED .600 INCH LONG, S-23L AT FS 744. REPAIR DOUBLER INSTALLED PER SRM 53-00-01, FIG 229. (M)SDR USAA040113Skin · crackedFOUND SKIN CRACKED 1.250 INCH LONG, 3 INCHES FORWARD OF FS 727E ADJACENT TO S-24L. INSTALLED DOUBLER PER SRM 53-00-01, FIG 229. (M)SDR USAA040107Skin · crackedFOUND SKIN CRACKED 1.250 INCH LONG, INSTALLED DOUBLER PER SRM. 53-00-01, FIG 229. INSTALLED DOUBLER PER SRM 53-00-01, FIG 229. (M)SDR GTIA040262Skin · damagedLAS - FLT 1103 - FOUND DAMAGE ON RIGHT SIDE OF A/C AT STATION 522-560 LONGERON 20 DUE TO DAMAGE. FUSELAGE EXTERNAL DOUBLER REPAIR INSTALLED AT FS 503-560, L19R-23R PER FLIGHT VEHICLES DRAWING 53-04162-1 EA 5310-0408. (M)SDR DL757040317Skin · dentedTHE FUSELAGE SKIN WAS FOUND DENTED BETWEEN STRINGERS 18L & 19L, JUST FWD OF THE FS 1618 SKIN BUTT SPLICE. THE DENTED AREA WAS REMOVED WITH A CUT OUT AND REPAIRED WITH TWO ALUMINUM REPAIR DOUBLERS. THE REPAIR WAS ACCOMPLISHED PER ER/A 089586-14, REV A.SDR DL73G040310Skin · damagedDAMAGE WAS NOTED TO THE FUSELAGE SKIN AT THE FWD EDGE OF THE C1 DOOR CUTOUT. DAMAGE WAS REMOVED AND REPAIRED PER ERA 089422-14.SDR DL73S040308Strap · damagedSCRIBE MARKS WERE NOTED IN THE BUTT JOINT AT BS 360 BETWEEN S13L AND S28R. DAMAGE WAS REMOVED AND REPAIRED PER ERA 088793-14.SDR DL73S040307Skin · damagedSCRIBE MARKS WERE NOTED IN THE LOWER SKIN OF THE S10L LAP JOINT BETWEEN BS 259.5 AND BS 303.9. DAMAGE WAS REMOVED AND REPAIRED PER ERA 088638-14.SDR DL73S040306Skin · damagedSCRIBE MARKS WERE NOTED IN THE LOWER SKIN OF THE S14L LAP JOINT BETWEEN BS 908 AND BS 960. DAMAGE WAS REMOVED AND REPAIRED PER ERA 088591-14.SDR DL73S040305Skin · damagedSCRIBE MARKS WERE NOTED IN THE LOWER SKIN OF THE S4R LAP JOINT BETWEEN BS 259.9 AND BS 360. DAMAGE WAS REMOVED AND REPAIRED PER ERA 089005-14.SDR DL73S040304Skin · damagedSCRIBE MARKS WERE NOTED IN THE LOWER SKIN OF THE S14R LAP JOINT BETWEEN BS 908 AND BS 960. DAMAGE WAS REMOVED AND REPAIRED PER ERA 088728-14.SDR DL73S040303Skin · damagedSCRIBE MARKS WERE NOTED AT S14L BETWEEN BS 259.5 AND 303.9. DAMAGE WAS REMOVED AND REPAIRED PER ERA 089014-14.SDR SWAA040995Skin · corrodedDURING SCHEDULED D CHECK, FOUND AFT CARGO COMPARTMENT SKIN AT BS 727 + 14, LBL 9, STRINGER 27L, CORRODED. REPAIRED SKIN PER ER.SDR SWAA040993Skin · crackedFOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 727 + 5, BS 767 + 6, STRINGER 20L. REPAIRED SKIN PER SRM.SDR SWAA040992Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN AT BS 440, STRINGER 13L, CRACKED. REPAIRED SKIN PER SRM.
Back to JASC 5330