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 SWAA063443Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827 BETWEEN STR 27R AND 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA063442Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 22R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063391Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN TEAR STRAP CRACKED AT BS 747, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA062627Sign · brokenEMERGENCY EXIT SIGN BROKEN AT R1 DOOR. REMOVED AND REPLACED EMERGENCY EXIT SIGN IAW MM.SDR SWAA062100Glowstrip · wornDURING SCHEDULED C3 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 1 DEF. REMOVED AND REPLACED PHOTOLUMINESCENT STRIP PER MM.SDR SWAA062033Battery · dischargedFWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA061635Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA061634Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 777, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA060776Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA060775Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA054059Bulb · inoperativeDURING SCHEDULED A2 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. RELAMPED LIGHTS PER MM.SDR SWAA054058Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND LEFT WING NR 2 SPOILER DELAMINATED. REMOVED AND REPLACED NR 2 SPOILER PER MM.SDR SWAA052475Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947.5, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA052465Roller · missingDURING SCHEDULED C4 CHECK, FOUND RT WING INBOARD T/E FOREFLAP MID-TRACK ROLLER MISSING. INSTALLED ROLLER PER MM.SDR SWAA052464Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA052463Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA051317Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 12R. REPAIRED SKIN PER SWA EA.SDR SWAA051196Lamp · inoperativeDURING SCHEDULED A2 CHECK, FOUND R1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED PER MM.SDR SWAA050153Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 747, STRINGER 18L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043709Bulkhead · puncturedDURING SCHEDULED SERVICE CHECK, FOUND RT MLG BULKHEAD WEB PUNCTURED AT BS 727, RBL 24, WL 178. REPAIRED WEB PER SWA EA.SDR SWAA043541Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. REMOVED AND REPLACED R1 DOOR EVAC SLIDE PER MM.SDR SWAA043261Battery · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR OVERHEAD EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA043246Module · leakingAIR TURNBACK, DECLARED EMERGENCY. HYDRAULIC B-SYSTEM FAILURE. REMOVED AND REPLACED B-SYSTEM HYDRAULIC MODULE PER MM.SDR SWAA042931Slide · wornDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EVAC SLIDE GIRT WORN. REMOVED AND REPLACED R1 DOOR EVAC SLIDE PER MM.SDR SWAA042930Bracket · crackedDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EVAC SLIDE FWD MOUNTING BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA042929Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 727E + 5, BELOW STRINGER 19R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041747Girt Bar · dislodgedR1 DOOR EVAC SLIDE GIRT BAR FELL OUT. INSTALLED R1 DOOR EVAC SLIDE GIRT BAR PER MM.SDR SWAA041609Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA041453Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 944, STRINGER 25R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA040883Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAMES AT BS 827, STRINGER 9L AND BS 867, STRINGER 9R, CRACKED. REPAIRED FRAMES PER ER AND SRM.SDR SWAA040876Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAMES AT STRINGER 9R, BS 380, BS 480, BS 747, BS 807, BS 827, BS 887, BS 907, CRACKED. REPAIRED FRAME SECTIONS PER ER.SDR SWAA040875Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAMES AT STRINGER 9L, BS 360, BS 400, BS 440, BS 480, BS 727E, BS 747, BS 807, BS 907, CRACKED. REPAIRED FRAME SECTIONS PER ER.SDR SWAA040877Rib · crackedDURING SCHEDULED D CHECK, FOUND RT WING AT WBL 114, S2, UPPER RIB CRACKED. REPAIRED RT WING RIB PER ER.SDR SWAA040874Skin · damagedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN AT BS 284, BETWEEN STRINGERS 23R AND 24R, CREASED. REPAIRED SKIN PER SRM.SDR SWAA040873Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN AT BS 500A + 5, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040854Fitting · crackedDURING SCHEDULED D-CHECK, FOUND LT MLG BEAM FITTING AT D-HOLE CRACKED. REMOVED AND REPLACED LT MLG FITTING PER ER.SDR SWAA040841Bulkhead · crackedDURING SCHEDULED D CHECK, FOUND BULKHEAD AT BS 1016, STRINGER 23L, CRACKED. REPAIRED BULKHEAD PER ER.SDR SWAA040839Fitting · crackedDURING SCHEDULED D CHECK, FOUND RT MLG BEAM FITTING AT 5 O'CLOCK POSITION CRACKED. REMOVED AND REPLACED BEAM FITTING PER ER.SDR SWAA040838Frame · corrodedDURING SCHEDULED D CHECK, FOUND AFT CARGO DOOR FRAME CUTOUT AT BS 794, STRINGER 20R TO STRINGER 25R, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA040837Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM AT BS 960 TO BS 986, LBL 60 TO LBL 65, WL 208, CORRODED. REPAIRED CREASE BEAM PER SRM.SDR SWAA040817Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED AT BS 520, STRINGER 4R AND BS 867, STRINGER 9R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040816Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CRACKED AT BS 616, STRINGER 4 R. REPAIRED STRINGER PER SRM.SDR SWAA040815Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 360 BETWEEN STRINGERS 14R AND 15R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040814Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE CORRODED AT BS 967, LBL 1. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA040813Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 616, RBL 71, WL 208. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA040804Clip · crackedDURING SCHEDULED D-CHECK, FOUND 3 EA STRINGER CLIPS CRACKED AT BS 727C, STR 22R, STR 21R, & BS 727D, STR 23R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040805Skin · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 911, BETWEEN STR 27L & STR 24L. REPAIRED SKIN PER SRM.SDR SWAA040797Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND 2 CRACKS AT FUSELAGE BULKHEAD, BS 1016, STR 7R, AND OUTBOARD OF DOME CAP. REPAIRED BULKHEAD WEB PER ER.SDR SWAA040796Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 970, STR 7L. REPAIRED FRAME PER SRM.SDR SWAA040795Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED SPLICE PER SRM.
Back to N699SW, cancelled Oct 30, 2013