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 SWAA2014101432925Skin · crackedSKIN CRACKED AT BS 540 STRINGER 22L. REPAIRED SKIN IAW EA.SDR SIMA20141008019Skin · dentedHAIL DAMAGE EVENT. REPLACE FWD FUSELAGE I SKIN LT FWD. R & R FWD FUSELAGE I LT FWD SKIN IAW SRM 53-11-01, 51-40-02 03 06 08, ETN-EM-53-235 & ETN-EM-51-11.SDR SIMA20141008023Skin · dentedHAIL DAMAGE EVENT. REPLACE FWD FUSELAGE I SKIN RT FWD. R & R FWD FUSELAGE I RT FWD SKIN IAW SRM 53-11-01, 51-40-02 03 06 08, ETN- EM-53-235 & ETN-EM-51-118.SDR SIMA20141008022Skin · dentedHAIL DAMAGE EVENT. REPLACE RT CTR FUSELAGE I. R & R RT CTR FUSELAGE I SKIN IAW SRM 53-21-01-SI, 51-20-01 03, 51-40-02 03 06 08, ETN-EM-53-262 & ETN-EM-51-118.SDR SIMA20141008021Skin · dentedHAIL DAMAGE EVENT. REPLACE FWD FUSELAGE II SKIN CROWN. R & R FWD FUSELAGE II SKIN CROWN IAW SRM 51-20-01 03, 51-40-02 03 04 06 08, 53-12-01, ETN EM-53-206 & EM-51-118.SDR SIMA20141008020Skin · dentedHAIL DAMAGE EVENT. REPLACE CTR FUSELAGE II TOP SKIN. R & R CTR FUSELAGE II SKIN TOP IAW SRM 51-20-01 03, 51-40-02 03 04 06 08, 53-22-01 SI & ETNS EM 51-118 & EM-53-263.SDR SIMA20141008017Skin · dentedHAIL DAMAGE EVENT. REPLACE FWD FUSELAGE II SKIN WIPER. R & R FWD FUSELAGE II SKIN WIPER PANEL IAW SRM 51-20-01, 51-20-03, 51-40-02, 51-40-06, 53-12-01 ETN-EM-51-118 & ETN-EM-53-206.SDR SIMA20141008018Skin · dentedHAIL DAMAGE EVENT. REPLACE FWD FUSELAGE I SKIN RT AFT. R & R FWD FUSELAGE I SKIN RT AFT IAW SRM 53-11-01, 51-20-01/03, 51-40-02 03/06/08 & ETN-EM-53-235 & ETN-EM-51-118.SDR SIMA20141008015Skin · dentedHAIL DAMAGE EVENT. REPLACE CTR FUSELAGE IV TOP SKIN. R & R CTR FUSELAGE IV TOP SKIN IAW SRM 53-24-01, 51-20-01 03, 51-40--02/03/06/08 & ETN'S EM-51-118 & EM-53-265.SDR SIMA20141008016Skin · dentedHAIL DAMAGE EVENT. REPLACE FWD FUSELAGE I SKIN LT AFT. R & R FWD FUSELAGE I SKIN LT AFT IAW SRM 53-11-01, 51-20-01 03, 51-40-02 03/06/08 & ETN-EM-53-235 & ETN-EM-51-118.SDR SIMA20141008014Skin · dentedHAIL DAMAGE EVENT. REPLACE REAR FUSELAGE I SKIN. R & R REAR FUSELAGE I TOP FWD SKIN IAW SRM 51-20-01, 51-20-03, 51-40-02, 51-40-06, 53-31-01, ETN-EM-51-118 & ETN-EM-53-266.SDR SIMA20141008013Skin · dentedHAIL DAMAGE EVENT. REPLACE CTR FUSELAGE II LT SKIN. R & R CTR FUSELAGE II LT SKIN IAW SRM 53-22-01, 51-20-01 03 & 51-40-020 3/06/08 & ETN-EM-53-263 & ETN-EM-51-118.SDR SWAA2014102333343Skin · crackedSKIN CRACKED AT BS 540 STRINGER 22R HOLE F. REPAIRED SKIN IAW SRM.SDR SWAA2014102333342Skin · crackedSKIN CRACKED AT BS 540 STRINGER 22R HOLE B. REPAIRED SKIN IAW SRM.SDR SWAA2014101733125Skin · crackedLEFT NR 3 WINDOW FRAME SKIN CUT OUT CRACKED LOWER FASTENER HOLE. REPAIRED SKIN IAW EA.SDR SWAA2014101733126Skin · crackedRIGHT NR 3 WINDOW FRAME SKIN CUT OUT CRACKED AT SECOND LOWER FASTENER HOLE. REPAIRED SKIN IAW EA.SDR SIMA20141008009Skin · crackedLEFT AFT FUSELAGE SKIN AT FRAME 75 STRINGER 2 UPPER & LOWER AREA HAS CRACKS MARKED. ACCOMPLISHED REPAIR OF LT REAR FUSELAGE I SKIN IAW ERS-EM-53MR-789.SDR SIMA20141008005Skin · crackedDURING MBV INSPECTION, QA FOUND LT UPPER FUSELAGE SKIN CRACKED JUST AFT OF FRAME 75 & ABOVE STRINGER 2L. ACFT WAS REMOVED FROM SERVICE FOR MBV INSPECTION & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. PERFORMED PERMANENT REPAIR IAW ERS-EM-53MR-788. REPASDR FDEA201410083011Skin · corrodedFOUND CORROSION ON FUSELAGE SKIN RUNNING UNDER LAP SEAM AT STRINGER 4L FROM BS 1320 TO 1360 & FROM BS 1400 TO 1460 REQUIRING ADDITIONAL STRIPPING FROM BS 1180 TO 1460. ACCOMPLISHED EA F-5330-T0312157 FUSELAGE PLATES & SKINS CORROSION REPAIR TRACKING STRINGER SDR SWAA2014112434422Skin · damagedLEFT FUSELAGE SKIN DAMAGED AT STATION 304.5, WL 238. REPAIRED SKIN IAW EA & EO.SDR FDEA201410072992Skin · damagedFUSELAGE SKIN HAD NUMEROUS NICKS & SCRATCHES BETWEEN STRINGER 26 LT & 26 RT AT BS 580- 600. DAMAGE REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-00-01 FIG 101 DETAIL II REV 113 AND REPAIRED IAW EA F-5330-T0312729 PART 1. REPAIR CLASSIFIED AS MAJOR.SDR SWAA2014110633848Skin · crackedSKIN CRACKED AT BS 360 STRINGER 3R. REPAIRED SKIN IAW AAR & EA.SDR SWAA2014102333344Skin · crackedSKIN CRACKED AT BS 540 STRINGER 22L HOLE B. REPAIRED SKIN IAW SRM.SDR CALA2014102192527Skin · dentedDENT AT STATION 1705 BETWEEN STRINGER 17L & 18L. REPAIRED IAW SRM 53-00-01 FIG 201 REPAIR 3.SDR FDEA201410072997Skin · damagedFUSELAGE SKIN HAD NUMEROUS NICKS & SCRATCHES BETWEEN STRINGER 26L & 26R BETWEEN BS 1701 - 1720. DAMAGE REMOVED AND TREATED IAW SRM 51-10-02 REV 112. FOUND ONE SPOT OUT OF LIMITS IAW SRM 53-00-01 FIG 101 DETAIL II ALLOWABLE DAMAGE 1 REV 112, REPAIRED OUT OF LISDR AALA20141007005Skin · corrodedCORROSION ON FUSELAGE SKIN AROUND AFT LAVATORY AREA. REMOVED CORROSION & REINSTALLED AFFECTED FASTENERS.SDR AALA20141007004Skin · corrodedCORROSION ON FUSELAGE SKIN AROUND ONE FASTENER AT STATION 910 BELOW STRINGER 25 LT. REMOVED LIGHT SURFACE CORROSION IAW SRM 51-10-02 & INSTALLED ONE FASTENER IAW SRM 51-40-02 & EA B737-53-036873.SDR REXA2014101300896Skin · dentedDENT IN THE FUSELAGE SKIN AT FS 598 AT THE SKIN SPLICE AT STRINGER 20L. THE DENT MEASURES 1 INCH X 0.63 INCH X 0.017 INCHES DEEP. REPAIRED IAW EA CRJ253-02971.SDR REXA2014101300895Skin · damagedLIGHTNING STRIKE DAMAGE TO THE FUSELAGE SKIN & A FASTENER COMMON TO THE FRAME AT FS 364 BETWEEN STRINGER 22L & 23L MEASURING 0.093 INCHES X 0.062 INCHES X 0.055 INCHES DEEP. REPAIRED IAW EA.SDR DALA2014100705418Skin · damagedFOUND LIGHTNING STRIKE AT BS 1480 AND STR 36R DURING WALK AROUND. REPAIRED IAW SRM 53-00-01, REPAIR 12.SDR SWAA2014110533753Skin · crackedAFT CARGO DOOR CUT OUT FWD LOWER CORNER FUSELAGE SKIN CRACKED FROM FASTENER TOWARDS SKIN EDGE. REPAIRED CUT OUT IAW SRM.SDR SIMA20141006011Skin · crackedEXTERNAL LT FUSELAGE SKIN CRACKED AROUND RIVET FRAME 79 MARKED. REPAIRED IAW ERS EM-5300-808.SDR SIMA20141006010Skin · crackedEXTERNAL LT FUSELAGE SKIN CRACKED AROUND RIVET FRAME 78 MARKED. REPAIRED EXTERNAL LT FUSELAGE SKIN CRACK AROUND RIVET AT FRAME 78 IAW ERS EM-5300-808.SDR SIMA20141006009Skin · crackedEXTERNAL RT FUSELAGE SKIN CRACKED AROUND RIVET FRAME 78 MARKED. REPAIRED EXTERNAL RT FUSELAGE SKIN CRACK AROUND RIVET AT FRAME 78 IAW ERS EM-5300-803.SDR SIMA20141006008Skin · crackedEXTERNAL RT FUSELAGE SKIN CRACKED AROUND RIVET FRAME 79 MARKED. REPAIRED EXTERNAL RT FUSELAGE SKIN CRACK AROUND RIVET AT FRAME 79 IAW EM-5300-804.SDR FDEA201410062984Skin · crackedLOWER FUSELAGE SKIN AT BS 1156 CRACKED. REPAIR IAW EA 8-5310-T0312350 PART 1. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR AALA20141015003Skin · dentedDENT AT STATION 1330 BETWEEN STRINGER 32 & 33 LT WITH GOUGE. INSTALLED DOUBLER IAW SRM 53-00-01-2R-29.SDR DALA2014100705583Skin · crackedFUSELAGE SKIN CRACKED AT BS 1475, LONGERON 2R. REPAIRED IAW PRI 529605-14, REV O.SDR DALA2014100705582Skin · crackedFUSELAGE SKIN CRACKED AT FASTENER AT BS 1475, LONGERON 2L. REPAIRED IAW SRM 53-30-01, RIG 14.SDR DALA2014100605476Skin · damagedLIGHTNING STRIKE ON SKIN BS 654+44 AND TWO INCHES BELOW S24R. REPAIRED IAW SRM 53-00-01.SDR DALA2014100605475Skin · damagedLIGHTNING STRIKE ON SKIN AT BS 721 S24R. REPAIRED IAW SRM 53-00-01.SDR ASOA2014100911396Skin · damagedDENT WITH SCRATCH IN FUSELAGE BETWEEN WINDOWS 10 AND 11 ON LT SIDE. DAMAGE FOUND TO BE BETWEEN F/S 669.40 AND F/S 677 AND BETWEEN STRINGERS 10L AND 11L. THIS IS IN A NO DAMAGE ALLOWED AREA IAW SRM 53-41-01. DENT WITH GOUGE MEASURES 2.4" X 1.5" X .040". THISSDR ASOA2014100911394Skin · dentedFUSELAGE SKIN DENTED RT SIDE BS 437 - 453, STRINGERS 17 - 18R. REPAIRED IAW SRM 53-00-01, FIGURE 53-00-01-991-808 SHEET 2. MAJOR REPAIR.SDR IPXA2014100884535Skin · dentedDAMAGE TO FUSELAGE SKIN FRAME 28 FOUR INCHES BELOW S8R. REPAIRED IAW EO A300-5330-54549-B.SDR SWAA2014112634473Skin · crackedFUSELAGE SKIN CRACKED AT STATION 540, STRINGER 22L. REPAIRED SKIN IAW EA.SDR SWAA2014100932837Post · crackedLEFT NR 1 FLIGHT DECK WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED POST IAW EA.SDR SWAA2014100932836Post · crackedLEFT NR 3 FLIGHT DECK WINDOW FRAME E - F POST CRACKED AT FASTENER HOLE 2ND FROM THE BOTTOM. REPAIRED POST IAW EA.SDR SWAA2014100932835Post · crackedRIGHT NR 3 FLIGHT DECK WINDOW FRAME E - F POST CRACKED AT FASTENER HOLE 3RD FROM THE BOTTOM. REPAIRED POST IAW EA.SDR SWAA2014100932834Post · crackedRIGHT NR 3 FLIGHT DECK WINDOW FRAME E - F POST CRACKED AT FASTENER HOLE 2ND FROM THE BOTTOM. REPAIRED POST IAW EA.SDR SWAA2014100832775Post · crackedLEFT NR 3 FLIGHT DECK WINDOW FRAME E - F POST FASTENER HOLE 4TH FROM THE BOTTOM CRACKED. REPAIRED POST IAW ACO & SRM.
Back to JASC 5330