N344SW, cancelled Oct 26, 2017
Service difficulty reports · 292
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 = 'N344SW' AND deregistration_id = 'N344SW-2017-10-26' 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 = 'N344SW' AND deregistration_id = 'N344SW-2017-10-26' 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 SWAA091539Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 2 SLAT O/B END UPPER T/E LOWER SURFACE DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA091538Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT CREASE BEAM CORRODED BETWEEN BS 747 TO BS 797, WL 208. REPAIRED BEAM PER SRM.SDR SWAA091537Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091536Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 16R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091535Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091485Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 500, STR 28R. REPAIRED FRAME PER SRM.SDR SWAA091462Stringer · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CORRODED AT BS 980, STR 27L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA091461Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091460Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091432Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 328, RBL 30. REPAIRED BEAM PER SRM.SDR SWAA091431Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 270, LBL 18. REPAIRED BEAM PER SRM.SDR SWAA091430Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 328, LBL 30. REPAIRED BEAM PER SRM.SDR SWAA091429Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 709 TO BS 713, WL 202, BL 0. REPAIRED WEB PER SI.SDR SWAA091370Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091369Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091368Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA091367Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091366Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091365Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091237Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER EA.SDR SWAA091236Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT KEEL BEAM CORRODED AT BS 500D. REPAIRED KEEL BEAM PER SRM.SDR SWAA091235Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 21L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091234Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 25L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091233Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 25R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA090629Skin · crackedDURING SCHEDULED SC CHECK, FOUND SKIN CRACKED AT BS 517, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA090628Skin · crackedDURING SCHEDULED SC CHECK, FOUND SKIN CRACKED AT BS 727E, BETWEEN STR 19R TO STR 20R. REPAIRED SKIN PER SWA EA.SDR SWAA090175Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND R1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA086192Light · inoperativeDURING SCHEDULED RON CHECK, FOUND R1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA085181Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND R1 EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA084144Charger · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND RT AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA084111Charger · faultyDURING SCHEDULED SERVICE CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. R&R BATTERY CHARGER PER MM.SDR SWAA084016Sign · missingAFT CABIN EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN PER MM.SDR SWAA082859Slide · low pressureDURING SCHEDULED MV1 CHECK, L2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA082245Hinge · brokenDURING SCHEDULED C2 CHECK, FOUND RIGHT WING NR 5 SPOILER HINGE AT OUTBOARD ACTUATOR BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA082150Skin · delaminatedRIGHT NR 6 SPOILER DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA082151Skin · delaminatedRIGHT NR 9 SPOILER DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA081348Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080547Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 390, RBL 2. REPAIRED SKIN PER EA.SDR SWAA080551Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 291, STR 16R. REPAIRED SKIN PER EA.SDR SWAA080550Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA080548Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, LBL 2. REPAIRED SKIN PER EA.SDR SWAA080549Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, BL 0. REPAIRED SKIN PER EA.SDR SWAA080520Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080300Fitting · looseR1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA080101Lens · missingDURING SCHEDULED C1 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 6ABC. INSTALLED LENS PER MM.SDR SWAA080100Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074837Lamp · inoperativeDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074836Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 978, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA074101Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073013Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.
Back to N344SW, cancelled Oct 26, 2017