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 QXEA200600142Skin · corrodedPDX: RT FUSELAGE SKIN HAS LIGHT FRETTING CORROSION AROUND MOUNTING SCREW HOLE FOR RT STRAKE AT FS X529 (UPPER HOLE). MAINTENANCE REPAIRED IAW RD 8/4-53-666, Q400 SRM 51-21-10 AND SRM 51-25-10.SDR QXEA200600141Skin · corrodedPDX: FOUND RT FUSELAGE SKIN HAS LIGHT FRETTING CORROSION AROUND MOUNTING SCREW HOLES (2) FOR RT STRAKE AT FS X564. MAINTENANCE REPAIRED IAW RD 8/4-53-666, NDTM PART 6, 51-00-02 AND NDTM PART 1, 51-00-04, Q400 SRM 51-21-10 AND SRM 51-25-10.SDR 2006UALA00068Skin · dentedFWD FUSELAGE IS DENTED 24 INCHES BELOW CAPTAINS SLIDING WINDOW. INSTALLED DOUBLER PER SRM 53-00-11.SDR 2006UALA00056Skin · damagedFOUND DAMAGE APPROX 4 FEET AFT OF AFT CARGO DOOR AT STA 29896-FR63 BETWEEN STRINGERS 39R AND 41R. MAJOR REPAIR. REPAIRED STR 39R BETWEEN FR 62 & 63 PER SRM 53-00-13 FIG201. INSTALLED SKIN DOUBLER REPAIR PER SRM 53- 00-11 FIG 209 & 211.SDR USAA060017Skin · crackedFOUND CRACK BS 727E AT S-24R. INSTALLED DOUBLER AND TRIPLER IAW EA 97249.SDR USAA0617Skin · crackedBS 727E AT S-24R CRACKED. INSTALLED DOUBLER AND TRIPLER IAW EA 97249.SDR 06FDEA0140Skin · chafedUPON REMOVAL OF APU FOUND RT DELTA KEEL BEAM SKIN CHAFED AT BS 874 INBOARD OF APU FLOW CONTROL VALVE. REMOVED AND REPLACED R/H DELTA BEAM SKIN AT BS 874 I/B OF APU FLOW CONTROL IAW SRM 53-30-01, SRM 53-10-02 AND SRM 53-30-02.SDR SWAA060127Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT AIR COND, GROUND SERVICE DOOR CUTOUT, RT FWD CORNER, BS 520, STR 28R. REPAIRED SKIN PER SWA EA.SDR SWAA060128Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 769 AND BS 782, STR 18L. REPAIRED SKIN PER SWA EA.SDR PIDA06005Skin · crackedCRACK IN FUSELAGE SKIN AT BS 500A ABOVE STR 4 LT SKIN LAP JOINT. REPAIRED DAMAGE PER SRM 53-00-01.SDR USAA0517Skin · crackedBS 727E AT S-24R CRACKED. INSTALLED DOUBLER AND TRIPLER IAW EA 97249, DEFECT SIZE: 2.4 INCH.SDR SWAA060125Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 494 TO BS 496, STR 10R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA060124Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 501D TO BS 503D, STR 12L. REPAIRED SKIN PER SWA EA.SDR 2006UALA00218Skin · dentedA 2 INCH GOUGE AND DENT AT DOOR 3L, 2 FEET AFT AND BELOW DOOR AT STA 1700. INSTALLED REPAIR DOUBLER PER SRM 53-00-01.SDR DHL2006763502Skin · crackedS/O 284007 N/R 031777 - CRACK IN L-1 DOOR UPPER HINGE CUTOUT IN FUSELAGE SKIN .300" LENGTH , FWD LOWER CORNER, CONFIRMED 10X VISUAL BS 303.7. CUT OUT CRACKED SECTION, FABRICATED AND INSTALLED DOUBLER REPAIR 16.5" X 5.4" FROM 301-1/2 HARD .063" AND 6.5" X 6.5"SDR 06FDEA0108Skin · damagedBS 492- BS 500, RBL 15, WL 150, STR 27R GRAVEL DAMAGE COMMON TO BELLY SKIN BS 492 TO BS 500, STR 27R. *S/D* REPAIRED DAMAGE ON SKIN BS 492 - BS 500 RBL 15 WL 150 STR 27R IAW SRM 53-30-3.SDR 06FDEA0130Skin · corrodedWHILE WORKING CARD N00378 FOUND CORROSION ON SKIN AT BS 680 TO BS 700 BETWEEN STR 2R AND 3L. *S/D* COMPLIED WITH FED EX EA 7-5330-91435.SDR QXEA200600073Skin · corrodedPDX: CORROSION A/C SKIN UNDER LAVATORY DRAIN MAST. MAINTENANCE REPAIRED IAW Q400 SRM 51-21-00, NDTM PART 6, 51-00-02, SRM 51-21-10 PG 201-205 AND SRM 51-25-10 PG 201-205.SDR SWAA060103Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 578, STR 10R. REPAIRED SKIN PER SRM.SDR DL738060027Skin · dentedTHE FUSELAGE SKIN AT BS 469 BETWEEN S-19R AND S-20R WAS DENTED AND GOUGED. DENT WAS APPROXIMATELY 1 INCH DIA. REPAIRED BY INSTALLING A DOULBER PER ER/A 452385-14.SDR 06FDEA0067Doubler · debondedFOUND INTERNAL DOUBLER DISBONDED ON FUSELAGE SKIN AT B.L. 0, STRINGER 30 AT STA 700 TO STA 720. REMOVED AND REPLACED DOUBLER IAW SRM 53-30-3 AND SRM 51-30-2.SDR SWAA060092Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 504D, STR 16L. REPAIRED SKIN IAW SRM.SDR SWAA060091Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 740E, STR 23L. REPAIRED SKIN IAW SWA EA.SDR SWAA060090Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA060089Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765, BETWEEN STR 19R TO STR 20R. REPAIRED SKIN IAW EA AND SRM.SDR SWAA060088Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER HINGE CUTOUT, FWD UPPER CORNER. REPAIRED SKIN IAW SWA EA AND SRM.SDR ASAA0640012Skin · dentedFUSELAGE SKIN DENTED AT BSTA 995 BETWEEN STRINGER 13-14 LT. REMOVED SKIN AT BSTA 986.5-1016, STRINGER 10-14 LT, FABRICATED AND INSTALLED REPLACEMENT SKIN IAW DWG AND SRM. (K)SDR AMTA200600013Skin · corrodedLOWER FUSELAGE STRINGERS S32, S33, S34, S35 INNER SKIN FOUND WITH CORROSION FROM FS 235 TO FS 251. DISCREPANCY IS FOR S33 ONLY. REPAIRED S33 FS 235 TO FS 274 IAW L1011 53-13-00 FIG 804 SHEET 2 SRM. (M)SDR 06FDEA0064Skin · dentedLT FUSELAGE SKIN 20" AFT OF AFT PIT DOOR HAS 3 EACH DENTS FS1975-1986, LONGERON 37L-38L. REPAIRED FUSELAGE SKIN IAW DC10 SRM 53-20-00 VOL II. SEE FEDEX SNRM N00137 OF WORK ORDER 00031297.SDR SWAA060072Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 794, STR 19L. REPAIRED SKIN PER SRM.SDR UPS06845925Skin · corrodedFUSELAGE HAS A BULGED AREA 25" FWD OF PIT 31 LWR FWD CORNER MARKED AND ADVISED BY MX. GAINED ACCESS TO THE BACKSIDE OF AREA NO CORROSION OR DEFECTS FOUND AT THIS TIME AS PER SRM 51-1-0. OK FOR SERVICE, AREA FOUND TO BE FREE AND SMOOTH.SDR ASAA0610001Frame · dentedDENT IN FUSELAGE SKIN AT BSTA 927-947.5 BETWEEN STRINGERS 18 AND 19 LT. REPAIRED IAW SRM. (K)SDR ASAA0610002Skin · cracked1.5 INCH CRACK IN FUSELAGE LT SIDE, BSTA 727B-747 JUST BELOW BLUE PAINT LINE 32 INCHES BELOW WINDOW. (S16L) REPAIRED IAW SRM. (K)SDR ASOA06024Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE DOUBLER AT FS 470-477, RBL 44-37. (M)SDR ASOA06025Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE DOUBLER AT FS 473-477, LBL 44-37. (M)SDR ASOA06026Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE DOUBLER AT FS 498-513, RBL 44-37. (M)SDR ASOA06027Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE DOUBLER AT FS 513-517, LBL 44-37. (M)SDR ASOA06028Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE DOUBLER AT FS 556-558, RBL 44-42. (M)SDR ASOA06029Finger Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE FINGER DOUBLERS AT FS 447-451, LBL AND RBL 44-42.SDR ASOA06030Finger Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE FINGER DOUBLERS AT FS 523-530, LBL AND RBL 44-42. (M)SDR ASOA06031Finger Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE FINGER DOUBLER AT FS 438-440, LBL 44-42. (M)SDR ASOA06032Finger Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE FINGER DOUBLER AT FS 460-462, LBL 44-42. (M)SDR ASOA06033Finger Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE FINGER DOUBLERS AT FS 483-485, LBL AND RBL 44-42. (M)SDR ASOA06034Finger Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE FINGER DOUBLERS AT FS 538-540, LBL 44-42. (M)SDR ASOA06037Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE ON THE DOUBLERS AT FS 543-545, LBL 44-42. (M)SDR ASOA06038Finger Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE FINGER DOUBLER AT FS 544, RBL 44-41. (M)SDR ASOA06036Finger Doubler · corrodedDURING A C-CHECK IN MCN, FOUND CORROSION ON THE FINGER DOUBLER AT FS 540, RBL 44-41. (M)SDR 0601027Skin · canningFUSELAGE SKIN SECTION REPAIRED DUE TO OIL CANNING.SDR 0601023Skin · dentedFUSELAGE SKIN SECTION REPAIRED DUE TO DENT OUT OF LIMITS.SDR 0601022Skin · dentedFUSELAGE SKIN SECTION REPAIRED DUE TO DENT OUT OF LIMITS.
Back to JASC 5330