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 SWAA106065Lens · out of positionDURING SCHEDULED SPV CHECK, FOUND RT EEPLS LENS OUT OF POSITION AT ROW 12. REPOSITIONED LENS PER MM.SDR SWAA105989Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED SPLICE PER SRM AND BAC DWG.SDR SWAA105496Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA105495Light · inoperativeDURING SCHEDULED HC2 CHECK, FOUND L EEPLS INOP AT ROW 7. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA104928Engine · failedAIR TURNBACK / IN-FLIGHT SHUTDOWN. RIGHT AFTER FLAP CLEAN-UP AT 1200 AGL NR 1 ENGINE ROLLED BACK TO 12.9N ON2 WITH ASSOCIATED ENGINE FAILURE LIGHTS. REMOVED AND REPLACED NR 1 ENGINE PER MM AND MT.SDR SWAA104184Spindle · crackedDURING SCHEDULED MV2 CHECK, FOUND RT WING NR 8 FLAP SPINDLE CRACKED. REMOVED AND REPLACED SPINDLE PER MM.SDR SWAA100411Lens · crackedL1 DOOR LOWER EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA100278Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA096931Flap · crackedDURING SCHEDULED MV2 CHECK, FOUND LT WING I/B TRAILING EDGE FLAP CRACKED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA095415Spoiler · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING NR 6 FLIGHT SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA095276Shutoff Valve · malfunctionedINFLIGHT SHUTDOWN / DECLARED EMERGENCY. FWD LOW PRESSURE LIGHT NR 1 MAIN FUEL TANK ON, FOLLOWED BY AFT LOW PRESSURE LIGHT, IN NR 1 MAIN. BOTH PUMPS TURNED OFF. FL 260, ENG RUNNING NORMAL THEN FLAMED OUT. WINDMILLING N1 & N2 NORMAL. REMOVED AND REPLACED SDR SWAA094935Failsafe · corrodedDURING SCHEDULED 12Y CHECK, FOUND AFT PIT FAIL-SAFE CHORD CORRODED AT BS 727E, BETWEEN STR 25R TO STR 26R. REPAIRED CHORD PER SRM.SDR SWAA094904Doubler · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE L1 DOOR INTERNAL DOUBLER CRACKED. REPAIRED SKIN PER AAR EA.SDR SWAA094903Rib · crackedDURING SCHEDULED 12Y CHECK, FOUND RT WING RIB CHORD CRACKED AT STA 135.5. REPAIRED CHORD PER ACO.SDR SWAA094902Skin · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE SKIN AT L1 DOOR CRACKED. REPAIRED SKIN PER AAR EA.SDR SWAA094901Panel · crackedDURING SCHEDULED 12Y CHECK, FOUND RT MLG WHEEL WELL AFT KEEL BEAM PANEL CRACKED. REPAIRED PANEL PER SRM.SDR SWAA094900Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 711, LBL 24.8. REPAIRED WEB PER AAR EA.SDR SWAA094858Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FWD CARGO BAY FRAME CORRODED AT BS 500C, BETWEEN LBL 5 TO RBL 5. REPAIRED FRAME PER AAR EA.SDR SWAA094857Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED FROM BS 706 TO BS 711, LBL 24.8. REPAIRED BEAM PER AAR EA.SDR SWAA094812Lens · brokenDURING SCHEDULED 12Y CHECK, FOUND FWD EMERGENCY EXIT SIGN LENS BROKEN. REMOVED AND REPLACED SIGN PER SRM.SDR SWAA094811Shear Tie · corrodedDURING SCHEDULED 12Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500D, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA094810Shear Tie · corrodedDURING SCHEDULED 12Y CHECK, FOUND SHEAR TIE CORRODED AT BS 807, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA094809Shear Tie · corrodedDURING SCHEDULED 12Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA094808Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND CENTER WING BOX LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 740A, BETWEEN LBL 43 TO LBL 45.5. REMOVED AND REPLACED BEAM PER EA.SDR SWAA094744Fitting · corrodedDURING SCHEDULED 12Y CHECK, FOUND VERTICAL STABILIZER AFT O/B DRAG ANGLE FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA094743Fitting · crackedDURING SCHEDULED 12Y CHECK, FOUND L1 DOOR LOWER HINGE CUTOUT FITTING CRACKED AT BS 304, WL 237. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA094682Stringer Clip · crackedDURING SCHEDULED 12Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4R. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA094681Stringer Clip · crackedDURING SCHEDULED 12Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 619, STR 4R. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA094680Stringer Clip · crackedDURING SCHEDULED 12Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 10R. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA094679Stringer Clip · crackedDURING SCHEDULED 12Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 2R. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA094678Stringer Clip · crackedDURING SCHEDULED 12Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 7R. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA094655Crease Beam · crackedDURING SCHEDULED 12Y CHECK, FOUND LT CREASE BEAM CRACKED BETWEEN BS 787 TO BS 807. REPAIRED BEAM PER SRM.SDR SWAA094632Stringer Clip · crackedDURING SCHEDULED 12Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094602Wedge · delaminatedDURING SCHEDULED 12Y CHECK, FOUND LT WING NR 3 SLAT WEDGE DELAMINATED. REPAIRED WEDGE PER MM.SDR SWAA085683Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED SLIDE PER MT.SDR SWAA084367Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED AT UPPER AND LOWER SURFACE. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081760Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER ACO.SDR SWAA081761Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER ACO.SDR SWAA081600Flap · brokenLEFT WING FOREFLAP MECHANISM PROTRUDING UNDER WING. REMOVED AND REPLACED FLAP PER MM.SDR SWAA080835Slat · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 2 L/E SLAT DELAMINATED AT OUTBOARD T/E. REPAIRED SLAT PER SRM.SDR SWAA073465Stringer Clip · crackedDURING SCHEDULED 10Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 28L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073464Skin · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 784, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA073430Shear Tie · corrodedDURING SCHEDULED 10Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073401Stringer · crackedDURING SCHEDULED 10Y CHECK, FOUND STRINGER 23R CRACKED AT BS 494. REPAIRED STRINGER PER SRM.SDR SWAA073403Fitting · crackedDURING SCHEDULED 10Y CHECK, FOUND L1 DOOR UPPER HINGE BOX FITTING CRACKED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA073404Fitting · looseDURING SCHEDULED 10Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA073402Skin · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, STR 28R. REPAIRED SKIN PER SWA EA.SDR SWAA073355Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND RIGHT MLG STABILIZER BEAM CORRODED. REMOVED AND REPLACED MLG BEAM PER MM.SDR SWAA073357Rib · crackedDURING SCHEDULED 10Y CHECK, FOUND VERTICAL STABILIZER RIB CRACKED AT STA 292.70. REMOVED AND REPLACED RIB PER SRM.SDR SWAA073354Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 291 TO BS 332, STR 17R. REPAIRED CREASE BEAM PER SRM.
Back to N650SW, cancelled Nov 6, 2017