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 SWAA2013100120621Skin · crackedLT BS 440+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,5,7,8. REPAIRED SKIN IAW SWA EA.SDR SWAA2013100120620Skin · crackedLT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,4,5. REPAIR SKIN IAW EA.SDR SWAA2013100120619Skin · crackedRT BS 727+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 5,7. REPAIRED SKIN IAW SWA EA.SDR SWAA2013100120618Skin · crackedRT BS 500C+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,6,7. REPAIRED SKIN IAW SWA EA.SDR SWAA2013100120617Skin · crackedRT BS 500B+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1,3,4,5,6,7,8. REPAIRED SKIN IAW SWA EA.SDR SWAA2013092520470Skin · crackedRT BS 460+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,4,5,6,8. REPAIRED SKIN IAW EA.SDR SWAA2013092520469Skin · crackedRT BS 400+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,4,6,12. REPAIRED SKIN IAW EA.SDR SWAA2013092520489Skin · crackedLT BS 460+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 1,2,3,4,5,6,8,9,10,11,12. REPAIRED SKIN IAW EA.SDR SWAA2013092520476Skin · crackedRT BS 520+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,6,7,8. REPAIRED SKIN IAW EA.SDR SWAA2013092520475Skin · crackedRT BS 480+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2 - 8. REPAIRED SKIN IAW EA.SDR SWAA2013092420457Skin · crackedLT BS 460+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 5,6,7,8,10. REPAIRED SKIN IAW EA.SDR SWAA2013092320401Skin · crackedLT BS 520+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2 - 12. REPAIRED SKIN IAW EA.SDR SWAA2013092320400Skin · crackedLT BS 500+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 1,3,4,5,6,7,8,10,12. REPAIRED SKIN IAW EA.SDR SWAA2013092420398Skin · crackedLT BS 727C+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 5. REPAIRED SKIN IAW EA.SDR SWAA2013092420397Skin · crackedLT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1,2,9,10,11,12. REPAIRED SKIN IAW EA.SDR SWAA2013092420396Skin · crackedRT BS 827+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013092420395Skin · crackedRT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,4,5. REPAIRED SKIN IAW EA.SDR SWAA2013092420394Skin · crackedLT BS 520+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,5,6,7,8. REPAIRED SKIN IAW EA.SDR SWAA2013092420402Skin · crackedLT BS 400+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 4. REPAIRED SKIN IAW EA.SDR SWAA2013092320337Skin · crackedRT BS 727A+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 1. REPAIRED SKIN IAW EA.SDR SWAA2013091920315Skin · crackedLT BS 500A+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,4,5,6,9,10. REPAIRED SKIN IAW SB.SDR SWAA2013091920309Skin · crackedLT BS 807+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 2. REPAIRED SKIN IAW SB.SDR SWAA2013091920308Skin · crackedLT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3 & 7. REPAIRED SKIN IAW SB.SDR SWAA2013091920307Skin · crackedLT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013091920306Skin · crackedRT BS 500+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 1,3,4,5,6,7,8. REPAIRED SKIN IAW SWA EA.SDR SWAA2013091920305Skin · crackedRT BS 420+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,8. REPAIRED SKIN IAW SWA EA.SDR SWAA2013091920304Skin · crackedLT BS 500B+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1,2,3,4,5,6,7,8,10,11,12. REPAIRED SKIN IAW SB.SDR SWAA2013091820247Skin · crackedRT BS 887+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013091820246Skin · crackedRT BS 867+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013091820245Skin · crackedRT BS 847+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3 & 9. REPAIRED SKIN IAW SB.SDR SWAA2013091820244Skin · crackedRT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2 & 3. REPAIRED SKIN IAW SB.SDR SWAA2013091820243Skin · crackedRT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013091820242Skin · crackedRT BS 380+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE 2,5,7. REPAIRED SKIN IAW SB.SDR SWAA2013091820241Skin · crackedLT BS 420+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1- 8. REPAIRED SKIN IAW SB & DRAWING.SDR SWAA2013091820256Skin · crackedLT BS 420+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 1,3,5,6,7,8,9,10,11,12. REPAIRED SKIN IAW SB.SDR IPXA3180259Skin · gougedINSPECTION TYPE:3C, FUSELAGE SKIN REPAIR DOUBLER AT FR 20A AND STGR 28R HAS SEVERAL GOUGES. R & R REPAIR DOUBLER ON RT FUSELAGE SKIN AT FR 20A AND STGR 28R IAW EO A300-5330-52105-A.SDR CALA2013090691066Fastener · damagedINBD CREW REPORTED THAT THEY HAD A LIGHTING STRIKE. HEAT DAMAGE TO FASTENER LOCATED APPROXIMATELY STATION 403 AT S-17L, APPROXIMATELY WL 281.25. DETAIL INSPECTION & FASTENER REPLACEMENT WITHIN 50 FLIGHT HOURS NO CRACKS NOTED ON PRELIMINARY CHECK. IAW SRM 53SDR C77A20130905001Skin · dentedDENT AND LIGHTNING STRIKE DAMAGE IN THE LT FWD FUSELAGE SKIN. THE DAMAGE IS LOCATED BETWEEN FR11/ FR12 AND STGR-13L/ STGR-15L. THIS REPAIR IS BEING ACCOMPLISHED IAW ETD2013-170-033507A, SRM PART II 53-10-01, REPAIR 15P, AND SRM PART II 51-75-14. THE DAMAGE SDR FOTR23141NR29648Doubler · corrodedDOUBLER AT BS 500B AND STRINGER 26L HAS CORROSION. REPAIRED ON WO 23141, NR29648.SDR SWAA2013100220672Skin · crackedSKIN CRACKED AT BS 294.5+4 STRINGER 18R. REPAIRED SKIN IAW EA.SDR FDEA201309042150Skin · dentedAN OUTWARD DENT ON FUSELAGE SKIN BS 381, S23-24R. FOUND TO BE OUT OF LIMITS IAW SRM 53-00- 01, FIG. 101, DETAIL 3. REPAIRED IAW SRM 53-00-01, FIG. 201, REPAIR 16. THIS IS A CATEGORY "B" MAJOR REPAIR.SDR DALA13043615531Skin · dentedFOUND FOUR DENTS, LT SIDE FWD OF L4 DOOR BS 1610 18L DENTS OUT OF LIMITS IAW SRM 53-00-01, FIG 101. CUT OUT DAMAGE IAW SRM 53-00-01, FIG 201. PERFORMED HFEC AND BHEC OF REPAIR CUTOUT AND EXISTING FASTENER HOLES IAW SRM 53-00-01, FIG 201, REPAIR 2, NO CRACKS SDR SWAA2013090920000Skin · corrodedFS SKIN CORRODED AT STATION 579, STRINGER 20L. REPAIRED SKIN IAW SRM.SDR CALA2013090591011Skin · gougedFS SKIN GOUGE AT FR21 BETWEEN STRINGER 41R & 42R. LIFE LIMITED REPAIR, IAW SRM 53-00-11. INSTALLED PERMANENT DOUBLER REPAIR IAW SRM 53-11-11 FIG 214 ON NR.SDR CALA2013090591010Nut Plate · brokenSCREW MISSING AT CORNER+1 POSITION ON PANEL 195BB JUST AFT OF PACK 1 EXHAUST. INSPECTED & FOUND THE INTERNAL NUTPLATE BROKEN & INTERIM TAPED PER AMM. SERVICEABLE FOR 10 CYCLES. THE LOCATION IS 195AB. REPLACED NUTPLATE & SCREW.SDR DALA13042710949Skin · corrodedCORROSION ON FUSELAGE SKIN BENEATH FILLET PANEL RUBSTRIPS STA Y=729-731, Y=752-783, BETWEEN LONG 22RT TO 30 (FS) IN REF 500 ZONE 50 (T0 291576). FASTENERS WERE REMOVED, CORROSION WAS REMOVED.SDR DALA13042700949Skin · corrodedCORROSION ON FUSELAGE SKIN BENEATH FILLET PANEL RUBSTRIPS STA Y=1082-1093; Y=1105-1112 BETWEEN LONGERON 27 TO 30L IN REF 498, ZONE 50. FASTENERS WERE REMOVED, CORROSION WAS REMOVED, AREA WAS MEASURED NOMINAL THICKNESS ON FUSELAGE SKIN, AREA WAS TREATED AND PAISDR DALA13042690949Skin · corrodedCORROSION ON FUSELAGE SKIN BENEATH FILLET PANEL RUBSTRIPS STA Y=729-739 ,Y=782-786, BETWEEN LONGERON 21 TO 30L IN REF 499, ZONE 50 (T0 291577). FASTENERS WERE REMOVED , CORROSION WERE REMOVED, AREA WAS MEASURED NOMINAL THICKNESS ON FUSELAGE SKIN, AREA WAS TRESDR DALA13042680949Skin · corrodedCORROSION ON FUSELAGE SKIN BENEATH FILLET PANEL RUBSTRIPS STA Y=1086-1122 , BETWEEN LONGERON 26 TO 30R IN REF 497, ZONE 50, T0 291579. FASTENER WERE REMOVED, CORROSION WAS REMOVED, AREA WAS MEASURED NOMINAL THICKNESS, AREA WERE TREATED AND PAINTED, AREA OUT SDR FDEA201309042117Skin · damagedFWD CARGO BAY RT SIDE FRAMES 38.0 TO 38.1, AREA BETWEEN STRINGERS 29-30R ABOVE NOTCH FLAP STRUCTURE REPLACED SOLID RIVET HAS A LARGE ELONGATED HOLE. CARGO BAY RT SIDE FR38.0-FR38.1 AREA STRINGERS 29-30 ABOVE NOTCH FLAP REPAIRED IAW EA 6-5310-T0207146.
Back to JASC 5330