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 ASOA2013052003633Skin · burnedONE BURN AT FS 597 ONE INCH ABOVE S5R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013052003632Skin · burnedONE BURN ON RIVET ONE INCH AFT OF FS 693 ON S10R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013052003631Skin · burnedONE BURN ON RIVET 6.5 INCHES AFT OF FS 581 ON S15R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013052003630Skin · burnedONE BURN ON RIVET ON FS 437 BETWEEN S16 - 17R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013052003629Skin · burnedONE BURN ON SKIN FIVE INCHES AFT OF FS 202 BETWEEN S19 - 20R. REPAIRED IAW 670-53-00-388.SDR ASOA2013052003628Skin · burnedONE BURN ON RIVET SIX INCHES FWD OF FS 549 ON S16R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013052003627Skin · burnedONE BURNED RIVET ON FS 613 ONE INCH BELOW S1R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013052003626Skin · burnedONE BURN ON RIVET ON FS 517, BELOW STR 16R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013052003625Skin · burnedONE BURN ON RIVET ON STRINGER 6R, FOUR INCHES AFT OF FS 517. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013051703622Skin · burnedBURN ON SKIN EDGE FWD FS 453 BELOW STRINGER 8R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013051703621Skin · burnedBURN ON SKIN BETWEEN FS 437 - 421 BELOW STRINGER 8R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013051703620Skin · burnedBURN ON SKIN AFT OF BS 409 BELOW STR 8R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013051703619Skin · burnedBURN ON SKIN FWD OF FS 409 BELOW STR 8R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013051703618Skin · burnedBURN ON SKIN FWD OF FS 394 ON STR 12R. REPAIRED IAW REO NR 670-53-00-388.SDR ASOA2013051703617Skin · burnedBURNED SKIN AT 4" FWD OF FS 310.00 AND STR17 RT. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013051703616Skin · burnedONE BURN ON SKIN AT BS 280 STRINGER 20R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013051703615Skin · burnedONE BURN ON SKIN 7 INCHES AFT OF FS 202 STRINGER 18R. REPAIRED IAW REO 670-53-00-388.SDR ASOA2013051703614Skin · burnedONE BURN ON SKIN AT FS 250 AND ONE INCH BELOW STRINGER 20R. REPAIRED IAW REO 670-53-00-388.SDR ASAA2013042894782Skin · scratchedSCRATCHES ON SKIN BELOW NR 5 EYEBROW WINDOW. REPAIRED SCRATCHES ON SKIN BELOW NR 5 EYEBROW WINDOW IAW ASA EA NR 400, 53EA 10352.SDR REXA2013042800769Doubler · corrodedTCAS ANTENNA DOUBLER CORRODED. REMOVED, FABRICATED, & REPLACED TCAS DOUBLER IAW CRJ 900 SRM 51-24-21.SDR DALA13022220998Skin · damagedDURING LINE MX, MX NOTED GROUND DAMAGE ON THE FWD EDGE SKIN OF THE MID (C-2) CARGO DOOR CUTOUT. DAMAGE WAS REPAIRED IAW ER/A 514326-14 AND THE REQUIRED INSPECTION WAS ACCOMPLISHED.SDR ASAA2013042894733Skin · dentedLEFT FUSELAGE BS 807 S21L SKIN DENTED. FOUND TO BE OUT OF LIMITS. REPAIRED IAW SRM 53-00-01-212-35.SDR DALA1311960681Skin · dentedDENT ON FUSELAGE SKIN BETWEEN FRAME BS 580 AND 600, S25-26L. REPAIRED IAW ERA 512670-14AD, REV ORG.SDR DALA1311670609Skin · damagedLIGHTNING STRIKE AT BS 1190, 2 INCHES BELOW STRINGER 9L. REPAIRED IAW SRM 53-00-01.SDR DALA1311143749Skin · crackedLOWER EXTERNAL FUSELAGE BILGE AREA BS 747-767 ANTENNA CRACKED AND CORRODED ON SKIN. REPAIRED IAW ERA 513574-14, REV ORIG NR 1841125.SDR UALA2013042902949Skin · corrodedBS 1720 S43L, CORROSION BETWEEN SKIN AND STRINGER. REMOVED DAMAGE. HFEC PERFORMED MANUFACTURED AND INSTALLED REPAIR IAW SRM 53-00-01 REPAIR 1. MAJOR REPAIR.SDR QXEA2013042700853Strap · corrodedSKIN STRAP BETWEEN STR 31P AND 32P CORRODED JUST FWD OF STA 301. FASTENERS & CORROSION REMOVED ON SKIN STRAP BETWEEN STR 31P & 32P JUST FORWARD OF STATION 301 IAW RD 8/4-53-5238. MIN THICKNESS NOTED .044" REF NTM 51-00-04-910-801, PT1, REV 9. CONFIRMED CRACSDR QXEA2013042700852Skin · damagedINTERNAL BELLY SKIN STRAP BETWEEN STRINGERS 31P AND 32P HAS CORROSION BETWEEN STA X258.500 AND X301.000. REMOVED 9 RIVETS AND REMOVED CORRSION ON BELLY SKIN STRAP BETWEEN STR 31P AND 32P BETWEEN FRAME 258.5 AND 301 IAW SRM 51-42-05-02-01, SRM 51-21-00-00-02, SDR C77A20132704001Skin · damagedSKIN ON THE RT FORWARD FUSELAGE DAMAGED. R & R THE SKIN. ACFT WAS RELEASED FOR SERVICE.SDR DALA13025550193Skin · damagedFOUND TWENTY LIGHTNING STRIKE DAMAGE POINTS BETWEEN BS 287 AND 654+110, S34-36L. REMOVED DAMAGE IAW SRM 53-00-01, REPAIR B SECTION C/W BHEC INSPECTION OF HOLES IAW SRM 53-00-01, FIG 201, NO CRACKS FOUND.SDR SWAA2013052316423Skin · crackedSKIN CRACKED AT BS 827+15, STR 17L. REPAIRED SKIN IAW SRM.SDR SWAA2013051716169Splice Plate · corrodedFUSELAGE SKIN EXTERIOR SPLICE PLATE CORRODED AT STA 813, BETWEEN LONG 28L TO LONG 28R. R & R SPLICE PLATE IAW SRM & DWG.SDR SWAA2013051416033Skin · crackedLEFT NLG STRUT DOOR AFT HINGE CUTOUT SKIN CRACKED. REPAIRED DOUBLER IAW SRM.SDR SWAA2013050915876Skin · crackedRIGHT NLG STRUT DOOR, AFT HINGE CUTOUT SKIN CRACKED. REPAIRED DOUBLER IAW SRM.SDR SWAA2013050615667Skin · crackedL1 DOOR UPPER HINGE CUTOUT CRACKED. REMOVED AND REPLACED CUTOUT IAW SRM.SDR C77A20130502003Skin · damagedDAMAGE WAS FOUND UNDER THE FO’S SIDE WINDOW ON THE SIDE OF THE FUSELAGE. THE DAMAGE IS A DENT LOCATED BETWEEN FR 05 AND FR 06 AND STGR 21R AND 22R. FORWARD SIDE OF DENT IS LOCATED 5" AFT OF FR 05 AND AFT SIDE OF DENT IS LOCATED 11.10" AFT OF FR 05. THE BOTTSDR AALA20130426011Doubler · damagedEXTERNAL FUSELAGE REPAIR DOUBLER LOCATED BODY STATIONS 334 TO 340 BETWEEN STRINGERS 17 AND 18 LEFT DAMAGED. REMOVED FLOORBOARD AND ACCOMPLISHED REPAIR PER REO G16170 REVISION A AND INSTALLED FLOORBOARD PER AMM 53-01-01.SDR DALA13020480920Skin · crackedACFT SKIN CRACKED APPROX .5" LONG THROUGH RIVET HOLE BS 1437, 1" INBD OF LONGERON 3 LT. ALL WORK COMPLETED ON PRI 514384-14, REV-O AND REV-1.SDR C77A20130430017Doubler · corrodedAFTER REMOVAL OF BRACKET, CORROSION WAS FOUND ON INTERNAL DOUBLER SKIN. Y= 21192-21617, STR= 27R-28R. BLENDED CORROSION IAW SRM 51-10-03 & 51-12-01.SDR USAA2013042900018Skin · corrodedC3 CHECK - CORROSION ON FUSELAGE SKIN AT BS 1307 BETWEEN S34L TO S35L. REPAIRED FUSELAGE SKIN AT BS 1307 BETWEEN S34L TO S35L IAW EA 505273.SDR DALA13019830992Skin · dentedDURING SCHEDULED MX, AN EXTERNAL SKIN DENT WITH GOUGE WAS DOCUMENTED AT BS 1303 1" ABOVE LONGERON 19R. EVAULATED SKIN DENT WITH GOUGE AT BS 1303 1" ABOVE LONGERON 19R. DENT MEASURED 1.7" X 2.2" X .053". AND IS OUT OF LIMITS IAW SRM 53-04-1. TRIMMED OUT DAMAGSDR FDEA201304260859Skin · damagedFUSELAGE SKIN RT SIDE HAS A LIGHTING STRIKE AT BS 395, STR 7R. REPAIRED IAW EA F-5330-168308, PART 1. MAJOR REPAIR.SDR NACA20130426006Skin · damagedDICOVERED DAMAGE TO THE FUSELAGE SKIN BETWEEN STATION 8610 AND 887. DAMAGE TO THE SKIN WAS ACCOMPLISHED IAW BOEING 737-300 SRM 53-60-01 REPAIR NUMBER 9 AS STATED PER SB 737-53A 1266. MODIFICATION TO THE DORSAL FIN CAP WAS ALSO ACCOMPLISHED IAW SB 737-53A- 12SDR 39LA2013042600004Skin Panel · dentedSKIN DENTED AND GOUGED DAMAGE BETWEEN BS 531.5-564.5, S17-19S, SKIN PANEL. REPAIRED IAW DWG RD8-53-12999, ISSUE 1.SDR UALA2013042502890Skin · dentedLEFT FUSELAGE SKIN BS 520-660, S14-20L, HAS NUMEROUS DENTS. REPAIRED PER REO G12078 REV 'A' AND EVA 70421.SDR FDEA201304250857Skin · crackedFUSELAGE SKIN BS 1701-1715, S19-20L MISREPAIRED. REPAIRED IAW SRM 51-40-02, & 53-00-01 REPAIR 15. HFEC CUTOUT AND HOLES IAW NTM 51-00-19 & 51-00-16. NO CRACKS NOTED. INSTALLED NEW DOUBLER AND FILLER IAW SRM 53.-00-01 REPAIR 15. CATEGORY 'B' MAJOR REPAIR.SDR FDEA201304250858Skin · damagedFOUND SCRIBE LINE ON SKIN AT BS 439.625 TO 560.875 IN LAP JOINT SEAM AT S19R. REPAIRED IAW EA 757-5331-16-F4105, REV, AND 496583220001. CAT "A" MAJOR REPAIR.SDR DALA13019323211Skin · damagedDURING INSPECTION, FOUND LOWER FWD FUSELAGE EXTERNAL SKIN BETWEEN FR 26-27 S40R HAS TWO LIGHTNING STRIKES. DRILLED OUT DAMAGE FASTENER IAW SRM 51-42-11, PERFORMED HFEC ROTARY PROBE INSPECTION OF ONE OPEN FASTENER HOLE IAW NTM 51-10-01 PT6 WITH NO INDICATIONSDR QXEA2013042500823Strap · corrodedSKIN STRAP BETWEEN STA -18.25 AND STA -39 FROM STR 32S TO 31S HAS CORROSION. REMOVED RIVETS TO FOM IAW SRM 51-42-05-02-01, REV 12. REMOVED CORROSION FROM SKIN STRAP IAW SRM REV 12 51-21-00-00-02. MINIMUM REMAINING THICKNESS NOTED IS .034" IAW NTM 51-00-04-91SDR DALA13019403211Skin · damagedLOWER FWD FUSELAGE EXTERNAL SKIN BETWEEN FR26-27 STRGR 40R HAS 2EA LIGHTNING STRIKE. DRILLED OUT DAMAGE FASTENER IAW SRM 51-42-11, PERFORMED HFEC ROTARY PROBE INSPECTION OF ONE OPEN FASTENER HOLE IAW NTM 51-10-01 WITH NO INDICATIONS NOTED. COLD WORKED FASTENE
Back to JASC 5330