N343SW, cancelled Oct 27, 2017
Service difficulty reports · 247
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 = 'N343SW' AND deregistration_id = 'N343SW-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 = 'N343SW' AND deregistration_id = 'N343SW-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 SWAA090108Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087402Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087401Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087389Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA085202Skin · crackedDURING SCHEDULED C2 CHECK, FOUND SKIN CRACKED AT BS 792, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA084273Light · inoperativeDURING SCHEDULED A2 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA084172Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA083073Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA083072Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 506D, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA082916Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA081748Gasper Fan · faultyCREW REPORTS ELECTRICAL SMELL IN CABIN. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA080893Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, BL 0. REPAIRED SKIN PER SWA EA.SDR SWAA080895Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, LBL 2. REPAIRED SKIN PER SWA EA.SDR SWAA080894Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, RBL 3. REPAIRED SKIN PER SWA EA.SDR SWAA080740Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730D, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA080024Slide · out of adjustDURING SCHEDULED THRU CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA076018Hook · looseR2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED HOOK PER MM.SDR SWAA075893Light · brokenDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA074972Stringer · crackedDURING SCHEDULED SERVICE CHECK, FOUND STRINGER 17L CRACKED AT BS 809. REPAIRED STRINGER PER SRM.SDR SWAA070059Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070058Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 933, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA065130Fuse · faultyAIR TURNBACK, AFTER TAKEOFF NOSE GEAR WOULD NOT RETRACT. RED UNSAFE LIGHT ILLUMINATED, CYCLED GEAR, NO HELP. REMOVED AND REPLACED NLG HYDRAULIC FUSE PER MM.SDR SWAA064487Lamp · inoperativeDURING SCHEDULED A1 CHECK, FOUND RT OVERWING DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA063589Lens · missingDURING SCHEDULED C3 CHECK, FOUND OVERHEAD EMERGENCY EXIT SIGN LENS MISSING AT ROW 22. INSTALLED EXIT SIGN LENS PER MM.SDR SWAA062128Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA061961Battery Pack · dischargedDURING SCHEDULED 1/4D CHECK, FOUND MID EMERGENCY EXIT LIGHT INOP AT BS 431, BL 0, WL 289. REMOVED AND REPLACED EMERGENCY EXIT BATTERY PACK PER MM.SDR SWAA061936Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 378, RBL 1.5 TO RBL 3.5. REPAIRED SKIN PER SWA EA.SDR SWAA061935Lens · looseDURING SCHEDULED 1/4D CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 4 DEF. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA061934Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FRAME CUTOUT CRACKED AT FWD LOWER STOP FITTING BS 303, STR 16L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061888Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AFT OF RADIO ALTIMETER ANTENNA, BS 395, BL O. REPAIRED SKIN PER SWA EA.SDR SWAA061872Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 DOOR SKIN CRACKED AT LOWER HINGE CUTOUT UPPER CORNER. REMOVED AND REPLACED R1 DOOR PER MM.SDR SWAA061871Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 24R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061870Angle · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER ANGLE CRACKED AT BS 301, STR 6L. REMOVED AND REPLACED STRINGER ANGLE PER SRM.SDR SWAA061869Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE UPPER FRAME ANGLE CRACKED AT BS 294, STR 10L. REMOVED AND REPLACED FRAME ANGLE PER SRM.SDR SWAA061868Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE LOWER FRAME ANGLE CRACKED AT BS 294, STR 10L. REMOVED AND REPLACED FRAME ANGLE PER SRM.SDR SWAA061867Light · looseDURING SCHEDULED 1/4D CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LOOSE AT ROW 15 DEF. SECURED BULLNOSE LIGHT PER MM.SDR SWAA061866Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND BULKHEAD WEB CRACKED AT BS 295, STR 16L. REPAIRED WEB SECTION PER SRM.SDR SWAA061859Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061807Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 744, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA060628Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA060562Skin · delaminatedLT WING NR 3 L/E SLAT UPPER SKIN, OUTBD AFT EDGE DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA060555Skin · delaminatedLT WING NR 3 L/E SLAT UPPER SKIN, OUTBOARD AFT EDGE DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA060076Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 780.50, BETWEEN STR 18L TO STR 19L. REPAIRED SKIN IAW EA AND SRM.SDR SWAA060075Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 929.75 TO BS 931.50, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA053562Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 739D, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA052746Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT EXTERIOR FUSELAGE LIGHTS INOP. RELAMPED LIGHTS PER MM.SDR SWAA050048Skin · delaminatedDURING SCHEDULED C1 CHECK, FOUND RT WING INBOARD T/E FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA050022Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 950, ABOVE STRINGER 19R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043670Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 978, STRINGER 21L, CRACKED. REPAIRED SKIN SECTION PER EA.SDR SWAA043446Cable · misroutedDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EVAC SLIDE GIRT BAR CABLE MISROUTED. REROUTED CABLE PER MM.
Back to N343SW, cancelled Oct 27, 2017