N365SW, cancelled May 11, 2016
Service difficulty reports · 325
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 = 'N365SW' AND deregistration_id = 'N365SW-2016-05-11' 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 = 'N365SW' AND deregistration_id = 'N365SW-2016-05-11' 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 SWAA084453Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 3R. REPAIRED FRAME PER SRM.SDR SWAA084452Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, BETWEEN STR 2R AND STR 3R. REPAIRED FRAME PER SRM.SDR SWAA084417Pressure Panel · crackedDURING SCHEDULED 16Y CHECK, FOUND NLG WHEEL WELL LT CEILING PANEL CUTOUT WEB CRACKED. REPAIRED WEB PER SRM.SDR SWAA084416Pressure Panel · crackedDURING SCHEDULED 16Y CHECK, FOUND NLG WHEEL WELL RT CEILING PANEL CUTOUT WEB CRACKED. REPAIRED WEB PER SRM.SDR SWAA084405Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084404Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084403Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084402Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084401Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 288, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084384Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084383Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084382Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 288 STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084285Stiffener · crackedDURING SCHEDULED 16Y CHECK, FOUND VERTICAL STIFFENER CRACKED AT BS 727B, RBL 45.50, WL 208. REMOVED AND REPLACED STIFFENER PER SRM AND BOEING DRAWING.SDR SWAA084284Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084283Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084282Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084281Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084280Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084279Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084278Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084277Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084276Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084227Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 28L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084226Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 28L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084225Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA084214Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 986, LBL 45. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA084215Fitting · corrodedDURING SCHEDULE 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA084216Stringer Clip · crackedDURING SCHEDULE 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084180Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084181Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 22R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084147Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 22R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084146Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083793Strip · wornDURING SCHEDULE HC2 CHECK, FOUND EEPLS STRIP WORN AT 13C. CLEANED EEPLS STRIP PER MM.SDR SWAA083792Slide · out of adjustDURING SCHEDULE HC2 CHECK, FOUND L1 DOOR EVAC SLIDE OUT OF POSITION. ADJUSTED SLIDE ASSY PER MM.SDR SWAA081432Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 883, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA080352Lens · looseEEPLS LENS LOOSE AT ROW 1 ABC. SECURED LENS PER MM.SDR SWAA075497Battery · inoperativeDURING SCHEDULED MV2 CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA073450Door Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT LOWER FWD CORNER. REPAIRED FRAME PER SRM.SDR SWAA073406Bearing · wornDURING SCHEDULED 14Y CHECK, LEFT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED CONTROL ROD BUSHING AND TORQUE TUBE BEARING PER MM.SDR SWAA073405Bearing · wornDURING SCHEDULED 14Y CHECK, RIGHT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED CONTROL ROD BUSHING AND TORQUE TUBE BEARING PER MM.SDR SWAA073410Slide · out of adjustDURING SCHEDULED 14Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073407Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 26L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073411Fitting · looseDURING SCHEDULED 14Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA073409Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 847, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA073408Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 390, LBL 3.5. REPAIRED SKIN PER EA.SDR SWAA073351Tab · delaminatedDURING SCHEDULED 14Y CHECK, FOUND RIGHT ELEVATOR TAB DELAMINATED AT NR 1 HINGE CUTOUT. REPAIRED TAB PER SRM.SDR SWAA073350Rib · crackedDURING SCHEDULED 14Y CHECK, FOUND LEFT HORIZONTAL STAB RIB CRACKED AT STA 212.30. REMOVED AND REPLACED RIB PER SRM.SDR SWAA072127Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG WALKING BEAM OUTBOARD AFT STAB FITTING CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA072125Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LT MLG WALKING BEAM OUTBOARD FWD STAB FITTING CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA072126Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND RT MLG WALKING BEAM OUTBOARD FWD STAB FITTING CORRODED. REPAIRED FITTING PER SWA EA.
Back to N365SW, cancelled May 11, 2016