N323SW, cancelled Jul 17, 2013
Service difficulty reports · 396
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 = 'N323SW' AND deregistration_id = 'N323SW-2013-07-17' 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 = 'N323SW' AND deregistration_id = 'N323SW-2013-07-17' 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 SWAA082349Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA082305Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR CUTOUT UPPER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA082306Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FWD CARGO DOOR OUTER SKIN CRACKED AT DOOR HANDLE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA081719Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA075518Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 407 AND BS 414, STR 26L. REPAIRED SKIN PER SWA EA.SDR SWAA075451Web · crackedDURING SCHEDULED HC2 CHECK, FOUND NOSE W/W UPPER CEILING PANEL WEB CRACKED AT BS 229, RBL 16. REPAIRED CEILING PANEL PER SWA EA.SDR SWAA075450Web · crackedDURING SCHEDULED HC2 CHECK, FOUND NOSE W/W UPPER RIGHT CEILING PANEL WEB CRACKED. REPAIRED CEILING PANEL PER ACO.SDR SWAA074222Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 289, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA074165Lens · missingRIGHT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LIGHT LENS PER MM.SDR SWAA073916Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 460, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA073612Battery · dischargedDURING SCHEDULED MV2 CHECK, FOUND AFT CABIN LOWER EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA073394Wire · frayedDURING SCHEDULED MV2 CHECK, INTERIOR EMERGENCY EXIT LIGHTS ILLUMINATED INTERMITTENTLY. FOUND FRAYED WIRE AT AFT FLIGHT ATTENDANT SWITCH. REPAIRED WIRE PER MM.SDR SWAA072929Battery · faultyMID CABIN EMERGENCY EXIT LIGHTS STAY ON WITH SWITCH IN ARM POSITION. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA071933Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA071934Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 943, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA071445Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 582, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA071444Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 563, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA071446Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 572, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA063976Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA063975Battery Pack · dischargedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA063938Wire · brokenDURING SCHEDULED 20Y CHECK, FOUND AFT CABIN EMERGENCY EXIT SIGN INOP. REPAIRED BROKEN WIRE PER MM.SDR SWAA063937Bracket · looseDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FLOOR BRACKET LOOSE. REMOVED AND REPLACED GIRT BAR FLOOR BRACKET PER MM.SDR SWAA063917Connector · looseDURING SCHEDULED 20Y CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. SECURED LOOSE CONNECTOR PER MM.SDR SWAA063902Connector · looseDURING SCHEDULED 20Y CHECK, FOUND OVERHEAD FWD CABIN EMERGENCY EXIT SIGN INOP. SECURED LOOSE CONNECTOR PER MM.SDR SWAA063901Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 13 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA063833Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CRACKED AT BS 663, BL 0. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA063814Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 20R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063789Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED AFT GIRT BAR FITTING PER SRM.SDR SWAA063788Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 294, STR 17R. REPAIRED FRAME SECTION PER SRM.SDR SWAA063775Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA063774Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA063773Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA063745Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 747, STR 26R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA063620Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L. REPAIRED FRAME SECTION PER SRM.SDR SWAA063565Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L. REPAIRED FRAME SECTION PER SRM.SDR SWAA063564Aileron · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING AILERON DELAMINATED ON INBOARD END. REPAIRED AILERON PER SRM.SDR SWAA063523Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 10L. REMOVED AND REPLACED STRINGER CLIP IAW SRM.SDR SWAA063508Stringer Clip · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 747, STR 26R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063507Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CRACKED AT BS 328, LBL 12. REPAIRED FLOORBEAM PER SRM.SDR SWAA063463Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING OUTBOARD FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA063360Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP LOWER SURFACE DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA063359Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT MLG BEAM INBOARD AFT ATTACH FITTING CORRODED. REMOVED AND REPLACED LT MLG ATTACH FITTING PER MM.SDR SWAA063315Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA062878Bulkhead · crackedDURING SCHEDULED C1 CHECK, FOUND AFT PRESSURE BULKHEAD CRACKED AT BS 1016, STR 6L. REPAIRED BULKHEAD PER SRM.SDR SWAA062274Light · inoperativeDURING SCHEDULED PM CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT FWD ENTRY DOOR. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA062175Gusset · crackedDURING SCHEDULED A1 CHECK, FOUND NLG ACTUATOR ATTACH FITTING GUSSETT CRACKED IN RADIUS. REMOVED AND REPLACED GUSSETT FITTING PER SRM.SDR SWAA061974Bolt · wornDURING SCHEDULED C4 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB BOLTS PER MM.SDR SWAA061598Fitting · brokenRIGHT WING INBOARD GROUND SPOILER OUTBOARD FITTING BROKEN AT LOWER ATTACH LUG. REPAIRED SPOILER FITTING PER SWA EA.SDR SWAA061392Bolt · wornDURING SCHEDULED C4 CHECK, LT ELEVATOR INBOARD TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR INBOARD TAB BOLTS PER MM.SDR SWAA060807Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 507A, STR 26R. REPAIRED SKIN PER SRM.
Back to N323SW, cancelled Jul 17, 2013