N686SW, cancelled Feb 16, 2018
Service difficulty reports · 388
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 = 'N686SW' AND deregistration_id = 'N686SW-2018-02-16' 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 = 'N686SW' AND deregistration_id = 'N686SW-2018-02-16' 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 SWAA074697Lamp · inoperativeDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074629Glowstrip · delaminatedDURING SCHEDULED 22Y CHECK, FOUND MID CABIN EEPLS PHOTOLUMINESCENT STRIPS DELAMINATED. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA074627Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA074628Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 23 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA074502Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 12. REPAIRED FLOORBEAM PER EA.SDR SWAA074503Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT EQUIPMENT COOLING DUCT EXHAUST BS 378, BL 0. REPAIRED SKIN PER EA.SDR SWAA074465Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 8R CRACKED AT BS 344. REPAIRED STRINGER PER SRM.SDR SWAA074466Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 12. REPAIRED FLOORBEAM PER EA.SDR SWAA074464Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT CRACKED BS 450, BL 0. REPAIRED SKIN PER EA.SDR SWAA074450Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 28R AND STR 28L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074449Bulkhead · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD CORRODED AT BS 1016, BETWEEN STR 26L AND STR 26R. REPAIRED BULKHEAD PER ACO.SDR SWAA074422Stiffener · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD STIFFENER CORRODED AT BS 1016, BL 0. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA074421Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LEFT WING INBOARD T/E AFT FLAP DELAMINATED AT INBOARD LOWER END. REPAIRED FLAP PER SRM.SDR SWAA074363Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074362Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074290Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074289Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074261Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LEFT WING INBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REPAIRED FLAP PER SRM.SDR SWAA074233Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074232Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074231Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074210Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074187Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071876Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 760, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA071877Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA071875Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 794, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA071874Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA070632Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA065112Stringer Splice · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CORRODED AT BS 25L, BS 360. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA065111Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA065110Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 312, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA065109Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA065108Battery · dischargedDURING SCHEDULED SPV CHECK, FOUND MID CABIN EMERGENCY EXIT BATTERIES INOP. REMOVED AND REPLACED BATTERY PACKS PER MM.SDR SWAA065038Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 22R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA064815Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 964, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA064814Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA063242Flap · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING OUTBOARD AFT FLAP DELAMINATED AT INBOARD LOWER END. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA063241Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062657Line · leakingAIR TURN BAC, DECLARED EMERGENCY MASTER CAUTION AND "B" HYDRAULIC SYSTEM LOW PRESSURE LIGHT ILLUMINATED FOLLOWED BY "B" HYDRAULIC SYSTEM QUANTITY GAUGE DROPPING. REMOVED AND REPLACED HYDRAULIC LINE AT "B" SYSTEM ACOUSTIC FILTER AND "B" SYSTEM CASE DRAIN FILTESDR SWAA062172Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 847, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA062171Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 803, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA062169Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 760, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA062168Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 765, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA061671Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND L2 DOOR EMERGENCY EXIT EVAC SLIDE CABLE MISROUTED. REROUTED EVAC SLIDE CABLE PER MM.SDR SWAA061285Coffeemaker · faultyBURNING SMELL IN FWD GALLEY. REMOVED AND REPLACED FWD COFFEEMAKER PER MM.SDR SWAA060471Glowstrip · wornDURING SCHEDULED C2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 8 ABC. REMOVED AND REPLACED STRIP PER MM.SDR SWAA060470Bulb · inoperativeDURING SCHEDULED C2 CHECK, FOUND AFT CABIN RT LOWER EMERGENCY EXIT LIGHTS INOP. RELAMPED LIGHTS PER MM.SDR SWAA053433Skin · corrodedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 360, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA053432Stringer · corrodedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 360, STR 26R. REPAIRED STRINGER PER SRM.SDR SWAA053431Window · arcedR1 COCKPIT WINDOW ARCED & CRACKED. REMOVED AND REPLACED R1 WINDOW PER MM.
Back to N686SW, cancelled Feb 16, 2018