N693SW, cancelled Dec 8, 2014
Service difficulty reports · 443
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 = 'N693SW' AND deregistration_id = 'N693SW-2014-12-08' 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 = 'N693SW' AND deregistration_id = 'N693SW-2014-12-08' 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 SWAA073818Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073813Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073759Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073764Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073757Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073758Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073763Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073762Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073760Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073761Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073636Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073635Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073124Stringer · corrodedDURING SCHEDULED MV1 CHECK, FOUND STRINGER 21R CORRODED AT BS 727D. REPAIRED STRINGER PER SRM.SDR SWAA073123Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 734D, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA072925Glowstrip · wornDURING SCHEDULED HC1 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 4 ABC. REMOVED AND REPLACED STRIP PER MM.SDR SWAA071657Lamp · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA070793Shear Tie · corrodedDURING SCHEDULED MV2 CHECK, FOUND SHEAR TIE CORRODED AT BS 987, STR 23L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA070796Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 982, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA070795Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 907, STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA070794Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA064969Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND RT OVERWING DOOR LOWER EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA064968Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND RT OVERWING DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA064967Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA064966Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 26L CORRODED AT BS 360. REPAIRED STRINGER SECTION PER SRM.SDR SWAA064965Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 27L CORRODED AT BS 360. REPAIRED STRINGER SECTION PER SRM.SDR SWAA064964Bracket · corrodedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR AFT GIRT BAR FLOOR BRACKET CORRODED. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA064963Bracket · corrodedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR FWD GIRT BAR FLOOR BRACKET CORRODED. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA064943Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, S2L. REPAIRED FRAME SECTION PER EA.SDR SWAA064942Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17R AND STR 17L. REPAIRED FRAME SECTION PER EA.SDR SWAA064941Lamp · inoperativeDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064940Lamp · inoperativeDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064939Stringer Splice · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 907, STR 25R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA064925Lamp · inoperativeDURING SCHEDULED 22Y CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064924Connector · looseDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. RESEATED CONNECTOR D2972 PER MM.SDR SWAA064881Fitting · looseDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA064880Fitting · looseDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA064879Door Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR CUTOUT AFT FRAME CORRODED AT BS 993, STR 17R. REPAIRED FRAME SECTION PER SRM.SDR SWAA064878Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME SECTION PER SRM.SDR SWAA064877Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 20R CORRODED AT BS 515B. REPAIRED STRINGER PER SRM.SDR SWAA064876Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 845 TO BS 847, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA064875Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 847, STR 26R. REPAIRED FRAME SECTION PER SRM.SDR SWAA064874Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986.5, STR 7L. REPAIRED FRAME SECTION PER SRM.SDR SWAA064841Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, BL 0. REPAIRED SKIN PER SB.SDR SWAA064843Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, BL 0. REPAIRED SKIN PER SB.SDR SWAA064842Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, BL 0. REPAIRED SKIN PER SB.SDR SWAA064548Bolt · wornDURING SCHEDULED 22Y CHECK, LEFT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED INBOARD HINGE TAB BOLT PER MM.SDR SWAA064547Bushing · wornDURING SCHEDULED 22Y CHECK, RIGHT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED INBOARD HINGE TAB BUSHING PER MM.SDR SWAA064171Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING OUTBOARD AFT FLAP DELAMINATED AT INBOARD LOWER L/E. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA064056Wire Harness · burnedRIGHT ELEVATOR PITOT LIGHT ILLUMINATED ON CLIMBOUT, WITH ASSOCIATED C/B TRIPPED ON P-18-3 PANEL. FOUND WIRE BUNDLE W018 BEHIND P18-1 PANEL WITH NUMEROUS WIRES BURNT. REPAIRED WIRES PER WDM.SDR SWAA062461Lens · looseDURING SCHEDULED C3 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 5 DEF. SECURED LIGHT LENS PER MM.
Back to N693SW, cancelled Dec 8, 2014