N646SW, cancelled Nov 20, 2017
Service difficulty reports · 356
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 = 'N646SW' AND deregistration_id = 'N646SW-2017-11-20' 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 = 'N646SW' AND deregistration_id = 'N646SW-2017-11-20' 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 SWAA070537Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA070520Skin · delaminatedDURING SCHEDULED 10Y CHECK, FOUND LEFT WING NR 2 L/E SLAT OUTBOARD AFT CORNER DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA070519Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, RBL 28 TO RBL 42. REPAIRED FLOORBEAM PER SRM.SDR SWAA070444Fitting · corrodedDURING SCHEDULED 10Y CHECK, FOUND RT AND LT HORIZONTAL STAB FITTING CLEVIS LUG FACES CORRODED. REPAIRED STAB FITTING PER ACO.SDR SWAA070428Sign · looseDURING SCHEDULED 10Y CHECK, FOUND RIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA070357Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 294.5 TO BS 328, RBL 61. REMOVED AND REPLACED CREASE BEAM SECTION PER SRM.SDR SWAA070356Fitting · corrodedDURING SCHEDULED 10Y CHECK, FOUND LT AND RT HORIZONTAL STAB FITTING CLEVIS LUG FACES CORRODED. REPAIRED STAB FITTING PER ACO.SDR SWAA070355Hook · looseDURING SCHEDULED 10Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK LOOSE. SECURED FWD GIRT BAR HOOK PER MM.SDR SWAA070314Pressure Panel · crackedDURING SCHEDULED 10Y CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 663.75, LBL 32. REPAIRED PRESSURE WEB PER SRM.SDR SWAA070291Hook · looseDURING SCHEDULED 10Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED GIRT BAR HOOK PER SRM.SDR SWAA064890Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA061543Battery · inoperativeDURING SCHEDULED SPV CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACKS PER MM.SDR SWAA061377Sign · brokenFWD ENTRY DOOR EMERGENCY EXIT DOOR SIGN BROKEN. REMOVED AND REPLACED EMERGENCY EXIT DOOR SIGN PER MM.SDR SWAA061372Sign · brokenFWD CABIN EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED EMERGENCY EXIT SIGN PER MM.SDR SWAA060308Fan · seizedSTRONG SMOKE SMELL IN CABIN. FOUND GASPER FAN WORN AND RECIRCULATION FAN SEIZED. REMOVED AND REPLACED GASPER FAN AND RECIRCULATION FAN PER MM.SDR SWAA051935Engine · overtempDIVERSION, NR 2 ENGINE OVERTEMP AT 500 FT AGL, 970 DEGREES INDICATED WITH RED LIGHT ILLUMINATED. REMOVED AND REPLACED NR 2 ENGINE PER MM.SDR SWAA051637Light · inoperativeL1 DOOR EMERGENCY EXIT LOWER LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA050302Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA050043Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA043270Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA043043Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA042840Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA042697Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA042609Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER 27R AT BS 747 AND BS 727E, CORRODED. REPAIRED STRINGER PER EA.SDR SWAA042608Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAMS AT BS 727D, LBL 3, RBL 3, RBL 8 AND BS 773, LBL 12, RBL 3, RBL 8, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA042600Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 858, LBL 3 TO RBL 8, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA042599Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 773, LBL 3, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA042408Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR PER MM.SDR SWAA042314Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA041959Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041800Panel · crackedDURING SCHEDULED C4 CHECK FOUND RT KEEL BEAM PANEL, CRACKED. REPAIRED KEEL BEAM PANEL PER EA.SDR SWAA041006Lamp · inoperativeDURING SCHEDULED C3 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED OVERWING EXIT LIGHT PER MM.SDR SWAA041005Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND LT WING INBOARD AFT T/E FLAP DELAMINATED. REMOVED AND REPLACED LT WING AFT FLAP PER MM.SDR SWAA032822Skin · crackedDURING SCHEDULED C2 CHECK, FOUND NR 3 L/E SLAT LOWER T/E SKIN CRACKED AT FASTENER'S ROW. REPAIRED SKIN PER SWA EA.SDR SWAA032821Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EVACUATION SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA032820Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EVACUATION SLIDE OUT OF ADJUST. READJUSTED SLIDE ASSY PER MM.SDR SWAA032752Window · arcedARCING AT R4 COCKPIT WINDOW. OK TO CONTINUE PER MEL.SDR SWAA032029Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031498Engine · failedIN FLIGHT SHUTDOWN, DECLARED EMERGENCY, ONE HOUR INTO FLIGHT NR 1 ENGINE FAILED. REMOVED AND REPLACED NR 1 ENGINE PER MM.SDR SWAA031252Bushing · wornDURING SCHEDULED C4 CHECK, SWA SI 11139-55, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB NR 1 HINGE HARDWARE AND BUSHING.SDR SWAA030936Light · inoperativeFWD ENTRY EMERGENCY EXIT LIGHT NEXT TO F/A SEAT INOP. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY PER MM.SDR SWAA022889Engine · malfunctionedABORTED TAKEOFF, DURING TAKEOFF, BANG/GRINDING NOISE, FLASH FROM NR 1 ENGINE AREA. ENGINE INDICATIONS NORMAL, SHUTDOWN BOTH ENGINES AS PRECAUTIONARY MEASURE. REMOVED AND REPLACED NR 1 ENGINE PER MM.SDR SWAA021864Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND EXTERIOR EMERGENCY LIGHT INOP AFT OF AFT SVC DOOR. RELAMPED EMERGENCY LIGHT PER MM.SDR SWAA021231Bushing · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11111-55, BOTH LEFT AND RIGHT ELEVATOR TABS FAILED FREE PLAY CHECK. REMOVED AND REPLACED BOTH LEFT AND RIGHT ELEVATOR TAB LOCKOUT MECHANISM BUSHINGS AND LINKS PER MM.SDR SWAA021112Lens · missingLT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA020910Lens · brokenFED SVC DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA020572Wire · damagedDURING SCHEDULED 1/2D CHECK, FOUND FWD SVC DOOR EMERGENCY EXIT LIGHT INOP. REPAIRED WIRE TO EXIT LIGHT PER MM.SDR SWAA020529Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CRACKED AT BS 390, BL 0 AND WL 208.1. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA012564Pitot Tube · crackedUPPER LH PITOT TUBE CRACKED. R&R PITOT TUBE PER MM.SDR SWAA012196Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE PER MM.
Back to N646SW, cancelled Nov 20, 2017