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 SWAA050315Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 518, STRINGER 12R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050312Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 927 + 6, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050304Skin · crackedDURING SCHEDULED THRU CHECK, FOUND FUSELAGE SKIN AT BS 500A + 15, ABOVE STRINGER 16R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050298Skin · debondedDURING SPV, FOUND FUSELAGE SKIN BETWEEN BS 887 AND BS 897, BETWEEN STRINGERS 5L AND 9L, DISBONDED. REPAIRED SKIN PER SRM.SDR QXEA200500421Skin · gougedYYC - RIGHTHAND FUSELAGE EXTERNAL SKIN AT STATION X170, STRINGER 17 HAS A GOUGE. REPAIRED IAW RD 8/4-53-1156 AND HORIZON AIR EA 6-53-518.SDR SIMA200503804Skin · lightning strikeDURING AN MBV INSPECTION, A LIGHTNING STRIKE WAS FOUND ON THE LT SIDE OF THE FUSELAGE BETWEEN FRAMES 32 AND 33 AT STRINGER 6L. REMOVED THE DAMAGE BY MAKING A CUT OUT. FABRICATED A FILLER, OUTER DOUBLER AND AN INNER DOUBLER. REPAIR DONE IAW SRM. (K)SDR WRLA2005017Skin · corrodedITEM: DURING "C2" CHECK INSPECTION, FOUND CORROSION AT BARREL NUT HOLE NR 36 RT. CLEANED CORROSION AND OVERSIZED BARREL NUT HOLE TO 2.587" DIA, PER SECTION 7 OF E/O 02-5510-098 REV 03 AND FABRICATED REPAIR BUSHING PER SECTION 12 OF SAME E/O. CLEANED AND REINSDR DLM88050081Skin · gougedFUSELAGE SKIN DENTED AND GOUGED AT STATION 646 AND LONGERON 30. REPAIRED IAW ERA 096160-14.SDR DL75A050077Skin · tool damageTOOLING DAMAGE TO THE FUSELAGE SKIN AT STATION 631 AND STR 4L.SDR DL75A050076Skin · tool damageTOOLING DAMAGE TO THE FUSELAGE SKIN AT STATION 899 AND STR 3L. REPAIRED IAW ERA 096211-14.SDR DL75A050075Skin · damagedTOOLING DAMAGE TO THE FUSELAGE SKIN AT STATION 453 AND STR 4L. REPAIR IAW ERA 096138-14.SDR DLM88050074Skin · damagedFUSELAGE SKIN DAMAGED AT TWO LOCATIONS BETWEEN STATIONS 1250 AND 1287 AND LONGERONS 29L AND 30. REPAIRED I/A/W ERA 096383-14.SDR DLM88050073Skin · damagedFUSELAGE SKIN BUSHED ADJACENT TO THE AIRSTAIR DOOR CUTOUT AT TWO LOCATIONS BETWEEN LONGERONS 21L AND 22L. REPAIRED I/A/W ERA 096251-14.SDR SWAA050282Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 767, STRINGER 25L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050280Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 787, STRINGER 19L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050270Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 524, STRINGER 10L, CRACKED. REPAIRED SKIN PER EA.SDR ASAA0580081Skin · corrodedOKC - DURING C-CHECK, FOUND FUSELAGE SKIN CORRODED AND PITTED ON INSIDE JUST ABOVE LONGERON 3L. REMOVED DAMAGED AREA. INSTALLED REPAIR FILLER, DOUBLER, AND FINER DOUBLER. (M)SDR ASAA0580077Skin · crackedOKC - FOUND C-CHECK, FOUND L1 DOOR CUTOUT INNER WEB IS CRACKED. REMOVED DAMAGED AREA. INSTALLED REPAIR FILLER AND DOUBLER. (M)SDR AWXA200500222Skin · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .1875 INCH CRACK WAS FOUND IN FUSELAGE SKIN AT FORWARD EDGE OF L-1 DOOR UPPER HINGE CUTOUT BS 302, STR 10 LT. MAINTENANCE TRIMMED OUT CRACK IN L-1 DOOR UPPER HINGE CUTOUT BS 302, STR 10 LT; FABRICATED 2 EACH FILLERS ANSDR AWXA200500223Skin · crackedMCN - MAJOR REPAIR - DURING C-16 CHECK A .1875 INCH CRACK WAS FOUND IN FUSELAGE SKIN AT L-2 DOOR UPPER HINGE CUTOUT BS 955, STR 10 LT. MAINTENANCE CUT OUT CRACK IN L-2 DOOR UPPER HINGE CUTOUT BS 955, STR 10 LT; FABRICATED A FILLER AND REPAIR PLATE; INSTALLED SDR 05FDEA00202Skin · damagedAPU EXHAUST AREA UPPER DOOR HINGE FUSELAGE SKIN FOUND WITH REPAIR. EXISTING REPAIR ON APU EXHAUST AREA UPPER DOOR HINGE FUSELAGE SKIN REMOVED AS PER SRM 51-35-01 VOL I. NEW REPAIR DOUBLERS FABRICATED AND INSTALLED AS PER SRM 53-20-00, FIG 4 VOL I & SRM 53-00SDR SIMA200503101Skin · gougedDURING AN MBV INSPECTION THE BAGGAGE DOOR CUT OUT WAS FOUND TO BE GOUGED AT THE AFT LOWER CORNER OUTER SKIN. REMOVED THE DAMAGED OUTER SKIN BY MAKING A CUTOUT. FABRICATED A FILLER, DOUBLER FOR REPAIR. REPAIR DONE IAW SRM. (SW21200503066) (K)SDR SIMA200503803Skin · gougedDURING AN INSPECTION OF AIRCRAFT, THE BAGGAGE DOOR CUT OUT WAS FOUND TO BE GOUGED AT THE AFT LOWER CORNER OUTER SKIN. REMOVED THE DAMAGED OUTER SKIN MY MAKING A CUTOUT. FABRICATED A FILLER AND DOUBLER. REPAIR DONE IAW SRM. (K)SDR HNAA0500007Skin Panel · debondedDURING BOND TESTING, FOUND WIDE SPREAD DISBOND ON SKIN PANEL AT STRS 27P & 28P FROM FRAME X325 TO X424. REMOVED AND REPLACED SKIN PANEL FROM X325 TO X 424.SDR QXEA200500381Skin · chippedYYC - RIGHTHAND SIDE OF FUSELAGE SKIN BETWEEN STATION X595 AND X301 HAS NUMEROUS SMALL PAINT CHIPS. REPAIRED IAW DHC-8 400 SRM 51-25-05-370-001, PARAGRAPH E AND RD 8/4-53-382, ISSUE 3, PAGE 6.SDR AWXA200500329Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A .25 INCH CRACK WAS FOUND IN FUSELAGE SKIN EMANATING FROM FASTENER HOLE AT FORWARD LOWER CUTOUT OF R-2 DOOR BS 947. MAINTENANCE CUT OUT CRACK IN FUSELAGE SKIN AT FORWARD LOWER CUTOUT OF R-2 DOOR BS 947; FABRICATED 2 EACSDR SWAA050259Skin · crackedFUSELAGE SKIN AT BS 500B, STRINGER 17L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050258Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 312, STRINGER 18R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050246Skin · chafedDURING SPV, FOUND FUSELAGE SKIN CHAFED AT DORSAL FIN CONTACT AREA, FROM LT AND RT BS 863 TO 883, RT BS 911 TO 929, AND LT BS 964 TO BS 969. REPAIRED SKIN SECTIONS PER ER.SDR USAA050177Skin · crackedCLT - FOUND SKIN CRACKED, STATION 727D STRINGER S24L. INSTALLED DOUBLER IAW SRM 53-00-01. (M)SDR SWAA050234Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 792, STRINGER 19L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050230Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN AT BS 760, STRINGER 18R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050229Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 792, STRINGER 17L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050228Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 747, STRINGER 19R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050224Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 390, STRINGER 15R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050223Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 370, STRINGER 26L, CRACKED. REPAIRED SKIN PER EA.SDR 05FDEA00188Skin · corrodedSTA 1130 STR 28L IS BULGING 1 RIVET PULLED AND RIVET SHEARED. REMOVED FLOOR PANEL STA 1070-STA 1183 AFT PIT FOR ACCESS IAW SRM 51-30-2. REMOVED EXISTING REPAIR DOUBLER AT STA 1130 IAW SRM 51-30-02. FOUND CORROSION UNDER REPAIR DOUBLER, REMOVED DAMAGED AREA SDR IXXA0500162SSkin · corrodedDURING ROUTINE C-CHECK, FOUND CORROSION ON EXTERIOR FUSELAGE SKIN FROM STATION 680 TO STATION 780 BETWEEN LONGERON 32 LEFT AND LONGERON 32 RIGHT. REMOVED FASTENERS, AND ANTENNA TO GAIN ACCESS. REMOVED CORROSION. ORIGINAL SKIN THICKNESS .125 AFTER CORROSION SDR USAA050219Skin · crackedPIT - FOUND SKIN CRACKED THREE PLACES, .125 INCH .8750 INCH AND .125 INCH, E/E COOLING DUCT SKIN, LOWER FUSELAGE BS 380 S27R AND S27L. SKIN DOUBLER INSTALLED PER EO 5300V258. (M)SDR USAA050152Skin · crackedCLT - RON - SKIN, 1.750 INCH CRACK, STRINGER 23R STATION 727E; INSTALLED DOUBLER. (K)SDR SWAA050219Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 767, STRINGER 24R, CRACKED. REPAIRED SKIN PER SRM.SDR IXXA0500195SSkin · crackedDURING ROUTINE C-CHECK FOUND EXTERNAL FUSELAGE SKIN CRACKED AT STATION 45 LONGERON 28 LEFT IN AREA OF EXISTING REPAIR. PERFORMED HFEC TO VERIFY CRACK. VERIFIED, GAINED ACCESS, REMOVED FASTENERS, EXISTING DOUBLER, AND REMOVED DAMAGE. FABRICATED FILLER AND DOSDR USAA050218Skin · crackedPIT - FOUND SKIN CRACKED .25 INCH, AFT SERVICE DOOR TOP HINGE CUTOUT. INSTALLED DOUBLER REPAIR PER SRM 53-60-01. (M)SDR AWXA200500285Skin · crackedMCN - MAJOR REPAIR - DURING C-18 CHECK A .375 INCH CRACK WAS FOUND IN FUSELAGE SKIN EMANATING FROM FASTENER HOLE AT FORWARD UPPER CORNER CUTOUT OF R-1 DOOR. MAINTENANCE TRIMMED OUT CRACK IN FUSELAGE SKIN FORWARD UPPER CORNER CUTOUT OF R-1 DOOR; FABRICATED FILSDR SWAA050209Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 787, STRINGER 25L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050208Skin · chafedDURING SCHEDULED A2 CHECK, FOUND UPPER FUSELAGE SKIN BETWEEN BS 867 AND 887, AT DORSAL FIN, CHAFED. REPAIRED SKIN PER EA.SDR SWAA050206Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 500C, STRINGER 16L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050199Skin · wornDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN BETWEEN BS 875 AND BS 878, STRINGER 1, WORN. REPAIRED SKIN PER EA.SDR SWAA050198Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 943, STRINGER 25R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050195Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 358, STRINGER 18R, CRACKED. REPAIRED SKIN PER EA.
Back to JASC 5330