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 SWAA064206Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064205Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064204Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064203Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064202Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064201Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064200Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064199Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA064198Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 738E, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA064182Hook · looseDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOK LOOSE. SECURED FWD GIRT BAR HOOK PER SRM.SDR SWAA064181Hook · looseDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED AFT GIRT BAR HOOK PER SRM.SDR SWAA063643Skin · crackedDURING SCHEDULED C1 CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT OUTER DOOR HANDLE CUTOUT. REPAIRED AFT CARGO DOOR SKIN PER SWA EA.SDR SWAA062495Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 921, STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA062127Structure · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 5 L/E SLAT DELAMINATED. REMOVED AND REPLACED NR 5 L/E SLAT PER MM.SDR SWAA062091Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 315, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA062073Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FOUND FUSELAGE SKIN CRACKED AT BS 921, STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA060779Slide · low pressureR1 DOOR EVACUATION SLIDE PRESS IND BELOW LIMITS. REMOVED AND REPLACED SLIDE ASSY PER MM.SDR SWAA060738Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA053754Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA052946Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA051897Hinge · brokenR2 DOOR UPPER HINGE LINK ASSY BROKEN. REMOVED AND REPLACED HINGE LINK ASSY PER MM.SDR SWAA050937Cover · missingEMERGENCY EXIT LIGHT ASSY MISSING LENS COVER AT ROW 2 ABC. INSTALLED LENS COVER PER MM.SDR SWAA050853Flashlight · inoperativeDURING SCHEDULED A1 CHECK, FOUND FWD RT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT ASSY PER MM.SDR SWAA050484Frame · crackedDURING SPV, FOUND FRAME AT BS 500, STRINGER 9L, CRACKED. REPAIRED FRAME PER SRM.SDR SWAA050432Stringer Clip · crackedDURING SPV, FOUND STRINGER CLIP AT BS 580, STRINGER 11R, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050412Shear Tie · crackedDURING SPV FOUND SHEAR TIE AT BS 540, STRINGER 10R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050411Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 360, BETWEEN STRINGERS 14R AND 15R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050308Stringer Clip · crackedDURING SPV, FOUND STRINGER CLIP CRACKED BETWEEN BS 360 FROM STRINGER 4L TO STRINGER 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050307Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAMES AT RT AND LT BS 188, LBL 33 AND RBL 33, CRACKED. REMOVED AND REPLACED FRAME SECTIONS PER SRM.SDR SWAA050281Floorbeam · crackedDURING SPV, FOUND 2 EACH CRACKS ON FLOORBEAM WEB BETWEEN BS 188 TO BS 196, AT LBL 30 AND RBL 30. REMOVED AND REPLACED WEB SECTIONS PER SRM.SDR SWAA050099Lamp · inoperativeDURING SPV, FOUND EMERGENCY EXIT BULLNOSE LIGHT AT ROW 6 ABC, INOP. RELAMPED LIGHT PER MM.SDR SWAA042948Adc · faultyF/O'S AIRSPEED IND, AND F/O`S ALTIMETER WARNING FLAGS IN VIEW. F/O`S AIR SPEED NEEDLE CYCLED 0 TO 360 TO 0, EVERY 2 MINUTES. DURING LAST 20 MINUTES OF FLIGHT F/A REPORTED BURNED ELECTRICAL SMELL IN CABIN. REMOVED AND REPLACED NR 2 ADC PER MM.SDR SWAA042480Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA042479Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 507, STRINGER 14R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042478Gate · crackedDURING SCHEDULED C2 CHECK, FOUND R2 DOOR AT LOWER AFT GATE, CRACKED. REMOVED AND REPLACED R2 DOOR PER MM.SDR SWAA042477Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 948, STRINGER 24R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041948Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 964, STRINGER 21L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041114Skin · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO BAY SKIN BETWEEN BEARSTRAP AND INTERCOSTAL LOWER FLANGE AT BS 844, RBL 17, CORRODED. REPAIRED SKIN PER EA.SDR SWAA041113Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND NLG W/W CEILING WEB AT LT AND RT BRAKE PAD AFT MOUNTS, CRACKED. REPAIRED NLG W/W CEILING WEB PER EA.SDR SWAA041096Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAMS AT BS 727D + 5, LBL 13, AND BS 774 TO BS 777, LBL 8, CORRODED. REPAIRED FLOORBEAMS PER EA.SDR SWAA041097Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND MLG W/W BEADED PRESSURE WEB AT BS 673, RBL 36, CRACKED. REPAIRED WEB PER SRM.SDR SWAA041083Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO FLOORBEAM AT BS 727D + 5, LBL 13, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA041074Floor Support · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO FLOOR SUPPORT AT BS 774 TO BS 777, LBL 8, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA041061Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER TIE CLIP AT BS 663, STRINGER 10R, CRACKED. REMOVED AND REPLACED STRINGER TIE CLIP PER SRM.SDR SWAA041060Floor Support · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM FROM, BS 727 + 10 TO BS 780, AT RBL 3, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA041034Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 500 + 2, STRINGER 12R, AND BS 500D + 18, STRINGER 12L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041029Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM AT LT BS 907 TO LT BS 927, CORRODED. REMOVED AND REPLACED CREASE BEAM SECTION PER EA.SDR SWAA041028Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 1016, STRINGER 7L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041027Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FRAME AT BS 500B, STRINGER 20L, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR SWAA041026Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 727B, STRINGER 25L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N342SW, cancelled Oct 26, 2017