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 SWAA052260Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765, STR 24R. REPAIRED SKIN PER SRM.SDR DU4R0507172Skin · dentedDENT IN LT SIDE FUSELAGE SKIN IN AREA OF S-20L BS 465.SDR ASOA05707Doubler · corrodedDURING A C-CHECK IN YUL, THE DOUBLER AT FRAME 39, STRINGER 14 RIGHT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE DOUBLER AT FRAME 39, STRINGER 14 RIGHT IAW ATR-72 SRM 51-21-42 AND 51-25-01. (M)SDR UPS05445187Skin · crackedINSPECTION TYPE:C FX SKIN S19R AT BS 388 TOP ROW FASTENER ROW 1EA FASTENER HOLE FOUND CRACK AT OUTER SKIN RUNNING FWD & AFT APPROX 0.030 INCH. FX SKIN BS 383 TO BS 399 STR 19R AREA OVERLAPPING SKIN REPAIRED WITH ZERO TIMING AT CRITICAL ROW FASTENERS AS PER SRSDR SWAA052231Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 522, STR 10R. REPAIRED SKIN PER SWA EA .SDR SWAA052227Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKS AT BS 769 AND BS 783, STR 22R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA052225Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE CRACKS AT BS 792 AND BS 812, STR 18L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA052223Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT, UPPER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA052221Skin · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 847, BETWEEN STR 27R AND STR 27L. REPAIRED SKIN PER SRM.SDR SWAA052242Skin · damagedDURING SCHEDULED 5Y CHECK, FOUND FUSELAGE SKIN CREASED AT BS 812, BETWEEN STR 27L AND STR 26R. REPAIRED SKIN PER SRM.SDR SWAA052250Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 968 TO BS 971, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA052249Skin · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 847, BETWEEN STR 27L TO STR 27R. REPAIRED SKIN PER SRM.SDR SWAA052244Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500A + 4, STR 16R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA052243Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 485, STR 16L. REPAIRED SKIN PER SWA EA AND SRM.SDR USAA050903Skin · crackedCLT - C1 - FUSELAGE SKIN, .75 INCH CRACK, GROUND AIR SERVICE CONNECTION DOOR CUTOUT AT AREA BETWEEN BS 520-BS 540. REMOVED DAMAGE, FABRICATED REPAIR PARTS AND INSTALLED IAW EA. (K)SDR SWAA052226Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKS BETWEEN BS 727E + 3 AND BS 747, STR 19R. REPAIRED SKIN PER SWA EA AND SRM.SDR 2005UALA00719Skin · crackedAPPROXIMATE 1.5 INCH CRACK IN FUSELAGE AT LOWER AFT RADIUS OF DOOR 1R. REPAIRED DOOR 1R LOWER AFT CORNER REF SRM 53-10-01 PAGE 207.SDR GTIA050232Skin · dentedFOUND DENT AT FS 212, X=0.038, D=0.5 AND D/X=17.2. REMOVED FLOORBOARDS, COVER GRILL, AND CUT OUT WEB TO FOM FOR SKIN REPAIR. FABRICATED INTERNAL REPAIR DOUBLER. TREATED, PRIMED AND INSTALLED INTERNAL REPAIR DOUBLER. FABRICATED WEB REPAIR DOUBLER. TREATED,SDR SWAA052207Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 774, STR 25L. REPAIRED SKIN PER SRM.SDR 2005UALA00712Skin · dentedSTATION 807 IS DENTED AT STR 28R. CUT OUT DAMAGE AND INSTALLED A TRIPLER REPAIR REF SRM 53-00-01 FIG 229.SDR AWXA200500980Skin · crackedMCN - MAJOR REPAIR - DURING C16 CHECK DISCOVERED CRACK, .150 INCHES IN LENGTH, AT L1 DOOR CUTOUT JUST BELOW AFT CORNER AT FASTENER. MAINTENANCE REMOVED CRACK IAW AMERICA WEST AIRLINES ENGINEERING REPAIR 03-5211-05224-ES1. FABRICATED DOUBLER, TRIPLER, FILLERSSDR ASAA0580408Skin · gougedOKC - FOUND DURING C-CHECK, FUSELAGE IS GOUGED. REPLACED EXISTING REPAIR DOUBLER. (M)SDR ASAA0580407Skin · dentedOKC - DURING C-CHECK, FOUND FUSELAGE IS DENTED. COLD-WORKED DAMAGED AREA AND INSTALLED REPAIR DOUBLER. (M)SDR ASAA0580406Skin · dentedOKC - DURING C-CHECK, FOUND FUSELAGE IS DENTED. COLD-WORKED DAMAGED AREA AND INSTALLED REPAIR DOUBLER. (M)SDR ASAA0580405Skin · dentedOKC - DURING C-CHECK, FOUND RIGHT FUSELAGE IS DENTED. REMOVED DAMGAED AREA. INSTALLED REPAIR DOUBLER. (M)SDR ASAA0580399Skin · damagedOKC - FOUND DURING C-CHECK, FREEZE PLUG IN FUSELAGE SKIN. INSTALLED EXTERNAL REPAIR DOUBLER. (M)SDR UPS05845150Skin · crackedFUSELAGE EXTERIOR SKIN CRACKED 1/2" LONG AT STA 1746 L15R. REMOVED DAMAGED SECTION OF SKIN, FABRICATED, AND INSTALLED REPAIR IAW DC-8 SRM 53-2-1 FIG 7.SDR UPS05845149Skin · crackedFUSELAGE EXTERIOR SKIN CRACKED 1/2" LONG AT STA 1746 L15L. CUT OUT DAMAGED SECTION OF SKIN AT STA 1746 AND L15L. FABRICATED, AND IN STALLED REPAIR IAW DC-8 SRM 53-2-1 FIG 7.SDR SWAA052186Skin · crackedDURING WALKAROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 480, STR 16L. REPAIRED SKIN PER SWA EA & SRM.SDR 05FDEA02091Skin · chafedPREVIOUS REPAIR IS CHAFED AT BS 720D 12, STRINGER 19 LEFT. REPLACED CHAFFED REPAIR AT BS 720D 12, STR 19L, IAW SRM 51-10-1 AND 51-10-2. (CLOSED)SDR 05FDEA02090Skin · gougedGOUGE IN FUSELAGE SKIN AT BS 430, JUST BELOW STR. 18R. CUT OUT DAMAGE IN SKIN BS 430 R, STR 18 IAW SRM 53-30-3 FABRICATED, INSTALLED PARTS PER SRM 53-30-3. (CLOSED)SDR PIDA20050061Skin · crackedCRACK IN FUSELAGE SKIN JUST BELOW STR.18LT AT APROXIMATE BS797. REPAIRED IN ACCORDANCE WITH SRM 53-00-01.SDR GTIA050230Skin · gougedFOUND MID PIT, SKIN GOUGED/DENTED AT STATION 540 BETWEEN LONGERONS 26L AND 27L. DAMAGED AREA FOUND, OUT OF LIMITS AT STATION 540 BETWEEN 26L AND 27L. CUT OUT DAMAGED AREA. FABRICATED FINGER DOUBLER, TREATED, PRIMED AND INSTALLED REPAIR DOUBLER. (M)SDR ABXA050223Skin · corrodedSKIN LONGERON 30, FS 680 TO FS 737 WAS CORRODED. BLENDED CORROSION AND REPAIRED DAMAGED AREAS IAW DC-9 SRM.SDR AWXA200500975Skin · crackedMCN - MAJOR REPAIR - DURING C16 CHECK DISCOVERED R1 DOOR UPPER HINGE CUTOUT AT UPPER CORNER. MAINTENANCE TRIMMED OUT THE R1 DOOR UPPER HINGE CUTOUT IAW AMERICA WEST AIRLINES (AWA) ENGINEERING REPAIR (ER) NO. 03-5241-05208-ES2. FABRICATED DOUBLER AND REPLACEMSDR SWAA052192Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 12R. REPAIRED SKIN PER SWA EA.SDR SWAA052177Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA052158Skin · corrodedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 500A, STR 26R. REPAIRED SKIN PER SWA EA.SDR SWAA052151Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT, FWD UPPER CORNER. REPAIRED SKIN PER SWA EA.SDR 2005UALA00694Skin · dentedSTATION 203 HAS A SCRATCH BETWEEN STR 24 AND 25 LT. CUT-OUT DAMAGED AREAS AND INSTALLED TRIPLER REPAIR REF SRM 53-10-01 FIG 211 DETAIL XII AND XIII.SDR IXXA05RNG044SSkin · corrodedDURING A ROUNTINE C CHECK INSPECTION FOUND CORROSION ON LOWER SKIN STA 1440-1530 LONGERON 31RH- 31LH. SKIN STA 1440-1530 LONGERON 31R-31L WAS REMOVED AND REPLACED IAW DOUGLAS DRAWING 5615374, AND EXTERNAL SPLICE, INTERNAL SPLICE, FINGER DOUBLER AND LONGERONSDR SWAA052153Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED BELOW DORSAL FIN AT BS 967, STR 2R. REPAIRED SKIN PER SRM.SDR DL757050753Skin · deformedTHE FUSELAGE SKIN AND BEARSTRAP WERE DENTED AT LOWER AFT CORNER OF THE FORWARD CARGO DOORWAY. INSTALLED REPAIR DOUBLERS.SDR ASOA05636Doubler · crackedDURING C-CHECK, THE RT FS 718 DOUBLER AT STRINGER 10-12 RT WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE RT FS 718 DOUBLER AT STRINGER 10-12 RT IAW EO. (K)SDR UPS05445186Skin · crackedINSPECTION TYPE:C RIGHT WING AT BS 395 STR 19 UPPER FASTENER ROW FOUND 1EA FASTENER HOLE CRACK AT OUTER SKIN APPROX .125 INCH LONG RUNNING FWD AS MARKED. FX BS 383 TO BS 399 STR 19R AREA OVERLAPPING SKIN REPAIRED WITH ZERO TIMING AT CRITICAL ROW FASTENERS AS SDR UPS05445185Skin · crackedINSPECTION TYPE:C, RIGHT SIDE AT BS 395 STR 19 UPPER FASTENER ROW FOUND ONE EACH FASTENER HOLE CRACKED AT OUTER SKIN APPROX .125 INCH LONG RUNNING FWD AS MARKED. FX BS 383 TO BS 399 STR 19R AREA OVERLAPPING SKIN REPAIRED WITH ZERO TIMING AT CRITICAL ROW FASTESDR SWAA052171Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 687, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA052170Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA052169Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727C, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA052161Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 12R. REPAIRED SKIN PER SWA EA.
Back to JASC 5330