N351SW, cancelled Sep 8, 2017
Service difficulty reports · 332
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 = 'N351SW' AND deregistration_id = 'N351SW-2017-09-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 = 'N351SW' AND deregistration_id = 'N351SW-2017-09-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 SWAA092470Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 303, STR 16L. REPAIRED WEB PER ACO.SDR SWAA092469Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND RADIO ALTIMETER BELLY SKIN CUTOUT CRACKED AT BS 390, LBL 4. REPAIRED SKIN PER SWA EA.SDR SWAA092449Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 302.2, BETWEEN WL 262 TO WL 258. REPAIRED SKIN PER SWA EA.SDR SWAA092448Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BETWEEN BS 304.55 TO BS 303, BETWEEN WL 238.3 TO WL 235. REPAIRED SKIN PER SWA EA.SDR SWAA092413Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, BL 0. REPAIRED BEAM PER SWA EA.SDR SWAA092312Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS BS 867, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092311Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727B, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092310Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 597, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092313Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 667 AT LOWER CHORD. REPAIRED BEAM PER SWA EA.SDR SWAA092287Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727C, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092286Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BETWEEN BS 290 TO BS 293, BETWEEN WL 229.50 TO WL 259. REPAIRED SKIN PER SWA EA.SDR SWAA092249Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BETWEEN BS 296.5 TO BS 307.5, BETWEEN WL 278 TO WL 285. REPAIRED SKIN PER SWA EA.SDR SWAA092248Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727A, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092193Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092192Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092191Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 807, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092190Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092189Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727E, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092188Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND RADIO ALTIMETER FUSELAGE BELLY SKIN CUTOUT CRACKED BETWEEN BS 394 TO BS 454, BETWEEN RBL TO LBL 4. REPAIRED SKIN PER SWA EA.SDR SWAA092127Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 14L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092073Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA092072Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 727E, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA092049Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM I/B UPPER CHORD CRACKED AT BS 727A+17, LBL 45. REPAIRED CHORD PER SWA EA.SDR SWAA091513Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA090084Slide · out of positionL2 DOOR EMERGENCY EVACUATION SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA085132Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA084534Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. R&R LIGHT BULB PER MM.SDR SWAA083452Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA083422Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA082327Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA082131Sign · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA081793Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081720Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081692Hinge · wornDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 4 SPOILER INBOARD HINGE WORN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA081691Flap · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING INBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081539Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA080936Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 462 AND BS 466, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA080351Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 263.5, STR 9L. REPAIRED SKIN PER SWA EA.SDR SWAA076386Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA076387Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 505D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA075496Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075125Battery · dischargedFWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA074839Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074707Glowstrip · wornDURING SCHEDULED HC1 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 3 ABC. REMOVED AND REPLACED STRIP PER MM.SDR SWAA074708Lens · looseDURING SCHEDULED HC1 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 2 ABC. SECURED LENS PER MM.SDR SWAA074656Lens · looseDURING SCHEDULED HC1 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 2 ABC. SECURED LENS PER MM.SDR SWAA072633Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072511Slide · out of adjustDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072510Lens · looseDURING SCHEDULED MV2 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LIGHT LENS PER MM.SDR SWAA071502Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 310, STR 18R. REPAIRED SKIN PER SWA EA.
Back to N351SW, cancelled Sep 8, 2017