N671SW, cancelled Jan 3, 2013
Service difficulty reports · 308
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 = 'N671SW' AND deregistration_id = 'N671SW-2013-01-03' 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 = 'N671SW' AND deregistration_id = 'N671SW-2013-01-03' 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 SWAA061435Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 734, STR 19R. REPAIRED FUSELAGE SKIN PER SWA EA.SDR SWAA061434Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 921, STR 25R. REPAIRED FUSELAGE SKIN PER SWA EA.SDR SWAA061417Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 921, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA060536Fitting · brokenDURING SCHEDULED SERVICE CHECK, FOUND LEFT WING INBOARD GROUND SPOILER NR 4 MOUNT SUPPORT LUG BROKEN. REPAIRED SPOILER MOUNT SUPPORT PER SWA EA.SDR SWAA060535Actuator · shearedDURING SCHEDULED SERVICE CHECK, FOUND LT WING INBOARD GROUND SPOILER INBOARD ACTUATOR SHEARED. REMOVED AND REPLACED ACTUATOR PER MM.SDR SWAA060534Actuator · brokenDURING SCHEDULED SERVICE CHECK, FOUND LT WING INBOARD GROUND SPOILER OUTBOARD ACTUATOR BROKEN AT FWD MOUNTING BOLT. REMOVED AND REPLACED ACTUATOR PER MM.SDR SWAA060533Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 957, STR 23L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053883Flap Track · corrodedDURING SCHEDULED 1/4D CHECK, FOUND LT WING T/E FLAP NR 2 TRACK CORRODED AT AFT LOWER OTBD ATTACH FITTING. REMOVED AND REPLACED FLAP TRACK PER MM.SDR SWAA053863Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 665, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053862Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947.5, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA053861Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 518D, STR 12L. REPAIRED SKIN PER SWA EA.SDR SWAA053860Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 500A, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053859Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053858Stringer · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 359, STR 14L. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA053836Stringer · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA053835Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA053834Skin · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT, FWD UPPER CORNER. REPAIRED SKIN IAW SRM.SDR SWAA053819Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, BETWEEN STR 14L TO STR 15L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA052558Solenoid · faultyDECLARED EMERGENCY. MLG HANDLE WOULD NOT LOCK DOWN DURING MLG EXTENSION, 3 RED AND 3 GREEN LANDING GEAR POSITION LIGHTS ILLUMINATED. REMOVED AND REPLACED MLG LEVER HANDLE SOLENOID PER MM.SDR SWAA052348Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L1 & R1 DOOR EMERGENCY EVAC SLIDES OUT OF ADJUST. ADJUSTED SLIDES PER MM.SDR SWAA052347Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND RT WING INBOARD T/E AFT FLAP DELAMINATED AT OUTBOARD END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA051429Lens · missingEMERGENCY BULLNOSE LIGHT LENS MISSING AT ROW 12DEF. INSTALLED LENS PER MM.SDR SWAA051041Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA050994Lens · missingDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS COVER PER MM.SDR SWAA050932Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947.5, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA043096Light · brokenDURING SCHEDULED SERVICE CHECK, FOUND RT FWD EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED EMERGENCY EXIT LIGHT PER MM.SDR SWAA040888Skin · crackedDURING SCHEDULED C2 CHECK, FOUND 2 EA FUSELAGE SKIN CRACKS AT BS 983, STR 21L, AND BS 947, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA040887Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT EXTERNAL A/C DOOR CUTOUT, FWD RT CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA040749Blower · faultyF/A REPORTED ELECTRICAL ODOR IN CABIN. TURNING OFF RECIRC FAN ODOR ELIMINATED. REMOVED AND REPLACED RECIRC FAN BLOWER PER MM.SDR SWAA040103Spindle · crackedDURING SCHEDULED PMC, FOUND NR 8 T/E FLAP SPINDLE WITH CRACK INDICATION. REMOVED AND REPLACED NR 8 FLAP SPINDLE PER MM.SDR SWAA040033Slide · deployedUPON OPENING L1 DOOR, EVACUATION SLIDE DEPLOYED. REMOVED AND REPLACED L1 DOOR EVACUATION SLIDE PER MM.SDR SWAA032732Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACK AT BS 927, STRINGER 23L. REPAIRED SKIN PER SRM.SDR SWAA031988Bushing · wornDURING SCHEDULED C4 CHECK, SWA SI 11138-55, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB NR 1 HINGE HARDWARE AND BUSHING PER MM.SDR SWAA031637Slide · out of adjustDURING SCHEDULED PM CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031621Slide · looseAFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA031470Keelbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND KEEL BEAM CORRODED AT BS 520-540. REPAIRED KEEL BEAM PER SWA EA.SDR SWAA031469Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR AFT FRAME T-CHORD CRACKED AT NR 3 STOP FITTING. REM0VED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA031457Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 706, LBL 57. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA031404Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER TIE CLIPS CRACKED (2 EA) BS 663 AT STR 10R, AND BS 633 AT STR 10L. REMOVED AND REPLACED STRINGER TIE CLIPS PER SRM.SDR SWAA031395Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 26L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA031394Lens · damagedDURING SCHEDULED 1/2D CHECK, FOUND RT OVERWING EXTERIOR EMERGENCY EXIT LIGHT LENS CLOUDED. REMOVED AND REPLACED EXIT LIGHT LENS PER MM.SDR SWAA031390Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE FWD AND AFT GIRT BAR ATTACH FITTINGS CORRODED. REMOVED AND REPLACED ATTACH FITTINGS PER SRM.SDR SWAA031061Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA031060Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND BOTH AFT CABIN DOOR EMERGENCY EVAC SLIDE GIRT ASSY'S OUT OF ADJUST. ADJUSTED BOTH AFT CABIN DOOR SLIDES PER MM.SDR SWAA031059Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030903Line · leakingAIR TURNBACK. LOST A-SYSTEM HYDRAULICS. FOUND, HYD LINE LEAKING AT RT MLG ACTUATOR UPSIDE. REMOVED AND REPLACED HYD LINE FOR RT MLG ACTUATOR PER MM.SDR SWAA030671Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED (7 EA) AT BS 178, BETWEEN LBL 6 & RBL 12. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA030292Skin · bulgedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN BULGED BETWEEN BS 727 AND BS 727A, ABOVE STR 8L. REPAIRED SKIN PER SWA EA.SDR SWAA020993Sensor · malfunctionedDURING FLT, BOTH NLG RED AND GREEN LIGHTS REMAINED ILLUMINATED AFTER GEAR RETRACTION. REMOVED AND REPLACED S845 SWITCH PER MM.SDR SWAA013262Bypass Valve · erraticT/E FLAPS WOULD NOT STOP AT 35 DEGS WHEN FLAP HANDLE WAS MOVED FROM 30 TO 40 DEGS. WORKS OK ON THE GROUND. REMOVED AND REPLACED T/E FLAP BYPASS VALVE AND FLAP DRIVE MOTOR PER MM.
Back to N671SW, cancelled Jan 3, 2013