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 FDEA201412024036Skin · damagedDOOR 1 RT, FUSELAGE EXTERIOR SKIN BELOW LOWER SILL, STRINGER 17R, APPROX STATION 345, FASTENER HEAD FOUND PARTIALLY DRILLED.SDR FDEA201412024027Skin · damagedFOUND SCRIBE LINE IN LAP SEAM AT STRINGER 26L FROM BS 661 TO 720 WITH CORROSION ON TOP OF SCRIBE LINE. REPAIRED IAW EA F-5330-T0313764. MAJOR REPAIR.SDR DALA2016111008682Skin · corrodedGENERAL SURFACE CORROSION ON FWD CABIN PRESSURE SAFETY VALVE FUSELAGE SKIN. PRESSURE VALVE COLLAR WAS REPLACED IAW DWG 591657555-5 REV.E. AND SRM 51-30-1 & 51-30-2 FWD CABIN PRESSURE SAFETY VALVE WAS REMOVED, INSTALLED, AND TESTED IAW AMM 21-32-07. (UT) WAS ASDR SWIA201440556Skin · corrodedFUSELAGE SKIN AROUND AVIONICS BAY DOOR OPENING HAS CORROSION AT FWD AND AFT ENDS AT DOOR SEAL INTERFACE. REMOVED CORROSION IAW REO.SDR SWIA201440394Skin · dentedFS 265, SKIN DENTED. REPAIRED THE SKIN BETWEEN STR 14 - 15R IAW EA.SDR SWAA2014121635050Skin · crackedFUSELAGE SKIN CRACKED AT BS 380+3, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2014121635049Skin · crackedFUSELAGE SKIN CRACKED AT BS 867+4, STRINGER 23R. REPAIRED SKIN IAW EA.SDR SWAA2014121034910Skin · crackedFUSELAGE SKIN THIRD ROW CRACKED AT BS 540, STRINGER 22L AFT HOLE. REPAIRED SKIN IAW EA.SDR SWAA2014121034909Skin · crackedFUSELAGE SKIN SECOND ROW CRACKED AT BS 540, STRINGER 22L AFT HOLE. REPAIRED SKIN IAW EA.SDR SWAA2014121034899Skin · crackedFUSELAGE SKIN CRACKED AT BS 400+14, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2014121034896Skin · crackedFUSELAGE SKIN CRACKED AT BS 520 - 3, STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014120934861Skin · crackedNUMBER 1 RT COCKPIT WINDOW SKIN CRACKED BETWEEN TWO FASTENER HOLES AT LOWER INBD CORNER. REPAIRED SKIN IAW ACO.SDR SWAA2014120934851Skin · crackedSKIN CRACKED AT BS 380+15, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014120334644Post · crackedLEFT NR 3 WINDOW FRAME EF POST CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014120334643Post · crackedRIGHT NR 3 WINDOW FRAME EF POST CRACKED. REPAIRED POST IAW ACO.SDR SIMA20141201005Skin · crackedDURING MBV INSPECTION, QA FOUND LT UPPER FUSELAGE SKIN WITH 2 CRACKS AT FRAME 75 BETWEEN STRINGERS 1L & 3L. ACFT WAS REMOVED FROM SERVICE FOR MBV INSPECTION & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. PERFORMED PERMANENT REPAIR TO FUSELAGE SKIN AT FRASDR SIMA20141201004Skin · crackedDURING MBV INSPECTION, QA FOUND RT UPPER FUSELAGE SKIN WITH 3 CRACKS AT FRAME 75 BETWEEN STRINGERS 1R & 3R. ACFT WAS REMOVED FROM SERVICE FOR MBV INSPECTION & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. PERFORMED PERMANENT REPAIR TO FUSELAGE SKIN AT FRSDR GLBA2014120100472Skin · corrodedDURING A SCHEDULED INSPECTION, FOUND BELLY SKIN CORROSION & A CRACK AT BS 228.25 BETWEEN STRINGER 15 - 16R, .3 INCHES IN LENGTH. REPAIRED IAW EO 14-1900-53-048. MAJOR REPAIR.SDR GLBA2014120100471Skin · corrodedMAJOR REPAIR DURING A SCHEDULED INSPECTION FOUND A CORRODED AREA APPROX 4 INCHES BY 3 INCHES AT FS 213.25 & STRINGER 16. DURING A SCHEDULED INSPECTION MX FOUND A CORRODED AREA APPROX 4 INCHES BY 3 INCHES AT FS 213.25 & STRINGER 16. REPAIRED IAW EO 14-1900-53SDR FDEA201412013996Skin · damagedFUSELAGE EXTERIOR SKIN THERE ARE NUMEROUS NICKS & SCRATCHES BETWEEN STRINGER 26L & 26R BS 600 T0 620. NICKS & SCRATCHES REMOVED, FOUND OUT OF LIMITS AT IAW SRM 53-00-01 FIG 101 DETAIL II REV 113. REPAIRED IAW SRM 53-00-01 FIG 201 REPAIR 15 RVE 113. REPAIR SDR SWIA201440499Skin · dentedONE DENT BS 654.5 - 672.2 S18-21L. COLDWORKED DENT TO ORIGINAL CONTOUR IAW EA.SDR SWAA2015010535469Doubler · crackedFUSELAGE INTERNAL SKIN DOUBLER CRACKED AT STATION 227.8 TO 235.8, WL 207. 5 RT SIDE. REPAIRED SKIN IAW EA.SDR SWAA2014121034895Skin · crackedFUSELAGE SKIN CRACKED AT BS 908-2, STRINGER 4R. REPAIRED SKIN IAW EA.SDR SWAA2014120934850Skin · crackedFUSELAGE SKIN CRACKED AT BS 908-2, BETWEEN STRINGER 3L TO 4L. REPAIRED SKIN IAW EA.SDR SWAA2014120834755Skin · crackedFUSELAGE SKIN CRACKED AT BS 360+2, BETWEEN STRINGER 1 TO 2L. REPAIRED SKIN IAW SRM.SDR R61A201411301218Skin · dentedDURING CHECK, DENT IN FUSELAGE SKIN FRAMES 10-11 BETWEEN STRINGER 18-19L WAS REPAIRED IAW ETD2014-170-100869, REV A AND SRM 53-10-01/200,SDR DALA2014113006339Skin · crackedFAILSAFE AND SKIN LAYERS SHOW CRACK INDICATIONS. REPAIRED IAW ERA 530652-14AD, REV ORIGINAL.SDR DALA2014112806395Skin · damagedLIGHTNING STRIKE AT BS 654+104 JUST ABOVE STRINGER 36L. BLENDED THE AREA AND FOUND IT TO BE OUT OF LIMITS IAW SRM 53-00-01.SDR DALA2014112806394Skin · damagedLIGHTNING STRIKE AT FASTENER BS 525, STRINGER 11L. REMOVED FASTENER. INSTALLED TEMPORARY BLIND FASTENER IAW SRM 53-00-01.SDR FDEA201411283960Skin · burnedSUSPECT LIGHTNING STRIKE TO 5 FASTENERS AT STATION 500 STRINGER 26LT. LIGHTNING STRIKE DAMAGE AT 5 FASTENERS REPAIRED IAW EA F-5330-T0313473.SDR FDEA201411283959Skin · burnedLIGHTNING STRIKE, AT 1360 - 1380 STRINGER 21 - 22, IN POCKET REPAIR IAW SRM 53-00-01. REPAIR 6 IS RESTRICTED BY RVSM REQUIREMENTS 51.10.01 FIG 7 & 53-00-01 FIG 201.SDR FDEA201411273918Skin · chafedFORWARD CARGO DOOR CUT OUT BS 1009 LONGERON 40 - 42 RT, FOUND CHAFED. REPAIRED IAW EA 1-5330-T0313796 PART 1. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100.SDR ASOA2014122311945Skin · damagedAFT DRAIN MAST AFT AT MOUNT IN FUSELAGE IS DAMAGED. REPAIRED IAW REO 670-53-61-1108.SDR GLBA2014112600470Skin · crackedMAJOR REPAIR DURING A SCHEDULED INSPECTION FOUND A CRACK IN THE LT SIDE BELLY SKIN AT BL 29.06 & WING SPAR, .5 INCHES IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 14-1900-53-047.SDR DALA2014113006399Skin · damagedLIGHTNING STRIKE, BS 654+121 STRINGER 6L. DRILLED OUT DAMAGE IAW SRM 53-00-01.SDR DALA2014113006398Skin · damagedLIGHTNING STRIKE BS 830 AT STRINGER 5L. DRILLED OUT DAMAGE IAW SRM 53-00-01, REPAIR 8.SDR DALA2014113006397Skin · damagedLIGHTNING STRIKE BS 818 STRINGER 5L. DRILLED OUT DAMAGE IAW SRM 53-00-01 REPAIR 8.SDR DALA2014113006396Skin · damagedLIGHTNING STRIKE, BS 730 STRINGER 5L. DRILLED OUT DAMAGE IAW SRM 53-00-01. REPAIR 8.SDR FDEA201411253894Skin · dentedFUSELAGE HAS A DENT AT BS 525 BETWEEN STRINGERS 26 - 27L. REPAIRED IAW EA F-5330-T0313598 REV P1. MAJOR REPAIR.SDR SWAA2014120934855Skin · crackedLEFT BS 887+10 UPPER AFT WINDOW CORNER SKIN CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR SWAA2014120834788Skin · crackedLEFT BS 787+10 LOWER FWD WINDOW CORNER SKIN CRACKED AT HOLE NR 10. R & R SKIN IAW EA.SDR SWAA2014120834826Skin · crackedLEFT LOWER BULKHEAD SKIN CHORD CRACKED AT BS 540, STRINGER 22L FROM AFT HOLE AT 6 O'CLOCK POSITION. REPAIRED SKIN IAW EA.SDR SWAA2014120834825Skin · crackedLEFT LOWER BULKHEAD SKIN CHORD CRACKED AT BS 540, STRINGER 22L FROM FWD FASTENER 2 ROWS AT 3 & 9 O'CLOCK POSITION. REPAIRED SKIN IAW EA.SDR SWAA2014120534729Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SIMA20141125017Skin Panel · crackedUPPER FRAME 77 LT SIDE OF VERTICAL STAB HAS TWO RIVETS WITH SKIN CRACKS. UPPER FRAME 78 LT SIDE VERTICAL STAB HAS ONE RIVET WITH SKIN CRACK. REPAIRED SKIN AT FRAME 77 TWO EACH RIVETS HOLES IAW ERS EM-5300-912 & FABRICATED ONE EACH REPAIR BUSHING FOR UPPER FRSDR SIMA20141125016Skin Panel · crackedUPPER FRAME 78 RT SIDE VERTICAL STAB HAS 1 RIVET WITH SKIN CRACK. UPPER FRAME 77 RT SIDE VERTICAL STAB HAS 1 RIVET WITH SKIN CRACK. UPPER FRAME 78 SKIN CRACK REPAIRED AS REQUIRED IAW ERS -EM-5300-898 & UPPER FRAME 77 SKIN CRACK REPAIRED AS REQUIRED IAW ERS-ESDR QXEA2014120100936Skin · damagedFOUND TWO LIGHTNING STRIKES MIDWAY ON FUSELAGE SKIN BETWEEN BS 47.975 AND 71.200 STR 32R . BLENDED AND REMOVED IAW SRM 53-20-31, REPAIR-01. COMPLIED WITH ET INSPECTION & UT THICK TEST ON AREAS IAW NDTM PT1 51-00-06 & 51-00-04. NO DEFECTS NOTED. FOUND TO BESDR SIMA20141125013Skin · crackedFRAME 75 SKIN CRACKED AT FASTENER HOLE, BELOW STRINGER 2R - 2L. FABRICATED & DRILLED DOUBLER, FILLER & REPAIR ANGLE FOR FRAME 75 SKIN DAMAGE AT STRINGER 2R - 2L IAW ERS-EM-53MR-901.SDR DALA2014112706323Skin · corrodedCORROSION ON FUSELAGE SKIN BS 1096 - 1100 BETWEEN LONGERONS 25 - 30L. REPAIRED IAW SRM 53-04, FIG 57.SDR TSAA20141128048Skin · crackedDISCOVERED 1.25 INCH SKIN CRACK APPROX 2 INCHES FWD OF BS 540 BETWEEN STRINGER 1 & 2L. REPAIRED IAW SRM 53-30-3 FIG 48 DETAIL XXIII PROCEDURE III & VII.
Back to JASC 5330