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 SWAA2012060404689Skin · corrodedSKIN CORRODED AT BS 747, STR 27R. REPAIRED SKIN PER EA.SDR AALA20120604017Skin · crackedCRACK FOUND AT STATION 1309 BETWEEN LONGERONS 6 AND 7 RIGHT. INSTALLED REPAIR DOUBLER PER SRM 53-04-03 FIGURE 9 AND SRM 51-01-00 PARAGRAPH 4 B.SDR UALA2012060503114Skin · damagedON LEFT SIDE OF AIRCRAFT AT STR 35L AT APPROX STA 1263 3 LOCK FASTENERS ON THE LAP JOINT STRINGER ROW HEADS ARE PULLED OR MISSING. FABRICATED AND INSTALLED FILLER, DOUBLER, TRIPLER, STRINGERS, U-CHANNELS, J-CHANNELS PER ECRA 5360-01202 AND EA PT67-53-011. ACSDR DALA1242910635Skin · dentedTWO DENTS ON LOWER FUSELAGE SKIN AT BS 1422 BETWEEN STR 27R- 29R. FOUND DENTS TO BE OUT OF LIMITS. COMPLIED WITH ERA 505017-14 REV ORIG.SDR DALA1242820635Skin · dentedDENT ON EXTERNAL FUSELAGE AT BS 1680 BETWEEN STRINGER 16R-17R. FOUND TO BE OUT OF LIMITS. COMPLIED WITH ERA 505010-14 REV ORIG.SDR SWAA2012070205490Skin · crackedSKIN CRACKED AT BS 360+18, LBL 3. REPAIRED SKIN IAW EA.SDR SWAA2012070205489Skin · crackedSKIN CRACKED AT BS 211.8, STR 9L. REPAIRED SKIN IAW EO AND EA.SDR UALA2012060303069Skin · dentedSKIN DENTED AT FR 24, STR 23L. DENT MEASURES .011D BY .70L BY .40W, IN LIMITS PER SRM 53-11-11 DIAG 102. HFEC INSPECTION INTERNAL AND EXTERNAL SIDES, NO CRACKS NOTED. DENT IS SMOOTH AND CRACK FREE. PER SRI53-11-11 TABLE 102.SDR UALA2012060303068Skin · dentedSKIN DENTED ON LT SIDE AT FR 11, STR 23L. DENT MEASURES .025D BY 1.6L BY 1.5W, WITHIN LIMITS REF SRM.SDR SWAA2012061104804Skin · crackedSKIN CRACKED AT BS 520+7, RBL 5. REPAIRED SKIN IAW EA.SDR IPXA12173828Skin · damagedFUSELAGE SKIN DAMAGE FROM LIGHTNING STRIKE ON STR 52L & 3.5" A FT OF FRAME 36. REPAIRED REF EO A300-5330-47332-B.SDR UALA2012060303062Skin · damagedLEFT SIDE FUSELAGE FWD OF CAPTAIN PITOT TUBE 16 LIGHTNING BURN AREAS. REPLACED TOTAL OF 12 RIVETS PER AMM.SDR DALA1238859868Skin · dentedDENT ON SKIN AT BS 239 BETWEEN L16L AND 18L. COMPLIED WITH ERA 504283-14 REV3.SDR FDEA201206022056Skin · misrepairedSKIN MISREPAIRED, REPAIRED IAW SRM 53-10-12, FIG 225, SHEET 1, PAGES 357 TO 362. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR WRLA20120602546Skin · gougedGOUGE / DENT FOUND DURING PRIMARY INSPECTION AT FUSELAGE STA 755 L-24 & L25 MEASURED 3.00 X .133. ACCOMPLISHED HFEC INSPECTION ON DENT, NO CRACKS FOUND FOLLOWING BLEND-OUT OF THE EFFECTED AREA ACCOMPLISHED UT INSPECTION OF EFFECTED AREA AND FOUND SKIN THICKNESDR FDEA201206022055Skin · failedSKIN AT FRAMES 35 TO 36 & BETWEEN STRINGERS 54 LT TO 54 RT MISREPAIRED. REPAIRED SKIN WITH NEW DOUBLER IAW SRM 53-10-12, FIG 225, SHEET 1, PAGES 357 TO 362.SDR ASOA20120602082Skin · dentedDURING A-CK INSPECTION, A DENT WAS FOUND IN THE LT REAR FUSELAGE BETWEEN FRAMES 77 AND 78 AND STRINGERS 15L & 16L. MX PERFORMED A DOUBLER REPAIR, AND THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR C77A20120603016Finger Doubler · gougedFWD CARGO DOOR OPENING FWD FINGER DOUBLER HAS A CHAFED APPROX 0.015" DEEP BY .5" LONG FROM PROTECTIVE SILL PLATE. BLENDED CHAFE AND TREATEDIAW SRM 51-10-03 & 51-12-01 ON WO 553865-130 IAW ETD 2012-170-007717 AND EO E170-5300-004 REV 1 WO 572994.SDR R61A201206020302Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE DOUBLER ON THE WATER SERVICE BOX CORRODED. MAINTENANCE REMOVED AND REPLACED THE DOUBLER ON THE WATER SERVICE BOX IAW EMB 175 SRM 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201206020301Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND DOUBLER ON WATER SERVICE BOX CORRODED. MAINTENANCE REMOVED AND REPLACED THE DOUBLER ON THE WATER SERVICE BOX IAW EMB175 SRM 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR DALA12013945807Skin · damagedMX DISCOVERED THE FUSELAGE SKIN HAS LIGHTNING STRIKE AT BS 1180-65.5 AT STRINGER 3R. REMOVED DAMAGED FASTENER, HFEC INSPECTED HOLE, NO DAMAGE NOTED, INSTALLED BLIND FASTENER IAW SRM 53-00-01. REMOVED TEMP FASTENER, REAMED HOLE TO .262 CLEANED AREA. ACCOMPL SDR DALA12013935807Skin · damagedMX DISCOVERED THE FUSELAGE SKIN HAS LIGHTNING STRIKE AT BS 1180+37.5 AT STRINGER 3R. REMOVED DAMAGED FASTENER, HFEC INSPECTED HOLE, NO DAMAG E NOTED, INSTALLED BLIND FASTENER IAW SRM 53-00-01. REMOVED TEMP FASTENER, REAMED HOLE TO .262. CLEANED SURFACE. ACCOSDR DALA12013925807Skin · damagedMX DISCOVERED FUSELAGE SKIN HAS LIGHTNING STRIKE AT BS 1180+95 AT STRINGER 3R. REMOVED DAMAGED FASTENER, HFEC INSPECTED HOLE, NO DAMAGE NOTED, INSTALLED BLIND FASTENER IAW SRM 53-00-01. REMOVED TEMP FASTENER, REAMED HOLE TO HOLE .185 CLEANED SURFACE. ACCOMPSDR SWAA2012062205157Skin · crackedSKIN CRACKED AT BS 971, STR 24L. REPAIRED SKIN IAW EA.SDR IPXA12M74041Skin · damagedINSPECTION TYPE:4C 4 ELONGATED FASTENER HOLES IN FUSELAGE SKIN ALONG L48L AT STA 1562 TO 1564. REPAIRED FUSELAGE SKIN IAW STASA EA 011-5330-01-A3979 REV IR & EO MD11-5330-47600-A.SDR IPXA12M74040Skin · damagedINSPECTION TYPE: 4C, FOUR ELONGATED HOLES IN FUSELAGE EXTERNAL SKIN SPLICE STRAP ALONG L48L STA 1562-1564. REMOVED, FABRICATED, & INSTALLED SECTION OF EXTERNAL SPLICE STRAP ALONG L48L BETWEEN STA 1541-1581 IAW DWG AFA7195, NFA6214, STASA EA 011-5330-01-A3979 SDR AALA20120618008Skin · dentedDENT WITH GOUGE IN SKIN AT STATION 239. FINGER DOUBLER INSTALLED PER SRM 53-04-2 AND AARD 51-6-00.SDR USAA2012060400021Skin · crackedC2 CHECK - 2 INCH CRACK ON FUSELAGE SKIN AT BS 921, S27R. REPAIRED FUSELAGE SKIN AT BS 921, S27R IAW B737 SRM 53-00-01 PG BLOCK 2R REPAIR 31 DETAIL XIX.SDR AALA20120601009Skin · puncturedA 1.5 INCH PUNCTURE ON THE LEFT SIDE 21 INCH FORWARD AND 8.5 INCHES BELOW THE LEFT NUMBER 1 DOOR. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-00-01-2R-3.SDR SWAA2012060504641Skin · crackedSKIN CRACKED AT BS 767+ 17, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA2012060404595Skin · crackedFUSELAGE SKIN CRACKED AT BS 473, STR 16R. REPAIRED SKIN PER EA.SDR SWAA2012060404594Skin · crackedFUSELAGE SKIN CRACKED AT BS 465, STR 16R. REPAIRED SKIN PER EA.SDR SWAA2012060404591Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+13, STR 22L. REPAIRED SKIN PER SRM.SDR DALA1234950940Skin · corrodedCORROSION ON FUSELAGE SKIN BELOW RUB STRIP FROM STA Y=791, 788 BTW LONG 28 RT TO 29 RT. REPAIR PER SRM 53-04 FIG 57.SDR HNAA2012060100808Skin · corrodedPOSSIBLE CORROSION BUILDUP UNDER BOTH RADIO ALTIMETER ANTENNA. REMOVED MINOR CORROSION FROM SKIN SURFACE AT BOTH FORWARD AND AFT ALTIMETER ANTENNA AREA IAW CORROSION AND PREVENTION CONTROL MANUAL, SECTION 9, CHAPTER 4.SDR DALA12004963122Skin · dentedLEFT SIDE OF FORWARD FUSELAGE FRAMES 23 - 24, STR 21-22L, SKIN DENTED. MEASURED DENT IAW SRM FIG 105 T=.047 INCH D=.080 INCH A=2.5 INCH B=0.125 INCH. FOUND OUT OF LIMITS IAW SRM 53-11-11 DIA 103. CUT OUT DAMAGE L=3.4 INCH W=1.5 INCH IAW SRM 53-11-11 FIG 2SDR USAA2012062600030Skin Panel · corroded2S CHECK - CORROSION ON SKIN PANEL BETWEEN FR63 TO FR64 & BETWEEN S41R TO S42R. REPAIRED SKIN PANEL BETWEEN FR63 TO FR64 & BETWEEN S41R TO S42R IAW EA 501945 & A319 SRM 51-42-11.SDR SWAA2012062505191Skin · crackedFUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN IAW ER AND EA.SDR SWAA2012061905068Skin · crackedSKIN CRACKED AT BS 520, STR 13R. REPAIR SKIN IAW ER AND EA.SDR SWAA2012061905067Skin · crackedFUSELAGE SKIN CRACKED AT BS 380, STR 15R. REPAIRED SKIN PER ER AND EA.SDR SWAA2012061404899Skin · crackedSKIN CRACKED AT BS 500A+ 6, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA2012061404898Skin · crackedSKIN CRACKED AT BS 500B+ 13, STR 16L. REPAIRED SKIN IAW SRM.SDR SWAA2012060504672Skin · crackedSKIN CRACKED AT BS 500A+ 14, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012060504661Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 441 TO BS 445, STR 1L. REPAIRED SKIN IAW EA AND SRM.SDR SWAA2012060504660Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 431 TO BS 435, STR 1L. REPAIRED SKIN IAW EA AND SRM.SDR DALA1235210690Skin · damagedACCOMPLISH PERMANENT REPAIR PER ERA 472793-14 REV C AT FUSELAGE SKIN STA 505-520 STR 28L-28R. DAMAGED SKIN OUT OF LIMITS. REPAIRED PER ERA 472793-14 REV D.SDR UALA2012053103036Skin · dentedDENT AT DOOR 4R. ACCOMPLISHED SKIN LAP REPAIR 13 PER SRM AND ERCRA 5330-04215 AT C-02 VISIT. REPAIR IS LOCATED AT BS 2125 AT S24R AFT OF DOOR 4R.SDR USAA2012060100008Skin · crackedC6 CHECK - CRACK IN FUSELAGE SKIN AT BS 727E+14 INCHES, S23L. REPAIRED FUSELAGE SKIN AT BS 727E+14 INCHES, S23L IAW EA 103978.SDR USAA2012060100007Skin · crackedC6 CHECK - CRACK IN FUSELAGE SKIN AT BS 727+19 INCHES, S24L. REPAIRED FUSELAGE SKIN AT BS 727+19 INCHES, S24L IAW EA 103978.SDR USAA2012060100006Skin · crackedC6 CHECK - CRACK IN FUSELAGE SKIN AT BS 727F+8 INCHES, S23L. REPAIRED FUSELAGE SKIN AT BS 727F+8 INCHES, S23L IAW EA 103978.
Back to JASC 5330