N504SW, cancelled Oct 27, 2017
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 = 'N504SW' AND deregistration_id = 'N504SW-2017-10-27' 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 = 'N504SW' AND deregistration_id = 'N504SW-2017-10-27' 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 SWAA094886Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094885Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094872Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA094871Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA094870Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA094869Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA094854Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094853Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094787Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 1. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093536Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 413, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA093535Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 436, STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA091199Housing · brokenDURING SCHEDULED HC1 CHECK, FOUND LT EMERGENCY LIGHT BATTERY PACK HOUSING BROKEN. REMOVED AND REPLACED HOUSING PER MM.SDR SWAA090550Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA090229Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 827, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA090228Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 482A, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA090184Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 2 SLAT L/E SKIN CRACKED AT THE INBOARD AUXILIARY TRACK. REPAIRED SKIN PER SRM.SDR SWAA090183Skin · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR SKIN CUTOUT CRACKED AT LOWER FWD CORNER. REPAIRED SKIN PER ER.SDR SWAA090005Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT WING NR 6 SLAT L/E LOWER SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA085853Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 435, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA085609Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 800, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA084512Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA084491Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA083996Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 390, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA083997Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 460, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA082637Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA080721Pressure Panel · crackedDURING SCHEDULED HC1 CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 664, RBL 40. REPAIRED WEB PER SRM.SDR SWAA075591Actuator · faultyRIGHT MLG WOULD NOT REMAIN UP ON INITIAL RETRACTION. SECOND ATTEMPT GEAR STAYED UP. REMOVED AND REPLACED RIGHT MLG UPLOCK ACTUATOR PER MM.SDR SWAA074729Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA074461Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073666Frame · corrodedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 992, RBL 46. REPAIRED FRAME PER ER.SDR SWAA073600Floorbeam · corrodedDURING SCHEDULED RON, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986.5, RBL 44. REPAIRED FLOORBEAM PER ER.SDR SWAA073500Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT STR 4L. REPAIRED FRAME PER SRM.SDR SWAA073434Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND VERTICAL FIN PRIMARY FITTING CLEVIS LUGS CORRODED. REPAIRED FITTING CLEVIS LUGS PER ER.SDR SWAA073433Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 406, RBL 1. REPAIRED SKIN PER ER.SDR SWAA073245Cable · brokenDURING SCHEDULED 18Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE CABLE BROKEN. R&R EVAC SLIDE CABLE PER MM.SDR SWAA073244Hook · looseDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED HOOK PER SRM.SDR SWAA073243Hook · looseDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED HOOK PER SRM.SDR SWAA073211Flap · debondedDURING SCHEDULED 18Y CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DISBONDED. REPAIRED FLAP PER SRM.SDR SWAA073210Hinge · crackedDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR LOWER GATE HINGE CRACKED. R&R LOWER GATE HINGE PER SRM.SDR SWAA073209Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 304, STR 16L. REPAIRED FRAME PER SB.SDR SWAA073195Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073194Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073198Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 420 AND BS 440, LBL 69. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA073197Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT RT BS 616, LOWER ATTACH FASTENERS WL 201. REPAIRED FRAME PER SB.SDR SWAA073196Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT LT BS 616, LOWER ATTACH FASTENERS WL 201. REPAIRED FRAME PER SB.SDR SWAA073193Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 294, RBL 38. REPAIRED FLOORBEAM CHORD PER SRM.SDR SWAA073140Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073142Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947.5, LBL 5. REPAIRED FLOORBEAM PER SRM.SDR SWAA073132Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073131Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.
Back to N504SW, cancelled Oct 27, 2017