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 SWAA2013100720888Skin · crackedRT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 4 & HFEC CRACK INDICATION AT HOLE 3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720887Skin · crackedRT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW TC & EA.SDR SWAA2013100720886Skin · crackedRT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT INDICATION AT HOLE 3. REPAIRED SKIN IAW SB & TC.SDR SWAA2013100720885Skin · crackedRT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2013100720884Skin · crackedRT BS 887+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2013100720883Skin · crackedRT BS 867+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2013100720882Skin · crackedLT BS 500C+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,5,6,8. REPAIRED SKIN IAW EA.SDR SWAA2013100720881Skin · crackedLT BS 500A+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 4-8. REPAIRED SKIN IAW TC & EA.SDR SWAA2013100720880Skin · crackedLT BS 480+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 4 - 88. REPAIRED SKIN IAW TC & EA.SDR SWAA2013100720879Skin · crackedLT BS 460+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 4,5,8. REPAIRED SKIN IAW TC & EA.SDR AALA20130920003Skin · corrodedCORROSION ON SKIN UNDER RUB STRIP FOR FILLET PANEL FROM BS 750 TO 769 RT. INSTALLED DOUBLER REPAIR IAW SRM 53-04-00 FIGURE 57.SDR REXA2013092001882Doubler · corrodedANTENNA DOUBLER HAS CORROSION BETWEEN FRAMES 310 AND 295, AT AC BELLY, IN THE FWD E & E BAY IAW SRM 51-42-06, 51-42-21. REPLACED DOUBLER AT FS 310-295 BETWEEN STR 26R & 26L.SDR SWAA2013092620508Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 384.5 TO BS 388.5 STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2013092620507Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 500B+6" TO BS 500B+7" STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2013092620506Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 503.5 TO BS 504.5 STRINGER 16R. REPAIRED SKIN IAW EA.SDR USAA2013092300022Skin · crackedC3 CHECK, FOUND CRACK ON FUSELAGE SKIN AT BS 951, WL 251.77. REPAIRED SKIN IAW SRM 53-60-01-2R-5, FIG 201.SDR DALA13046410979Skin · crackedCROWN SKIN CRACKED AT BS 1418, S1 & 2R, CUT OUT DAMMAGE AREA. PREFORMED HFEC IAW NDT SPM 06-10-01 . NO CRACKS FOUND. SKIN CRACK AND GOUGE IN SKIN CONTAINED & REPAIR ACCOMPLISHED ON ER/A 518899-14, REV O.SDR SWAA2013121723445Skin · corrodedFWD CARGO PIT FUSELAGE SKIN CORRODED. REPAIRED SKIN IAW EA.SDR CALA2013092091310Doubler · crackedR5 DOOR FWD CUTOUT REVEALED DOUBLER CRACKED. CUTOUT DAMAGED SKIN, ACCOMPLISHED HFEC NO DEFECT NOTED. FABRICATED & INSTALLED REPAIRED DOUBLER IAW SRM53-60-15 REPAIR 3.SDR CALA2013092091309Doubler · crackedL5 DOOR FWD CUTOUT DOUBLER CRACKED. CUTOUT DAMAGED SKIN, ACCOMPLISHED HFEC, NO DEFECT NOTED. FABRICATED & INSTALLED REPAIRED DOUBLER IAW SRM 53-60-15 REPAIR 3.SDR SWAA2013100921013Skin · corrodedSKIN CORRODED AT BS 974 UNDER THRESHOLD PLATE. REPAIRED SKIN IAW SRM A& EA.SDR SWAA2013100921011Skin · corrodedC2 DOOR CUTOUT AT BS 974 SKIN CORRODED UNDER THRESHOLD PLATE. REPAIRED DOUBLER IAW EA.SDR SWIA201334803Skin · chafedCHAFFING ON FS BELLY AT FS 970, MARKED. C-CHECK COMPLIED WITH REO.SDR SWAA2013100720929Skin · crackedLT NLG STRUT DOOR AFT HINGE CUTOUT CRACKED. REPAIRED DOUBLER IAW SRM.SDR SWAA2013100720928Skin · crackedRT NLG STRUT DOOR AFT HINGE CUTOUT CRACKED. REPAIRED DOUBLER IAW SRM.SDR AALA20130930018Skin · damagedDAMAGE TO FS SKIN FROM BS 900 TO 927 & STRINGERS 22R TO 24 RT. INSTALLED REINFORCING REPAIR DOUBLER WITH STRUCTURAL FILLER.SDR DALA13046900971Skin · dentedDENT NOTED 38 INCHES AFT OF THE FWD ENTRY DOOR AT FLOOR LEVEL. REPAIRED IAW ER/A 518965-14, SECT 2.SDR ASOA20130923375Skin · crackedFUSELAGE SKIN BETWEEN THE CAPT WINDOW CUTOUT FRAME FWD TOP CORNER AND CAPT LT WINDSHIELD CUTOUT FRAME TOP OTBD CORNER CRACKED. CUT OUT DAMAGED AREA FABRICATED AND INSTALLED 2 SHIMS AND A DOUBLER IAW ETD2013-145-041246. ACFT RELEASED TO SERVICE.SDR QMLA2013091913135Skin · crackedDURING A 100 HOUR INSPECTION, A CRACK WAS FOUND IN THE SKIN ADJACENT OF THE RT CANOPY WEB. THE SKIN CRACK HAS APPROXIMATELY 30MM VISIBLE LENGTH PARALLEL TO INBD EDGE OF THE RT CANOPY WEB. IT TURNS OTBD ALONG THE TOP RADIUS OF THE CANOPY WEB. IT IS POSSIBLE THSDR DALA13045980979Skin · crackedCROWN SKIN CRACKED IN TWO AREAS AT BS 1439 BETWEEN S2-3L, CUT OUT DAMAGED AREAS. DAMAGE CONTAINED. HFEC IAW NDTSPM 06-10-01. 001, NO FINDINGS. REPAIRED IAW ER/A 518875-14, REV ORIG.SDR DALA13045970979Skin · crackedFUSELAGE SKIN CRACKED TWO AREAS AT BS 1380 + 10" ABOVE LT PYLON. CUT OUT CRACKS. HFEC IAW NDTSPM 06-10-01.001. NO FINDINGS COMPLIED WITH PRI ER/A 518877-14 REV O.SDR ASOA20130919373Skin · dentedDURING C-CHECK INSPECTION, FOUND EXTERIOR SKIN BETWEEN FRAMES 19 AND 20, STR 11-12L CREASED. MX CUTOUT AND REMOVED THE CREASED AREA. FABRICATED A NEW PART IAW EC 5320-01842 AND INSTALL NEW PART.SDR SWAA2013101421131Skin · dentedFUSELAGE SKIN DENTED AT LOWER LOBE BETWEEN STATION 796 TO STATION 807, BETWEEN STRINGER 25R TO 27R. REPAIRED SKIN IAW EA.SDR SWAA2013101421186Post · crackedNR 3 LT FLIGHT DECK WINDOW POST CRACKED SECOND LOWER FASTENER HOLE. REPAIRED POST IAW SWA EA.SDR SWAA2013100921004Skin · crackedSKIN CRACKED AT BS 400 + 4" TO 7.25" STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2013100921003Skin · crackedSKIN CRACKED AT BS 500B + 15" TO 17" STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2013100820966Skin · crackedSKIN CRACKED AT BS 847 + 5.25" TO 6.125, STRINGER 15R. REPAIRED SKIN IAW EA.SDR ASOA2013100809173Skin · dentedFUSELAGE SKIN AT FWD LOWER CORNER OF PAX DOOR SURROUND IS DENTED APPROX 1 L X .50 W X .30 D. CUT AWAY DAMAGED SKIN AT PAX DOOR CUTOUT OF FWD LWR CORNER IAW SRM 53-21-31, REPAIR NR 1, STEP 5, A1. COMPLIED WITH EC/TC SRM 53-21-31-01. FABRICATED DOUBLER AND FISDR SWAA2013100720860Skin · crackedSKIN CRACKED AT BS 847 + 2.5" TO 5.75, STRINGER 15R, R & R DOUBLER IAW EA.SDR SWAA2013100320754Bear Strap · crackedFWD ENTRY DOOR UPPER FWD CORNER SKIN CUTOUT CRACKED IN THE BEAR STRAP. REPAIRED SKIN IAW ATS ER & EA.SDR SWAA2013092420468Skin · crackedSKIN CRACKED AT BS 540 STRINGER 22R. REPAIRED SKIN IAW EA.SDR SWAA2013092420465Window Post · crackedLT COCKPIT NR 1 WINDOW POST CRACKED. REPAIRED POST IAW SWA EA.SDR KC8A20130918005Skin · corrodedEDDY CURRENT INSPECTION OF SPOT WELDED FUSELAGE SKIN FOUND CORROSION AT RT SIDE FUSELAGE FRAME 6-7, STRINGER 21-22R.SDR KC8A20130918004Skin · corrodedEDDY CURRENT INSPECTION OF SPOT WELDED FUSELAGE SKIN FOUND CORROSION AT RT SIDE FUSELAGE FRAMES 29-33, STRINGER 18R-22R.SDR KC8A20130918002Skin · corrodedEDDY CURRENT INSPECTION OF SPOT WELDED FUSELAGE SKIN. FOUND CORROSION AT FRAME 17-19, STRINGERS 5L-19L.SDR KC8A20130918001Skin · corrodedEDDY CURRENT INSPECTION OF SPOT WELDED ON FUSELAGE SKIN FOUND CORRODED AT FRAME 29-33, STRINGER 18L-22L.SDR DALA13057730955Skin · crackedCRACKS FOUND ON FUSELAGE SKIN BS 1418 BETWEEN LONGERONS 2-3L. REPAIRED IAW ER/A 519129-14AD REV. ORIG.SDR SWAA2013100921002Skin · crackedSKIN CRACKED AT BS 500D + 16" TO 18" STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2013100921001Skin · crackedSKIN CRACKED AT BS 500D + 14" TO 17" STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWIA201334806Skin · chafedCHAFE ON BELLY SKIN AT APPROXIMATELY FS 977, STRINGER 27. C-CHECK COMPLIED WITH REO.
Back to JASC 5330