N342SW, cancelled Oct 26, 2017
Service difficulty reports · 250
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 = 'N342SW' AND deregistration_id = 'N342SW-2017-10-26' 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 = 'N342SW' AND deregistration_id = 'N342SW-2017-10-26' 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 SWAA082705Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, BETWEEN STR 24L AND STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA081381Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 739D, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA081380Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 743, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA081067Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080011Battery · inoperativeDURING SCHEDULED MV3 CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA075674Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075673Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075513Skin · delaminatedLEFT WING INBOARD NR 3 FLIGHT SPOILER DELAMINATED AT INBOARD CORNER. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA074856Lamp · inoperativeDURING SCHEDULED MV3 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072448Battery · inoperativeDURING SCHEDULED HC1 CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA070804Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070736Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA064958Window · arcedR1 COCKPIT WINDOW ARCED. REMOVED AND REPLACED R1 COCKPIT WINDOW.SDR SWAA064464Stringer · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER 4L CRACKED AT BS 1006 TO BS 1016. REPAIRED STRINGER PER SRM & ER.SDR SWAA064447Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 407, RBL 2. REPAIRED SKIN PER ER.SDR SWAA064407Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND VERTICAL STAB FAIL-SAFE FITTING LT AND RT LUG FACES CORRODED. REPAIRED VERTICAL STAB FAIL-SAFE FITTING PER ER.SDR SWAA064406Attach Fitting · corrodedDURING SCHEDULED 18Y CHECK, FOUND VERTICAL STAB ATTACH FITTING LT AND RT CLEVIS LUG FACES CORRODED. REPAIRED VERTICAL STAB PER ER.SDR SWAA064375Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 273, STR 14R. REMOVED AND REPLACED FRAME WEB PER SRM.SDR SWAA064374Frame · corrodedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 993, STR 17R. REPAIRED FRAME SECTION PER SRM.SDR SWAA064321Beam · crackedDURING SCHEDULED 18Y CHECK, FOUND VERTICAL STAB RIGHT LOWER MID T/E BEAM CRACKED AT LOWER SECTION. REMOVED AND REPLACED STAB LOWER MID T/E BEAM SECTION PER SRM.SDR SWAA064320Shear Tie · crackedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 6L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA064319Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947.5, STR 10R. REPAIRED SKIN SECTION PER SRM.SDR SWAA064318Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 460 TO BS 500B, LBL 70. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR SWAA064317Stringer Splice · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 16L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA064316Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CORRODED AT BS 270, LBL 11 TO RBL 11. REMOVED AND REPLACED FLOORBEAM PER SRM.SDR SWAA064315Mount · corrodedDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR MOUNT CORRODED. REMOVED AND REPLACED AFT GIRT BAR MOUNT PER SRM.SDR SWAA064314Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 42 TO RBL 58. REPAIRED FLOORBEAM PER SRM.SDR SWAA064313Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA064312Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA064311Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA064310Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064309Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064308Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4L AND STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064307Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4L AND STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064306Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 4L AND STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064305Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064304Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 737E, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064303Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064302Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064301Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064300Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064299Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1138, STR 15L. REMOVED AND REPLACED STRINGER CLIP PER SRM AND BOEING DRAWING.SDR SWAA064256Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA064255Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 420 TO BS 440, LBL 70. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR SWAA064254Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, RBL 1 TO LBL 11. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA064253Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 793, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA064210Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 9R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA064209Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064208Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064207Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 3L. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N342SW, cancelled Oct 26, 2017