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 SWAA101975Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 6R. REMOVED AND REPLACED CLIP PER ER.SDR SWAA101974Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER ER.SDR SWAA101973Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED CLIP PER ER.SDR SWAA101972Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5R. REMOVED AND REPLACED CLIP PER ER.SDR SWAA101971Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 976, STR 22L. REPAIRED SKIN PER ER.SDR SWAA101970Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 10R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA101927Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 380, STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA101926Stringer Clip · crackedDURING SCHEDULED 26Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101883Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 516C, STR 14R. REPAIRED SKIN PER ER.SDR SWAA101825Spar · corrodedDURING SCHEDULED 26Y CHECK, FOUND RT WING FRONT SPAR WEB CORRODED AT UPPER INBOARD BOLT COMMON TO NR 2 FUEL TANK FWD BOOST PUMP. REPAIRED SPAR WEB PER ER AND SRM.SDR SWAA101824Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 914, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA101823Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 922, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA101822Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500, STR 13L TO STR 14L. REPAIRED FRAME PER ER.SDR SWAA101812Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 508D, STR 14R. REPAIRED SKIN PER ER.SDR SWAA101750Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA101749Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA101748Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, RBL 10. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA101811Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101810Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101682Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA101666Light · damagedDURING SCHEDULED 26Y CHECK, FOUND AFT EEPLS DAMAGED. REMOVED AND REPLACED EEPLS PER DWG.SDR SWAA096843Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA096775Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA096774Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA096269Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND OVERHEAD EMERGENCY EXIT SIGN BETWEEN L1 DOOR AND FWD GALLEY INOP. CHARGED BATTERY PACK PER MM.SDR SWAA095629Frame · corrodedDURING SCHEDULED MV2 CHECK, FOUND FRAME LOWER FITTING LUG BORE CORRODED AT BS 685 RT. REPAIRED FRAME PER SWA EA.SDR SWAA095621Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME LOWER FITTING LUG BORE CORRODED AT BS 685 LT. REPAIRED FRAME PER SWA EA.SDR SWAA095620Stringer · crackedDURING SCHEDULED MV2 CHECK, FOUND STRINGER CRACKED AT BS 942, STR 23R. REPAIRED STRINGER PER SRM.SDR SWAA093394Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BS 480.5, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA093395Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BS 492, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA093396Shear Tie · crackedDURING SCHEDULED MV2 CHECK, FOUND SHEAR TIE CRACKED AT BS 500D, STR 14L. REPAIRED SHEAR TIE PER SRM.SDR SWAA093393Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 505C TO BS 516C, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA093392Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 501D TO BS 505D, BETWEEN STR 12L TO STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA093391Sensor · out of adjustAFTER GEAR RETRACTION, GEAR HANDLE MOVED TO OFF POSITION AND L & R GEAR INDICATED RED & GREEN. NOSE GEAR INDICATED NORMAL. CYCLED GEAR, OPERATED NORMALLY. ADJUSTED AIR SAFETY/GROUND SENSOR S106.SDR SWAA092047Strip · wornDURING SCHEDULED HC1 CHECK, FOUND EEPLS STRIP WORN BETWEEN ROW 12 TO ROW 14. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA092046Strip · wornDURING SCHEDULED HC1 CHECK, FOUND EEPLS STRIP WORN BETWEEN ROW 16 TO ROW 21. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA092045Lens · crackedDURING SCHEDULED HC1 CHECK, FOUND LT EMERGENCY EXIT SIDEWALL LIGHT LENS CRACKED. REMOVED AND REPLACED LENS PER MM.SDR SWAA092044Lens · crackedDURING SCHEDULED HC1 CHECK, FOUND RT EMERGENCY EXIT SIDEWALL LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA092043Lens · missingDURING SCHEDULED HC1 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA092042Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 769, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA090490Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT FWD EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA090489Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT INOP BETWEEN ROW 2 TO ROW 5. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA087078Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 500C, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA087077Stringer · crackedDURING SCHEDULED MV2 CHECK, FOUND STRINGER CRACKED AT BS 500C, STR 16R. REPAIRED STRINGER SWA EA.SDR SWAA083276Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 976, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA083220Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 976, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA081842Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 312 AND BS 317, STR 18R AND STR 20R. REPAIRED SKIN PER SWA EA.SDR SWAA081843Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, BETWEEN STR 16R AND STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA081713Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081673Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.
Back to N676SW, cancelled Oct 26, 2017