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 SWAA113417Stringer Clip · crackedDURING SCHEDULED 22Y CHECK FOUND, STRINGER CLIP 15R CRACKED AT BS 277, 15R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA113320Stringer Clip · crackedDURING SCHEDULED 22Y CHECK FOUND LT CARGO COMPARTMENT STRINGER CLIP CRACKED, BS 767 STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113319Web · crackedDURING SCHEDULED 22Y CHECK FOUND CRACKS FLIGHT DECK FLOOR WEB, BS 247 RBL 24. REPAIRED PER DOC.SDR SWAA113260Skin · crackedDURING SCHEDULED MV1 CHECK FOUND CRACK IN FUSELAGE SKIN STA 492, STR 162. REPAIRED PER SRM.SDR SWAA113259Skin · crackedDURING SCHEDULED MV1 CHECK FOUND FUSELAGE CRACK AT STA 843 JUST ABOVE STR 16L CRACK. REPAIRED PER SRM.SDR SWAA113055Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 492, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA113054Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 843, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA110783Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 265.5, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA107915Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 413, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA107664Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107663Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 482B, STR 7R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107616Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107615Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA105751Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR BS 948.5, STR 11R. REPAIRED SKIN PER SRM.SDR SWAA105750Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR BS 989.5, STR 7L. REPAIRED SKIN PER SRM.SDR SWAA105777Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 948.5, STR 12R. REPAIRED SKIN PER SRM.SDR SWAA103438Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 384, STR 15R. REPAIRED SKIN PER EA.SDR SWAA101500Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 933, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA100026Splice · damagedDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LIGHT INOP. REMOVED AND REPLACED SPLICE PER MM.SDR SWAA095573Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 873, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA095572Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA095552Battery Pack · dischargedDURING SCHEDULED 20Y CHECK, FOUND FWD GALLEY EMERGENCY BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA095551Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT RADIO ALTIMETER CUTOUT, BETWEEN BS 410 TO BS 450. REPAIRED SKIN PER AAR EA.SDR SWAA095534Lens · missingDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LIGHT ASSY PER MM.SDR SWAA095533Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT KEEL BEAM LOWER CHORD CORRODED AT BS 482. REPAIRED BEAM PER SRM.SDR SWAA095519Tab · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING AILERON TAB AFT I/B CORNER DELAMINATED. REMOVED AND REPLACED TAB PER MM.SDR SWAA095513Module · faultyDECLARED EMERGENCY, SMOKE AND FUMES FILLED AIRCRAFT WHEN INITIATING DESCENT FROM FL 350. SMOKE DISSIPATED AFTER RUNNING SMOKE AND FUMES CHECKLIST. REMOVED AND REPLACED HYDRAULIC SYS PRESSURE MODULE, CHECK VALVES, AND COALESCER BAGS.SDR SWAA095401Flap · puncturedDURING SCHEDULED 20Y CHECK, FOUND LT WING O/B FORE FLAP L/E PUNCTURED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA095162Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 13L TO STR 14L. REPAIRED FRAME PER AAR EA.SDR SWAA095161Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND LT WING LOWER RIB CHORD CRACKED, WBL 135.5, BETWEEN S2 TO S3. REPAIRED CHORD PER ACO.SDR SWAA095139Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 819, BETWEEN STR 22L TO STR 23L. REPAIRED SKIN PER SRM.SDR SWAA095087Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA095005Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095004Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095003Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095002Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 807, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095001Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095000Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094999Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094998Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094984Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663.75, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094929Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094928Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094927Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094926Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094891Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094890Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094889Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094888Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094887Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482, STR 22L. REMOVED AND REPLACED CLIP PER SRM.
Back to N504SW, cancelled Oct 27, 2017