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 SWAA2014012324474Skin · crackedLT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 5. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324473Skin · crackedLT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 5. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324472Skin · crackedRT BS 887+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324471Skin · crackedRT BS 827+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324470Skin · crackedRT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR GLBA2014011300370Skin · crackedDURING A SCHEDULED INSPECTION, FOUND TWO CRACKS AT BS 150 & STRINGER 1 EXTERIOR FUSELAGE SKIN PROTRUDING OUT OF RIVETS ON EITHER SIDE OF STRINGER, .25 INCHES IN LENGTH. REPAIRED IAW EO 13-1900-53-004.SDR SWAA2014012024332Skin · crackedLT BS 767+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE 2. REPAIRED SKIN IAW SWA EA.SDR DALA14003433145Skin · gougedGOUGE ON EXTERNAL FUSELAGE SKIN AT FRAME 34 AND STR 44. REWORKED GOUGE IAW SRM A319 51-73-00. FOUND WITHIN LIMITS IAW SRM A319 53-21-11.SDR AALA20140114007Skin · crackedFUSELAGE SKIN CRACKED AT STATION 1380 BETWEEN LONGERONS 13 & 14 RT. DYE CHECKED CRACK & STOP DRILLED. INSTALLED DOUBLER IAW SRM 53-01-00 & AARD 53-30-00-02.SDR DALA14003030996Skin · corrodedCORROSION FOUND ON OUTER SKIN, BELOW AFT DRAIN MAST. REPAIRED IAW SRM 51-30-5, 51-10-3, 51-30-2, 53-04-3, FIG 11, 51-10-4, AMM 30-72-01 & NDT SPM PART 4, 04-00-07.SDR USAA2014011400002Skin · crackedFUSELAGE SKIN CRACKED AT BS 807 - 6 INCHES, STRINGER 19L. REPAIRED FUSELAGE SKIN AT BS 807 - 6 INCHES, STRINGER 19L IAW SRM 53-00-01-2R-31.SDR SWAA2014020424839Skin · crackedLT BS 520+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 3 TO 7. REPAIRED SKIN IAW EA.SDR SWAA2014020324786Skin · crackedRT BS 500A+10 UPPER FWD SKIN CUTOUT CRACKED BETWEEN HOLES 4 TO 5. REPAIRED SKIN IAW EA.SDR SWAA2014012824640Skin · crackedLT BS 500+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 3 & 4. REPAIRED SKIN IAW EA.SDR SWAA2014012824638Skin · crackedLT BS 500A+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 3 TO 7. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012824637Skin · crackedLT BS 400+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 3 TO. REPAIRED SKIN IAW EA.SDR ASAA2014011212462Skin · crackedLEFT LOWER FUSELAGE EXTERNAL FWD A/C BAY GROUND SERVICE ACCESS DOOR CUTOUT FAIRING INBD SIDE SKIN IS BENT. ACFT GROUNDED. REMOVED DAMAGE IAW SRM 53-00-01-1A-1. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-01-1A-1. FABRICATED -1, DOUBLER, -4 FILLERS, -5 TAPERED SDR SWAA2014012324469Skin · crackedLT BS 500A+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324468Skin · crackedLT BS 420+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324467Skin · crackedLT BS 360+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 2 TO 4. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324466Skin · crackedLT BS 500C+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324465Skin · crackedLT BS 500B+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 3 TO 4. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324464Skin · crackedLT BS 500+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 4. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324463Skin · crackedLT BS 480+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324462Skin · crackedLT BS 460+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW BOEING SB.SDR SWAA2014012324461Skin · crackedLT BS 420+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 5 TO 6. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324460Skin · crackedLT BS 380+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 4 TO 6. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012324459Skin · crackedLT BS 360+10 UPPER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 7. REPAIRED SKIN IAW SWA EA.SDR ASOA2014012109782Skin · damagedDAMAGE ON FUSELAGE SKIN BETWEEN FS 509-605, S25-26R. EC/TC REO 601R-53-61-4388, REV A HAS BEEN ACCOMPLISHED.SDR AALA20140114002Skin · damagedFUSELAGE DENT GOUGE AT STATION 500A & STRINGER 20 LT. INSTALLED DOUBLER REPAIR IAW SRM 53-00-01-2R-3.SDR SCNA20140210038Skin · gougedSKIN ON INSIDE OF AFT CARGO DOOR CUTOUT LOWER AFT CORNER IS GOUGED. REPAIRED AFT CARGO DOOR CUTOUT LOWER AFT CORNER.SDR SCNA20140210037Skin · gougedSKIN ON LOWER FORWARD INSIDE OF AFT CARGO DOOR CUTOUT IS GOUGED. REPAIRED AFT CARGO INNER SKIN LOWER FORWARD SIDE.SDR DALA14003393145Skin · dentedDENT ON EXTERNAL SKIN AT FRAME 21+6" AND BETWEEN STRINGERS 6-7L. FOUND WITHIN LIMITS IAW SRM 53-11-11.SDR CALA2014011390138Skin · damagedFUSELAGE SKIN DAMAGE AFT OF DOOR 5R. DAMAGE CONSISTS OF FOUR SMALL GOUGES & ONE DENT. DEEPEST GOUGE IS .007, LOCATED IN DENT WITHIN SRM53-00-01 DETAIL II ALLOWABLE LIMITS. DENT DIMENSIONS ARE 3.5 X 2 .070 DEEP BEYOND SRM DETAIL III ALLOWABLE LIMITS. DAMAGE SDR CALA2014011390132Skin · damagedEXTERNAL FUSELAGE SKIN CREASED BETWEEN BS 1380 TO 1400 & STRINGER 27R - 28R. REMOVED DAMAGED SKIN & FABRICATED A REPAIR DOUBLER, STRUCTURAL FILLER & FILLER & INSTALLED BETWEEN BS 1380 TO 1390 & AFT CARGO DOOR FWD LOWER CORNER OF CUT-OUT. IAW UAL ECRA 5360-01SDR 7C7A2016071700245Skin · dentedSHARP DENT IN FUSELAGE RT SIDE BEHIND ICE SHIELD. REPAIRED WITH INSERTION PATCH SRM 51-70-06.SDR SWAA2014012724590Skin · crackedSKIN CRACKED AT BS 988.5 STRINGER 7L. REPAIRED SKIN IAW SRM.SDR SWAA2014012724610Skin · crackedFUSELAGE SKIN CRACKED AT BS 327, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2014012724609Skin · crackedFUSELAGE SKIN CRACKED AT BS 957.5, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR DALA14005559226Skin · puncturedFUSELAGE, SKIN, BS 77, BELOW AOA VANE PUNCTURED.SDR SWAA2014012424516Skin · crackedFUSELAGE SKIN CRACKED AT BS 958.5, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2014012324458Bear Strap · crackedBEAR STRAP CRACKED AT BS 989 STRINGER 7L. REPAIRED STRAP IAW SRM.SDR DALA14003423145Skin · gougedGOUGE ON EXTERNAL SKIN LOCATED 3 INCHES FROM FWD CUT OUT OF REAR AVIONIC COMPARTMENT. REWORKED GOUGE IAW SRM 51-73-00, FOUND WITHIN LIMITS IAW SRM 53-11-11.SDR DALA14003413145Skin · dentedDENT ON EXTERNAL SKIN RT SIDE PANEL AT FRAME 5+8" AND 13". BELOW OF WINDOWS. FOUND WITHIN LIMITS IAW SRM 53-11-11.SDR DALA14003403145Skin · dentedDENT ON EXTERNAL SKIN AT FRAME 20+4.5" AND 6" UP FROM LT LATERAL STRINGER. FOUND WITHIN LIMITS IAW SRM 53-11-11.SDR AALA20140110007Skin · damagedSKIN SECTION DAMAGED FROM STATIONS 37 TO 53 ON LT HAND SIDE OF NOSE WW CUT OUT. INSTALLED SKIN FILLER SECTION & DOUBLERS IAW AARD 53-30-00-02 & SRM 53-01-00 FIGURE 2 SHEET 3.SDR SWAA2014011324056Skin · crackedFUSELAGE SKIN CRACKED AT BS 482 STRINGER 19R. REPAIRED SKIN IAW SWA EA.SDR CALA2014011390134Skin · dentedARC DENT WAS FOUND ON EXTERIOR FUSELAGE SKIN OF THE BULK CARGO DOOR FWD LWR CORNER STATION 1968 SIAW NDT PART6 51-00-00, NO CRACKS INDICATIONS.SDR SIMA20140110004Skin · gougedDURING MAINTENANCE INSPECTION ON FLIGHT 2897 FOUND LT FUSELAGE SKIN INSIDE LT PYLON PANEL 414DB GOUGED 2 PLACES JUST ABOVE LOWER PYLON SKIN. THE ACFT WAS REMOVED FROM SERVICE. REPAIRED LT FUSELAGE SKIN INSIDE LT PYLON PANEL 414DB GOUGES JUST ABOVE LOWER PYLOSDR SWAA2014013024681Doubler · corrodedSKIN DOUBLER CORRODED AT BS 727E+3 RBL 11. R & R DOUBLER IAW DRAWING & SRM.
Back to JASC 5330