N506SW, cancelled Nov 8, 2013
Service difficulty reports · 277
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 = 'N506SW' AND deregistration_id = 'N506SW-2013-11-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 = 'N506SW' AND deregistration_id = 'N506SW-2013-11-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 SWAA094790Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094789Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094788Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094786Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, LBL 33. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094785Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094784Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094783Slat · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 3 SLAT DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA094782Slat · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 4 SLAT DELAMINATED AT I/B END. REPAIRED SLAT PER SRM.SDR SWAA094734Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094733Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094732Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094731Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094730Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094728Slat · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 6 SLAT I/B END DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA094697Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094696Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094695Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094694Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094654Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094653Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094652Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094651Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094650Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094649Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091948Fuse · blownL1 DOOR LIGHT INOP. REMOVED AND REPLACED FUSE PER MM.SDR SWAA090553Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 813, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA090552Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 933, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA090551Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 760, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA085958Slide · out of positionL1 DOOR EMERGENCY EXIT SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED SLIDE PER MT.SDR SWAA085754Slide · out of adjustFOUND L1 DOOR EMERGENCY ESCAPE SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA084588Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FWD CARGO DOOR SKIN CRACKED AT DOOR HANDLE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA084587Cable · frayedDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE CABLE FRAYED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA083260Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA082825Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 470, STR 1. REPAIRED SKIN PER SRM.SDR SWAA082824Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 406, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA082821Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT ELEVATOR UPPER SURFACE DELAMINATED. REPAIRED ELEVATOR PER SRM.SDR SWAA082823Stiffener · crackedDURING SCHEDULED SPV CHECK, FOUND VERTICAL STIFFENER AT BS 178, RBL 5.7. REPAIRED STIFFENER PER SRM.SDR SWAA082822Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 967, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA082699Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA080424Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 926, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA080425Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 951, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA076075Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA075129Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LEFT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA075011Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA073717Slide · unwanted deployDURING SCHEDULED 18Y CHECK, L1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA073708Lens · looseDURING SCHEDULED 18Y CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA073664Keelbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND KEEL BEAM CORRODED AT BS 487B, STR 28R. REPAIRED KEEL BEAM PER SRM.SDR SWAA073656Door Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME WEB CRACKED AT LOWER OUTBOARD CORNER. REMOVED AND REPLACED FRAME WEB PER ACO.SDR SWAA073551Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA073553Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.
Back to N506SW, cancelled Nov 8, 2013