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 USAA2013051300015Skin · crackedCRACK ON FUSELAGE SKIN AT BS 345, S7L. REPAIRED SKIN IAW EA 204872A, PG 1-13 & SB 757-53-0094 REV 1.SDR DALA13022573133Skin · corrodedCORROSION ON EXTERNAL SKIN LOCATED FR 34+17" AND BETWEEN STR 44 AND STR 43R FWD LOWER FUSELAGE DIMENSIONS L=0.128" W=0.080" D=0.001" APPROX, SSI 532165. REWORKED AREA ON EXTERNAL SKIN LOCATED FR 34+17" AND BETWEEN STR 44 AND STR 43R FWD LOWER FUSELAGE EVALUATSDR USAA2013051300016Bear Strap · crackedDAILY VISIT - L-1 DOOR FRAME FUSELAGE CUTOUT FORWARD CORNER CUTOUT RADIUS HAS A CRACK INDICATION AT NR 7 FASTENER IN THE BEAR STRAP AT BS 345 BETWEEN S6L TO S7L. REPAIRED L-1 DOOR FRAME FUSELAGE CUTOUT FORWARD CORNER CUTOUT BEAR STRAP AT BS 345 BETWEEN S6L TOSDR REXA2013051300660Skin · damagedFUSELAGE SKIN FROM FS 589 - FS 603, S22R - S26R HAS MULTIPLE DENTS. REPAIRED IAW EA CRJ253-01552 AND ASSOCIATED 8110-3.SDR FDEA201305100969Skin · misrepairedSKIN MISREPAIRED BS 1700 -1720 S15-16L. REPAIRED IAW EA F-5330-T0300418, CAT "B" MAJOR REPAIR.SDR U5QA20130510054Skin · dentedDENT ON FUSELAGE BELOW LT NR 2 WINDOW. INSTALLED DOUBLER IAW 60006-23252.SDR USAA2013061700043Skin · crackedQ4 CHECK -CRACK ON FUSELAGE SKIN AT BS447, LBL1. REPAIRED FUSELAGE SKIN AT BS447, LBL1 IAW EA NR 104781.SDR COEA2013061114912Skin · dentedDURING HEAVY CHECK, DENT IN SKIN BETWEEN FRAMES 16-17 AND STRINGER 17L-18L. REPAIR IAW SRM 53-00-00. MAJOR REPAIRSDR SWAA2013060516803Skin · crackedRT BS 500C+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW EA.SDR SWAA2013060416723Skin · crackedLEFT BS 847+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2, AND 3. REPAIRED SKIN IAW SB.SDR SWAA2013060416722Skin · crackedLEFT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW SB.SDR UALA2013051003289Skin · damagedFUSELAGE SKIN DAMAGED. INSTALLED REPAIR IAW SRM 53-00-01 FIG 201 REPAIR 2.SDR UALA2013051003288Skin · damagedFUSELAGE SKIN BS 759, 9 INCHES BELOW S26L. INSTALLED REPAIR DOUBLER ON IAW SRM 53-00-01 REPAIR 2 FIG 201 TABLE V.SDR UALA2013051003283Skin · damagedFUSELAGE SKIN BS 698-722 STR 27L DAMAGED. REPAIRED IAW SRM 53-00-01 FIG 201 REPAIR 2. THIS CAT 'B' REPAIR IN ZONE A.SDR UALA2013051003282Skin · gougedDEEP GOUGE IN FUSELAGE SKIN BS 705 S27L. INSTALLED REPAIR DOUBLER BS 698-722 IAW SRM 53-00-01 FIG 201 REPAIR 2. ACCOMPLISHED HFEC IAW NDT 51-00-16 & 51-00-19, NO CRACKS NOTED.SDR UALA2013051003277Skin · gougedDEEP GOUGE IN FUSELAGE SKIN BS 759, 9 INCHES BELOW S26L. INSTALLED REPAIR DOUBLER ON SKIN IAW SRM 53-00-01 FIG 201 REPAIR 2. ACCOMPLISHED HFEC IAW NDT 51-00-19 & 51-00-16 NO CRACKS FOUND. MAJOR REPAIR.SDR UALA2013051003275Skin · damagedLIGHTNING STRIKE ON FUSELAGE SKIN BS 710, EIGHT INCHES BELOW S27R. REPAIRED FUSELAGE SKIN IAW SRM REPAIR 2. ACCOMPLISHED HFEC IAW NDT 51-00-16 & 51-00-19.SDR UALA2013051003273Skin · dentedDENT IN FUSELAGE SKIN AT BS 214 AND 9 INCHES BELOW S22R. REPAIRED DENT IAW ECRA 5311-01594. ACCOMPLISHED HFEC OF CUTOUT IAW NDTM 51-00-16 & 51-00-19. NO CRACKS NOTED. MAJOR REPAIR.SDR SWAA2013060316686Skin · crackedLEFT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3, 5, 6, 7. REPAIRED SKIN IAW EA.SDR SWAA2013060316682Skin · crackedRIGHT BS 520+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013060316681Skin · crackedLEFT BS 727B+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2013060316680Skin · crackedLEFT BS 727+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 7, 8. REPAIRED SKIN.SDR SWAA2013060316679Skin · crackedLEFT BS 727D+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 4, 12. REPAIRED SKIN IAW EA.SDR SWAA2013060316674Skin · crackedRIGHT BS 520+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 4. REPAIRED SKIN IAW EA.SDR SWAA2013052916599Skin · crackedL1 DOOR CUTOUT CRACKED ON REVEAL LOCATED ON AFT LOWER CORNER. R & R CUTOUT IAW SRM AND DWG.SDR COEA2013052903912Skin · dentedHEAVY CHECK COE/MAJOR REPAIR: FOUND DENT DAMAGE TO SKIN BETWEEN FRAMES 11-12 AND STRINGER 13R-14R. REPAIR PER ATR42 SRM 53-00-00 FIG 403.SDR IPXA3M78511Skin · dentedINSPECTION TYPE:2C, 12 DENTS ON FUSELAGE EXTERIOR SKIN AFT OF BULK CARGO DOOR, BS 1958- 2007, L36L -L42L. REPAIRED FUSELAGE SKIN AT NOTED LOCATION IAW STASA EA 011-5330-01- A4630, REV IR AND EO MD11-5330-50829-A. FAA 8100-9 DATED 20 MAY 2013 (MINOR)SDR SWAA2013052416461Skin · crackedLEFT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 3. REPAIRED SKIN IAW SB.SDR SWAA2013052316427Skin · crackedRIGHT BS 500A+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013052316426Skin · crackedRIGHT BS 500+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013052316425Skin · crackedRIGHT BS 480+10 UPPER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013052216356Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3, 7, 8. REPAIRED SKIN IAW SB.SDR SWAA2013052216355Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3, 6. REPAIRED SKIN IAW SB.SDR SWAA2013052216354Skin · crackedLEFT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013052016226Skin · crackedRT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013052016225Skin · crackedRT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3,5. REPAIRED SKIN IAW SB.SDR DALA13023170948Skin · dentedFUSELAGE EXTERIOR BS 256 L17L DENTED. CUT-OUT DAMAGED AREA, FABRICATED DOUBLER, FABRICATED STRAP DOUBLERS, AND INSTALLED STRAPS DOUBLER, DOUBLER REPAIR AND FILLER & REPAIR IAW SRM 51-30-2, 53-04-3, FIG 4, 51-10-3,SDR COEA2013051701912Skin · dentedHEAVY CHECK COE/MAJOR REPAIR: DENT DAMAGE TO SKIN BETWEEN FR 12-13 AND STRINGER 18L-19L. MAJOR REPAIR PER ATR 42 SRM 53-00-00.SDR UALA2013051003280Skin · misrepairedLIGHTNING STRIKE REPAIR AT BS716 .5" BELOW STR 27L DOESN'T MEET SRM REQUIREMENTS. *SUPPLEMENTAL DATA UPDATE* MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR DOUBLER TO FUSELAGE SKIN BS 698-722 STR 27L IAW SRM 53-00-01 FIG 201 RPR 2. ACCOMPLISHED HFEC IAW NDT SDR UALA2013051003276Skin · dentedFORWARD LOWER FUSELAGE HAS A SMALL DENT AT BS 358 AND S23R. INSPECTED DENT, NO CRACKS NOTED IAW HFEC. DENT IS WITHIN LIMITS OF SRM 53-00-01 & OK FOR CONTINUED SERVICE WITHOUT FURTHER ACTION.SDR QXEA2013050900953Skin · corrodedSKIN STRAP FROM STA 19.4 TO STA 32 STR 32P - 31P HAS CORROSION. REMOVED RIVETS ON SKIN STRAP FROM STA 19.4 TO STA 32 TO FOM IAW SRM 51-42-05-02-01, REV 12. REMOVED CORROSION ON SKIN STRAP FROM STA 19.4-32 BETWEEN STR 32P-31P IAW SRM 51-21-00-00-02, REV 12. MSDR QXEA2013050900950Skin · corrodedEXTERNAL SKIN STRAP, STATION -18.250 - 136.00 HAS MULTIPLE CORRODED RIVETS AND POSSIBLE CORROSION. CORROSION ON FASTENERS ONLY. REMOVED CORRODED RIVETS IAW IAW 1400 SRM 51-42-05-02-01, REV 12. INSTALLED RIVETS IAW SRM 51-42-05-02-01, REV 12. APPLIED PRIMERSDR UALA2013051003278Skin · damagedREPAIRED FUSELAGE SKIN AT BS 215.50, RBL 14 .10 RECEIVED 1ST& 2ND STG APPRL.SDR WX0A071578Skin · dentedUPPER LEFT FUSELAGE SKIN DENT STATION 218 LONGERON 3L. LENGTH 1.5 DEPTH .018 D/X RATIO OF 83.3. FOUND TO BE WITHIN LIMITS.SDR DALA13021713211Skin · damagedDURING INSPECTION, MX REPLACED FWD CENTER TITANIUM & RT FUSELAGE LATERAL SKIN PANEL BETWEEN FR1-FR 12 IAW ER/A 512316-14. REPLACED FWD CENTER TITANIUM SKIN IAW REPAIR DWG R5311269007 & RT FUSELAGE LATERAL SKIN PANEL FR 1-12 IAW REPAIR DWG R53112168000.SDR AALA20130509011Skin · wrinkledRIGHT FUSELAGE SKIN WRINKLED AND BULGED BETWEEN STATIONS 1231 TO 1250 AND LONGERONS 25 AND 26. REPLACED SKIN SECTION PER SRM 53-04-00 FIGURE 12C.SDR DALA13066275652Skin · damagedLIGHTNING STRIKE ON SKIN AT BS 385, STRINGER 26L. INSTALLED BLIND FASTENER IAW SRM 53-00-01, REPAIR 6, SEC 2, PARA 4.SDR DALA13066265652Skin · damagedLIGHTNING STRIKE ON SKIN AT BS 360, STRINGER 26L. INSTALLED BLIND FASTENER IAW SRM 53-00-01, REPAIR 6, SEC 2, PARA 4.SDR DALA13066255652Skin · damagedLIGHTNING STRIKE AT BS 369, STRINGER 26L. INSTALLED BLIND FASTENER IAW SRM 53-00-01, REPAIR 6, SEC 2,SDR AALA20130607010Skin · corrodedFUSELAGE SKIN CORRODED AROUND LAVATORY VENT. INSTALLED REINFORCING REPAIR IAW EA B737-53-030149.
Back to JASC 5330