N699SW, cancelled Oct 30, 2013
Service difficulty reports · 338
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 = 'N699SW' AND deregistration_id = 'N699SW-2013-10-30' 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 = 'N699SW' AND deregistration_id = 'N699SW-2013-10-30' 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 SWAA085071Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT AIR STAIR CUTOUT LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA084974Battery Pack · inoperativeDURING SCHEDULED 22Y CHECK, FOUND RT FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA084953Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 24R CORRODED AT BS 324. REPAIRED STRINGER PER SRM.SDR SWAA084859Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 12. REPAIRED FLOORBEAM PER SRM.SDR SWAA084813Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 12. REPAIRED FLOORBEAM PER SRM.SDR SWAA084812Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND LT WING STABILIZER LINK LUG CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA084774Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, LBL 17. REPAIRED WEB PER SRM.SDR SWAA084773Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING INBOARD FORE FLAP UPPER SURFACE DELAMINATED AT OUTBOARD END. REPAIRED FLAP PER SRM.SDR SWAA084772Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084310Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA084199Battery · dischargedDURING SCHEDULED MV3 CHECK, FOUND FWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA083561Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA082226Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA082225Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA081149Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 410 AND BS 430, BL 0. REPAIRED SKIN PER EA.SDR SWAA080731Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080705Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075638Skin · delaminatedRIGHT WING NR 9 GROUND SPOILER DELAMINATED AT OUTBOARD END. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA075390Lamp · inoperativeDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA075086Strip · wornDURING SCHEDULED HC2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT FWD CABIN. REMOVED AND REPLACED STRIP PER MM.SDR SWAA075085Light · brokenDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075087Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 806, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA073432Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730B, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA071837Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 504C, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA071838Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 513D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA070464Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA064540Torque Tube · disconnectedDECLARED EMERGENCY, ON APPROACH FLAPS WOULD NOT EXTEND BEYOND 2. FOUND LEFT WING INBOARD 90 DEGREE ANGLE GEAR BOX TORQUE TUBE DISCONNECTED, RECONNECTED TORQUE TUBE PER MM.SDR SWAA064370Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 970, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA063748Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063720Wire · faultyDURING SCHEDULED 20Y CHECK, WHEN PLACING EMERGENCY EXIT LIGHT SWITCH TO OFF POSITION, ALL OF THE MAIN CABIN LOWER EXIT LIGHTS REMAIN ILLUMINATED. REMOVED AND REPLACED WIRE W132-022-22 PER WDM.SDR SWAA063696Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR AFT FRAME CRACKED AT NR 3 DOOR STOP. REPAIRED DOOR FRAME SECTION PER SRM.SDR SWAA063630Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 1006, STR 27R TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA063629Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 987, STR 27L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063628Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 968 TO BS 979, STR 24L TO STR 26L. REPAIRED SKIN PER SWA EA.SDR SWAA063604Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CHORD CORRODED AT LT BS 540. REPAIRED KEEL BEAM CHORD PER SRM.SDR SWAA063603Stringer · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER 27L CRACKED AT BS 987. REPAIRED STRINGER SECTION PER SRM.SDR SWAA063602Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 971, STR 26L. REPAIRED SKIN PER SWA EA.SDR SWAA063585Beltframe · crackedDURING SCHEDULED 20Y CHECK, FOUND BELT FRAME CRACKED AT BS 1006, STR 27L AND 27R. REPAIRED BELT FRAME PER SRM.SDR SWAA063584Beltframe · corrodedDURING SCHEDULED 20Y CHECK, FOUND BELT FRAME CORRODED AT BS 360, STR 28L AND 28R. REPAIRED BELT FRAME PER SRM.SDR SWAA063583Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 360, STR 28R. REPAIRED SKIN PER SRM.SDR SWAA063582Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 989, STR 27L. REPAIRED SKIN PER SRM.SDR SWAA063537Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 948, STR 25R. REMOVED AND REPLACED STRINGER CLIP IAW SRM.SDR SWAA063536Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 948, STR 22L. REMOVED AND REPLACED STRINGER CLIP IAW SRM.SDR SWAA063535Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 18L. REMOVED AND REPLACED STRINGER CLIP IAW SRM.SDR SWAA063519Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 948, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063497Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER TEE CHORD CRACKED AT BS 669, LBL 24.5. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA063496Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER TEE CHORD CRACKED AT BS 662, LBL 24.5. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA063495Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 23L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063494Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063457Beltframe · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BELTFRAME CORRODED AT BS 1006 BETWEEN STR 27L AND 27R. REPAIRED BELTFRAME PER SWA EA.
Back to N699SW, cancelled Oct 30, 2013