N510SW, cancelled Sep 15, 2014
Service difficulty reports · 319
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 = 'N510SW' AND deregistration_id = 'N510SW-2014-09-15' 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 = 'N510SW' AND deregistration_id = 'N510SW-2014-09-15' 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 SWAA050897Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT BS 378, LBL 2. REPAIRED SKIN PER SWA EA.SDR SWAA050672Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EXTERIOR EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA043570Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 932, STRINGER 25R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043567Fitting · wornDURING SCHEDULED C3 CHECK, LT ELEVATOR INBOARD TAB HINGE FAILED FREE PLAY CHECK. REMOVED AND REPLACED INBOARD HINGE FITTING PER MM.SDR SWAA043479Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED OUTBOARD T/E AFT FLAP PER MM.SDR SWAA042598Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE EMERGENCY EXIT OVERHEAD LIGHT AND AFT ENTRY SIDEWALL EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA042488Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND R2 AND L2 DOOR EVAC SLIDE CABLES MISROUTED. ROUTED R2 AND L2 DOOR EVAC SLIDE CABLES PER MM.SDR SWAA042126Battery · inoperativeDURING SCHEDULED A2 CHECK, FOUND AFT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA042111Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN AT BS 927, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041726Slide · dislodgedR2 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REMOVED AND REPLACED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041277Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EVAC SLIDE CABLE MISROUTED. REROUTED L2 DOOR EVAC SLIDE DOOR CABLE PER MM.SDR SWAA041229Lens · crackedDURING SCHEDULED PM CHECK, FOUND BULLNOSE LIGHT LENS AT ROW 8 ABC CRACKED. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA040687Slide · out of adjustL2 DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA040198Skin · crackedDURING SCHEDULED C4 CHECK, FOUND RT HORIZONTAL STAB LOWER SKIN CRACKED AT AFT SPAR ATTACHMENT POINT, STATION 90. REPAIRED SKIN CRACK PER SRM.SDR SWAA040183Actuator · brokenDURING SCHEDULED C4 CHECK, FOUND RT WING NR 5 OUTBOARD SPOILER ACTUATOR END BROKEN. REMOVED AND REPLACED NR 5 SPOILER ACTUATOR PER MM.SDR SWAA030945Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAMS CRACKED AT LBL 24, BS 669 & BS 672. REPAIRED FLOORBEAMS PER SWA EA.SDR SWAA030933Skin · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND RT OUTBOARD AFT T/E FLAP DELAMINATED ON BOTTOM SURFACE. REMOVED AND REPLACED RT OUTBOARD AFT T/E FLAP PER MM.SDR SWAA030658Window Post · crackedDURING SCHEDULED C1 CHECK, FOUND CAPT'S UPPER WINDOW POST CRACKED. REPAIRED WINDOW POST PER SRM.SDR SWAA030650Strip · looseDURING SCHEDULED C1 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP LOOSE BETWEEN ROW 6 & ROW 7 ABC. SECURED EEPLS PER MM.SDR SWAA030643Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 882, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA022901Cable · misroutedDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022900Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA022048Bushing · wornT/E FLAP HANDLE WOULD NOT MOVE PAST 5 DEGREES. REMOVED AND REPLACED T/E FLAP HANDLE BUSHING PER MM.SDR SWAA021971Spoiler · crackedDURING WALK AROUND INSPECTION, FOUND NR 5 L/E GROUND SPOILER CRACKED. REMOVED AND REPLACED NR 5 L/E GROUND SPOILER PER MM.SDR SWAA021840Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 890, BETWEEN STR 24R AND STR 25R. REPAIRED SKIN PER SRM.SDR SWAA021084Tab · wornDURING SCHEDULED A2 CHECK, SWA SI 11138-55, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB AND HINGE BUSHINGS FOR NR 1 AND NR 2 HINGE POINTS PER MM.SDR SWAA021083Bushing · wornDURING SCHEDULED A2 CHECK, SWA SI 11138-55, FOUND RT ELEVATOR TAB HINGE BUSHINGS WORN AT NR 1, NR 3, AND NR 4 HINGE ATTACH POINTS. REMOVED AND REPLACED BUSHINGS PER MM.SDR SWAA020735Feel Unit · faultyELEVATOR FEEL FORCE IS LOW, IT TAKES MUCH LESS FORCE THAN NORMAL TO ROTATE OR FLARE THE A/C. REMOVED AND REPLACED ELEVATOR FEEL AND CENTERING UNIT PER MM.SDR SWAA020444Bracket · looseDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FLOOR ATTACH BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA012452Slide · deployedDURING SCHEDULED RON, FWD SVC DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. R&R EVAC SLIDE PER MM.SDR SWAA011552Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011192Blade · fodAIR TURNBACK. FOLLOWING PROBABLE BIRD STRIKE, nr 2 ENGINE HAD UNUSAL SOUND & EXCESSIVE VIBRATION. ACCOMPLISHED BIRD STRIKE INSPECTION & FOUND 4 FAN BLADES BENT. Removed and replaced ALL nr 2 ENG FAN BLADES PER MM & SWA SAM 455.SDR SWAA002343Slide · dislodgedFWD SVC DOOR EMERGENCY EVAC SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002213Battery Pack · inoperativeDURING SCHEDULED D-CHECK AT DALFORT, FOUND BOTH FWD EMERGENCY FLASHLIGHTS INOP. REMOVED AND REPLACED BATTERY PACKS PER MM.SDR SWAA001943Skin · corrodedDURING SCHEDULED D-CHECK AT DALFORT, FOUND FUSELAGE INNER SKIN CORRODED AT STR 7L, BS 727B. REPAIRED SKIN PER SRM.SDR SWAA001942Splice · crackedDURING SCHEDULED D-CHECK AT DALFORT, FOUND STR 4L CRACKED AT SPLICE, BS 908. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA001920Shear Tie · crackedDURING SCHEDULED D-CHECK AT DALFORT, FOUND SHEAR TIE CRACKED AT STR 9R, BS 1040. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA001823Stringer · crackedDURING SCHEDULED D-CHECK , FOUND BS 908, STR CRACK STR 4R. REPAIRED STR PER SRM.SDR SWAA001806Stringer · damagedDURING SCHEDULED D-CHECK AT DALFORT, FOUND DAMAGED STR 7L AT BS 727B. REPAIRED DAMAGED STR PER SRM.SDR SWAA001749Shear Tie · crackedDURING SCHEDULED D-CHECK AT DALFORT, FOUND SHEAR TIE CRACKED AT BS 847, BETWEEN STR 13L AND 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA000016Light · inoperativeEEPLS INOP BETWEEN ROWS 10-14. RESECURED LOOSE WIRE PER MM.SDR SWAA992082Light · inoperativeDURING SCHEDULED SPECIAL VISIT, FOUND EEPLS INOP, ROWS 6 TO 13. REPAIRED WIRING PER WDM.SDR SWAA991879Light · looseEEPLS FWD END LOOSE. REINSTALLED LIGHT ASSY PER MM.SDR SWAA991038Wire · looseEMERGENCY ESCAPE FLOOR TRACK LIGHTS INOP FWD OF ROW 3. RECONNECTED WIRE TO LIGHT PER MM.SDR SWAA990899Bulb · inoperativeDURING SCHEDULED C3 CHECK, FOUND AFT EMERGENCY ESCAPE FLOOR TRACK LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA990482Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD SECTION OF EMERGENCY FLOOR TRACK LIGHTING INOP. SPLICED WIRE TO LAMP ASSY PER MM.SDR SWAA990375Light · inopDURING SCHEDULED CHECK, FOUND NR 2 FRONT FLOOR TRACK LIGHTING TRACK INOP. REPAIRED WIRING AT ROW 2 PER MM.SDR SWAA990344Wire · damagedDURING SCHEDULED CHECK, FOUND FLOOR TRACK LIGHTING LIGHT (NR 2 FROM FRONT) INOP. REPAIRED WIRING AT ROW 2 LIGHT SOCKET, OP CKS OK PER MM.SDR SWAA990340Wire · damagedDURING SCHEDULED CHECK, FOUND FLOOR TRACK LIGHTING LIGHT (NR 2 FROM FRONT) INOP. REPAIRED WIRING AT ROW 2 LIGHT SOCKET, OP CKS OK PER MM.SDR SWAA990135Battery · dischargedDURING SCHEDULED SC CHECK, FOUND RT OVERWING EXIT EMERGENCY LIGHTS INOP. REPLACED BATTERY PACK PER BOEING MM.
Back to N510SW, cancelled Sep 15, 2014