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 061048Skin · damagedEXTERNAL EMPENNAGE SKIN DOUBLER DAMAGED AT BS 2742, WL 272. REPAIRED SKIN IAW B747 SRM 53-30-03 FIG 1A.SDR 06FDEA1246Skin · dentedN00969 DENT IN SKIN, BS 748, JUST BELOW STR2R. REPAIRED DENT PER FED EX E.A. 7-5330-96624SDR SWAA061071Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 513D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA061055Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 933 TO BS 951, STR 21L TO STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA061054Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 910, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA061053Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA061052Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 732E TO BS 734E, STR 19R TO STR 20R. REPAIRED SKIN PER SWA EA.SDR SWAA061051Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 562, STR 10R. REPAIRED SKIN PER SWA EA.SDR 06FDEA1247Skin · dentedFOUND DENT IN SKIN, BS 1084, 1" ABOVE STR 2L TO 4" ABOVE STR 4L. ALL WORK ACCOMPLISHED IAW FED EX EA 7-5330-99514 FOUND TO BE A MAJOR REPAIRSDR 06FDEA1245Repair · unknownRT FUSELAGE EXTERNAL REPAIR IS IN CRITICAL AREA OF PRIMARY STATIC PORT. REWORKED REPAIR IAW FEDX EA 8-5330-96383 FUSELAGE - SKIN AT FORWARD CARGO DOOR HAS REPAIR THAT WAS REMOVED - REWORK. MAJOR REPAIR.SDR MWEA060035Skin · damagedFOUND LIGHTNING STRIKE AT FRAME STATION 1116, LONGERON 6 LEFT. FABRICATED AND INSTALLED DOUBLER.SDR MWEA060034Skin · damagedLIGHTENING STRIKE AT FRAME STATION 1053, BETWEEN LONGERON 3 LEFT. -- FABRICATED AND INSTALLED DOUBLERSDR MWEA060033Skin · lightning strikeFOUND LIGHTNING STRIKE AT FRAME STATION 1087, LONGERON 5 LEFT. FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR MWEA060032Skin · damagedFOUND LIGHTNING STRIKE AT FRAME STATION 927, LONGERON 3 LEFT. FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR MWEA060030Skin · damagedFOUND LIGHTNING STRIKE AT FRAME STATION 832 LONGERON 6 LEFT AND 7 LEFT. FABRICATED AND INSTALLED DOUBLER.SDR MWEA060029Skin · damagedFOUND LIGHTNING STRIKE AT FRAME STATION 775-794 LONGERON 5 LEFT. FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR MWEA060028Skin · damagedFOUND LIGHTNING STRIKE AT FRAME STATION 370-357 LONGERON 9 LEFT. FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR MWEA060027Skin · damagedFOUND LIGHTNING STRIKE AT FRAME STATION 275-256 LONGERON 9 LEFT. FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR UPS06846692Skin · corrodedFOUND STRUCTURE CORRODED FWD OF LT BOTTLE BOLT BARREL NUT, LT W/W FWD UPPER OB CORNER. REPAIRED EXTERNAL SKIN CORROSION AT STA 857 LONGERON 24L AT BAYONET FITTING IAW UPS ENGINEERING FILE NR DC8-53-20543, SAA EA NR 008-5320-01-A0137, BAC SERVICE REQUEST 1-176SDR SWAA061063Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 946, STR 21L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA061062Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 328, STR 22R. REPAIRED SKIN PER SWA EA.SDR SWAA061057Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT FWD CARGO DOOR CUTOUT, BS 491, STR 26R. REPAIRED SKIN PER SWA EA.SDR QXEA200600955Skin · corrodedPDX - C4 FUSELAGE UNDER NR 2 DME ANTENNA HAS CORROSION AROUND ANTENNA MOUNTING HOLES. REPAIRED IAW DHC-8-200 SRM 51-20-16.SDR QXEA200600828Skin · dentedPDX - C4 THERE IS AN INSIDE OUT DENT AT APPROXIMATELY X524 BETWEEN STRINGERS 31L AND 32L . REPAIRED IAW RD 8-53-2181.SDR QXEA200600827Skin · corrodedPDX - C4 THERE IS CORROSION AT THE SCREW HOLES ON THE FUSELAGE FOR THE LOWER TCAS ANTENNA. REPAIRED IAW CHD-8-200 SRM 51-20-16.SDR QXEA200600823Skin · corrodedPDX - C4 AIRCRAFT SKIN UNDER LOWER TCAS ANTENNA HAS CORROSION BUILD UP AROUND TWO ATTCHMENT SCREWS. REPAIRED IAW DHC-8-200 SRM 51-20-11 AND 51-20-16.SDR UPS06846614Skin · corrodedFUSELAGE SKIN AT SPLICE BETWEEN FUSELAGE AND TAILCONE BETWEEN LONGERON 34L- 34R HAS CORROSION APPEARS TO GO UNDER DOUBLER ON FUSELAGE SIDE STA 1890. REMOVED DOUBLER, REMOVED CORROSION FROM SKIN AND FOUND TO BE WITHIN LIMITS. FABRICATED AND INSTALLED DOUBLER SDR SWAA061027Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA061037Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 373, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA061031Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 464, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA061030Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA061029Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503D, STR 12R. REPAIRED SKIN PER SWA EA.SDR SWAA061028Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 328, BETWEEN STR 16L TO STR 17L. REPAIRED SKIN PER SWA EA.SDR 2006UALA00572Skin · dentedLEFT SIDE OF FUSELAGE FWD OF NR 2 MAIN ENTRY DOOR HAS A PUNCTURE & DENT.SDR SWAA061046Skin · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 732C TO BS 732D, STR 14L. REPAIRED SKIN PER BFG ER.SDR SWAA061039Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 761 TO BS 764, STR 22L TO STR 23L. REPAIRED SKIN PER SWA EA & SRM.SDR GAIA06012Skin · crackedDURING INSPECTION A CRACK WAS FOUND ON THE SKIN BY THE LOWER AFT CORNER OF THE R-2 DOOR CUT OUT. REPAIRED THE SKIN IAW SB. AIRCRAFT RETURNED TO SERVICE. (K)SDR UPS06846615Skin · dentedDENTS 2 EACH AFT OF SERVICE DOOR L-2 AT STA 1670 L17L. CUT OUT DAMAGE, FABRICATED AND INSTALLED DOUBLER AND FILLER IAW SRM53-2-1 FIG 10.SDR QXEA200600883Skin · chippedPDX: THE PAINT AND SKIN OF AIRCRAFT IS CHIPPED AND GOUGED 1 TO 8 INCHES AFT OF THE LAV SERVICE DOOR. MAINTENANCE REPAIRED IAW Q400 SRM 51-14-00, NDTM PART 6, 51-00-04, NDTM PART 6, 51-00-01-250-801, HORIZON EA 6-53-644 AND RD 8/4-53-1058.SDR 06FDEA1208Skin · corrodedFOUND BS 680 ABOVE STR 27 RT FUSELAGE SKIN BUT SPLICE IS CORRODED INSIDE FWD CARGO BAY. REPAIRED SKIN AT BS 680, AT STA 27RT PER FED EX EA 7-5310-99057.SDR 2006UALA00564Skin · damagedTHREE AREAS OF DAMAGE FOUND FROM STATIONS 600 TO 620 ON LEFT SIDE BETWEEN STRINGERS 15L AND 20L. CAUSE OF DAMAGE - AIRCRAFT IMPACTED BY JETWAY AT DOOR 2L. SKIN AND FRAME DAMAGE WERE CUT OUT AND DOUBLERS INSTALLED PER EVA-60167 AND EVA-60176.SDR 2006UALA00563Skin · dentedACFT DENTED 11 INCHES FWD OF RADAR COMPT DOOR IN 2 AREAS, 5 X 1.25 X .187 INCH & 7 X 9 X .25 INCH. DENTS IN PRESSURIZED AREA AND ON A BUTT JOINT. REMOVED DAMAGE. MANUFACTURED REPAIR DOUBLERS, TEAR STRAP, AND FILLER PER EVA.SDR 06FDEA1210Skin · gougedREWORK ON N00140 REQUIRED. LWR LOBE EXTERNAL SKIN, SKIN AFT OF FWD CARGO DOOR HAS GRAVEL GOUGES BETWEEN STR 23R AND 25R. REWORK REQUIRED BECAUSE BLENDING EXTENDS OVER FASTENERS AND FASTENER HOLES. THIS IS NOT ALLOWED PER SRM 53-30-1. *S/D* REPAIRED PER FESDR 06FDEA1209Skin · damagedEXTERNAL DOUBLER REPAIR APPROX 12.75 X 26.75 INCHES, RT FUSELAGE STA 1010 STRINGER 26R TO 26L REPAIR REQUIRES EVALUATION FOR MAJOR MINER DETERMINATION AND IF THE REPAIR WAS ACCOMPLISHED USING FAA APPROVED DATA. *S/D* REPAIRED PER FED EX EA 7-5330-96615.SDR ABXA060151Skin · corrodedFOUND FUSELAGE EXTERIOR FASTENER SHEARED AT LONGERON 39 LEFT AND SKIN BULGED AT FS -32.00. REPAIRED FUSELAGE EXTERIOR SKIN AT FS 32.00, LONGERON 30 LEFT IAW DC8 SRM 53-2-1, 51-1-8, AND DWG K04888.SDR SWAA061009Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 913, STR 24R. REPAIRED SKIN PER SRM.SDR DL73S060218Skin · crackedA CRACK WAS FOUND IN THE FUSELAGE SKIN FROM STA 927 TO STA 937 NEAR STR 22R. CRACK IS ABOUT 3.5 INCH LONG. A REPAIR DOUBLER WAS INSTALLED PER SRM 53-30-3 FIG 48.SDR TSAA0653022Skin Panel · crackedA 1.75 INCH CRACK AT BS 787 STR 19L. CRACK CUT OUT AND REPAIRED IAW SRM 53-30-3 FIGURE 48 DETAIL XI. NDT ACCOMPLISHED IAW BOEING NDT MANUAL 51-00-00 PT 6. REPAIR APPROXIMATE SIZE 9 X 12 INCHES.SDR SWAA061015Skin · crackedDURING SCHEDULED C1CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA060985Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT RT WING L/E SCANNING LIGHT CUTOUT, FWD UPPER CORNER. REPAIRED SKIN PER SWA EA.
Back to JASC 5330