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 AALA20141002001Skin · crackedFUSELAGE SKIN CRACKED PAST STOP DRILL AT LT NLG STRUT DOOR AFT HINGE. INSTALLED DOUBLER IAW SRM 53-05-00-001.SDR DALA2014100205369Skin · corrodedCORROSION ON FUSELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING ON STA Y= 1102 L28R . AREA WAS REPAIRED IAW SRM 53-04, FIG 57.SDR FY4Y20141003007Skin · corrodedDURING INSPECTION THE INSPECTOR PERFORMED VISUAL INSPECTION & FOUND LEVEL 2 CORROSION ON FUSELAGE SKIN OF BS 950E+4 STRINGER 28L. THE CORROSION THROUGH THE SKIN WAS OVER LIMIT IAW SRM 53-30-01 FIG 1. THE ITEM HAS BEEN REPORTED FOR REQUESTING THE REPAIR APPROSDR FY4Y20141003006Skin · corrodedDURING CPCP INSPECTION THE INSPECTOR FOUND LEVEL 2 CORROSION ON FUSELAGE SKIN BETWEEN BS 720B & 720C STRINGER 28L & 28R. THE CORROSION THROUGH THE SKIN WAS OVER LIMIT IAW SRM 53-30-01 FIG 1. THE ITEM HAS BEEN REPORTED FOR REQUESTING THE REPAIR APPROVAL DATASDR SIMA20140930002Skin · crackedLEFT AFT FUSELAGE FRAME 75 STRINGER 2L UPPER AREA, SKIN CRACKED AT FASTENER. ACCOMPLISHED REPAIR IAW ERS-EM-53MR-755.SDR DALA2014100105329Skin · dentedDURING HEAVY CHECK, TWO DENTS WERE LOCATED IN THE SKIN BETWEEN STRINGERS 41 - 43R AND FRAMES 26 - 27. REPAIRED IAW ERA 528824-14, SECTION I.SDR FDEA201409302878Skin · corrodedFOUND SCRIBE LINE IN LAP SEAM AT STRINGER 4R FROM BS 700 TO 781 WITH CORROSION ON TOP OF SCRIBE LINE RUNNING UNDER LAP SEAM & WITH CORROSION ON UPPER SKIN SURFACE AT MARKED LOCATIONS REQUIRING ADDITIONAL STRIPPING FROM BS 661 - 700. COMPLIED WITH EA F-5330-SDR FDEA201409302874Skin · dentedLOWER FUSELAGE HAS A DENTED AREA BS 664 BETWEEN STRINGERS 25L & 26L. COMPLIED WITH EA F-5330-TO311447 PART 1. COMPLIED WITH HFEC & DVI INSPECTIONS NO DEFECTS NOTED. INSTALLED DENT DOT AT DENT LOCATION IAW GMM 6-3-101.SDR 7C7A201409300057Panel · corrodedLEFT STRESS PANEL 522AT CORROSION IN COUNTERSINKS. CORROSION REMOVED FROM 30 COUNTERSINKS IAW RD8-57-1715.SDR CA141014008Skin · corroded(CAN) FINDING: BELLY SKIN CORROSION AT STA 258 BETWEEN STRINGERS 15L AND 16L. REPAIRED IAW SRM 51-70-06 METHOD A. DAMAGED SKIN REMOVED. INNER DOUBLER MADEWITH SKIN FILLER. ALL WET ASSEMBLY WITH PR1422 USING ALL MS20470AD4 SOLID RIVETS. ALL AFFECTED AREAS PREPSDR SWAA2014111934302Skin · crackedSKIN CRACKED AT BS 482B+5.75, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014111934301Skin · crackedSKIN CRACKED AT BS 482B+12.5, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014111834258Skin · crackedSKIN CRACKED AT BS 908+ 4.75, STRINGER 4L. REPAIRED SKIN IAW EO & EA.SDR SWAA2014111334137Skin · crackedSKIN CRACKED AT BS 482B + 13, STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWIA201439599Skin · chafedBS 985 STINGER 27 CHAFED. C-CHECK. REMOVED AND REPLACED THE DOUBLER AND FILLER BETWEEN BS 977 AND 985 IAW REO. PRESSURIZATION CHECKED GOOD.SDR DALA2014093005336Skin · crackedCRACK IN SKIN TWO INCHES FWD OF BS 1338, LONGERON 3L. ACCOMPLISHED REPAIR IAW ERA 529397-14AD, REV ORIGINAL SEC I.SDR DALA2014093005335Skin · crackedCRACK DISCOVERED AT BS 1338, LONGERON 3L ON SKIN ONE INCH FWD. 0.125 INCH IN LENGTH. ACCOMPLISHED REPAIR IAW ERA 529397-14AD, REV ORIGINAL SEC I.SDR DALA2014093005318Skin · damagedSKIN BS 494, S26-27R, FWD ATG4 ANTENNA DAMAGED. REPAIRED IAW ER/A 519398-14, REV A.SDR FDEA201409292853Skin · damagedLIGHTNING STRIKE DAMAGE BS 1220 STRINGER 1 FASTENER. REPAIRED IAW SRM 53-00-01 REPAIR 6.SDR FDEA201409292852Skin · damagedLIGHTNING STRIKE TO FUSELAGE BS 1460 STRINGER 1R. REPAIR CARRIED OUT IAW SRM 53-00-01 REPAIR 6.SDR SWAA2014111834257Skin · crackedSKIN CRACKED AT BS 420+2.5, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2014111834256Skin · crackedSKIN CRACKED AT BS 400+13.750, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2014111434186Skin · crackedSKIN CRACKED AT BS 767+7, STRINGER 22L. REPAIRED SKIN IAW EA.SDR SWAA2014111434185Skin · crackedSKIN CRACKED AT BS 767+12, STRINGER 22L. REPAIRED SKIN IAW EA.SDR SWAA2014111434176Skin · crackedSKIN CRACKED AT BS 747 + 16.5 STRINGER 24L. REPAIRED SKIN IAW EA.SDR SWAA2014111434175Skin · crackedSKIN CRACKED AT BS 767 + 2.750, STRINGER 23L. REPAIRED SKIN IAW EA.SDR SWAA2014111434167Skin · crackedSKIN CRACKED AT BS 747 + 3, STRINGER 23L. REPAIRED SKIN IAW EA.SDR SWAA2014111434166Skin · crackedSKIN CRACKED AT BS 747 + 12, STRINGER 21L. REPAIRED SKIN IAW EA.SDR SWAA2014111234093Skin · crackedFUSELAGE SKIN CRACKED AT BS 360 STRINGER 2R. REPAIRED SKIN IAW EO & EA.SDR SWIA201439548Skin · corrodedAVIONICS DOOR CUTOUT SURROUND STRUCTURE INNER SKIN HAS SEVERAL AREAS WITH CORROSION. C-CHECK, REPAIRED IAW REO.SDR SWIA201439503Skin · chafedFUSELAGE CHAFED UNDER RT STUB FAIRING, PANEL 172DR. C-CHECK, REPAIRED DAMAGED AREA IAW EA.SDR FDEA201409282844Skin · damagedMULTIPLE TOOL DAMAGE ON THE INTERIOR SKIN AT BS 1420 - 1423, STRINGER 25L - 26L. REPAIRED IAW EA F-5330-T0311215 PART 1. REPAIR CLASSIFIED AS MAJOR.SDR SWIA201439476Skin · corrodedCORROSION FOUND UNDERNEATH TCAS OMNI DIRECTIONAL ANTENNA BS 295 - 310 STR 27 OUTER SKIN SURFACE. REPAIRED SKIN IAW STS EA.SDR IPXA2014100884537Skin · gougedINSPECTION TYPE:1C, GOUGE DAMAGE ON FUSELAGE SKIN AFT EDGE AT CTR CARGO DOOR CUT-OUT, STA 1781, L40R-L42R. REPAIRED NOTED DAMAGE AT CTR CARGO DOOR CUT-OUT EDGE IAW SRM 53-00-05, REPAIR 8, FIG 202.SDR AALA20141003018Doubler · crackedCRACK EXISTS IN RT LOWER DOUBLER AT LONGERON 2 RT & STATION 1437. REPLACED INNER DOUBLER IAW SRM 51-30-05.SDR SWAA2014111934316Skin · crackedSKIN CRACKED AT BS 482B+6, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014111934314Skin · crackedSKIN CRACKED AT BS 482B+14, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014111834254Skin · crackedSKIN CRACKED AT BS 400+15, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2014111434184Skin · crackedSKIN CRACKED AT BS 747+3, STRINGER 23L. REPAIRED SKIN IAW EA.SDR SWAA2014111234091Skin · crackedFUSELAGE SKIN CRACKED AT BS 927 + 13.75 STRINGER 21R. REPAIRED SKIN IAW EA.SDR ASOA2014102811527Skin · corrodedCORROSION FOUND BETWEEN BS 295 - 310 STRINGER 27 AROUND BASE OF ANTENNA. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. DOUBLER AT TCAS DETERMINED OUT OF LIMITS IAW SRM 53-21-01-101-002-A01. INSTALLED NEW TCAS LOWER CHANNEL AFTER REMOVING OLD TCAS LOWER DSDR SWAA2014102233226Skin · corrodedFUSELAGE SKIN CORRODED BETWEEN BS 747 TO 767 BETWEEN STRINGER 27R TO 27L. REPAIRED SKIN IAW EA.SDR REXA2014100100894Skin · dentedDENT WAS NOTED IN THE FUSELAGE SKIN BETWEEN FS 582 & FS 588 STRINGER 20L & 21L MEASURING 6 INCHES X 1 INCH X 0.010 INCHES DEEP. REPAIRED IAW EA CRJ253-02952.SDR AALA20140927003Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 888 TO 1016 BETWEEN STRINGERS 22 TO 26 LT. REMOVED CORROSION & REPLACED RIVETS IAW EA B737-53-036749.SDR CALA2014092992336Doubler · corrodedAFT LT EXTERNAL FUSELAGE SKIN REPAIR DOUBLER AT BS 1832.9 TO 1847.9 IS GOUGED. FOUND EXISTING DOUBLER TO BE OUT OF LIMITS. REMOVED REPAIR DOUBLER, FABRICATED A NEW DOUBLER & FILLER. INSTALLED IAW SRM 53-80-01.SDR CALA2014092901288Skin · mechanic errorWHILE ACCOMPLISHING EA 5310-04848 3 HOLES ON DOUBLER AT FS 727 D STRINGER 3R DRILLED WITH NO EDGE DISTANCE FROM CHEM-MIL. ACCOMPLISHED THE INTERIM IAW REPAIR ECRA 5310-06248 PART 1. NEED TO ACCOMPLISH A PERMANENT REPAIR ON OR BEFORE 16 SEP 2015. PLANNING TOSDR CALA2014092901287Skin · mechanic errorWHILE ACCOMPLISHING EA 5310-05702 4 EA HOLE ON DOUBLER AT FS 727C STRINGER 2L DRILLED WITH NO EDGE DISTANCE CHEM-MIL ACCOMPLISHED THE INTERIM REPAIR ECRA 5310-06248 PART 1. WILL NEED TO ACCOMPLISH A PERMANENT REPAIR ON OR BEFORE 16 SEPT 2015. PLANNING TO CONSDR FDEA201409262805Skin · corrodedTOILET SERVICE PANEL LOWER CUT OUT FUSE SKIN CORRODED. REMOVED CORROSION IAW SRM 51-74-10. HFEC IAW NTM 51-10-08. NO CRACK FOUND. REPAIRED IAW SRM 51-21-10 & SRM 51-40-21. REPAIR CATEGORY IS A. MAJOR REPAIR IAW GMM 6-2-100.SDR SWAA2014102233227Skin · crackedSKIN CRACKED AT BS 381 STRINGER 14L. REPAIRED SKIN IAW EA.SDR SWIA201439533Skin · dentedBELOW AFT CARGO DOOR IS DENTED, APPROX 12" DOWN, NEAR BS 605. C-CHECK, REPAIRED DENT APPROXIMATELY 12" BELOW CARGO DOOR NEAR FS 605.00 IAW REO.
Back to JASC 5330