N348SW, cancelled Jul 16, 2012
Service difficulty reports · 282
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 = 'N348SW' AND deregistration_id = 'N348SW-2012-07-16' 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 = 'N348SW' AND deregistration_id = 'N348SW-2012-07-16' 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 SWAA085909Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 28R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085908Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 28L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085730Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085661Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BETWEEN BS 415 TO BS 417, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA085353Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA084533Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 931, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA082395Door Frame · crackedDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR FWD FRAME CRACKED AT LOWER STOP FITTING. REMOVED AND REPLACED L1 DOOR PER MM.SDR SWAA082394Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA081900Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081651Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 981, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA081329Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA BS 390, STR 28R. REPAIRED SKIN PER EA.SDR SWAA081278Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 410, BL 0. REPAIRED SKIN PER EA AND SB.SDR SWAA081280Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 460, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081279Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 16L CRACKED BETWEEN BS 348 AND BS 360. REPAIRED STRINGER PER SRM.SDR SWAA080127Solenoid · faultyDIVERSION/DECLARED EMERGENCY. DURING CLIMBOUT OF TUS LANDING GEAR HANDLE WOULD NOT MOVE FROM THE UP POSITION TO THE OFF POSITION. REMOVED AND REPLACED GEAR HANDLE SOLENOID PER MM.SDR SWAA075922Window · arcedFLIGHT DECK R1 WINDOW ARCED. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA075350Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA075351Battery · inoperativeDURING SCHEDULED HC2 CHECK, LT FWD CABIN EMERGENCY EXIT LIGHTS WOULD NOT SHUT OFF WITH PILOT SWITCH. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA074648Skin · crackedFUSELAGE SKIN CRACKED AT BS 518, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA074675Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 930 AND BS 952, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA074674Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 518D, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA074374Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071898Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA071650Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RIGHT WING OUTBOARD T/E AFT FLAP DELAMINATED AT LOWER OUTBOARD END. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA071515Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RIGHT WING OUTBOARD T/E AFT FLAP DELAMINATED AT OUTBOARD END. REPAIRED FLAP PER SRM.SDR SWAA071402Lamp · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA071320Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 791, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA071299Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 791, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA070167Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 21 ABC. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA065077Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA064984Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA063998Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA063904Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 907 TO BS 927, STR 17L. REPAIRED WEB PER SWA EA.SDR SWAA063903Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 727B TO BS 727C, STR 17L. REPAIRED WEB PER SWA EA.SDR SWAA063800Duct · crackedDURING FLIGHT CREW REPORTED LARGE AMOUNTS OF INSULATION BLEW INTO MID CABIN. REMOVED AND REPLACED MAIN CABIN AIR CENTER DUCT PER MM.SDR SWAA063766Charger · inoperativeDURING SCHEDULED 18Y CHECK, FOUND LT OVERWING CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA063765Charger · inoperativeDURING SCHEDULED 18Y CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA063764Charger · inoperativeDURING SCHEDULED 18Y CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA063763Pressure Panel · corrodedDURING SCHEDULED 18Y CHECK, FOUND NLG W/W WEB CORRODED AT RT BS 243 TO BS 251, WL 171. REMOVED AND REPLACED NLG W/W WEB SECTION PER SWA EA.SDR SWAA063718Web · crackedDURING SCHEDULED 18Y CHECK, FOUND NLG W/W WEB CRACKED BETWEEN RT BS 243 AND RT BS 251, WL 174. REPAIRED WEB PER SWA EA.SDR SWAA063677Frame · corrodedDURING SCHEDULED 18Y CHECK, FOUND RT NLG W/W FRAMECORRODED, BS 243 TO BS 251. REPAIRED W/W FRAME PER SRM.SDR SWAA063659Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063658Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 13R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063657Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R AND STR 8L. REPAIRED FRAME SECTION PER ACO.SDR SWAA063656Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND LT WING NR 1 L/E SLAT CRACKED AT LOWER AUX TRACK CUTOUT SURFACE. REPAIRED NR 1 L/E SLAT PER SRM.SDR SWAA063650Connector · damagedDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EXIT SIGN BATTERY PACK HOUSING CONNECTOR PIN BENT. REMOVED AND REPLACED BATTERY PACK HOUSING PER MM.SDR SWAA063611Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063610Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063609Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063608Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME SECTION PER SWA EA.
Back to N348SW, cancelled Jul 16, 2012