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 QXEA200601225Skin · corrodedPDX - C3 FUSELAGE SKIN UNDER AFT WATER DRAIN MAST CORRODED AROUND CENTER LEFT HAND HOLE AND ALL RIGHT HAND HOLES APPROX STATION FS 1039.00. REPAIRED IAW SRM 51-20-004, EA R-53-449, AND SRM 51-25-01.SDR QXEA200601233Skin · lightning strikePDX - C3 2 LIGHTNING BURN MARKS ON SKIN AT FS 331 ON STRINGER 27. REPAIRED IAW SRM 51-25-01, SRM 51-12-00 AND EA R-53-450.SDR QXEA200601224Skin · scratchedPDX - C3 SCRATCHES IN FUSELAGE SKIN AROUND AND AT WATER DRAIN MAST, STATION FS 1039.0. REPAIRED IAW SRM 51-21-11, EA R-53-449, AND SRM 51-25-01.SDR UPS06246867Skin · crackedINSPECTION TYPE:C&SI ON REMOVAL OF FRAME AT BS 540 WEB SKIN AT 500-540 S18R HAS EVIDENCE OF MECHANICAL DAMAGE AND CRACKS. NEW WEB SKIN FABRICATED IAW SRM 51-20-01. NEW SKIN DRILLED OFF EXISTING HOLES IAW SRM 51-30-02 ALSO NUT PLATES INSTALLED AS REQ'D IAW SRSDR 2006UALA00902Skin · damagedFOUND UPPER FUSELAGE HAS A REWORKED DENT LOCATED AT STATION 767 + 18", STR 2R - 1.5".SDR 2006UALA00899Skin · dentedRT EXTERNAL FUSELAGE BS 440-460 BETWEEN STR 9R-8R HAS DENT.SDR 2006UALA00897Skin · crackedFUSELAGE SKIN CRACKED AT AFT ENTRY DOOR TORQUE TUBE TOP FWD CORNER STATION 947 STR 11L.SDR 2006UALA00896Bear Strap · dentedAFT CARGO DOOR SURROUND FWD EDGE, BARE STRAP HAS A DENT BETWEEN STR 22R AND 23R.SDR 06FDEA1723Skin · dentedEXTERIOR FUSELAGE BS 1148 BETWEEN STR 5R AND 6R, SKIN IS DENTED. FOUND DENT TO BE BEYOND LIMITS. REMOVED DAMAGE, FABRICATED REPAIR AND INSTALLED REF SRM 53-30-3.SDR SWAA061518Skin · crackedFUSELAGE SKIN CRACKED AT BS 747, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA061517Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 914, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA061516Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT BEAR STRAP. REPAIRED SKIN PER SRM.SDR 06FDEA1725Skin · chafedFUSELAGE SKIN CHAFED FROM BODY FAIRINGS BS 950D PLUS 10 BS 990 BTWN STR 27L AND 23L. REPAIRED CHAFFED SKIN IAW SRM 53-30-01.SDR USAA060656Skin · crackedFOUND SKIN CRACKED, BS 944 JUST ABOVE S-24L. INSTALLED DOUBLER, TRIPLER AND FILLER IAW SRM 53-00-01 REP 31, DEFECT SIZE: 2.250".SDR 2006UALA00887Skin · damagedAFT CARGO PIT SKIN AND BUTT SPLICE STRAP AT BS 907 STR 23R HAS ELONGATED FASTENER HOLE.SDR SWAA061515Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA061514Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA061504Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 506, STR 21R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061503Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 465, STR 16R. REPAIRED SKIN PER SWA EA AND SRM.SDR ASAA0640549Skin · dentedDENTS BETWEEN STRINGERS 25 AND 26 LH. CUT OUT DAMAGED AREA AND INSTALLED REPAIR IAW SRM 53 00 01 PAGE 232.SDR QXEA200601253Skin · damagedPDX - C3 FUSELAGE SKIN IS ABRADED AT FORWARD EDGE OF MAIN CABIN DOOR CUTOUT. REPAIRED IAW EA R-53-443 AND SRM 51-21-16.SDR 2006UALA00860Skin · crackedRT EXTERNAL FUSELAGE SKIN CRACKED AT FWD GALLEY DOOR CUTOUT LWR AFT CORNER AT BS 328 & WL 211.SDR 06FDEA1691Skin · gougedFOUND FUSELAGE SKIN GOUGED, BS 720D PLUS 12, STR 19L, MARKED. REPAIRED SKIN PER SRM 53-30-3 FIG 14.SDR 06FDEA1694Repair · misrepairedEXTERNAL DOUBLER AT BS 660, STR 30 REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF THE REPAIR WAS ACCOMPLISHED USING FAA APPROVED DATA. EXTERNAL DOUBLER AT BS 660, STR 30 WAS FOUND NOT TO BE ACCOMPLISHED IAW APPROVED DATA. REMOVED DOUBLER, REPAIRESDR SWAA061495Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941, STR 25R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061494Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 882, STR 25R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061493Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 385, STR 26L. REPAIRED SKIN PER SWA EA SRM.SDR SWAA061492Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 20L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA061491Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 739, STR 24R. REPAIRED SKIN PER SWA EA AND SRM.SDR 06FDEA1683Skin · dentedFUSELAGE - EXTERIOR SKIN WHILE CARRYING OUT REPETITIVE INSPECTION ON DENTED MARK AT STA 640 STRINGER 38L TO 39L FOUND REQUIRE REPAIR. FORWARD CARGO STA 640 STRINGER 38L TO 39L DENTED MARK CARRIED OUT REPAIR AS PER SRM 53-20-00 FIGURE 16 VOLUME I. REPAIR CLASSDR 06FDEA1682Skin · dentedFUSELAGE - EXTERIOR SKIN WHILE CARRYING OUT REPETITIVE INSPECTION ON DENTED MARK 3 FEET AFT OF CENTER CARGO DOOR FOUND REQUIRE REPAIR. THREE FEET AFT OF CENTER CARGO DOOR DENTED SKIN CARRIED OUT REPAIR AS PER SRM 53-20-00 FIGURE 6 VOLUME I. REPAIR CLASSIFIEDSDR USAA060651Skin · crackedFOUND SKIN CRACKED, STA 727E, STR 24L SRM REPAIR 53-00-01, DEFECT SIZE: 3".SDR 06FDEA1687Skin · chafedFOUND RIGHT HAND LOWER FUSELAGE OUTER SKIN HAVE MULTIPLE CHAFED DAMAGE APPROX BETWEEN STA 1100 TO STA 1175, AREA BETWEEN STA 1100 TO STA 1110 AND STA 1175 FOUND OUT OF LIMITS. CUT OUT DAMAGE, FABRICATED REPAIR PARTS IAW SRM 53-30-3 FIG 1 AND REINSTALLED ALL RSDR QXEA200601621Skin · tool damageYYC - C3 FUSELAGE EXTERNAL SKIN, AT STATION X373 AND STRINGER 23S HAS A TOOL MARK ADJACENT TO HI-LITE FASTENER. REPAIRED IAW RD 8/4-53-1462, ISSUE 1 AND EA 6-53-657.SDR QXEA200601620Skin · gougedYYC - C3 FUSELAGE EXTERNAL SKIN, AT STATION X373 AND STRINGER 23P HAS TOOL MARKS AND A GOUGE AROUND HI-LITE FASTENERS. REPAIRED IAW RD 8/4-53-1462 AND EA 6-53-657.SDR QXEA200601251Skin · corrodedPDX - C3 LOWER FUSELAGE SKIN HAS CORROSION ON MATING SURFACE FOR LOWER TCAS ANTENNA REPAIRED IAW EO 670-53-21-186 AND SRM 51-21-06.SDR QXEA200601240Skin · lightning strikePDX - C3 1 LIGHTNING BURN MARK ON SKIN AT FS 322.95 BETWEEN STRINGER 27 AND 26R. REPAIRED IAW SRM 51-25-01 AND SRM 51-21-11.SDR AWXA200600757Skin · corrodedDURING C19 CHECK DISCOVERED LEVEL 2 GALVANIC CORROSION ON THE AFT PIT DOOR CUT-OUT LOWER SIDE AT BS 815.5 BETWEEN STR 24R AND STR 25R. CORROSION WAS REMOVED AND RE-WORK WAS FOUND OUT OF LIMITS. MAINTENANCE CUT OUT DAMAGED IAW AMERICA WEST AIRLINES ENGINEERINSDR USAA060648Skin · crackedFOUND CRACK STA 944 JUST ABOVE 24L. FABRICATED REPAIR DOUBLER IAW EA 97676, SRM 53-00-01 REPAIR 31, DEFECT SIZE: 3".SDR 06FDEA1668Skin · chafedCTR CARGO DOOR CUTOUT AT AFT LWR SIDE FOUND CHAFED. REPAIR CARRIED OUT AT CTR CARGO DOOR CUTOUT AFT LWR SIDE CHAFFED AS PER SRM 53-50-00 VOLUME I FIGURE 16. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100.SDR 06FDEA1667Skin · chafedFWD CARGO DOOR CUTOUT AT FWD LWR SIDE FOUND CHAFED. DOOR CUTOUT AT FWD LWR SIDE CHAFE SMOOTHENED AS PER SRM 53-50-00 VOLUME I FIGURE 16. REPAIR CLASSIFIED AS MINOR AS PER GMM 6-2-100.SDR USAA200605001Skin · crackedFOUND 1.5" CRACK AT STA 33 LBL, LT SIDE OF MAIN WHEEL WELL. REPAIRED PER TYPICAL REPAIR 53-60-04.SDR UPS06147068Skin · ground damageINSPECTION TYPE:N/A REPAIR SKIN DAMAGE CAUSED BY GROUND EQUIPMENT REF EO A300-5310-24267-A. REPLACED SKIN AND REPAIRED DAMAGED FRAMES AND STRINGERS.SDR CA060509000Skin · worn(CAN) SKIN P/N 50-120156-82 (PRESSURE VESSEL) EXIBITING WEAR MARK ALONG FASTENER ROW ATTACHING FILLET P/N 50-420023-24 TO IT. WEAR MARK NOT READILY VISIBLE WITHOUT PULLING AWAY FILLET FROM SURFACE OF SKIN. WEAR MARK IS CAUSED BY LOOSENING OF FILLET TO SKIN FASSDR QXEA200601230Rivet · lightning strikePDX - C3 1 LIGHTNING BURN MARK ON RIVET HEAD ON AT FS 273 ON STRINGER 24L. REPAIRED IAW SRM 51-42-06, SRM 51-21-11.SDR QXEA200601231Rivet · lightning strikePDX - C3 1 LIGHTNING BURN MARK ON RIVET HEAD ON PROP PATCH AT FS 256.5 ON STRINGER 26L. REPAIRED IAW SRM 51-42-06, SRM 51-21-11.SDR QXEA200601229Skin · lightning strikePDX - C3 1 LIGHTNING BURN MARK ON RIVET HEAD ON AT FS 342.25. REPAIRED IAW SRM 51-21-11, SRM 52-20-006.SDR SWAA061452Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA061451Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 816, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA061448Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 518, STR 12R. REPAIRED SKIN PER EA.
Back to JASC 5330