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 SWAA2014080530607Skin · crackedFUSELAGE SKIN LOWER BULKHEAD CHORD CRACKED AT BS 540 BETWEEN STRINGER 22R TO 23R. REPAIRED SKIN IAW EA.SDR USAA2014073000010Skin · corrodedC4 CHECK LEVEL 2 GALVANIC CORROSION ON FUSELAGE SKIN BETWEEN BS 740 TO 760 & BETWEEN STRINGER 19L TO 23L. REPAIRED FUSELAGE SKIN IAW SRM 53-00-01-1A-1, FIG 101, DET III & EA 506048.SDR K11A201492291501Skin · crackedLEFT MAIN GEAR WHEEL WELL UPPER LT SKIN HAS A CRACK.SDR ASOA2014082211106Doubler · corrodedCORROSION AROUND ANTENNA BETWEEN BS 295-FS310 S27. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 53-21-01-101-002-A02 AND 51-21-06-001-001-A01. REMOVED AND REPLACED THE DOUBLER IAW SRM 51-42-20-001-001-A01, SRM 51-42-210-001-A01, & 51-42-06-001-00SDR CALA2014072891547Skin · dentedFUSELAGE SKIN RT DENT FOUND OUT OF LIMITS AT FRAME 1 - 28 + WL. INSTALLED A 7 X 7 REPAIR IAW SRM 53-00-11 4S-230 PRINCIPLE 2. FIRST INSPECTION REQUIRED AT 77452 PTC. R & R IAW SRM 53-00-11-PH4S FIG 230. REINSPECT IAW SRI53-00-11-2-017-00.SDR SIMA20140726018Skin · crackedLEFT FUSELAGE SKIN CRACKED AT FRAME 75, 1ST FASTENER BELOW STRINGER 2L. CRACK APPROX LENGTH 1/2 INCHES. SEE NRWC E400943 FOR CORRECTIVE ACTION FOR REPAIR.SDR SIMA20140726010Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT FRAME 75, 1ST FASTENER BELOW STRINGER 2R. CRACK APPROX LENGTH 3/8 INCHES. SEE NRWC E400940 FOR CORRECTIVE ACTION OF REPAIR FOR RT FUSELAGE SKIN.SDR SWAA2014082531152Skin · crackedSKIN CRACKED AT BS 416 STRINGER 16R. REPAIRED SKIN IAW ER & EA.SDR SWIA201439070Skin · dentedDENT FOUND ON RIGHT SIDE OF AIRCRAFT AFT OF FWD LAV PORT. INSTALLED DOUBLER REPAIR IAW SRM.SDR FDEA201407261980Skin · crackedAPPROX 4.5 INCHES LONG CRACK AT NLG WW LT WALL FWD END. CUT OUT CRACK & PERFORMED REPAIR IAW SRM 53-00-01 FIG 10 SHEET 5 & 51-31-01. MATERIAL 7075-T6 063C BATCH 2629113 & 7075-T6 071 BATCH 1874677. MAJOR REPAIR.SDR SWAA2014082931445Skin · corrodedSKIN CORRODED BETWEEN BS 986.5+7 INCHES TO 986.5+13 INCHES RBL 8. REPAIRED SKIN IAW EA.SDR ASOA2014082211096Skin · damagedLIGHTNING DAMAGE ON FASTENER FS 333 STR 25L-24L. COMPLIED WITH SRM SUPPLEMENT, REF GREO 670-53-00-045, REV G, STEP ,NR 3 A2/PERMANENT DISPOSITION BLENDED OUT DAMAGE. C/W LIGHTNING STRIKE REPAIR AT FS 333 STR 25L-24L IAW REO 670-53-00-045, REV G, STEP 3 A2. SDR ASOA2014082211095Skin · damagedLIGHTNING DAMAGE ON FASTENER FS 394 BETWEEN STR 25L - 24L. COMPLIED WITH SRM SUPPLEMENT, REF GREO 670-53-00-045, REV G, STEP NR 3 A2/PERMANENT DISPOSITION BLENDED OUT DAMAGED AREA. C/W LIGHTNING STRIKE REPAIR AT FS 394 BETWEEN STR 25L-26L IAW REO 670-53-00-0SDR ASOA2014082211094Skin · damagedLIGHTNING DAMAGE FS 364, BETWEEN STR 25R. COMPLIED WITH SRM SUPPLEMENT 53-00-00, REF GREO 670-53-00-045 REV G, STEP NR 3 B2/PERMANENT DISPOSITION OPENED UP HOLE FOR 1-OFF MS20426A06 INSTALLATION. C/W LIGHTNING STRIKE REPAIR AT FS 364, STR 25L IAW REO 670-53-SDR SWAA2014082131080Skin · crackedLEFT BS 520+10 UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014082031031Skin · crackedLEFT BS 500A+10 LOWER AFT WINDOW SKIN CORNER CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014081230790Skin · crackedLEFT BS 500C+10 LOWER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014081230789Skin · crackedLEFT BS 360+10 LOWER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014081230788Skin · crackedLEFT BS 500A+10 UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014081130773Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014081130772Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014081130771Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014081130770Skin · crackedLEFT BS 787+10 UPPER AFT WINDOW CORNER CRACKED. REPAIRED WINDOW IAW EA.SDR SWAA2014081130769Skin · crackedLEFT BS 867+10 LOWER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014081130768Skin · crackedLEFT BS 827+10 LOWER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW EA.SDR SWAA2014081130767Skin · crackedLEFT BS 787+10 LOWER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW EA.SDR SWAA2014081130766Skin · crackedLEFT BS 500B+10 LOWER AFT WINDOW CORNER CRACKED. REPAIRED WINDOW IAW EA.SDR SWAA2014081130765Skin · crackedLEFT BS 380+10 LOWER AFT WINDOW CORNER CRACKED. REPAIRED WINDOW IAW EA.SDR SWAA2014081130764Skin · crackedLEFT BS 500C+10 UPPER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014081130763Skin · crackedLEFT BS 500B+10 UPPER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW EA.SDR SWAA2014081130762Skin · crackedLEFT BS 500+10 UPPER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW EA.SDR SWAA2014081130761Skin · crackedLEFT BS 360+10 UPPER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW EA.SDR SWAA2014080830720Skin · crackedRIGHT BS 787+10 UPPER AFT WINDOW CORNER CRACKED. REPAIRED WINDOW IAW EA.SDR SWAA2014080630654Skin · crackedLEFT BS 420+10 UPPER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014080630653Skin · crackedLEFT BS 400+10 UPPER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014080630647Skin · crackedLEFT BS 500+10 LOWER AFT WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014080630646Skin · crackedLEFT BS 480+10 LOWER AFT WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014080630645Skin · crackedLEFT BS 460+10 LOWER AFT WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014080630644Skin · crackedLEFT BS 480+10 UPPER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014080630643Skin · crackedLEFT BS 460+10 UPPER FWD WINDOW CORNER CRACKED. REPAIRED WINDOW IAW SB.SDR SWAA2014080530604Skin · crackedRIGHT BS 767+10 LOWER FWD WINDOW CORNER CUT OUT CRACKED. REPAIRED WINDOW IAW SB.SDR FDEA201407251978Skin · dentedLOWER FUSELAGE SKIN HAS A DENT AT BS 1666 BETWEEN STRINGERS 24 - 25L. REPAIRED IAW EA F-5330-T0309871 PT 1.SDR CALA2014072801008Doubler · corrodedSUPPORT TASK FWD CARGO BILGE ANTENNA DOUBLER HAS SURFACE CORROSION AT STATION 500A+10 INCHES. REMOVED CORROSION IAW 51-10-02. ORIGINAL MAT .060 INCHES, LOSS MAT .011 INCHES & REMAINING MAT .049 INCHES FOUND OUT LIMITS IAW SRM 53-00-01. FABRICATED A NEW ANTESDR DALA2014072604259Skin · corrodedSKIN SPLICE CORRODED, BS 1240, LBL 12- RBL 6. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATED AND INSTALLED SPLICE IAW SRM 51-10-05, 51-30-05 AND DWG 5936667.SDR AALA20140725006Skin · corrodedCORROSION ON FUSELAGE SKIN AT EXHAUST VENT AREA. INSTALLED DOUBLER REPAIR IAW EA B737-53-035889.SDR CALA2014072891552Skin · corrodedADF ANTENNA CUT OUT FOUND CORRODED FUSELAGE FRAME 44 - 45 STRINGER 1L - 1R. REMOVED CORROSION FROM UPPER SKIN SURFACE NEAR ADF CUT OUT.\O-T\0.087. DEPTH OF REMOVED MATERIAL =.077\W=2.5\ SRM 53-31-11 PARAGRAPH 3 TABLE 101 PARAGRAPH 4 A NOTE 1 DIAGRAM 101. ACSDR CALA2014072891548Skin · damagedMLG DOOR HINGE FITTINGS LT & RT WERE REMOVED TO FIND SEVERAL ELONGATED HOLES AT MATING SURFACE OF HINGE FITTING & KEEL BEAM BOTTOM SKIN. REPAIRED BOTH LT & RT BOTTOM KEEL BEAM SKINS AT HINGE FITTING SURFACES IAW ECRA 5336-01 017. NO DEVIATIONS, NO FURTHER ACSDR ASAA2014072415621Skin · dentedDENT ON FUSELAGE SKIN ON STR S22R AT APPROXIMATELY FS 306, RT SIDE. ACFT GROUNDED. RESOLVED ON W/O: 254932, TASKCARD: N/R-00003. REMOVED AND REINSTALL AIR DUCT FROM ELECTRONIC EQUIPMENT COMPARTMENT TO GET ACCESS IAW SRM 51-40-02 SWPM 20-10-12. REPAIR VERIFISDR ASAA2014072415620Skin · dentedDENT ON FUSELAGE SKIN ON STR S22R AT APPROXIMATELY FS 306, RT SIDE. ACFT GROUNDED. RESOLVED ON W/O: 254932, TASKCARD: N/R-00003. REMOVED AND RE-INSTALL AIR DUCT FROM ELECTRONIC EQUIPMENT COMPARTMENT TO GET ACCESS IAW SRM 51-40-02, SWPM 20-10-12. REPAIR VERISDR ASOA2014082211093Skin · damagedLIGHTNING STRIKE DAMAGE DISCOVERED AT FS 310 & STR 25L. COMPLIED WITH SRM SUPPLEMENT 53-00-00, REF GREO 670-53-00-045, REV G, STEP NR 3 B2/PERMANENT DISPOSITION OPENED UP HOLE FOR 1-OFF MS20426AD6 INSTALLATION. C/W LIGHTNING STRIKE REPAIR AT FS 364, STR 25L
Back to JASC 5330