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 DL73S060261Lap Joint · crackedTHE FUSELAGE SKIN HAS 3 CRACKS IN THE LAP JOINT AT S-10R, BS 500-500A. THE CRACKED SKIN WAS REMOVED AND A REPAIR DOUBLER WAS INSTALLED.SDR DL73S060259Lap Joint · crackedFIVE CRACKS WERE FOUND IN THE FUSELAGE LAP JOINT AT S14L BETWEEN BS 480-500A. THE DAMAGED SKIN WAS REMOVED AND A REPAIR DOUBLER WAS INSTALLED.SDR ASAA0690410Skin · damagedFOUND SKIN DAMAGED (GOUGED) AT STA 440 519R BY BAG CART. REPAIRED IAW EA 5330 02074.SDR ASAA0670409Skin · gougedFOUND GOUGE IN FUSELAGE SKIN REPAIRED IAW EA 5330 02073.SDR SWAA061162Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA061158Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 251.6, BETWEEN STR 24L TO STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA061157Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503C, STR 15L. REPAIRED SKIN PER SWA EA.SDR KCSA061106Skin · corrodedFOUND FUSELAGE SKIN CORRODED AT BS 985 STRINGER S-43L.SDR 06FDEA1318Repair · misinstalledDOUBLER REPAIR AT FS 755-787, L47L-49L EVALUATED AND FOUND NOT TO BE PER SRM. REMOVED AND REPLACED DOUBLER WITH NEW DOUBLER IAW DC10 SRM 53-20-00 FIG 6 VOL I. THIS WAS CONSIDERED TO BE A MAJOR REPAIR.SDR QXEA200601610Skin · damagedYYC - C3 FUSELAGE EXTERNAL LEFT SIDE SKIN AT STATION X784 HAS A NICK AT STRINGER 21L. REPAIRED IAW RD 8/4-53-505.SDR QXEA200601022Skin · dentedYYC - C4 FUSELAGE EXTERIOR SKIN AT STATION X302, BETWEEN STRINGERS 17S - 20S HAS SEVERAL DENTS. REPAIRED IAW DHC-8-200 SRM 51-20-91, RD 8-53-4984, ISSUE 1 AND HORIZON AIR EA 2-53-730.SDR DL76K060258Skin · dentedTHE FUSELAGE SKIN HAS A DENT BETWEEN S-28R AND S-29R AT BS 1351. THE DAMAGED SKIN WAS REMOVED AND A REPAIR DOUBLER WAS INSTALLED.SDR QXEA200601003Skin · corrodedPDX - C4 CORROSION ON INTERNAL SKIN BAGGAGE COMPARTMENT JUST AFT OF DOOR CUTOUT FLOOR LEVEL. SEVERAL AREAS OF SURFACE CORROSION APPROXIMATELY X600-X535 AND STRINGER 23P. REPAIRED IAW RD 8-53-8998.SDR SWAA061179Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT, LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA061178Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 379, LBL 2, AFT SIDE OF E & E COOLING DUCT EXHAUST PORT. REPAIRED SKIN PER SWA EA.SDR SWAA061168Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 500C TO BS 520, STR 15L TO STR 16L. REPAIRED SKIN PER SWA EA.SDR CALA0600105Skin · crackedINSPECTION FOUND A 2.5 INCH CRACK IN FUSELAGE SKIN AT STA 761, S18R TO 19R. REPAIRED IAW SRM 53-00-01, REPAIR 31.SDR 06FDEA1315Skin · corrodedFOUND CORROSION ON FUSELAGE SKIN BS 680 -740 FROM STRINGER 4 LEFT TO STRINGER 10 LEFT. REMOVED AND REPLACED SKIN PANEL BS 680-740 STR 4 LT, STR 10 LT IAW SRM 51-30-2.SDR 06FDEA1314Skin · corrodedFOUND CORROSON ON FUSELAGE SKIN FROM BS 740 - 870 FROM STRINGER 4 LEFT TO STRINGER 4 RIGHT. REMOVED AND REPLACED SKIN BS 740-870 STR 4L-4R IAW SRM 51-30-2.SDR SWAA061153Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 474, STR 7R. REPAIRED SKIN PER SRM.SDR KCSA061100Skin · corrodedFOUND CORROSION ON INTERIOR OF FUSELAGE SKIN AT BS 1241, BELOW STR 11L. REPAIRED SKIN IAW B747 SRM 53-30-03 FIG 47.SDR IXXA06RNG028SSkin · crackedDURING ROUTINE CHECK, FOUND 3 CRACKS ON LEFT WING LEADING EDGE LOWER SURFACE BETWEEN STATION XFS 422 AND XS 435. REMOVED AND REPLACED SKIN IN LEFT WING LEAD EDGE LOWER SURFACE BETWEEN STATION XFS 422 AND XS 435 IAW DOUGLAS DRAWING NR 5769857.SDR IXXA06RNG006SSkin · corrodedDURING INSPECTION CHECK FOUND A CORROSION ON FUSELAGE SKIN BETWEEN STA 35 TI 70, LONGERON 31 RT TO 31 LT. SKIN PORTION OF LOWER FUSELAGE FROM LONGERON 31 RT TO 31 LT AND STA 17 TO 70 WAS REMOVED AND REPLACED IAW DOUBLER DRAWING 5613862, AND SPLICE WAS FABRICASDR QXEA200601158Skin · chafedPDX - FRONT SIDE OF FWD PRESSURE BULKHEAD AT 2 1/2 INCHES LEFT OF CENTER CUTOUT SKIN IS CHAFED. MAINTENANCE REPAIRED IAW Q400 SRM 51-14-00, NDTM PART 6, 51-00-02, HORIZON EA 6-53-669 AND RD 8/4-53-1471.SDR USAA060562Skin · corrodedFOUND SKIN CORRODED STA 312 STR 28L. INSTALLED REPAIR PER SRM 53-00-07, DEFECT SIZE: 2" BY 2".SDR DLM88060262Skin · corrodedTHE FUSELAGE SKIN HAS CORROSION BETWEEN BS 759-812, AND L27R - L29R. THE DAMAGED SKIN WAS REMOVED AND A REPAIR DOUBLER WAS INSTALLED.SDR TSAA0653028Skin · crackedAPPROXIMATE 2 INCH SKIN CRACK AT BS 747 +10 STR 24L. REPAIR COMPLETED IAW SRM 53-30-3 FIG 48. REPAIR SIZE APPROX 15 X 11 INCHES. INSURANCE CUT MADE .040 INCH. DOUBLER .032 2024T3; TRIPLER .050 2024T3. HFEC HOLE LAY-OUT IAW NDT MANUAL 51-00-00 PT 6.SDR GUUA04040601Skin · damagedFLIGHT 9196 GGT/FLL DURING PREFLIGHT, FOUND AIRCRAFT DAMAGE AT LEFT FUSELAGE AFT OF CARGO DOOR FUSELAGE STATION 523.5 TO 531.0 AT STRINGER 10L. REPAIRED DAMAGE BY INSTALLING EXTERNAL REINFORCEMENT DOUBLER PER BEECH STRUCTURAL REPAIR MANUAL 51-70-06.SDR SWAA061148Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA061137Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 518, STR 12L. REPAIRED SKIN PER SWA EA.SDR SWAA061136Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 851, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA061135Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 430, BL 0, #3 RADIO ALTIMETER ANTENNA CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA061129Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 20L. REPAIRED SKIN PER SRM.SDR QXEA200601616Skin · roughYYC - C3 PANEL 122AR, EXTERNAL SKIN, ENTIRE SURFACE SANDED VERY COURSE. SMOOTHED IAW DHC-8-400 SRM 51-14-00-350-803.SDR QXEA200601615Skin · roughYYC - C3 PANEL 121BL, EXTERNAL SKIN, ENTIRE SURFACE SANDED VERY COURSE. SMOOTHED IAW DHC-8-400 SRM 51-14-00-350-803.SDR QXEA200601614Skin · damagedYYC - C3 PANEL 121AL, EXTERNAL SKIN, ENTIRE SURFACE SANDED VERY COURSE. SMOOTHED IAW DHC-8-400 SRM 51-14-00-350-803.SDR QXEA200601613Skin · damagedYYC - C3 PANEL 122AR, EXTERNAL SKIN, ENTIRE SURFACE SANDED VERY COURSE. SMOOTHED IAW DHC-8-400 SRM 51-14-00-350-803.SDR QXEA200601612Skin · damagedYYC - C3 PANEL 112BR, EXTERNAL SKIN, ENTIRE SURFACE SANDED VERY COURSE. SMOOTHED SURFACE IAW DHC-8-400 SRM 51-14-00-350-803.SDR IXXA06RNG012SSkin · corrodedDURING INSPECTION CHECK FOUND CORROSION ON FUSELAGE SKIN BETWEEN STA 340 TO 360, LONGERON 32 RT TO 32 LT. CORRODED AREA WAS REMOVED AND EXTERNAL DOUBLER, FILLER DOOR JAMB INNER SKIN AND SPLICE WERE FABRICATED AND INSTALLED IAW EWO ATI 53-042. FAA FORM 8110-3SDR AWXA200600763Skin · crackedDURING C19 CHECK DISCOVERED FUSELAGE SKIN CRACKED, .5 INCHES, AT BS 727E+18 AT STR 24R. MAINTENANCE CUT OUT CRACKED SECTION OF SKIN AT BS 727B+18 AT STR 24R IAW BOEING 737-300 SRM 53-00-01-2R31 FIG 201. FABRICATED DOUBLER, FILLER AND TRIPLER IAW SRM 53-00-01SDR AMTA200600252Skin · corrodedEXTERNAL FUSELAGE SKIN BETWEEN 983-1212 AND STR 35-38 HAS SURFACE CORROSION. REMOVED CORROSION IAW SRM AND FOUND THAT A CRACK EXISTED AFTER BLEND OUT. ACCOMPLISHED SKIN REPAIR IAW SRM. TREATED AND PROTECTED AREA IAW SRM. (K)SDR DL73S060242Bear Strap · crackedTHE UPPER AFT CORNER OF THE L2 DOOR OPENING HAS A FATIGUE CRACK IN THE BEAR STRAP AND ONE IN THE FUSELAGE OUTER SKIN AND DOUBLER. CUTOUT IS 3.5 X 1.5 INCH. INSTALLED REPAIR DOUBLER PER SRM.SDR 06FDEA1299Skin · damagedFOUND STA 342, 4" BELOW STR 21L SKIN HAS SHARP PROTRUSION, FROM APPARENT INTERNAL IMPACT. REPAIRED DAMAGE AT STA 342 4" BELOW STR 21L IAW SRM 53-30-3 FIG 13A.SDR SWAA061130Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SWA EA.SDR USAA060531Skin · crackedSTR 944, STRINGER 24L CRACKED. INSTALLED TRIPLER, DOUBLER, AND FILLER IAW EA 97508 SRM 53-00-1 REPAIR 31, DEFECT SIZE: 3 INCH.SDR USAA060550Skin · dentedSTA 500A+1 AND S-24-S25 DENTED. INSTALLED DOUBLER IAW SRM 53-00-01, DEFECT SIZE: .50 INCH.SDR USAA060539Skin · dentedSTA 480 S26R DENTED. REMOVED DAMAGE, INSTALLED DOUBLER AND TRIPLER REPAIR PARTS IAW EA 97535, DEFECT SIZE: 3.0"X1.25"X.095".SDR USAA060543Skin · wornBS 879-887 WL 306.5 RBL 3 SKIN HAS FRETTING WEAR. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-60-01 EA 97537, DEFECT SIZE: 9" X .250" X .010".SDR 06FDEA1292Skin · corrodedLT A/C BAY BETWEEN FS 39-41 HAS NUMEROUS SPOTS OF CORROSION ON SKIN FS STRG 37- 47. REMOVED CORROSION IAW A310-200 SRM 51-74-10, ALL AREAS WITHIN LIMITS IAW A310-200 SRM 53-15-12. ALODINED PRIMED AND TOP COATED ALL AREAS IAW A310-200 SRM 51-75-10.SDR 06FDEA1291Skin · corrodedFWD OF LT AIR COND CUT OUT EXTERNAL DOUBLER HAS NUMEROUS SPOTS OF CORROSION ON SKIN AND AROUND FASTENERS. REMOVED CORROSION IAW A310-200SRM 51-74-10 ALL AREAS FOUND TO BE WITHIN LIMITS IAW A310-200 SRM 53-15-12 PROTECTED ALL AREAS IAW A310-200 SRM 51-75-10.
Back to JASC 5330