N507SW, cancelled Jan 29, 2014
Service difficulty reports · 338
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 = 'N507SW' AND deregistration_id = 'N507SW-2014-01-29' 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 = 'N507SW' AND deregistration_id = 'N507SW-2014-01-29' 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 SWAA096141Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096140Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095092Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 916, STR 24L. REPAIRED SKIN PER AAR EA.SDR SWAA095044Web · corrodedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO PIT FLOORBEAM VERTICAL SUPPORT WEB CORRODED BETWEEN BS 927 TO BS 947, STR 26R. REMOVED AND REPLACED WEB PER BAC DWG.SDR SWAA095043Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 943, STR 23L. REPAIRED SKIN PER AAR EA.SDR SWAA095023Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA095007Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND LT AFT EMERGENCY EXIT BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA094893Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 914, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA094892Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 913, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA092653Flap · delaminatedDURING SCHEDULED 2HC1 CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA092652Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 911, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA092557Strip · looseEEPLS CLEAR STRIP LOOSE. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA092028Ballast · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BALLAST PER MM.SDR SWAA091601Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 291, WL 254, RT SIDE. REPAIRED SKIN PER ER.SDR SWAA091553Skin · crackedDURING SCHEDULED SPV CHECK, FOUND GALLEY DOOR SKIN CUTOUT CRACKED AT BS 291, WL 254. REPAIRED SKIN PER ER.SDR SWAA091379Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA086556Battery · dischargedFOUND AFT EMERGENCY FLASHLIGHT INOP. R&R BATTERY PER MM.SDR SWAA085652Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 434, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA085231Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT FWD FUSE BS 400, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA085230Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 344, STR 22R TO 23R. REPAIRED SKIN PER SRM.SDR SWAA085044Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA084543Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 265 AND BS 271, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA081798Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 831, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA081797Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 920, STR 24L AND STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA081412Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 395, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA081385Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 395, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA075820Lamp · inoperativeDURING SCHEDULED MV2 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 5 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075819Lamp · inoperativeDURING SCHEDULED MV2 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 3 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075707Torque Tube · wornDURING SCHEDULED SERVICE CHECK, NR 4 FLAP TRANSMISSION TO 120 DEGREE GEARBOX TORQUE TUBE WORN. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA075706Torque Tube · wornDURING SCHEDULED SERVICE CHECK, NR 4 FLAP TRANSMISSION TO 90 DEGREE GEARBOX TORQUE TUBE WORN. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA074792Battery · inoperativeDURING SCHEDULED BRDG CHECK, FOUND FWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA074791Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA074738Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA074715Battery · inoperativeDURING SCHEDULED BRDG CHECK, FOUND FWD CABIN EMERGENCY EXIT FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA074614Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REPAIRED FRAME PER SWA EA.SDR SWAA074513Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074512Bear Strap · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT BS 303.9, STR 10L TO STR 13L. REPAIRED SKIN PER SWA EA.SDR SWAA074458Bear Strap · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN BEAR STRAP CRACKED AT BS 847, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA074385Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 328, STR 6R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074386Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 1010, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074384Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 328, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074390Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9R. REPAIRED FRAME PER SWA EA.SDR SWAA074387Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074388Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074383Shear Tie · corrodedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 277, STR 11L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA074382Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CORRODED AT BS 277, STR 9L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA074389Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074291Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 12L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074265Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074264Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N507SW, cancelled Jan 29, 2014