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 SWAA115253Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 847+4, STR 4L. REPAIRED SKIN IAW EA.SDR SWAA115252Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 408, STR 4L. REPAIRED SKIN IAW EA.SDR SWAA115223Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 685+3, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA115178Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 500C+15, STR 1L. REPAIRED SKIN PER EA.SDR SWAA115177Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 970, STR 4L. REPAIRED SKIN PER SRM.SDR SWAA115176Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 965.5, STR 4L. REPAIRED SKIN PER SRM.SDR DALA1143770949Skin · crackedJULY 14 THIS AIRCRAFT WAS IN PSV IN MSP DEPT 260. DURING INSPECTION OF THE VERTICAL STAB A CRACK WAS VERIFIED AT STA 1401 L-2L. CRACK WAS REPAIRED PER ERA,494602-14_NON ROUTINE 108. ETOPS CATEGORY 'F': ANY OTHER EVENT DETRIMENTAL TO ETOPSSDR USAA2011071900002Skin Panel · crackedOVERNIGHT CHECK - CRACK FOUND ON KEEL BEAM PANEL LOCATED AFT & TO THE LEFT OF RT PACK EXHAUST LOUVERS AT BS 550, RBL 6. REPAIRED KEEL BEAM PANEL AT BS 550, RBL 6 IAW B737 SRM 53-60-12, FIG 201.SDR SWAA115125Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 907, STR 10L. REPAIRED SKIN IAW SRM AND DWG.SDR JR2R2011071800304Skin · damagedBIRD STRIKE DAMAGE NEAR FLIGHTDECK ESCAPE HATCH. REMOVED AND REPLACED SKIN AND DAMAGE STRINGERS IAW CRJ 900 AMM 51-42-06 AND 51-42-21.SDR JR2R2011071700293Skin · dentedBIRD STRIKE DAMAGE. REMOVED AND REPLACED FWD TOP SKIN IAW CRJ 900 SRM.SDR SWAA2012101708588Skin · crackedSKIN CRACKED AT BS 500C+15, STR 1L. REPAIRED SKIN PER EA.SDR UALA2011071903679Skin · gougedFOUND 2 GOUGES LOCATED APPROX 8FT FWD AND 10FT LEFT OF LOWER TCAS ANTENNA STATION 529, AND 48L. FOUND 1ST GOUGE APPROX 1.0" LONG AND .020" DEEP WITHIN A SHALLOW DENT OF 3.O" BY 4.0". THE 2ND GOUGE IS APPROX 0.75" LONG AND .003" DEEP. BLENDED BOTH GOUGES PER SDR SWAA115152Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 942, STR 25R. REPAIRED SKIN PER ER.SDR SWAA115150Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT SKIN CORRODED AT BS 947+5, STR 27L. REMOVED AND REPLACED SKIN PER SRM AND DWG.SDR SWAA115149Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 6. REPAIRED CHORD IAW EO AND EA.SDR SWAA115148Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CORRODED BETWEEN BS 847 TO BS 867, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN IAW EA.SDR SWAA115147Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CORRODED AT BS 787+9, BETWEEN STR 26R TO STR 27R. REPAIRED SKIN IAW EA.SDR SWAA115146Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CORRODED AT BS 787+13, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN IAW EA.SDR SWAA115145Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CORRODED AT BS 767+9, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN IAW EA.SDR SWAA115129Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE SKIN LOWER AFT WINDOW CUTOUT CORNER CRACKED AT BS 500+10, STR 17L. REPAIRED SKIN IAW TC.SDR SWAA115128Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE SKIN LOWER AFT WINDOW CUTOUT CORNER CRACKED AT BS 500B+10, STR 17L. REPAIRED SKIN IAW TC.SDR SWAA115127Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE SKIN LOWER AFT WINDOW CUTOUT CORNER CRACKED AT BS 500A+10, STR 17L. REPAIRED SKIN IAW TC.SDR SWAA115126Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE SKIN LOWER AFT WINDOW CUTOUT CORNER CRACKED AT BS 440+10, STR 17R. REPAIRED SKIN IAW TC.SDR SWAA115117Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 962, STR 21L. REPAIRED SKIN PER SRM.SDR IPXA11568327Doubler · gougedINSPECTION TYPE:C3, WHILE WORKING NRC 942125 FOUND A GOUGE IN 143N8740-78 OUTER DOUBLER AT THE FWD MAIN CARGO DOOR HINGE FUSELAGE SIDE BS 486.5, WL 302. REPLACED DOUBLER IAW DWG 143N8740, SRM 51-40-02-0G, SRM 51-40-05-0G.SDR DU4R2011008Skin · damagedLIGHTNING STRIKE ON LT FUSELAGE SKIN AT BS 891 AND .75" BELOW STR 23L.SDR SWAA115130Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN IAW SRM.SDR FDEA201107152729Skin · damagedFWD RT DOOR CUT OUT, NDT INSPECTION HIGHLIGHTED SEVERAL AREAS OF SURFACE ANOMALIES IN THE FWD LWR CORNER AREA . REWORK ACCOMPLISHED ON EA 6-5315-150930.SDR UALA2011071503596Skin · dentedDENT AT BS 458 AT S-17L. MAJOR REPAIR. REPAIRED DENT IAW EA PD57-53-147 AND EVA 81000.SDR QXEA2011071900504Skin · corrodedC2 - INTERNAL BELLY LAP BETWEEN STA X156.000 AND X176.000 HAS AREAS OF CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED PAINT AND PRIMER IAW SRM 51-21-00-00-01. CORROSION WAS CONFINED TO PAINT AND PRIMER. ALODINED PRIMED AND PAINTED IAW SRM 51-21-10-02-01, SDR SWAA115141Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 767+12, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA115140Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 767+16, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA115139Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 767+7, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA115134Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 877 TO BS 878, STR 4R. REPAIRED SKIN PER EA.SDR SWAA115133Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 753 TO BS 755, STR 4R. REPAIRED SKIN PER EA.SDR DALA1145080922Skin · corrodedCORROSION ON LOWER FUSELAGE SKIN STA Y=726 LONG 29RT. SKIN SECTION SPLICE REPAIR WAS ACCOMPLISHED IAW ERA 494046-14 REV ORIG.SDR UALA2011071403565Skin · damagedFUSELAGE HAS LIGHTNING STRIKE DAMAGE. ACCOMPLISHED PERMANENT REPAIR IAW SRM 53-00-01 RPR 6.SDR USAA2011072200028Skin · crackedQ3 CHECK - CRACK IN FUSELAGE SKIN AT BS 727F, S24R. REPAIRED FUSELAGE SKIN AT BS 727F, S24R IAW B737 SRM 53-00-01 REPAIR 31 DETAIL V111.SDR SWAA115089Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CUTOUT LOWER AFT CORNER CRACKED AT BS 400+10, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA115069Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW CUTOUT SKIN LOWER AFT CORNER CRACKED AT BS 420+10, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA115058Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN UPPER FORWARD CORNER CRACKED AT BS 500A+10, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA115057Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN UPPER FORWARD CORNER CRACKED AT BS 460+10, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA115056Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN UPPER FORWARD CORNER CRACKED AT BS 500B+10, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA115055Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN UPPER FORWARD CORNER CRACKED AT BS 400+10, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA115053Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 327, BETWEEN STR 16R TO STR 17R. REPAIRED SKIN PER EA.SDR SWAA115052Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 328, BETWEEN STR 16R TO STR 17R. REPAIRED SKIN PER EA.SDR SWAA115051Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 328+2, BETWEEN STR 16R TO STR 17R. REPAIRED SKIN PER EA.SDR DALA1159860925Skin · corrodedFUSELAGE SKIN STA 588, L29L TO L30 CORROSION. REPAIRED IAW ERA 483854-14.SDR FDEA201107132674Skin · dentedRAMP REPORTED DENT 17 IN AFT OF FWD LOWER CARGO DOOR AND APPROX 57 IN UP FROM BOTTOM OF DOOR OPENING. INSP IAW SRM 53-10-12 DIAGRAM 109 WITIN LIMITS OF "B" NO REPAIR REQUIRED. REINSPECT WITHIN 3000 FC. ACFT OK TO CONTINUE. NO RESTRICTION REF: SRM 53-10
Back to JASC 5330