N650SW, cancelled Nov 6, 2017
Service difficulty reports · 316
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 = 'N650SW' AND deregistration_id = 'N650SW-2017-11-06' 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 = 'N650SW' AND deregistration_id = 'N650SW-2017-11-06' 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 SWAA073356Skin · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE SKIN CORRODED AT RADIO ALTIMETER ANTENNA CUTOUT BS 439, STR 28R. REPAIRED SKIN PER ACO.SDR SWAA073332Ground Wire · brokenDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED GROUND WIRE W1460-062-20 PER WDM.SDR SWAA073333Rod End · corrodedDURING SCHEDULED SERVICE CHECK, FOUND AILERON ROD END CORRODED IN RT MLG W/W. REMOVED AND REPLACED ROD END PER MM.SDR SWAA073334Crease Beam · crackedDURING SCHEDULED SERVICE CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 295, RBL 60, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR SWAA073267Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073266Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073233Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073235Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073241Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073240Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073237Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073238Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073236Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073234Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073239Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073232Floorbeam · crackedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CRACKED AT BS 328, LBL 27. REPAIRED FLOORBEAM PER SRM.SDR SWAA073205Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L AND 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073180Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM CORRODED AT BETWEEN BS 312 AND BS 356, STR 17L. REPAIRED CREASE BEAM PER SRM.SDR SWAA073149Floorbeam · crackedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CRACKED AT BS 312, RBL 24. REPAIRED FLOORBEAM PER SRM.SDR SWAA072307Window · crackedAT CRUISE FLIGHT DECK L1 WINDOW ARCHED AND CRACKED. REMOVED AND REPLACED L1 WINDOW PER MM.SDR SWAA072194Spoiler · crackedDURING SCHEDULED MV1 CHECK, FOUND RT WING NR 3 FLIGHT SPOILER CRACKED AT AFT OUTBOARD END. R&R SPOILER PER MM.SDR SWAA072149Spoiler · crackedDURING SCHEDULED MV1 CHECK, FOUND RT WING #3 FLIGHT SPOILER CRACKED AT FWD INBOARD END. REPAIRED SPOILER PER SWA EA.SDR SWAA071155Bearing · wornDURING SCHEDULED C4 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED CONTROL ROD BEARING PER MM.SDR SWAA071154Flap · delaminatedDURING SCHEDULED C4 CHECK, FOUND LEFT WING OUTBOARD T/E FLAP DELAMINATED AT UPPER T/E SURFACE. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA064338Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA064337Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD LOWER SURFACE. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA061643Connector · looseDURING SCHEDULED A1 CHECK, FOUND AFT RT EMERGENCY EXIT BULL NOSE LIGHT INOP. RESECURED LIGHT CONNECTOR PER MM.SDR SWAA061513Bolt · wornDURING SCHEDULED C1 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT NR 1 HINGE BOLT PER MM.SDR SWAA061512Bolt · wornDURING SCHEDULED C1 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 HINGE BOLT PER MM.SDR SWAA061113Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA060258Light · looseEEPLS STRIP LOOSE AT FWD END. REMOVED AND REPLACED STRIP PER MM.SDR SWAA060216Light · wornDURING SCHEDULED C4 CHECK, FOUND EEPLS STRIP WORN AT ROW 11, LT SIDE. REMOVED AND REPLACED STRIP PER MM.SDR SWAA051452Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REPAIRED LIGHT ASSY PER MM.SDR SWAA050855Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY EMERGENCY BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA050522Battery · inoperativeDURING SCHEDULED A2 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA050373Slide · dislodgedR2 DOOR EVAC SLIDE FELL OUT, DID NOT DEPLOY. REINSTALLED R2 DOOR EVAC SLIDE PER MM.SDR SWAA050100Fitting · corrodedDURING SCHEDULED SERVICE CHECK, FOUND RT AND LT FWD OUTBOARD HANGER FITTINGS CORRODED. REPAIRED HANGER FITTINGS PER EA.SDR SWAA043675Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR AFT FRAME AT LOWER CORNER CRACKED. REPAIRED DOOR FRAME PER BAC DRAWING.SDR SWAA043674Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 907, BETWEEN STRINGER 25R AND STRINGER 26R, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA043673Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 767, STRINGER 27L, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA043672Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 772, FROM LBL 12 TO RBL 14, CORRODED. REPAIRED FLOORBEAM PER EA.SDR SWAA043653Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED PRESSURE WEB AT BS 665, LBL 31.5, CRACKED. REPAIRED PRESSURE WEB PER SRM.SDR SWAA043652Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FRAME AT BS 616, STRINGER 17R, CRACKED. REPAIRED FRAME SECTION PER EA.SDR SWAA043651Skin · separatedDURING SCHEDULED 1/4D CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP, SKIN SEPARATED. REPAIRED FLAP PER SRM.SDR SWAA042640Fitting · wornDURING SCHEDULED SERVICE CHECK, FOUND RT ELEVATOR TAB NR 1 HINGE FITTING WORN. REMOVED AND REPLACED TAB ASSEMBLY PER MM.SDR SWAA042165Slide · dislodgedR1 DOOR EVAC SLIDE FELL OUT. REINSTALLED AND SECURED R1 DOOR EVAC SLIDE PER MM.SDR SWAA041681Frame · crackedDURING SPV, FOUND BULKHEAD SIDE FRAME AT LT AND RT BS 178, WL 208, CRACKED. REMOVED AND REPLACED FRAME SECTIONS PER ACO.SDR SWAA041002Slide · dislodgedR1 DOOR EVAC SLIDE FELL OUT OF CONTAINER SLIDE DID NOT INFLATE. REINSTALLED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040180Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA032362Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND BOTH L1 AND R1 DOOR EVACUATION SLIDES OUT OF ADJUST. REPOSITIONED SLIDE ASSY'S PER MM.
Back to N650SW, cancelled Nov 6, 2017