N676SW, cancelled Oct 26, 2017
Service difficulty reports · 282
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 n_number = 'N676SW' AND deregistration_id = 'N676SW-2017-10-26' 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 n_number = 'N676SW' AND deregistration_id = 'N676SW-2017-10-26' 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 SWAA075268Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075269Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075251Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 480, STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA075267Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 294, STR 14R. REPAIRED SKIN PER SRM.SDR SWAA075254Skin · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 947, RBL 6. REPAIRED SKIN PER SRM.SDR SWAA075253Skin · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 1006, STR 27L. REPAIRED SKIN PER SRM.SDR SWAA075252Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR CENTER SKIN CRACKED AT LOWER END. REPAIRED SKIN PER SRM.SDR SWAA075139Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 27L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA075138Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073945Slide · out of positionR1 DOOR SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA073168Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA072983Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA072690Hydraulic Line · chafedAIRTURN BACK / DECLARED EMERGENCY. THE -A- SYSTEM HYDRAULIC FLUID LOSS ON DEPARTURE FROM PHL. FOUND RIGHT MLG DOWNLOCK ACTUATOR LINE CHAFED. REMOVED AND REPLACED LINE PER MM.SDR SWAA071861Duct · crushedAT FL 240, CABIN ALT HORN SOUNDED, ALT CLIMBED TO 15,000 FT AND MASKS DEPLOYED. FOUND AFT PRESSURE BULKHEAD APU PNEUMATIC DUCT CRUSHED. REMOVED AND REPLACED AFT PRESSURE BULKHEAD APU PNEUMATIC DUCT PER MM.SDR SWAA071294Motor · shearedAT FL 370 NR 2 ENGINE WILL NOT ATTAIN MAX CLIMB POWER. FOUND VBV MOTOR SHAFT SHEARED. REMOVED AND REPLACED VBV DRIVE MOTOR PER MM.SDR SWAA070282Light · looseBULL NOSE EMERGENCY EXIT LIGHT LOOSE AT ROW 19 DEF. SECURED LIGHT ASSY AND REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064805Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 768, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA063260Lens · missingDURING SCHEDULED MV2 CHECK, FOUND EMERGENCY EXIT SIGN LENS MISSING AT ROW 2 DEF. INSTALLED LENS PER MM.SDR SWAA063259Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND EMERGENCY EXIT BULL NOSE LIGHT INOP AT ROW 12 DEF. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA062595Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 517D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA062270Attach Fitting · crackedDURING SCHEDULED MV2 CHECK, FOUND NLG ACTUATOR UPPER ATTACH FITTING GUSSETT CRACKED IN RADIUS. REMOVED AND REPLACED NLG GUSSETT FITTING PER SRM.SDR SWAA062241Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA061847Keelbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND KEELBEAM CORRODED AT BS 520, LBL 6.50. REPAIRED CHORD PER ER.SDR SWAA061824Rib · crackedDURING SCHEDULED SPV CHECK, FOUND RT WING RIB UPPER CHORD CRACKED AT WBL 114, STR 2. REPAIRED WING CHORD PER ER.SDR SWAA061791Structure · corrodedDURING SCHEDULED SPV CHECK, FOUND LOWER TORQUE BOX INBOARD CHORD CORRODED AT BS 1088 TO BS 1092, LBL 25. REPAIRED CHORD PER ER AND SRM.SDR SWAA061735Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CORRODED AT LEFT KEEL BEAM, BS 500C, STR 28L. REPAIRED SKIN PER SRM.SDR SWAA061656Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, LBL 8 TO RBL 8. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA061626Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 6L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA061608Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND RIGHT WING NR 5 SLAT T/E WEDGE DELAMINATED. REPAIRED NR 5 SLAT T/E WEDGE PER SRM.SDR SWAA061607Hook · looseDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EXIT EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED EVAC SLIDE AFT GIRT BAR HOOK PER SRM.SDR SWAA061590Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR UPPER FRAME CRACKED. REMOVED AND REPLACED AFT CARGO DOOR UPPER FRAME SECTION PER SRM.SDR SWAA061589Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 14 L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA060572Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 505C, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA06370Slide · dislodgedR1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER WHEN PROVISIONING OPENED DOOR. REINSTALLED SLIDE PER MM.SDR SWAA060259Light · damagedDURING SCHEDULED RON CHECK, FOUND EEPLS STRIP DAMAGED BETWEEN ROW 6 TO ROW 8, RT SIDE. REMOVED AND REPLACED STRIP PER MM.SDR SWAA053923Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY BULLNOSE LIGHT INOP AT ROW 12 DEF. RELAMPED LIGHT PER MM.SDR SWAA053816Rod End · brokenFOUND LT WING NR 4 GROUND SPOILER OTBD ACTUATOR ROD END BROKEN. REMOVED AND REPLACED GROUND SPOILER OTBD ACTUATOR PER MM.SDR SWAA053522Lens · missingBULLNOSE EMERGENCY LIGHT LENS MISSING AT ROW 12. INSTALLED LENS PER MM.SDR SWAA053421Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA052650Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING OTBD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA052627Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 21L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA052054Stringer · corrodedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 500D, STR 23L. REPAIRED STRINGER PER SRM.SDR SWAA052052Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA050958Tab · wornDURING SCHEDULED C1 CHECK, LT ELEVATOR TAB HAD EXCESSIVE PLAY. REMOVED AND REPLACED LT ELEVATOR TAB PER MM.SDR SWAA050957Tab · wornDURING SCHEDULED C1 CHECK, RT ELEVATOR TAB FAILED THE FREE PLAY CHECK. REMOVED AND REPLACED RT ELEVATOR TAB PER MM.SDR SWAA050356Cover · dislodgedEMERGENCY EXIT LIGHT COVER AT ROW 13 ABC, FEEL OFF. REMOVED AND REPLACED LIGHT COVER PER MM.SDR SWAA043663Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA042174Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR OVERHEAD EXIT LIGHT INOP. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PER MM.SDR SWAA041412Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040480Lens · missingDURING SCHEDULED C1 CHECK, FOUND EMERGENCY EXIT LIGHT LENS MISSING FROM BULLNOSE AT 8D. REMOVED AND REPLACED LIGHT LENS PER MM.
Back to N676SW, cancelled Oct 26, 2017